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));
}
