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