protected void DDL_Dist_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
sqlObj = new SqlString(ComObj);
string str = "SELECT * FROM PurchaseCenterMaster,MarketingSeasonMaster where PurchaseCenterMaster.DistrictId = '" + DDL_Dist.SelectedValue + "' and PurchaseCenterMaster.MarkSeasId = '" + DDL_MarkSeas.SelectedValue + "' and cropyear ='" + DDL_CropYear.SelectedItem.Text + "' and MarketingSeasonMaster.MarkSeasId = PurchaseCenterMaster.MarkSeasId order by PurchaseCenterName ";
//string str = "SELECT * FROM PurchaseCenterMaster,MarketingSeasonMaster where PurchaseCenterMaster.DistrictId = '" + DDL_Dist.SelectedValue + "' and PurchaseCenterMaster.MarkSeasId = '" + DDL_MarkSeas.SelectedValue + "' and cropyear ='" + DDL_CropYear.Text + "' and MarketingSeasonMaster.MarkSeasId = PurchaseCenterMaster.MarkSeasId order by PurchaseCenterName ";
DataSet ds = sqlObj.selectAny(str);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
DDL_PC.DataSource = ds.Tables[0];
DDL_PC.DataTextField = "PurchaseCenterName";
DDL_PC.DataValueField = "PcId";
DDL_PC.DataBind();
}
else
{
DDL_PC.Items.Clear();
}
}
DDL_PC.Items.Insert(0, "--Select--");
}
catch (Exception ex)
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('" + ex.Message + "'); </script> ");
}
}
private void getPurchaseCenter(string distid, string mid, string cropyear)
{
PcObj = new PurchaseCenter(ComObj);
string str = "SELECT * FROM PurchaseCenterMaster,MarketingSeasonMaster where PurchaseCenterMaster.DistrictId = '" + distid + "' and PurchaseCenterMaster.MarkSeasId = '" + mid + "' and cropyear ='" + cropyear + "' and MarketingSeasonMaster.MarkSeasId = PurchaseCenterMaster.MarkSeasId order by PurchaseCenterName ";
DataSet ds = PcObj.selectAny(str);
if (ds == null)
{
}
else
{
if (ds.Tables[0].Rows.Count > 0)
{
DDL_PC.DataSource = ds.Tables[0];
DDL_PC.DataTextField = "PurchaseCenterName";
DDL_PC.DataValueField = "PcId";
DDL_PC.DataBind();
}
}
}
