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 btnPrint_Click(object sender, RoutedEventArgs e) { try { IReports objReports = ReportsBusinessObject.CreateInstance(); using (CReportViewer objReportViewer = new CReportViewer()) { DataSet dtTISPromotionalDetails = objReports.GetTISPromotionalDetails(this.StartDate, this.EndDate, NoOfRecordsInPage); if (dtTISPromotionalDetails != null) { objReportViewer.PrintTISDetailsReport(dtTISPromotionalDetails, this.StartDate, this.EndDate, NoOfRecordsInPage); objReportViewer.SetOwner(this); objReportViewer.ShowDialog(); } else { MessageBox.ShowBox("MessageID550", BMC_Icon.Information); } } } catch (Exception ex) { ExceptionManager.Publish(ex); } }
private void btnPrint_Click(object sender, RoutedEventArgs e) { try { IReports objReports = ReportsBusinessObject.CreateInstance(); using (CReportViewer objReportViewer = new CReportViewer()) { DataSet dtPromotionalHistory = objReports.GetPromotionalTicketHistory(); if (dtPromotionalHistory != null) { objReportViewer.PrintPromotionalHistoryReport(dtPromotionalHistory); objReportViewer.SetOwner(Window.GetWindow(this)); objReportViewer.ShowDialog(); } else { MessageBox.ShowBox("MessageID550", BMC_Icon.Information); } } } 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 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 btnPrint_Click(object sender, RoutedEventArgs e) { try { bool TicketShow = true; if (!Security.SecurityHelper.HasAccess("BMC.Presentation.CashDeskManager.UserControls.CashDeskManagerAllDetails.lvViewAll.TicketValue")) { TicketShow = false; } btnPrint.IsEnabled = false; //DataSet _DtDetails = BMC.Common.Utilities.CollectionExtensions.ToDataSet<CashierTransactionsDetails>(lstCashierTransactionsDetails, "DetailsView"); BMC.Business.CashDeskOperator.Reports objReports = new BMC.Business.CashDeskOperator.Reports(); //DataSet _DtDetails = objReports.GetCashierTransactionsDetails(true, true, true, true, // true, true, true, true, // true, true, // true, true, true, true, // true, true, // true, true, // StartDate, EndDate, user, iRoute_No); if (dtTickets.Tables[0].Rows.Count == 0) { MessageBox.ShowBox("MessageID47"); return; } using (CReportViewer objReportViewer = new CReportViewer()) { objReportViewer.showDetailedReport(dtTickets, StartDate, EndDate, sFooterText, TicketShow); objReportViewer.SetOwner(this); objReportViewer.ShowDialog(); } } finally { btnPrint.IsEnabled = true; } }
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 CreateWeeklyExceptionSummaryReport(int WeekID) { try { using (CReportViewer cReportViewer = new CReportViewer()) { LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info); cReportViewer.ShowWeeklyExceptionSummary(WeekID); cReportViewer.SetOwner(Window.GetWindow(this)); cReportViewer.ShowDialog(); } } catch (Exception ex) { ExceptionManager.Publish(ex); } }
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 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); } }
/// <summary> /// Displays the Exception Summary Report for selected collection batch in a new dialog /// </summary> private void CreateExceptionSummaryReport() { try { using (CReportViewer cReportViewer = new CReportViewer()) { LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info); if (!string.IsNullOrEmpty(ExchangeConst) && !string.IsNullOrEmpty(TicketConst)) cReportViewer.ShowExceptionSummaryReport(_BatchID, ExchangeConst, TicketConst); else cReportViewer.ShowExceptionSummaryReport(_BatchID); cReportViewer.SetOwner(Window.GetWindow(this)); cReportViewer.ShowDialog(); } } 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 CreateVaultCassettesCurrentTransactionReport(usp_Vault_FillVaultResult Vault, string TransactionType) { try { using (CReportViewer cReportViewer = new CReportViewer()) { cReportViewer.ShowVaultCurrentTransactionSlip(Vault.Vault_ID, Vault.Name, Vault.Serial_NO, Vault.Manufacturer_Name, Vault.Type_Prefix, SecurityHelper.CurrentUser.DisplayName, Convert.ToDateTime(Vault.CreatedDate), Vault.IsWebServiceEnabled, Convert.ToDecimal(Vault.FillAmount), Convert.ToDecimal(Vault.TotalAmountOnFill), Convert.ToDecimal(Vault.CurrentBalance), TransactionType); cReportViewer.SetOwner(Window.GetWindow(this)); cReportViewer.ShowDialog(); } LogManager.WriteLog("Show Vault Transaction Slip Report Successfull", LogManager.enumLogLevel.Info); } 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 CreateLiquidationReport() { try { if (Settings.SGVI_Enabled) { CreateSGVILiquidationReport(); return; } IReports objReports = isCommonCDOforDeclaration ? ReportsBusinessObject.CreateInstance(ExchangeConst, TicketConst) : ReportsBusinessObject.CreateInstance(); LogManager.WriteLog("Check whether the Liquidation performed for the batch or not-Starts", LogManager.enumLogLevel.Info); int? iLiquidationPerformed = 0; int isLiquidationPerformedForBatch = objReports.CheckLiquidationPerformed(_BatchID, ref iLiquidationPerformed); if (isLiquidationPerformedForBatch == 0) { MessageBox.ShowBox("MessageID891", BMC_Icon.Information); return; } using (CReportViewer cReportViewer = new CReportViewer()) { LogManager.WriteLog("Launch the liquidation report", LogManager.enumLogLevel.Info); cReportViewer.ShowLiquidationReportForRead(_BatchID, null); cReportViewer.SetOwner(Window.GetWindow(this)); cReportViewer.ShowDialog(); } LogManager.WriteLog("ShowLiquidationReport 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); } }
private void btnPrint_Click(object sender, RoutedEventArgs e) { try { IReports objReports = ReportsBusinessObject.CreateInstance(); using (CReportViewer objReportViewer = new CReportViewer()) { DataSet dtTISPromotionalDetails= objReports.GetTISPromotionalDetails(this.StartDate,this.EndDate,NoOfRecordsInPage); if (dtTISPromotionalDetails != null) { objReportViewer.PrintTISDetailsReport(dtTISPromotionalDetails, this.StartDate, this.EndDate, NoOfRecordsInPage); objReportViewer.SetOwner(this); objReportViewer.ShowDialog(); } else { MessageBox.ShowBox("MessageID550", BMC_Icon.Information); } } } catch (Exception ex) { ExceptionManager.Publish(ex); } }
private void PrintonDrop(IList<UndeclaredCollectionRecord> collectionRecords, string userName) { // DataSet DeclarationPrint = CollectionExtensions.ToDataSet<UndeclaredCollectionRecord>(((IEnumerable<UndeclaredCollectionRecord>)Source), "DeclarationPrint"); int batchNo = 0; int nMachineCount = 0; string sDropType = string.Empty; var lineHeader = new DataTable(); var lineItem = new DataTable("DeclarationPrint"); var isFirstRecord = true; ILiquidationDetails details = LiquidationBusinessObject.CreateInstance(); bool bSGVIEnable = false; string sAutoTicketDeclare = string.Empty; lineHeader.Columns.Add("Date"); lineHeader.Columns.Add("DropNo"); lineHeader.Columns.Add("NoOfMachine"); lineHeader.Columns.Add("user"); lineHeader.Columns.Add("Bills"); lineHeader.Columns.Add("CoinsIn"); lineHeader.Columns.Add("TicketsIn"); lineHeader.Columns.Add("EFTIn"); lineHeader.Columns.Add("TotalCashIn"); lineHeader.Columns.Add("TicketsOut"); lineHeader.Columns.Add("EFTOut"); lineHeader.Columns.Add("CancelledCredits"); lineHeader.Columns.Add("Jackpots"); lineHeader.Columns.Add("CoinsOut"); lineHeader.Columns.Add("TotalCashOut"); lineHeader.Columns.Add("Asset"); lineHeader.Columns.Add("Pos"); //lineHeader.Columns.Add("NetWin"); lineItem.Columns.Add("Asset", typeof(string)); lineItem.Columns.Add("Pos", typeof(string)); lineItem.Columns.Add("Bills", typeof(decimal)); lineItem.Columns.Add("CoinsIn", typeof(decimal)); lineItem.Columns.Add("TicketsIn", typeof(decimal)); lineItem.Columns.Add("EFTIn", typeof(decimal)); lineItem.Columns.Add("TotalCashIn", typeof(decimal)); lineItem.Columns.Add("TicketsOut"); //lineItem.Columns.Add("EFTOut"); lineItem.Columns.Add("CancelledCredits", typeof(decimal)); //lineItem.Columns.Add("Jackpots"); //lineItem.Columns.Add("CoinsOut"); //lineItem.Columns.Add("TotalCashOut"); //lineItem.Columns.Add("NetWin"); try { batchNo = _batchnumberfordropPrint; nMachineCount = collectionRecords.Count - 1; bSGVIEnable = (Convert.ToBoolean(details.GetSetting("SGVI_Enabled")) && (details.GetSetting("Client") == "SGVI")); sAutoTicketDeclare = Convert.ToString(details.GetSetting("TicketDeclarationMethod")); foreach (var collectionRecord in collectionRecords) { //var dr = isFirstRecord ? lineHeader.NewRow() : lineItem.NewRow(); //if (isFirstRecord) { isFirstRecord = false; // continue; //} var dr = lineItem.NewRow(); sDropType = collectionRecord.Type == "defloat" ? "Final" : "Standard"; dr["Bills"] = collectionRecord.TotalBillValue; dr["CoinsIn"] = collectionRecord.TotalCoinsValue; dr["TicketsIn"] = collectionRecord.TicketsInValue; dr["EFTIn"] = collectionRecord.EFTInValue; dr["TotalCashIn"] = (collectionRecord.TotalBillValue + collectionRecord.TotalCoinsValue + collectionRecord.TicketsInValue); //dr["TotalCashIn"] = (collectionRecord.TotalBillValue + collectionRecord.TotalCoinsValue + collectionRecord.TicketsInValue)+ collectionRecord.EFTInValue); if (bSGVIEnable) { dr["TicketsOut"] = collectionRecord.TicketsOutValue;// + collectionRecord.ShortPayValue); dr["CancelledCredits"] = collectionRecord.AttendantPayValue; } else { if (sAutoTicketDeclare.ToUpper() == "AUTO") dr["TicketsOut"] = collectionRecord.TicketsOutValue; else dr["TicketsOut"] = (collectionRecord.TicketsOutValue + collectionRecord.ShortPayValue); dr["CancelledCredits"] = collectionRecord.AttendantPayValue + collectionRecord.JackpotValue; } //dr["Jackpots"] = collectionRecord.Jackpot; //dr["CoinsOut"] = ((decimal)collectionRecord.CoinOutValue).GetUniversalCurrencyFormatWithSymbol(); //dr["EFTOut"] = ((decimal)0).GetUniversalCurrencyFormatWithSymbol(); //dr["TotalCashOut"] = (collectionRecord.TicketsOutValue + collectionRecord.ShortPayValue + collectionRecord.HandpayValue + collectionRecord.JackpotValue + collectionRecord.CoinOutValue).GetUniversalCurrencyFormatWithSymbol(); //dr["NetWin"] = ((collectionRecord.TotalBillValue + collectionRecord.TotalCoinsValue + collectionRecord.TicketsInValue + collectionRecord.EFTInValue) // - (collectionRecord.TicketsOutValue + collectionRecord.HandpayValue + collectionRecord.JackpotValue + collectionRecord.ShortPayValue + collectionRecord.CoinOutValue)).GetUniversalCurrencyFormatWithSymbol(); //if (isFirstRecord) //{ // dr["Date"] = DateTime.Now.GetUniversalDateFormat(); // dr["DropNo"] = collectionRecords[1].CollectionBatchNo == 0 // ? (object)"Interm Collection" // : collectionRecords[1].CollectionBatchNo; // dr["NoOfMachine"] = collectionRecords.Count - 1; // dr["user"] = userName; // lineHeader.Rows.Add(dr); //} //else //{ dr["Asset"] = collectionRecord.AssetNo; dr["Pos"] = collectionRecord.Position; lineItem.Rows.Add(dr); // } isFirstRecord = false; } DataSet DSDeclaration = new DataSet("DeclarationPrint"); DSDeclaration.Tables.Add(lineItem); IReports objReports = ReportsBusinessObject.CreateInstance(); if (DSDeclaration.Tables[0].Rows.Count == 0) { MessageBox.ShowBox("MessageID261", BMC_Icon.Information); return; } using (CReportViewer cReportViewer = new CReportViewer()) { cReportViewer.DropSummaryReport(DSDeclaration, userName, batchNo, nMachineCount, sDropType); cReportViewer.SetOwner(Window.GetWindow(this)); cReportViewer.ShowDialog(); } } catch (Exception ex) { ExceptionManager.Publish(ex); MessageBox.ShowBox("MessageID262", BMC_Icon.Error); } }
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; } }