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); }