public void UpdateCity(CityModel cityModel) { DictionaryCity dictionaryCity = _untoldContext.DictionaryCity.Find(cityModel.DictionaryCityId); dictionaryCity.CityName = cityModel.CityName; dictionaryCity.CountyId = cityModel.CountyId; _untoldContext.SaveChanges(); }
public void insertCity(int id, int cityDistrictId, string cityCode, string cityName) { var idx = _electriccastleContext.DictionaryCity.Max(x => x.DictionaryCityId) + 1; var cities = new DictionaryCity { DictionaryCityId = idx, CityCode = cityCode, DictionaryCityName = cityName, DictionaryDistrictId = cityDistrictId }; _electriccastleContext.DictionaryCity.Add(cities); _electriccastleContext.SaveChanges(); }
public void AddCity(string Code, string Name, string county) { DictionaryCity current = new DictionaryCity(); current.DictionaryCityCode = Code; current.DictionaryCityName = Name; current.DictionaryCountyId = Int32.Parse(county); this._dbContext.DictionaryCity.Add(current); this._dbContext.SaveChanges(); }
public void updateCity(int cityId, string cityCode, string cityName, int cityDistrictId) { DictionaryCity updatecity = _electriccastleContext.DictionaryCity.Where(x => x.DictionaryCityId == cityId).FirstOrDefault(); updatecity.CityCode = cityCode; updatecity.DictionaryCityName = cityName; updatecity.DictionaryDistrictId = cityDistrictId; _electriccastleContext.DictionaryCity.Update(updatecity); _electriccastleContext.SaveChanges(); }
public void InsertCity(CityModel cityModel) { DictionaryCity dictionaryCity = new DictionaryCity() { DictionaryCityId = cityModel.DictionaryCityId, CityName = cityModel.CityName, CountyId = cityModel.CountyId }; _untoldContext.DictionaryCity.Add(dictionaryCity); _untoldContext.SaveChanges(); }
public String DeleteCity(int CityId) { string error = ""; try { DictionaryCity dictionaryCity = _untoldContext.DictionaryCity.Where(c => c.DictionaryCityId == CityId).FirstOrDefault(); _untoldContext.DictionaryCity.Remove(dictionaryCity); } catch (Exception e) { error += "error"; } _untoldContext.SaveChanges(); return(error); }