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 HeaderTransaction searchByPaymentID(int paymentID)
{
return(HeaderTransactionRepository.searchByPaymentID(paymentID));
}
//ngambil smua
public static List <HeaderTransaction> getAllHeaderTransaction()
{
return(HeaderTransactionRepository.getAll());
}
//ngambil per id
public static HeaderTransaction getTransaction(int transactionId)
{
return(HeaderTransactionRepository.getTransaction(transactionId));
}
public static int insertHT(int userID, int paymentTypeID)
{
int transactionID = HeaderTransactionRepository.insertHeaderTransaction(userID, paymentTypeID);
return(transactionID);
}