public bool insertProductInvoice(Invoice transaction, Product product, int quantity) { Decimal grpPrice = product.UnitPrice * quantity; return create( insertValues(transaction.InvoiceId, product.Barcode, quantity, grpPrice) ); }
public int getTransactionId(Invoice transaction) { string condition = String.Format(" date = {0} and employee_id = '{1}' ORDER BY time DESC", "CURDATE()", transaction.EmployeeId); return (int)readScalar("id", condition); }
public bool insertTransaction(Invoice transaction) { return create(insertValues( "CURDATE()", "CURTIME()", transaction.EmployeeId) ); }
public List<ProductInvoice> getListOfProductInvoice(Invoice invoice) { List<ProductInvoice> productInvoices = new List<ProductInvoice>(); List<Entity> entities = getListOfEntity(string.Format("invoice_id = {0}", invoice.InvoiceId)); foreach (Entity entity in entities) { productInvoices.Add(new ProductInvoice(entity)); } return productInvoices; }
public bool insertTransactionResult(Invoice transaction, Decimal totalPrice, Decimal cashTender) { if (transaction != null) { Decimal change = cashTender - totalPrice; return create( insertValues(transaction.InvoiceId, totalPrice, cashTender, change) ); } return false; }
public ProductInvoice(Entity entity) { invoice = new Invoice() { InvoiceId = (int)entity.getField("invoice_id"), }; product = new Product() { Barcode = entity.getField("product_id").ToString(), }; QuantitySold = (int)entity.getField("quantity"); GroupPrice = (Decimal)entity.getField("subtotal"); }
public bool queryProducts() { bool success = false; int invoice_no = 0; int sum_of_qty = 0; decimal sum_of_price = 0M; if (int.TryParse(txtEncode.Text, out invoice_no)) { Invoice invoice = new Invoice() { InvoiceId = invoice_no }; ProductInvoice pI = new ProductInvoice() { invoice = invoice }; if (!dbController.checkIfAlreadyConsumed(pI)) { lblPOSmsg.Text = "PV-" + invoice.InvoiceId.ToString("00000"); carts = dbController.getListOfProductInvoice(invoice); int quantity = carts.Count; dt.Clear(); foreach (ProductInvoice productInvoice in carts) { currentProduct = dbController.getProductFromBarcode(productInvoice.product.Barcode); sum_of_qty += productInvoice.QuantitySold; sum_of_price += productInvoice.GroupPrice; addRowInDatagrid(productInvoice); } poSlbl2.Text = sum_of_price.ToString("N"); totalAmount = sum_of_price; success = true; } else { MessageBox.Show("Invoice transaction was already used or do not exist."); } } txtEncode.Clear(); return success; }
public bool insertTransactionResult(Invoice transaction, Decimal totalPrice, Decimal cashTender) { return transactionResult.insertTransactionResult(transaction, totalPrice, cashTender); }
void beginTransaction() { if (currentTransaction == null) { currentTransaction = new Invoice() { TransactionDateTime = DateTime.Now, EmployeeId = masterController.LoginEmployee.User_id }; dbController.insertTransaction(currentTransaction); currentTransaction.InvoiceId = dbController.getTransactionId(currentTransaction); totalAmount = 0M; } else { txtEncode.Focus(); } }
public List<String> getListOfProduct(Invoice invoice) { return productInvoiceMapper.getListOfProductOnInvoice(invoice); }
public void insertTransaction(Invoice transaction) { // This method insert a new row into transaction_tbl if (invoiceMapper.insertTransaction(transaction)){ OnInsertEntity(new EntityArgs(transaction)); } }
public List <String> getListOfProduct(Invoice invoice) { return(productInvoiceMapper.getListOfProductOnInvoice(invoice)); }
//private void barcodeIndicator_Tick(object sender, EventArgs e) //{ // rightSidePane.BackgroundImage = Properties.Resources.barcodeWhite; // barcodeIndicator.Stop(); //} void resetTransaction() { if (!concludeTransaction){ DialogResult result = MessageBox.Show("It's seems there are still unfinished transaction. Are you sure you want to reset?", "Message", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning); if (result == DialogResult.Cancel) return; } currentTransaction = null; lblTransactionno.ResetText(); toggleEncoding(true); //lblChange.ResetText(); carts.Clear(); clearDataGrid(); resetServices(); concludeTransaction = false; poSlbl2.Text = "0"; lblPOSmsg.Text = "No current transaction"; }
public bool insertReceipt(Invoice transaction, Decimal totalPrice, Decimal cashTender) { return receipt.insertReceipt(transaction, totalPrice, cashTender); }
void resetTransaction() { if (!concludeTransaction){ DialogResult result = MessageBox.Show("It's seems there are still unfinished transaction. Are you sure you want to reset?", "Message", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning); if (result == DialogResult.Cancel) return; } currentTransaction = null; lblTransactionno.ResetText(); toggleEncoding(true); carts.Clear(); clearDataGrid(); concludeTransaction = false; txtQuantity.Text = "1"; poSlbl2.Text = "0"; lblPOSmsg.Text = "No current transaction"; MyExtension.Validation.clearFields(panel1); }
void updateProductTransaction(string name, int transaction_id, int qty, decimal grp_price) { Product product = dbController.getProductThroughName(name); Invoice transaction = new Invoice() { InvoiceId = transaction_id, }; ProductInvoice productInvoice = new ProductInvoice() { product = product, invoice = transaction, QuantitySold = -qty, GroupPrice = grp_price, }; int quantity = 0; if (int.TryParse(getValueFromDatagridCell(2), out quantity)) { if (qty > quantity) return; } dbController.insertProductInvoice(productInvoice); }
public List <ProductInvoice> getListOfProductInvoice(Invoice invoice) { return(productInvoiceMapper.getListOfProductInvoice(invoice)); }
public List<string> getListOfProductOnInvoice(Invoice invoice) { return getList("invoice_id", string.Format("invoice_id = {0}", invoice.InvoiceId)); }
public bool insertMedicalTransaction(Invoice transaction, Medical medical, int qty, decimal subtotal) { return create( insertValues(medical.Id, qty, subtotal, transaction.InvoiceId) ); }
public bool insertReceipt(Invoice transaction, Decimal totalPrice, Decimal cashTender) { return(receipt.insertReceipt(transaction, totalPrice, cashTender)); }
void beginTransaction() { if (currentTransaction == null) { currentTransaction = new Invoice() { TransactionDateTime = DateTime.Now, EmployeeId = masterController.LoginEmployee.User_id }; dbController.insertTransaction(currentTransaction); currentTransaction.InvoiceId = dbController.getTransactionId(currentTransaction); lblTransactionno.Text = "PV-" + currentTransaction.InvoiceId.ToString("00000"); totalAmount = 0M; activateServices(true); } else { txtEncode.Focus(); } }
public int getTransactionId(Invoice transaction) { return invoiceMapper.getTransactionId(transaction); }
void updateProductTransaction(string name, int transaction_id, int qty, decimal grp_price) { Product product = dbController.getProductThroughName(name); Invoice transaction = new Invoice() { InvoiceId = transaction_id, }; ProductInvoice productInvoice = new ProductInvoice() { product = product, invoice = transaction, QuantitySold = -qty, GroupPrice = grp_price, }; dbController.insertProductInvoice(productInvoice); }
public List<ProductInvoice> getListOfProductInvoice(Invoice invoice) { return productInvoiceMapper.getListOfProductInvoice(invoice); }
public bool insertMedicalTransaction(Invoice transaction, Medical medical, int qty, decimal subtotal) { if (medicalTransactionMapper.insertMedicalTransaction(transaction, medical, qty, subtotal)) { OnInsertEntity(new EntityArgs(transaction)); return true; } return false; }
public int getTransactionId(Invoice transaction) { return(invoiceMapper.getTransactionId(transaction)); }