<link href="_content/Bit.Client.Web.BlazorUI/styles/bit.blazorui.min.css" rel="stylesheet" />

<script src="_content/Bit.Client.Web.BlazorUI/scripts/bit.blazorui.min.js"></script>  

@using Bit.Client.Web.BlazorUI

<BitButton>Hello!</BitButton>

<BitDatePicker SelectedDate="@BirthDate"></BitDatePicker>

CultureInfo.CurrentUICulture = new CultureInfo("fa-IR");

<BitDatePicker Culture="@(new System.Globalization.CultureInfo("en-US"))" />

var cultureInfo = CultureInfo.CreateSpecificCulture("fa-IR")

cultureInfo.DateTimeFormat.MonthNames = new[] { "فروردین", "اردیبهشت", "خرداد", "تیر", "مرداد", "شهریور", "مهر", "آبان", "آذر", "دی", "بهمن", "اسفند", "" };  

 public string GetHour(DateTime lastdate)
        {
            PersianCalendar pc = new PersianCalendar();
            string result = " ساعت " + (((pc.GetHour(lastdate)) < 10) ? ("0" + pc.GetHour(lastdate).ToString()) : (pc.GetHour(lastdate)).ToString()) + ":" + (((pc.GetMinute(lastdate)) < 10) ? ("0" + pc.GetMinute(lastdate).ToString()) : (pc.GetMinute(lastdate)).ToString());
            return result;
        }

public string getDay(DayOfWeek day)
        {
            string Result = "";
            switch (day)
            {
                case DayOfWeek.Friday:
                    Result = "جمعه";
                    break;
                case DayOfWeek.Monday:
                    Result = "دوشنبه";
                    break;
                case DayOfWeek.Saturday:
                    Result = "شنبه";
                    break;
                case DayOfWeek.Sunday:
                    Result = "یکشنبه";
                    break;
                case DayOfWeek.Thursday:
                    Result = "پنج شنبه";
                    break;
                case DayOfWeek.Tuesday:
                    Result = "سه شنبه";

                    break;
                case DayOfWeek.Wednesday:
                    Result = "چهارشنبه";
                    break;
                default:
                    break;
            }
            return Result;
        }

getDay(pc.GetDayOfWeek(LastDate))

public string GetMounth(int month)
        {
            string[] monthInYear = {"فروردین","اردیبهشت","خرداد","تیر","مرداد","شهریور","مهر","آبان","آذر","دی","بهمن","اسفند" };
            return monthInYear[month-1];
        }

private void btnGetDate_Click(object sender, EventArgs e)
        {
            DateTime LastDate = DateTime.Parse(txtLastDate.Text);
            TimeSpan ts = DateTime.Now - LastDate;
            PersianCalendar pc = new PersianCalendar();
            int DifferenceYear = DateTime.Now.Year - LastDate.Year;
            int DiffernceMounth = DateTime.Now.Month - LastDate.Month;
            if(DateTime.Now.Month>LastDate.Month)
                DiffernceMounth = DateTime.Now.Month - LastDate.Month; 
            else
            DiffernceMounth=LastDate.Month-DateTime.Now.Month;
            int DifferenceDays = ts.Days;

            StringBuilder Result = new System.Text.StringBuilder("");
           
            if(DifferenceYear>0)
            {
                Result.Append(DifferenceYear.ToString() + " سال پیش"+" ، "+getDay(pc.GetDayOfWeek(LastDate))+" "+pc.GetDayOfMonth(LastDate).ToString()+" " + GetMounth(pc.GetMonth(LastDate))+" " +pc.GetYear(LastDate)+GetHour(LastDate));
            }
            else if(DiffernceMounth>0)
            {
                Result.Append(DiffernceMounth.ToString() + " ماه پیش" + " ، " + getDay(pc.GetDayOfWeek(LastDate)) + " " + pc.GetDayOfMonth(LastDate).ToString() + " " + GetMounth(pc.GetMonth(LastDate)) + " " + pc.GetYear(LastDate) + GetHour(LastDate));
            }
            else if(DifferenceDays>0)
                Result.Append(DifferenceDays.ToString() + " روز پیش" + " ، " + getDay(pc.GetDayOfWeek(LastDate)) + " " + pc.GetDayOfMonth(LastDate).ToString() + " " + GetMounth(pc.GetMonth(LastDate)) + " " + pc.GetYear(LastDate) + GetHour(LastDate));
            else if(DifferenceDays==0)
                Result.Append(" امروز" + " ، " + getDay(pc.GetDayOfWeek(LastDate)) + " " + pc.GetDayOfMonth(LastDate).ToString() + " " + GetMounth(pc.GetMonth(LastDate)) + " " + pc.GetYear(LastDate) + GetHour(LastDate));

            lblResult.Text = Result.ToString();
        }

using System.Data;
using System.IO;
using OfficeOpenXml;
using OfficeOpenXml.Drawing.Chart;
using OfficeOpenXml.Style;
using OfficeOpenXml.Table;

namespace EPPlusTest
{
  class Program
  {
      static void Main(string[] args)
      {
          var newFile = new FileInfo("Test.xlsx");
          if (newFile.Exists)
          {
              newFile.Delete();
          }

          //ایجاد یک سری اطلاعات دلخواه
          var table = createDt();

          using (var package = new ExcelPackage(newFile))
          {
              // اضافه کردن یک ورک شیت جدید
              ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("مخارج");             

              //اضافه کردن یک جدول جدید از دیتاتیبل دریافتی
              worksheet.Cells["A1"].LoadFromDataTable(table, true, TableStyles.Dark9);

              //نمایش جمع ستون هزینه‌های ماه‌ها
              var tbl = worksheet.Tables[0];
              //زیر آخرین ردیف یک سطر اضافه می‌کند
              tbl.ShowTotal = true;
              //فرمول نحوه‌ی محاسبه جمع ستون انتساب داده می‌شود
              tbl.Columns[1].TotalsRowFunction = RowFunctions.Sum;

              //تعیین عرض ستون‌های جدول
              worksheet.Column(1).Width = 14;
              worksheet.Column(2).Width = 12;

              //تنظیم متن هدر
              worksheet.HeaderFooter.oddHeader.CenteredText = "مثالی از نحوه‌ی استفاده از ایی پی پلاس";              

              //می‌خواهیم سرستون‌ها در وسط ستون قرار گیرند
              worksheet.Cells["A1"].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
              worksheet.Cells["B1"].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;

              //افزودن یک نمودار جدید به شیت جاری
              var chart = worksheet.Drawings.AddChart("chart1", eChartType.Pie3D);
              chart.Title.Text = "نمودار هزینه‌های سال";
              chart.SetPosition(Row: 2, RowOffsetPixels: 5, Column: 3, ColumnOffsetPixels: 5);
              chart.SetSize(PixelWidth: 320, PixelHeight: 360);
              chart.Series.Add("B2:B13", "A2:A13");
              chart.Style = eChartStyle.Style26;

              //تنظیم یک سری خواص فایل نهایی
              package.Workbook.Properties.Title = "مثالی از ایی پی پلاس";
              package.Workbook.Properties.Author = "وحید";
              package.Workbook.Properties.Subject = "ایجاد فایل اکسل بدون نرم افزار اکسل";

              //تنظیم نحوه‌ی نمایش فایل زمانیکه در نرم افزار اکسل گشوده می‌شود
              worksheet.View.PageLayoutView = true;
              worksheet.View.RightToLeft = true;

              // ذخیر سازی کلیه موارد اعمالی در فایل
              package.Save();
          }
      }

      private static DataTable createDt()
      {
          var table = new DataTable("مخارج");
          table.Columns.Add("ماه", typeof(string));
          table.Columns.Add("هزینه", typeof(decimal));

          table.Rows.Add("فروردین", 100);
          table.Rows.Add("اردیبهشت", 250);
          table.Rows.Add("خرداد", 80);
          table.Rows.Add("تیر", 300);
          table.Rows.Add("مرداد", 200);
          table.Rows.Add("شهریور", 150);
          table.Rows.Add("مهر", 250);
          table.Rows.Add("آبان", 200);
          table.Rows.Add("آذر", 400);
          table.Rows.Add("دی", 100);
          table.Rows.Add("بهمن", 130);
          table.Rows.Add("اسفند", 80);
          return table;
      }
  }
}

//ok( truthy [, message ] )

test( "ok test", function() {
  ok( true, "true succeeds" );
  ok( "non-empty", "non-empty string succeeds" );
 
  ok( false, "false fails" );
  ok( 0, "0 fails" );
  ok( NaN, "NaN fails" );
  ok( "", "empty string fails" );
  ok( null, "null fails" );
  ok( undefined, "undefined fails" );
});

function KeyLogger( target ) {
  if ( !(this instanceof KeyLogger) ) {
    return new KeyLogger( target );
  }
  this.target = target;
  this.log = [];
 
  var self = this;
 
  this.target.off( "keydown" ).on( "keydown", function( event ) {
    self.log.push( event.keyCode );
  });
}

test( "keylogger api behavior", function() {
 
  var event,
      $doc = $( document ),
      keys = KeyLogger( $doc );
 
  // trigger event
  event = $.Event( "keydown" );
  event.keyCode = 9;
  $doc.trigger( event );
 
  // verify expected behavior
  equal( keys.log.length, 1, "a key was logged" );
  equal( keys.log[ 0 ], 9, "correct key was logged" );
 
});

public interface IHasRowIntegrity
{
    string Hash { get; set; }
}

internal sealed class RowIntegrityHook : PostActionHook<IHasRowIntegrity>
{
    public override string Name => HookNames.RowIntegrity;
    public override int Order => int.MaxValue;
    public override EntityState HookState => EntityState.Unchanged;

    protected override void Hook(IHasRowIntegrity entity, HookEntityMetadata metadata, IUnitOfWork uow)
    {
        metadata.Entry.Property(EFCore.Hash).CurrentValue = uow.EntityHash(entity);
    }
}

//DbContextCore : IUnitOfWork

public string EntityHash<TEntity>(TEntity entity) where TEntity : class
{
    var row = Entry(entity).ToDictionary(p => p.Metadata.Name != EFCore.Hash &&
                                              !p.Metadata.ValueGenerated.HasFlag(ValueGenerated.OnUpdate) &&
                                              !p.Metadata.IsShadowProperty());
    return EntityHash<TEntity>(row);
}

protected virtual string EntityHash<TEntity>(Dictionary<string, object> row) where TEntity : class
{
    var json = JsonConvert.SerializeObject(row, Formatting.Indented);
    using (var hashAlgorithm = SHA256.Create())
    {
        var byteValue = Encoding.UTF8.GetBytes(json);
        var byteHash = hashAlgorithm.ComputeHash(byteValue);
        return Convert.ToBase64String(byteHash);
    }
}

services.AddEFCore<ProjectDbContext>()
    .WithTrackingHook<long>()
    .WithDeletedEntityHook()
    .WithRowLevelSecurityHook<long>()
    .WithRowIntegrityHook()
    .WithNumberingHook(options =>
    {
        options.NumberedEntityMap[typeof(Task)] = new NumberedEntityOption
        {
            Prefix = "Task",
            FieldNames = new[] {nameof(Task.BranchId)}
        };
    });

<appSettings>
   <add key="nhibernate-logger"
             value="NHibernate.Logging.CommonLogging.CommonLoggingLoggerFactory, Hibernate.Logging.CommonLogging"/>
</appSettings>

<configuration>
 <system.net>
  <settings>
   <httpWebRequest useUnsafeHeaderParsing="true" />
  </settings>
 </system.net>
</configuration>