public void Refresh() { var db = new SpecificationDbEntities(); Values = new List <MaterialBase>(); List <Model.Material> materials; switch (Value.TypeID) { case (int)NMaterialGenerateType.ByMaterialAdministrator: materials = db.Materials.Where(x => Value.CategoryID0 > 0 && Value.CategoryID0 == x.CategoryID0 && (Value.CategoryID1 == 0 || x.CategoryID1 == Value.CategoryID1) && (Value.CategoryID2 == 0 || x.CategoryID2 == Value.CategoryID2) && (Value.CategoryID3 == 0 || x.CategoryID3 == Value.CategoryID3) && x.TypeID == 0 ).ToList(); break; //case (int)NMaterialGenerateType.ByWorker: //case (int)NMaterialGenerateType.ByEstimator: default: materials = db.Materials.Where(x => x.TypeID == Value.TypeID).ToList(); break; } materials = materials.OrderBy(x => x.MaterialCategory1.CategoryName) .ThenBy(x => x.MaterialCategory2.CategoryName) .ThenBy(x => x.MaterialCategory3.CategoryName) .ThenBy(x => x.MaterialCategory4.CategoryName) .ToList(); foreach (var material in materials) { var mb = new MaterialBase(material); Values.Add(mb); } }
public void Refresh(SpecDomain.Model.Material material) { //Value Value = material; //Values var db = new SpecificationDbEntities(); Values = new List <MaterialBase>(); var materials = db.Materials.Where(x => Value.CategoryID0 > 0 && Value.CategoryID0 == x.CategoryID0 && (Value.CategoryID1 == 0 || x.CategoryID1 == Value.CategoryID1) && (Value.CategoryID2 == 0 || x.CategoryID2 == Value.CategoryID2) && (Value.CategoryID3 == 0 || x.CategoryID3 == Value.CategoryID3) ).OrderBy(x => x.MaterialCategory1.CategoryName) .ThenBy(x => x.MaterialCategory2.CategoryName) .ThenBy(x => x.MaterialCategory3.CategoryName) .ThenBy(x => x.MaterialCategory4.CategoryName) .ToList(); foreach (var m in materials) { var mb = new MaterialBase(m); Values.Add(mb); } //Dropdownlist var temp0 = db.MaterialCategory0.Where(x => x.CategoryID >= 0) .OrderBy(x => x.CategoryName) .ToList(); Categories0 = temp0.Select(x => new SelectListItem { Value = Convert.ToString(x.CategoryID), Text = x.CategoryName }); }