public IEnumerable <ComboBoxList> GetProductHelpList(int Id, string term)
{
var PurchaseIndent = new PurchaseIndentHeaderService(_unitOfWork).Find(Id);
var settings = new PurchaseIndentSettingService(_unitOfWork).GetPurchaseIndentSettingForDocument(PurchaseIndent.DocTypeId, PurchaseIndent.DivisionId, PurchaseIndent.SiteId);
string[] ProductTypes = null;
if (!string.IsNullOrEmpty(settings.filterProductTypes))
{
ProductTypes = settings.filterProductTypes.Split(",".ToCharArray());
}
else
{
ProductTypes = new string[] { "NA" };
}
var list = (from p in db.Product
where (string.IsNullOrEmpty(term) ? 1 == 1 : p.ProductName.ToLower().Contains(term.ToLower())) &&
(string.IsNullOrEmpty(settings.filterProductTypes) ? 1 == 1 : ProductTypes.Contains(p.ProductGroup.ProductTypeId.ToString()))
group new { p } by p.ProductId into g
select new ComboBoxList
{
PropFirst = g.Max(m => m.p.ProductName),
Id = g.Key,
// DocumentTypeName=g.Max(p=>p.p.DocumentTypeShortName)
}
).Take(20);
return(list.ToList());
}
public IEnumerable <MaterialPlanLineHelpListViewModel> GetPendingMaterialPlanHelpList(int Id, string term)
{
var PurchaseIndent = new PurchaseIndentHeaderService(_unitOfWork).Find(Id);
var settings = new PurchaseIndentSettingService(_unitOfWork).GetPurchaseIndentSettingForDocument(PurchaseIndent.DocTypeId, PurchaseIndent.DivisionId, PurchaseIndent.SiteId);
string[] contraDocTypes = null;
if (!string.IsNullOrEmpty(settings.filterContraDocTypes))
{
contraDocTypes = settings.filterContraDocTypes.Split(",".ToCharArray());
}
else
{
contraDocTypes = new string[] { "NA" };
}
var list = (from p in db.ViewMaterialPlanBalance
where (string.IsNullOrEmpty(term) ? 1 == 1 : p.MaterialPlanNo.ToLower().Contains(term.ToLower())) && p.BalanceQty > 0 &&
(string.IsNullOrEmpty(settings.filterContraDocTypes) ? 1 == 1 : contraDocTypes.Contains(p.DocTypeId.ToString()))
group new { p } by p.MaterialPlanHeaderId into g
select new MaterialPlanLineHelpListViewModel
{
DocNo = g.Max(m => m.p.MaterialPlanNo),
MaterialPlanHeaderId = g.Key,
DocumentTypeName = g.Max(m => m.p.DocType.DocumentTypeName)
// DocumentTypeName=g.Max(p=>p.p.DocumentTypeShortName)
}
).Take(20);
return(list.ToList());
}