public static List <MegrendelesTetel> ListTetel(int megrendelesId) { using (CRMEntities oc = new CRMEntities()) { return((from m in oc.MegrendelesTetel.Include("Termek").Include("Statusz") where m.MegrendelesID == megrendelesId select m).ToList()); } }
public static List <string> ListVevo(string nev) { using (CRMEntities oc = new CRMEntities()) { return((from v in oc.Vevo where v.Nev.Contains(nev) select v.Nev).Distinct().ToList()); } }
public static List <Termek> Search(string nev, int minAr) { using (var ctx = new CRMEntities()) { return((from t in ctx.Termek.Include("Kategoria") where t.Nev.Contains(nev) && t.NettoAr >= minAr select t).ToList()); } }
public static List <Megrendeles> Search(string nev, DateTime fromDate, DateTime toDate) { using (CRMEntities oc = new CRMEntities()) { return((from m in oc.Megrendeles.Include("Statusz").Include("Telephely.Vevo") where m.Telephely.Vevo.Nev.Contains(nev) && m.Datum >= fromDate && m.Datum <= toDate orderby m.Telephely.Vevo.Nev select m).ToList()); } }