public static IQueryable <Region> GetRegions(int countryId) { try { using (var db = new Models.FatWatchEntities()) { return(db.Regions.Where(x => x.CountryId == countryId)); } } catch (System.Exception ex) { return(null); } }
// private FatWatchEntities db = new FatWatchEntities(); public static IQueryable <Country> GetCountries() { try { using (var db = new Models.FatWatchEntities()) { return(db.Countries.AsQueryable()); } } catch (System.Exception ex) { return(null); } }
public static int SaveAddress(int cityId, string addressDetails) { try { //TODO: using (var db = new Models.FatWatchEntities()) { Address address = new Address() { CityId = cityId }; return(0); } } catch (System.Exception ex) { return(-1); } }
public static IQueryable <City> GetCities(int regionId, int countryId) { IQueryable <City> cities = null; try { using (var db = new Models.FatWatchEntities()) { if (regionId == 0) { cities = db.Cities.Where(x => x.CountryId == countryId); } else { cities = db.Cities.Where(x => x.RegionId == regionId); } } } catch (System.Exception ex) { } return(cities); }