public static DetailTransaction AddTransactionDetail(DetailTransaction transactionDetail)
        {
            db.DetailTransactions.Add(transactionDetail);
            db.SaveChanges();

            return(transactionDetail);
        }
예제 #2
0
        public static void doInsertDetailTransaction(int transactionId, int productId, int qty)
        {
            DetailTransaction dt = DetailTransactionFactory.createDetailTransaction(transactionId, productId, qty);

            db.DetailTransactions.Add(dt);
            db.SaveChanges();
        }
예제 #3
0
        public static void InsertNewDetailTrans(int transId, int productId, int quantity)
        {
            DetailTransaction detailTrans = TransactionFactory.CreateNewDetailTrans(transId, productId, quantity);

            db.DetailTransactions.Add(detailTrans);
            db.SaveChanges();
        }
예제 #4
0
        public static long getSubTotal(DetailTransaction dt)
        {
            long subTotal = 0;

            subTotal = dt.Quantity * dt.Product.Price;
            return(subTotal);
        }
예제 #5
0
        public static void newTransactionDetail(int transactionID, int productID, int quantity)
        {
            DetailTransaction dt = DetailTransactionFactory.addNewDetail(transactionID, productID, quantity);

            db.DetailTransactions.Add(dt);
            db.SaveChanges();
        }
예제 #6
0
        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);
        }
예제 #7
0
        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);
        }
예제 #8
0
        public static void insertDetailTransaction(int transactionID, int productID, int quantity)
        {
            DetailTransaction dt = TransactionFactory.addDetailTransaction(transactionID, productID, quantity);

            dbEntity.DetailTransactions.Add(dt);
            dbEntity.SaveChanges();
        }
예제 #9
0
        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();
        }
예제 #10
0
        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);
            }
        }
예제 #12
0
        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);
        }
예제 #13
0
        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);
        }
예제 #14
0
        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);
        }
예제 #16
0
        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();
        }
예제 #17
0
        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);
        }
예제 #18
0
        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);
        }
예제 #19
0
        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);
        }
예제 #20
0
        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);
        }
예제 #21
0
        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);
            }
        }
예제 #22
0
        public static DetailTransaction insertDetailTransaction(int headerId, int productId, int quantity)
        {
            DetailTransaction dt = new DetailTransaction()
            {
                TransactionID = headerId,
                ProductID     = productId,
                Quantity      = quantity
            };

            return(dt);
        }
예제 #23
0
        public DetailTransaction CreateDetailTransaction(int transactionID, int productID, int quantity)
        {
            DetailTransaction newDT = new DetailTransaction
            {
                TransactionID = transactionID,
                ProductID     = productID,
                Quantity      = quantity
            };

            return(newDT);
        }
예제 #24
0
        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);
            }
        }
예제 #25
0
        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);
        }
예제 #27
0
        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);
        }
예제 #28
0
        //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);
        }
예제 #30
0
        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);
            }
        }
예제 #31
0
        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);
        }
예제 #32
0
        private void CityGridRegistration()
        {
            var cityDetail = new DetailTransaction<City>(CityDataSource.CityDataSource.GetCitys().Take(100).ToList());
            this.DetailContainer["PagingCityGrid"] = cityDetail;

        }