public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
GreigeProduction rpt = new GreigeProduction();
rpt.Site = this.Site;
return(rpt);
}
public IQueryable <TLKNI_GreigeProduction> SOHGreigeProduction(KnitQueryParameters parameters)
{
IQueryable <TLKNI_GreigeProduction> GreigeProduction;
if (!parameters.BoughtInFabric)
{
GreigeProduction = _context.TLKNI_GreigeProduction.Where(x => x.GreigeP_Captured && !x.GreigeP_Dye && x.GreigeP_weightAvail > 0 && !x.GreigeP_BoughtIn).AsQueryable();
}
else
{
GreigeProduction = _context.TLKNI_GreigeProduction.Where(x => x.GreigeP_Captured && !x.GreigeP_Dye && x.GreigeP_weightAvail > 0 && x.GreigeP_BoughtIn).AsQueryable();
}
if (parameters.Grade.Length != 0)
{
var GradePredicate = PredicateBuilder.False <TLKNI_GreigeProduction>();
GreigeProduction = GreigeProduction.AsExpandable().Where(x => x.GreigeP_Grade.Contains(parameters.Grade.ToUpper()));
}
if (parameters.Greiges.Count > 0)
{
var GreigePredicate = PredicateBuilder.False <TLKNI_GreigeProduction>();
foreach (var Greige in parameters.Greiges)
{
var temp = Greige;
GreigePredicate = GreigePredicate.Or(s => s.GreigeP_Greige_Fk == temp.TLGreige_Id);
}
GreigeProduction = GreigeProduction.AsExpandable().Where(GreigePredicate);
}
if (parameters.WhseStores.Count > 0)
{
var WhsePredicate = PredicateBuilder.False <TLKNI_GreigeProduction>();
foreach (var whse in parameters.WhseStores)
{
var temp = whse;
WhsePredicate = WhsePredicate.Or(s => s.GreigeP_Store_FK == temp.WhStore_Id);
}
GreigeProduction = GreigeProduction.AsExpandable().Where(WhsePredicate);
}
return(GreigeProduction);
}
