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