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));
}
