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