public List <EmployeeAttendanceModel> GetAttendanceForRange(Int64 UserID, DateTime FromDateTime, DateTime ToDateTime, string requestLevelPerson, bool isDirectEmployees, bool getBreakStatus)
{
List <EmployeeAttendanceModel> employeeAttendanceModelList = new List <EmployeeAttendanceModel>();
EmployeeDac employeeDac = new EmployeeDac();
IList <Int64> employeeIDs = new List <Int64>();
if (requestLevelPerson.ToUpper() == "MY")
{
employeeIDs.Add(UserID);
}
else
{
if (isDirectEmployees)
{
employeeIDs = employeeDac.GetDirectEmployees(UserID);
}
else
{
employeeIDs = employeeDac.GetEmployeesReporting(UserID);
}
}
using (var context = new NLTDDbContext())
{
employeeAttendanceModelList = (from ea in context.EmployeeAttendance
join e in context.Employee on ea.UserID equals e.UserId
join s in context.ShiftMapping on e.UserId equals s.UserID
join sm in context.ShiftMaster on s.ShiftID equals sm.ShiftID
where employeeIDs.Contains(ea.UserID ?? 0) && ea.InOutDate >= FromDateTime && ea.InOutDate <= ToDateTime &&
ea.InOutDate >= DbFunctions.AddHours(s.ShiftDate, sm.FromTime.Hours - BeforeShiftBuffer) &&
ea.InOutDate <= (sm.ToTime.Hours > 9 ? DbFunctions.AddHours(s.ShiftDate, sm.ToTime.Hours + AfterShiftBuffer) : DbFunctions.AddHours(DbFunctions.AddDays(s.ShiftDate, 1), sm.ToTime.Hours + AfterShiftBuffer))
select new EmployeeAttendanceModel
{
UserID = ea.UserID,
InOutDate = ea.InOutDate,
InOut = (ea.InOut ? "Out" : "In"),
Name = (e.FirstName + " " + e.LastName),
ShiftDate = s.ShiftDate
}).OrderBy(e => e.UserID).ThenBy(e => e.InOutDate).ToList();
}
if (getBreakStatus)
{
TimeSpan punchTime = new TimeSpan();
TimeSpan breakTime = new TimeSpan();
TimeSpan workTime = new TimeSpan();
for (int i = 0; i <= employeeAttendanceModelList.Count - 1; i++)
{
if (i == employeeAttendanceModelList.Count - 1)
{
employeeAttendanceModelList[i].BreakDuration = "Total Work : " + workTime.ToString() + ", Total Break : " + breakTime.ToString();
}
else if (employeeAttendanceModelList[i].UserID == employeeAttendanceModelList[i + 1].UserID)
{
punchTime = (employeeAttendanceModelList[i + 1].InOutDate - employeeAttendanceModelList[i].InOutDate);
if (employeeAttendanceModelList[i].ShiftDate == employeeAttendanceModelList[i + 1].ShiftDate)
{
if (employeeAttendanceModelList[i].InOut == "In")
{
if (employeeAttendanceModelList[i + 1].InOut == "Out")
{
employeeAttendanceModelList[i].BreakDuration = "Work : " + punchTime.ToString();
workTime += punchTime;
}
else
{
employeeAttendanceModelList[i].BreakDuration = "Missing Out Punch";
}
}
else
{
if (employeeAttendanceModelList[i + 1].InOut == "In")
{
employeeAttendanceModelList[i].BreakDuration = "Break : " + punchTime.ToString();
breakTime += punchTime;
}
else
{
employeeAttendanceModelList[i].BreakDuration = "Missing In Punch";
}
}
}
else
{
employeeAttendanceModelList[i].BreakDuration = "Total Work : " + workTime.ToString() + ", Total Break : " + breakTime.ToString();
workTime = TimeSpan.Zero;
breakTime = TimeSpan.Zero;
}
}
else
{
employeeAttendanceModelList[i].BreakDuration = "Total Work : " + workTime.ToString() + ", Total Break : " + breakTime.ToString();
workTime = TimeSpan.Zero;
breakTime = TimeSpan.Zero;
}
}
}
return(employeeAttendanceModelList.OrderBy(e => e.Name).ThenByDescending(e => e.InOutDate).ToList());
}