public List<CIUnavailability> XtractFormCollectionData(FormCollection formCollection) { //int i = 0; List<CIUnavailability> excelDataList = new List<CIUnavailability>(); CIUnavailability model = new CIUnavailability(); foreach (string formData in formCollection) { //if (formData == "selectedRow_" + i) if (formData == "selectedRow_") { model.CI_UNAVAILABILITY_ID = formCollection[formData].ToString(); //i++; excelDataList.Add(model); model = new CIUnavailability(); } } return excelDataList; }
public ActionResult Edit(CIUnavailability record, string id) { var data = new CIUnavailability(); data = _db.CIUnavailabilities.FirstOrDefault(x => x.CI_UNAVAILABILITY_ID == id); data.REVIEW_STATUSREASON_ID = record.REVIEW_STATUSREASON_ID; data.ADJUSTED_START_DATE = record.ADJUSTED_START_DATE; data.ADJUSTED_END_DATE = record.ADJUSTED_END_DATE; data.ADJUSTED_DURATION = record.ADJUSTED_DURATION; data.ADJUSTED_ASSIGNMENT_STATUS = record.ADJUSTED_ASSIGNMENT_STATUS; data.COMMENTS = record.COMMENTS; data.UPDATED_BY = User.Identity.Name; data.UPDATED_DATE = DateTime.Now; // If any changes have been made to this record, mark this as an Adjusted record if (data.ADJUSTED_START_DATE != null || data.ADJUSTED_END_DATE != null || data.ADJUSTED_DURATION != null || !string.IsNullOrEmpty(data.COMMENTS) || !string.IsNullOrEmpty(data.ADJUSTED_ASSIGNMENT_STATUS)) { data.REVIEW_STATUS_ID = ReviewStatusType.Adjusted; } else { // No changes so remains as Imported. Cannot reach this code if record has been perviously excluded, so it's safe to reset to Imported if all adjusted fields are null/empty. data.REVIEW_STATUS_ID = ReviewStatusType.Imported; data.REVIEW_STATUSREASON_ID = null; } try { int success = _db.SaveChanges(); if(success == 1) { TempData["type"] = "success"; TempData["title"] = "Update successfully!"; TempData["message"] = "The current record is saved successfully."; } } catch (Exception e) { string error = e.Message; throw; } LoadDropdowns(); return View("Edit", data); }