public ActionResult DeleteLocGr(LocationGroupDeleteViewModel model)
        {
            try
            {
                int id = Convert.ToInt32(model.ID);
                if (_uow.Repository <REF_LOCATION_X_LOCATION_GROUP_TB>().Find(u => u.N_LOCATION_GROUP_SYSID == id).Count() > 0 ||
                    _uow.Repository <REF_REQUEST_TB>().Find(u => u.N_LOCATION_GROUP_SYSID == id).Count() > 0)
                {
                    model.ShowMessageDescription = true;
                    model.MessageDescription     = "Records exist for this location group. Sorry, the location group can not be deleted.";

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

                    return(RedirectToAction("Index", new { ID = id }));
                }
            }
            catch (Exception ex)
            {
                if (ex.InnerException == null)
                {
                    ViewBag.Message = "Function: LocationGroupController.DeleteLocGr_POST\n\nError: " + ex.Message;
                }
                else
                {
                    ViewBag.Message = "Function: LocationGroupController.DeleteLocGr_POST\n\nError: " + (ex.Message + "\n\nInnerException: " + ex.InnerException.Message);
                };
                Session["ErrorMessage"] = ViewBag.Message;
                return(RedirectToAction("InternalServerError", "Error"));
            };
        }
        public ActionResult DeleteLocGr(string ID)
        {
            try
            {
                REF_LOCATION_GROUP_TB        locationGroup = _uow.Repository <REF_LOCATION_GROUP_TB>().GetById(Convert.ToInt32(ID));
                LocationGroupDeleteViewModel locationGroupDeleteViewModel = new LocationGroupDeleteViewModel()
                {
                    Description            = locationGroup.SZ_DESCRIPTION,
                    ID                     = locationGroup.N_LOCATION_GROUP_SYSID,
                    MessageDescription     = "",
                    ShowMessageDescription = false
                };

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