public bool UpdateAttenance(AttenanceModel am)
{
using (var _dbcontext = new PayRollEntities())
{
var at = (from a in _dbcontext.ATTENDANCE_IMPORT where a.Id == am.Id select a).FirstOrDefault();
at.InTime = am.InTime;
at.OutTime = am.OutTime;
at.PunchRecords = am.PunchRecords;
_dbcontext.Entry(at).State = EntityState.Modified;
_dbcontext.SaveChanges();
return(true);
}
}
public ActionResult UpdateAttenance(int id)
{
AttenanceModel am = new AttenanceModel();
CommonRepository _repo = new CommonRepository();
var at = _repo.GetAttenancedate(id);
am.Id = at.Id;
am.sAttendanceDate = Convert.ToDateTime(at.AttendanceDate).ToString("dd/MM/yyyy");
am.EmployeeId = at.EmployeeId;
am.sInTime = Convert.ToDateTime(DateTime.Now.Date + at.InTime).ToString("hh:mm tt");
am.sOutTime = Convert.ToDateTime(DateTime.Now.Date + at.OutTime).ToString("hh:mm tt");
am.PunchRecords = at.PunchRecords;
ViewBag.date = am.sAttendanceDate;
return(View(am));
}
public ActionResult UpdateAttenance(AttenanceModel am)
{
if (ModelState.IsValid)
{
am.InTime = DateTime.ParseExact(am.sInTime, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay;
am.OutTime = DateTime.ParseExact(am.sOutTime, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay;
CommonRepository _repo = new CommonRepository();
_repo.UpdateAttenance(am);
}
else
{
return(View(am));
}
return(RedirectToAction("AttenanceReport", new { Date = Convert.ToDateTime(am.sAttendanceDate).ToString("dd/MM/yyyy") }));
}
public ActionResult AddAttenance(AttenanceModel am)
{
if (ModelState.IsValid)
{
ATTENDANCE_IMPORT ai = new ATTENDANCE_IMPORT();
ai.AttendanceLogId = 0;
ai.AttendanceDate = Convert.ToDateTime(am.sAttendanceDate);
ai.EmployeeId = am.EmployeeId;
ai.InTime = DateTime.ParseExact(am.sInTime, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay;
ai.OutTime = DateTime.ParseExact(am.sOutTime, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay;
ai.PunchRecords = am.PunchRecords;
CommonRepository _repo = new CommonRepository();
_repo.AddAttenance(ai);
}
else
{
return(View(am));
}
return(RedirectToAction("index"));
}
