public ActionResult SubmitTime(TimeRecord record) { if (ModelState.IsValid) { var repo = new EmployeeRepository(); repo.AddTimeRecordToDB(record); return RedirectToAction("TimeSheet"); } return RedirectToAction("Index"); }
public void AddTimeRecordToDB(TimeRecord tr) { using (SqlConnection cn = new SqlConnection(Settings.ConnectionString)) { var p = new DynamicParameters(); p.Add("EmpID", tr.EmpID); p.Add("DateWorked", tr.DateWorked.ToShortDateString()); p.Add("HoursWorked", tr.HoursWorked); cn.Execute("dbo.AddTimeRecord", p, commandType: CommandType.StoredProcedure); } }