public long GetHrUserId()
{
ITimesheetHelper TimesheetHelperObj = new TimeSheetDac();
long usrId = TimesheetHelperObj.GetHrUserId();
return(usrId);
}
public bool IsUserHR(long userId)
{
ITimesheetHelper TimesheetHelperObj = new TimeSheetDac();
bool result = TimesheetHelperObj.IsUserHR(userId);
return(result);
}
public IList <UserEmailListModel> GetUserEmailData()
{
ITimesheetHelper TimesheetHelperObj = new TimeSheetDac();
IList <UserEmailListModel> usrEmailList = TimesheetHelperObj.GetUserEmailData();
return(usrEmailList);
}
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 <TimeSheetModel> GetMyTimeSheet(Int64 UserID, DateTime FromDate, DateTime ToDate)
{
ITimesheetHelper TimesheetHelperObj = new TimeSheetDac();
List <TimeSheetModel> timeSheetModelList = TimesheetHelperObj.GetMyTimeSheet(UserID, FromDate, ToDate);
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);
}
public List <ReportLateMonth> GetMyTimeSheet(Int64 UserID, DateTime FromDate, DateTime ToDate, string ReportingTo, string Name, string EmpId)
{
TimeSheetDac timeSheetDac = new TimeSheetDac();
List <ReportLateMonth> reportLateMonthlst = new List <ReportLateMonth>();
List <ShiftQueryModel> ShiftQueryModelList = timeSheetDac.GetShiftDetails(UserID, FromDate, ToDate);
try
{
var toDateShift = (from m in ShiftQueryModelList
where m.ShiftDate == ToDate
select new { fromTime = m.ShiftFromtime, toTime = m.ShiftTotime }).FirstOrDefault();
TimeSpan fromTime = toDateShift.fromTime;
TimeSpan toTime = toDateShift.toTime;
if (fromTime > toTime)
{
ToDate = ToDate.AddDays(1).Add(toTime.Add(new TimeSpan(AfterShiftBuffer, 0, 0)));
}
else
{
ToDate = ToDate.Add(toTime.Add(new TimeSpan(AfterShiftBuffer, 0, 0)));
}
// TimeSpan ToDate = ToDate.Add(toDateShift);
}
catch (Exception)
{
throw;
}
IEmployeeAttendanceHelper EmployeeAttendanceDacObj = new EmployeeAttendanceDac();
//To Retrive the Employee Attendance for the given date.
List <EmployeeAttendanceModel> EmployeeAttendanceList = EmployeeAttendanceDacObj.GetAttendanceForRange(UserID, FromDate, ToDate, "My", true, false);
try
{
for (int i = 0; i < ShiftQueryModelList.Count(); i++)
{
ReportLateMonth reportLateMonth = new ReportLateMonth();
DateTime shiftFromDateTime = ShiftQueryModelList[i].ShiftDate.Add(ShiftQueryModelList[i].ShiftFromtime.Add(new TimeSpan(-BeforeShiftBuffer, 0, 0)));
DateTime shiftEndDateTime = ShiftQueryModelList[i].ShiftDate.Add(ShiftQueryModelList[i].ShiftTotime.Add(new TimeSpan(AfterShiftBuffer, 0, 0)));
if (shiftEndDateTime < shiftFromDateTime)
{
shiftEndDateTime = shiftEndDateTime.AddDays(1);
}
reportLateMonth.UserID = UserID;
reportLateMonth.ReportingTo = ReportingTo;
reportLateMonth.Name = Name;
reportLateMonth.EmpId = EmpId;
var maxmin = from s in EmployeeAttendanceList
where s.InOutDate >= shiftFromDateTime && s.InOutDate <= shiftEndDateTime
group s by true into r
select new
{
min = r.Min(z => z.InOutDate)
};
if (maxmin != null && maxmin.Count() > 0)
{
if (maxmin.ToList()[0].min.TimeOfDay > ShiftQueryModelList[i].ShiftFromtime)
{
reportLateMonth.LateEntry = maxmin.ToList()[0].min.TimeOfDay - ShiftQueryModelList[i].ShiftFromtime;
reportLateMonthlst.Add(reportLateMonth);
}
}
}
}
catch (Exception)
{
throw;
}
return(reportLateMonthlst);
}
