private void CommonTemplate_Load(object sender, EventArgs e)
        {
            try
            {
                ProgressBarControl progressBar = new ProgressBarControl();
                ProjectFunctions.ToolStripVisualize(Menu_ToolStrip);

                lbl.Text = Title;

                _RangeSelector = new RangeSelector()
                {
                    StartDate = GlobalVariables.FinYearStartDate, EndDate = GlobalVariables.FinYearEndDate
                };
                //_RangeSelector.DtFrom.EditValue = GlobalVariables.FinYearStartDate;
                //_RangeSelector.DtEnd.EditValue = GlobalVariables.FinYearEndDate;
                _RangeSelector.BtnLoad.Click += new EventHandler(BtnLoad_Click);
                _RangeSelector.Controls.Add(Chk_Selected);
                Chk_Selected.Text            = "Select Party";
                Chk_Selected.CheckedChanged += Chk_Selected_CheckedChanged;
                //RangeSelector.Chk_Selected.CheckedChanged += new EventHandler(Selected_CheckedChanged);
                Controls.Add(_RangeSelector);
                Controls.Add(progressBar);
                progressBar.Dock = DockStyle.Fill;
                _RangeSelector.Hide();
                ProjectFunctions.ButtonVisualize(_RangeSelector.BtnLoad);
                ProjectFunctions.DatePickerVisualize(_RangeSelector);
            }
            catch (Exception ex)
            {
                ProjectFunctions.SpeakError(ex.Message);
            }
        }
        private void BtnLoad_Click(object sender, EventArgs e)
        {
            try
            {
                Cursor.Current = Cursors.WaitCursor;
                StartDate      = _RangeSelector.DtFrom.DateTime.Date;
                EndDate        = _RangeSelector.DtEnd.DateTime.Date;
                DataRow Currentrow = HelpGrid.GetDataRow(HelpGrid.FocusedRowHandle);


                switch (GlobalVariables.ProgCode)
                {
                case "PROG143":
                    DataSet      Ds      = ProjectFunctions.GetDataSet(string.Format("Exec [Sp_CashBookRpt] '{0:yyyy-MM-dd}', '{1:yyyy-MM-dd}'", StartDate.Date, EndDate.Date));
                    rpt_CashBook RptDoc1 = new rpt_CashBook();
                    (RptDoc1.ReportDefinition.ReportObjects["txtCompanyName"] as TextObject).Text = GlobalVariables.CompanyName;
                    (RptDoc1.ReportDefinition.ReportObjects["txtReportHead"] as TextObject).Text  = "CASH BOOK";
                    (RptDoc1.ReportDefinition.ReportObjects["txtDateRange"] as TextObject).Text   = string.Format("From ({0} to {1}) ", StartDate.Date.ToString("dd-MM-yyyy"), EndDate.Date.ToString("dd-MM-yyyy"));
                    RptDoc1.SetDataSource(Ds.Tables[0]);
                    lbl.Text = string.Format(Title + " ({0} to {1}) ", StartDate.Date.ToString("dd-MM-yyyy"), EndDate.Date.ToString("dd-MM-yyyy"));
                    crystalReportViewer1.ReportSource = RptDoc1;
                    _RangeSelector.Hide();
                    break;

                case "PROG144":
                    HelpGrid.CloseEditor();
                    HelpGrid.UpdateCurrentRow();
                    DataSet      DsRecoBank = ProjectFunctions.GetDataSet(string.Format("Exec [SP_RecoBank] '{0:yyyy-MM-dd}', '253'", EndDate.Date));
                    rpt_BankReco RptDoc2    = new rpt_BankReco();
                    (RptDoc2.ReportDefinition.ReportObjects["txtCompanyName"] as TextObject).Text = GlobalVariables.CompanyName;
                    (RptDoc2.ReportDefinition.ReportObjects["txtReportName"] as TextObject).Text  = "Bank Reco";
                    (RptDoc2.ReportDefinition.ReportObjects["txtDateRange"] as TextObject).Text   = string.Format("From ({0} to {1}) ", StartDate.Date.ToString("dd-MM-yyyy"), EndDate.Date.ToString("dd-MM-yyyy"));
                    RptDoc2.SetDataSource(DsRecoBank.Tables[0]);
                    lbl.Text = string.Format(Title + " ({0} to {1}) ", StartDate.Date.ToString("dd-MM-yyyy"), EndDate.Date.ToString("dd-MM-yyyy"));
                    crystalReportViewer1.ReportSource = RptDoc2;
                    crystalReportViewer1.Show();
                    crystalReportViewer1.BringToFront();
                    _RangeSelector.Hide();
                    HelpGridCtrl.Hide();
                    break;

                case "PROG145":
                    DataSet     dsDayBook = ProjectFunctions.GetDataSet(string.Format("[Sp_PrepareDayBook] '{0:yyyy-MM-dd}', '{1:yyyy-MM-dd}'", StartDate.Date, EndDate.Date));
                    rpt_DayBook RptDoc3   = new rpt_DayBook();
                    (RptDoc3.ReportDefinition.ReportObjects["txtCompanyName"] as TextObject).Text = GlobalVariables.CompanyName;
                    (RptDoc3.ReportDefinition.ReportObjects["txtReportHead"] as TextObject).Text  = "Day Book";
                    (RptDoc3.ReportDefinition.ReportObjects["txtDateRange"] as TextObject).Text   = string.Format("From ({0} to {1}) ", StartDate.Date.ToString("dd-MM-yyyy"), EndDate.Date.ToString("dd-MM-yyyy"));
                    RptDoc3.SetDataSource(dsDayBook.Tables[0]);
                    lbl.Text = string.Format(Title + " ({0} to {1}) ", StartDate.Date.ToString("dd-MM-yyyy"), EndDate.Date.ToString("dd-MM-yyyy"));
                    crystalReportViewer1.ReportSource = RptDoc3;
                    crystalReportViewer1.Show();
                    crystalReportViewer1.BringToFront();
                    _RangeSelector.Hide();
                    break;

                case "PROG147":
                    DataSet      ds     = ProjectFunctions.GetDataSet(string.Format("[Sp_PrepareBankBook] '{0:yyyy-MM-dd}', '{1:yyyy-MM-dd}'", StartDate.Date, EndDate.Date));
                    Rpt_BankBook RptDoc = new Rpt_BankBook();
                    (RptDoc.Section2.ReportObjects["txtCompanyName"] as TextObject).Text = GlobalVariables.CompanyName;
                    (RptDoc.Section2.ReportObjects["txtReportName"] as TextObject).Text  = "Bank Book";
                    (RptDoc.Section2.ReportObjects["txtDateRange"] as TextObject).Text   = string.Format("From ({0} to {1}) ", StartDate.Date.ToString("dd-MM-yyyy"), EndDate.Date.ToString("dd-MM-yyyy"));
                    lbl.Text = string.Format(Title + " ({0} to {1})", StartDate.Date.ToString("dd-MM-yyyy"), EndDate.Date.ToString("dd-MM-yyyy"));
                    RptDoc.SetDataSource(ds.Tables[0]);
                    crystalReportViewer1.ReportSource = RptDoc;
                    crystalReportViewer1.Show();
                    crystalReportViewer1.BringToFront();
                    _RangeSelector.Hide();
                    break;

                case "PROG165":
                    if (Currentrow != null)
                    {
                        DataSet     dsLedger  = ProjectFunctions.GetDataSet(string.Format("[sp_ZoomPartyAct] '{0:yyyy-MM-dd}', '{1:yyyy-MM-dd}','{2}'", StartDate.Date, EndDate.Date, Currentrow["AccCode"].ToString()));
                        PartyLedger RptLedger = new PartyLedger();
                        (RptLedger.Section2.ReportObjects["txtCompanyName"] as TextObject).Text = GlobalVariables.CompanyName;
                        (RptLedger.Section2.ReportObjects["txtReportName"] as TextObject).Text  = "Party Ledger";
                        (RptLedger.Section2.ReportObjects["txtDateRange"] as TextObject).Text   = string.Format("From ({0} to {1}) ", StartDate.Date.ToString("dd-MM-yyyy"), EndDate.Date.ToString("dd-MM-yyyy"));
                        lbl.Text = string.Format(Title + " ({0} to {1})", StartDate.Date.ToString("dd-MM-yyyy"), EndDate.Date.ToString("dd-MM-yyyy"));
                        RptLedger.SetDataSource(dsLedger.Tables[0]);
                        crystalReportViewer1.ReportSource = RptLedger;
                        crystalReportViewer1.Show();
                        crystalReportViewer1.BringToFront();
                        _RangeSelector.Hide();
                    }
                    else
                    {
                        ProjectFunctions.SpeakError("Plz Select Party First");
                    }
                    break;

                default:
                    break;
                }
            }
            catch (Exception ex)
            {
                XtraMessageBox.Show(ex.Message);
            }
        }