public ActionResult Edit(StayBazar.Areas.Admin.Models.CountryModel data) { try { if (ModelState.IsValid) { CLayer.Country pt = new CLayer.Country() { CountryId = data.CountryId, Name = data.Name, IsDefault = data.IsDefault, ForProperty = data.ForProperty, Status = data.Status, Code = data.Code }; BLayer.Country.Save(pt); ViewBag.Saved = true; } else { ViewBag.Saved = false; } return(RedirectToAction("Index")); } catch (Exception ex) { Common.LogHandler.HandleError(ex); return(Redirect("~/Admin/ErrorPage")); } }
public ActionResult Edit(int id) { try { ViewBag.Saved = false; StayBazar.Areas.Admin.Models.CountryModel mbt = new CountryModel() { CountryId = 0 }; CLayer.Country pt = BLayer.Country.Get(id); if (pt != null) { mbt = new CountryModel() { CountryId = pt.CountryId, Name = pt.Name, IsDefault = pt.IsDefault, ForProperty = pt.ForProperty, Status = pt.Status, Code = pt.Code } } ; return(PartialView("_Edit", mbt)); } catch (Exception ex) { Common.LogHandler.HandleError(ex); return(Redirect("~/Admin/ErrorPage")); } }
public string UpdateGDSCountry(string CountryName) { string pKeyword = CountryName; string CountryFromKeyWord = GetCountryWithKeyWords(CountryName); CountryName = string.IsNullOrEmpty(CountryFromKeyWord) ? CountryName : CountryFromKeyWord; string sql = "SELECT COUNT(*) FROM country WHERE NAME='" + CountryName + "'"; object obj = Connection.ExecuteSQLQueryScalar(sql); if (Connection.ToInteger(obj) < 1) { CLayer.Country country = new CLayer.Country(); country.Name = CountryName; country.ForProperty = true; country.Status = 1; // country.KeyWords = CountryName; Save(country); } else { string sqlc = "SELECT CountryID FROM country WHERE NAME='" + CountryName + "'"; object objc = Connection.ExecuteSQLQueryScalar(sqlc); CLayer.Country country = new CLayer.Country(); country.CountryId = Connection.ToLong(objc); country.Name = CountryName; country.ForProperty = true; country.Status = 1; // country.KeyWords = pKeyword; Save(country); } return(CountryName); }
public int GDSSave(CLayer.Country country) { string pKeyWords = country.KeyWords; string sql = "select keywords from country where countryid=" + country.CountryId + ""; string result = Convert.ToString(Connection.ExecuteSQLQueryScalar(sql)); if (!string.IsNullOrEmpty(result)) { string[] resultList = result.Split(','); for (int i = 0; i < resultList.Length; i++) { if (resultList[i] != pKeyWords) { country.KeyWords = result + "," + pKeyWords; } } } List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pCountryId", DataPlug.DataType._BigInt, country.CountryId)); param.Add(Connection.GetParameter("pName", DataPlug.DataType._Varchar, country.Name)); param.Add(Connection.GetParameter("pCode", DataPlug.DataType._Varchar, country.Code)); param.Add(Connection.GetParameter("pIsDefault", DataPlug.DataType._Bool, country.IsDefault)); param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, country.Status)); param.Add(Connection.GetParameter("pForProperty", DataPlug.DataType._Bool, country.ForProperty)); param.Add(Connection.GetParameter("pKeyWords", DataPlug.DataType._Varchar, country.KeyWords)); object objresult = Connection.ExecuteQueryScalar("GDScountry_Save", param); return(Connection.ToInteger(objresult)); }
public int GDSKeywordSave(CLayer.Country country) { string pKeyWords = country.KeyWords; string sql = "select keywords from country where countryid=" + country.CountryId + ""; string result = Convert.ToString(Connection.ExecuteSQLQueryScalar(sql)); if (!string.IsNullOrEmpty(result)) { string[] resultList = result.Split(','); for (int i = 0; i < resultList.Length; i++) { if (resultList[i] != pKeyWords) { if (!result.Contains(pKeyWords)) { country.KeyWords = result + "," + pKeyWords; } else { country.KeyWords = result; } } } } sql = "Update country set keywords='" + country.KeyWords + "' where countryid=" + country.CountryId + ""; object obj = Connection.ExecuteSQLQueryScalar(sql); return(Connection.ToInteger(obj)); }
public int Save(CLayer.Country country) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pCountryId", DataPlug.DataType._BigInt, country.CountryId)); param.Add(Connection.GetParameter("pName", DataPlug.DataType._Varchar, country.Name)); param.Add(Connection.GetParameter("pCode", DataPlug.DataType._Varchar, country.Code)); param.Add(Connection.GetParameter("pIsDefault", DataPlug.DataType._Bool, country.IsDefault)); param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, country.Status)); param.Add(Connection.GetParameter("pForProperty", DataPlug.DataType._Bool, country.ForProperty)); object result = Connection.ExecuteQueryScalar("country_Save", param); return(Connection.ToInteger(result)); }
// // TODO Delete Country // public CLayer.Country Get(int CountryId) { CLayer.Country country = null; List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pCountryId", DataPlug.DataType._BigInt, CountryId)); DataTable dt = Connection.GetTable("country_Get", param); if (dt.Rows.Count > 0) { country = new CLayer.Country(); country.CountryId = Connection.ToLong(dt.Rows[0]["CountryId"]); country.Name = Connection.ToString(dt.Rows[0]["Name"]); country.IsDefault = Connection.ToBoolean(dt.Rows[0]["IsDefault"]); country.Status = Connection.ToInteger(dt.Rows[0]["Status"]); country.ForProperty = Connection.ToBoolean(dt.Rows[0]["ForProperty"]); country.Code = Connection.ToString(dt.Rows[0]["Code"]); } return(country); }
public static int GDSKeywordSave(CLayer.Country pcountry) { DataLayer.Country country = new DataLayer.Country(); return(country.GDSKeywordSave(pcountry)); }
public static int Save(CLayer.Country countrydata) { DataLayer.Country country = new DataLayer.Country(); countrydata.Validate(); return(country.Save(countrydata)); }