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);
}
