public CountryModel UpdateCountry(CountryModel _objdata) { tbl_Countries _objCountry = new tbl_Countries(); try { using (newconecommerce dataContext = new newconecommerce()) { dataContext.Database.Connection.Open(); var _query = dataContext.tbl_Countries.Where(x => x.int_Id == _objdata.intCountryId).FirstOrDefault(); if (_query != null) { tbl_Countries _objTemp = new tbl_Countries(); _objTemp = dataContext.tbl_Countries.Where(x => x.int_Id == _objdata.intCountryId).FirstOrDefault(); _objTemp.v_country = _objdata.strCountryName; _objTemp.v_currency = _objdata.strCourncy; _objTemp.v_currency_symbol = _objdata.strCourncySymbol; dataContext.SaveChanges(); dataContext.Database.Connection.Close(); } _objdata.StatusMessaage = "Country updated sucessfully."; return(_objdata); } } catch (Exception) { throw; } }
public CountryModel DeleteCountry(int intCountryId) { CountryModel _objdata = new CountryModel(); tbl_Countries _objBrand = new tbl_Countries(); try { using (newconecommerce dataContext = new newconecommerce()) { dataContext.Database.Connection.Open(); var _query = dataContext.tbl_Countries.Where(x => x.int_Id == intCountryId).FirstOrDefault(); if (_query != null) { tbl_Countries _log = new tbl_Countries(); _log = dataContext.tbl_Countries.Where(x => x.int_Id == intCountryId).FirstOrDefault(); _log.b_IsActive = false; dataContext.SaveChanges(); dataContext.Database.Connection.Close(); } _objdata.StatusMessaage = "Country deleted sucessfully."; return(_objdata); } } catch (Exception ex) { throw ex; } }
public CountryModel SaveCountry(CountryModel _objdata) { tbl_Countries _objCountry = new tbl_Countries(); try { using (newconecommerce dataContext = new newconecommerce()) { dataContext.Database.Connection.Open(); _objCountry.v_country = _objdata.strCountryName; _objCountry.v_currency = _objdata.strCourncy; _objCountry.v_currency_symbol = _objdata.strCourncySymbol; _objCountry.b_IsActive = true; dataContext.tbl_Countries.Add(_objCountry); dataContext.SaveChanges(); dataContext.Database.Connection.Close(); _objdata.StatusMessaage = "Country save sucessfully."; return(_objdata); } } catch (Exception) { throw; } }
public tbl_Countries POST([FromBody] tbl_Countries countries) { using (ClaimyWebServies_dbEntities2 entity = new ClaimyWebServies_dbEntities2()) { entity.Configuration.ProxyCreationEnabled = false; entity.tbl_Countries.Add(countries); entity.SaveChanges(); return(countries); } }