public ActionResult DeleteFacility(FacilityDeleteViewModel model)
        {
            try
            {
                int id = Convert.ToInt32(model.ID);
                if (_uow.Repository <TRN_SEWER_OVERFLOW_TB>().Find(u => u.N_FACILITY_SYSID == id).Count() > 0)
                {
                    model.ShowMessage = true;
                    model.Message     = "Sewer Overflow records exist for this facility. Sorry, the facility can not be deleted.";

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

                    return(RedirectToAction("Index", new { ID = id }));
                }
            }
            catch (Exception ex)
            {
                if (ex.InnerException == null)
                {
                    ViewBag.Message = "Function: AdminController.Delete_POST\n\nError: " + ex.Message;
                }
                else
                {
                    ViewBag.Message = "Function: AdminController.Delete_POST\n\nError: " + (ex.Message + "\n\nInnerException: " + ex.InnerException.Message);
                };
                Session["ErrorMessage"] = ViewBag.Message;
                return(RedirectToAction("InternalServerError", "Error"));
            };
        }
        public ActionResult Delete(FacilityDeleteViewModel model)
        {
            try
            {
                REF_FACILITY_TB         facility = _uow.Repository <REF_FACILITY_TB>().GetById(model.ID);
                FacilityDeleteViewModel facilityDeleteViewModel = new FacilityDeleteViewModel()
                {
                    ID          = facility.N_FACILITY_SYSID,
                    Title       = facility.SZ_TITLE,
                    Message     = "",
                    ShowMessage = false
                };

                return(View("Delete", facilityDeleteViewModel));
            }
            catch (Exception ex)
            {
                if (ex.InnerException == null)
                {
                    ViewBag.Message = "Function: FacilityController.Delete_GET\n\nError: " + ex.Message;
                }
                else
                {
                    ViewBag.Message = "Function: FacilityController.Delete_GET\n\nError: " + (ex.Message + "\n\nInnerException: " + ex.InnerException.Message);
                };
                Session["ErrorMessage"] = ViewBag.Message;
                return(RedirectToAction("InternalServerError", "Error"));
            };
        }