private VMEditAttendanceDateWise GetAttendanceAttributesDateWise(List <VAT_DailyAttendance> dailyAttendance, DateTime dtTo, string Criteria, int CriteriaData) { VMEditAttendanceDateWise entries = new VMEditAttendanceDateWise(); List <EditAttendanceListDateWise> list = new List <EditAttendanceListDateWise>(); int i = 1; foreach (var item in dailyAttendance) { EditAttendanceListDateWise eal = new EditAttendanceListDateWise(); eal.EmployeeID = (int)item.EmpID; eal.No = i; i++; eal.EmpNo = item.OEmpID; eal.EmpName = item.EmployeeName; 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.SystemRemarks = 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") { string OT = ""; if (item.GZOTMin > 0) { TimeSpan GZTime = new TimeSpan(0, (int)item.GZOTMin, 0); OT = GZTime.Hours.ToString("00") + ":" + GZTime.Minutes.ToString("00"); } if (item.ExtraMin > 0) { TimeSpan ExtraMin = new TimeSpan(0, (int)item.ExtraMin, 0); OT = ExtraMin.Hours.ToString("00") + ":" + ExtraMin.Minutes.ToString("00"); } eal.OTMin = OT; } else { string OT = ""; if (item.OTMin > 0) { TimeSpan OTTime = new TimeSpan(0, (int)item.OTMin, 0); OT = OTTime.Hours.ToString("00") + ":" + OTTime.Minutes.ToString("00"); } if (item.ExtraMin > 0) { TimeSpan ExtraMin = new TimeSpan(0, (int)item.ExtraMin, 0); OT = ExtraMin.Hours.ToString("00") + ":" + ExtraMin.Minutes.ToString("00"); } eal.OTMin = OT; } if (item.ApprovedOT > 0) { TimeSpan ot = new TimeSpan(0, (int)item.ApprovedOT, 0); eal.ApprovedOTMin = ot.Hours.ToString("00") + ot.Minutes.ToString("00"); } if (item.ApprovedDoubleOT > 0) { TimeSpan ot = new TimeSpan(0, (int)item.ApprovedDoubleOT, 0); eal.ApprovedOTMin = ot.Hours.ToString("00") + ot.Minutes.ToString("00"); } if (item.ApprovedCPL > 0) { TimeSpan ot = new TimeSpan(0, (int)item.ApprovedCPL, 0); eal.ApprovedOTMin = ot.Hours.ToString("00") + ot.Minutes.ToString("00"); } list.Add(eal); } entries.list = list.OrderBy(aa => aa.EmpName).ToList(); entries.Count = list.Count; entries.Criteria = Criteria; entries.CriteriaData = CriteriaData; entries.Date = dtTo.ToString("dd-MMM-yyyy"); return(entries); }
public AttEditSingleEmployee GetAttendanceAttributes(List <DailyAttendance> dailyAttendance, DateTime dtFrom, DateTime dtTo, int empID) { AttEditSingleEmployee entries = new AttEditSingleEmployee(); Expression <Func <DailyAttendance, bool> > SpecificEntries = c => c.EmpID == empID && c.AttDate >= dtFrom && c.AttDate <= dtTo; dailyAttendance = DailyAttendanceRepo.FindBy(SpecificEntries); if (dailyAttendance.Count() > 0) { entries.EmployeeID = (int)dailyAttendance.FirstOrDefault().EmpID; entries.EmpNo = dailyAttendance.FirstOrDefault().EmpNo; entries.EmpName = dailyAttendance.FirstOrDefault().Employee.EmployeeName; entries.DateFrom = dtFrom.ToString("dd-MMM-yyyy"); entries.DateTo = dtTo.ToString("dd-MMM-yyyy"); entries.OUName = dailyAttendance.FirstOrDefault().Employee.OrganizationalUnit.OUName; entries.JobTitleName = dailyAttendance.FirstOrDefault().Employee.JobTitle.JobTitleName; List <EditAttendanceListDateWise> list = new List <EditAttendanceListDateWise>(); int i = 1; foreach (var item in dailyAttendance.OrderBy(aa => aa.AttDate)) { EditAttendanceListDateWise eal = new EditAttendanceListDateWise(); eal.EmployeeID = (int)item.EmpID; eal.EmpNo = item.EmpNo; eal.No = i; i++; 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.SystemRemarks = ""; } else { eal.SystemRemarks = 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") { string OT = ""; if (item.GZOTMin > 0) { TimeSpan GZTime = new TimeSpan(0, (int)item.GZOTMin, 0); OT = GZTime.Hours.ToString("00") + ":" + GZTime.Minutes.ToString("00"); } if (item.ExtraMin > 0) { TimeSpan ExtraMin = new TimeSpan(0, (int)item.ExtraMin, 0); OT = ExtraMin.Hours.ToString("00") + ":" + ExtraMin.Minutes.ToString("00"); } eal.OTMin = OT; } else { string OT = ""; if (item.OTMin > 0) { TimeSpan OTTime = new TimeSpan(0, (int)item.OTMin, 0); OT = OTTime.Hours.ToString("00") + ":" + OTTime.Minutes.ToString("00"); } if (item.ExtraMin > 0) { TimeSpan ExtraMin = new TimeSpan(0, (int)item.ExtraMin, 0); OT = ExtraMin.Hours.ToString("00") + ":" + ExtraMin.Minutes.ToString("00"); } eal.OTMin = OT; } if (item.ApprovedOT > 0) { TimeSpan ot = new TimeSpan(0, (int)item.ApprovedOT, 0); eal.ApprovedOTMin = ot.Hours.ToString("00") + ot.Minutes.ToString("00"); } if (item.ApprovedDoubleOT > 0) { TimeSpan ot = new TimeSpan(0, (int)item.ApprovedDoubleOT, 0); eal.ApprovedOTMin = ot.Hours.ToString("00") + ot.Minutes.ToString("00"); } if (item.ApprovedCPL > 0) { TimeSpan ot = new TimeSpan(0, (int)item.ApprovedCPL, 0); eal.ApprovedOTMin = ot.Hours.ToString("00") + ot.Minutes.ToString("00"); } list.Add(eal); } entries.list = list; } return(entries); }