public void BindDataset(string Category)
{
var objectDataSource = new Telerik.Reporting.ObjectDataSource();
string selectCommandText = "";
//Getting Datasouce
string connectionString = ConfigurationManager.ConnectionStrings["Reports.Properties.Settings.UFCWEntire"].ConnectionString;
//const string connectionString =
// "Data Source=.;Initial Catalog=UFCW_Entire;Integrated Security=True";
if (Category != "All")
{
selectCommandText = "SELECT (select Name from dbo.Benefits where Name='" + Category + "') as Benefits,(select COUNT(*) as Total from Members_Benefits where BenefitID in (select RecordID from Benefits where Name='" + Category + "')) as MembersCount,((select COUNT(*) as Total from Members_Benefits where BenefitID in (select RecordID from Benefits where Name='" + Category + "')) + (select COUNT(*) as Total from Members_Benefits a inner join Members_Dependence b on a.ReferenceID=b.ReferenceID where BenefitID in (select RecordID from Benefits where Name='" + Category + "'))) as MemDepCount";
}
SqlDataAdapter adapter = new SqlDataAdapter(selectCommandText, connectionString);
DataTable dt = new DataTable();
adapter.Fill(dt);
objectDataSource.DataSource = dt;
MagnaCareReport MagnaReport = new MagnaCareReport();
MagnaReport.DataSource = objectDataSource;
Telerik.Reporting.InstanceReportSource reportSource = new Telerik.Reporting.InstanceReportSource();
reportSource.ReportDocument = MagnaReport;
ReportViewer1.ReportSource = reportSource;
}
protected void Drp_shop_SelectedIndexChanged(object sender, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e)
{
string category = Drp_Benefits.SelectedItem.Text;
if (category == "All")
{
MagnaCareReport MagnaReport = new MagnaCareReport();
ReportViewer1.Report = MagnaReport;
}
else
{
BindDataset(category);
}
//string type = RadioButtonList1.SelectedValue;
}
protected void Page_Load(object sender, EventArgs e)
{
menu.GenerateMenu("Reports");
Submenu.GenerateMenu("Magnacare");
if (!IsPostBack)
{
Repository.Benefits.GetBenefitsMagnacare_cb(Drp_Benefits);
string category = Drp_Benefits.SelectedItem.Text;
//string type = RadioButtonList1.SelectedValue;
if (category == "All")
{
MagnaCareReport MagnaReport = new MagnaCareReport();
ReportViewer1.Report = MagnaReport;
}
}
}
