public List <Country> GetCountries() { using (PropertyHubContext context = new PropertyHubContext()) { return((from c in context.Countries select c).ToList()); } }
public List <Province> GetProvinces() { using (PropertyHubContext context = new PropertyHubContext()) { return((from c in context.Provinces select c).ToList()); } }
public Country GetCountry(int id) { using (PropertyHubContext context = new PropertyHubContext()) { return((from c in context.Countries where c.Id == id select c).FirstOrDefault()); } }
public Province GetProvince(int id) { using (PropertyHubContext context = new PropertyHubContext()) { return((from c in context.Provinces where c.Id == id select c).FirstOrDefault()); } }
public Country AddCountry(Country entity) { using (PropertyHubContext context = new PropertyHubContext()) { context.Add(entity); context.SaveChanges(); } return(entity); }
public List <Province> GetProvinces(Country country) { using (PropertyHubContext context = new PropertyHubContext()) { return((from c in context.Provinces .Include(c => c.Country) select c).ToList()); } }
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 List <City> GetCities(Country country) { using (PropertyHubContext context = new PropertyHubContext()) { return((from c in context.Cities .Include(c => c.Province.Country) where c.Province.Country.Id == country.Id select c).ToList()); } }
//City public City GetCities(int id) { using (PropertyHubContext context = new PropertyHubContext()) { return((from c in context.Cities .Include(c => c.Province) where c.Id == id select c).FirstOrDefault()); } }
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); }