Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- namespace ConsoleApp1
- {
- class Program
- {
- static void Main(string[] args)
- {
- //masodikFeladat();
- //harmadikFeladat();
- negyedikFeladat();
- Console.Read();
- }
- private static void negyedikFeladat()
- {
- //a
- using (var db = new HNQNL7Entities())
- {
- var fizetesMod = new FizetesMod
- {
- Mod = "Valamikor hozom",
- Hatarido = 99999
- };
- db.FizetesMod.Add(fizetesMod);
- db.SaveChanges();
- }
- //b
- using (var db = new HNQNL7Entities())
- {
- Console.WriteLine("\tb");
- var query = db.NepszeruTermek(5);
- foreach (var res in query)
- Console.WriteLine($"\tNév={res.Nev}\tRaktarkészlet={res.Raktarkeszlet}\tNettoAr={res.NettoAr}"); ;
- }
- }
- private static void harmadikFeladat()
- {
- //a
- using (var db = new HNQNL7Entities())
- {
- Console.WriteLine("\ta");
- var query = from t in db.Termek
- where t.Kategoria.Nev == "Építo elemek"
- select t;
- foreach (var res in query)
- {
- Console.WriteLine($"\tNév={res.Nev}\tRaktarkészlet={res.Raktarkeszlet}\tNettoAr={res.NettoAr}");
- res.NettoAr *= 1.1;
- }
- db.SaveChanges();
- query = from t in db.Termek
- where t.Kategoria.Nev == "Epito elemek"
- select t;
- foreach (var res in query)
- {
- Console.WriteLine($"\tNév={res.Nev}\tRaktarkészlet={res.Raktarkeszlet}\tNettoAr={res.NettoAr}");
- }
- }
- //b
- using (var db = new HNQNL7Entities())
- {
- Console.WriteLine("\tb");
- var query = from k in db.Kategoria
- where k.Nev == "Drága Játék"
- select k;
- var dragaJatek = query.SingleOrDefault();
- if (dragaJatek == null)
- {
- dragaJatek = new Kategoria { Nev = "Drága Játék" };
- }
- var query2 = from t in db.Termek
- where t.NettoAr > 8000
- select t;
- foreach (var res in query2)
- {
- res.Kategoria = dragaJatek;
- }
- db.SaveChanges();
- var query3 = from t in db.Termek
- where t.Kategoria.Nev == "Drága Játék"
- select t;
- foreach (var res in query3)
- {
- Console.WriteLine($"\tNév={res.Nev}\tRaktarkészlet={res.NettoAr}");
- }
- }
- }
- private static void masodikFeladat()
- {
- //a
- Console.WriteLine("\ta");
- using (var db = new HNQNL7Entities())
- {
- var qTermekRaktarKeszlet = from t in db.Termek
- where t.Raktarkeszlet > 30
- select t;
- foreach (var t in qTermekRaktarKeszlet)
- Console.WriteLine($"\t\tNév={t.Nev}\tRaktarkészlet={t.Raktarkeszlet}");
- }
- //b
- Console.WriteLine("\tb");
- using (var db = new HNQNL7Entities())
- {
- var qTermekRendeles = from t in db.Termek
- where t.MegrendelesTetel.Count >= 2
- select t;
- foreach (var t in qTermekRendeles)
- Console.WriteLine($"\t\tNév={t.Nev}\tMennyiség={t.Raktarkeszlet}");
- }
- //c
- Console.WriteLine("\tc");
- using (var db = new HNQNL7Entities())
- {
- var qMegrendelesOsszeg = from m in db.Megrendeles
- .Include("MegrendelesTetel")
- .Include("MegrendelesTetel.Termek")
- .Include("Telephely")
- .Include("Telephely.Vevo")
- where m.MegrendelesTetel.Sum(mt => mt.Mennyiseg * mt.NettoAr) > 30000
- select m;
- foreach (var m in qMegrendelesOsszeg)
- {
- Console.WriteLine($"\t\tNév={m.Telephely.Vevo.Nev}");
- foreach (var mt in m.MegrendelesTetel)
- Console.WriteLine($"\t\t\tTermék={mt.Termek.Nev}\tÁr={mt.NettoAr}\tDB={mt.Mennyiseg}");
- }
- }
- //d
- Console.WriteLine("\td");
- using (var db = new HNQNL7Entities())
- {
- var q = from t in db.Termek
- where t.NettoAr == db.Termek.Max(a => a.NettoAr)
- select t;
- foreach (var t in q)
- Console.WriteLine($"\t\tNév={t.Nev}\tMennyiség={t.NettoAr}");
- }
- //e
- Console.WriteLine("\te");
- using (var db = new HNQNL7Entities())
- {
- var q = from t1 in db.Telephely
- join t2 in db.Telephely on t1.Varos equals t2.Varos
- where t1.VevoID > t2.VevoID
- select new { V1 = t1.Vevo, V2 = t2.Vevo };
- foreach (var v in q)
- Console.WriteLine($"\t\tVevo1={v.V1.Nev}\tVevo2={v.V2.Nev}");
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement