public IQueryable <Product> FetchProducts() { SrvContext dbCtx = new SrvContext(); if ((this.category_id > 0) && (dbCtx.Categories .Where(el => el.CategoryID == category_id)) .Count() == 1) { ltlCategory.Text = dbCtx.Categories .Where(el => el.CategoryID == category_id) .Select(el => el.Name) .First(); return(dbCtx.Products .Where(el => el.CategoryID == category_id) .OrderBy(el => el.Name)); } else { if (!(string.IsNullOrEmpty(Request.QueryString["q"]))) { string q = Request.QueryString["q"].ToString(); ltlCategory.Text = ("Search : " + q); return(dbCtx.Products .Where(el => el.Name.Contains(q) || el.Description.Contains(q)) .OrderBy(el => el.Name)); } else { return(dbCtx.Products .Where(el => el.IsFeatured) .OrderByDescending(el => el.CategoryID)); } } }
protected void Page_Load(object sender, EventArgs e) { int.TryParse(Request.QueryString["product_id"], out product_id); SrvContext dbCtx = new SrvContext(); if ((product_id > 0) && (dbCtx.Products .Where(el => (el.ProductID == product_id)) .Count() == 1)) { WebFormsCommerceDemo.Models.Product currProduct = dbCtx.Products .Where(el => el.ProductID == product_id) .First(); ltlProductName.Text = currProduct.Name; ltlPrice.Text = string.Format("{0:C}", currProduct.UnitPrice); ltlDescription.Text = currProduct.Description; imgProduct.ImageUrl = currProduct.ImagePath; if (!currProduct.IsAvailable) { lblStock.CssClass = lblStock.CssClass.Replace("label-success", "label-danger"); lblStock.Text = "Unavailable"; btnAddToCart.Disabled = true; } lnkCategory.PostBackUrl = ("/?category_id=" + currProduct.CategoryID); lnkCategory.Text = currProduct.Category.Name; } else { plhBreadCrumbs.Visible = false; plhProductDetails.Visible = false; plhProductDescription.Visible = false; plhNoContent.Visible = true; } }
public static bool doRemoveCartItem(int CartItemID) { Guid testId; bool t = false; if ((Guid.TryParse(Generics.IfNullString(Default.AppUserUniqueKey), out testId)) && (CartItemID > 0)) { SrvContext dbCtx = new SrvContext(); int CustomerID = dbCtx.Customers .Where(el => (el.UniqueKey == testId)) .Single() .CustomerID; if (dbCtx.CartItems.Where(el => (el.CartItemID == CartItemID) && (el.CustomerID == CustomerID)).Count() == 1) { CartItem ci = dbCtx.CartItems .Where(el => (el.CartItemID == CartItemID) && (el.CustomerID == CustomerID)) .Single(); dbCtx.CartItems.Remove(ci); try { t = (dbCtx.SaveChanges() > 0); } catch { ; } } } return(t); }
protected void Page_Load(object sender, EventArgs e) { if (Guid.TryParse(Generics.IfNullString(Default.AppUserUniqueKey), out testId)) { dbCtx = new SrvContext(); this.FetchOrderHistory(); } }
protected void Page_PreRender(object sender, EventArgs e) { if (!(IsPostBack) && (Generics.IfNullString(Request.QueryString["cart_added"]) == "true")) { SrvContext dbCtx = new SrvContext(); vwAddedCart.InnerText = vwAddedCart.InnerText.Replace("{{Product}}", dbCtx.Products.Where(el => (el.ProductID == product_id)).Single().Name); vwAddedCart.Visible = true; } }
protected void Page_Load(object sender, EventArgs e) { if (Guid.TryParse(Generics.IfNullString(Default.AppUserUniqueKey), out testId)) { dbCtx = new SrvContext(); this.FetchCartItems(); updCustomer = dbCtx.Customers.Where(el => (el.UniqueKey == testId)) .Single(); } }
protected void Page_InitComplete(object sender, EventArgs e) { Guid testId; string UserUUID = Generics.IfNullString(Default.AppUserUniqueKey); if (Guid.TryParse(UserUUID, out testId)) { dbCtx = new SrvContext(); updCustomer = dbCtx.Customers.Where(el => (el.UniqueKey == testId)) .Single(); } }
public static bool doUpdateCartItemQuantity(int CartItemID, byte quantity) { Guid testId; bool t = false; if (Guid.TryParse(Generics.IfNullString(Default.AppUserUniqueKey), out testId)) { SrvContext dbCtx = new SrvContext(); Customer cx = dbCtx.Customers .Where(el => (el.UniqueKey == testId)) .Single(); CartItem ci; if (dbCtx.CartItems .Where(el => (el.CustomerID == cx.CustomerID) && el.IsActive && (el.CartItemID == CartItemID)).Count() == 1) { ci = dbCtx.CartItems .Where(el => (el.CustomerID == cx.CustomerID) && el.IsActive && (el.CartItemID == CartItemID)) .Single(); if ((ci.Quantity > 0) && (ci.Quantity < 10)) { ci.Quantity = quantity; ci.ItemPrice = double.Parse(Generics.IfNullString(dbCtx.Products .Where(el => (el.ProductID == ci.ProductID)) .Single() .UnitPrice)) * ci.Quantity; if (Validator.TryValidateObject(ci, new ValidationContext(ci, serviceProvider: null, items: null), new List <ValidationResult>(), true)) { try { t = (dbCtx.SaveChanges() > 0); } catch { ; } } } } } return(t); }
public IQueryable <CartItem> FetchCartItems() { SrvContext dbCtx = new SrvContext(); IQueryable <CartItem> lstCartItems = dbCtx.CartItems .Where(el => (el.Customer.UniqueKey == testId) && el.IsActive); CartItemCount = lstCartItems.Count(); if (CartItemCount > 0) { CartItemTotal = lstCartItems.Select(el => el.ItemPrice).Sum(); vwCheckout.Visible = true; } return(lstCartItems); }
public IQueryable <CartItem> FetchCartItems() { Guid testId; Guid.TryParse(Generics.IfNullString(Default.AppUserUniqueKey), out testId); SrvContext dbCtx = new SrvContext(); IQueryable <CartItem> lstCartItems = dbCtx.CartItems .Where(el => (el.Customer.UniqueKey == testId) && el.IsActive); if (lstCartItems.Count() > 0) { vwNoItems.Visible = false; thCheckout.Visible = true; lvwCheckout.Visible = true; tfCheckout.Visible = true; TotalAmount = lstCartItems.Select(el => el.ItemPrice) .Sum(); } return(lstCartItems); }
protected void btnAddToCart_Click(object sender, CommandEventArgs e) { Guid testId; int ProductId = 0; if (Guid.TryParse(Generics.IfNullString(Default.AppUserUniqueKey), out testId) && int.TryParse(Generics.IfNullString(e.CommandArgument), out ProductId)) { if (Mediator.doAddCartItem(ProductId)) { SrvContext dbCtx = new SrvContext(); vwAddedCart.InnerText = vwAddedCart.InnerText.Replace("{{Product}}", dbCtx.Products.Where(el => (el.ProductID == ProductId)).Single().Name); } else { vwAddedCart.InnerText = "There was an error adding the product to your cart."; vwAddedCart.Attributes["class"] = vwAddedCart.Attributes["class"].Replace("-success", "-danger"); } vwAddedCart.Visible = true; } else { Response.Redirect("/Login/?logon=enabled"); } }
protected void Page_Load(object sender, EventArgs e) { dbCtx = new SrvContext(); }
public IQueryable <Category> FetchCategories() { SrvContext dbCtx = new SrvContext(); return(dbCtx.Categories); }