public static bool AddtoWlist(List <Product> products, string username) { BWAEntities context = new BWAEntities(); try { foreach (var item in products) { Wlist wishlistItem = new Wlist { itemID = item.ItemID, username = username, itemName = item.ItemName, itemPrice = item.Price }; context.Wlists.Add(wishlistItem); context.SaveChanges(); } return(true); } catch (InvalidOperationException) { return(false); } }
public static bool userCart(List <Product> products, string username) { BWAEntities context = new BWAEntities(); try { foreach (var item in products) { Cart cartItem = new Cart { cost = item.Price, productName = item.ItemName, itemID = item.ItemID, quantity = item.Quantity, username = username, total = item.Price * item.Quantity }; context.Carts.Add(cartItem); context.SaveChanges(); } return(true); } catch (InvalidOperationException ex) { ex.ToString(); return(false); } }
public ActionResult add_to_cart(string id) { BWAEntities context = new BWAEntities(); if (Session["cart"] == null) { List <Product> cart = new List <Product>(); cart.Add(context.Products.Single(x => x.ItemID == id)); Session["cart"] = cart; } else { List <Product> cart = (List <Product>)Session["cart"]; int a = addExistingItem(id); if (a == -1) { cart.Add(context.Products.Single(x => x.ItemID == id)); } else { cart[a].Quantity++; } Session["cart"] = cart; } return(View("Cart")); }
public static bool addItem(string itemID, string itemName, string itemDescription, int Stock, int discount, int price, string itemAvailability, string itemCategory) { BWAEntities context = new BWAEntities(); try { Product p = new Product(); p.ItemID = itemID; p.ItemName = itemName; p.ItemDescription = itemDescription; p.Stock = Stock; p.Discount = discount; p.Price = price; p.ItemAvailability = itemAvailability; p.ItemCategory = itemCategory; context.Products.Add(p); context.SaveChanges(); return(true); } catch (InvalidOperationException) { return(false); } }
public ActionResult resetPwdAction() { string username = Request["username"]; string password1 = Request["pwd1"]; string password2 = Request["pwd"]; if (!(username == "" && password2 == "")) { if (password1.Equals(password2)) { using (var context = new BWAEntities()) { context.Database.ExecuteSqlCommand("update Account set password='******' where username='******'"); context.SaveChanges(); //ViewBag.Message = "Successfully updated!"; //TempData["Success"] = "Successfully updated!"; return(RedirectToAction("../Account/login")); } } else { ViewBag.Message = "Passwords does not match!"; return(View("resetPassword")); } } else { ViewBag.Message = "Please enter valid fields!"; return(View("resetPassword")); } }
public ActionResult add_to_wishlist(string id) { BWAEntities context = new BWAEntities(); if (Session["wlist"] == null) { List <Product> wlist = new List <Product>(); wlist.Add(context.Products.Single(x => x.ItemID == id)); Session["wlist"] = wlist; } else { List <Product> wlist = (List <Product>)Session["wlist"]; int a = addExisting_wList_Item(id); if (a == -1) { wlist.Add(context.Products.Single(x => x.ItemID == id)); } else { wlist[a].Quantity++; } Session["wlist"] = wlist; } return(View("Wishlist")); }
public ActionResult women() { using (var context = new BWAEntities()) { var women_product = context.Products.SqlQuery("select * from Product where ItemCategory='Women'").ToList(); return(View(women_product)); } }
public ActionResult viewProducts() { using (var context = new BWAEntities()) { var prod = context.Products.SqlQuery("SELECT * FROM dbo.Product").ToList(); return(View(prod)); } }
public ActionResult totalSales() { using (var context = new BWAEntities()) { //var message = context.Carts.SqlQuery("SELECT SUM(total) FROM Cart"); ViewBag.Total = context.Carts.Sum(x => x.total); ViewBag.Total_Units = context.Carts.Sum(x => x.quantity); return(View()); } }
public ActionResult admin_Inbox() { var user = Session["userSession"]; using (var context = new BWAEntities()) { var message = context.Messages.SqlQuery("SELECT * FROM dbo.Message where reciever='" + user + "'").ToList(); return(View(message)); } }
public static bool UserIsValid(string username, string password) { BWAEntities context = new BWAEntities(); try { Account a = context.Accounts.Single(x => x.username == username && x.password == password); return(true); } catch (InvalidOperationException) { return(false); } }
public static bool remove_product(string id) { BWAEntities context = new BWAEntities(); try { Product m = context.Products.Single(a => a.ItemID == id); context.Products.Remove(m); context.SaveChanges(); return(true); } catch (InvalidOperationException) { return(false); } }
public static bool remove_mail(int id) { BWAEntities context = new BWAEntities(); try { Message m = context.Messages.Single(a => a.msgID == id); context.Messages.Remove(m); context.SaveChanges(); return(true); } catch (InvalidOperationException) { return(false); } }
public ActionResult view_Wlist() { try { var user = Session["userSession"]; using (var context = new BWAEntities()) { var wishlist_view = context.Products.SqlQuery("select * from Wlist where username='******'"); return(View("Wishlist", wishlist_view)); } } catch (InvalidOperationException oe) { ViewBag.wlistError = oe; return(View("../Product/Product")); } }
public static bool message_portal(int messageID, string username, string subject, string messageBody, string receive_end) { BWAEntities context = new BWAEntities(); try { Message m = new Message(); m.msgID = random_numberGen.randNumber(); m.username = username; m.subject = subject; m.messageDetail = messageBody; m.reciever = "*****@*****.**"; context.Messages.Add(m); context.SaveChanges(); return(true); } catch (InvalidOperationException) { return(false); } }
public static bool AddUser(int userID, string username, string shippingAddress, string cardNumber, string email, string password, string userType) { BWAEntities context = new BWAEntities(); try { Account a = new Account(); a.userID = random_numberGen.randNumber(); a.username = username; a.shippingAddress = shippingAddress; a.cardNumber = cardNumber; a.email = email; a.password = password; a.userType = "customer"; context.Accounts.Add(a); context.SaveChanges(); return(true); } catch (InvalidOperationException) { return(false); } }