public City GetCityById(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 List <City> GetCitys() { using (PropertyHubContext context = new PropertyHubContext()) { return((from c in context.Cities.Include(c => c.Province) select c).ToList()); } }
public PropertyType GetPropertyType(int Id) { using (PropertyHubContext context = new PropertyHubContext()) { return((from pt in context.PropertyTypes where pt.Id == Id select pt).FirstOrDefault()); } }
public List <Province> GetProvinces() { using (PropertyHubContext context = new PropertyHubContext()) { return((from c in context.Provinces.Include(c => c.Country) select c).ToList()); } }
public Province GetProvinceById(int Id) { using (PropertyHubContext context = new PropertyHubContext()) { return((from c in context.Provinces.Include(c => c.Country) where c.Id == Id select c).FirstOrDefault()); } }
public List <Role> GetRole() { using (PropertyHubContext context = new PropertyHubContext()) { return((from u in context.Roles select u).ToList()); } }
public List <Country> GetCountries() { using (PropertyHubContext context = new PropertyHubContext()) { return((from c in context.Countries select c).ToList()); } }
public List <PropertyType> GetPropertyTypes() { using (PropertyHubContext context = new PropertyHubContext()) { return((from pt in context.PropertyTypes select pt).ToList()); } }
public Country GetCountryById(int Id) { using (PropertyHubContext context = new PropertyHubContext()) { return((from c in context.Countries where c.Id == Id select c).FirstOrDefault()); } }
public List <User> GetUsers() { using (PropertyHubContext context = new PropertyHubContext()) { return((from u in context.Users select u).ToList()); } }
public void DeleteCity(City entity) { using (PropertyHubContext context = new PropertyHubContext()) { context.Remove(entity); context.SaveChanges(); } }
public void UpdateCountry(Country entity, int Id) { using (PropertyHubContext context = new PropertyHubContext()) { context.Countries.Update(entity); context.SaveChanges(); } }
public void AddCountry(Country entity) { using (PropertyHubContext context = new PropertyHubContext()) { context.Countries.Add(entity); context.SaveChanges(); } }
public List <PropertyFeature> GetFeatures() { using (PropertyHubContext context = new PropertyHubContext()) { return((from f in context.PropertyFeatures select f).ToList()); } }
public List <AdvType> GetAdvTypes() { using (PropertyHubContext context = new PropertyHubContext()) { return((from at in context.AdvTypes select at).ToList()); } }
//#region Property Adv Types //public List<PropertyType> GetPropertyTypes() //{ // using (PropertyHubContext context = new PropertyHubContext()) // { // return (from t in context.PropertyTypes // select t).ToList(); // } //} //public PropertyType GetPropertyType(int id) //{ // using (PropertyHubContext context = new PropertyHubContext()) // { // return (from pa in context.PropertyTypes // where pa.Id == id // select pa).FirstOrDefault(); // } //} //public PropertyType AddPropertyType(PropertyType type) //{ // using (PropertyHubContext context = new PropertyHubContext()) // { // context.Add(type); // context.SaveChanges(); // return type; // } //} //public PropertyType UpdatePropertyType(int idToSearch, PropertyType type) //{ // using (PropertyHubContext context = new PropertyHubContext()) // { // PropertyType found = (from t in context.PropertyTypes // where t.Id == idToSearch // select t).First(); // if (!(string.IsNullOrWhiteSpace(type.Name))) // { // found.Name = type.Name; // context.SaveChanges(); // } // return found; // } //} //public PropertyType DeletePropertyType(int idToSearch) //{ // using (PropertyHubContext context = new PropertyHubContext()) // { // PropertyType found = (from t in context.PropertyTypes // where t.Id == idToSearch // select t).First(); // context.Remove(found); // context.SaveChanges(); // return found; // } //} //#endregion #region Area Units public List <AreaUnit> GetAreaUnits() { using (PropertyHubContext context = new PropertyHubContext()) { return((from au in context.AreaUnits select au).ToList()); } }
public void DeleteCountry(Country entity, int Id) { using (PropertyHubContext context = new PropertyHubContext()) { context.Remove(entity); context.SaveChanges(); } }
public List <Neighborhood> GetNeighborhoods() { using (PropertyHubContext context = new PropertyHubContext()) { return((from c in context.HousingSchemes .Include(c => c.City) select c).ToList()); } }
public PropertyType AddPropertyTypr(PropertyType entity) { using (PropertyHubContext context = new PropertyHubContext()) { context.PropertyTypes.Add(entity); context.SaveChanges(); } return(entity); }
public List <AdvType> GetAdvsTypes() { using (PropertyHubContext context = new PropertyHubContext()) { List <AdvType> advTypes = (from t in context.AdvTypes select t).ToList(); return(advTypes); } }
public List <PropertyAreaUnit> GetPropertyAreaUnits() { using (PropertyHubContext context = new PropertyHubContext()) { List <PropertyAreaUnit> result = (from u in context.PropertyAreaUnits select u).ToList(); return(result); } }
public PropertyType DeletePropertyTypr(PropertyType entity) { using (PropertyHubContext context = new PropertyHubContext()) { context.PropertyTypes.Remove(entity); context.SaveChanges(); } return(entity); }
public User DeleteUser(User entity) { using (PropertyHubContext context = new PropertyHubContext()) { context.Users.Remove(entity); context.SaveChanges(); } return(entity); }
public void RejectAdv(PropertyAdv entity) { using (PropertyHubContext context = new PropertyHubContext()) { context.Entry(entity.Status).State = EntityState.Unchanged; context.Update(entity); context.SaveChanges(); } }
public void AddCity(City entity) { using (PropertyHubContext context = new PropertyHubContext()) { context.Entry(entity.Province).State = EntityState.Unchanged; context.Add(entity); context.SaveChanges(); } }
public List <User> GetUsers() { using (PropertyHubContext context = new PropertyHubContext()) { return((from u in context.Users .Include("Role") .Include("Address.City.Province.Country") select u).ToList()); } }
public Neighborhood GetNeighborhood(int id) { using (PropertyHubContext context = new PropertyHubContext()) { return((from c in context.HousingSchemes .Include(c => c.City) where c.Id == id select c).FirstOrDefault()); } }
public Neighborhood DeleteNeighborhood(int id) { using (PropertyHubContext context = new PropertyHubContext()) { Neighborhood found = context.Find <Neighborhood>(id); context.Remove(found); context.SaveChanges(); return(found); } }
public Neighborhood AddNeighborhood(Neighborhood entity) { using (PropertyHubContext context = new PropertyHubContext()) { context.Entry(entity.City).State = EntityState.Unchanged; context.Add(entity); context.SaveChanges(); return(entity); } }
public List <Neighborhood> GetNeighborhoods() { using (PropertyHubContext context = new PropertyHubContext()) { List <Neighborhood> areasList = (from a in context.Neighborhoods .Include(a => a.City.Province.Country) select a).ToList(); return(areasList); } }