private void frmStockout_Load(object sender, EventArgs e)
{
txtBarcode.MaxLength = 11;
txtBarcode.Focus();
pro.FillAutonumber(11, lblTransactionId);
txtChange.Visible = false;
txtAmountTender.Visible = false;
lblamountTender.Visible = false;
lblchange.Visible = false;
txtTotalAmount.Size = new Size(150, 76);
timer1.Start();
pro.ResponsiveDtg(dtgList);
}
private void frmTransaction_Load(object sender, EventArgs e)
{
txtBarcode.MaxLength = 11;
pro.sqlselect = "SELECT p.Barcode,ProductName,Category,p.OriginalPrice,DateReceived,ReceivedQty,Unit FROM tblcategory c, tblproduct p,tblstockin s WHERE p.CategoryId=c.CategoryId AND p.Barcode=s.Barcode ORDER BY DateReceived Desc";
pro.LoadData(pro.sqlselect, dtgList);
pro.sqlselect = "SELECT OrderId,Supplier,OrderDate,p.Barcode,ProductName,Description,Category,p.OriginalPrice,OrderQty,Unit,OrderTotal " +
" FROM tblcategory c, tblproduct p,tblorder o , tblsupplier s " +
" WHERE p.CategoryId=c.CategoryId AND p.Barcode=o.Barcode AND o.SupplierId=s.SupplierId AND Rem='Ordered' And p.Barcode = '" + txtBarcode.Text + "'";
pro.LoadData(pro.sqlselect, dtgOrderlist);
dtgOrderlist.Columns[0].Visible = false;
pro.ResponsiveDtg(dtgOrderlist);
}