public ActionResult EditTimeSheet(int sheetID, string startDate, string endDate, string assignedProjects = "true", string completed = "false")
{
ProjectRequestEntities request = new ProjectRequestEntities();
//sheetID = Convert.ToInt32(Request.QueryString["sheetID"]);
var chores = request.Chores.Where(c => c.sheetID == sheetID);
var timeSheet = request.TimeSheets.FirstOrDefault(t => t.sheetID == sheetID);
bool delete;
bool complete;
if (Request.Form["complete"] != null)
{
complete = true;
}
else
{
complete = false;
}
timeSheet.completed = complete;
foreach (var chore in chores)
{
var currentRequest = request.Requests.FirstOrDefault(r => r.reuqestID == chore.requestID);
if (Request.Form["Delete_" + chore.choreID] != null)
{
delete = true;
}
else
{
delete = false;
}
if (delete == false)
{
chore.requestID = Convert.ToInt16(Request.Form["Request_" + chore.choreID]);
chore.chore1 = Request.Form["Chore_" + chore.choreID].ToString();
chore.timeSpent = Convert.ToDecimal(Request.Form["TimeSpent_" + chore.choreID]);
chore.name = currentRequest.projectName;
}
else
{
request.DeleteObject(chore);
}
}
request.SaveChanges();
if (Request.Form["Request"] != null && Request.Form["Request"].ToString().Count() > 0)
{
int requestID = Convert.ToInt16(Request.Form["Request"]);
var currentRequest = request.Requests.FirstOrDefault(r => r.reuqestID == requestID);
Chore chore = new Chore();
chore.sheetID = sheetID;
chore.requestID = Convert.ToInt16(Request.Form["Request"]);
chore.chore1 = Request.Form["Chore"].ToString();
chore.timeSpent = Convert.ToDecimal(Request.Form["TimeSpent"]);
chore.name = currentRequest.projectName;
request.AddToChores(chore);
request.SaveChanges();
}
return(RedirectToAction("CreateTimeSheet", new { sheetID = sheetID, startDate = startDate, endDate = endDate, assignedProjects = assignedProjects, completed = completed }));
}