private void txtBarcode_TextChanged(object sender, EventArgs e)
{
try
{
if (txtBarcode.Text != "")
{
if (txtBarcode.Text.Length >= 10)
{
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.sqlselect = "SELECT * FROM tblcategory c, tblproduct p WHERE p.CategoryId=c.CategoryId And Barcode Like '%" + txtBarcode.Text + "%'";
//pro.Single_Select(pro.sqlselect);
//if (pro.dt.Rows.Count > 0)
//{
// decimal price;
// txtProduct.Text = pro.dt.Rows[0].Field<string>("ProductName");
// txtDescription.Text = pro.dt.Rows[0].Field<string>("Description");
// txtCategory.Text = pro.dt.Rows[0].Field<string>("Category");
// price = pro.dt.Rows[0].Field<decimal>("OriginalPrice");
// txtPrice.Text = price.ToString("N2");
//}
//else
//{
// clearStockin();
//}
}
else
{
txtProduct.Clear();
txtDescription.Clear();
txtPrice.Clear();
txtCategory.Clear();
txtQty.Clear();
}
}
else
{
txtProduct.Clear();
txtDescription.Clear();
txtPrice.Clear();
txtCategory.Clear();
txtQty.Clear();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void frmCategory_Load(object sender, EventArgs e)
{
config.sqlselect = "SELECT c.CategoryId,Category,CategoryType,Unit FROM tblcategory c,tblautonumber a WHERE c.CategoryId=a.CategoryId";
config.LoadData(config.sqlselect, dtglist);
txtcategory.Clear();
txtUnit.Clear();
txtType.Clear();
categoryid = 0;
dtglist.Columns[0].Visible = false;
config.FillAutonumber(4, lblCategoryId);
}
private void frmProduct_Load(object sender, EventArgs e)
{
try
{
txtBarcode.MaxLength = 11;
//pro.FillAutonumber(1, lblProductId);
pro.sql = "Select CategoryId, Category + '[' + CategoryType + ']' as 'CategType' From tblcategory";
pro.FillComboBox(pro.sql, "CategoryId", "CategType", cboCategory);
string categoryid = cboCategory.SelectedValue.ToString();
int id = Int32.Parse(categoryid);
pro.PassingAutonumberLbl(id, lblProductId);
pro.sqlselect = "SELECT ProductId,p.Barcode,ProductName,Description,Category + '[' + CategoryType + ']' as 'Category' ,p.OriginalPrice,MarkupPrice,ProductQty,Unit FROM tblcategory c, tblproduct p WHERE p.CategoryId=c.CategoryId";
pro.LoadData(pro.sqlselect, dtglist);
pro.dtgcolor(dtglist, 7);
useFunc.clearTxt(this);
}
catch
{
}
}
private void frmPurchaseOrder_Load(object sender, EventArgs e)
{
pro.sqlselect = "SELECT OrderDate,p.Barcode,ProductName,Description,Category,p.OriginalPrice,OrderQty,Unit,OrderTotal FROM tblcategory c, tblproduct p,tblorder o WHERE p.CategoryId=c.CategoryId AND p.Barcode=o.Barcode";
pro.LoadData(pro.sqlselect, dtgList);
txtBarcode.MaxLength = 11;
pro.FillComboBox("SELECT * FROM tblsupplier", "SupplierId", "Supplier", comboBox1);
clearStockin();
}
private void btnNew_Click(object sender, EventArgs e)
{
useFunc.clearTxt(this);
cboRole.Text = "Administrator";
user.FillAutonumber(2, lblUserId);
user.sqlselect = "Select UserId,Fullname,User_Name as 'Username',UserRole as 'Role' FROM tbluser";
user.LoadData(user.sqlselect, dtgList);
}
private void frmSupplier_Load(object sender, EventArgs e)
{
sup.sqlselect = "SELECT * From tblsupplier";
sup.LoadData(sup.sqlselect, dtgList);
txtSupplier.Clear();
txtContactNo.Clear();
txtCompanyAddress.Clear();
txtCompany.Clear();
txtSupplier.Focus();
supplierid = 0;
}
private void frmListProducts_Load(object sender, EventArgs e)
{
prolist.sqlselect = "SELECT p.Barcode,ProductName,Description,Category,p.OriginalPrice,ProductQty,Unit FROM tblcategory c, tblproduct p WHERE p.CategoryId=c.CategoryId";
prolist.LoadData(prolist.sqlselect, dtgList);
prolist.dtgcolor(dtgList, 5);
}