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