public List <TimeSheetModel> GetMyTeamTimeSheet(Int64 UserID, DateTime FromDate, DateTime ToDate, bool myDirectEmployees)
{
ITimesheetHelper TimesheetHelperObj = new TimeSheetDac();
List <TimeSheetModel> timeSheetModelList = TimesheetHelperObj.GetMyTeamTimeSheet(UserID, FromDate, ToDate, myDirectEmployees);
return(timeSheetModelList);
}
public List <lateAndEarlyRpt> GetLateAndEarlyEmployees(DateTime FromDate, DateTime ToDate, Int64 UserId, bool OnlyReportedToMe)
{
List <lateAndEarlyRpt> lateAndEarlyRpt = new List <lateAndEarlyRpt>();
try
{
ToDate = ToDate.AddDays(1);
using (var context = new NLTDDbContext())
{
List <TimeSheetModel> timeSheetModelList = new List <TimeSheetModel>();
TimeSheetDac timeSheetDac = new TimeSheetDac();
List <TimeSheetModel> timeSheetModelListTemp = timeSheetDac.GetMyTeamTimeSheet(UserId, FromDate, ToDate, OnlyReportedToMe);
timeSheetModelList.AddRange(timeSheetModelListTemp);
var shiftQueryModelList = (from sm in context.ShiftMaster
join smp in context.ShiftMapping on sm.ShiftID equals smp.ShiftID
join e in context.Employee on smp.UserID equals e.UserId
where smp.UserID == UserId && smp.ShiftDate >= FromDate && smp.ShiftDate <= ToDate
select new ShiftQueryModel
{
UserID = smp.UserID,
Employeename = e.FirstName + " " + e.LastName,
ShiftFromtime = sm.FromTime,
ShiftTotime = sm.ToTime,
ShiftDate = smp.ShiftDate,
}).ToList();
}
}
catch (Exception)
{
throw;
}
return(lateAndEarlyRpt);
}
