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