public ActionResult GetAttributes(string ItemNumber, Guid?InfoTemplateID) { //var ProductAttributes = _db.GetProductAttributes(ItemNumber.Trim()).ToList(); //var Attributes = _db.GetProductAndCategoryAttributesAndValues(ItemNumber, InfoTemplateID).ToList(); //var AttributeSettings = _db.GetAttributeTypeSettings().ToList(); List <GetProductAttributesResult> ProductAttributes = null; List <GetProductAndCategoryAttributesAndValuesResult> Attributes = null; List <GetAttributeTypeSettingsResult> AttributeSettings = null; Parallel.Invoke(() => { var db = new DataEntryDataContext(); ProductAttributes = db.GetProductAttributes(ItemNumber.Trim()).ToList(); }, () => { var db = new DataEntryDataContext(); Attributes = db.GetProductAndCategoryAttributesAndValues(ItemNumber, InfoTemplateID).ToList(); }, () => { var db = new DataEntryDataContext(); AttributeSettings = db.GetAttributeTypeSettings().ToList(); }); return(GetAttributes(ProductAttributes, Attributes, AttributeSettings)); }
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 static void LogError(Exception ex) { string ConnectionString = ConfigurationManager.ConnectionStrings["DataEntryConnectionString"].ConnectionString; var db = new DataEntryDataContext(ConnectionString); db.CommandTimeout = 99999; var UserName = System.Web.HttpContext.Current.User.Identity.Name; db.InsertError(UserName, ex.Message, ex.StackTrace, ex.Source); }
protected void btnCheckOut_Click(object sender, EventArgs e) { var selectedBookID = 0; if (!string.IsNullOrWhiteSpace(Request.QueryString["bookID"])) { selectedBookID = int.Parse(Request.QueryString["bookID"]); } else { Utilities.setPageMessage("Please select a book.", Utilities.severity.error, Page.Master); return; } var dbOperations = new DataEntryDataContext(); var bookName = txtName.Text; var mobileNo = txtMobile.Text; var nationalID = txtNationalID.Text; var checkOutDate = DateTime.Parse(lblCheckOutDate.Text); var checkOutSummery = new CheckOutSummery(); checkOutSummery.Book.Id = selectedBookID; checkOutSummery.User.Id = dbOperations.GetUserIdByMobileNumber(mobileNo); checkOutSummery.CheckOutDate = checkOutDate; var result = dbOperations.InsertBorrowingInformation(checkOutSummery); if (result == 0) { Utilities.setPageMessage("Encountered an error while checking out.", Utilities.severity.error, Page.Master); return; } Utilities.setPageMessage("Book has been checked out in the name of " + txtName.Text, Utilities.severity.info, Page.Master); DisplayBookCheckOutHistory(selectedBookID); }
protected void btnCheckIn_Click(object sender, EventArgs e) { var dbOperations = new DataEntryDataContext(); var selectedBookID = 0; if (!string.IsNullOrWhiteSpace(Request.QueryString["bookID"])) { selectedBookID = int.Parse(Request.QueryString["bookID"]); } var result = dbOperations.UpdateSummery(selectedBookID); if (result == 0) { Utilities.setPageMessage("Encountered an error while checking in.", Utilities.severity.error, Page.Master); return; } Utilities.setPageMessage("Book has been checked in successfully.", Utilities.severity.info, Page.Master); }
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)); }