//insert time header
public string insertTimeHeader(TimeHeaderModel model)
{
try
{
DbCommand dbCommand = db.GetStoredProcCommand("ins_TimeHeader");
db.AddInParameter(dbCommand, "staffID", DbType.Int32, model.staffID);
db.AddInParameter(dbCommand, "weekEnding", DbType.String, model.weekEnding);
db.ExecuteNonQuery(dbCommand);
return("success");
}
catch
{
return("fail");
}
}
public ActionResult addTimeSheet(FormCollection col)
{
TimeHeaderModel timeHeader = new TimeHeaderModel();
timeHeader.staffID = Convert.ToInt32(col["staffID"]);
timeHeader.weekEnding = col["weekEnding"];
TimeSheetDataController dataController = new TimeSheetDataController();
dataController.insertTimeHeader(timeHeader);
Staff staff = new Staff();
StaffController staffController = new StaffController();
ViewBag.staffList = staffController.GetStaffList();
ViewBag.staffID = timeHeader.staffID;
return(View("Time_Headers"));
}
