protected void CheckoutBtn_Click(object sender, EventArgs e)
{
int tempUserID = Convert.ToInt32(Session["UserID"]);
DateTime Date = DateTime.Now;
HeaderTransactionRepository.insertHeaderTransaction(tempUserID, Date);
HeaderTransaction LastTransaction = db.HeaderTransactions.Where(lt => lt.UserID == tempUserID).OrderByDescending(lt => lt.TransactionID).FirstOrDefault();
int TransactionID = LastTransaction.TransactionID;
for (int i = 0; i < CartGridView.Rows.Count; i++)
{
int BookID = Int32.Parse(CartGridView.Rows[i].Cells[2].Text);
int Quantity = Int32.Parse(CartGridView.Rows[i].Cells[4].Text);
DetailTransactionRepository.insertDetailTransaction(TransactionID, BookID, Quantity);
}
for (int i = 0; i < CartGridView.Rows.Count; i++)
{
Cart cart = db.Carts.Where(c => c.UserID == tempUserID).FirstOrDefault();
db.Carts.Remove(cart);
db.SaveChanges();
}
Response.Redirect("/Views/MemberTransactionHistory.aspx");
}
} // buat checkout
public static int insertTransaction(int userID, DateTime date, int paymentTypeID)
{
DateTime currDate = DateTime.Now;
int User = userID;
int transactionID = HeaderTransactionRepository.newTransaction(userID, currDate, paymentTypeID);
List <Cart> cartlist = getCart();
foreach (Cart cart in cartlist)
{
int productID = ProductRepository.getproductId(cart.productID);
DetailTransactionRepository.newTransactionDetail(transactionID, productID, cart.Quantity);
}
return(transactionID);
}
public static DetailTransaction searchDetailTransactionByID(int id)
{
return(DetailTransactionRepository.searchByID(id));
}
public static List <DetailTransaction> getDetailTransaction(int transactionId)
{
return(DetailTransactionRepository.getDetailTransaction(transactionId));
}
public static void insertDT(int transactionID, int productID, int quantity)
{
DetailTransactionRepository.insertDetailTransaction(transactionID, productID, quantity);
}
