private IDataTable GetAllPersonnelTotalSummaryTimesheetDataTable (List <BiometryCalculatedDetail> summaries, bool withform) { var res = new DynaDataTable() { RecordsList = summaries.Cast <dynamic>().ToList(), Headers = new Dictionary <string, string> { { "Id", "شماره پرسنلی" }, { "PersonnelName", "نام پرسنل" }, { "TotalStr", "کل ساعت حظور" }, { "TotalAbsenceStr", "کسری کار وغیبت" }, { "TotalOvertimeStr", "اضافه کاری" }, { "InValidStr", "غیر مجاز" }, { "ShiftWorkStr", "نوبت کاری" }, { "NightWorkStr", "شب کاری" }, { "MissionWorkStr", "ماموریت" }, { "HolidayWorkStr", "تعطیل کاری" }, { "VacationStr", "مرخصی" }, { "TotalValidStr", "کارکرد موظف" }, } }; SetDynamicTableViewDataHelper(res, formActionName: "GetAllPersonnelTotalSummaryTimesheet", withform: withform); return(res); }
public override IDataTable GetDataTable(ObligatedRange p) { using (var db = new EngineContext()) { var dict = new Dictionary <string, string> { { "Id", "کد" }, { "Name", "نام" }, { "OffDay", "روز تعطیلی" }, }; var dt = db.ObligatedRanges.ToList(); var list = dt.Select(s => new { Id = s.Id, Name = s.Name, OffDay = EngineUtility.GetTranslate(s.OffDay) } ).Cast <dynamic>().ToList(); var dyna = new DynaDataTable { Headers = dict, RecordsList = list }; return(dyna); } }
public override IDataTable GetDataTable(BiometricRawData p) { using (var db = new EngineContext()) { var dict = new Dictionary <string, string> { { "Id", "کد" }, { "Date", "تاریخ" }, { "Time", "زمان" }, { "Type", "نوع" }, { "UserId", "پرسنل" }, }; var dt = db.BiometricRawDatas.Where(b => b.IsManual).Include(d => d.PersonnelMachine) .Include(d => d.PersonnelMachine.Personnel).ToList(); PersianCalendar pc = new PersianCalendar(); var list = dt.Select(s => new { Id = s.Id, Name = s.Name, Date = s.Date.HasValue ? $@"{pc.GetYear(s.Date.Value)}/{pc.GetMonth(s.Date.Value)}/{pc.GetDayOfMonth(s.Date.Value)}" : "-", Time = s.Time.HasValue ? $@"{s.Time.Value.Hour}:{s.Time.Value.Minute}" : "-", Type = s.Type == BiometricDataType.In ? "ورود" : "خروج", PersonnelMachineId = s.PersonnelMachineId, UserId = s.PersonnelMachine?.Personnel?.Name + " " + s.PersonnelMachine?.Personnel?.LastName } ).Cast <dynamic>().ToList(); var dyna = new DynaDataTable { Headers = dict, RecordsList = list }; return(dyna); } }