public static DetailTransaction AddTransactionDetail(DetailTransaction transactionDetail) { db.DetailTransactions.Add(transactionDetail); db.SaveChanges(); return(transactionDetail); }
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 InsertNewDetailTrans(int transId, int productId, int quantity) { DetailTransaction detailTrans = TransactionFactory.CreateNewDetailTrans(transId, productId, quantity); db.DetailTransactions.Add(detailTrans); db.SaveChanges(); }
public static long getSubTotal(DetailTransaction dt) { long subTotal = 0; subTotal = dt.Quantity * dt.Product.Price; return(subTotal); }
public static void newTransactionDetail(int transactionID, int productID, int quantity) { DetailTransaction dt = DetailTransactionFactory.addNewDetail(transactionID, productID, quantity); db.DetailTransactions.Add(dt); db.SaveChanges(); }
public ActionResult DetailTransaction(string TransID) { TransactionHistoryDetailTableAdapter transactionDetail = new TransactionHistoryDetailTableAdapter(); DetailTransaction detail = new DetailTransaction(); try { int tranID = int.Parse(TransID); transactionDT = transactionDetail.GetData(tranID); DataRow data = transactionDT.Rows[0]; detail.Username = (string)data["Username"]; detail.TransactionTypeName = (string)data["TransactionTypeName"]; detail.Name = (string)data["Name"]; detail.TransactionContent = (string)data["TransactionContent"]; detail.Value = (int)data["Value"]; detail.InsertedDate = (DateTime)data["InsertedDate"]; detail.UpdatedBy = (string)data["UpdatedBy"]; detail.LastUpdated = (DateTime)data["LastUpdated"]; //detail.MealSetName = data.Field<string>("MealSetName"); detail.MealSetName = data["DishName"].ToString(); } catch (Exception ex) { Log.ErrorLog(ex.Message); return RedirectToAction("ListTransaction", "Transaction"); } return View(detail); }
public bool checkout(int userID, int paymentID) { HeaderTransaction header = new HeaderTransaction(); header.UserID = userID; header.PaymentTypesID = paymentID; header.Date = DateTime.Now; var head = db.HeaderTransactions.Add(header); if (head == null) { return(false); } db.SaveChanges(); var carts = cartRepository.GetCartByUser(userID); foreach (Cart item in carts) { DetailTransaction detail = new DetailTransaction(); detail.TransactionID = head.TransactionID; detail.ProductID = item.ProductID.Value; detail.Quantity = item.Quantity.Value; db.DetailTransactions.Add(detail); decreaseStock(item.ProductID.Value, item.Quantity.Value); cartRepository.deleteCart(item.ID); db.SaveChanges(); } return(true); }
public static void insertDetailTransaction(int transactionID, int productID, int quantity) { DetailTransaction dt = TransactionFactory.addDetailTransaction(transactionID, productID, quantity); dbEntity.DetailTransactions.Add(dt); dbEntity.SaveChanges(); }
private void button2_Click(object sender, EventArgs e) { if (dataGridView2.Rows.Count == 0) { MessageBox.Show("No laptop in cart!"); return; } for (int i = 0; i < dataGridView2.Rows.Count; i++) { HeaderTransaction ht = new HeaderTransaction(); DetailTransaction dtn = new DetailTransaction(); ht.TransactionID = transactionID; ht.UserID = currentUser; ht.TransactionDate = DateTime.Now.ToString(); dtn.TransactionID = transactionID; dtn.LaptopID = dataGridView2.CurrentRow.Cells[0].Value.ToString(); DataGridViewRow row = dataGridView2.Rows[0]; dtn.Quantity = Convert.ToInt32(row.Cells[2].Value.ToString()); de.HeaderTransactions.Add(ht); de.DetailTransactions.Add(dtn); de.SaveChanges(); dataGridView2.Rows.RemoveAt(0); } MessageBox.Show("Checkout Success"); loadCart(); }
protected DetailTransaction getDATA() { DetailTransaction apa = new DetailTransaction(); var detailTran = apa._DetailTransaction; var headerTran = apa.HeaderTransaction; List <Model.Header_Transaction> htList = new JavaScriptSerializer().Deserialize <List <Model.Header_Transaction> >(htController.getALLHTLIST()); foreach (Model.Header_Transaction obj in htList) { var tempHeader = headerTran.NewRow(); tempHeader["UserName"] = obj.User.Username; //TODO tempHeader["HeaderTransactionID"] = obj.HeaderTransactionID; //TODO headerTran.Rows.Add(tempHeader); List <Model.Detail_Transaction> dtList = new JavaScriptSerializer().Deserialize <List <Model.Detail_Transaction> >(dtController.GetDTBYHEADERID(obj.HeaderTransactionID)); foreach (Model.Detail_Transaction obj2 in dtList) { var dtRows = detailTran.NewRow(); dtRows["HeaderTransactionID"] = obj2.HeaderTransactionID; dtRows["ShoeName"] = obj2.Sho.ShoeName; dtRows["Quantity"] = obj2.Quantity; detailTran.Rows.Add(dtRows); } } return(apa); }
public static Boolean SimpanTransaksi(TransactionViewModel mdl) { try { //disimpan pertama adalah master //buat instanisasi mastertransaksi MasterTransaction masterTransaction = new MasterTransaction(); using (DataContext db = new DataContext()) { masterTransaction.NoFaktur = mdl.NoFaktur; masterTransaction.TransactionDate = mdl.TransactionDate; masterTransaction.Total = mdl.Total; masterTransaction.CashReturn = mdl.CashReturn; db.MasterTransaction.Add(masterTransaction); db.SaveChanges(); //menyimpan ke tabel mastertransaksi DetailTransaction detailTransaction = new DetailTransaction(); foreach (var item in mdl.TrxDetail) { detailTransaction.NoFaktur = mdl.NoFaktur; detailTransaction.BarangID = item.BarangID; detailTransaction.Quantity = item.Quantity; db.DetailTransaction.Add(detailTransaction); db.SaveChanges(); //menyimpandata } } return(true); } catch (Exception) { return(false); } }
public static DetailTransaction insertDetailTransaction(int headerId, int productId, int quantity) { DetailTransaction dt = TransactionFactory.insertDetailTransaction(headerId, productId, quantity); db.DetailTransactions.Add(dt); db.SaveChanges(); return(dt); }
public static DetailTransaction InsertDetailTransaction(int transactionId, int productId, int qty) { DetailTransaction dt = TransactionFactory.GetDetailTransaction(transactionId, productId, qty); db.DetailTransactions.Add(dt); db.SaveChanges(); return(dt); }
public static DetailTransaction InitDetail(String TransactionID, String ProductID, int Quantity) { DetailTransaction detail = new DetailTransaction(); detail.TransactionID = TransactionID; detail.ProductID = ProductID; detail.Quantity = Quantity; return(detail); }
public static DetailTransaction CreateNewDetailTrans(int transId, int productId, int quantity) { DetailTransaction detail = new DetailTransaction(); detail.TransactionID = transId; detail.ProductID = productId; detail.Quantity = quantity; return(detail); }
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 static DetailTransaction addDetailTransaction(int transactionID, int productID, int quantity) { DetailTransaction dt = new DetailTransaction(); dt.TransactionID = transactionID; dt.ProductID = productID; dt.Quantity = quantity; return(dt); }
public static DetailTransaction createDetailTransaction(int TransactionID, int ProductID, int Quantity) { DetailTransaction dt = new DetailTransaction(); dt.TransactionID = TransactionID; dt.ProductID = ProductID; dt.Quantity = Quantity; return(dt); }
public static DetailTransaction createDetailTransaction(int transactionId, int productId, int qty) { DetailTransaction dt = new DetailTransaction(); dt.TransactionID = transactionId; dt.ProductID = productId; dt.Quantity = qty; return(dt); }
public static DetailTransaction createDetailTransaction(int headerTransactionId, int productId, int quantity) { DetailTransaction dt = new DetailTransaction(); dt.HTransactionsId = headerTransactionId; dt.ProductsId = productId; dt.Quantity = quantity; return(dt); }
public static void Checkout(User user, List <Cart> carts) { HeaderTransaction headerTransaction = TransactionFactory.CreateHeader(user.username); int headerTransactionId = TransactionRepository.InsertHeaderTransaction(headerTransaction).id; foreach (var item in carts) { DetailTransaction detailTransaction = TransactionFactory.CreateDetail(headerTransactionId, item); TransactionRepository.InsertDetailTransaction(detailTransaction); } }
public static DetailTransaction insertDetailTransaction(int headerId, int productId, int quantity) { DetailTransaction dt = new DetailTransaction() { TransactionID = headerId, ProductID = productId, Quantity = quantity }; return(dt); }
public DetailTransaction CreateDetailTransaction(int transactionID, int productID, int quantity) { DetailTransaction newDT = new DetailTransaction { TransactionID = transactionID, ProductID = productID, Quantity = quantity }; return(newDT); }
public static void checkout(int userId, List <Cart> cartList, int paymentTypeId, DateTime date) { HeaderTransaction newHT = TransactionFactory.createHeaderTransaction(userId, paymentTypeId, date); int htId = TransactionRepository.addHeaderTransaction(newHT).HTransactionsId; foreach (Cart cart in cartList) { DetailTransaction newDT = TransactionFactory.createDetailTransaction(htId, cart.ProductsId, cart.Quantity); TransactionRepository.addDetailTransaction(newDT); } }
public static DetailTransaction GetDetailTransaction(int transactionId, int productId, int qty) { DetailTransaction dt = new DetailTransaction() { TransactionId = transactionId, ProductId = productId, Quantity = qty }; return(dt); }
public static DetailTransaction CreateDetailTransaction(int transactionid, int productid, int quantity) { DetailTransaction newDetailTransaction = new DetailTransaction() { TransactionId = transactionid, ProductId = productid, Quantity = quantity, }; return(newDetailTransaction); }
public static DetailTransaction CreateDetail(int headerTransactionId, Cart cart) { DetailTransaction detailTransaction = new DetailTransaction() { trans_id = headerTransactionId, product_id = cart.Product.id, price = cart.Product.price, quantity = cart.Quantity }; return(detailTransaction); }
//Function to store Detail Transaction private void storeDetailTransaction(string ht, string shoeid, int qty) { DB = Db4oFactory.OpenFile("Detail Transaction.yap"); DetailTransaction dt = new DetailTransaction() { ShoeID = shoeid, HeaderTransactionID = ht, Quantity = qty }; DB.Store(dt); DB.Close(); }
public bool Insert(TransactionParam transactionParam) { var get = new DetailTransaction(transactionParam); _context.DetailTransactions.Add(get); var result = _context.SaveChanges(); if (result > 0) { status = true; } return(status); }
public static DetailTransaction InsertDetailTransaction(DetailTransaction detailTransaction) { using (WatchShopEntities db = new WatchShopEntities()) { db.DetailTransaction.Add(detailTransaction); db.SaveChanges(); int productId = detailTransaction.product_id; int quantity = detailTransaction.quantity.Value; ProductRepository.DecreaseStock(productId, quantity); return(detailTransaction); } }
public static void checkout(int userid, int paymentTypeid, List <Cart> carts) { HeaderTransaction headerTransaction = TransactionFactory.headerTransaction(userid, paymentTypeid, DateTime.Now); int TrID = TransactionRepository.addHT(headerTransaction).Id; foreach (Cart i in carts) { DetailTransaction detailTransaction = TransactionFactory.detailTransaction(TrID, i.ProductID, i.Quantity); TransactionRepository.addDT(detailTransaction); ProductRepository.decreaseproduct(i.ProductID, i.Quantity); } CartRepository.deleteCarts(carts); }
private void CityGridRegistration() { var cityDetail = new DetailTransaction<City>(CityDataSource.CityDataSource.GetCitys().Take(100).ToList()); this.DetailContainer["PagingCityGrid"] = cityDetail; }