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