private void PopulateSearchDropdowns()
{
FinalProductStock_Dropdown objData = (new Report_DL()).GetDropdownData_FinalProductStock();
lbCompany.DataSource = objData.lst_Company;
lbCompany.DataBind();
lbItemName.DataSource = objData.lst_StockItemName;
lbItemName.DataBind();
lbGodownName.DataSource = objData.lst_GodownName;
lbGodownName.DataBind();
lbStockGroup.DataSource = objData.lst_StockGroup;
lbStockGroup.DataBind();
}
public FinalProductStock_Dropdown GetDropdownData_FinalProductStock()
{
FinalProductStock_Dropdown ddlData = new FinalProductStock_Dropdown();
Common.OpenConnection();
try
{
//--- Company Drop Down ----
ddlData.lst_Company = new List <string>();
ddlData.lst_Company.Add("select");
String sql = "Select Distinct CompanyID from TD_Txn_StockDetails order by CompanyID";
SqlCommand cmd = new SqlCommand(sql, Common.conn);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
ddlData.lst_Company.Add(Common.GetString(rdr["CompanyID"]));
}
rdr.Close();
//--- lst_StockItemName Drop Down ----
ddlData.lst_StockItemName = new List <string>();
ddlData.lst_StockItemName.Add("select");
sql = "select distinct StockItemName from TD_Txn_InvLine where Len(StockItemName)>2 order by StockItemName";
cmd = new SqlCommand(sql, Common.conn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
ddlData.lst_StockItemName.Add(Common.GetString(rdr["StockItemName"]));
}
rdr.Close();
//--- GodownName Drop Down ----
ddlData.lst_GodownName = new List <string>();
ddlData.lst_GodownName.Add("select");
sql = "Select Distinct GodownName from TD_Txn_StockDetails order by GodownName";
cmd = new SqlCommand(sql, Common.conn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
ddlData.lst_GodownName.Add(Common.GetString(rdr["GodownName"]));
}
rdr.Close();
//--- StockGroup Drop Down ----
ddlData.lst_StockGroup = new List <string>();
ddlData.lst_StockGroup.Add("select");
sql = "Select Distinct StockGroup from TD_Mst_StockItem order by StockGroup";
cmd = new SqlCommand(sql, Common.conn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
ddlData.lst_StockGroup.Add(Common.GetString(rdr["StockGroup"]));
}
rdr.Close();
}
catch (Exception ex)
{
}
finally
{
Common.CloseConnection();
}
return(ddlData);
}
