private void SaveTransaction(decimal amt, decimal tnd)
{
if (tnd < amt)
{
return;
}
try
{
transaction.TenderAmount = tnd;
if (!DataHandler.SaveTransaction(transaction))
{
FncFilter.Alert(globalvariables.saving_failed);
return;
}
else
{
HardwareHelper.Print(transaction, false, false);
FncFilter.Alert(globalvariables.saving_success);
transComplete = true;
this.Close();
}
}
catch
{
FncFilter.Alert(globalvariables.saving_failed);
return;
}
}
private void btnXRead_Click(object sender, EventArgs e)
{
if (GenerateReport.XRead(DateTime.Now))
{
FncFilter.Alert("X-Read Generation Success");
}
}
private void btnOkay_Click(object sender, EventArgs e)
{
txtInvoice.Text.Trim();
if (txtInvoice.Text.Length == 0)
{
return;
}
string invoicenumber = txtInvoice.Text;
Transaction trans = DataHandler.GetTransactionByInvoice(invoicenumber);
if (trans == null)
{
FncFilter.Alert("Invalid Invoice Number.");
}
else
{
if (IsReprint)
{
HardwareHelper.Print(trans, true, false);
this.Close();
}
else
{
DataHandler.VoidTransaction(trans);
HardwareHelper.Print(trans, false, true);
this.Close();
}
}
}
private bool CheckFields()
{
decimal amt = FncFilter.GetDecimalValue(tbPrice.Text);
if (amt == 0)
{
FncFilter.Alert(globalvariables.warning_invalid_amount);
tbPrice.Focus();
tbPrice.SelectAll();
return(false);
}
tbProductName.Text.Trim();
if (tbProductName.Text == "")
{
FncFilter.Alert(globalvariables.warning_invalid_product);
tbProductName.Focus();
tbProductName.SelectAll();
return(false);
}
tbStockNo.Text.Trim();
if (tbStockNo.Text == "")
{
FncFilter.Alert(globalvariables.warning_invalid_stockno);
tbStockNo.Focus();
tbStockNo.SelectAll();
return(false);
}
return(true);
}
private void btnPayment_Click(object sender, EventArgs e)
{
decimal tendered = FncFilter.GetDecimalValue(tbPrice.Text);
decimal amountdue = FncFilter.GetDecimalValue(lblDueAmount.Text);
SaveTransaction(amountdue, tendered);
}
private void AddProduct()
{
if (globalvariables.LockedPOS)
{
FncFilter.Alert("POS is Locked, Z-Read already generated");
return;
}
if (dgvProduct.SelectedRows.Count <= 0)
{
return;
}
Product product = products[dgvProduct.SelectedRows[0].Index];
try
{
bool alreadyExists = transaction.productlist.Any(x => x.ID == product.ID);
if (alreadyExists)
{
int index = transaction.productlist.FindIndex(a => a.ID == product.ID);
transaction.productlist[index].Qty = transaction.productlist[index].Qty + 1;
}
else
{
product.Qty = 1;
transaction.productlist.Add(product);
}
dgvTransactionProduct.RowCount = transaction.productlist.Count;
dgvTransactionProduct.Refresh();
RefreshTransactionDetails();
}
catch { }
}
private void bgwSearchProduct_DoWork(object sender, DoWorkEventArgs e)
{
string SQLSearch = "";
e.Result = false;
string str_input = "";
string[] words = this.txtKeyword.Text.Split(' ');
foreach (string word in words)
{
if (word.Length > 0)
{
str_input += "%" + word;
}
}
str_input += "%";
SQLSearch = string.Format(@"SELECT *
FROM Product
WHERE (productname LIKE '{0}' OR
barcode LIKE '{1}' OR
stockno LIKE '{2}')", str_input, str_input, str_input);
DataTable productDataTable = DataBaseHelper.GetDB(SQLSearch);
products.Clear();
this.bgwSearchProduct.ReportProgress(0);
//dgvProduct.DataSource = result;
foreach (DataRow productDataRow in productDataTable.Rows)
{
decimal actualPrice = Convert.ToDecimal(productDataRow["price"].ToString());
products.Add(
new Product
{
ID = Convert.ToInt64(productDataRow["id"]),
Name = productDataRow["productname"].ToString(),
Barcode = productDataRow["barcode"].ToString(),
StockNo = productDataRow["stockno"].ToString(),
Price = actualPrice,
Qty = FncFilter.GetDecimalValue(productDataRow["inventory"].ToString()),
Show = Convert.ToInt32(productDataRow["discontinued"].ToString())
}
);
}
longestProductName = null;
List <string> productNames = new List <string>();
if (products.Count != 0)
{
products.ForEach(x => productNames.AddRange(x.Name.Split(' ')));
int textLength = productNames.Max(s => s.Length);
string productName = productNames.FirstOrDefault(s => s.Length == textLength);
longestProductName = products.FirstOrDefault(s => s.Name.Contains(productName));
}
this.bgwSearchProduct.ReportProgress(1);
}
private void btnAddProduct_Click(object sender, EventArgs e)
{
if (!CheckFields())
{
return;
}
if (!forUpdate)
{
decimal price = FncFilter.GetDecimalValue(tbPrice.Text);
string name = tbProductName.Text;
string stockno = tbStockNo.Text;
Product newproduct = new Product()
{
Name = name,
StockNo = stockno,
Price = price
};
if (!DataHandler.SaveProduct(newproduct))
{
FncFilter.Alert(globalvariables.saving_failed);
return;
}
else
{
FncFilter.Alert(globalvariables.saving_success);
newProduct = true;
this.Close();
}
}
else
{
decimal price = FncFilter.GetDecimalValue(tbPrice.Text);
string name = tbProductName.Text;
string stockno = tbStockNo.Text;
product.Name = name;
product.Price = price;
product.StockNo = stockno;
product.Show = cbProductStatus.Checked ? 1 : 0;
if (!DataHandler.UpdateProduct(product))
{
FncFilter.Alert(globalvariables.saving_failed);
return;
}
else
{
FncFilter.Alert(globalvariables.saving_success);
newProduct = true;
this.Close();
}
}
}
private void ManageInventory_Load(object sender, EventArgs e)
{
foreach (DataGridViewColumn col in dgvInventory.Columns)
{
col.SortMode = DataGridViewColumnSortMode.NotSortable;
col.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
}
FncFilter.set_dgv_controls(dgvInventory);
dgvInventory.VirtualMode = true;
dgvInventory.CellValueNeeded += new DataGridViewCellValueEventHandler(dgvInventory_CellValueNeeded);
}
private void btnVoid_Click(object sender, EventArgs e)
{
if (globalvariables.LockedPOS)
{
FncFilter.Alert("POS is Locked, Z-Read already generated");
return;
}
ReprintVoidForm reprintVoidForm = new ReprintVoidForm();
reprintVoidForm.IsReprint = false;
reprintVoidForm.ShowDialog();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (DataHandler.SaveAdjustments(adjustments))
{
FncFilter.Alert(globalvariables.saving_success);
this.Close();
}
else
{
FncFilter.Alert(globalvariables.saving_failed);
return;
}
}
private void btnZRead_Click(object sender, EventArgs e)
{
if (FncFilter.ConfirmYesNo(globalvariables.confirm_lock_pos))
{
GenerateReport.ZRead(DateTime.Now);
globalvariables.LockedPOS = true;
RefreshTransactionDetails();
}
else
{
return;
}
}
private void AddAdjustmentForm_Load(object sender, EventArgs e)
{
FncFilter.set_dgv_controls(dgvProduct);
FncFilter.set_dgv_controls(dgvAdjustments);
foreach (DataGridViewColumn col in dgvProduct.Columns)
{
col.SortMode = DataGridViewColumnSortMode.NotSortable;
}
dgvProduct.VirtualMode = true;
dgvProduct.CellValueNeeded += new DataGridViewCellValueEventHandler(dgvProduct_CellValueNeeded);
dgvAdjustments.VirtualMode = true;
dgvAdjustments.CellValueNeeded += new DataGridViewCellValueEventHandler(dgvAdjustments_CellValueNeeded);
RefreshDetails();
}
private void PointOfSales_Load(object sender, EventArgs e)
{
FncFilter.set_dgv_controls(dgvProduct);
FncFilter.set_dgv_controls(dgvTransactionProduct);
foreach (DataGridViewColumn col in dgvProduct.Columns)
{
col.SortMode = DataGridViewColumnSortMode.NotSortable;
}
dgvProduct.VirtualMode = true;
dgvProduct.CellValueNeeded += new DataGridViewCellValueEventHandler(dgvProduct_CellValueNeeded);
dgvTransactionProduct.VirtualMode = true;
dgvTransactionProduct.CellValueNeeded += new DataGridViewCellValueEventHandler(dgvTransactionProduct_CellValueNeeded);
InitializeTransaction();
}
private void btnChangeQty_Click(object sender, EventArgs e)
{
if (dgvTransactionProduct.SelectedRows.Count <= 0)
{
return;
}
int index = dgvTransactionProduct.SelectedRows[0].Index;
decimal qty = FncFilter.GetDecimalValue(lblQtyD.Text);
transaction.productlist[index].Qty = qty;
dgvTransactionProduct.Refresh();
RefreshTransactionDetails();
}
private void btnChangeQty_Click(object sender, EventArgs e)
{
if (dgvAdjustments.SelectedRows.Count <= 0)
{
return;
}
int index = dgvAdjustments.SelectedRows[0].Index;
decimal qty = FncFilter.GetDecimalValue(lblQtyD.Text);
adjustments[index].Quantity = qty;
dgvAdjustments.Refresh();
RefreshDetails();
}
private void btnZRead_Click(object sender, EventArgs e)
{
if (report.Date == DateTime.Now.Date && !globalvariables.LockedPOS)
{
if (FncFilter.ConfirmYesNo(globalvariables.confirm_lock_pos))
{
GenerateReport.ZRead(report.Date);
}
}
else
{
report.Type = 3;
HardwareHelper.PrintReport(null, null, null, report);
}
this.Close();
}
private void keyDownTimer_Tick(object sender, EventArgs e)
{
keyDownTimer.Stop();
if (this.txtKeyword.Text.Trim().Length == 0)
{
this.dgvProduct.RowCount = 0;
products.Clear();
FncFilter.SetGridViewDisplay(this.dgvProduct, false);
return;
}
if (!bgwSearchProduct.IsBusy)
{
pbLoad.Visible = true;
bgwSearchProduct.RunWorkerAsync();
}
}
private void bwRecompute_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
pbLoad.Visible = false;
FncFilter.Alert("Recompute Complete!");
}
