public static List <PopulationOfFemalePassenger> GetPopulationOfFemalePassenger(int year, int count = 225) { DateTime @from = new DateTime(year, 1, 1); DateTime to = from.AddYears(1); using (CosmeticFinalEntities context = (CosmeticFinalEntities)DbContextCreator.Create()) { var query = (from x in context.PassengerInfoes where x.Date >= @from && x.Date <= to group x by new { x.StationId, } into g select new { Id = g.Key.StationId, Year = g.FirstOrDefault().Date.Year, Name = g.FirstOrDefault().Station.Name, PassengerNumber = g.Sum(x => x.PopulationPerMonth) }).OrderByDescending(x => x.PassengerNumber).Take(count); var list = query.ToList(); List <PopulationOfFemalePassenger> listPopulation = new List <PopulationOfFemalePassenger>(); foreach (var x in list) { listPopulation.Add(new PopulationOfFemalePassenger(x.Year, x.PassengerNumber, x.Id, x.Name)); } return(listPopulation); } }
public static CosmeticFinalEntities Create() { CosmeticFinalEntities context = new CosmeticFinalEntities(ConnectionString); context.Configuration.ProxyCreationEnabled = false; return(context); }
public List <InformationNearStation> GetCompetitorStoreNumber(int stationId) { using (CosmeticFinalEntities context = DbContextCreator.Create()) { var query = from x in context.InformationNearStations where x.StationId == stationId select x; return(query.ToList()); } }