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));
}
