public ActionResult Delete(string ID)
{
try
{
REF_WATER_BODY_TB waterBody = _uow.Repository <REF_WATER_BODY_TB>().GetById(Convert.ToInt32(ID));
WaterBodyDeleteViewModel waterBodyDeleteViewModel = new WaterBodyDeleteViewModel()
{
WaterBodyID = waterBody.N_WATER_BODY_SYSID,
WaterBodyName = waterBody.SZ_NAME,
WaterBodyDescription = waterBody.SZ_DESCRIPTION,
MessageNameAndDescription = "",
ShowMessageNameAndDescription = false
};
return(View(waterBodyDeleteViewModel));
}
catch (Exception ex)
{
if (ex.InnerException == null)
{
ViewBag.Message = "Function: WaterBodyController.Delete_GET\n\nError: " + ex.Message;
}
else
{
ViewBag.Message = "Function: WaterBodyController.Delete_GET\n\nError: " + (ex.Message + "\n\nInnerException: " + ex.InnerException.Message);
};
Session["ErrorMessage"] = ViewBag.Message;
return(RedirectToAction("InternalServerError", "Error"));
};
}
public ActionResult Delete(string ID)
{
try
{
REF_WATER_BODY_TB recWater = _uow.Repository <REF_WATER_BODY_TB>().GetById(Convert.ToInt32(ID));
ReceivingWaterDeleteViewModel recWaterDeleteViewModel = new ReceivingWaterDeleteViewModel()
{
ReceivingWaterID = recWater.N_WATER_BODY_SYSID,
ReceivingWaterDescription = recWater.SZ_DESCRIPTION,
MessageDescription = "",
ShowMessageDescription = false
};
return(View(recWaterDeleteViewModel));
}
catch (Exception ex)
{
if (ex.InnerException == null)
{
ViewBag.Message = "Function: ReceivingWaterController.Delete_GET\n\nError: " + ex.Message;
}
else
{
ViewBag.Message = "Function: ReceivingWaterController.Delete_GET\n\nError: " + (ex.Message + "\n\nInnerException: " + ex.InnerException.Message);
};
Session["ErrorMessage"] = ViewBag.Message;
return(RedirectToAction("InternalServerError", "Error"));
};
}
public ActionResult Edit(WaterBodyEditViewModel Model)
{
if (_waterBodyRepo.IsWaterBodyNameAndDescriptionDuplicate(Model.WaterBodyName, Model.WaterBodyDescription))
{
Model.ShowMessageNameAndDescription = true;
Model.MessageNameAndDescription = "The Water Body Name and Description combination already exists. Please enter a different one.";
return(View(Model));
}
else
{
if (ModelState.IsValid)
{
int id = 0;
if (Model.WaterBodyID == 0) //new
{
REF_WATER_BODY_TB waterBody = new REF_WATER_BODY_TB()
{
B_INACTIVE = false,
DT_ENTERED = DateTime.UtcNow,
DT_MODIFIED = DateTime.UtcNow,
SZ_ENTERED_BY = _modifiedBy,
SZ_MODIFIED_BY = _modifiedBy,
SZ_DESCRIPTION = Model.WaterBodyDescription,
SZ_NAME = Model.WaterBodyName
};
_uow.Repository <REF_WATER_BODY_TB>().Add(waterBody);
_uow.SaveChanges();
REF_WATER_BODY_TB waterBodyFound = _uow.Repository <REF_WATER_BODY_TB>().Find(u => u.SZ_ENTERED_BY == _modifiedBy &&
u.SZ_MODIFIED_BY == _modifiedBy && u.SZ_DESCRIPTION == Model.WaterBodyDescription &&
u.SZ_NAME == Model.WaterBodyName).FirstOrDefault();
id = waterBodyFound.N_WATER_BODY_SYSID;
}
else //edit
{
REF_WATER_BODY_TB waterBody = _uow.Repository <REF_WATER_BODY_TB>().GetById(Model.WaterBodyID);
waterBody.DT_MODIFIED = DateTime.UtcNow;
waterBody.SZ_DESCRIPTION = Model.WaterBodyDescription;
waterBody.SZ_MODIFIED_BY = _modifiedBy;
waterBody.SZ_NAME = Model.WaterBodyName;
_uow.Repository <REF_WATER_BODY_TB>().Update(waterBody);
_uow.SaveChanges();
id = Model.WaterBodyID;
}
return(RedirectToAction("Index", new { ID = id }));
}
return(View(Model));
}
}
public ActionResult Edit(int ID)
{
try
{
var receivingWaterEditViewModel = new ReceivingWaterEditViewModel();
if (ID > 0)
{
REF_WATER_BODY_TB receivingWater = _uow.Repository <REF_WATER_BODY_TB>().GetById(ID);
receivingWaterEditViewModel.ReceivingWaterDescription = receivingWater.SZ_DESCRIPTION == null ? "" : receivingWater.SZ_DESCRIPTION;
receivingWaterEditViewModel.ReceivingWaterID = receivingWater.N_WATER_BODY_SYSID;
receivingWaterEditViewModel.ShowMessageDescription = false;
receivingWaterEditViewModel.MessageDescription = "";
}
else
{
receivingWaterEditViewModel.ReceivingWaterDescription = "";
receivingWaterEditViewModel.ReceivingWaterID = ID;
receivingWaterEditViewModel.ShowMessageDescription = false;
receivingWaterEditViewModel.MessageDescription = "";
}
return(View("Edit", receivingWaterEditViewModel));
}
catch (Exception ex)
{
if (ex.InnerException == null)
{
ViewBag.Message = "Function: ReceivingWaterController.Edit_GET\n\nError: " + ex.Message;
}
else
{
ViewBag.Message = "Function: ReceivingWaterController.Edit_GET\n\nError: " + (ex.Message + "\n\nInnerException: " + ex.InnerException.Message);
};
Session["ErrorMessage"] = ViewBag.Message;
return(RedirectToAction("InternalServerError", "Error"));
};
}
public ViewResult Edit(int ID)
{
var waterBodyEditViewModel = new WaterBodyEditViewModel();
if (ID > 0)
{
REF_WATER_BODY_TB waterBody = _uow.Repository <REF_WATER_BODY_TB>().GetById(ID);
waterBodyEditViewModel.WaterBodyDescription = waterBody.SZ_DESCRIPTION == null ? "" : waterBody.SZ_DESCRIPTION;
waterBodyEditViewModel.WaterBodyID = waterBody.N_WATER_BODY_SYSID;
waterBodyEditViewModel.WaterBodyName = waterBody.SZ_NAME == null ? "" : waterBody.SZ_NAME;
waterBodyEditViewModel.ShowMessageNameAndDescription = false;
waterBodyEditViewModel.MessageNameAndDescription = "";
}
else
{
waterBodyEditViewModel.WaterBodyDescription = "";
waterBodyEditViewModel.WaterBodyID = ID;
waterBodyEditViewModel.WaterBodyName = "";
waterBodyEditViewModel.ShowMessageNameAndDescription = false;
waterBodyEditViewModel.MessageNameAndDescription = "";
}
return(View("Edit", waterBodyEditViewModel));
}
public ActionResult Edit(ReceivingWaterEditViewModel Model)
{
bool saveFailed;
do
{
saveFailed = false;
try
{
if (_receivingWaterRepo.IsReceivingWaterDescriptionDuplicate(Model.ReceivingWaterDescription))
{
Model.ShowMessageDescription = true;
Model.MessageDescription = "The Receiving Water Description already exists. Please enter a different one.";
return(View(Model));
}
else
{
if (ModelState.IsValid)
{
int id = 0;
if (Model.ReceivingWaterID == 0) //new
{
int receivingWaterID = _receivingWaterRepo.GetNextRecWaterID();
REF_WATER_BODY_TB receivingWater = new REF_WATER_BODY_TB()
{
SZ_ENTERED_BY = _modifiedBy,
DT_ENTERED = DateTime.UtcNow,
SZ_MODIFIED_BY = _modifiedBy,
DT_MODIFIED = DateTime.UtcNow,
SZ_NAME = Model.ReceivingWaterDescription,
SZ_DESCRIPTION = Model.ReceivingWaterDescription
};
_uow.Repository <REF_WATER_BODY_TB>().Add(receivingWater);
_uow.SaveChanges();
REF_WATER_BODY_TB receivingWaterFound = _uow.Repository <REF_WATER_BODY_TB>().Find(u => u.SZ_ENTERED_BY == _modifiedBy &&
u.SZ_MODIFIED_BY == _modifiedBy && u.SZ_DESCRIPTION == Model.ReceivingWaterDescription
).FirstOrDefault();
id = receivingWaterFound.N_WATER_BODY_SYSID;
}
else //edit
{
REF_WATER_BODY_TB receivingWater = _uow.Repository <REF_WATER_BODY_TB>().GetById(Model.ReceivingWaterID);
receivingWater.SZ_MODIFIED_BY = _modifiedBy;
receivingWater.DT_MODIFIED = DateTime.UtcNow;
receivingWater.SZ_DESCRIPTION = Model.ReceivingWaterDescription;
_uow.Repository <REF_WATER_BODY_TB>().Update(receivingWater);
_uow.SaveChanges();
id = Model.ReceivingWaterID;
}
return(RedirectToAction("Index", new { ID = id }));
}
return(View(Model));
}
}
catch (DbEntityValidationException ex)
{
StringBuilder sb = new StringBuilder();
foreach (var failure in ex.EntityValidationErrors)
{
sb.AppendFormat("{0} failed validation:\n\n", failure.Entry.Entity.GetType());
foreach (var error in failure.ValidationErrors)
{
sb.AppendFormat("- {0} : {1}", error.PropertyName, error.ErrorMessage);
sb.AppendLine();
}
}
if (ex.InnerException == null)
{
ViewBag.Message = "Function: ReceivingWaterController.Edit_POST\n\nError: " + ex.Message + "\n\n" + sb;
}
else
{
ViewBag.Message = "Function: ReceivingWaterController.Edit_POST\n\nError: " + ex.Message + "\n\n" + sb + "\n\n" + ex.InnerException.Message;
};
}
catch (DbUpdateConcurrencyException ex)
{
saveFailed = true;
var entry = ex.Entries.Single();
entry.OriginalValues.SetValues(entry.GetDatabaseValues());
}
catch (DataException ex)
{
if (ex.InnerException == null)
{
ViewBag.Message = "Function: ReceivingWaterController.Edit_POST\n\nError: " + ex.Message + "\n\nBaseException: " + ex.GetBaseException().Message;
}
else
{
ViewBag.Message = "Function: ReceivingWaterController.Edit_POST\n\nError: " + ex.Message + "\n\nBaseException: " + ex.GetBaseException().Message + "\n\nInnerException: " + ex.InnerException.Message;
};
}
catch (Exception ex)
{
if (ex.InnerException == null)
{
ViewBag.Message = "Function: ReceivingWaterController.Edit_POST\n\nError: " + ex.Message;
}
else
{
ViewBag.Message = "Function: ReceivingWaterController.Edit_POST\n\nError: " + ex.Message + "\n\nBaseException: " + ex.InnerException.Message;
};
};
} while (saveFailed);
Session["ErrorMessage"] = ViewBag.Message;
return(RedirectToAction("InternalServerError", "Error"));
}