public int UpdateIndividualAttendanceDaily(AttendanceDailyViewModel atd)
{
SqlConnection conn = DbConnectHelper.GetConnection();
conn.Open();
SqlCommand cmd = new SqlCommand("sp_updateDailyattendance", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@checkIn", atd.AttCheckIn);
cmd.Parameters.AddWithValue("@CheckOut", atd.AttCheckOut);
cmd.Parameters.AddWithValue("@IsAbsent", atd.IsAbsent);
cmd.Parameters.AddWithValue("@empcode", atd.EmpCode);
cmd.Parameters.AddWithValue("@Date", atd.AttDate);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
da.Dispose();
cmd.Dispose();
conn.Close();
conn.Dispose();
return(0);
}
public ActionResult UpdateAttendancedata(AttendanceDailyViewModel atd)
{
try
{
if (atd.IsAbsent == 1)
{
atd.AttCheckIn = null;
atd.AttCheckOut = null;
_attendanceDailyServices.UpdateIndividualAttendanceDaily(atd);
}
else
{
if (atd.AttCheckIn != null && atd.AttCheckOut != null)
{
DateTime checkin = Convert.ToDateTime(atd.AttDate);
DateTime checkout = Convert.ToDateTime(atd.AttDate);
TimeSpan chkints = TimeSpan.Parse(atd.AttCheckIn);
checkin = checkin.Add(chkints);
atd.AttCheckIn = checkin.ToString();
TimeSpan chkoutts = TimeSpan.Parse(atd.AttCheckOut);
checkout = checkout.Add(chkoutts);
atd.AttCheckOut = checkout.ToString();
}
else
if (atd.AttCheckIn != null)
{
DateTime checkin = Convert.ToDateTime(atd.AttDate);
TimeSpan chkints = TimeSpan.Parse(atd.AttCheckIn);
checkin = checkin.Add(chkints);
atd.AttCheckIn = checkin.ToString();
}
else
if (atd.AttCheckOut != null)
{
DateTime checkout = Convert.ToDateTime(atd.AttDate);
TimeSpan chkoutts = TimeSpan.Parse(atd.AttCheckOut);
checkout = checkout.Add(chkoutts);
atd.AttCheckOut = checkout.ToString();
}
_attendanceDailyServices.UpdateIndividualAttendanceDaily(atd);
}
int id = atd.EmpCode;
string sdate = atd.SearchStartdate;
string enddate = atd.SearchEndDate;
return(RedirectToAction("Index", new { id = id, Sdate = sdate, Enddate = enddate }));
}
catch (Exception Ex)
{
return(View(Ex.Message));
}
}
