public MaterialSearchJobCosting(int transactionID, int categoryID2)
{
var transaction = _db.JobCostingTransactions.Find(transactionID);
var materialID = transaction.MaterialID;
var filter = _db.Materials.Find(materialID);
var materials = _db.Materials.Where(x => filter.CategoryID0 > 0 &&
filter.CategoryID0 == x.CategoryID0 &&
(x.CategoryID1 == filter.CategoryID1 && filter.CategoryID1 > 0) &&
(categoryID2 == 0 || x.CategoryID2 == categoryID2)
).OrderBy(x => x.MaterialCategory1.CategoryName)
.ThenBy(x => x.MaterialCategory2.CategoryName)
.ThenBy(x => x.MaterialCategory3.CategoryName)
.ThenBy(x => x.MaterialCategory4.CategoryName)
.ToList();
Values = new List <SelectListItem>();
foreach (var material in materials)
{
var mb = new SelectListItem();
mb.Value = material.MaterialID.ToString("");
mb.Text = MaterialCommon.GetCategory3Name(material);
Values.Add(mb);
}
}
