private void btnPrint_Click(object sender, RoutedEventArgs e) { try { if (lstReadReport.Items.Count <= 0) { MessageBox.ShowBox("MessageID526", BMC_Icon.Information); return; } using (CReportViewer cReportViewer = new CReportViewer()) { ReadLiquidationReportRecords lstReadLiqRecords = lstReadReport.SelectedItem as ReadLiquidationReportRecords; if (lstReadLiqRecords == null) { MessageBox.ShowBox("MessageID527", BMC_Icon.Information); return; } cReportViewer.ShowLiquidationReportForRead(null, lstReadLiqRecords.ReadId); cReportViewer.SetOwner(Window.GetWindow(this)); cReportViewer.Show(); } } catch (Exception ex) { ExceptionManager.Publish(ex); } }
private void CreateOutstandingVaultdropReport() { try { using (CReportViewer cReportViewer = new CReportViewer()) { LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info); cReportViewer.ShowOutstandingVaultReport(false); cReportViewer.SetOwner(Window.GetWindow(this)); cReportViewer.Show(); } LogManager.WriteLog("Show Undeclared Drop Report Successfull", LogManager.enumLogLevel.Info); } catch (Exception ex) { ExceptionManager.Publish(ex); } }
private void CreateVaultEventDetailsReport(int Vault_Id, string Type, int No_Of_Records, string SearchKey, DateTime StartDate, DateTime EndDate) { try { using (CReportViewer cReportViewer = new CReportViewer()) { LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info); cReportViewer.ShowVaultEventDetailReport(Vault_Id, Type, No_Of_Records, SearchKey, StartDate, EndDate); cReportViewer.SetOwner(System.Windows.Window.GetWindow(this)); cReportViewer.Show(); } LogManager.WriteLog("Show Undeclared Drop Report Successfull", LogManager.enumLogLevel.Info); } catch (Exception ex) { ExceptionManager.Publish(ex); } }
private void btnPrint_Click(object sender, RoutedEventArgs e) { try { DataTable dtHistory = null; if (cmb_SelectTop.SelectedValue.ToString() == "All") { dtHistory = objVaultBiz.GetFillHistory(0, 0, ((rsp_Vault_GetTransactionTypesResult)cmbTransType.SelectedItem).TYPE_ID); } else { dtHistory = objVaultBiz.GetFillHistory(0, int.Parse(cmb_SelectTop.SelectedValue.ToString()), ((rsp_Vault_GetTransactionTypesResult)cmbTransType.SelectedItem).TYPE_ID); } if (dtHistory.Rows.Count == 0 || dtHistory.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()) { LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info); if (cmb_SelectTop.SelectedValue.ToString() == "All") { cReportViewer.ShowVaultFillHistory(dtHistory, 0, 0); } else cReportViewer.ShowVaultFillHistory(dtHistory, 0, int.Parse(cmb_SelectTop.SelectedValue.ToString())); cReportViewer.SetOwner(Window.GetWindow(this)); cReportViewer.Show(); } LogManager.WriteLog("ShowLiquidationReport Successfull", LogManager.enumLogLevel.Info); } catch (Exception Ex) { ExceptionManager.Publish(Ex); } }
void PrintDrop(DataRow drBalance) { try { if (drBalance != null) { using (CReportViewer cReportViewer = new CReportViewer()) { cReportViewer.ShowVaultCurrentDropSlip(int.Parse(cmb_DeviceName.SelectedValue.ToString()), drBalance["Name"].ToString(), drBalance["Serial_NO"].ToString(), drBalance["Manufacturer_Name"].ToString(), drBalance["Type_Prefix"].ToString(), SecurityHelper.CurrentUser.DisplayName, Convert.ToDateTime(drBalance["CreatedDate"]), Convert.ToBoolean(drBalance["IsWebServiceEnabled"]), Convert.ToDecimal(drBalance["FillAmount"]), Convert.ToDecimal(drBalance["TotalAmountOnFill"]), Convert.ToDecimal(drBalance["CurrentBalance"]), _IsFinalDrop); cReportViewer.SetOwner(System.Windows.Window.GetWindow(this)); cReportViewer.Show(); } } } catch (Exception Ex) { ExceptionManager.Publish(Ex); } }
public void CreateVaultCurrentBalanceSlipReport(int Vault_Id, string VaultName, string Serial_No, string Manufacturer_Name, string Type_Prefix, string LoginUser, DateTime CreatedDate, bool IsWebServiceEnabled, decimal FillAmount, decimal TotalAmountOnFill, decimal CurrentBalance) { try { using (CReportViewer cReportViewer = new CReportViewer()) { LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info); cReportViewer.ShowVaultCurrentBalanceSlip(Vault_Id, VaultName, Serial_No, Manufacturer_Name, Type_Prefix, LoginUser, CreatedDate, IsWebServiceEnabled, Convert.ToDecimal(FillAmount), Convert.ToDecimal(TotalAmountOnFill), Convert.ToDecimal(CurrentBalance)); cReportViewer.SetOwner(System.Windows.Window.GetWindow(this)); cReportViewer.Show(); } LogManager.WriteLog("Show Vault Current Balance Slip Report Successfull", LogManager.enumLogLevel.Info); } catch (Exception ex) { ExceptionManager.Publish(ex); } }
private void btnBalancing_Click(object sender, RoutedEventArgs e) { try { btnBalancing.IsEnabled = false; if (StartDate > EndDate) { MessageBox.ShowBox("MessageID282", BMC_Icon.Information); return; } if (StartDate > System.DateTime.Now) { MessageBox.ShowBox("MessageID283", BMC_Icon.Information); return; } if (EndDate > System.DateTime.Now) { MessageBox.ShowBox("MessageID284", BMC_Icon.Information); return; } IReports objReports = ReportsBusinessObject.CreateInstance(); LogManager.WriteLog("Fetching report data from database...", LogManager.enumLogLevel.Info); DataSet SystemBalancingDetails = null; switch (URoleBased.Count) { case 0: { if (Security.SecurityHelper.CurrentUser.User_No == UserNo) { SystemBalancingDetails = objReports.GetSystemBalancingDetails(StartDate, EndDate, UserNo, iRoute_No); } break; } case 1: { if (UserNo == 0) { SystemBalancingDetails = objReports.GetSystemBalancingDetails(StartDate, EndDate, 0, iRoute_No); } else { SystemBalancingDetails = objReports.GetSystemBalancingDetails(StartDate, EndDate, UserNo, iRoute_No); } break; } } if (SystemBalancingDetails.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()) { LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info); cReportViewer.ShowSystemBalancingReport(SystemBalancingDetails, StartDate, EndDate); cReportViewer.SetOwner(System.Windows.Window.GetWindow(this)); cReportViewer.Show(); } LogManager.WriteLog("ShowSystemBalancingReport Successfull", LogManager.enumLogLevel.Info); } catch (Exception ex) { ExceptionManager.Publish(ex); } finally { btnBalancing.IsEnabled = true; } }
private void btnTicketAnomalies_Click(object sender, RoutedEventArgs e) { try { if (StartDate > EndDate) { MessageBox.ShowBox("MessageID282", BMC_Icon.Information); return; } if (StartDate > System.DateTime.Now) { MessageBox.ShowBox("MessageID283", BMC_Icon.Information); return; } if (EndDate > System.DateTime.Now) { MessageBox.ShowBox("MessageID284", BMC_Icon.Information); return; } IReports objReports = ReportsBusinessObject.CreateInstance(); DataSet TicketAnomalies = null; TicketAnomalies = objReports.GetTicketAnomalies(StartDate, EndDate); LogManager.WriteLog("Fetching report data from database...", LogManager.enumLogLevel.Info); using (CReportViewer cReportViewer = new CReportViewer()) { LogManager.WriteLog("Report data fetched successfully from database Ticket Anomalies Report", LogManager.enumLogLevel.Info); cReportViewer.ShowTicketAnomaliesReport(StartDate, EndDate); cReportViewer.SetOwner(System.Windows.Window.GetWindow(this)); cReportViewer.Show(); } LogManager.WriteLog("Ticket Anomalies Report Successfull", LogManager.enumLogLevel.Info); } catch (Exception ex) { ExceptionManager.Publish(ex); } }
private void btnPrint_Click(object sender, RoutedEventArgs e) { try { btnPrint.IsEnabled = false; if (_worker.IsBusy) { MessageBox.ShowBox("MessageID368", BMC_Icon.Information); return; } if (StartDate > EndDate) { MessageBox.ShowBox("MessageID282", BMC_Icon.Information); return; } if (StartDate > System.DateTime.Now) { MessageBox.ShowBox("MessageID283", BMC_Icon.Information); return; } if (EndDate > System.DateTime.Now) { MessageBox.ShowBox("MessageID284", BMC_Icon.Information); return; } if (isDateChanged) { btnProcess_Click(sender, e); } IReports objReports = ReportsBusinessObject.CreateInstance(); LogManager.WriteLog("Fetching report data from database...", LogManager.enumLogLevel.Info); DataSet CashdeskDetails = null; String UserName = string.Empty; User lstUser = cboUser.SelectedItem as User; if (lstUser == null || String.IsNullOrEmpty(lstUser.UserName)) { UserName = SecurityHelper.CurrentUser.UserName; } else { UserName = lstUser.UserName; } CashdeskDetails = new DataSet(); //Add this list in order amount/count CashdeskDetails.Tables.Add("CDSummary"); CashdeskDetails.Tables["CDSummary"].Columns.Add("CDPaidAmount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("CDPaidCount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("CDPrintedAmount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("CDPrintedCount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("HandPayAmount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("HandPayCount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("JackpotAmount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("JackpotCount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("ProgAmount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("ProgCount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("ShortPayAmount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("ShortPayCount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("OfflineVoucherAmount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("OfflineVoucherCount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("VoidAmount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("VoidCount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("MCPaidAmount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("MCPaidCount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("MCPrintAmount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("MCPrintCount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("ActiveCashableVoucherAmount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("ActiveCashableVoucherCount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("VoidTicketsAmount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("VoidTicketsCount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("VoidVoucherAmount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("VoidVoucherCount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("CancelledAmount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("CancelledCount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("ExpiredAmount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("ExpiredCount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("TicketInExceptionAmount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("TicketInExceptionCount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("TicketOutExceptionAmount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("TicketOutExceptionCount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("CashableVoucherLiabilityAmount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("CashableVoucherLiabilityCount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("PromoCashableAmount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("PromoCashableCount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("NonCashableINAmount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("NonCashableINCount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("NonCashableOutAmount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("NonCashableOutCount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("OutstandingHandpaysAmount"); CashdeskDetails.Tables["CDSummary"].Columns.Add("OutstandingHandpaysCount"); CashdeskDetails.Tables["CDSummary"].Rows.Add(CashdeskDetails.Tables["CDSummary"].NewRow()); foreach (rsp_CDM_GetCashierTransactionsSummary item in _CashierHistory.Summary) { if (CashdeskDetails.Tables["CDSummary"].Columns.IndexOf(item.Summary_Type) < 0) continue; CashdeskDetails.Tables["CDSummary"].Rows[0][item.Summary_Type] = item.Amount.ToString(); CashdeskDetails.Tables["CDSummary"].Rows[0][CashdeskDetails.Tables["CDSummary"].Columns.IndexOf(item.Summary_Type) + 1] = item.Count_Summary.ToString(); } //= objReports.GetCashDeskReconcilationDetails(StartDate, EndDate); // CashdeskDetails = objReports.GetCashierTransactions(StartDate, EndDate, UserNo, iRoute_No); using (CReportViewer cReportViewer = new CReportViewer()) { LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info); cReportViewer.ShowCashierTransactionsHistoryReport(CashdeskDetails, StartDate, EndDate, UserNo, UserName, sRoute_Name, iRoute_No, CashdeskDetails.GetXml()); cReportViewer.SetOwner(System.Windows.Window.GetWindow(this)); cReportViewer.Show(); } LogManager.WriteLog("ShowCashDeskReconcilationReport Successfull", LogManager.enumLogLevel.Info); } catch (Exception ex) { ExceptionManager.Publish(ex); } finally { btnPrint.IsEnabled = true; } }
private void btnConfirm_Click(object sender, RoutedEventArgs e) { try { if (objCommonLiquidation.ProfitShareGroupId <= 0) { MessageBox.ShowBox("MessageID490", BMC_Icon.Information); return; } if (string.IsNullOrEmpty(txtAdvanceToRetailer.Text)) { MessageBox.ShowBox("MessageID370", BMC_Icon.Information); return; } decimal dAdvanceToRetailer = 0.0M; if (!CheckForValidAdvanceToRetailValue(out dAdvanceToRetailer)) { MessageBox.ShowBox("MessageID434", BMC_Icon.Information); return; } System.Windows.Forms.DialogResult dr = MessageBox.ShowBox("MessageID371", BMC_Icon.Question, BMC_Button.YesNo); if (dr.ToString() == "Yes") { //Calculate the retailer negative net CalculateRetailerNegative(); if (oReadLiquidationConfiguration.SaveLiquidation(objCommonLiquidation) == 0) { MessageBox.ShowBox("MessageID488", BMC_Icon.Information); Audit(true, objCommonLiquidation.Read_No); System.Windows.Forms.DialogResult res = MessageBox.ShowBox("MessageID251", BMC_Icon.Question, BMC_Button.YesNo); if (res == System.Windows.Forms.DialogResult.Yes) { using (CReportViewer cReportViewer = new CReportViewer()) { LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info); cReportViewer.ShowLiquidationReportForRead(null, objCommonLiquidation.Read_No); cReportViewer.SetOwner(this); cReportViewer.Show(); } } } else { MessageBox.ShowBox("MessageID489", BMC_Icon.Information); return; } this.Close(); } } catch (Exception ex) { ExceptionManager.Publish(ex); } }
private void CreateBatchWinLossReport() { try { //IReports objReports = ReportsBusinessObject.CreateInstance(); LogManager.WriteLog("Fetching report data from database...", LogManager.enumLogLevel.Info); using (CReportViewer cReportViewer = new CReportViewer()) { LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info); cReportViewer.ShowExceptionSummaryReport(_BatchID); cReportViewer.SetOwner(System.Windows.Window.GetWindow(this)); cReportViewer.Show(); } LogManager.WriteLog("ShowExceptionSummaryReport Successfull", LogManager.enumLogLevel.Info); } catch (Exception ex) { LogManager.WriteLog("Report" + ex.Message, LogManager.enumLogLevel.Info); } }
private void ShowCollectionReport() { try { LogManager.WriteLog("ShowCollectionReport Start", LogManager.enumLogLevel.Info); if (IsCommonCDO) { using (CReportViewer cReportViewer = new CReportViewer(_ExchangeConnectionString, _TicketingConnectionString)) { LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info); if (_BatchID > 0) { cReportViewer.ShowCollectionReport(_BatchID, 0); } cReportViewer.Show(); } } else { using (CReportViewer cReportViewer = new CReportViewer()) { LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info); if (_BatchID > 0) { cReportViewer.ShowCollectionReport(_BatchID, 0); } cReportViewer.Show(); } } LogManager.WriteLog("ShowCollectionReport Successfull", LogManager.enumLogLevel.Info); } catch (Exception ex) { ExceptionManager.Publish(ex); } }
private void CreateVarianceReport() { try { //IReports objReports = ReportsBusinessObject.CreateInstance(); LogManager.WriteLog("Fetching report data from database...", LogManager.enumLogLevel.Info); DataSet ExceptionDetails = objReports.GetExceptionSummary(_BatchID); if (ExceptionDetails.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; } if(IsCommonCDO) { using (CReportViewer cReportViewer = new CReportViewer(_ExchangeConnectionString, _TicketingConnectionString)) { LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info); cReportViewer.ShowVarianceReport(_BatchID, _ExchangeConnectionString, _TicketingConnectionString); cReportViewer.SetOwner(System.Windows.Window.GetWindow(this)); cReportViewer.Show(); } } else { using (CReportViewer cReportViewer = new CReportViewer()) { LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info); cReportViewer.ShowVarianceReport(_BatchID); cReportViewer.SetOwner(System.Windows.Window.GetWindow(this)); cReportViewer.Show(); } } LogManager.WriteLog("ShowExceptionSummaryReport Successfull", LogManager.enumLogLevel.Info); } catch (Exception ex) { LogManager.WriteLog("Report" + ex.Message, LogManager.enumLogLevel.Info); } }
private void CreateLiquidationReport() { try { //IReports objReports = ReportsBusinessObject.CreateInstance(); LogManager.WriteLog("Fetching report data from database...", LogManager.enumLogLevel.Info); DataSet LiquidationDetails = objReports.GetLiquidationDetails(_BatchID); DataSet LiquidationSummaryDetails = objReports.GetLiquidationSummaryDetails(_BatchID); if (LiquidationDetails.Tables[0].Rows.Count == 0 || LiquidationSummaryDetails.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()) { LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info); cReportViewer.ShowLiquidationReport(LiquidationDetails, LiquidationSummaryDetails, _BatchID); cReportViewer.SetOwner(System.Windows.Window.GetWindow(this)); cReportViewer.Show(); } LogManager.WriteLog("ShowLiquidationReport Successfull", LogManager.enumLogLevel.Info); } catch (Exception ex) { LogManager.WriteLog("Report" + ex.Message, LogManager.enumLogLevel.Info); } }