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);
}
}
