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