public ActionResult Update(FormCollection coll) { string role = roledb.GetUserRolesByUser(User.Identity.Name.ToString().ToUpper().Replace("CT\\", ""))[0]; ViewData["Role"] = role; int resource_id = int.Parse(coll["resid"]); DateTime myDate = DateTime.Parse(coll["txtDate"]); timedb.DeleteTimesheet(resource_id, myDate); //Delete Old Timesheet entries for this resource for this date peroid List <day> myEntries = new List <day>(); //Find all non null Timetable hours for posted foreach (var item in coll) { if (item.ToString().Contains("dayentry")) { if (coll[item.ToString()].Trim() != string.Empty) { string[] parts = item.ToString().Split('|'); myEntries.Add(new day { Day = int.Parse(parts[1]), Year = myDate.Year, Month = myDate.Month, HoursWorked = decimal.Parse(coll[item.ToString()].ToString().Trim()) }); } } } timedb.AddTimeSheetEntriesForDays(myEntries, resource_id); //Add Time entries for this resource timedb.Save(); //Submit to database ViewData["Users"] = new SelectList(userdb.GetUserItems(), "cai", "detail", coll["ddlUsers"]); ViewData["MonthDays"] = MonthDays(myDate); ViewData["UserProjects"] = userdb.GetUserResources(coll["ddlUsers"]).ToList(); return(View("Index", timedb.GetTimeSheetByUser(coll["ddlUsers"], DateTime.Parse(coll["txtDate"])))); }