protected void drdReportType_SelectionChanged(object sender, Infragistics.Web.UI.ListControls.DropDownSelectionChangedEventArgs e)
 {
     if (Constants.ByRequsitions == drdReportType.SelectedItem.Text)
     {
         chkShowTotal.Enabled    = true;
         drdRequisitions.Enabled = true;
         drdItems.Enabled        = false;
         dgvReport.ClearDataSource();
         reportDT = getControl().getFilterDepartmentByRequisitions(drdDepartment.SelectedValue,
                                                                   drdEmployee.SelectedValue, chkShowTotal.Checked, drdRequisitions.SelectedValue
                                                                   , getDate(FromDate.Value.ToString()), getDate(ToDate.Value.ToString()));
         BindChart();
     }
     else if (Constants.ByItems == drdReportType.SelectedItem.Text)
     {
         chkShowTotal.Enabled    = false;
         chkShowTotal.Checked    = false;
         drdRequisitions.Enabled = false;
         drdItems.Enabled        = true;
         dgvReport.ClearDataSource();
         reportDT = getControl().getFilterDepartmentByItems(drdDepartment.SelectedValue,
                                                            drdEmployee.SelectedValue, drdItems.CurrentValue
                                                            , getDate(FromDate.Value.ToString()), getDate(ToDate.Value.ToString()));
     }
     BindData();
     Session["ReportData"] = reportDT;
 }
        protected void drdRequisitions_SelectionChanged(object sender, Infragistics.Web.UI.ListControls.DropDownSelectionChangedEventArgs e)
        {
            dgvReport.ClearDataSource();
            reportDT = getControl().getFilterDepartmentByRequisitions(drdDepartment.SelectedValue, drdEmployee.SelectedValue,
                                                                      chkShowTotal.Checked, drdRequisitions.CurrentValue, getDate(FromDate.Value.ToString()), getDate(ToDate.Value.ToString()));

            dgvReport.ClearDataSource();
            dgvReport.DataSource = reportDT;
            dgvReport.DataBind();

            if (reportDT != null && reportDT.Rows.Count > 0)
            {
                lblTotalCount.Text = "Total Count : " + reportDT.Rows.Count;
            }
            BindChart();
            Session["ReportData"] = reportDT;
        }
 protected void drdReportList_SelectionChanged(object sender, Infragistics.Web.UI.ListControls.DropDownSelectionChangedEventArgs e)
 {
     if (Constants.ItemReport == drdReportList.CurrentValue)
     {
         reportDT = getControl().getItems();
     }
     else if (Constants.StationeryCatalogueReport == drdReportList.CurrentValue)
     {
         reportDT = getControl().getCatalogue();
     }
     else if (Constants.ReorderReport == drdReportList.CurrentValue)
     {
         reportDT = getControl().getReorderDetails();
     }
     else if (Constants.ColletionReport == drdReportList.CurrentValue)
     {
         reportDT = getControl().getCollections();
     }
     else if (Constants.RequisitionReport == drdReportList.CurrentValue)
     {
         reportDT = getControl().getRequisitions();
     }
     else if (Constants.SupplierReport == drdReportList.CurrentValue)
     {
         reportDT = getControl().getSuppliers();
     }
     else if (Constants.UserReport == drdReportList.CurrentValue)
     {
         reportDT = getControl().getUsers();
     }
     else if (Constants.ItemPriceReport == drdReportList.CurrentValue)
     {
         reportDT = getControl().getUsers();
     }
     else if (Constants.DepartmentReport == drdReportList.CurrentValue)
     {
         reportDT = getControl().getDepartments();
     }
     else if (Constants.EmployeeReport == drdReportList.CurrentValue)
     {
         reportDT = getControl().getEmployees();
     }
     else if (Constants.RolesReport == drdReportList.CurrentValue)
     {
         reportDT = getControl().getRoles();
     }
     else if (Constants.ItemMovementReport == drdReportList.CurrentValue)
     {
         fillSupplier();
         panelSupplier.Visible         = true;
         drdSupplier.SelectedItemIndex = 0;
         reportDT = getControl().getItemMovement("C001");
         bindStockMovementChart();
     }
     else if (Constants.ItemConsumptionReport == drdReportList.CurrentValue)
     {
         fillData();
         FilterPanel.Visible             = true;
         lblNoDataAvailable.Visible      = false;
         drdReportType.SelectedItemIndex = 0;
         chkShowTotal.Enabled            = true;
         firstLoad();
         drdDepartment.SelectedItemIndex = 0;
     }
     else if (Constants.StationeryTenderReport == drdReportList.CurrentValue)
     {
         fillSupplier();
         panelSupplier.Visible         = true;
         drdSupplier.SelectedItemIndex = 0;
         reportDT = getControl().getTenderPrice(drdSupplier.SelectedValue);
     }
     PrepareData();
 }