protected void drdMonth_SelectionChanged(object sender, DropDownSelectionChangedEventArgs e)
        {
            if (!drdMonth.CurrentValue.Contains(","))
            {
                string fromDate = drdYear.SelectedItems[0].Value + "-" + (Convert.ToInt16(drdMonth.SelectedItems[0].Value)) + "-01";
                string todate   = drdYear.SelectedItems[0].Value + "-" + (Convert.ToInt16(drdMonth.SelectedItems[0].Value)) + "-" +
                                  System.DateTime.DaysInMonth(Convert.ToInt16(drdYear.SelectedValue), (Convert.ToInt16(drdMonth.SelectedItems[0].Value)));

                if (Constants.ByRequsitions == drdReportType.SelectedItem.Text)
                {
                    dgvReport.ClearDataSource();
                    reportDT = getControl().getFilterDepartmentByRequisitions(drdDepartment.SelectedValue,
                                                                              drdEmployee.SelectedValue, chkShowTotal.Checked, drdRequisitions.SelectedValue
                                                                              , fromDate, todate);
                    BindChart();
                }
                else if (Constants.ByItems == drdReportType.SelectedItem.Text)
                {
                    dgvReport.ClearDataSource();
                    reportDT = getControl().getFilterDepartmentByItems(drdDepartment.SelectedValue, drdEmployee.SelectedValue,
                                                                       drdItems.CurrentValue, fromDate, todate);
                }
            }
            else
            {
                string fromDate = string.Empty;
                string todate   = string.Empty;


                //for (int i = 0; i < s.Length; i++)
                //{
                for (int i = 0; i < drdMonth.SelectedItems.Count; i++)
                {
                    fromDate = fromDate + ";" + drdYear.SelectedItems[0].Value + "-" + drdMonth.SelectedItems[i].Value + "-01";
                    todate   = todate + ";" + drdYear.SelectedItems[0].Value + "-" + drdMonth.SelectedItems[i].Value + "-" +
                               System.DateTime.DaysInMonth(Convert.ToInt16(drdYear.SelectedItems[0].Value),
                                                           (Convert.ToInt16(drdMonth.SelectedItems[i].Value)));
                }
                //}

                if (Constants.ByRequsitions == drdReportType.SelectedItem.Text)
                {
                    dgvReport.ClearDataSource();
                    reportDT = getControl().getFilterDepartmentByRequisitions(drdDepartment.SelectedValue,
                                                                              drdEmployee.SelectedValue, chkShowTotal.Checked, drdRequisitions.SelectedValue
                                                                              , fromDate, todate);
                    BindChart();
                }
                else if (Constants.ByItems == drdReportType.SelectedItem.Text)
                {
                    dgvReport.ClearDataSource();
                    reportDT = getControl().getFilterDepartmentByItems(drdDepartment.SelectedValue, drdEmployee.SelectedValue,
                                                                       drdItems.CurrentValue, fromDate, todate);
                }
            }

            BindData();
            Session["ReportData"] = reportDT;
        }
 protected void drdItems_SelectionChanged(object sender, DropDownSelectionChangedEventArgs e)
 {
     dgvReport.ClearDataSource();
     reportDT = getControl().getFilterDepartmentByItems(drdDepartment.SelectedValue,
                                                        drdEmployee.SelectedValue, getSelectedValueFields(drdItems.SelectedItems),
                                                        getDate(FromDate.Value.ToString()), getDate(ToDate.Value.ToString()));
     BindData();
     Session["ReportData"] = reportDT;
 }
 protected void drdSupplier_SelectionChanged(object sender, DropDownSelectionChangedEventArgs e)
 {
     if (Constants.ItemMovementReport == drdReportList.CurrentValue)
     {
         reportDT = getControl().getItemMovement(drdSupplier.SelectedValue);
         BindData();
         bindStockMovementChart();
     }
     else
     {
         reportDT = getControl().getTenderPrice(drdSupplier.SelectedValue);
         BindData();
     }
 }
 protected void drdYear_SelectionChanged(object sender, DropDownSelectionChangedEventArgs e)
 {
     drdMonth_SelectionChanged(null, null);
 }
 protected void drdYear_SelectionChanged(object sender, DropDownSelectionChangedEventArgs e)
 {
     drdMonth_SelectionChanged(null, null);
 }
 protected void drdSupplier_SelectionChanged(object sender, DropDownSelectionChangedEventArgs e)
 {
     if (Constants.ItemMovementReport == drdReportList.CurrentValue)
     {
         reportDT = getControl().getItemMovement(drdSupplier.SelectedValue);
         BindData();
         bindStockMovementChart();
     }
     else
     {
         reportDT = getControl().getTenderPrice(drdSupplier.SelectedValue);
         BindData();
     }
 }
        protected void drdMonth_SelectionChanged(object sender, DropDownSelectionChangedEventArgs e)
        {
            if (!drdMonth.CurrentValue.Contains(","))
            {
                string fromDate = drdYear.SelectedItems[0].Value + "-" + (Convert.ToInt16(drdMonth.SelectedItems[0].Value)) + "-01";
                string todate = drdYear.SelectedItems[0].Value + "-" + (Convert.ToInt16(drdMonth.SelectedItems[0].Value)) +"-"+
                    System.DateTime.DaysInMonth(Convert.ToInt16(drdYear.SelectedValue), (Convert.ToInt16(drdMonth.SelectedItems[0].Value)));

                if (Constants.ByRequsitions == drdReportType.SelectedItem.Text)
                {
                    dgvReport.ClearDataSource();
                    reportDT = getControl().getFilterDepartmentByRequisitions(drdDepartment.SelectedValue,
                                    drdEmployee.SelectedValue, chkShowTotal.Checked, drdRequisitions.SelectedValue
                                    , fromDate, todate);
                    BindChart();
                }
                else if (Constants.ByItems == drdReportType.SelectedItem.Text)
                {
                    dgvReport.ClearDataSource();
                    reportDT = getControl().getFilterDepartmentByItems(drdDepartment.SelectedValue, drdEmployee.SelectedValue,
                        drdItems.CurrentValue, fromDate, todate);
                }
            }
            else
            {
                string fromDate = string.Empty;
                string todate = string.Empty;

                //for (int i = 0; i < s.Length; i++)
                //{
                for (int i = 0; i < drdMonth.SelectedItems.Count; i++)
                {
                    fromDate = fromDate + ";" + drdYear.SelectedItems[0].Value + "-" + drdMonth.SelectedItems[i].Value + "-01";
                    todate = todate + ";" + drdYear.SelectedItems[0].Value + "-" + drdMonth.SelectedItems[i].Value + "-" +
                        System.DateTime.DaysInMonth(Convert.ToInt16(drdYear.SelectedItems[0].Value),
                        (Convert.ToInt16(drdMonth.SelectedItems[i].Value)));
                }
                //}

                if (Constants.ByRequsitions == drdReportType.SelectedItem.Text)
                {
                    dgvReport.ClearDataSource();
                    reportDT = getControl().getFilterDepartmentByRequisitions(drdDepartment.SelectedValue,
                                    drdEmployee.SelectedValue, chkShowTotal.Checked, drdRequisitions.SelectedValue
                                    , fromDate, todate);
                    BindChart();
                }
                else if (Constants.ByItems == drdReportType.SelectedItem.Text)
                {
                    dgvReport.ClearDataSource();
                    reportDT = getControl().getFilterDepartmentByItems(drdDepartment.SelectedValue, drdEmployee.SelectedValue,
                        drdItems.CurrentValue, fromDate, todate);
                }
            }

            BindData();
            Session["ReportData"] = reportDT;
        }
 protected void drdItems_SelectionChanged(object sender, DropDownSelectionChangedEventArgs e)
 {
     dgvReport.ClearDataSource();
     reportDT = getControl().getFilterDepartmentByItems(drdDepartment.SelectedValue,
         drdEmployee.SelectedValue, getSelectedValueFields(drdItems.SelectedItems),
         getDate(FromDate.Value.ToString()), getDate(ToDate.Value.ToString()));
     BindData();
     Session["ReportData"] = reportDT;
 }