public ActionResult AddAttendance(AddAttendanceModel attendance)
{
if (ModelState.IsValid)
{ //clalling BLL function
AttendanceLogic.addAttendance(attendance);
}
return(View());
}
public void addAttendance(AddAttendanceModel attendance)
{
if (Sqlcon.State == ConnectionState.Closed)
{
Sqlcon.Open();
SqlCommand Sqlcmd = new SqlCommand("SP_Add_Attendance", Sqlcon);
Sqlcmd.CommandType = CommandType.StoredProcedure;
Sqlcmd.Parameters.AddWithValue("@EmployeeID", attendance.EmployeeID);
Sqlcmd.Parameters.AddWithValue("@Month", attendance.Month);
Sqlcmd.Parameters.AddWithValue("@WorkingDays", attendance.WorkingDays);
Sqlcmd.Parameters.AddWithValue("@Absents", attendance.Absents);
Sqlcmd.ExecuteNonQuery();
Sqlcon.Close();
}
}
//add record
public void addAttendance(AddAttendanceModel attendance)
{
AttendanceDAL.addAttendance(attendance);
}
