public ActionResult Delete(WaterBodyDeleteViewModel model)
        {
            try
            {
                int id = Convert.ToInt32(model.WaterBodyID);
                if (_uow.Repository <REF_LOCATION_TB>().Find(u => u.N_WATER_BODY_SYSID == id).Count() > 0 ||
                    _uow.Repository <TRN_SEWER_OVERFLOW_TB>().Find(u => u.N_WATER_BODY_SYSID == id).Count() > 0)
                {
                    model.ShowMessageNameAndDescription = true;
                    model.MessageNameAndDescription     = "Records exist for this water body. Sorry, the water body can not be deleted.";

                    return(View(model));
                }
                else
                {
                    _uow.Repository <REF_WATER_BODY_TB>().Delete(id);
                    _uow.SaveChanges();

                    return(RedirectToAction("Index", new { ID = id }));
                }
            }
            catch (Exception ex)
            {
                if (ex.InnerException == null)
                {
                    ViewBag.Message = "Function: WaterBodyController.Delete_POST\n\nError: " + ex.Message;
                }
                else
                {
                    ViewBag.Message = "Function: WaterBodyController.Delete_POST\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        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"));
            };
        }