private void GetProductStock(string ProductName)
{
BLSaleProductTransaction objcount = new BLSaleProductTransaction();
DataTable ds = objcount.GetProductStock(ProductName);
if (ds.Rows.Count != 0)
{
txtProductCount.Text = ds.Rows[0]["Quantity"].ToString();
}
}
private void Usp_BindGridSaleProductTransaction()
{
DataTable dt = new DataTable();
BLSaleProductTransaction objBL = new BLSaleProductTransaction();
dt = objBL.BindFullGrid();
if (dt.Rows.Count > 0)
{
dgvProducts.DataSource = dt;
dgvProducts.Refresh();
dgvProducts.Show();
}
}
private void dgvProducts_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (dgvProducts.SelectedRows.Count > 0)
{
cbProductName.Text = Convert.ToString(dgvProducts.SelectedRows[0].Cells[0].Value);
string ProductName = cbProductName.Text;
BLSaleProductTransaction objProduct = new BLSaleProductTransaction();
DataTable dt = objProduct.GetID(ProductName);
if (dt.Rows.Count != 0)
{
lblProductid.Text = dt.Rows[0]["ProductID"].ToString();
}
txtProductCount.Text = Convert.ToString(dgvProducts.SelectedRows[0].Cells[1].Value);
txtProductSeleQty.Text = Convert.ToString(dgvProducts.SelectedRows[0].Cells[2].Value);
txtsellingTo.Text = Convert.ToString(dgvProducts.SelectedRows[0].Cells[3].Value);
//cbActive.Text = Convert.ToString(dgvProducts.SelectedRows[0].Cells[7].Value);
btbSave.Text = "Update";
}
}