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 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 PrintOrExportDetails(bool Print) { string sType = string.Empty; switch (_iType) { case 1: sType = "(Day)"; break; case 2: sType = "(Drop)"; break; case 3: sType = "(Week)"; break; case 4: sType = "(Month)"; break; default: sType = ""; break; } string sReportName = txtHeader.Text.Trim() + sType; using (CReportViewer cReportViewer = new CReportViewer()) { if (dtPrintDetails.Rows.Count > 0) { cReportViewer.ShowReportsAnalysisDetails(dtPrintDetails, sReportName, Print, TotalAvgBet, string.Empty); } } }
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 PrintOrExportDetails(bool Print) { try { string sType = string.Empty; if (ParentElement != AnalysisDetailsParent.SiteInterrogration) { switch (_iType) { case 1: sType = "(Day)"; break; case 2: sType = "(Drop)"; break; case 3: sType = "(Week)"; break; case 4: sType = "(Month)"; break; default: sType = ""; break; } } string sReportName = this.Caption.Trim() + sType; using (CReportViewer cReportViewer = new CReportViewer()) { if (dtPrintDetails.Rows.Count > 0) { string sAnalysisDetails = string.Empty; lstAnalysisDetails.SelectAllCells(); lstAnalysisDetails.ClipboardCopyMode = (Microsoft.Windows.Controls.DataGridClipboardCopyMode)DataGridClipboardCopyMode.IncludeHeader; ApplicationCommands.Copy.Execute(null, lstAnalysisDetails); lstAnalysisDetails.UnselectAllCells(); try { sAnalysisDetails = (string)Clipboard.GetData(DataFormats.CommaSeparatedValue); Clipboard.Clear(); } catch { MessageBox.ShowBox("MessageID56"); } cReportViewer.ShowReportsAnalysisDetails(dtPrintDetails, sReportName, Print, TotalAvgBet, sAnalysisDetails); } } } 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 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 GetVoucherCouponLiabilityReport(DateTime dtIssueDate,string sDeviceType,string sVoucherStatus ) { try { LogManager.WriteLog("Inside GetVoucherCouponLiabilityReport method", LogManager.enumLogLevel.Info); if (dtIssueDate > System.DateTime.Now) { MessageBox.ShowBox("MessageID285", BMC_Icon.Information); return; } IReports objReports = ReportsBusinessObject.CreateInstance(); DataSet dtDetails = objReports.GetVoucherCouponLiabilityReport(dtIssueDate, sDeviceType, sVoucherStatus); if (dtDetails.Tables[0].Rows.Count == 0) { MessageBox.ShowBox("MessageID261", BMC_Icon.Information); return; } using (CReportViewer cReportViewer = new CReportViewer()) { cReportViewer.ShowVoucherCouponLiabilityReport("VoucherCouponLiabilityReport", dtDetails, dtIssueDate, sDeviceType, sVoucherStatus); cReportViewer.ShowDialog(); } } catch (Exception ex) { ExceptionManager.Publish(ex); MessageBox.ShowBox("MessageID262", BMC_Icon.Error); } }
private void ShowAccountingWinLossReport(int ZoneNo, int MachineCategoryNo, DateTime StartDate, DateTime EndDate, string ZoneName, string Category, bool IncludeNonCashable) { try { LogManager.WriteLog("Inside ShowAccountingWinLossReport method", LogManager.enumLogLevel.Info); if (StartDate > EndDate) { MessageBox.ShowBox("MessageID286", BMC_Icon.Information); return; } if (StartDate > System.DateTime.Now) { MessageBox.ShowBox("MessageID287", BMC_Icon.Information); return; } if (EndDate > System.DateTime.Now) { MessageBox.ShowBox("MessageID288", BMC_Icon.Information); return; } IReports objReports = ReportsBusinessObject.CreateInstance(); DataSet dtDataset = objReports.GetAccountingWinLossReport(ZoneNo,MachineCategoryNo,StartDate, EndDate, IncludeNonCashable); if (dtDataset.Tables[0].Rows.Count == 0) { MessageBox.ShowBox("MessageID261", BMC_Icon.Information); return; } using (CReportViewer cReportViewer = new CReportViewer()) { cReportViewer.ShowAccountingWinLossReport("AccountingWinLossReport", dtDataset, ZoneNo, MachineCategoryNo, StartDate, EndDate, ZoneName, Category, IncludeNonCashable); cReportViewer.ShowDialog(); } } catch (Exception ex) { ExceptionManager.Publish(ex); MessageBox.ShowBox("MessageID262", BMC_Icon.Error); } }
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); } }
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); } }
private void ShowExceptionVoucherDetailReport(DateTime dtFromDate, DateTime dtToDate, Int32 BatchNumber,string SiteCode) { try { LogManager.WriteLog("Inside GetExceptionVoucherDetailReport method", LogManager.enumLogLevel.Info); if (dtFromDate > dtToDate) { MessageBox.ShowBox("MessageID286", BMC_Icon.Information); return; } if (dtFromDate > System.DateTime.Now) { MessageBox.ShowBox("MessageID287", BMC_Icon.Information); return; } if (dtToDate > System.DateTime.Now) { MessageBox.ShowBox("MessageID288", BMC_Icon.Information); return; } IReports objReports = ReportsBusinessObject.CreateInstance(); DataSet dtDataset = objReports.GetExceptionVoucherDetails(dtFromDate, dtToDate, chkDropBased.IsChecked, BatchNumber); if (dtDataset.Tables[0].Rows.Count == 0) { MessageBox.ShowBox("MessageID261", BMC_Icon.Information); return; } using (CReportViewer cReportViewer = new CReportViewer()) { cReportViewer.ShowExceptionVoucherDetail("ExceptionVoucherDetails", dtDataset, dtFromDate, dtToDate, chkDropBased.IsChecked, BatchNumber,SiteCode); cReportViewer.ShowDialog(); } } catch (Exception ex) { ExceptionManager.Publish(ex); MessageBox.ShowBox("MessageID262", BMC_Icon.Error); } }
private void button_Click(object sender, RoutedEventArgs e) { try { int InstallationNumber = 0; int ValidationLength = 0; string _Barcode = this.ucValueCalc.txtDisplay.Text.Trim(); System.Windows.Forms.DialogResult _diagResult; btnVerify.IsEnabled = false; if (isScannerFired) //check done not to fire the verify event twice while verifying a ticket using scanner { isScannerFired = false; return; } if ((sender is System.Windows.Controls.TextBox)) isScannerFired = true; else isScannerFired = false; if (this.ucValueCalc.txtDisplay.Text.Trim().Length > 0) { //8-digit ticket validation. //Slot ticket cannot be redeemed via cashdesk. if (this.ucValueCalc.txtDisplay.Text.Trim().Length != 18) { LinqDataAccessDataContext linqDBExchange = new LinqDataAccessDataContext(CommonDataAccess.ExchangeConnectionString); IEnumerable<InstallationFromTicket> InstallationTicket = linqDBExchange.GetInstallationNumber(_Barcode); if (InstallationTicket != null) { foreach (var item in InstallationTicket) { InstallationNumber = item.installation_no.Value; _Barcode = item.strbarcode; } DataTable InstallationDetails = (new CommonDataAccess()).GetInstallationDetails(0, InstallationNumber, false, false); if (InstallationDetails.Rows.Count > 0) { int.TryParse(InstallationDetails.Rows[0]["Validation_length"].ToString(), out ValidationLength); if (ValidationLength != _Barcode.Length) { MessageBox.ShowBox("MessageID403", BMC_Icon.Error); return; } } } } TicketsHelper objTicketsHelper = new TicketsHelper(); int? nResult = -1; decimal dAmount = 0; int iTransactionNo = 0; int iSequenceNo = 0; //foreach (var obj in objTicketsHelper.ValidateVoidVoucher(this.ucValueCalc.txtDisplay.Text.Trim(), ref nResult)) //{ // dAmount = Convert.ToDecimal(obj.iAmount)/100; //} dAmount = objTicketsHelper.ValidateVoidVoucher(_Barcode, Security.SecurityHelper.CurrentUser.User_No, ref nResult); switch (nResult) { case 0: { if (Convert.ToBoolean(AppSettings.REDEEM_TICKET_POP_UP_ALERT_VISIBILITY)) { //Message: Are you sure you want to Void the Voucher? _diagResult = MessageBox.ShowBox("MessageID512", BMC_Icon.Question, BMC_Button.YesNo, this.ucValueCalc.txtDisplay.Text.Trim(), Convert.ToString(dAmount)); if (_diagResult == System.Windows.Forms.DialogResult.No) return; } else { _diagResult = System.Windows.Forms.DialogResult.Yes; } if (_diagResult == System.Windows.Forms.DialogResult.Yes) { string barcode = this.ucValueCalc.txtDisplay.Text.Trim(); foreach (var obj in objTicketsHelper.UpdateVoidVoucher(barcode, System.Environment.MachineName, Security.SecurityHelper.CurrentUser.User_No, txtNotes.Text)) { iTransactionNo = (int)obj.iTransactionNo; iSequenceNo = obj.TE_ID; } // TIS Printed Tickets if (VoucherHelper.IsTISPrintedTicket(barcode)) { VoucherHelper.SendTISVoidTicket(barcode, Security.SecurityHelper.CurrentUser.User_No); } //Message: "Voucher Voided Successfully." MessageBox.ShowBox("MessageID513", BMC_Icon.Information); //Receipt BMC.Business.CashDeskOperator.Reports objReports = new BMC.Business.CashDeskOperator.Reports(); string sCode = BMC.Transport.Settings.SiteCode; using (CReportViewer objReportViewer = new CReportViewer()) { objReportViewer.PrintVoidVoucherReceipt(System.Environment.MachineName, this.ucValueCalc.txtDisplay.Text.Trim(), dAmount, iTransactionNo, sCode, iSequenceNo); //objReportViewer.ShowDialog(); } Audit(this.ucValueCalc.txtDisplay.Text.Trim(), dAmount, "Voucher Voided Successfully"); lblVoidAmountValue.Visibility = Visibility.Visible; lblVoidAmount.Visibility = Visibility.Visible; lblVoidAmountValue.Text = string.Empty; lblVoidAmountValue.Text = dAmount.ToString("0.00"); } break; } case 1: { //Voucher Not Found //Message: "Voucher is not available in System" MessageBox.ShowBox("MessageID514", BMC_Icon.Error); Audit(this.ucValueCalc.txtDisplay.Text.Trim(), dAmount, "Voucher Not Found"); lblVoidAmount.Visibility = Visibility.Hidden; lblVoidAmountValue.Visibility = Visibility.Hidden; //Audit break; } case 2: { // Invalid for Slots, only CashDesk is allowed. //Message: "Void is applicable only for Cash Desk Vouchers" MessageBox.ShowBox("MessageID515", BMC_Icon.Error); Audit(this.ucValueCalc.txtDisplay.Text.Trim(), dAmount, "Void is applicable only for Cash Desk Vouchers"); //Audit lblVoidAmount.Visibility = Visibility.Hidden; lblVoidAmountValue.Visibility = Visibility.Hidden; break; } case 3: { //PAID Status // Message: "Voucher has already been redeemed." MessageBox.ShowBox("MessageID516", BMC_Icon.Error); Audit(this.ucValueCalc.txtDisplay.Text.Trim(), dAmount, "Voucher has already been redeemed"); lblVoidAmount.Visibility = Visibility.Hidden; lblVoidAmountValue.Visibility = Visibility.Hidden; //Audit break; } case 4: { //Already Voided // Message: "Voucher has already been Voided." MessageBox.ShowBox("MessageID517", BMC_Icon.Error); Audit(this.ucValueCalc.txtDisplay.Text.Trim(), dAmount, "Voucher has already been Voided"); lblVoidAmount.Visibility = Visibility.Hidden; lblVoidAmountValue.Visibility = Visibility.Hidden; //Audit break; } case 5: { //Expired Date // Message: "Voucher has expired." MessageBox.ShowBox("MessageID518", BMC_Icon.Error); Audit(this.ucValueCalc.txtDisplay.Text.Trim(), dAmount, "Voucher has expired"); lblVoidAmount.Visibility = Visibility.Hidden; lblVoidAmountValue.Visibility = Visibility.Hidden; //Audit break; } } } else { //Message: "Please enter or scan a valid Voucher Number MessageBox.ShowBox("MessageID519", BMC_Icon.Warning); this.ucValueCalc.txtDisplay.Focus(); } ClearAll(); } catch (Exception ex) { MessageBox.ShowBox("MessageID520", BMC_Icon.Error); BMC.Common.ExceptionManagement.ExceptionManager.Publish(ex); ClearAll(); } finally { btnVerify.IsEnabled = true; } }
private void ShowExpenseDetailsReport(DateTime reportDate, string reportPeriod,bool IsGamingDayBasedReport,string SiteCode) { try { LogManager.WriteLog("Inside ShowExpenseDetailsReport method", LogManager.enumLogLevel.Info); if (reportDate > System.DateTime.Now) { MessageBox.ShowBox("MessageID281", BMC_Icon.Information); return; } IReports objReports = ReportsBusinessObject.CreateInstance(); LogManager.WriteLog("Fetching report data from database...", LogManager.enumLogLevel.Info); DataSet expenseDetails = objReports.GetExpenseDetails(reportDate, reportPeriod, IsGamingDayBasedReport); if (expenseDetails.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.ShowExpenseDetailsReport(expenseDetails, reportDate, reportPeriod, IsGamingDayBasedReport,SiteCode); cReportViewer.ShowDialog(); } LogManager.WriteLog("ShowExpenseDetailsReport Successfull", LogManager.enumLogLevel.Info); } catch (Exception ex) { ExceptionManager.Publish(ex); MessageBox.ShowBox("MessageID262", BMC_Icon.Error); } }
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 PrintSpotCheckReport() { Installations objInstallationDetails = tvMachineList.SelectedItem as Installations; if (objInstallationDetails == null) return; List<SpotCheck> lstSpotCheck = new List<SpotCheck>(); lstSpotCheck = lstSpotCheckSummaryDetails.Where(item => item.InstallationNo == objInstallationDetails.Installation_No).ToList(); if (lstSpotCheck == null || lstSpotCheck.Count <= 0) return; using (CReportViewer cReportViewer = new CReportViewer()) { cReportViewer.ShowSpotCheckReport( objInstallationDetails.Bar_Position_Name, objInstallationDetails.Zone_Name.IsNullOrEmpty() ? string.Empty : objInstallationDetails.Zone_Name, objInstallationDetails.GameTitle,//(Convert.ToDecimal(objInstallationDetails.POP) / 100).ToString(), (Convert.ToDecimal(objInstallationDetails.POP)).ToString(), lstSpotCheck[0].DateTimeStamp, (lstSpotCheck[0].CashIn - lstSpotCheck[0].CashOut), lstSpotCheck[0].CashIn, Convert.ToDecimal(lstSpotCheck[0].Payout), Convert.ToDecimal(lstSpotCheck[0].CoinsDrop.ToString("#,##0.00")), lstSpotCheck[0].HandPay, lstSpotCheck[0].Date, Settings.SiteCode ); cReportViewer.ShowDialog(); } }
private void btnPrint_Click(object sender, RoutedEventArgs e) { try { CancelTask(ClearBinding: false); btnPrint.IsEnabled = false; lblStatus.Content = ""; progressBar1.Visibility = Visibility.Hidden; string sReportName = string.Empty; if ((bool)chkDay.IsChecked) { sReportName = chkDay.Content.ToString(); Audit_Print("Current Day Report ", DateTime.Now); } else if ((bool)chkDrop.IsChecked) { sReportName = chkDrop.Content.ToString(); Audit_Print("Current Drop Report ", DateTime.Now); } else if ((bool)chkWeek.IsChecked) { sReportName = chkWeek.Content.ToString(); Audit_Print("Current Week Report ", DateTime.Now); } else if ((bool)chkMonth.IsChecked) { sReportName = chkMonth.Content.ToString(); if (!Settings.ShowSystemCalendar) Audit_Print("Current Period Report ", DateTime.Now); else Audit_Print("Current Month Report ", DateTime.Now); } using (CReportViewer cReportViewer = new CReportViewer()) cReportViewer.ShowReportsPrintTab(dtPrint, sReportName, Settings.SiteCode); } finally { btnPrint.IsEnabled = true; } }
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 GetRedeemedTicketByDeviceReport(DateTime dtFromDate,DateTime dtToDate, string sDeviceType) { try { LogManager.WriteLog("Inside GetRedeemedTicketByDeviceReport method", LogManager.enumLogLevel.Info); if (dtFromDate > dtToDate) { MessageBox.ShowBox("MessageID286", BMC_Icon.Information); return; } if (dtFromDate > System.DateTime.Now) { MessageBox.ShowBox("MessageID287", BMC_Icon.Information); return; } if (dtToDate > System.DateTime.Now) { MessageBox.ShowBox("MessageID288", BMC_Icon.Information); return; } IReports objReports = ReportsBusinessObject.CreateInstance(); DataSet dtDataset = objReports.GetRedeemedTicketByDevice(dtFromDate, dtToDate, sDeviceType); //if (dtDataset.Tables[0].Rows.Count == 0) //{ // MessageBox.ShowBox("MessageID261", BMC_Icon.Information); // return; //} using (CReportViewer cReportViewer = new CReportViewer()) { cReportViewer.ShowRedeemedTicketByDevice("RedeemedTicketByDevice", dtDataset, dtFromDate, dtToDate, sDeviceType,SiteCode); cReportViewer.ShowDialog(); } } catch (Exception ex) { ExceptionManager.Publish(ex); MessageBox.ShowBox("MessageID262", BMC_Icon.Error); } }
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 ShowStackerLevelDetailReport(int StackerLevel) { try { IReports objReports = ReportsBusinessObject.CreateInstance(); LogManager.WriteLog("Fetching report data from database...", LogManager.enumLogLevel.Info); DataSet dsStackerDetails = objReports.GetStackerDetails(StackerLevel); //if (dsStackerDetails.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.ShowStackerLevelDetailReport(dsStackerDetails, StackerLevel,SiteCode); cReportViewer.ShowDialog(); } LogManager.WriteLog("ShowStackerLevelDetailReport Successfull", LogManager.enumLogLevel.Info); } catch (Exception ex) { ExceptionManager.Publish(ex); MessageBox.ShowBox("MessageID262", BMC_Icon.Error); } }
private void btnConfirm_Click(object sender, RoutedEventArgs e) { try { 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") { //Update advance retailer value //UpdateAdvanceRetailer(); //Calculate the retailer negative net //CalculateRetailerNegative(); //CalculateCarriedForwardAmount(); if (Entity.ProfitShareGroupId > 0) { //Sp call for profit share details CommonLiquidationDataContext objCommonLiquidation = new CommonLiquidationDataContext(CommonUtilities.ExchangeConnectionString); int LiquidationProfitShareResult = objCommonLiquidation.PerformLiquidationForProfitShare(null, _BatchNo, _entity.ProfitShareGroupId, _entity.ExpenseShareGroupID, _entity.ExpenseShareAmount, _entity.WriteOffAmount, _entity.PayPeriodId, _entity.Gross, _entity.Tickets_Expected, _entity.Net_Percentage, _entity.Retailer_Negative_Net, _entity.Net_Percentage, _entity.Tickets_Paid, _entity.Advance_To_Retailer, _entity.Retailer_Share, _entity.Balance_Due, _entity.Retailer, _entity.RetailerShareBeforeFixedExpense, _entity.CarriedForwardExpense, _entity.RetailerExpenseShareAmount, _entity.FixedExpenseAmount, _entity.PrevCarriedForwardExpense); //Report MessageBox.ShowBox("MessageID488", BMC_Icon.Information); //calling Audit Method Audit(true, _BatchNo); System.Windows.Forms.DialogResult res = MessageBox.ShowBox("MessageID491", 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(_BatchNo, null); cReportViewer.ShowDialog(); } } } else { MessageBox.ShowBox("MessageID490", BMC_Icon.Information); return; } this.Close(); } } catch (Exception ex) { ExceptionManager.Publish(ex); } }
private void ShowJackpotSlipSummaryReport(DateTime reportStartDateTime, DateTime reportEndDateTime) { try { LogManager.WriteLog("Inside ShowJackportSlipSummaryReport method", LogManager.enumLogLevel.Info); if (reportStartDateTime > reportEndDateTime) { MessageBox.ShowBox("MessageID282", BMC_Icon.Information); return; } if (reportStartDateTime > System.DateTime.Now) { MessageBox.ShowBox("MessageID283", BMC_Icon.Information); return; } if (reportEndDateTime > System.DateTime.Now) { MessageBox.ShowBox("MessageID288", BMC_Icon.Information); return; } IReports objReports = ReportsBusinessObject.CreateInstance(); LogManager.WriteLog("Fetching report data from database...", LogManager.enumLogLevel.Info); DataSet jackpotSlipSummaryDetails = objReports.GetJackpotSlipSummaryDetails(reportStartDateTime, reportEndDateTime,chkIncludeHandpay.IsChecked,chkIncludeJackpot.IsChecked); if (jackpotSlipSummaryDetails.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.ShowJackpotSlipSummaryReport(jackpotSlipSummaryDetails, reportStartDateTime, reportEndDateTime, chkIncludeHandpay.IsChecked,chkIncludeJackpot.IsChecked); cReportViewer.ShowDialog(); } LogManager.WriteLog("ShowJackportSlipSummaryReport Successfull", LogManager.enumLogLevel.Info); } catch (Exception ex) { ExceptionManager.Publish(ex); MessageBox.ShowBox("MessageID262", BMC_Icon.Error); } }
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 GetIssuedTicketReport(DateTime dtFromDate, DateTime dtToDate, string sStatus, string sSlot) { try { LogManager.WriteLog("Inside GetIssuedTicketReport method", LogManager.enumLogLevel.Info); if (dtFromDate > dtToDate) { MessageBox.ShowBox("MessageID286", BMC_Icon.Information); return; } if (dtFromDate > System.DateTime.Now) { MessageBox.ShowBox("MessageID287", BMC_Icon.Information); return; } if (dtToDate > System.DateTime.Now) { MessageBox.ShowBox("MessageID288", BMC_Icon.Information); return; } IReports objReports = ReportsBusinessObject.CreateInstance(); DataSet dtDataset = objReports.GetVoucherListingReport(dtFromDate, dtToDate, sStatus,sSlot); if (dtDataset.Tables[0].Rows.Count == 0) { MessageBox.ShowBox("MessageID261", BMC_Icon.Information); return; } using (CReportViewer cReportViewer = new CReportViewer()) { cReportViewer.ShowVoucherListingReport("VoucherListingReport", dtDataset, dtFromDate, dtToDate, sStatus,sSlot); cReportViewer.ShowDialog(); } } catch (Exception ex) { ExceptionManager.Publish(ex); MessageBox.ShowBox("MessageID262", BMC_Icon.Error); } }
public void CreateVaultCassettesCurrentDropReport(usp_Vault_DropResult Vault) { try { using (CReportViewer cReportViewer = new CReportViewer()) { cReportViewer.ShowVaultCurrentDropSlip(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), _isfinaldrop); cReportViewer.ShowDialog(); } LogManager.WriteLog("Show Vault Drop Transaction Slip Report Successfull", LogManager.enumLogLevel.Info); } catch (Exception ex) { ExceptionManager.Publish(ex); } }
private void ShowCrossPropertyLiabilityTransferSummaryReport(DateTime StartDate, DateTime EndDate) { try { LogManager.WriteLog("Inside ShowCrossPropertyLiabilityTransferSummaryReport method", LogManager.enumLogLevel.Info); if (StartDate > EndDate) { MessageBox.ShowBox("MessageID286", BMC_Icon.Information); return; } if (StartDate > System.DateTime.Now) { MessageBox.ShowBox("MessageID287", BMC_Icon.Information); return; } if (EndDate > System.DateTime.Now) { MessageBox.ShowBox("MessageID288", BMC_Icon.Information); return; } IReports objReports = ReportsBusinessObject.CreateInstance(); DataSet dtDataset = objReports.GetCrossPropertyLiabilityTransferSummaryReport(StartDate, EndDate); if (dtDataset.Tables[0].Rows.Count == 0) { MessageBox.ShowBox("MessageID261", BMC_Icon.Information); return; } using (CReportViewer cReportViewer = new CReportViewer()) { cReportViewer.ShowCrossPropertyLiabilityTransferSummaryReport("CrossPropertyLiabilityTransferDetailsReport", dtDataset, StartDate, EndDate); 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; } }
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 PrintOrExportDetails(bool Print) { string sType = string.Empty; switch (_iType) { case 1: sType = "(Day)"; break; case 2: sType = "(Drop)"; break; case 3: sType = "(Week)"; break; case 4: sType = "(Month)"; break; default: sType = ""; break; } string sReportName = txtHeader.Text.Trim() + sType; using (CReportViewer cReportViewer = new CReportViewer()) { if (dtPrintDetails.Rows.Count > 0) { cReportViewer.ShowReportsAnalysisDetails(dtPrintDetails, sReportName, Print, TotalAvgBet,string.Empty); } } }
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); } }
// /// <summary> /// Performs the auto cash dispense. /// </summary> /// <returns>True if succeeded; otherwise false.</returns> public bool AutoCashDispense(string fieldName, string fieldValue, decimal value) { DispenserWorkerResult result = DispenserWorkerResult.None; string message = string.Empty; this.EnsureDecksAreLoaded(); IDictionary<string, DeckDenomValue> pairs = new SortedDictionary<string, DeckDenomValue>(StringComparer.InvariantCultureIgnoreCase); string keyLower = "LOWER"; string keyUpper = "UPPER"; decimal upperCount = 0; decimal lowerCount = 0; decimal receiptAmount = 0; try { // Determine the number of counts from lower and upper deck decimal upperAvailAmount = this.UpperDeck.RemainingValueCalculated; decimal lowerAvailAmount = this.LowerDeck.RemainingValueCalculated; // denominations decimal upperDenom = this.UpperDeck.Denimination; decimal lowerDenom = this.LowerDeck.Denimination; if (lowerDenom > upperDenom) { // denom decimal tempDenom = lowerDenom; lowerDenom = upperDenom; upperDenom = tempDenom; // total amount decimal tempAmount = lowerAvailAmount; lowerAvailAmount = upperAvailAmount; upperAvailAmount = tempAmount; keyLower = "UPPER"; keyUpper = "LOWER"; } // mapping for upper and lower deck pairs.Add(keyLower, new DeckDenomValue() { Denomination = lowerDenom, Value = lowerAvailAmount }); pairs.Add(keyUpper, new DeckDenomValue() { Denomination = upperDenom, Value = upperAvailAmount }); // if valid amount is passed if (value > 0) { decimal inputValue = value; // upper count upperCount = Math.Floor(inputValue / pairs[keyUpper].Denomination); if (upperCount > pairs[keyUpper].TotalCount) { upperCount = pairs[keyUpper].TotalCount; } inputValue -= (upperCount * pairs[keyUpper].Denomination); // lower count lowerCount = Math.Floor(inputValue / pairs[keyLower].Denomination); if (lowerCount > pairs[keyLower].TotalCount) { lowerCount = pairs[keyLower].TotalCount; } inputValue -= (lowerCount * pairs[keyLower].Denomination); // updated values pairs[keyUpper].Value = upperCount; pairs[keyLower].Value = lowerCount; receiptAmount = inputValue; } // dispense result = this.Dispense(pairs["UPPER"].Value, pairs["LOWER"].Value, out message); if (result != (DispenserWorkerResult.Success | DispenserWorkerResult.LowerDeckOK | DispenserWorkerResult.UpperDeckOK)) { LogManager.WriteLog(message, LogManager.enumLogLevel.Error); } else { LogManager.WriteLog(message, LogManager.enumLogLevel.Info); } // try to print the remaing amount as receipt if (receiptAmount > 0) { try { using (CReportViewer objReportViewer = new CReportViewer()) { objReportViewer.PrintCashDispenserReceipt(System.Environment.MachineName, fieldName, fieldValue, Convert.ToDecimal(receiptAmount)); } } catch (Exception ex) { ExceptionManager.Publish(ex); } } WriteAuditLog(this.UpperDeck, this.LowerDeck, upperCount, lowerCount, "Receipt", receiptAmount); } catch (Exception ex) { ExceptionManager.Publish(ex); } return (result == (DispenserWorkerResult.Success | DispenserWorkerResult.LowerDeckOK | DispenserWorkerResult.UpperDeckOK)); }
private void btnPrint_Click(object sender, RoutedEventArgs e) { try { string SiteCode = ""; string AssetNumber = ""; string PosNumber = ""; this.Cursor = Cursors.Wait; btnPrint.IsEnabled = false; LogManager.WriteLog("Inside btnPrint_Click", LogManager.enumLogLevel.Info); IMeterLife meterLife = MeterLifeBusinessObject.CreateInstance(); meterLife.GetAssetDetails(this.InstallationNo, ref SiteCode, ref AssetNumber, ref PosNumber); if (lstView != null) { if (lstView.Items.Count > 0) { DataTable meterData = new DataTable(); meterData.TableName = "MachineMeters"; meterData.Columns.Add("Meter"); meterData.Columns.Add("Start"); meterData.Columns.Add("Current"); meterData.Columns.Add("Difference"); meterData.Columns.Add("Value"); meterData.Columns.Add("SiteCode"); meterData.Columns.Add("PosNumber"); meterData.Columns.Add("AssetNumber"); LogManager.WriteLog("Filling the Meter Datatable for Print Report...", LogManager.enumLogLevel.Info); foreach (DataRowView dvItem in lstView.Items) { DataRow meterRow = meterData.NewRow(); meterRow["Meter"] = dvItem["Meter"].ToString(); meterRow["Start"] = dvItem["Start"].ToString(); meterRow["Current"] = dvItem["Current"].ToString(); meterRow["Difference"] = dvItem["Difference"].ToString(); meterRow["Value"] = dvItem["Value"].ToString() != string.Empty ? Convert.ToDecimal(dvItem["Value"]).GetUniversalCurrencyFormatWithSymbol() : "NA"; meterRow["SiteCode"] = SiteCode; meterRow["PosNumber"] = PosNumber; meterRow["AssetNumber"] = AssetNumber; meterData.Rows.Add(meterRow); } LogManager.WriteLog("Meter Datatable filled successfully with Print Report Data.", LogManager.enumLogLevel.Info); CReportViewer cReportViewer = new CReportViewer(); cReportViewer.PrintMeterLifeReport(meterData); cReportViewer = null; meterData = null; } else { MessageBox.ShowBox("MessageID47"); } } else { MessageBox.ShowBox("MessageID47"); } } catch (Exception ex) { ExceptionManager.Publish(ex); } finally { this.Cursor = Cursors.Arrow; btnPrint.IsEnabled = true; } }
private void btnConfirm_Click(object sender, RoutedEventArgs e) { try { 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") { //Update advance retailer value //UpdateAdvanceRetailer(); //Calculate the retailer negative net //CalculateRetailerNegative(); //CalculateCarriedForwardAmount(); if (Entity.ProfitShareGroupId > 0) { //Sp call for profit share details CommonLiquidationDataContext objCommonLiquidation = new CommonLiquidationDataContext(CommonUtilities.ExchangeConnectionString); int LiquidationProfitShareResult = objCommonLiquidation.PerformLiquidationForProfitShare(null, _BatchNo, _entity.ProfitShareGroupId, _entity.ExpenseShareGroupID, _entity.ExpenseShareAmount, _entity.WriteOffAmount, _entity.PayPeriodId, _entity.Gross, _entity.Tickets_Expected, _entity.Net_Percentage, _entity.Retailer_Negative_Net, _entity.Net_Percentage, _entity.Tickets_Paid, _entity.Advance_To_Retailer, _entity.Retailer_Share, _entity.Balance_Due, _entity.Retailer, _entity.RetailerShareBeforeFixedExpense, _entity.CarriedForwardExpense, _entity.RetailerExpenseShareAmount, _entity.FixedExpenseAmount, _entity.PrevCarriedForwardExpense); //Report MessageBox.ShowBox("MessageID488", BMC_Icon.Information); //calling Audit Method Audit(true,_BatchNo); System.Windows.Forms.DialogResult res = MessageBox.ShowBox("MessageID491", 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(_BatchNo, null); cReportViewer.ShowDialog(); } } } else { MessageBox.ShowBox("MessageID490", BMC_Icon.Information); return; } this.Close(); } } 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 Print(IList<UndeclaredCollectionRecord> collectionRecords, string userName) { int batchNo = 0; int nMachineCount = 0; string sDropType = string.Empty; string sExchangeConnectionString = string.Empty; string sTicketConnectionString = string.Empty; DataSet DSDeclaration; ILiquidationDetails details = LiquidationBusinessObject.CreateInstance(); try { batchNo = ((UndeclaredCollection)cboMachineType.SelectedItem).Collection_Batch_No; nMachineCount = collectionRecords.Count - 1; sDropType = string.Empty; foreach (UndeclaredCollectionRecord Collection in collectionRecords) { /*if (sDropType == string.Empty) { sDropType = Collection.Type == "Defloat" ? "Final" : "Standard"; } else*/ { switch (Collection.Type) { case "Defloat": if (!sDropType.Contains("Final")) sDropType = sDropType + (sDropType.Length >0?", ":"") + "Final"; break; case "Total": break; default: if (!sDropType.Contains("Standard")) sDropType = sDropType + (sDropType.Length > 0 ? ", " : "") + "Standard"; break; } } } if (collectionRecords.Count >1) { if (collectionRecords[1].CollectionBatchNo == 0) { sDropType = "Part"; } } bool bAddShortPay = false; try { bAddShortPay = Convert.ToBoolean(details.GetSetting("AddShortpayInVoucherOut")); } catch{} DSDeclaration = GetBatchDataset(collectionRecords, bAddShortPay); if (DSDeclaration.Tables[0].Rows.Count == 0) { MessageBox.ShowBox("MessageID261", BMC_Icon.Information); return; } if (isCommonCDOforDeclaration) { sExchangeConnectionString = (cboSiteCode.SelectedItem as SiteConfig).ExchangeConnectionString; sTicketConnectionString = (cboSiteCode.SelectedItem as SiteConfig).TicketConnectionString; } using (CReportViewer cReportViewer = new CReportViewer()) { cReportViewer.ShowDeclarationReport(DSDeclaration, userName, batchNo, nMachineCount, sDropType, sExchangeConnectionString, sTicketConnectionString); cReportViewer.ShowDialog(); } } catch (Exception ex) { ExceptionManager.Publish(ex); MessageBox.ShowBox("MessageID262", BMC_Icon.Error); } }