protected void BuyCheck(object sender, CommandEventArgs e)
{
int discountcode = 0;
if (User.Identity.IsAuthenticated == false)
{
Response.Redirect("~/Login.aspx");
}
else
{
ShopCart mycart = new ShopCart();
mycart.BookID = Convert.ToInt32(e.CommandArgument);
mycart.SessionUser = User.Identity.Name;
foreach (Book x in db2.Books)
{
if (x.BookID == mycart.BookID)
{
mycart.ISBN = x.ISBN;
mycart.BookTitle = x.Title;
mycart.Price = Math.Round((double)x.Price, 2);
mycart.Discount = x.BookDiscount;
}
}
if (User.IsInRole("Silver"))
{
discountcode = 2;
}
else if (User.IsInRole("Gold"))
{
discountcode = 3;
}
else if (User.IsInRole("Platinium"))
{
discountcode = 5;
}
foreach (Discount d in db2.Discounts)
{
if (d.DiscountID == discountcode)
{
mycart.Discount += d.DiscountAmt;
}
}
foreach (ShopCart y in db2.ShopCarts)
{
if (y.BookID == mycart.BookID)
{
y.Quantity++;
y.Subtotal = y.Quantity * y.Price * (100 - y.Discount) / 100;
y.Subtotal = Math.Round(y.Subtotal, 2);
db2.SaveChanges();
return;
}
}
mycart.Quantity = 1;
mycart.Subtotal = mycart.Price * mycart.Quantity * (100 - mycart.Discount) / 100;
mycart.Subtotal = Math.Round(mycart.Subtotal, 2);
db2.ShopCarts.Add(mycart);
db2.SaveChanges();
}
}
public void DeleteOrder(int index)
{
string UserN = User.Identity.Name;
List <ShopCart> myshopcart = new List <ShopCart>();
foreach (ShopCart sc in db2.ShopCarts)
{
if (sc.SessionUser == UserN)
{
myshopcart.Add(sc);
}
}
ShopCart cartitem = myshopcart[index];
db2.ShopCarts.Remove(cartitem);
db2.SaveChanges();
myshopcart = db2.ShopCarts.ToList <ShopCart>();
grandtotal = 0;
foreach (ShopCart x in myshopcart)
{
grandtotal += x.Subtotal;
double temp = Math.Round((x.Discount / 100 * x.Quantity * x.Price), 2);
discounts += temp;
}
Label2.Text = "Total Savings : $" + discounts.ToString();
Label1.Text = "Grand Total : $" + grandtotal.ToString();
}
