public ActionResult CheckOut()
{
List <shoppingcart> shoppingcartitems = new List <shoppingcart>();
product product = new product();
EmailService mail = new EmailService();
IdentityMessage message = new IdentityMessage();
var keys = Request.Form.AllKeys;
message.Destination = Request.Form.Get(keys[0]);
message.Subject = "Order confirmation Bright Yellow";
message.Body = "Thank you for your purchase. <br />You purchased the following items:";
using (new_testEntities db = new new_testEntities())
{
string userid = "0";
if (Request.IsAuthenticated)
{
userid = User.Identity.GetUserId();
}
shoppingcartitems = db.shoppingcart.Where(x => x.UserId == userid).ToList();
foreach (shoppingcart item in shoppingcartitems)
{
product = db.product.FirstOrDefault(x => x.ID == item.ProductId);
product.stock = product.stock - item.Quantity;
message.Body = message.Body + "<br />" + product.ProductName;
if (product.PurchasedQuantity == null)
{
product.PurchasedQuantity = 1;
}
product.PurchasedQuantity = product.PurchasedQuantity + item.Quantity;
db.SaveChanges();
db.shoppingcart.Remove(item);
db.SaveChanges();
int productid = item.ProductId;
int quantity = (int)item.Quantity;
DateTime date = DateTime.Now;
string productname = product.ProductName;
string imagePath = product.imagepath;
purchasehistory ph = new purchasehistory
{
ProductID = productid,
UserID = userid,
Quantity = quantity,
PurchaseDate = date,
ProductName = productname,
imagepath = imagePath
};
db.purchasehistory.Add(ph);
db.SaveChanges();
}
try
{
mail.SendAsync(message);
}
catch
{
}
}
return(View());
}
public ActionResult Minus_To_Cart(int id)
{
//Console.WriteLine("Add to shoppingcart is succesfully called");
int?ProductId;
ProductId = id;
using (new_testEntities db = new new_testEntities())
{
//user user = db.user.FirstOrDefault(x => x.ID == id);
shoppingcart Shoppingcart = db.shoppingcart.FirstOrDefault(x => x.ProductId == id);
Shoppingcart.Quantity -= 1;
db.SaveChanges();
if (Shoppingcart.Quantity <= 0)
{
db.shoppingcart.Remove(Shoppingcart);
db.SaveChanges();
}
return(RedirectToAction("Index", "Shoppingcart"));
}
}
//[HttpGet]
public ActionResult Add_To_Wishlist(int id)
{
//Console.WriteLine("Add to wishlist is succesfully called");
ID = id;
using (new_testEntities db = new new_testEntities())
{
//user user = db.user.FirstOrDefault(x => x.ID == id);
product product = db.product.FirstOrDefault(x => x.ID == id);
string userid = User.Identity.GetUserId();
wishlist Wishlist = db.wishlist.FirstOrDefault(x => x.ProductId == id && x.UserId == userid);
if (Wishlist == null)
{
db.wishlist.Add(new wishlist {
ProductId = product.ID, UserId = userid, Quantity = 1, ProductName = product.ProductName, Price = product.price, Imagepath = product.imagepath
});
db.SaveChanges();
}
else
{
Wishlist.Quantity += 1;
db.SaveChanges();
}
return(RedirectToAction("Index", "Wishlist"));
}
}
public ActionResult Minus_To_Wishlist(int id)
{
//Console.WriteLine("Add to wishlist is succesfully called");
int?ProductId;
ProductId = id;
using (new_testEntities db = new new_testEntities())
{
//user user = db.user.FirstOrDefault(x => x.ID == id);
wishlist Wishlist = db.wishlist.FirstOrDefault(x => x.ProductId == id);
Wishlist.Quantity -= 1;
db.SaveChanges();
if (Wishlist.Quantity <= 0)
{
db.wishlist.Remove(Wishlist);
db.SaveChanges();
}
return(RedirectToAction("Index", "Wishlist"));
}
}
public ActionResult Add_To_Cart(int id)
{
//Console.WriteLine("Add to wishlist is succesfully called");
int?ProductId;
ProductId = id;
using (new_testEntities db = new new_testEntities())
{
product product = db.product.FirstOrDefault(x => x.ID == id);
string userid = "0";
if (Request.IsAuthenticated)
{
userid = User.Identity.GetUserId();
}
shoppingcart shoppingcart = db.shoppingcart.FirstOrDefault(x => x.ProductId == id && x.UserId == userid);
wishlist Wishlist = db.wishlist.FirstOrDefault(x => x.ProductId == id);
if (shoppingcart == null)
{
db.shoppingcart.Add(new shoppingcart {
ProductId = Wishlist.ProductId, UserId = User.Identity.GetUserId(), Quantity = Wishlist.Quantity, ProductName = Wishlist.ProductName, Price = Wishlist.Price, Imagepath = Wishlist.Imagepath
});
db.SaveChanges();
}
else
{
shoppingcart.Quantity += Wishlist.Quantity;
db.SaveChanges();
}
return(RedirectToAction("Index", "Shoppingcart"));
}
}
public ActionResult Delete(int id)
{
using (new_testEntities db = new new_testEntities())
{
shoppingcart shoppingcart = db.shoppingcart.FirstOrDefault(x => x.ProductId == id);
db.shoppingcart.Remove(shoppingcart);
db.SaveChanges();
}
return(RedirectToAction("Index", "Shoppingcart"));
}
public ActionResult Create(FormCollection collection)
{
try
{
using (ApplicationDbContext db2 = new ApplicationDbContext())
{
if (User.IsInRole("Admin"))
{
// TODO: Add insert logic here
using (new_testEntities db = new new_testEntities())
{
product p = new product
{
price = Convert.ToDecimal(collection[11]),
imagepath = collection[9],
stock = 100,
Brand = collection[1],
Supplier = "testsupplier",
ProductName = collection[10]
};
ram r = new ram
{
ID = p.ID,
Brand = p.Brand,
CompositionOfMemory = collection[2],
MemoryType = collection[3],
Clockspeed = Convert.ToInt32(collection[4]),
CASlatency = Convert.ToInt32(collection[5]),
Voltage = (float)Convert.ToDouble(collection[6]),
MemoryModuleConnection = Convert.ToInt32(collection[7]),
MemorySuitableFor = collection[8],
ImagePath = p.imagepath,
Name = p.ProductName,
Price = p.price,
Ramsize = Convert.ToInt32(collection[12])
};
db.product.Add(p);
db.ram.Add(r);
db.SaveChanges();
}
}
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
// GET: Statistics/Delete/5
public ActionResult Delete(int id)
{
using (ApplicationDbContext db2 = new ApplicationDbContext())
{
if (User.IsInRole("Admin"))
{
using (new_testEntities db = new new_testEntities())
{
ram ram = db.ram.FirstOrDefault(r => r.ID == id);
product product = db.product.FirstOrDefault(p => p.ID == id);
db.ram.Remove(ram);
db.product.Remove(product);
db.SaveChanges();
}
}
}
return(RedirectToAction("Index"));
}
public ActionResult Edit(int id, FormCollection collection)
{
try
{
using (ApplicationDbContext db2 = new ApplicationDbContext())
{
if (User.IsInRole("Admin"))
{
using (new_testEntities db = new new_testEntities())
{
// TODO: Add update logic here
ram ram = db.ram.FirstOrDefault(r => r.ID == id);
product product = db.product.FirstOrDefault(p => p.ID == id);
ram.ImagePath = collection[10];
product.imagepath = collection[10];
ram.Brand = collection[2];
product.Brand = collection[2];
ram.CompositionOfMemory = collection[3];
ram.MemoryType = collection[4];
ram.Clockspeed = Convert.ToInt32(collection[5]);
ram.CASlatency = Convert.ToInt32(collection[6]);
ram.Voltage = (float)Convert.ToDouble(collection[7]);
ram.MemoryModuleConnection = Convert.ToInt32(collection[8]);
ram.MemorySuitableFor = collection[9];
ram.Name = collection[11];
product.ProductName = collection[11];
ram.Price = Convert.ToDecimal(collection[12]);
product.price = Convert.ToDecimal(collection[12]);
ram.Ramsize = Convert.ToInt32(collection[13]);
db.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
}
catch
{
return(View());
}
}