private void ShowMeterListReport(string installationNo, string assetNo) { DataSet dsMeterDetails = null; DataSet dsMeterDetail = null; try { LogManager.WriteLog("Inside ShowMeterListReport method", LogManager.enumLogLevel.Info); dsMeterDetails = new DataSet(); IReports objReports = ReportsBusinessObject.CreateInstance(); if (installationNo == "ALL") { LogManager.WriteLog("Fetching Asset Numbers from database....", LogManager.enumLogLevel.Info); DataTable dtAssetNumbers = objReports.GetAssetNumberforActiveInstallations(); if (dtAssetNumbers.Rows.Count > 0) { LogManager.WriteLog("Asset Numbers fetched successfully from database", LogManager.enumLogLevel.Info); foreach (DataRow dataRow in dtAssetNumbers.Rows) { LogManager.WriteLog(string.Format("{0} - {1}", "Fetching report data from database for Installation No", dataRow["InstallationNo"].ToString()), LogManager.enumLogLevel.Info); dsMeterDetail = objReports.GetMeterDetails(Convert.ToInt32(dataRow["InstallationNo"])); LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info); LogManager.WriteLog("Merging dataset...", LogManager.enumLogLevel.Info); dsMeterDetails.Merge(dsMeterDetail); LogManager.WriteLog("Merge dataset Successfull", LogManager.enumLogLevel.Info); if (dsMeterDetail != null) { dsMeterDetail = null; } } } else { LogManager.WriteLog("Asset Number not available - Return", LogManager.enumLogLevel.Info); MessageBox.ShowBox("MessageID261", BMC_Icon.Information); return; } } else { LogManager.WriteLog("Fetching report data from database...", LogManager.enumLogLevel.Info); dsMeterDetails = objReports.GetMeterDetails(Convert.ToInt32(installationNo)); LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info); } if (dsMeterDetails.Tables[0].Rows.Count == 0) { LogManager.WriteLog("No Records found for the selected criteria - Return", LogManager.enumLogLevel.Info); MessageBox.ShowBox("MessageID261", BMC_Icon.Information); return; } using (CReportViewer cReportViewer = new CReportViewer()) { cReportViewer.ShowMeterListReport(dsMeterDetails, assetNo); cReportViewer.ShowDialog(); } LogManager.WriteLog("ShowMeterListReport Successfull", LogManager.enumLogLevel.Info); } catch (Exception ex) { ExceptionManager.Publish(ex); MessageBox.ShowBox("MessageID262", BMC_Icon.Error); } }