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