public static VMEditAttendanceDateWise GetAttendanceAttributesDateWise(List <Att_DailyAttendance> dailyAttendance, DateTime dtTo, string Criteria, int CriteriaData) { VMEditAttendanceDateWise entries = new VMEditAttendanceDateWise(); List <EditAttendanceListDateWise> list = new List <EditAttendanceListDateWise>(); foreach (var item in dailyAttendance) { EditAttendanceListDateWise eal = new EditAttendanceListDateWise(); eal.EmployeeID = (int)item.EmpID; eal.EmpNo = item.EmpNo; eal.EmpName = item.HR_Employee.FullName; eal.Date = item.AttDate.Value.ToString("dd-MMM-yyyy"); eal.DutyTime = item.DutyTime.Value.Hours.ToString("00") + item.DutyTime.Value.Minutes.ToString("00"); eal.EmpDate = item.EmpDate; eal.DutyCode = item.DutyCode; eal.Remarks = item.Remarks; TimeSpan shiftTime = new TimeSpan(0, (int)item.ShifMin, 0); eal.ShiftTime = shiftTime.Hours.ToString("00") + shiftTime.Minutes.ToString("00"); if (item.TimeIn != null) { eal.TimeIn = item.TimeIn.Value.TimeOfDay.Hours.ToString("00") + item.TimeIn.Value.TimeOfDay.Minutes.ToString("00"); } if (item.TimeOut != null) { eal.TimeOut = item.TimeOut.Value.TimeOfDay.Hours.ToString("00") + item.TimeOut.Value.TimeOfDay.Minutes.ToString("00"); } if (item.WorkMin > 0) { TimeSpan WorkTime = new TimeSpan(0, (int)item.WorkMin, 0); eal.WorkMinutes = WorkTime.Hours.ToString("00") + ":" + WorkTime.Minutes.ToString("00"); } else { eal.WorkMinutes = "0000"; } if (item.DutyCode == "G") { if (item.GZOTMin > 0) { TimeSpan GZTime = new TimeSpan(0, (int)item.GZOTMin, 0); eal.OTMin = GZTime.Hours.ToString("00") + ":" + GZTime.Minutes.ToString("00"); } else { eal.OTMin = "0000"; } } else { if (item.NOTMin > 0) { TimeSpan OTTime = new TimeSpan(0, (int)item.NOTMin, 0); eal.OTMin = OTTime.Hours.ToString("00") + ":" + OTTime.Minutes.ToString("00"); } else { eal.OTMin = "00:00"; } } if (item.Tin0 != null) { eal.TimeIn1 = item.Tin0.Value.TimeOfDay.Hours.ToString("00") + item.Tin0.Value.TimeOfDay.Minutes.ToString("00"); } if (item.Tin1 != null) { eal.TimeIn2 = item.Tin1.Value.TimeOfDay.Hours.ToString("00") + item.Tin1.Value.TimeOfDay.Minutes.ToString("00"); } if (item.Tin2 != null) { eal.TimeIn3 = item.Tin2.Value.TimeOfDay.Hours.ToString("00") + item.Tin2.Value.TimeOfDay.Minutes.ToString("00"); } if (item.Tout0 != null) { eal.TimeOut1 = item.Tout0.Value.TimeOfDay.Hours.ToString("00") + item.Tout0.Value.TimeOfDay.Minutes.ToString("00"); } if (item.Tout1 != null) { eal.TimeOut2 = item.Tout1.Value.TimeOfDay.Hours.ToString("00") + item.Tout1.Value.TimeOfDay.Minutes.ToString("00"); } if (item.Tout2 != null) { eal.TimeOut3 = item.Tout2.Value.TimeOfDay.Hours.ToString("00") + item.Tout2.Value.TimeOfDay.Minutes.ToString("00"); } list.Add(eal); } entries.list = list; entries.Count = list.Count; entries.Criteria = Criteria; entries.CriteriaData = CriteriaData; entries.Date = dtTo.ToString("dd-MMM-yyyy"); return(entries); }
public static AttEditSingleEmployee GetAttendanceAttributes(List <Att_DailyAttendance> dailyAttendance, DateTime dtFrom, DateTime dtTo) { AttEditSingleEmployee entries = new AttEditSingleEmployee(); entries.EmployeeID = (int)dailyAttendance.FirstOrDefault().EmpID; entries.EmpNo = dailyAttendance.FirstOrDefault().EmpNo; entries.EmpName = dailyAttendance.FirstOrDefault().HR_Employee.FullName; entries.DateFrom = dtFrom.ToString("dd-MMM-yyyy"); entries.DateTo = dtTo.ToString("dd-MMM-yyyy"); List <EditAttendanceListDateWise> list = new List <EditAttendanceListDateWise>(); foreach (var item in dailyAttendance) { EditAttendanceListDateWise eal = new EditAttendanceListDateWise(); eal.Date = item.AttDate.Value.ToString("dd-MMM-yyyy"); eal.EmployeeID = (int)item.EmpID; eal.EmpNo = item.EmpNo; eal.Date = item.AttDate.Value.ToString("dd-MMM-yyyy"); eal.DutyTime = item.DutyTime.Value.Hours.ToString("00") + item.DutyTime.Value.Minutes.ToString("00"); eal.EmpDate = item.EmpDate; eal.DutyCode = item.DutyCode; if (item.Remarks == null) { eal.Remarks = ""; } else { eal.Remarks = item.Remarks; } TimeSpan shiftTime = new TimeSpan(0, (int)item.ShifMin, 0); eal.ShiftTime = shiftTime.Hours.ToString("00") + shiftTime.Minutes.ToString("00"); if (item.TimeIn != null) { eal.TimeIn = item.TimeIn.Value.TimeOfDay.Hours.ToString("00") + item.TimeIn.Value.TimeOfDay.Minutes.ToString("00"); } else { eal.TimeIn = ""; } if (item.TimeOut != null) { eal.TimeOut = item.TimeOut.Value.TimeOfDay.Hours.ToString("00") + item.TimeOut.Value.TimeOfDay.Minutes.ToString("00"); } else { eal.TimeOut = ""; } if (item.WorkMin > 0) { TimeSpan WorkTime = new TimeSpan(0, (int)item.WorkMin, 0); eal.WorkMinutes = WorkTime.Hours.ToString("00") + ":" + WorkTime.Minutes.ToString("00"); } else { eal.WorkMinutes = ""; } if (item.DutyCode == "G") { if (item.GZOTMin > 0) { TimeSpan GZTime = new TimeSpan(0, (int)item.GZOTMin, 0); eal.OTMin = GZTime.Hours.ToString("00") + ":" + GZTime.Minutes.ToString("00"); } else { eal.OTMin = "0000"; } } else { if (item.NOTMin > 0) { TimeSpan OTTime = new TimeSpan(0, (int)item.NOTMin, 0); eal.OTMin = OTTime.Hours.ToString("00") + ":" + OTTime.Minutes.ToString("00"); } else { eal.OTMin = "00:00"; } } if (item.Tin0 != null) { eal.TimeIn1 = item.Tin0.Value.TimeOfDay.Hours.ToString("00") + item.Tin0.Value.TimeOfDay.Minutes.ToString("00"); } else { eal.TimeIn1 = ""; } if (item.Tin1 != null) { eal.TimeIn2 = item.Tin1.Value.TimeOfDay.Hours.ToString("00") + item.Tin1.Value.TimeOfDay.Minutes.ToString("00"); } else { eal.TimeIn2 = ""; } if (item.Tin2 != null) { eal.TimeIn3 = item.Tin2.Value.TimeOfDay.Hours.ToString("00") + item.Tin2.Value.TimeOfDay.Minutes.ToString("00"); } else { eal.TimeIn3 = ""; } if (item.Tout0 != null) { eal.TimeOut1 = item.Tout0.Value.TimeOfDay.Hours.ToString("00") + item.Tout0.Value.TimeOfDay.Minutes.ToString("00"); } else { eal.TimeOut1 = ""; } if (item.Tout1 != null) { eal.TimeOut2 = item.Tout1.Value.TimeOfDay.Hours.ToString("00") + item.Tout1.Value.TimeOfDay.Minutes.ToString("00"); } else { eal.TimeOut2 = ""; } if (item.Tout2 != null) { eal.TimeOut3 = item.Tout2.Value.TimeOfDay.Hours.ToString("00") + item.Tout2.Value.TimeOfDay.Minutes.ToString("00"); } else { eal.TimeOut3 = ""; } list.Add(eal); } entries.list = list; return(entries); }