public List <GroupInfo> TotalAmountSellGroup(string GroupName) { using (DiscContext context = new DiscContext()) { string se = context.Bands.FirstOrDefault(b => b.Name == GroupName).Name; int c = context.Bands.Include("CDs").FirstOrDefault(b => b.Name == GroupName).CDs.Count; Console.WriteLine(); for (int i = 0; i < context.Bands.FirstOrDefault(b => b.Name == GroupName).CDs.Count; i++) { groups.Add(new GroupInfo { Name = context.Bands.Include("CDs").Include("CDs.Format").Include("CDs.Selling").Include("CDs.Selling.Seller").FirstOrDefault(b => b.Name == GroupName).CDs.ToList()[i].Name, Cd_Date = context.Bands.Include("CDs").Include("CDs.Format").Include("CDs.Selling").Include("CDs.Selling.Seller").FirstOrDefault(b => b.Name == GroupName).CDs.ToList()[i].Cd_Date, Format = context.Bands.Include("CDs").Include("CDs.Format").Include("CDs.Selling").Include("CDs.Selling.Seller").FirstOrDefault(b => b.Name == GroupName).CDs.ToList()[i].Format.Name, SellingCount = context.Bands.Include("CDs").Include("CDs.Format").Include("CDs.Selling").Include("CDs.Selling.Seller").FirstOrDefault(b => b.Name == GroupName).CDs.ToList()[i].Selling.Count() }); } Console.WriteLine(); return(groups); } }
public List <SellInfo> AllSellInfo() { List <SellInfo> sell = new List <SellInfo>(); using (DiscContext context = new DiscContext()) { int c = context.Sellings.Count(); for (int i = 0; i < c; i++) { sell.Add( new SellInfo { SellerName = context.Sellings.Include("CD").Include("Seller").ToList()[i].Seller.Name, BandName = context.Sellings.Include("CD").Include("Seller").Include("CD.Band").Include("CD.Format").ToList()[i].CD.Band.Name, CDName = context.Sellings.Include("CD").Include("Seller").Include("CD.Band").Include("CD.Format").ToList()[i].CD.Name, Cd_Date = context.Sellings.Include("CD").Include("Seller").Include("CD.Band").Include("CD.Format").ToList()[i].CD.Cd_Date, FormatName = context.Sellings.Include("CD").Include("Seller").Include("CD.Band").Include("CD.Format").ToList()[i].CD.Format.Name, DateTime = new DateTime(2018, 9, 5 + i) }); } } return(sell); }
public void AddSell(string discName, string cashier) { using (DiscContext context = new DiscContext()) { context.Sellings.Add(new Selling { CD = context.CDs.FirstOrDefault(s => s.Name == discName), Seller = context.Sellers.FirstOrDefault(s => s.Name == cashier) }); context.SaveChanges(); } }
public string MostPopularGroup() { using (DiscContext context = new DiscContext()) { int max = context.Bands.Include("CDs").Include("CDs.Format").Include("CDs.Selling").Include("CDs.Selling.Seller").Max(p => p.CDs.Max(r => r.Selling.Count())); string s = context.CDs.FirstOrDefault(p => p.Selling.Count == 2).Name; string str = context.Bands.FirstOrDefault(t => t.CDs.Select(i => i.Name).FirstOrDefault() == s).Name; //string fg = groups.FirstOrDefault(p => p.SellingCount == 2).Name; return(str); } }
private void AddDisc(SellInfo sellInfo, Band band) { using (DiscContext context = new DiscContext()) { context.CDs.Add( new CD { Name = sellInfo.CDName, Cd_Date = sellInfo.Cd_Date, Format = context.Formats.FirstOrDefault(f => f.Name == sellInfo.FormatName), Band = band }); context.SaveChanges(); } }
static void Main(string[] args) { using (DiscContext context = new DiscContext()) { try { Database.SetInitializer(new DiscInitializer()); context.Database.Initialize(true); Console.WriteLine("Database OK!"); } catch (Exception ex) { Console.WriteLine(ex.Message); } try { ServiceHost serviceHost = new ServiceHost(typeof(DiscInfo)); DiscInfo disc = new DiscInfo(); // disc.AllSellInfo(); //disc.TotalAmountSellGroup("Наутилус"); //disc.MostPopularGroup(); disc.ShowAllDiscs(); serviceHost.Open(); Console.WriteLine("Up and running!"); // ZodiacFind zodiacFind = new ZodiacFind(); //zodiacFind.FindWestHoroscope(new DateTime(2018,6,2)); Console.ReadLine(); serviceHost.Close(); Console.WriteLine("Service closed!"); } catch (Exception ex) { Console.WriteLine(ex.Message); } } }
public List <Disc> ShowAllDiscs() { List <Disc> discs = new List <Disc>(); using (DiscContext context = new DiscContext()) { for (int i = 0; i < context.CDs.Count(); i++) { discs.Add(new Disc { Name = context.CDs.Include("Format").Include("Band").ToList()[i].Name, BandName = context.CDs.Include("Format").Include("Band").ToList()[i].Band.Name, FormatName = context.CDs.Include("Format").Include("Band").ToList()[i].Format.Name, Cd_Date = context.CDs.Include("Format").Include("Band").ToList()[i].Cd_Date }); } return(discs); } }
private Band AddBand(string bandName, int bandDate) { using (DiscContext context = new DiscContext()) { Band band = new Band(); if (context.Bands.Any(p => p.Name == bandName)) { band = context.Bands.FirstOrDefault(p => p.Name == bandName); } else { band = new Band { Name = bandName, Year = bandDate }; context.Bands.Add(band); } return(context.Bands.AsEnumerable().Last()); } }