private void btnShowReport_Click(object sender, EventArgs e) { try { this.Cursor = Cursors.WaitCursor; DataSet dsRecords = new DataSet(); DateTime dtCurrent = DateTime.Now; DateTime dtStartofDay = new DateTime(dtPickerStart.Value.Year, dtPickerStart.Value.Month, dtPickerStart.Value.Day, 0, 0, 0); DateTime dtEndofDay = new DateTime(dtPickerEnd.Value.Year, dtPickerEnd.Value.Month, dtPickerEnd.Value.Day, 23, 59, 59); CReportManager objReportMgnr = new CReportManager(); CResult objResult = objReportMgnr.GetInventorySalesRecords(dtStartofDay.Ticks, dtEndofDay.Ticks); dsRecords = (DataSet)objResult.Data; DataTable dtDetails = GetInventroySalesReport(dsRecords); if (dsRecords.Tables[0].Rows.Count > 0) { Int32 totalCovers = Convert.ToInt32("0" + dsRecords.Tables[0].Rows[0]["guest_count"].ToString()); rptSalesInterval objSales = new rptSalesInterval(); objSales.SetDataSource(dtDetails); objSales.SetParameterValue(0, dtPickerStart.Value.ToString("dd/MM/yyyy")); objSales.SetParameterValue(1, dtPickerEnd.Value.ToString("dd/MM/yyyy")); objSales.SetParameterValue(2, DateTime.Now.ToString("dd/MM/yyyy")); string reportHeader = RMSAdminController.CollectHeader(); string reportFooter = RMSAdminController.CollectFooter(); objSales.SetParameterValue(3, reportHeader); objSales.SetParameterValue(4, reportFooter); objSales.SetParameterValue(5, totalCovers.ToString()); RecportViewerCtl objRptViewer = new RecportViewerCtl(m_parentForm); objRptViewer.cRptViewerAdmin.ReportSource = objSales; m_parentForm.pnlContext.Controls.Clear(); objRptViewer.Parent = this; m_parentForm.pnlContext.Controls.Add(objRptViewer); objRptViewer.Dock = DockStyle.Fill; } else { MessageBox.Show("There is no record.", RMSGlobal.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Information); } this.Cursor = Cursors.Default; } catch (Exception exp) { throw exp; } }
private static void Init() { ConfigManager.Init(); ConfigManager.ReloadConfig(); CCommonConstants oTempConstant = ConfigManager.GetConfig<CCommonConstants>(); CDalConfig oTempDal = ConfigManager.GetConfig<CDalConfig>(); CLogin oLogin = new CLogin(); oLogin = (RmsRemote.CLogin)Activator.GetObject(typeof(RmsRemote.CLogin), oTempConstant.RemoteURL); CResult oResult = oLogin.GetInitialDBStr(); if (oResult.IsSuccess && oResult.Data != null) { DataSet dsRecords = new DataSet(); String oTempStr = (String)oResult.Data; oTempConstant.DBConnection = oTempStr; RMSGlobal.m_serverConnectionString = oTempConstant.DBConnection; CReportManager objReportMgnr = new CReportManager(); CResult objFoodType = objReportMgnr.GetFoodTypesRecords(); dsRecords = (DataSet)objFoodType.Data; m_foodTypeRecords=dsRecords.Tables[0]; objFoodType = objReportMgnr.GetFoodCategoryRecords(); dsRecords = (DataSet)objFoodType.Data; m_categoryRecords= dsRecords.Tables[0]; objFoodType = objReportMgnr.GetFoodItemRecords(); dsRecords = (DataSet)objFoodType.Data; m_foodItemRecords= dsRecords.Tables[0]; objFoodType = objReportMgnr.GetSelectionofItemsRecords(); dsRecords = (DataSet)objFoodType.Data; m_selectionItemRecords=dsRecords.Tables[0]; //m_initDataSet.Relations.Add("category1_to_category2", // m_foodTypeRecords.Columns["cat1_id"], // m_categoryRecords.Columns["cat1_id"], false); } }