public static void Clock(string phone, LogType logtype) { var EmpDb = new EmployeeDB(); var d = DateTime.Now; var clockTime = DateTimeSQLite.Value(d); var emp = EmpDb.GetEmployeeDetails().FirstOrDefault(c => c.Phone == phone); var log = new LogDetails() { EmpId = emp.Id, LogType = logtype.ToString(), LogTime = clockTime, }; EmpDb.AddEmployeeLog(log); }
public List <LogDetails> EmpLogDetails(int id) { var dCurrent = DateTime.Now; var startDay5 = DateTimeSQLite.Value(new DateTime(dCurrent.Year, dCurrent.Month, dCurrent.AddDays(-5).Day, 10, 00, 00)); var startDay4 = DateTimeSQLite.Value(new DateTime(dCurrent.Year, dCurrent.Month, dCurrent.AddDays(-4).Day, 10, 00, 00)); var startDay3 = DateTimeSQLite.Value(new DateTime(dCurrent.Year, dCurrent.Month, dCurrent.AddDays(-3).Day, 10, 00, 00)); var startDay2 = DateTimeSQLite.Value(new DateTime(dCurrent.Year, dCurrent.Month, dCurrent.AddDays(-2).Day, 10, 00, 00)); var startDay1 = DateTimeSQLite.Value(new DateTime(dCurrent.Year, dCurrent.Month, dCurrent.AddDays(-1).Day, 10, 00, 00)); var startDay0 = DateTimeSQLite.Value(new DateTime(dCurrent.Year, dCurrent.Month, dCurrent.AddDays(-0).Day, 10, 00, 00)); var endDay5 = DateTimeSQLite.Value(new DateTime(dCurrent.Year, dCurrent.Month, dCurrent.AddDays(-5).Day, 16, 00, 00)); var endDay4 = DateTimeSQLite.Value(new DateTime(dCurrent.Year, dCurrent.Month, dCurrent.AddDays(-4).Day, 16, 00, 00)); var endDay3 = DateTimeSQLite.Value(new DateTime(dCurrent.Year, dCurrent.Month, dCurrent.AddDays(-3).Day, 16, 00, 00)); var endDay2 = DateTimeSQLite.Value(new DateTime(dCurrent.Year, dCurrent.Month, dCurrent.AddDays(-2).Day, 16, 00, 00)); var endDay1 = DateTimeSQLite.Value(new DateTime(dCurrent.Year, dCurrent.Month, dCurrent.AddDays(-1).Day, 16, 00, 00)); var endDay0 = DateTimeSQLite.Value(new DateTime(dCurrent.Year, dCurrent.Month, dCurrent.AddDays(0).Day, 16, 00, 00)); var LogDetailsDetails = new List <LogDetails>(); if (id == 3 || id == 4) { LogDetailsDetails = new List <LogDetails>() { new LogDetails() { EmpId = id, LogType = LogType.In.ToString(), LogTime = startDay5, }, new LogDetails() { EmpId = id, LogType = LogType.In.ToString(), LogTime = startDay4, }, new LogDetails() { EmpId = id, LogType = LogType.In.ToString(), LogTime = startDay3, }, new LogDetails() { EmpId = id, LogType = LogType.In.ToString(), LogTime = startDay2, }, new LogDetails() { EmpId = id, LogType = LogType.In.ToString(), LogTime = startDay1, }, new LogDetails() { EmpId = id, LogType = LogType.Out.ToString(), LogTime = endDay5, }, new LogDetails() { EmpId = id, LogType = LogType.Out.ToString(), LogTime = endDay4, }, new LogDetails() { EmpId = id, LogType = LogType.Out.ToString(), LogTime = endDay3, }, new LogDetails() { EmpId = id, LogType = LogType.Out.ToString(), LogTime = endDay2, }, new LogDetails() { EmpId = id, LogType = LogType.Out.ToString(), LogTime = endDay1, }, }; } else { LogDetailsDetails = new List <LogDetails>() { new LogDetails() { EmpId = id, LogType = LogType.In.ToString(), LogTime = startDay5, }, new LogDetails() { EmpId = id, LogType = LogType.In.ToString(), LogTime = startDay4, }, new LogDetails() { EmpId = id, LogType = LogType.In.ToString(), LogTime = startDay3, }, new LogDetails() { EmpId = id, LogType = LogType.In.ToString(), LogTime = startDay2, }, new LogDetails() { EmpId = id, LogType = LogType.In.ToString(), LogTime = startDay1, }, new LogDetails() { EmpId = id, LogType = LogType.In.ToString(), LogTime = startDay0, }, new LogDetails() { EmpId = id, LogType = LogType.Out.ToString(), LogTime = endDay5, }, new LogDetails() { EmpId = id, LogType = LogType.Out.ToString(), LogTime = endDay4, }, new LogDetails() { EmpId = id, LogType = LogType.Out.ToString(), LogTime = endDay3, }, new LogDetails() { EmpId = id, LogType = LogType.Out.ToString(), LogTime = endDay2, }, new LogDetails() { EmpId = id, LogType = LogType.Out.ToString(), LogTime = endDay1, }, }; } return(LogDetailsDetails); }