public ActionResult Edit(int id) { try { ViewBag.Saved = false; StayBazar.Areas.Admin.Models.CityModel mbt = new CityModel() { CityId = 0 }; CLayer.City pt = BLayer.City.Get(id); if (pt != null) { mbt = new CityModel() { CityId = pt.CityId, Name = pt.Name, StateId = pt.StateId, ForListing = pt.ForListing, Keywords = pt.Keywords } } ; return(PartialView("_Edit", mbt)); } catch (Exception ex) { Common.LogHandler.HandleError(ex); return(Redirect("~/Admin/ErrorPage")); } }
public ActionResult Edit(StayBazar.Areas.Admin.Models.CityModel data) { try { if (ModelState.IsValid) { CLayer.City pt = new CLayer.City() { CityId = data.CityId, Name = data.Name, StateId = data.StateId, ForListing = data.ForListing, Keywords = data.Keywords }; BLayer.City.Save(pt); ViewBag.Saved = true; } else { ViewBag.Saved = false; } return(RedirectToAction("Index", new { id = data.StateId })); } catch (Exception ex) { Common.LogHandler.HandleError(ex); return(Redirect("~/Admin/ErrorPage")); } }
public int UpdateGDSCity(int StateID, string City = "Others") { int result = 0; string sql = "SELECT COUNT(*) FROM City WHERE StateID='" + StateID + "' and name='" + City + "'"; object obj = Connection.ExecuteSQLQueryScalar(sql); if (Connection.ToInteger(obj) < 1) { CLayer.City objCity = new CLayer.City(); objCity.CityId = 0; objCity.Name = City; objCity.StateId = StateID; objCity.ForListing = true; objCity.Keywords = City; result = Save(objCity); } else { sql = "SELECT cityid FROM City WHERE StateID='" + StateID + "' and name='" + City + "'"; obj = Connection.ExecuteSQLQueryScalar(sql); result = Connection.ToInteger(obj); } return(result); }
public CLayer.City GetCityID(string CityName) { CLayer.City city = null; List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pCity", DataPlug.DataType._Varchar, CityName)); DataTable dt = Connection.GetTable("cityID_Get", param); if (dt.Rows.Count > 0) { city = new CLayer.City() { CityId = Connection.ToInteger(dt.Rows[0]["CityId"]), Name = Connection.ToString(dt.Rows[0]["Name"]), StateId = Connection.ToInteger(dt.Rows[0]["StateId"]), ForListing = Connection.ToBoolean(dt.Rows[0]["ForListing"]), Keywords = Connection.ToString(dt.Rows[0]["Keywords"]) }; } else { city = new CLayer.City() { CityId = 0, Name = "", StateId = 0, //ForListing = Connection.ToBoolean(dt.Rows[0]["ForListing"]), //Keywords = Connection.ToString(dt.Rows[0]["Keywords"]) }; } return(city); }
public int Save(CLayer.City data) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pCityId", DataPlug.DataType._Int, data.CityId)); param.Add(Connection.GetParameter("pName", DataPlug.DataType._Varchar, data.Name)); param.Add(Connection.GetParameter("pStateId", DataPlug.DataType._Int, data.StateId)); param.Add(Connection.GetParameter("pForListing", DataPlug.DataType._Bool, data.ForListing)); param.Add(Connection.GetParameter("pKeywords", DataPlug.DataType._Varchar, data.Keywords)); object result = Connection.ExecuteQueryScalar("city_Save", param); return(Connection.ToInteger(result)); }
public CLayer.City Get(int?cityId) { CLayer.City city = null; List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pCityId", DataPlug.DataType._Int, cityId)); DataTable dt = Connection.GetTable("city_Get", param); if (dt.Rows.Count > 0) { city = new CLayer.City() { CityId = Connection.ToInteger(dt.Rows[0]["CityId"]), Name = Connection.ToString(dt.Rows[0]["Name"]), StateId = Connection.ToInteger(dt.Rows[0]["StateId"]), ForListing = Connection.ToBoolean(dt.Rows[0]["ForListing"]), Keywords = Connection.ToString(dt.Rows[0]["Keywords"]) }; } return(city); }
public static int Save(CLayer.City data) { DataLayer.City city = new DataLayer.City(); data.Validate(); return(city.Save(data)); }