protected void btnPay_Click(object sender, EventArgs e)
{
OrderHeader order = new OrderHeader();
order.OrderDate = DateTime.Today;
order.Total = (decimal)total;
MembershipUser user = Membership.GetUser();
Guid UserID = (Guid)user.ProviderUserKey;
order.UserID = UserID.ToString();
//order.UserID = ""; //todo
order.Address = txtAddress.Text;
order.Email = txtEmail.Text;
order.PostalCode = Convert.ToInt32(txtPostCode.Text);
order.Name = txtName.Text;
using (BooksDB entities = new BooksDB())
{
entities.OrderHeaders.Add(order);
entities.SaveChanges();
foreach (OrderDetail orddet in lstOD)
{
OrderDetail odet = new OrderDetail();
odet.Qty = orddet.Qty;
odet.UnitPrice = orddet.UnitPrice;
odet.NetPrice = orddet.NetPrice;
odet.BookID = orddet.BookID;
odet.DiscountID = orddet.DiscountID;
odet.OrderID = order.OrderID;
entities.OrderDetails.Add(odet);
Book b = new Book();
b = entities.Books.Where(x => x.BookID == odet.BookID).FirstOrDefault(); //todo
b.Stock -= odet.Qty;
entities.SaveChanges();
}
}
Session["cart_items"] = null;
Response.Redirect("ConfirmOrder.aspx?orderid=" + order.OrderID);
}
public static void AddOrder(OrderHeader o, List <OrderDetail> od)
{
using (BooksDB entities = new BooksDB())
{
entities.OrderHeaders.Add(o);
entities.SaveChanges();
foreach (OrderDetail orddet in od)
{
OrderDetail odet = new OrderDetail();
odet.Qty = orddet.Qty;
odet.UnitPrice = orddet.UnitPrice;
odet.NetPrice = orddet.NetPrice;
odet.BookID = orddet.BookID;
odet.DiscountID = orddet.DiscountID;
odet.OrderID = o.OrderID;
entities.OrderDetails.Add(odet);
}
entities.SaveChanges();
}
}
public static void UpdateBook(Book book)
{
BooksDB bdb = new BooksDB();
Book b = bdb.Books.Where(x => x.BookID == book.BookID).First();
b.Title = book.Title;
b.Price = book.Price;
b.Stock = book.Stock;
b.Author = book.Author;
b.BookID = book.BookID;
b.CategoryID = book.CategoryID;
b.ISBN = book.ISBN;
//b.Title = b.Title.Replace(s, title);
bdb.SaveChanges();
}