private static EmpMonthlyProductivityEntity DecompressActualAndExpectedMinForRDLC(EmpMonthlyProductivityEntity mp, List <ActualExpected> Mins) { int count = 0; foreach (ActualExpected mins in Mins) { switch (count) { case 0: mp.AW1 = mins.actual; mp.EW1 = mins.expected; break; case 1: mp.AW2 = mins.actual; mp.EW2 = mins.expected; break; case 2: mp.AW3 = mins.actual; mp.EW3 = mins.expected; break; case 3: mp.AW4 = mins.actual; mp.EW4 = mins.expected; break; case 4: mp.AW5 = mins.actual; mp.EW5 = mins.expected; break; case 5: mp.AW6 = mins.actual; mp.EW6 = mins.expected; break; case 6: mp.AW7 = mins.actual; mp.EW7 = mins.expected; break; case 7: mp.AW8 = mins.actual; mp.EW8 = mins.expected; break; case 8: mp.AW9 = mins.actual; mp.EW9 = mins.expected; break; case 9: mp.AW10 = mins.actual; mp.EW10 = mins.expected; break; case 10: mp.AW11 = mins.actual; mp.EW11 = mins.expected; break; case 11: mp.AW12 = mins.actual; mp.EW12 = mins.expected; break; case 12: mp.AW13 = mins.actual; mp.EW13 = mins.expected; break; case 13: mp.AW14 = mins.actual; mp.EW14 = mins.expected; break; case 14: mp.AW15 = mins.actual; mp.EW15 = mins.expected; break; case 15: mp.AW16 = mins.actual; mp.EW16 = mins.expected; break; case 16: mp.AW17 = mins.actual; mp.EW17 = mins.expected; break; case 17: mp.AW18 = mins.actual; mp.EW18 = mins.expected; break; case 18: mp.AW19 = mins.actual; mp.EW19 = mins.expected; break; case 19: mp.AW20 = mins.actual; mp.EW20 = mins.expected; break; case 20: mp.AW21 = mins.actual; mp.EW21 = mins.expected; break; case 21: mp.AW22 = mins.actual; mp.EW22 = mins.expected; break; case 22: mp.AW23 = mins.actual; mp.EW23 = mins.expected; break; case 23: mp.AW24 = mins.actual; mp.EW24 = mins.expected; break; case 24: mp.AW25 = mins.actual; mp.EW25 = mins.expected; break; case 25: mp.AW26 = mins.actual; mp.EW26 = mins.expected; break; case 26: mp.AW27 = mins.actual; mp.EW27 = mins.expected; break; case 27: mp.AW28 = mins.actual; mp.EW28 = mins.expected; break; case 28: mp.AW29 = mins.actual; mp.EW29 = mins.expected; break; case 29: mp.AW30 = mins.actual; mp.EW30 = mins.expected; break; case 30: mp.AW31 = mins.actual; mp.EW31 = mins.expected; break; } count++; } return(mp); }
private static EmpMonthlyProductivityEntity DecompressActualAndExpectedMinForRDLC(EmpMonthlyProductivityEntity mp, List<ActualExpected> Mins) { int count = 0; foreach (ActualExpected mins in Mins) { switch (count) { case 0: mp.AW1 = mins.actual; mp.EW1 = mins.expected; break; case 1: mp.AW2 = mins.actual; mp.EW2 = mins.expected; break; case 2: mp.AW3 = mins.actual; mp.EW3 = mins.expected; break; case 3: mp.AW4 = mins.actual; mp.EW4 = mins.expected; break; case 4: mp.AW5 = mins.actual; mp.EW5 = mins.expected; break; case 5: mp.AW6 = mins.actual; mp.EW6 = mins.expected; break; case 6: mp.AW7 = mins.actual; mp.EW7 = mins.expected; break; case 7: mp.AW8 = mins.actual; mp.EW8 = mins.expected; break; case 8: mp.AW9 = mins.actual; mp.EW9= mins.expected; break; case 9: mp.AW10 = mins.actual; mp.EW10 = mins.expected; break; case 10: mp.AW11 = mins.actual; mp.EW11 = mins.expected; break; case 11: mp.AW12 = mins.actual; mp.EW12 = mins.expected; break; case 12: mp.AW13 = mins.actual; mp.EW13 = mins.expected; break; case 13: mp.AW14 = mins.actual; mp.EW14 = mins.expected; break; case 14: mp.AW15 = mins.actual; mp.EW15 = mins.expected; break; case 15: mp.AW16 = mins.actual; mp.EW16 = mins.expected; break; case 16: mp.AW17 = mins.actual; mp.EW17= mins.expected; break; case 17: mp.AW18 = mins.actual; mp.EW18 = mins.expected; break; case 18: mp.AW19 = mins.actual; mp.EW19 = mins.expected; break; case 19: mp.AW20 = mins.actual; mp.EW20 = mins.expected; break; case 20: mp.AW21 = mins.actual; mp.EW21 = mins.expected; break; case 21: mp.AW22 = mins.actual; mp.EW22 = mins.expected; break; case 22: mp.AW23 = mins.actual; mp.EW23 = mins.expected; break; case 23: mp.AW24 = mins.actual; mp.EW24 = mins.expected; break; case 24: mp.AW25 = mins.actual; mp.EW25 = mins.expected; break; case 25: mp.AW26 = mins.actual; mp.EW26 = mins.expected; break; case 26: mp.AW27 = mins.actual; mp.EW27 = mins.expected; break; case 27: mp.AW28 = mins.actual; mp.EW28 = mins.expected; break; case 28: mp.AW29 = mins.actual; mp.EW29 = mins.expected; break; case 29: mp.AW30 = mins.actual; mp.EW30 = mins.expected; break; case 30: mp.AW31 = mins.actual; mp.EW31 = mins.expected; break; } count++; } return mp; }
public static List <EmpMonthlyProductivityEntity> ProcessAttendence(List <ViewAttData> finalOutput, string _dateFrom, string _dateTo) { TAS2013Entities db = new TAS2013Entities(); List <EmpMonthlyProductivityEntity> listOfEmps = new List <EmpMonthlyProductivityEntity>(); var result = finalOutput.OrderBy(m => m.EmpName).Select(m => m.EmpID).Distinct(); foreach (var emp in result) { EmpMonthlyProductivityEntity mp = new EmpMonthlyProductivityEntity(); Emp employee = db.Emps.Where(aa => aa.EmpID == emp).FirstOrDefault(); mp.EmpName = employee.EmpName; mp.Designation = employee.Designation.DesignationName; mp.EmpNo = employee.EmpNo; mp.Company = employee.Company.CompName; mp.SectionName = employee.Section.SectionName; mp.TotalActualWork = 0; mp.TotalExpectedWork = 0; List <ActualExpected> Mins = new List <ActualExpected>(); Boolean found = false; DateTime from = Convert.ToDateTime(_dateFrom); DateTime to = Convert.ToDateTime(_dateTo); while (from <= to) { foreach (ViewAttData att in finalOutput) { if (att.EmpID == emp && att.AttDate == from) { found = true; from = from.AddDays(1); ActualExpected ae = new ActualExpected(); if (att.WorkMin != null) { ae.actual = (double)att.WorkMin; mp.TotalActualWork = mp.TotalActualWork + ae.actual; } else { ae.actual = 0.0; } if (att.ShifMin != null || att.StatusDO == false || att.StatusGZ == false) { ae.expected = (double)att.ShifMin; mp.TotalExpectedWork = mp.TotalExpectedWork + ae.expected; } else { ae.expected = 0.0; } Mins.Add(ae); break; } } if (!found) { from = from.AddDays(1); } else { found = false; } } mp = DecompressActualAndExpectedMinForRDLC(mp, Mins); listOfEmps.Add(mp); } return(listOfEmps); }
public static List<EmpMonthlyProductivityEntity> ProcessAttendence(List<ViewAttData> finalOutput, string _dateFrom, string _dateTo) { TAS2013Entities db = new TAS2013Entities(); List<EmpMonthlyProductivityEntity> listOfEmps = new List<EmpMonthlyProductivityEntity>(); var result = finalOutput.OrderBy(m => m.EmpName ).Select(m => m.EmpID).Distinct(); foreach (var emp in result) { EmpMonthlyProductivityEntity mp = new EmpMonthlyProductivityEntity(); Emp employee = db.Emps.Where(aa => aa.EmpID == emp).FirstOrDefault(); mp.EmpName = employee.EmpName; mp.Designation =employee.Designation.DesignationName; mp.EmpNo = employee.EmpNo; mp.Company = employee.Company.CompName; mp.SectionName =employee.Section.SectionName; mp.TotalActualWork = 0; mp.TotalExpectedWork = 0; List<ActualExpected> Mins = new List<ActualExpected>(); Boolean found = false; DateTime from = Convert.ToDateTime(_dateFrom); DateTime to = Convert.ToDateTime(_dateTo); while (from <= to) { foreach (ViewAttData att in finalOutput) { if (att.EmpID == emp && att.AttDate == from) { found = true; from = from.AddDays(1); ActualExpected ae = new ActualExpected(); if (att.WorkMin != null) { ae.actual = (double)att.WorkMin; mp.TotalActualWork = mp.TotalActualWork + ae.actual; } else ae.actual = 0.0; if (att.ShifMin != null || att.StatusDO == false || att.StatusGZ == false) { ae.expected = (double)att.ShifMin; mp.TotalExpectedWork = mp.TotalExpectedWork + ae.expected; } else ae.expected = 0.0; Mins.Add(ae); break; } } if (!found) { from = from.AddDays(1); } else { found = false; } } mp = DecompressActualAndExpectedMinForRDLC(mp, Mins); listOfEmps.Add(mp); } return listOfEmps; }