protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ProductSet = new DataSet();
#region Populating Product List
try
{
connection.Open();
SqlCommand command = new SqlCommand("Select DISTINCT tbl_ProductMaster.* From tbl_ProductMaster INNER JOIN tblStock_Detail ON tbl_ProductMaster.ProductID = tblStock_Detail.ProductID Where tbl_ProductMaster.Status = 1", connection);
DataSet ds = new DataSet();
SqlDataAdapter sA = new SqlDataAdapter(command);
sA.Fill(ds);
ProductSet = ds;
ds.Tables[0].Columns.Add("ProductInfo", typeof(string), "Product_Name+ ' '+itemStrength+' '+itemPackSize+' '+itemForm");
SelectProduct.DataSource = ds.Tables[0];
SelectProduct.DataTextField = "ProductInfo";
SelectProduct.DataValueField = "ProductID";
SelectProduct.DataBind();
if (SelectProduct != null)
{
SelectProduct.Items.Insert(0, "Select Product");
SelectProduct.SelectedIndex = 0;
}
}
catch (Exception ex)
{
}
finally
{
connection.Close();
}
#endregion
}
}
//Sp_FillPO_Details
public void PopulateDropDown(String Text)
{
#region Populating Product Name Dropdown
try
{
connection.Open();
Text = Text + "%";
SqlCommand command = new SqlCommand("SELECT Distinct * From tbl_ProductMaster INNER JOIN tblStock_Detail ON tbl_ProductMaster.ProductID = tblStock_Detail.ProductID Where tbl_ProductMaster.Product_Name LIKE '" + Text + "' AND tbl_ProductMaster.Status = 1", connection);
DataSet ds = new DataSet();
SqlDataAdapter sA = new SqlDataAdapter(command);
sA.Fill(ds);
if (ds.Tables[0].Rows.Count.Equals(0))
{
WebMessageBoxUtil.Show("There is no stock for the selected product");
}
if (SelectProduct.DataSource != null)
{
SelectProduct.DataSource = null;
}
ProductSet = null;
ProductSet = ds;
//ds.Tables[0].Columns.Add("ProductInfo", typeof(string), "Product_Name+ ' '+itemStrength+' '+itemPackSize+' '+itemForm");
SelectProduct.DataSource = ds.Tables[0];
SelectProduct.DataTextField = "Description";
SelectProduct.DataValueField = "ProductID";
SelectProduct.DataBind();
if (SelectProduct != null)
{
SelectProduct.Items.Insert(0, "Select Product");
SelectProduct.SelectedIndex = 0;
}
}
catch (Exception ex)
{
}
finally
{
connection.Close();
}
#endregion
}
public void PopulateDropDown(String Text)
{
#region Populating Product Name Dropdown
try
{
connection.Open();
Text = Text + "%";
SqlCommand command = new SqlCommand("SELECT * From tbl_ProductMaster Where tbl_ProductMaster.Product_Name LIKE '" + Text + "' AND Status = 1", connection);
DataSet ds = new DataSet();
SqlDataAdapter sA = new SqlDataAdapter(command);
sA.Fill(ds);
if (SelectProduct.DataSource != null)
{
SelectProduct.DataSource = null;
}
ProductSet = null;
ProductSet = ds;
StockDisplayGrid.DataSource = ds;
StockDisplayGrid.DataBind();
SelectProduct.DataSource = ds.Tables[0];
SelectProduct.DataTextField = "Product_Name";
SelectProduct.DataValueField = "ProductID";
SelectProduct.DataBind();
if (SelectProduct != null)
{
SelectProduct.Items.Insert(0, "Select Product");
SelectProduct.SelectedIndex = 0;
}
}
catch (Exception ex)
{
}
finally
{
connection.Close();
}
#endregion
}
//Sp_FillPO_Details
public void PopulateDropDown(String Text)
{
#region Populating Product Name Dropdown
try
{
connection.Open();
Text = Text + "%";
SqlCommand command = new SqlCommand("SELECT * From tbl_ProductMaster Where tbl_ProductMaster.Product_Name LIKE '" + Text + "' AND Status = 1", connection);
DataSet ds = new DataSet();
SqlDataAdapter sA = new SqlDataAdapter(command);
sA.Fill(ds);
if (SelectProduct.DataSource != null)
{
SelectProduct.DataSource = null;
}
ProductSet = null;
ProductSet = ds;
// ds.Tables[0].Columns.Add("ProductInfo", typeof(string), "Product_Name+ ' '+itemStrength+' '+itemPackSize+' '+itemForm");
SelectProduct.DataSource = ds.Tables[0];
SelectProduct.DataTextField = "Description";
SelectProduct.DataValueField = "ProductID";
SelectProduct.DataBind();
if (SelectProduct != null)
{
SelectProduct.Items.Insert(0, "Select Product");
SelectProduct.SelectedIndex = 0;
}
}
catch (Exception ex)
{
}
finally
{
connection.Close();
}
#endregion
}
