public bool DeleteCity(long CITY_CD) { ManageCityDa dataAccess = new ManageCityDa(); int result = 0; using (var transaction = new TransactionScope()) { try { result = dataAccess.DeleteCity(CITY_CD); if (result > 0) { transaction.Complete(); } } catch (Exception ex) { transaction.Dispose(); result = -1; throw new Exception(ex.Message, ex); } finally { transaction.Dispose(); } } return(result > 0); }
public IEnumerable <MstCity> SearchCityList(DataTableModel dt, CityModel model, out int total_row) { ManageCityDa dataAccess = new ManageCityDa(); IEnumerable <MstCity> results = dataAccess.SearchCityList(dt, model, out total_row); return(results); }
//check exist public ActionResult CheckExistCityCd(int cityCd, int cityCdOld) { if (Request.IsAjaxRequest()) { // Declare new DataAccess object ManageCityDa dataAccess = new ManageCityDa(); var exist = dataAccess.FindCity(cityCd, cityCdOld); JsonResult result = Json(new { exist }, JsonRequestBehavior.AllowGet); return(result); } return(new EmptyResult()); }
public long UpdateCity(MstCity city) { var ManageCityDa = new ManageCityDa(); long res = 0; // Declare new DataAccess object ManageCityDa dataAccess = new ManageCityDa(); using (var transaction = new TransactionScope()) { res = dataAccess.UpdateCity(city); if (res <= 0) { transaction.Dispose(); } transaction.Complete(); } return(res); }
public ActionResult CityEdit(int CityCd = 0) { CmnEntityModel currentUser = Session["CmnEntityModel"] as CmnEntityModel; var authorityList = currentUser != null ? currentUser.USER_AUTHORITY : 0; if (currentUser == null || authorityList != 2) { return(RedirectToAction("Login", "UserAccount")); } CityModel model = new CityModel(); ManageCityDa dataAccess = new ManageCityDa(); if (CityCd > 0) { model = dataAccess.getInfoCity(CityCd); } return(View(model)); }