protected void DDLComLoc_SelectedIndexChanged(object sender, EventArgs e)
{
SqlParameter[] arr = new SqlParameter[2];
arr[0] = new SqlParameter("@Action", "SELECT_ByComID");
arr[1] = new SqlParameter("@ComID", DDLComLoc.SelectedValue);
DataSet ds = SqlHelper.ExecuteDataset(Connection.connect(), CommandType.StoredProcedure, "SP_Godown_CRUD", arr);
DDLNgoLoc.DataSource = ds;
DDLNgoLoc.DataTextField = "Name";
DDLNgoLoc.DataValueField = "ID";
DDLNgoLoc.DataBind();
DDLNgoLoc.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "0"));
}
private void BindNgoForRequest()
{
try
{
SqlParameter[] arr = new SqlParameter[1];
arr[0] = new SqlParameter("@Action", "SELECT");
DataSet ds = SqlHelper.ExecuteDataset(Connection.connect(), CommandType.StoredProcedure, "SP_Godown_CRUD", arr);
if (ds.Tables[0].Rows.Count > 0)
{
DDLNgoLoc.DataSource = ds.Tables[0];
DDLNgoLoc.DataTextField = "Name";
DDLNgoLoc.DataValueField = "ID";
DDLNgoLoc.DataBind();
DDLNgoLoc.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "0"));
}
}
catch (Exception ex)
{
ShowMessage(ex.Message, MessageType.Error);
}
}
private void BindDDLNGO(string ComID)
{
try
{
SqlParameter[] arrparm = new SqlParameter[2];
arrparm[0] = new SqlParameter("@Action", "SELECT_ByComID");
arrparm[1] = new SqlParameter("@CompanyID", ComID);
DataSet DSRecord = SqlHelper.ExecuteDataset(Connection.connect(), CommandType.StoredProcedure, "SP_BusinessLocation_CRUD", arrparm);
if (DSRecord.Tables[0].Rows.Count > 0)
{
DDLNgoLoc.DataSource = DSRecord.Tables[0];
DDLNgoLoc.DataTextField = "BusinessLocationName";
DDLNgoLoc.DataValueField = "ID";
DDLNgoLoc.DataBind();
DDLNgoLoc.Items.Insert(0, new ListItem("Select", "0"));
}
}
catch (Exception ex)
{
ShowMessage(ex.Message, MessageType.Error);
}
}
