public static void newTransactionDetail(int transactionID, int productID, int quantity)
{
DetailTransaction dt = DetailTransactionFactory.addNewDetail(transactionID, productID, quantity);
db.DetailTransactions.Add(dt);
db.SaveChanges();
}
public static void doInsertDetailTransaction(int transactionId, int productId, int qty)
{
DetailTransaction dt = DetailTransactionFactory.createDetailTransaction(transactionId, productId, qty);
db.DetailTransactions.Add(dt);
db.SaveChanges();
}
public static void insertDetailTransaction(int transactionID, int productID, int quantity)
{
DetailTransaction dt = DetailTransactionFactory.addDetailTransaction(transactionID, productID, quantity);
dbEntity.DetailTransactions.Add(dt);
dbEntity.SaveChanges();
}
public static void insertDetailTransaction(int TransactionID, int UserID, int Quantity)
{
DetailTransaction dt = DetailTransactionFactory.createDetailTransaction(TransactionID, UserID, Quantity);
Database1Entities db = new Database1Entities();
db.DetailTransactions.Add(dt);
db.SaveChanges();
}
public void InsertDTransaction(int transactionID, int userID)
{
List <Cart> cartByUserID = new CartRepository().GetCartByUserId(userID);
foreach (var item in cartByUserID)
{
DetailTransaction newDT = new DetailTransactionFactory().CreateDetailTransaction(transactionID, item.ProductID, item.Quantity);
new DetailTransactionRepository().InsertDTransaction(newDT);
}
}
public static void checkOut(int userId, string paymentType)
{
List <vCart> cartData = CartRepository.read(userId);
int paymentId = PaymentTypeRepository.findPayment(paymentType).PaymentTypeId;
int transactionId = TransactionRepository.insertHeaderTransaction
(HeaderTransactionFactory.newHeader(userId, paymentId)).TransactionID;
foreach (vCart item in cartData)
{
int productId = item.Product_Id;
int qty = item.Quantity;
TransactionRepository.insertDetailTransaction(DetailTransactionFactory.createDetail(transactionId, productId, qty));
CartRepository.delete(userId, productId);
int currentStock = ProductRepository.findProductDetail(productId).Stock - qty;
ProductRepository.updateStock(productId, currentStock);
}
}
