public bool AddCity(CityDto dto)
{
if (!this.db.Cities.Any(x => x.DeletedOn.HasValue == false && x.Name.Trim() == dto.Name.Trim()))
{
this.db.Cities.Add(new City
{
CreatedOn = DateTime.Now,
UpdatedOn=DateTime.Now,
UpdatedBy = dto.UpdatedBy,
Comment = dto.Comment,
Name = dto.Name,
GeoZoneId = dto.GeoZone.Id
});
this.db.SaveChanges();
return true;
}
return false;
}
public bool UpdateCity(CityDto dto)
{
var city = this.db.Cities.FirstOrDefault(x => x.DeletedOn.HasValue == false && x.Id == dto.Id);
if (city != null)
{
city.UpdatedOn = DateTime.Now;
city.UpdatedBy = dto.UpdatedBy;
city.Comment = dto.Comment;
city.Name = dto.Name;
city.GeoZoneId = dto.GeoZone.Id;
this.db.SaveChanges();
return true;
}
return false;
}