public AttMnDataPer processPermanentMonthlyAttSingle(DateTime startDate, DateTime endDate, EmpView _Emp, List<AttData> _EmpAttData)
{
//Get Attendance data of employee according to selected month
_attMonth = new AttMnDataPer();
try
{
EmpAttData = _EmpAttData;
}
catch (Exception ex)
{
}
string EmpMonth = _Emp.EmpID + endDate.Date.Month.ToString();
//Check for already processed data
_attMonth.StartDate = startDate;
_attMonth.EndDate = endDate;
_attMonth.PreDays = 0;
_attMonth.WorkDays = 0;
_attMonth.AbDays = 0;
_attMonth.LeaveDays = 0;
_attMonth.OfficialDutyDays = 0;
_attMonth.ExpectedWrkTime = 0;
_attMonth.GZDays = 0;
_attMonth.RestDays = 0;
_attMonth.TEarlyIn = 0;
_attMonth.TEarlyOut = 0;
_attMonth.TGZOT = 0;
_attMonth.TLateIn = 0;
_attMonth.TLateOut = 0;
_attMonth.TNOT = 0;
_attMonth.TotalDays = 0;
_attMonth.TWorkTime = 0;
_attMonth.OT1 = 0;
_attMonth.OT2 = 0;
_attMonth.OT3 = 0;
_attMonth.OT4 = 0;
_attMonth.OT5 = 0;
_attMonth.OT6 = 0;
_attMonth.OT7 = 0;
_attMonth.OT8 = 0;
_attMonth.OT9 = 0;
_attMonth.OT10 = 0;
_attMonth.OT11 = 0;
_attMonth.OT12 = 0;
_attMonth.OT13 = 0;
_attMonth.OT14 = 0;
_attMonth.OT15 = 0;
_attMonth.OT16 = 0;
_attMonth.OT17 = 0;
_attMonth.OT18 = 0;
_attMonth.OT19 = 0;
_attMonth.OT20 = 0;
_attMonth.OT21 = 0;
_attMonth.OT22 = 0;
_attMonth.OT23 = 0;
_attMonth.OT24 = 0;
_attMonth.OT25 = 0;
_attMonth.OT26 = 0;
_attMonth.OT27 = 0;
_attMonth.OT28 = 0;
_attMonth.OT29 = 0;
_attMonth.OT30 = 0;
_attMonth.OT31 = 0;
TDays = 0;
WorkDays = 0;
PresentDays = 0;
AbsentDays = 0;
LeaveDays = 0;
RestDays = 0;
GZDays = 0;
EarlyIn = 0;
EarlyOut = 0;
LateIn = 0;
LateOut = 0;
WorkTime = 0;
NOT = 0;
GOT = 0;
TDays = Convert.ToByte((endDate - startDate).Days + 1);
CalculateMonthlyAttendanceSheet(EmpAttData);
_attMonth.Period = endDate.Date.Month.ToString() + endDate.Date.Year.ToString();
_attMonth.EmpMonth = EmpMonth;
_attMonth.EmpID = _Emp.EmpID;
_attMonth.EmpNo = _Emp.EmpNo;
_attMonth.EmpName = _Emp.EmpName;
return _attMonth;
}
private DataTable LoadPermanentMonthlyDT(List<EmpView> list, DateTime datefrom, DateTime dateto)
{
TAS2013Entities db = new TAS2013Entities();
List<AttData> attData = new List<AttData>();
List<AttData> _EmpAttData = new List<AttData>();
foreach (EmpView emp in list)
{
try
{
attData = db.AttDatas.Where(aa => aa.EmpID == emp.EmpID && aa.AttDate >= datefrom && aa.AttDate <= dateto).ToList();
PermanentMonthly cmp = new PermanentMonthly();
_EmpAttData = attData.Where(aa => aa.EmpID == emp.EmpID).ToList();
AttMnDataPer attMn = new AttMnDataPer();
attMn = cmp.processPermanentMonthlyAttSingle((DateTime)datefrom, (DateTime)dateto, emp, _EmpAttData);
AddDataToMonthlyDataAtable(attMn.Period.ToString(), attMn.EmpMonth.ToString(), (DateTime)attMn.StartDate, (DateTime)attMn.EndDate, attMn.EmpNo, (int)attMn.EmpID, attMn.EmpName, emp.SectionName, emp.DeptName, emp.TypeName, emp.LocName, emp.ShiftName, attMn.D21, attMn.D22, attMn.D23, attMn.D24, attMn.D25, attMn.D26, attMn.D27, attMn.D28, attMn.D29, attMn.D30, attMn.D31, attMn.D1, attMn.D2, attMn.D3, attMn.D4, attMn.D5, attMn.D6, attMn.D7, attMn.D8, attMn.D9, attMn.D10, attMn.D11, attMn.D12, attMn.D13, attMn.D14, attMn.D15, attMn.D16, attMn.D17, attMn.D18, attMn.D19, attMn.D20, (short)attMn.TotalDays, (short)attMn.WorkDays, (short)attMn.PreDays, (short)attMn.AbDays, (short)attMn.RestDays, (short)attMn.GZDays, (short)attMn.LeaveDays, (short)attMn.OfficialDutyDays, (short)attMn.TEarlyIn, (short)attMn.TEarlyOut, (short)attMn.TLateIn, (short)attMn.TLateOut, (short)attMn.TWorkTime, (short)attMn.TNOT, (short)attMn.TGZOT, (short)attMn.ExpectedWrkTime, (short)attMn.OT1, (short)attMn.OT2, (short)attMn.OT3, (short)attMn.OT4, (short)attMn.OT5, (short)attMn.OT6, (short)attMn.OT7, (short)attMn.OT8, (short)attMn.OT9, (short)attMn.OT10, (short)attMn.OT11, (short)attMn.OT12, (short)attMn.OT13, (short)attMn.OT14, (short)attMn.OT15, (short)attMn.OT16, (short)attMn.OT17, (short)attMn.OT18, (short)attMn.OT19, (short)attMn.OT20, (short)attMn.OT21, (short)attMn.OT22, (short)attMn.OT23, (short)attMn.OT24, (short)attMn.OT25, (short)attMn.OT26, (short)attMn.OT27, (short)attMn.OT28, (short)attMn.OT29, (short)attMn.OT30, (short)attMn.OT31);
}
catch (Exception ex)
{
}
}
return FlexyMonthlyReportDT;
}
