protected void getReport()
    {
        try
        {
            Report_DA_PatientVisits.LocalReport.DataSources.Clear();
            // Set a DataSource to the report
            // First Parameter - Report DataSet Name
            // Second Parameter - DataSource Object i.e DataTable
            DateTime FromDt = DateTime.Parse(txtFromDate.Text.Trim(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;
            DateTime ToDt   = DateTime.Parse(txtToDt.Text.Trim(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;

            DataTable dt = objRptBL.FetchDA_PaitentVisitsBAL(Session["UniqueInstId"].ToString(), FromDt, ToDt, Convert.ToInt16(ddlStartTime.SelectedItem.Text), Convert.ToInt16(ddlEndTime.SelectedItem.Text), ConnKey);
            if (dt.Rows.Count > 0)
            {
                Report_DA_PatientVisits.LocalReport.DataSources.Add(new ReportDataSource("Ds_Rpt_DA_PatientVisits", dt));
                // OR Set Report Path
                Report_DA_PatientVisits.LocalReport.ReportPath = HttpContext.Current.Server.MapPath("~/RDLCReports/Rpt_Analysis_PaitentVisits.rdlc");
                // Refresh and Display Report
                Report_DA_PatientVisits.LocalReport.Refresh();
                //btnImgprint.Visible = true;
                Report_DA_PatientVisits.Visible = true;
                lblNoRecordFound.Visible        = false;
                lblNoRecordFound.Visible        = false;
                btnImgprint.Visible             = true;
            }
            else
            {
                lblNoRecordFound.Visible        = true;
                Report_DA_PatientVisits.Visible = false;
                lblNoRecordFound.Text           = "No Record Found!!";
                btnImgprint.Visible             = false;
                //btnImgprint.Visible = false;
            }
        }
        catch (Exception ex)
        {
            Response.Redirect("~/Error.aspx");
        }
    }
Ejemplo n.º 2
0
    private void PrintAllReports(string ReportName)
    {
        try
        {
            LocalReport Report = new LocalReport();
            Report.DataSources.Clear();
            // Set a DataSource to the report
            // First Parameter - Report DataSet Name
            // Second Parameter - DataSource Object i.e DataTable
            if (ReportName == "PtRegStats")
            {
                DateTime FromDt = DateTime.Parse(Session["FromDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;
                DateTime ToDt   = DateTime.Parse(Session["ToDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;


                Report.DataSources.Add(new ReportDataSource("DS_VisitCount", ObjIns.FetchPaitentVisitCountBAL(Session["UniqueInstId"].ToString(), FromDt, ToDt, ConnKey)));
                // OR Set Report Path
                Report.ReportPath = HttpContext.Current.Server.MapPath("~/RDLCReports/Rpt_PaitentVistCount.rdlc");
                // Refresh and Display Report
                Report.Refresh();
            }
            else if (ReportName == "PtRegAbstract")
            {
                DateTime FromDt = DateTime.Parse(Session["FromDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;
                DateTime ToDt   = DateTime.Parse(Session["ToDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;


                Report.DataSources.Add(new ReportDataSource("Ds_Rpt_Visit_ReVisit_Abstract", ObjIns.FetchPaitentVisitCount_AbstractBAL(Session["UniqueInstId"].ToString(), FromDt.ToString("yyyy"), FromDt.ToString("MM"), ToDt.ToString("yyyy"), ToDt.ToString("MM"), ConnKey)));
                // OR Set Report Path
                Report.ReportPath = HttpContext.Current.Server.MapPath("~/RDLCReports/Rpt_PaitentVistCount_Abstract.rdlc");
                // Refresh and Display Report
                Report.Refresh();
            }
            else if (ReportName == "FeeCollected")
            {
                DateTime FromDt = DateTime.Parse(Session["FromDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;
                DateTime ToDt   = DateTime.Parse(Session["ToDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;

                Report.DataSources.Add(new ReportDataSource("DS_RptFeeCollected", ObjIns.FetchFeecollectedBAL(Session["UniqueInstId"].ToString(), FromDt, ToDt, ConnKey)));
                // OR Set Report Path
                Report.ReportPath = HttpContext.Current.Server.MapPath("~/RDLCReports/FeeCollectedRpt.rdlc");
                // Refresh and Display Report
                Report.Refresh();
            }
            else if (ReportName == "DailyStocksIssued")
            {
                DateTime FromDt = DateTime.Parse(Session["FromDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;
                DateTime ToDt   = DateTime.Parse(Session["ToDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;
                Report.DataSources.Add(new ReportDataSource("Ds_Rpt_Ph_DailyStocksIssued", ObjRptBL.Rpt_Ph_DailyStocksIssuedBAL(FromDt, ToDt, Session["DistCode"].ToString(), Session["InsId"].ToString(), Session["DrugCode"].ToString(), ConnKey)));
                // OR Set Report Path
                Report.ReportPath = HttpContext.Current.Server.MapPath("~/RDLCReports/Rpt_Ph_DailyStocksIssued.rdlc");
                // Refresh and Display Report
                Report.Refresh();
            }
            else if (ReportName == "Abstract_StocksIssued")
            {
                DateTime FromDt = DateTime.Parse(Session["FromDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;
                DateTime ToDt   = DateTime.Parse(Session["ToDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;
                Report.DataSources.Add(new ReportDataSource("Ds_Rpt_StocksIssued_Abstract", ObjRptBL.Rpt_Ph_StocksIssued_AbstractBAL(FromDt.ToString("yyyy"), FromDt.ToString("MM"), ToDt.ToString("yyyy"), ToDt.ToString("MM"), Session["DistCode"].ToString(), Session["InsId"].ToString(), Session["DrugCode"].ToString(), ConnKey)));
                // OR Set Report Path
                Report.ReportPath = HttpContext.Current.Server.MapPath("~/RDLCReports/Rpt_Ph_StocksIssued_Abstract.rdlc");
                // Refresh and Display Report
                Report.Refresh();
            }
            else if (ReportName == "DailyStocksRcvd")
            {
                DateTime FromDt = DateTime.Parse(Session["FromDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;
                DateTime ToDt   = DateTime.Parse(Session["ToDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;
                Report.DataSources.Add(new ReportDataSource("Ds_Rpt_Ph_DailyStocksRcvd", ObjRptBL.Rpt_Ph_DailyStocksRcvdBAL(FromDt, ToDt, Session["DistCode"].ToString(), Session["InsId"].ToString(), Session["DrugCode"].ToString(), ConnKey)));
                // OR Set Report Path
                Report.ReportPath = HttpContext.Current.Server.MapPath("~/RDLCReports/Rpt_Ph_DailyStocksRcvd.rdlc");
                // Refresh and Display Report
                Report.Refresh();
            }
            else if (ReportName == "DrugsAvailability")
            {
                Report.DataSources.Add(new ReportDataSource("DS_RptDrugAvailability", objPhar.getDrugsAvailBAL1(Session["UniqueInstId"].ToString(), Session["DrugCodeList"].ToString(), Session["Sort"].ToString(), Session["Order"].ToString(), ConnKey)));
                // OR Set Report Path
                Report.ReportPath = HttpContext.Current.Server.MapPath("~/RDLCReports/Rpt_DrugAvailability.rdlc");
                // Refresh and Display Report
                Report.Refresh();
            }
            else if (ReportName == "DrugsIssuedByRegNo")
            {
                DateTime Dt = DateTime.Parse(Session["SelDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;
                Report.DataSources.Add(new ReportDataSource("Ds_Rpt_Ph_DrugsIssuedByRegNo", ObjRptBL.Rpt_Ph_DrugsIssuedByRegNoBAL(Dt, Session["InsId"].ToString(), Session["RegNo"].ToString(), ConnKey)));
                // OR Set Report Path
                Report.ReportPath = HttpContext.Current.Server.MapPath("~/RDLCReports/Rpt_Ph_DrugsIssuedByRegNo.rdlc");
                // Refresh and Display Report
                Report.Refresh();
            }
            else if (ReportName == "DA_PatientVisits")
            {
                DateTime FromDt = DateTime.Parse(Session["FromDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;
                DateTime ToDt   = DateTime.Parse(Session["ToDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;

                Report.DataSources.Add(new ReportDataSource("Ds_Rpt_DA_PatientVisits", ObjRptBL.FetchDA_PaitentVisitsBAL(Session["UniqueInstId"].ToString(), FromDt, ToDt, Convert.ToInt16(Session["StartTime"].ToString()), Convert.ToInt16(Session["EndTime"].ToString()), ConnKey)));
                // OR Set Report Path
                Report.ReportPath = HttpContext.Current.Server.MapPath("~/RDLCReports/Rpt_Analysis_PaitentVisits.rdlc");
                // Refresh and Display Report
                Report.Refresh();
            }
            else if (ReportName == "DiagTestBill")
            {
                DateTime TestDate = DateTime.Parse(Session["TestDate"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;
                Report.DataSources.Add(new ReportDataSource("DS_RptDiagTest", objDiag.GetTestRepotBAL(Session["RegNo"].ToString(), Session["UniqueInstId"].ToString(), TestDate, ConnKey)));
                // OR Set Report Path
                Report.ReportPath = HttpContext.Current.Server.MapPath("~/RDLCReports/Rpt_DiagTest.rdlc");
                //Refresh and Display Report
                Report.Refresh();
            }
            else if (ReportName == "DiagFeeCollected")
            {
                DateTime FromDt = DateTime.Parse(Session["FromDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;
                DateTime ToDt   = DateTime.Parse(Session["ToDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;

                Report.DataSources.Add(new ReportDataSource("DS_Rpt_DiagTestFeeCollected", objDiag.FetchFeecollectedBAL(Session["UniqueInstId"].ToString(), FromDt, ToDt, ConnKey)));
                // OR Set Report Path
                Report.ReportPath = HttpContext.Current.Server.MapPath("~/RDLCReports/DiagFeeCollectedRpt.rdlc");
                // Refresh and Display Report
                Report.Refresh();
            }
            else if (ReportName == "PatientDtlsstatistics")
            {
                if (Session["ATypeCd"].ToString() == "ALL")
                {
                    DateTime FromDt = DateTime.Parse(Session["FromDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;
                    DateTime ToDt   = DateTime.Parse(Session["ToDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;
                    Report.DataSources.Add(new ReportDataSource("DataSet1", ObjIns.GetAnimalReportBAL(Session["UniqueInstId"].ToString(), Session["AnimalTypeCode"].ToString(), FromDt, ToDt, ConnKey)));
                    // OR Set Report Path
                    Report.ReportPath = HttpContext.Current.Server.MapPath("~/RDLCReports/Rpt_TotalPaitentCount.rdlc");
                    // Refresh and Display Report
                    Report.Refresh();
                }
                else if (Session["ATypeCd"].ToString() == "R")
                {
                    ReportParameter rp     = new ReportParameter("AnimalTypeCode", Session["AnimalTypeCode"].ToString());
                    ReportParameter rp1    = new ReportParameter("Status", Session["Status"].ToString());
                    DateTime        FromDt = DateTime.Parse(Session["FromDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;
                    DateTime        ToDt   = DateTime.Parse(Session["ToDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;

                    Report.DataSources.Add(new ReportDataSource("Ds_PatientDtls", ObjIns.GetAtypeRptBAL(Session["UniqueInstId"].ToString(), Session["AnimalTypeCode"].ToString(), Session["Status"].ToString(), FromDt, ToDt, ConnKey)));
                    // OR Set Report Path
                    Report.ReportPath = HttpContext.Current.Server.MapPath("~/RDLCReports/Rpt_AnimalTypeWiseDtls.rdlc");
                    Report.SetParameters(new ReportParameter[] { rp });
                    Report.SetParameters(new ReportParameter[] { rp1 });
                    // Refresh and Display Report
                    Report.Refresh();
                }
                else if (Session["ATypeCd"].ToString() == "T")
                {
                    ReportParameter rp     = new ReportParameter("AnimalTypeCode", Session["AnimalTypeCode"].ToString());
                    ReportParameter rp1    = new ReportParameter("Status", Session["Status"].ToString());
                    DateTime        FromDt = DateTime.Parse(Session["FromDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;
                    DateTime        ToDt   = DateTime.Parse(Session["ToDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;

                    Report.DataSources.Add(new ReportDataSource("Ds_PatientDtls", ObjIns.GetAtypeALL1BAL(Session["UniqueInstId"].ToString(), FromDt, ToDt, ConnKey)));
                    // OR Set Report Path
                    Report.ReportPath = HttpContext.Current.Server.MapPath("~/RDLCReports/Rpt_AnimalTypeWiseDtls.rdlc");
                    Report.SetParameters(new ReportParameter[] { rp });
                    Report.SetParameters(new ReportParameter[] { rp1 });
                    // Refresh and Display Report
                    Report.Refresh();
                }
            }
            else if (ReportName == "DBTotInstitutions")
            {
                Report.DataSources.Add(new ReportDataSource("DS_Rpt_DB_TotInstitutions", ObjRptBL.FetchDB_TotInstutionsBAL(Session["StateCd"].ToString(), Session["UniqueInstId"].ToString(), ConnKey)));
                // OR Set Report Path
                Report.ReportPath = HttpContext.Current.Server.MapPath("~/RDLCReports/Rpt_DB_TotInstitutions.rdlc");
                // Refresh and Display Report
                Report.Refresh();
            }
            else if (ReportName == "DBTotRegistrations")
            {
                Report.DataSources.Add(new ReportDataSource("DS_Rpt_DB_TotRegistrations", ObjRptBL.FetchDB_TotRegistrationsBAL(Session["StateCd"].ToString(), Session["UniqueInstId"].ToString(), Session["RegType"].ToString(), ConnKey)));
                // OR Set Report Path
                Report.ReportPath = HttpContext.Current.Server.MapPath("~/RDLCReports/Rpt_DB_TotRegistrations.rdlc");
                // Refresh and Display Report
                Report.Refresh();
            }
            else if (ReportName == "DBTotDrugIssued")
            {
                Report.DataSources.Add(new ReportDataSource("DS_Rpt_DB_TotDrugIssued", ObjRptBL.FetchDB_TotDrugIssuedBAL(Session["statecd"].ToString(), Session["UniqueInstId"].ToString(), ConnKey)));
                // OR Set Report Path
                Report.ReportPath = HttpContext.Current.Server.MapPath("~/RDLCReports/Rpt_DB_TotDrugsIssued.rdlc");
                // Refresh and Display Report
                Report.Refresh();
            }
            else if (ReportName == "PatientHistory")
            {
                Report.DataSources.Add(new ReportDataSource("Ds_Rpt_PatientHistory", ObjRptBL.GetPatientHistoryDtlsBAL(Session["UniqueInstId"].ToString(), Session["RegNo"].ToString(), ConnKey)));
                // OR Set Report Path
                Report.ReportPath = HttpContext.Current.Server.MapPath("~/RDLCReports/Rpt_PatientHistory.rdlc");
                // Refresh and Display Report
                Report.Refresh();
            }
            else if (ReportName == "Diag_MnthlyAbs")
            {
                Report.DataSources.Add(new ReportDataSource("Ds_Rpt_Diag_MonthlyAbstract", ObjRptBL.FetchDiag_MnthlyAbstractBAL(Session["UniqueInstId"].ToString(), Session["FromYr"].ToString(), Session["FromMnth"].ToString(), Session["ToYr"].ToString(), Session["ToMnth"].ToString(), ConnKey)));
                // OR Set Report Path
                Report.ReportPath = HttpContext.Current.Server.MapPath("~/RDLCReports/Rpt_Diag_MonthlyAbstarct.rdlc");
                // Refresh and Display Report
                Report.Refresh();
            }
            else if (ReportName == "FeedbackAnalysis")
            {
                DateTime FromDt = DateTime.Parse(Session["FromDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;
                DateTime ToDt   = DateTime.Parse(Session["ToDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;
                Report.DataSources.Add(new ReportDataSource("Ds_Rpt_FeedbackAnalysis", ObjRptBL.FetchFeedbackAnalysisBAL(Session["UniqueInstId"].ToString(), FromDt, ToDt, ConnKey)));
                // OR Set Report Path
                Report.ReportPath = HttpContext.Current.Server.MapPath("~/RDLCReports/Rpt_FeedbackAnalysis.rdlc");
                // Refresh and Display Report
                Report.Refresh();
            }
            else if (ReportName == "SchemeWsDrugsIssued")
            {
                DateTime FromDt = DateTime.Parse(Session["FromDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;
                DateTime ToDt   = DateTime.Parse(Session["ToDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;

                Report.DataSources.Add(new ReportDataSource("DS_Rpt_PH_HospWs_ShcemeWs_DrugsIssued", ObjRptBL.GetSchemeWsDrugsIssuedBAL(Session["UniqueInstId"].ToString(), FromDt, ToDt, ConnKey)));
                // OR Set Report Path
                Report.ReportPath = HttpContext.Current.Server.MapPath("~/RDLCReports/Rpt_PH_HospWs_ShcemeWs_DrugsIssued.rdlc");
                // Refresh and Display Report
                Report.Refresh();
            }
            else if (ReportName == "Ben_Dst_SchemeWsDrugsIssued_AadharCatCnt")
            {
                DateTime FromDt = DateTime.Parse(Session["FromDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;
                DateTime ToDt   = DateTime.Parse(Session["ToDt"].ToString(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;

                Report.DataSources.Add(new ReportDataSource("DS_Rpt_SchemeWs_Aadhar_CatCnt", ObjRptBL.GetBenCnt_Dst_Ins_SchemeWsDrugsIssuedBAL("ALL", Session["SelDtCode"].ToString(), FromDt, ToDt, Session["WithAadhar"].ToString(), ConnKey)));
                // OR Set Report Path
                Report.ReportPath = HttpContext.Current.Server.MapPath("~/RDLCReports/Rpt_SchemeWs_Aadhar_CatCnt_.rdlc");
                // Refresh and Display Report
                Report.Refresh();
            }
            Export(Report);
            PrintReport();
        }
        catch (Exception ex)
        {
        }
    }