/// <summary> /// Получение данных регионов /// </summary> /// <param name="db">БД</param> public IQueryable <Regions> RegionsFiltered(AddressSystemContext db) { var regions = from m in db.Regions select m; return(regions); }
/// <summary> /// Получение списка районов исходя из региона /// </summary> /// <param name="db">БД</param> /// <param name="regions">Список регионов</param> public SelectList AreasList(AddressSystemContext db, SelectList regions) { IQueryable <Areas> FilterAreas = db.Areas.Where(c => c.RegionId == Convert.ToInt32(regions.SelectedValue)); int AreaNum = FilterAreas.Count() == 0 ? 0 : FilterAreas.First().AreaId; SelectList areas = new SelectList(FilterAreas, "AreaId", "AreaName", AreaNum); return(areas); }
/// <summary> /// Получение списка ЭПС пунктов исходя из населенных пунктов /// </summary> /// <param name="db">БД</param> /// <param name="localities">Список населенных пунктов</param> public SelectList DistrictsList(AddressSystemContext db, SelectList localities) { IQueryable <Districts> FilterDistricts = db.Districts.Where(c => c.LocalityId == Convert.ToInt32(localities.SelectedValue)); int DistrictsNum = FilterDistricts.Count() == 0 ? 0 : FilterDistricts.First().DistrictId; SelectList districts = new SelectList(FilterDistricts, "DistrictId", "DistrictName", DistrictsNum); return(districts); }
/// <summary> /// Получение списка населенных пунктов исходя из районов /// </summary> /// <param name="db">БД</param> /// <param name="areas">Список районов</param> public SelectList LocalitiesList(AddressSystemContext db, SelectList areas) { IQueryable <Localities> FilterLocalities = db.Localities.Where(c => c.AreaId == Convert.ToInt32(areas.SelectedValue)); int LocalitiesNum = FilterLocalities.Count() == 0 ? 0 : FilterLocalities.First().LocalityId; SelectList localities = new SelectList(FilterLocalities, "LocalityId", "LocalityName", LocalitiesNum); return(localities); }
/// <summary> /// Получение списка домов исходя из улиц /// </summary> /// <param name="db">БД</param> /// <param name="streets">Список улиц</param> public SelectList HousesList(AddressSystemContext db, SelectList streets) { IQueryable <Houses> FilterHouses = db.Houses.Where(c => c.StreetId == Convert.ToInt32(streets.SelectedValue)); int HousesNum = FilterHouses.Count() == 0 ? 0 : FilterHouses.First().HouseId; SelectList houses = new SelectList(FilterHouses, "HouseId", "HouseNum", HousesNum); return(houses); }
/// <summary> /// Получение списка улиц исходя из ЭПС /// </summary> /// <param name="db">БД</param> /// <param name="districts">Список ЭПС</param> public SelectList StreetsList(AddressSystemContext db, SelectList districts) { IQueryable <Streets> FilterStreets = db.Streets.Where(c => c.DistrictId == Convert.ToInt32(districts.SelectedValue)); int StreetsNum = FilterStreets.Count() == 0 ? 0 : FilterStreets.First().StreetId; SelectList streets = new SelectList(FilterStreets, "StreetId", "StreetName", StreetsNum); return(streets); }
/// <summary> /// Получение данных районов /// </summary> /// <param name="db">БД</param> public IQueryable <DataAreas> AreasFiltered(AddressSystemContext db) { var areas = from p in db.Areas join c in db.Regions on p.RegionId equals c.RegionId orderby p.AreaId select new DataAreas { AreaId = p.AreaId, AreaName = p.AreaName, RegionName = c.RegionName, RegionId = c.RegionId }; return(areas); }
/// <summary> /// Получение данных населенных пунктов /// </summary> /// <param name="db">БД</param> public IQueryable <DataLocalities> LocalitiesFiltered(AddressSystemContext db) { var localities = from p in db.Localities join b in db.Areas on p.AreaId equals b.AreaId join c in db.Regions on b.RegionId equals c.RegionId orderby p.LocalityId select new DataLocalities { LocalityId = p.LocalityId, LocalityName = p.LocalityName, AreaId = p.AreaId, AreaName = b.AreaName, RegionName = c.RegionName, RegionId = c.RegionId }; return(localities); }
/// <summary> /// Получение данных ЭПС /// </summary> /// <param name="db">БД</param> public IQueryable <DataDistricts> DistrictsFiltered(AddressSystemContext db) { var districts = from p in db.Districts join a in db.Localities on p.LocalityId equals a.LocalityId join b in db.Areas on a.AreaId equals b.AreaId join c in db.Regions on b.RegionId equals c.RegionId orderby p.DistrictId select new DataDistricts { DistrictId = p.DistrictId, DistrictName = p.DistrictName, LocalityId = a.LocalityId, LocalityName = a.LocalityName, AreaId = b.AreaId, AreaName = b.AreaName, RegionName = c.RegionName, RegionId = c.RegionId }; return(districts); }
/// <summary> /// Получение данных улиц /// </summary> /// <param name="db">БД</param> public IQueryable <DataStreets> StreetsFiltered(AddressSystemContext db) { var streets = from d in db.Streets join p in db.Districts on d.DistrictId equals p.DistrictId join a in db.Localities on p.LocalityId equals a.LocalityId join b in db.Areas on a.AreaId equals b.AreaId join c in db.Regions on b.RegionId equals c.RegionId orderby d.StreetId select new DataStreets { StreetId = d.StreetId, StreetName = d.StreetName, DistrictId = p.DistrictId, DistrictName = p.DistrictName, LocalityId = a.LocalityId, LocalityName = a.LocalityName, AreaId = b.AreaId, AreaName = b.AreaName, RegionName = c.RegionName, RegionId = c.RegionId }; return(streets); }
/// <summary> /// Получение данных домов /// </summary> /// <param name="db">БД</param> public IQueryable <DataHouses> HousesFiltered(AddressSystemContext db) { var houses = from e in db.Houses join d in db.Streets on e.StreetId equals d.StreetId join p in db.Districts on d.DistrictId equals p.DistrictId join a in db.Localities on p.LocalityId equals a.LocalityId join b in db.Areas on a.AreaId equals b.AreaId join c in db.Regions on b.RegionId equals c.RegionId orderby e.HouseId select new DataHouses { HouseId = e.HouseId, HouseNum = e.HouseNum, Index = e.Index, Floors = e.Floors, Entrances = e.Entrances, Flats = e.Flats, StreetId = d.StreetId, StreetName = d.StreetName, DistrictId = p.DistrictId, DistrictName = p.DistrictName, LocalityId = a.LocalityId, LocalityName = a.LocalityName, AreaId = b.AreaId, AreaName = b.AreaName, RegionName = c.RegionName, RegionId = c.RegionId }; return(houses); }
/// <summary> /// Получение списка ЭПС пунктов исходя из населенных пунктов /// </summary> /// <param name="db">БД</param> /// <param name="OurLocalityId">Выбранный населенный пункт</param> /// <param name="OuDistrictId">Выбранный ЭПС по умолчанию</param> public SelectList DistrictsList(AddressSystemContext db, int OurLocalityId, int OuDistrictId) { SelectList districts = new SelectList(db.Districts.Where(c => c.LocalityId == OurLocalityId), "DistrictId", "DistrictName", OuDistrictId); return(districts); }
/// <summary> /// Получение списка населенных пунктов исходя из районов /// </summary> /// <param name="db">БД</param> /// <param name="OurAreaId">Выбранный район</param> /// <param name="OurLocalityId">Выбранный населенный пункт по умолчанию</param> public SelectList LocalitiesList(AddressSystemContext db, int OurAreaId, int OurLocalityId) { SelectList localities = new SelectList(db.Localities.Where(c => c.AreaId == OurAreaId), "LocalityId", "LocalityName", OurLocalityId); return(localities); }
/// <summary> /// Получение списка районов исходя из региона /// </summary> /// <param name="db">БД</param> /// <param name="OurRegId">Выбранный регион</param> /// <param name="OurAreaId">Выбранный район по умолчанию</param> public SelectList AreasList(AddressSystemContext db, int OurRegId, int OurAreaId) { SelectList areas = new SelectList(db.Areas.Where(c => c.RegionId == OurRegId), "AreaId", "AreaName", OurAreaId); return(areas); }
/// <summary> /// Получение списка регионов /// </summary> /// <param name="db">БД</param> /// <param name="RegionNum">Выбранный регион по умолчанию</param> public SelectList RegionsList(AddressSystemContext db, int RegionNum) { SelectList regions = new SelectList(db.Regions, "RegionId", "RegionName", RegionNum); return(regions); }
/// <summary> /// Получение списка улиц исходя из ЭПС /// </summary> /// <param name="db">БД</param> /// <param name="OuDistrictId">Выбранный ЭПС</param> /// <param name="OuStreetId">Выбранная улица по умолчанию</param> public SelectList StreetsList(AddressSystemContext db, int OuDistrictId, int OuStreetId) { SelectList streets = new SelectList(db.Streets.Where(c => c.DistrictId == OuDistrictId), "StreetId", "StreetName", OuStreetId); return(streets); }