public void BindGrid() { var _db = new ProductContext(); IQueryable<Product> query = _db.Products; GridView1.DataSource = query; GridView1.DataBind(); }
public bool AddProduct(string productName, string description, string imagePath, string unitPrice, int labelID, string status, string unitInStock, string categoryID, string userID) { var newProduct = new Product(); newProduct.ProductName = productName; newProduct.Description = description; newProduct.ImagePath = imagePath; newProduct.UnitPrice = Convert.ToDouble(unitPrice); newProduct.LabelID = labelID; newProduct.Status = Convert.ToBoolean(status); newProduct.UnitInStock = Convert.ToInt16(unitInStock); newProduct.CategoryID = Convert.ToInt16(categoryID); newProduct.CreatedDate = DateTime.Now.Date; newProduct.CreatedBy = userID; newProduct.UnitsAvailable = Convert.ToInt16(unitInStock); newProduct.UnitsLock = 0; newProduct.Discount = 0; using (ProductContext _db = new ProductContext()) { // Add product to DB. _db.Products.Add(newProduct); _db.SaveChanges(); } return true; }
public IQueryable<Product> GetProducts() { var _db = new ProductContext(); IQueryable<Product> query = _db.Products; UserRoleActions user = new UserRoleActions(); return query; }
// The return type can be changed to IEnumerable, however to support // paging and sorting, the following parameters must be added: // int maximumRows // int startRowIndex // out int totalRowCount // string sortByExpression public IQueryable<MenStore.Models.OrderDetail> OrderHistory_GetData() { ProductContext _db = new ProductContext(); string userName = User.Identity.GetUserName(); IQueryable<OrderDetail> query = _db.OrderDetails.Where(p => p.Username == userName ); return query; }
public void GetNewProducts() { var _db = new ProductContext(); List<Product> query = new List<Product>(); query = _db.Products.Where(p => p.Status == true && p.UnitInStock > 0 && p.LabelID == 1).ToList(); query = query.OrderBy(i => i.CreatedDate).Take(4).ToList(); productList.DataSource = query; productList.DataBind(); }
public void GetSpecialProducts() { var _db = new ProductContext(); List<Product> query = new List<Product>(); query = _db.Products.Where(p => p.Status == true && p.UnitInStock > 0 && p.Discount != 0).ToList(); query = query.OrderByDescending(i => i.Discount).Take(4).ToList(); ProductListSpecial.DataSource = query; ProductListSpecial.DataBind(); }
public void GetBestSellerProducts() { var _db = new ProductContext(); ProductActions productAction = new ProductActions(); List<Product> query = new List<Product>(); query = _db.Products.Where(p => p.Status == true && p.UnitInStock > 0 && p.LabelID == 4).ToList(); query = query.OrderByDescending(i => productAction.GetUnitSold(i.ProductID)).Take(4).ToList(); productListBstSlr.DataSource = query; productListBstSlr.DataBind(); }
public bool DeleteProduct(int productID) { using (ProductContext _db = new ProductContext()) { var product = (from c in _db.Products where c.ProductID == productID select c).FirstOrDefault(); if (product != null) { _db.Products.Remove(product); _db.SaveChanges(); } return true; } }
internal bool UpdateCategory(int ID, string Name) { using (ProductContext _db = new ProductContext()) { var cat = _db.Categories.Where(c => c.CategoryID == ID).FirstOrDefault(); if (cat != null) { cat.CategoryName = Name; _db.SaveChanges(); return true; } } return false; }
protected void OrderHistory_DataBound(object sender, EventArgs e) { ProductContext _db = new ProductContext(); Order order = new Order(); for (int i = 0; i < OrderHistory.Rows.Count; i++) { int id = int.Parse(OrderHistory.Rows[i].Cells[0].Text); order = _db.Orders.Find(id); if (order.PaymentTransactionId == null) { OrderHistory.Rows[i].Visible = false; } } }
public void GetProducts(string search) { var _db = new ProductContext(); List<Product> query = new List<Product>(); if (!string.IsNullOrEmpty(search)) { query = _db.Products.Where(p => p.ProductName.Contains(search) && p.Status == true && p.UnitInStock > 0).ToList(); } else { query = null; } productList.DataSource = query; productList.DataBind(); }
internal bool AddCategory(string Name) { var newCategory = new Category(); newCategory.CategoryName = Name; using (ProductContext _db = new ProductContext()) { // Add product to DB. _db.Categories.Add(newCategory); _db.SaveChanges(); } return true; }
internal bool DeleteCategory(int ID) { using (ProductContext _db = new ProductContext()) { var myItem = (from c in _db.Categories where c.CategoryID == ID select c).FirstOrDefault(); if (myItem.Products.Count() > 0) { return false; } _db.Categories.Remove(myItem); _db.SaveChanges(); } return true; }
public int GetUnitSold(int Id) { ProductContext _db = new ProductContext(); Order order = new Order(); int quantity = 0; List<OrderDetail> lst = _db.OrderDetails.Where(p => p.ProductId == Id).ToList(); foreach (var item in lst) { order = _db.Orders.Where(p => p.OrderId == item.OrderId).FirstOrDefault(); if (order.PaymentTransactionId != null) { quantity += item.Quantity; } } return quantity; }
private static void CheckCart() { ProductContext _db = new ProductContext(); ShoppingCartActions cartActions = new ShoppingCartActions(); while (true) { foreach (var item in _db.ShoppingCartItems.ToList()) { if ((DateTime.Now - (DateTime)item.DateCreated ).TotalMinutes >= 20) { cartActions.RemoveItem(item.CartId, item.ProductId); } } _db.SaveChanges(); Thread.Sleep(5000); } }
public void GetProducts(string id) { var _db = new ProductContext(); ProductActions productAction = new ProductActions(); List<Product> query = new List<Product>(); int catID = 0; bool r = Int32.TryParse(id, out catID); if (r && catID > 0) { query = _db.Products.Where(p => p.CategoryID == catID && p.Status == true && p.UnitInStock > 0).ToList(); Title = _db.Categories.Where(c => c.CategoryID == catID).FirstOrDefault().CategoryName; } else if (id=="new") { query = _db.Products.Where(p => p.Status == true && p.UnitInStock > 0 && p.LabelID == 1).ToList(); query = query.OrderBy(i => i.CreatedDate).ToList(); Title = "Special Offer"; } else if (id == "bestseller") { query = _db.Products.Where(p => p.Status == true && p.UnitInStock > 0 && p.LabelID == 4).ToList(); query = query.OrderByDescending(i => productAction.GetUnitSold(i.ProductID)).ToList(); Title = "Best Sellers"; } else if (id == "special") { query = _db.Products.Where(p => p.Status == true && p.UnitInStock > 0 && p.Discount != 0).ToList(); query = query.OrderByDescending(i => i.Discount).ToList(); Title = "Special Offer"; } else { query = _db.Products.Where(p => p.Status == true && p.UnitInStock > 0).ToList(); Title = "Browse Products"; } productList.DataSource = query; productList.DataBind(); }
public bool UpdateProduct(int ID, string productName, string description, string imagePath, double unitPrice, bool status, double discount, int unitInStock, int categoryID, string userId) { using (ProductContext _db = new ProductContext()) { var product = _db.Products.Where(p => p.ProductID == ID).FirstOrDefault(); if (product != null) { product.ProductName = productName; product.Description = description; product.ImagePath = imagePath; product.UnitPrice = unitPrice; product.Status = status; product.UnitInStock = unitInStock; product.CategoryID = categoryID; product.ModifiedDate = DateTime.Now.Date; product.ModifiedBy = userId; product.UnitsAvailable = unitInStock - product.UnitsLock; product.Discount = discount; _db.SaveChanges(); } } return true; }
private static void CheckLabel() { ProductContext _db = new ProductContext(); ProductActions productAction = new ProductActions(); while (true) { foreach (var item in _db.Products.ToList()) { DateTime date = (DateTime)item.CreatedDate; DateTime newDate = DateTime.Now; // Difference in days, hours, and minutes. TimeSpan ts = newDate - date; // Difference in days. int differenceInDays = ts.Days; if (differenceInDays >= 365) { if (item.Discount<0.50) { item.Discount = 0.50; } item.LabelID = 3; } else if (productAction.GetUnitSold(item.ProductID) >= 1000) { item.LabelID = 4; } else if (differenceInDays >= 7) { item.LabelID = 2; } } _db.SaveChanges(); Thread.Sleep(5000); } }
public IQueryable<Product> GetProduct([QueryString("productID")] int? productId) { var _db = new ProductContext(); IQueryable<Product> query = _db.Products.Where(p => p.Status == true && p.UnitInStock > 0); query = query.Where(p => p.ProductID == productId); if (query.Count() > 0) { UserRoleActions user = new UserRoleActions(); lblCreatedBy.Text = user.GetUserNameById(query.ToList()[0].CreatedBy); lblCreatedDate.Text = ((DateTime)query.ToList()[0].CreatedDate).ToShortDateString(); if (query.ToList()[0].ModifiedBy != null) { lblModifyBy.Text = user.GetUserNameById(query.ToList()[0].ModifiedBy); lblModifyDate.Text = ((DateTime)query.ToList()[0].ModifiedDate).ToShortDateString(); proModifyby.Visible = true; } } else { query = null; } return query; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { NVPAPICaller payPalCaller = new NVPAPICaller(); string retMsg = ""; string token = ""; string PayerID = ""; NVPCodec decoder = new NVPCodec(); token = Session["token"].ToString(); bool ret = payPalCaller.GetCheckoutDetails(token, ref PayerID, ref decoder, ref retMsg); if (ret) { Session["payerId"] = PayerID; var myOrder = new Order(); myOrder.OrderDate = Convert.ToDateTime(decoder["TIMESTAMP"].ToString()); myOrder.Username = User.Identity.Name; myOrder.FirstName = decoder["FIRSTNAME"].ToString(); myOrder.LastName = decoder["LASTNAME"].ToString(); myOrder.Address = decoder["SHIPTOSTREET"].ToString(); myOrder.City = decoder["SHIPTOCITY"].ToString(); myOrder.State = decoder["SHIPTOSTATE"].ToString(); myOrder.PostalCode = decoder["SHIPTOZIP"].ToString(); myOrder.Country = decoder["SHIPTOCOUNTRYCODE"].ToString(); myOrder.Email = decoder["EMAIL"].ToString(); myOrder.Total = Convert.ToDecimal(decoder["AMT"].ToString()); // Verify total payment amount as set on CheckoutStart.aspx. try { decimal paymentAmountOnCheckout = Convert.ToDecimal(Session["payment_amt"].ToString()); decimal paymentAmoutFromPayPal = Convert.ToDecimal(decoder["AMT"].ToString()); if (paymentAmountOnCheckout != paymentAmoutFromPayPal) { Response.Redirect("CheckoutError.aspx?" + "Desc=Amount%20total%20mismatch."); } } catch (Exception) { Response.Redirect("CheckoutError.aspx?" + "Desc=Amount%20total%20mismatch."); } // Get DB context. ProductContext _db = new ProductContext(); // Add order to DB. _db.Orders.Add(myOrder); _db.SaveChanges(); // Get the shopping cart items and process them. using (MenStore.Logic.ShoppingCartActions usersShoppingCart = new MenStore.Logic.ShoppingCartActions()) { List<CartItem> myOrderList = usersShoppingCart.GetCartItems(); // Add OrderDetail information to the DB for each product purchased. for (int i = 0; i < myOrderList.Count; i++) { // Create a new OrderDetail object. var myOrderDetail = new OrderDetail(); myOrderDetail.OrderId = myOrder.OrderId; myOrderDetail.Username = User.Identity.Name; myOrderDetail.ProductId = myOrderList[i].ProductId; myOrderDetail.Quantity = myOrderList[i].Quantity; myOrderDetail.UnitPrice = Math.Round((double)(myOrderList[i].Product.UnitPrice - (myOrderList[i].Product.UnitPrice * myOrderList[i].Product.Discount)), 2); // Add OrderDetail to DB. //Product p = _db.Products.Find(myOrderList[i].ProductId); ////set units in stock and unlock units //p.UnitsLock -= myOrderList[i].Quantity; //p.UnitInStock -= myOrderList[i].Quantity; _db.OrderDetails.Add(myOrderDetail); _db.SaveChanges(); } // Set OrderId. Session["currentOrderId"] = myOrder.OrderId; // Display Order information. List<Order> orderList = new List<Order>(); orderList.Add(myOrder); ShipInfo.DataSource = orderList; ShipInfo.DataBind(); // Display OrderDetails. OrderItemList.DataSource = myOrderList; OrderItemList.DataBind(); } } else { Response.Redirect("CheckoutError.aspx?" + retMsg); } } }
internal Product GetProduct(int id) { ProductContext _db = new ProductContext(); return _db.Products.Find(id); }
public void Dispose() { if (_db != null) { _db.Dispose(); _db = null; } }
internal void UnlockUnits(int quantity, int id) { using (ProductContext _db = new ProductContext()) { Product p = _db.Products.Find(id); p.UnitsLock -= quantity; _db.SaveChanges(); } }
public void UpdateShoppingCartDatabase(String cartId, ShoppingCartUpdates[] CartItemUpdates) { using (var db = new ProductContext()) { try { int CartItemCount = CartItemUpdates.Count(); List<CartItem> myCart = GetCartItems(); foreach (var cartItem in myCart) { // Iterate through all rows within shopping cart list for (int i = 0; i < CartItemCount; i++) { if (cartItem.Product.ProductID == CartItemUpdates[i].ProductId) { if (CartItemUpdates[i].PurchaseQuantity < 1 || CartItemUpdates[i].RemoveItem == true) { RemoveItem(cartId, cartItem.ProductId); } else { UpdateItem(cartId, cartItem.ProductId, CartItemUpdates[i].PurchaseQuantity); } } } } } catch (Exception exp) { throw new Exception("ERROR: Unable to Update Cart Database - " + exp.Message.ToString(), exp); } } }
public void UpdateItem(string updateCartID, int updateProductID, int quantity) { using (var _db = new ProductContext()) { try { var myItem = (from c in _db.ShoppingCartItems where c.CartId == updateCartID && c.Product.ProductID == updateProductID select c).FirstOrDefault(); if (myItem != null) { int count = quantity; count -= myItem.Quantity; //if (count < 0) //{ // count *= (-1); //} LockUnits(count, updateProductID); myItem.Quantity = quantity; _db.SaveChanges(); } } catch (Exception exp) { throw new Exception("ERROR: Unable to Update Cart Item - " + exp.Message.ToString(), exp); } } }
public void RemoveItem(string removeCartID, int removeProductID) { using (var _db = new ProductContext()) { try { var myItem = (from c in _db.ShoppingCartItems where c.CartId == removeCartID && c.Product.ProductID == removeProductID select c).FirstOrDefault(); if (myItem != null) { // Remove Item. _db.ShoppingCartItems.Remove(myItem); UnlockUnits(myItem.Quantity, myItem.ProductId); _db.SaveChanges(); } } catch (Exception exp) { throw new Exception("ERROR: Unable to Remove Cart Item - " + exp.Message.ToString(), exp); } } }
internal Category GetCategory(int id) { ProductContext _db = new ProductContext(); return _db.Categories.Find(id); }
internal double GetCashCollected(int id) { ProductContext _db = new ProductContext(); Order order = new Order(); double cash = 0.00; List<OrderDetail> lst = _db.OrderDetails.Where(p => p.ProductId == id).ToList(); foreach (var item in lst) { order = _db.Orders.Where(p => p.OrderId == item.OrderId).FirstOrDefault(); if (order.PaymentTransactionId != null) { cash += (double)(item.UnitPrice * item.Quantity); } } return cash; }
protected string GetOrderDate(int id) { ProductContext _db = new ProductContext(); return _db.Orders.Where(o => o.OrderId == id).FirstOrDefault().OrderDate.ToShortDateString(); ; }
public IQueryable<Category> GetCategories() { var _db = new ProductContext(); IQueryable<Category> query = _db.Categories; return query; }