public static List <GetCategoriesResult> GetCategories(Guid?ParentID) { string ConnectionString = ConfigurationManager.ConnectionStrings["DataEntryConnectionString"].ConnectionString; DataEntryDataContext db = new DataEntryDataContext(ConnectionString); db.CommandTimeout = 99999; return(db.GetCategories(ParentID).ToList()); }
public ActionResult Product(string ItemNumber) { ProductModel Model = new ProductModel(); Model.ItemNumber = ItemNumber?.Trim(); if (Session["SearchResults"] != null) { var SearchResults = (List <GetProductsResult>)Session["SearchResults"]; Model.SearchResultIndex = SearchResults.FindIndex(s => s.ERPNumber == Model.ItemNumber); Model.SearchResultCount = SearchResults.Count(); if (Model.SearchResultIndex > 0) { Model.PreviousItemNumber = SearchResults[Model.SearchResultIndex - 1].ERPNumber; } if (Model.SearchResultIndex < Model.SearchResultCount - 1) { Model.NextItemNumber = SearchResults[Model.SearchResultIndex + 1].ERPNumber; } } //Model.ProductInfo = _db.GetProduct(Model.ItemNumber).FirstOrDefault(); //if (Model.ProductInfo != null) //{ // //Model.ProductAttributes = _db.GetProductAttributes(Model.ItemNumber).ToList(); // //Model.Categories = _db.GetCategories(null).ToList(); // //Model.InfoTemplates = _db.GetInfoTemplates().ToList(); // //Model.AllVariants = _db.GetAllVariants().ToList(); // //Model.Attributes = _db.GetProductAndCategoryAttributesAndValues(ItemNumber, Model.ProductInfo.InfoTemplateID).ToList(); // //Model.AttributeSettings = _db.GetAttributeTypeSettings().ToList(); // Parallel.Invoke(/*() => // { // var db = new DataEntryDataContext(); // Model.ProductAttributes = db.GetProductAttributes(Model.ItemNumber).ToList(); // },*/ // () => // { // var db = new DataEntryDataContext(); // Model.Categories = db.GetCategories(null).ToList(); // }, // () => // { // var db = new DataEntryDataContext(); // Model.InfoTemplates = db.GetInfoTemplates().ToList(); // }, // () => // { // var db = new DataEntryDataContext(); // Model.AllVariants = db.GetAllVariants().ToList(); // }/*, // () => // { // var db = new DataEntryDataContext(); // Model.Attributes = db.GetProductAndCategoryAttributesAndValues(ItemNumber, Model.ProductInfo.InfoTemplateID).ToList(); // }, // () => // { // var db = new DataEntryDataContext(); // Model.AttributeSettings = db.GetAttributeTypeSettings().ToList(); // }*/); //} Parallel.Invoke(() => { var db = new DataEntryDataContext(); Model.ProductInfo = db.GetProduct(Model.ItemNumber).FirstOrDefault(); }, () => { var db = new DataEntryDataContext(); Model.Categories = db.GetCategories(null).ToList(); }, () => { var db = new DataEntryDataContext(); Model.InfoTemplates = db.GetInfoTemplates().ToList(); }, () => { var db = new DataEntryDataContext(); Model.AllVariants = db.GetAllVariants().ToList(); }, () => { var db = new DataEntryDataContext(); Model.AllChemicals = db.GetAllChemicals().ToList(); }); Model.ProductChemicals = _db.GetProductChemicals(Model.ProductInfo.Id).ToList(); return(View(Model)); }