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());
}
}
