public Country AddCountry(Country entity)
{
using (PropertyHubContext context = new PropertyHubContext())
{
context.Add(entity);
context.SaveChanges();
}
return(entity);
}
public Province AddProvince(Province entity)
{
using (PropertyHubContext context = new PropertyHubContext())
{
context.Entry(entity.Country).State = EntityState.Unchanged;
context.Add(entity);
context.SaveChanges();
}
return(entity);
}
public City AddCity(City entity)
{
using (PropertyHubContext context = new PropertyHubContext())
{
context.Entry(entity.Province).State = EntityState.Unchanged;
context.Add(entity);
context.SaveChanges();
}
return(entity);
}
public Country DeleteCountry(int idToSearch)
{
Country found = null;
using (PropertyHubContext context = new PropertyHubContext())
{
found = context.Find <Country>(idToSearch);
context.Remove(found);
context.SaveChanges();
}
return(found);
}
public Province DeleteProvince(int idToSearch)
{
Province found = null;
using (PropertyHubContext context = new PropertyHubContext())
{
found = context.Find <Province>(idToSearch);
context.Remove(found);
context.SaveChanges();
}
return(found);
}
public Province UpdateProvince(int idToSearch, Province entity)
{
Province found = null;
using (PropertyHubContext context = new PropertyHubContext())
{
found = context.Find <Province>(idToSearch);
found.Name = entity.Name;
if (entity.Country?.Id > 0)
{
found.Country = entity.Country;
}
context.SaveChanges();
}
return(found);
}
public Country UpdateCountry(int idToSearch, Country entity)
{
Country found = null;
using (PropertyHubContext context = new PropertyHubContext())
{
found = context.Find <Country>(idToSearch);
if (entity.Code.HasValue && entity.Code != 0)
{
found.Code = entity.Code;
}
if (!string.IsNullOrEmpty(entity.Name))
{
found.Name = entity.Name;
}
context.SaveChanges();
}
return(entity);
}
public Province UpdateProvince(int idToSearch, Province entity)
{
Province found = null;
using (PropertyHubContext context = new PropertyHubContext())
{
found = context.Provinces.Find(idToSearch);
if (!string.IsNullOrEmpty(entity.Name))
{
found.Name = entity.Name;
}
if (entity.Country?.Id != 0)
{
found.Country = entity.Country;
}
context.Entry(found.Country).State = EntityState.Unchanged;
context.SaveChanges();
}
return(found);
}
public City UpdateCity(int idToSearch, City neighborhood)
{
City found = null;
using (PropertyHubContext context = new PropertyHubContext())
{
found = context.Cities.Find(idToSearch);
if (!string.IsNullOrEmpty(neighborhood.Name))
{
found.Name = neighborhood.Name;
}
if (neighborhood.Province?.Id != 0)
{
found.Province = neighborhood.Province;
}
context.Entry(found.Province).State = EntityState.Unchanged;
context.SaveChanges();
}
return(neighborhood);
}