public List <T> GetAll() { using (var context = DbContextCreator.Create()) { return(context.Set <T>().ToList()); } }
public List <int> GetAllYears() { using (var context = DbContextCreator.Create()) { return(context.FootTraffics.Select(x => x.Date.Year).Distinct().ToList()); } }
public List <int> GetAllYears() { using (var context = DbContextCreator.Create()) { return(context.Revenues.Select(x => x.Month.Year).Distinct().ToList()); } }
public List <int> GetAllYears() { using (var context = DbContextCreator.Create()) { return(context.Satisfactions.Select(x => x.Year.Year).Distinct().ToList()); } }
public DateTime GetMaximumDate() { using (GothamSubwayEntities context = DbContextCreator.Create()) { return(context.FootTraffics.Select(x => x.Date).OrderByDescending(x => x).FirstOrDefault()); } }
public List <Revenue> GetByYear(int year) { using (var context = DbContextCreator.Create()) { return(context.Revenues.Where(x => x.Month.Year == year).ToList()); } }
public T GetByPK(K key) { using (DbContext context = DbContextCreator.Create()) { return(context.Set <T>().Find(key)); } }
public int GetCount() { using (var context = DbContextCreator.Create()) { return(context.Set <T>().Count()); } }
public void Delete(T entity) { using (var context = DbContextCreator.Create()) { context.Entry(entity).State = System.Data.Entity.EntityState.Deleted; context.SaveChanges(); } }
public void Insert(T entity) { using (var context = DbContextCreator.Create()) { context.Set <T>().Add(entity); context.SaveChanges(); } }
public List <SatisfactionCategory> GetUpperCategory() { using (GothamSubwayEntities context = DbContextCreator.Create()) { return(context.SatisfactionCategories .Where(x => x.UpperId == null) .OrderBy(x => x.SatisfactionCategoryId) .ToList()); } }
public List <ElectricityModel> GetModels() { using (GothamSubwayEntities context = DbContextCreator.Create()) { var query = from x in context.Electricities select new ElectricityModel { Usage = x.Usage, Bill = x.Bill }; return(query.ToList()); } }
public List <FootTrafficDurationSumModel> GetDurationSumModel() { using (GothamSubwayEntities context = DbContextCreator.Create()) { return((from x in context.FootTraffics select new FootTrafficDurationSumModel { Date = x.Date, StationId = x.StationId, TransferId = x.TransferId, Sum = x.BeforeSix + x.SixToSeven + x.SevenToEight + x.EightToNine + x.NineToTen + x.TenToEleven + x.ElevenToTwelve + x.TwelveToThirteen + x.ThirteenToFourteen + x.FourteenToFifteen + x.FifteenToSixteen + x.SixteenToSeventeen + x.SeventeenToEighteen + x.EighteenToNineteen + x.TwentyToTwentyOne + x.TwnetyOneToTwentyTwo + x.TwentyTwoToTwentyThree + x.TwentyThreeToTwentyFour + x.AfterTwentyFour }).ToList()); } }
public List <ElectricityItem> GetElectricity() { using (GothamSubwayEntities context = DbContextCreator.Create()) { var query = from x in context.Electricities orderby x.Month ascending select new ElectricityItem { Month = x.Month, Usage = x.Usage, Bill = x.Bill, }; List <ElectricityItem> items = query.ToList(); for (int i = 0; i < items.Count; i++) { ElectricityItem previousItem = items.Find(x => x.Month.Year == (items[i].Month.Year - 1) && x.Month.Month == items[i].Month.Month); if (previousItem == null) { items[i].UsageYoYRate = 0; items[i].BillYoYRate = 0; } else { items[i].UsageYoYRate = (items[i].Usage - previousItem.Usage) / (double)previousItem.Usage * 100.0; items[i].BillYoYRate = (items[i].Bill - previousItem.Bill) / (double)previousItem.Bill * 100.0; } } foreach (var x in items) { x.Monthdate = x.Month.ToString("MM"); } return(items); } }
public List <FootTrafficDurationAverageModel> GetDurationAverageModel(DateTime start, DateTime end) { using (GothamSubwayEntities context = DbContextCreator.Create()) { var query = from x in context.FootTraffics where (start <= x.Date && x.Date <= end) group x by new { StationId = x.StationId, TransferId = x.TransferId } into g select new { StationId = g.Key.StationId, TransferId = g.Key.TransferId, BeforeSix = g.Average(a => a.BeforeSix), SixToSeven = g.Average(a => a.SixToSeven), SevenToEight = g.Average(a => a.SevenToEight), EightToNine = g.Average(a => a.EightToNine), NineToTen = g.Average(a => a.NineToTen), TenToEleven = g.Average(a => a.TenToEleven), ElevenToTwelve = g.Average(a => a.ElevenToTwelve), TwelveToThirteen = g.Average(a => a.TwelveToThirteen), ThirteenToFourteen = g.Average(a => a.ThirteenToFourteen), FourteenToFifteen = g.Average(a => a.FourteenToFifteen), FifteenToSixteen = g.Average(a => a.FifteenToSixteen), SixteenToSeventeen = g.Average(a => a.SixteenToSeventeen), SeventeenToEighteen = g.Average(a => a.SeventeenToEighteen), EighteenToNineteen = g.Average(a => a.EighteenToNineteen), NineteenToTwenty = g.Average(a => a.NineteenToTwenty), TwentyToTwentyOne = g.Average(a => a.TwentyToTwentyOne), TwnetyOneToTwentyTwo = g.Average(a => a.TwnetyOneToTwentyTwo), TwentyTwoToTwentyThree = g.Average(a => a.TwentyTwoToTwentyThree), TwentyThreeToTwentyFour = g.Average(a => a.TwentyThreeToTwentyFour), AfterTwentyFour = g.Average(a => a.AfterTwentyFour) }; List <FootTrafficDurationAverageModel> footTrafficDurationAverageModels = new List <FootTrafficDurationAverageModel>(); foreach (var item in query) { footTrafficDurationAverageModels.Add(new FootTrafficDurationAverageModel() { StationId = item.StationId, TransferId = item.TransferId, Time = "6시이전", Average = item.BeforeSix }); footTrafficDurationAverageModels.Add(new FootTrafficDurationAverageModel() { StationId = item.StationId, TransferId = item.TransferId, Time = "6~7", Average = item.SixToSeven }); footTrafficDurationAverageModels.Add(new FootTrafficDurationAverageModel() { StationId = item.StationId, TransferId = item.TransferId, Time = "7~8", Average = item.SevenToEight }); footTrafficDurationAverageModels.Add(new FootTrafficDurationAverageModel() { StationId = item.StationId, TransferId = item.TransferId, Time = "8~9", Average = item.EightToNine }); footTrafficDurationAverageModels.Add(new FootTrafficDurationAverageModel() { StationId = item.StationId, TransferId = item.TransferId, Time = "9~10", Average = item.NineToTen }); footTrafficDurationAverageModels.Add(new FootTrafficDurationAverageModel() { StationId = item.StationId, TransferId = item.TransferId, Time = "10~11", Average = item.TenToEleven }); footTrafficDurationAverageModels.Add(new FootTrafficDurationAverageModel() { StationId = item.StationId, TransferId = item.TransferId, Time = "11~12", Average = item.ElevenToTwelve }); footTrafficDurationAverageModels.Add(new FootTrafficDurationAverageModel() { StationId = item.StationId, TransferId = item.TransferId, Time = "12~13", Average = item.TwelveToThirteen }); footTrafficDurationAverageModels.Add(new FootTrafficDurationAverageModel() { StationId = item.StationId, TransferId = item.TransferId, Time = "13~14", Average = item.ThirteenToFourteen }); footTrafficDurationAverageModels.Add(new FootTrafficDurationAverageModel() { StationId = item.StationId, TransferId = item.TransferId, Time = "14~15", Average = item.FourteenToFifteen }); footTrafficDurationAverageModels.Add(new FootTrafficDurationAverageModel() { StationId = item.StationId, TransferId = item.TransferId, Time = "15~16", Average = item.FifteenToSixteen }); footTrafficDurationAverageModels.Add(new FootTrafficDurationAverageModel() { StationId = item.StationId, TransferId = item.TransferId, Time = "16~17", Average = item.SixteenToSeventeen }); footTrafficDurationAverageModels.Add(new FootTrafficDurationAverageModel() { StationId = item.StationId, TransferId = item.TransferId, Time = "17~18", Average = item.SeventeenToEighteen }); footTrafficDurationAverageModels.Add(new FootTrafficDurationAverageModel() { StationId = item.StationId, TransferId = item.TransferId, Time = "18~19", Average = item.EighteenToNineteen }); footTrafficDurationAverageModels.Add(new FootTrafficDurationAverageModel() { StationId = item.StationId, TransferId = item.TransferId, Time = "19~20", Average = item.NineteenToTwenty }); footTrafficDurationAverageModels.Add(new FootTrafficDurationAverageModel() { StationId = item.StationId, TransferId = item.TransferId, Time = "20~21", Average = item.TwentyToTwentyOne }); footTrafficDurationAverageModels.Add(new FootTrafficDurationAverageModel() { StationId = item.StationId, TransferId = item.TransferId, Time = "21~22", Average = item.TwnetyOneToTwentyTwo }); footTrafficDurationAverageModels.Add(new FootTrafficDurationAverageModel() { StationId = item.StationId, TransferId = item.TransferId, Time = "22~23", Average = item.TwentyTwoToTwentyThree }); footTrafficDurationAverageModels.Add(new FootTrafficDurationAverageModel() { StationId = item.StationId, TransferId = item.TransferId, Time = "23~24", Average = item.TwentyThreeToTwentyFour }); footTrafficDurationAverageModels.Add(new FootTrafficDurationAverageModel() { StationId = item.StationId, TransferId = item.TransferId, Time = "24시이후", Average = item.AfterTwentyFour }); } return(footTrafficDurationAverageModels); } }
public List <SatisfactionModel> GetModels() { using (GothamSubwayEntities context = DbContextCreator.Create()) { List <Satisfaction> satisfactions = context.Satisfactions.ToList(); List <SatisfactionModel> models = new List <SatisfactionModel>(); foreach (var satisfaction in satisfactions) { models.AddRange(new List <SatisfactionModel>() { new SatisfactionModel() { SatisfactionCategoryId = satisfaction.SatisfactionCategoryId, SatisfactionCategory = satisfaction.SatisfactionCategory.Item, SatisfactionItem = "매우좋음", Persent = satisfaction.Excellent, ColorData = Color.FromArgb(96, 181, 204), Year = satisfaction.Year }, new SatisfactionModel() { SatisfactionCategoryId = satisfaction.SatisfactionCategoryId, SatisfactionCategory = satisfaction.SatisfactionCategory.Item, SatisfactionItem = "좋음", Persent = satisfaction.Good, ColorData = Color.FromArgb(230, 108, 125), Year = satisfaction.Year }, new SatisfactionModel() { SatisfactionCategoryId = satisfaction.SatisfactionCategoryId, SatisfactionCategory = satisfaction.SatisfactionCategory.Item, SatisfactionItem = "보통", Persent = satisfaction.Soso, ColorData = Color.FromArgb(107, 183, 109), Year = satisfaction.Year }, new SatisfactionModel() { SatisfactionCategoryId = satisfaction.SatisfactionCategoryId, SatisfactionCategory = satisfaction.SatisfactionCategory.Item, SatisfactionItem = "나쁨", Persent = satisfaction.Bad, ColorData = Color.FromArgb(240, 173, 0), Year = satisfaction.Year }, new SatisfactionModel() { SatisfactionCategoryId = satisfaction.SatisfactionCategoryId, SatisfactionCategory = satisfaction.SatisfactionCategory.Item, SatisfactionItem = "매우나쁨", Persent = satisfaction.Terrible, ColorData = Color.FromArgb(232, 134, 81), Year = satisfaction.Year }, }); } return(models); } }
public List <FootTrafficMonthlyTotalModel> GetMonthlyFootTraffics(int selectedYear, int stationNumber) { using (GothamSubwayEntities context = DbContextCreator.Create()) { var queryTime = from x in context.FootTraffics select new FootTrafficTotalModel { dailyTransferTotal = 0, monthlyTransferTotal = 0, date = x.Date, transferId = x.TransferId, stationId = x.StationId, beforeSix = x.BeforeSix, sixToSeven = x.SixToSeven, sevenToEight = x.SevenToEight, eightToNine = x.EightToNine, nineToTen = x.NineToTen, tenToEleven = x.TenToEleven, elevenToTwelve = x.ElevenToTwelve, twelveToThirteen = x.TwelveToThirteen, thirteenToFourteen = x.ThirteenToFourteen, fourteenToFifteen = x.FourteenToFifteen, fifteenToSixteen = x.FifteenToSixteen, sixteenToSeventeen = x.SixteenToSeventeen, seventeenToEighteen = x.SeventeenToEighteen, eighteenToNineteen = x.EighteenToNineteen, nineteenToTwenty = x.NineteenToTwenty, twentyToTwentyOne = x.TwentyToTwentyOne, twentyOneToTwentyTwo = x.TwnetyOneToTwentyTwo, twentyTwoToTwentyThree = x.TwentyTwoToTwentyThree, twentyThreeToTwentyFour = x.TwentyThreeToTwentyFour, afterTwentyFour = x.AfterTwentyFour }; queryTime = queryTime.Where(x => (x.date.Year == selectedYear) && (x.stationId == stationNumber)); // selected year에 해당하는 query 생성 var queryDailyTotalList = queryTime.ToList(); foreach (var item in queryDailyTotalList) { //일별 승 하차 합계 계산 item.dailyTransferTotal = item.beforeSix + item.sixToSeven + item.sevenToEight + item.eightToNine + item.nineToTen + item.tenToEleven + item.elevenToTwelve + item.twelveToThirteen + item.thirteenToFourteen + item.fourteenToFifteen + item.fifteenToSixteen + item.sixteenToSeventeen + item.seventeenToEighteen + item.eighteenToNineteen + item.nineteenToTwenty + item.twentyToTwentyOne + item.twentyOneToTwentyTwo + item.twentyTwoToTwentyThree + item.twentyThreeToTwentyFour + item.afterTwentyFour; } List <FootTrafficMonthlyTotalModel> footTrafficMonthlyTotalModels = new List <FootTrafficMonthlyTotalModel>(); foreach (var item in queryDailyTotalList) { FootTrafficMonthlyTotalModel find = footTrafficMonthlyTotalModels .Find(x => x.date.Year == item.date.Year && x.date.Month == item.date.Month && x.stationId == item.stationId && x.transferId == item.transferId); if (find == null) { find = new FootTrafficMonthlyTotalModel() { date = new DateTime(item.date.Year, item.date.Month, 1), stationId = item.stationId, transferId = item.transferId }; footTrafficMonthlyTotalModels.Add(find); } find.monthlytotal += item.dailyTransferTotal; } return(footTrafficMonthlyTotalModels); } }