public ActionResult submitRectifications(RectificationSelectionViewModel model) { var selectedIds = model.getSelectedIds(); if (selectedIds.Count > 0) { StringBuilder strXML = new StringBuilder(); strXML.Append("<CS_COLLECTION>"); foreach (var pkuid in selectedIds) { strXML.Append("<CSRECORD><pkuid>" + pkuid + "</pkuid><user_id>" + System.Web.HttpContext.Current.Session["username"].ToString() + "</user_id></CSRECORD>"); } strXML.Append("</CS_COLLECTION>"); string rtnString = ds.InsertRectification(strXML.ToString()); if (!string.IsNullOrWhiteSpace(rtnString)) { ModelState.AddModelError("", rtnString); } } var model2 = new RectificationSelectionViewModel(); model2 = GetFailedTransectsFromDb(model); return(View("Index", model2)); }
// GET: Rectification public ActionResult Index() { var model = new RectificationSelectionViewModel(); model.Rectifications = null; model.StartDate = DateTime.Today; model.EndDate = DateTime.Today; return(View(model)); }
private RectificationSelectionViewModel SetRectificationEnabledStatus(RectificationSelectionViewModel model) { foreach (var item in model.Rectifications.Where(w => w.Enabled == true)) { if (item.HiddenEnabled == "true") { item.Enabled = true; } else { item.Enabled = false; } } return(model); }
private RectificationSelectionViewModel GetFailedTransectsFromDb(RectificationSelectionViewModel model) { var StartDateParam = new SqlParameter { ParameterName = "StartDate", Value = model.StartDate }; var EndDateParam = new SqlParameter { ParameterName = "EndDate", Value = model.EndDate }; var model2 = new RectificationSelectionViewModel(); model2.StartDate = model.StartDate; model2.Rectifications = new List <RectificationEditorViewModel>(); model2.EndDate = model.EndDate; var smplRectificationsByDate = db.Database.SqlQuery <Rectification>("exec GetFailedTransects @StartDate, @EndDate ", StartDateParam, EndDateParam).ToList(); foreach (var rect in smplRectificationsByDate) { var RectVM = new RectificationEditorViewModel(); RectVM.seq_id = rect.seq_id; RectVM.pkuid = rect.pkuid; RectVM.inspected_date = rect.inspected_date; RectVM.ward_name = rect.ward_name; RectVM.colour = rect.colour; RectVM.freq_code = rect.freq_code; RectVM.street_name = rect.street_name; RectVM.limits = rect.limits; RectVM.grade = rect.grade; RectVM.reason_code = rect.reason_code; RectVM.rectification = rect.rectification; RectVM.disable_twiceweekly = rect.disable_twiceweekly; //set defaults RectVM.BackgroundColour = "colorFreqCodeWhite"; RectVM.Enabled = true; RectVM.HiddenEnabled = "true"; RectVM.Selected = false; //if Freq_Code field is: "1xDaily Path"; "1xDaily Street"; "1xDaily Recycling"; "Daily Litter Bin"; then BackGround colour is yellow //if Freq_Code field is: "Zone 1"; then BackGround colour is Sky Blue AND Checkbox is Disabled //if Rectification field is NOT empty (test for space) then Checkbox is Disabled and Checked switch (rect.freq_code) { case "1xDaily Path": case "1xDaily Street": case "Daily Litter Bin": RectVM.BackgroundColour = "colorFreqCodeYellow"; break; case "Zone 1": RectVM.BackgroundColour = "colorFreqCodeSkyBlue"; RectVM.Enabled = false; break; default: break; } if (!string.IsNullOrWhiteSpace(rect.rectification)) { RectVM.Enabled = false; RectVM.Selected = true; } model2.Rectifications.Add(RectVM); } return(model2); }
public ActionResult getFailedTransects(RectificationSelectionViewModel model) { model = GetFailedTransectsFromDb(model); return(View("Index", model)); }