public List<TicketExceptions> GetTicketAnomalies(TicketsClaimed oTickets,List<string> lstPositions) { return cashdeskmanagerDataAccess.RetrieveTicketAnomalies(oTickets,lstPositions); }
private List<TicketExceptions> LoadLiabilities() { busTreasury = new TreasuryTransactions(); System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { lvLiability.Items.Clear(); }); List<string> lstPositionstoDisplay = busTreasury.FillListOfFilteredPositions(RouteNumber); TicketsClaimed oTicketsClaimed = new TicketsClaimed(); oTicketsClaimed.TicketsClaimedFrom = StartDate + " " + StartTime; oTicketsClaimed.TicketsClaimedTo = EndDate + " " + EndTime; Tickets oTickets = new Tickets(); oTickets.EndDate = EndDate + " " + EndTime; oTickets.StartDate = StartDate + " " + StartTime; oTickets.IsLiability = true; oTickets.BarCode = "%"; oTickets.Type = "C"; System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { prgLiability.Value += 50; }); List<TicketExceptions> lstTitoTicketsClaimed = busTreasury.TitoTicketsClaimedLiability(oTickets, lstPositionstoDisplay); if (lstTitoTicketsClaimed == null) { lstTitoTicketsClaimed = new List<TicketExceptions>(); } oTickets.Type = "P"; System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { prgLiability.Value += 50; }); List<TicketExceptions> lstTitoTicketsPrinted = busTreasury.TitoTicketsPrintedLiability(oTickets, lstPositionstoDisplay); //lvLiability.ItemsSource = lstTitoTicketsPrinted; if (lstTitoTicketsPrinted != null) { foreach (TicketExceptions item in lstTitoTicketsPrinted) { lstTitoTicketsClaimed.Add(item); } } System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { prgLiability.Value += 50; }); List<TicketExceptions> lstTicketsClaimed = busTreasury.TicketsClaimed(oTicketsClaimed, lstPositionstoDisplay); if (lstTicketsClaimed != null) { foreach (TicketExceptions item in lstTicketsClaimed) { lstTitoTicketsClaimed.Add(item); } //lvLiability.ItemsSource = lstTicketsClaimed; } System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { prgLiability.Value += 50; }); List<TicketExceptions> lstTicketsPrinted = busTreasury.TicketsPrinted(oTicketsClaimed, lstPositionstoDisplay); if (lstTicketsPrinted != null) { foreach (TicketExceptions item in lstTicketsPrinted) { lstTitoTicketsClaimed.Add(item); } // lvLiability.ItemsSource = lstTicketsPrinted; } float ExceptionTotal = 0F; TicketExceptions Total = new TicketExceptions(); Total.PrintDate = "Total"; foreach (TicketExceptions exep in lstTitoTicketsClaimed) { ExceptionTotal += (float)exep.Value; } Total.Value = ExceptionTotal; Total.Amount = ExceptionTotal.ToString(); lstTitoTicketsClaimed.Insert(0, Total); System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { prgLiability.Value += 50; }); return lstTitoTicketsClaimed; }
private List<TicketExceptions> LoadTicketAnomalies() { objCashDeskManager = CashDeskManagerBusinessObject.CreateInstance(); System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { lvTicketAnomalies.Items.Clear(); }); List<string> lstPositionstoDisplay = objCashDeskManager.FillListOfFilteredPositions(RouteNumber); TicketsClaimed oTicketsClaimed = new TicketsClaimed(); oTicketsClaimed.TicketsClaimedFrom = StartDate; oTicketsClaimed.TicketsClaimedTo = EndDate; oTicketsClaimed.UserNo = UserNo; System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { prgTicketAnomalies.Value += 75; }); List<TicketExceptions> lstTicketAnomalies = objCashDeskManager.GetTicketAnomalies(oTicketsClaimed, lstPositionstoDisplay); System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { prgTicketAnomalies.Value += 50; }); return lstTicketAnomalies; }
private static DataTable ExecuteTable( TicketsClaimed oTickets) { return SqlHelper.ExecuteDataset(GetTicketingConnectionString(), DBConstants.CONST_SP_RSP_GETPROMOTICKETFORPERIODDETAILS, GetSpParameters(oTickets)).Tables[0]; }
private static object[] GetSpParameters(TicketsClaimed oTicketsClaimed) { SqlParameter[] ObjParams = new SqlParameter[2]; ObjParams[0] = new SqlParameter(DBConstants.CONST_PARAM_STARTDATE, oTicketsClaimed.TicketsClaimedFrom); ObjParams[1] = new SqlParameter(DBConstants.CONST_PARAM_ENDDATE, oTicketsClaimed.TicketsClaimedTo); return ObjParams; }
public static DataTable GetPromoTickets(TicketsClaimed oTickets) { DataTable dtTickets = null; try { dtTickets = ExecuteTable(oTickets); return dtTickets; } catch (Exception ex) { LogManager.WriteLog(ex.Message, LogManager.enumLogLevel.Info); ExceptionManager.Publish(ex); return dtTickets; } }
/// <summary> /// Method to get the tickets claimed. /// </summary> /// <param name=""></param> /// <returns>TicketsClaimed</returns> /// Method Revision History /// Author: Anuradha /// Created: 28 April 2009 /// private static DataTable GetTicketsClaimed(TicketsClaimed oTickets) { return ExecuteTable(DBConstants.CONST_SP_GET_TICKETS_CLAIMED, oTickets); }
private List<TicketExceptions> LoadPromoTickets() { busTreasury = new TreasuryTransactions(); System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { lvPromoCashable.Items.Clear(); }); List<string> lstPositionstoDisplay = busTreasury.FillListOfFilteredPositions(RouteNumber); TicketsClaimed oTicketsClaimed = new TicketsClaimed(); oTicketsClaimed.TicketsClaimedFrom = StartDate + " " + StartTime; oTicketsClaimed.TicketsClaimedTo = EndDate + " " + EndTime; System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { prgPromo.Value += 50; }); List<TicketExceptions> lstPromoTickets = busTreasury.GetPromoCashableTickets(oTicketsClaimed, lstPositionstoDisplay); decimal ExceptionTotal = 0; TicketExceptions Total = new TicketExceptions(); Total.PrintDate = "Total"; foreach (TicketExceptions exep in lstPromoTickets) { ExceptionTotal += (decimal)exep.Value; } Total.Value = (double)Decimal.Round(ExceptionTotal, 2); lstPromoTickets.Insert(0, Total); System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { prgPromo.Value += 50; }); return lstPromoTickets; }
private List<TicketExceptions> LoadActiveTickets() { busTreasury = new TreasuryTransactions(); System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { lvActiveTickets.Items.Clear(); }); List<string> lstPositionstoDisplay = busTreasury.FillListOfFilteredPositions(RouteNumber); TicketsClaimed oTicketsClaimed = new TicketsClaimed(); oTicketsClaimed.TicketsClaimedFrom = StartDate + " " + StartTime; oTicketsClaimed.TicketsClaimedTo = EndDate + " " + EndTime; Tickets oTickets = new Tickets(); oTickets.EndDate = EndDate + " " + EndTime; oTickets.StartDate = StartDate + " " + StartTime; oTickets.IsLiability = false; oTickets.BarCode = "%"; oTickets.Type = "U"; System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { prgActiveTickets.Value += 50; }); List<TicketExceptions> lstTitoTicketsUnclaimed = busTreasury.TitoTicketsUnclaimed(oTickets, lstPositionstoDisplay); if (lstTitoTicketsUnclaimed == null) { lstTitoTicketsUnclaimed = new List<TicketExceptions>(); } System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { prgActiveTickets.Value += 50; }); List<TicketExceptions> lstTicketsUnClaimed = busTreasury.TicketsUnclaimed(oTicketsClaimed, lstPositionstoDisplay); if (lstTicketsUnClaimed != null) { foreach (TicketExceptions item in lstTicketsUnClaimed) { lstTitoTicketsUnclaimed.Add(item); } decimal ExceptionTotal = 0; TicketExceptions Total = new TicketExceptions(); Total.PrintDate = "Total"; Total.PayDate = ""; foreach (TicketExceptions exep in lstTitoTicketsUnclaimed) { ExceptionTotal += (decimal)exep.Value; } Total.Value = (double)Decimal.Round(ExceptionTotal, 2); lstTitoTicketsUnclaimed.Insert(0, Total); System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { prgActiveTickets.Value += 50; }); } return lstTitoTicketsUnclaimed; }
public List<TicketExceptions> GetTicketAnomalies(TicketsClaimed oTickets,List<string> lstPositions) { return DBBuilder.RetrieveTicketAnomalies(oTickets,lstPositions); }
private List<TicketExceptions> LoadTicketAnomalies() { busTreasury = new TreasuryTransactions(); System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { lvTicketAnomalies.Items.Clear(); }); List<string> lstPositionstoDisplay = busTreasury.FillListOfFilteredPositions(RouteNumber); TicketsClaimed oTicketsClaimed = new TicketsClaimed(); oTicketsClaimed.TicketsClaimedFrom = StartDate + " " + StartTime; oTicketsClaimed.TicketsClaimedTo = EndDate + " " + EndTime; System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { prgTicketAnomalies.Value += 75; }); List<TicketExceptions> lstTicketAnomalies = busTreasury.GetTicketAnomalies(oTicketsClaimed, lstPositionstoDisplay); System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { prgTicketAnomalies.Value += 50; }); return lstTicketAnomalies; }
public List<TicketExceptions> GetPromoCashableTickets(TicketsClaimed oTickets, List<string> lstPositions) { string strTicketInException = string.Empty; List<TicketExceptions> lstTickets = null; TicketExceptions excep = null; try { DataTable dtTickets = DBBuilder.GetPromoTickets(oTickets); if (dtTickets == null && dtTickets.Rows.Count < 0) { } else { lstTickets = new List<TicketExceptions>(); foreach (DataRow row in dtTickets.Rows) { excep = new TicketExceptions(); excep.SEGM = row["PrintDevice"].ToString(); excep.Machine = DBBuilder.GetBarPositionFromAsset(row["PrintDevice"].ToString()); excep.currValue = (float)Convert.ToDouble(row["iAmount"]) / 100; if (DBCommon.CheckPositionToDisplay(excep.Machine, lstPositions)) { excep.Position = DBBuilder.GetBarPositionFromAsset(row["PrintDevice"].ToString()); excep.TransactionType = "PROMO"; excep.Zone = row["GameTitle"].ToString(); excep.PrintDate = Convert.ToDateTime(row["dtPrinted"]).ToString("dd MMM yyyy") + " " + Convert.ToDateTime(row["dtPrinted"]).ToString("HH:mm"); excep.PayDate = Convert.ToDateTime(row["dtPrinted"]).ToString("dd MMM yyyy") + " " + Convert.ToDateTime(row["dtPrinted"]).ToString("HH:mm"); excep.Value = Convert.ToDouble(row["iAmount"]) / 100; excep.Amount = "(" + Convert.ToDouble(row["iAmount"]) / 100 + ")"; excep.Status = (row["StrVoucherStatus"] == "NA" ? "Auto Cancelled" : "Void"); excep.cExceptionsTotal += excep.currValue; } else if (DBCommon.IsMachineATicketWorkstation(row["PrintDevice"].ToString())) { excep.Position = DBBuilder.GetBarPositionFromAsset(row["PrintDevice"].ToString()); excep.TransactionType = "PROMO"; excep.Zone = row["GameTitle"].ToString(); excep.PrintDate = Convert.ToDateTime(row["dtPrinted"]).ToString("dd MMM yyyy") + " " + Convert.ToDateTime(row["dtPrinted"]).ToString("HH:mm"); excep.PayDate = Convert.ToDateTime(row["dtPrinted"]).ToString("dd MMM yyyy") + " " + Convert.ToDateTime(row["dtPrinted"]).ToString("HH:mm"); excep.Value = Convert.ToDouble(row["iAmount"]) / 100; excep.Amount = "(" + Convert.ToDouble(row["iAmount"]) / 100 + ")"; excep.Status = (row["StrVoucherStatus"] == "NA" ? "Auto Cancelled" : "Void"); excep.cExceptionsTotal += excep.currValue; } lstTickets.Add(excep); } } } catch (Exception ex) { LogManager.WriteLog(ex.Message, LogManager.enumLogLevel.Info); ExceptionManager.Publish(ex); } return lstTickets; }
public List<TicketExceptions> TicketsUnclaimed(TicketsClaimed oTickets, List<string> lstPositions) { return DBBuilder.TicketsUnClaimed(oTickets, lstPositions); }
public List<TicketExceptions> TicketsPrinted(TicketsClaimed oTickets, List<string> lstPositionstoDisplay) { return DBBuilder.TicketsPrinted(oTickets, lstPositionstoDisplay); }
private object[] GetSpParameters(TicketsClaimed oTicketsClaimed) { try { SqlParameter[] ObjParams = new SqlParameter[2]; ObjParams[0] = new SqlParameter(DBConstants.CONST_PARAM_STARTDATE, oTicketsClaimed.TicketsClaimedFrom); ObjParams[1] = new SqlParameter(DBConstants.CONST_PARAM_ENDDATE, oTicketsClaimed.TicketsClaimedTo); return ObjParams; } catch (Exception ex) { ExceptionManager.Publish(ex); return null; } }
private List<TicketExceptions> LoadLiabilities() { objCashDeskManager = CashDeskManagerBusinessObject.CreateInstance(); System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { lvLiability.Items.Clear(); }); List<string> lstPositionstoDisplay = objCashDeskManager.FillListOfFilteredPositions(RouteNumber); TicketsClaimed oTicketsClaimed = new TicketsClaimed(); oTicketsClaimed.TicketsClaimedFrom = StartDate; oTicketsClaimed.TicketsClaimedTo = EndDate; Tickets oTickets = new Tickets(); oTickets.EndDate = EndDate; oTickets.StartDate = StartDate; oTickets.IsLiability = true; oTickets.BarCode = "%"; oTickets.Type = "C"; oTickets.UserNo = UserNo; System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { prgLiability.Value += 50; }); List<TicketExceptions> lstTitoTicketsClaimed = objCashDeskManager.TitoTicketsClaimedLiability(oTickets, lstPositionstoDisplay); if (lstTitoTicketsClaimed == null) { lstTitoTicketsClaimed = new List<TicketExceptions>(); } oTickets.Type = "P"; System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { prgLiability.Value += 50; }); List<TicketExceptions> lstTitoTicketsPrinted = objCashDeskManager.TitoTicketsPrintedLiability(oTickets, lstPositionstoDisplay); //lvLiability.ItemsSource = lstTitoTicketsPrinted; if (lstTitoTicketsPrinted != null) { foreach (TicketExceptions item in lstTitoTicketsPrinted) { if (item.VoucherStatus.ToUpper().Trim() != "PP") { lstTitoTicketsClaimed.Add(item); } } } System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { prgLiability.Value += 50; }); List<TicketExceptions> lstTicketsClaimed = objCashDeskManager.TicketsClaimed(oTicketsClaimed, lstPositionstoDisplay); if (lstTicketsClaimed != null) { foreach (TicketExceptions item in lstTicketsClaimed) { if (item.VoucherStatus.ToUpper().Trim() != "PP") { lstTitoTicketsClaimed.Add(item); } } //lvLiability.ItemsSource = lstTicketsClaimed; } System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { prgLiability.Value += 50; }); List<TicketExceptions> lstTicketsPrinted = objCashDeskManager.TicketsPrinted(oTicketsClaimed, lstPositionstoDisplay); if (lstTicketsPrinted != null) { foreach (TicketExceptions item in lstTicketsPrinted) { lstTitoTicketsClaimed.Add(item); } // lvLiability.ItemsSource = lstTicketsPrinted; } decimal ExceptionTotal = 0; TicketExceptions Total = new TicketExceptions(); Total.PrintDate = "Total"; foreach (TicketExceptions exep in lstTitoTicketsClaimed) { if (exep.VoucherStatus.ToUpper().Trim() != "PP") { ExceptionTotal += (decimal)exep.Value; } } Total.Value = Convert.ToDouble(ExceptionTotal); Total.Amount = CurrencySymbol + "" + Convert.ToDecimal(ExceptionTotal).GetUniversalCurrencyFormat(); //Total.Amount = ExceptionTotal.ToString(); lstTitoTicketsClaimed.Insert(0, Total); System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { prgLiability.Value += 50; }); return lstTitoTicketsClaimed; }
public static List<TicketExceptions> TicketsUnClaimed(TicketsClaimed oTickets, List<string> lstPositions) { string strTicketInException = string.Empty; List<TicketExceptions> lstTickets = null; TicketExceptions excep = null; try { DataTable dtTickets = ExecuteTable(DBConstants.CONST_SP_GET_TICKETS_UNCLAIMED, oTickets); if (dtTickets == null && dtTickets.Rows.Count < 0) { } else { lstTickets = new List<TicketExceptions>(); foreach (DataRow row in dtTickets.Rows) { excep = new TicketExceptions(); excep.SEGM = row["bar_pos_name"].ToString(); excep.Machine = DBBuilder.GetBarPositionFromAsset(row["bar_pos_name"].ToString()); if (DBCommon.CheckPositionToDisplay(excep.Machine, lstPositions)) { excep.Position = DBBuilder.GetBarPositionFromAsset(row["PrintDevice"].ToString()); excep.Machine = row["bar_pos_name"].ToString() + " - " + row["tbr_node_serial"].ToString(); excep.TransactionType = "Ticket"; excep.Zone = row["Zone_Name"] != null ? row["Zone_Name"].ToString() : string.Empty; excep.PrintDate = Convert.ToDateTime(row["tbr_payout_time"]).ToString("dd MMM yyyy") + " " + Convert.ToDateTime(row["tbr_payout_time"]).ToString("HH:mm"); excep.PayDate = Convert.ToDateTime(row["tbr_payout_time"]).ToString("dd MMM yyyy") + " " + Convert.ToDateTime(row["tbr_payout_time"]).ToString("HH:mm"); excep.SEGM = row["machine_name"].ToString(); excep.Value = Convert.ToDouble(row["tbr_payout_value"]) / 100; excep.Amount = "(" + Convert.ToDouble(row["tbr_payout_value"]) / 100 + ")"; excep.cExceptionsTotal += (float) excep.Value; } else if (DBCommon.IsMachineATicketWorkstation(row["PrintDevice"].ToString())) { excep.Position = DBBuilder.GetBarPositionFromAsset(row["PrintDevice"].ToString()); excep.Machine = row["bar_pos_name"].ToString() + " - " + row["tbr_node_serial"].ToString(); excep.TransactionType = "Ticket"; excep.Zone = row["Zone_Name"] != null ? row["Zone_Name"].ToString() : string.Empty; excep.PrintDate = Convert.ToDateTime(row["tbr_payout_time"]).ToString("dd MMM yyyy") + " " + Convert.ToDateTime(row["tbr_payout_time"]).ToString("HH:mm"); excep.PayDate = Convert.ToDateTime(row["tbr_payout_time"]).ToString("dd MMM yyyy") + " " + Convert.ToDateTime(row["tbr_payout_time"]).ToString("HH:mm"); excep.SEGM = row["machine_name"].ToString(); excep.Value = Convert.ToDouble(row["tbr_payout_value"]) / 100; excep.Amount = "(" + Convert.ToDouble(row["tbr_payout_value"]) / 100 + ")"; excep.cExceptionsTotal += (float)excep.Value; } lstTickets.Add(excep); } } } catch (Exception ex) { LogManager.WriteLog(ex.Message, LogManager.enumLogLevel.Info); ExceptionManager.Publish(ex); } return lstTickets; }
private List<TicketExceptions> LoadCashDeskDetails() { string szErrDesc = string.Empty; double cTicketClaimedTotalCashdesk = 0, cTicketPrintedTotalCashdesk = 0, cTicketPrintedTotalEGM = 0, cTicketClaimedTotalEGM = 0, cTicketsUnclaimed = 0, cTicketInExceptions = 0, cTicketOutExceptions = 0; double currEGM = 0, currCashdesk = 0, cTicketsVoid = 0, cTicketsExpired = 0, cTicketCancelled = 0; double cRefundTotal = 0, cRefillTotal = 0, cShortpayTotal = 0, cHandPayTotal = 0, cCashDeskFloatTotal = 0, cProgressiveTotal = 0, cJackpotTotal = 0; double RefillQty = 0, RefundQty = 0, ShortpayQty = 0, HandpayQty = 0, CashDeskFloatQty = 0, ProgressiveQty = 0, JackpotQty = 0, CashDeskClaimedQty = 0, MachineClaimedQty = 0, CashDeskPrintedQty = 0, MachinePrintedQty = 0; busTreasury = new TreasuryTransactions(); RouteNumber = "0"; List<string> lstPositionstoDisplay = busTreasury.FillListOfFilteredPositions(RouteNumber); if (string.IsNullOrEmpty(StartDate) || string.IsNullOrEmpty(EndDate)) { System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { BMC.Presentation.CashDeskManager.MessageBox.showBox("Not a valid Date Range"); //prgViewAll.Value = 0; }); return null; } if (!Business.CashDeskManager.Common.isValidDateRange((StartDate + " " + StartTime), (EndDate + " " + EndTime))) { System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { BMC.Presentation.CashDeskManager.MessageBox.showBox("Not a valid Date Range"); // prgViewAll.Value = 0; }); return null; } TicketsClaimed oTicketsClaimed = new TicketsClaimed(); oTicketsClaimed.TicketsClaimedTo = EndDate + " " + EndTime; oTicketsClaimed.TicketsClaimedFrom = StartDate + " " + StartTime; szErrDesc = "pre tickets claimed"; List<TicketExceptions> lstTicketsClaimed = busTreasury.TicketsClaimed(oTicketsClaimed, lstPositionstoDisplay); if (lstTicketsClaimed != null) { foreach (TicketExceptions exep in lstTicketsClaimed) { cTicketClaimedTotalCashdesk += (float)exep.Value; } } else { lstTicketsClaimed = new List<TicketExceptions>(); } szErrDesc = "pre tickets printed"; List<TicketExceptions> lstTicketsPrinted = busTreasury.TicketsPrinted(oTicketsClaimed, lstPositionstoDisplay); if (lstTicketsPrinted != null) { foreach (TicketExceptions exep in lstTicketsPrinted) { cTicketPrintedTotalEGM += (float)exep.Value; } foreach (TicketExceptions item in lstTicketsPrinted) { lstTicketsClaimed.Add(item); } } szErrDesc = "pre TiTo claimed"; Tickets oTickets = new Tickets(); oTickets.EndDate = EndDate + " " + EndTime; oTickets.StartDate = StartDate + " " + StartTime; oTickets.IsLiability = false; oTickets.BarCode = "%"; oTickets.Type = "C"; System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { oTickets.IsClaimedInCashDesk = (bool)chkCashDeskTicketIn.IsChecked; oTickets.IsClaimedInMachine = (bool)chkTicketIn.IsChecked; prgViewAll.Value += 20; } ); List<TicketExceptions> lstTitoClaimed = busTreasury.TitoTicketsClaimed(oTickets, lstPositionstoDisplay); if (lstTitoClaimed != null) { foreach (TicketExceptions exep in lstTitoClaimed) { currEGM += exep.currEGM; currCashdesk += exep.CurrentCashDesk; CashDeskClaimedQty += exep.CashDeskClaimedQty; MachineClaimedQty += exep.MachineClaimedQty; } System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { if ((bool)chkCashDeskTicketIn.IsChecked && (bool)chkTicketIn.IsChecked) { foreach (TicketExceptions item in lstTitoClaimed) { lstTicketsClaimed.Add(item); } } prgViewAll.Value += 20; }); cTicketClaimedTotalCashdesk = cTicketClaimedTotalCashdesk + currCashdesk; cTicketClaimedTotalEGM = cTicketClaimedTotalEGM + currEGM; } oTickets.Type = "U"; List<TicketExceptions> lstTicketsUnclaimed = busTreasury.TitoTicketsUnclaimed(oTickets, lstPositionstoDisplay); if (lstTicketsUnclaimed != null) { foreach (TicketExceptions exep in lstTicketsUnclaimed) { cTicketsUnclaimed += (float)exep.Value; lstTicketsClaimed.Add(exep); } } oTickets.Type = "E"; List<TicketExceptions> lstTicketInExceptions = busTreasury.TITOTicketInExceptions(oTickets, lstPositionstoDisplay); if (lstTicketInExceptions != null) { foreach (TicketExceptions exep in lstTicketInExceptions) { cTicketInExceptions += (double)exep.currValue; lstTicketsClaimed.Add(exep); } } oTickets.Type = "E"; List<TicketExceptions> lstTicketOutExceptions = busTreasury.TitoTicketOutExceptions(oTickets, lstPositionstoDisplay); if (lstTicketOutExceptions != null) { foreach (TicketExceptions exep in lstTicketOutExceptions) { cTicketOutExceptions += (float)exep.cTicketTotal; // lstTicketsClaimed.Add(exep); } } //cTicketOutExceptions = lstTicketOutExceptions[0].cTicketTotal; oTickets.Type = "V"; List<TicketExceptions> lstTicketsVoid = busTreasury.GetTicket_VoidnExpired(oTickets, lstPositionstoDisplay); if (lstTicketsVoid != null) { foreach (TicketExceptions exep in lstTicketsVoid) { lstTicketsClaimed.Add(exep); cTicketsVoid += (float)exep.cTicketTotal; } } //cTicketsVoid = lstTicketsVoid[0].cTicketTotal; oTickets.Type = "D"; List<TicketExceptions> lstTicketsExpired = busTreasury.GetTicket_VoidnExpired(oTickets, lstPositionstoDisplay); if (lstTicketsExpired != null) { foreach (TicketExceptions exep in lstTicketsExpired) { lstTicketsClaimed.Add(exep); cTicketsExpired += (float)exep.currValue; } } oTickets.Type = "B"; List<TicketExceptions> lstTicketsCancelled = busTreasury.GetTicket_VoidnExpired(oTickets, lstPositionstoDisplay); if (lstTicketsCancelled != null) { foreach (TicketExceptions exep in lstTicketsCancelled) { lstTicketsClaimed.Add(exep); cTicketCancelled += (float)exep.cTicketTotal; } } oTickets.Type = "P"; System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { oTickets.IsPrintedInCashDesk = (bool)chkCashDeskTicketOut.IsChecked; oTickets.IsPrintedInMachine = (bool)chkTicketOut.IsChecked; prgViewAll.Value += 20; }); List<TicketExceptions> lstTitoTicketsPrinted = busTreasury.TitoTicketsPrinted(oTickets, lstPositionstoDisplay); if (lstTitoTicketsPrinted != null) { foreach (TicketExceptions exep in lstTitoTicketsPrinted) { System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { if ((bool)chkCashDeskTicketOut.IsChecked && (bool)chkTicketOut.IsChecked) { lstTicketsClaimed.Add(exep); } }); CashDeskPrintedQty += exep.CashDeskPrintedQty; MachinePrintedQty += exep.MachinePrintedQty; } if (lstTitoTicketsPrinted != null && lstTitoTicketsPrinted.Count > 0) { currEGM = lstTitoTicketsPrinted[0].currEGM; currCashdesk = lstTitoTicketsPrinted[0].CurrentCashDesk; cTicketPrintedTotalCashdesk += currCashdesk; cTicketPrintedTotalEGM += currEGM; } } szErrDesc = "pre refunds"; oTickets.Type = TREASURY_REFUND; System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { oTickets.IsLiability = (bool)chkRefunds.IsChecked; prgViewAll.Value += 20; }); List<TicketExceptions> RefundItems = busTreasury.GetTreasuryItems(oTickets, lstPositionstoDisplay); if (RefundItems != null) { foreach (TicketExceptions item in RefundItems) { lstTicketsClaimed.Add(item); cRefundTotal += item.TreasuryAmount; RefundQty += item.HandpayQty; } } szErrDesc = "pre refill"; oTickets.Type = TREASURY_REFILL; System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { oTickets.IsLiability = (bool)chkRefills.IsChecked; }); List<TicketExceptions> RefillItems = busTreasury.GetTreasuryItems(oTickets, lstPositionstoDisplay); if (RefillItems != null) { foreach (TicketExceptions item in RefillItems) { lstTicketsClaimed.Add(item); cRefillTotal += item.TreasuryAmount; RefillQty += item.HandpayQty; } } szErrDesc = "pre shortpay"; oTickets.Type = TREASURY_SHORTPAY; System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { oTickets.IsLiability = (bool)chkShortPays.IsChecked; }); List<TicketExceptions> ShortpayItems = busTreasury.GetTreasuryItems(oTickets, lstPositionstoDisplay); if (ShortpayItems != null) { foreach (TicketExceptions item in ShortpayItems) { lstTicketsClaimed.Add(item); cShortpayTotal += item.TreasuryAmount; ShortpayQty += item.HandpayQty; } } szErrDesc = "Handpays"; oTickets.Type = TREASURY_HANDPAY_CREDIT; System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { oTickets.IsLiability = (bool)chkHandpays.IsChecked; prgViewAll.Value += 20; }); List<TicketExceptions> Handpays = busTreasury.GetTreasuryItems(oTickets, lstPositionstoDisplay); if (Handpays != null) { foreach (TicketExceptions item in Handpays) { lstTicketsClaimed.Add(item); cHandPayTotal += Convert.ToDouble(item.Amount); HandpayQty += item.HandpayQty; } } szErrDesc = "pre cash desk float"; oTickets.Type = TREASURY_CASH_DESK_FLOAT; System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { oTickets.IsLiability = (bool)chkCashDeskFloat.IsChecked; }); List<TicketExceptions> CashDeskFloatItems = busTreasury.GetTreasuryItems(oTickets, lstPositionstoDisplay); if (CashDeskFloatItems != null) { foreach (TicketExceptions item in CashDeskFloatItems) { lstTicketsClaimed.Add(item); cCashDeskFloatTotal += item.TreasuryAmount; CashDeskFloatQty += item.HandpayQty; } } szErrDesc = "Progressive"; oTickets.Type = TREASURY_PROGRESSIVE; System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { oTickets.IsLiability = (bool)chkProghandpays.IsChecked; }); List<TicketExceptions> ProgItems = busTreasury.GetTreasuryItems(oTickets, lstPositionstoDisplay); if (ProgItems != null) { foreach (TicketExceptions item in ProgItems) { lstTicketsClaimed.Add(item); cProgressiveTotal += item.TreasuryAmount; ProgressiveQty += item.HandpayQty; } } szErrDesc = "Jackpot"; oTickets.Type = TREASURY_JACKPOT; System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { oTickets.IsLiability = (bool)chkjackpot.IsChecked; }); List<TicketExceptions> JackPotItems = busTreasury.GetTreasuryItems(oTickets, lstPositionstoDisplay); if (JackPotItems != null) { foreach (TicketExceptions item in JackPotItems) { lstTicketsClaimed.Add(item); cJackpotTotal += item.TreasuryAmount; JackpotQty += item.HandpayQty; } } System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { prgViewAll.Value += 20; txtCashDeskTicketInVal.Text = cTicketClaimedTotalCashdesk.ToString(MYFORMAT); txtMachineTicketInVal.Text = cTicketClaimedTotalEGM.ToString(MYFORMAT); txtMachineTicketOutVal.Text = cTicketPrintedTotalEGM.ToString(MYFORMAT); txtCashDeskTicketOutVal.Text = cTicketPrintedTotalCashdesk.ToString(MYFORMAT); txtLiabilityVal.Text = ((cTicketPrintedTotalEGM + cTicketPrintedTotalCashdesk) - (cTicketClaimedTotalEGM + cTicketClaimedTotalCashdesk)).ToString(MYFORMAT); txtExcepVal.Text = cTicketInExceptions.ToString(MYFORMAT) + "/" + cTicketOutExceptions.ToString(MYFORMAT); txtActiveVal.Text = cTicketsUnclaimed.ToString(MYFORMAT); txtVoidval.Text = cTicketsVoid.ToString(MYFORMAT) + "/" + cTicketCancelled.ToString(MYFORMAT); txtExpiredVal.Text = cTicketsExpired.ToString(MYFORMAT); txtRefundVal.Text = cRefundTotal.ToString(MYFORMAT); txtFillsVal.Text = cRefillTotal.ToString(MYFORMAT); txtCashDeskShortPaysVal.Text = cShortpayTotal.ToString(MYFORMAT); txtHandpayVal.Text = cHandPayTotal.ToString(MYFORMAT); txtCashDeskFloatVal.Text = cCashDeskFloatTotal.ToString(MYFORMAT); txtProgHandpayVal.Text = cProgressiveTotal.ToString(MYFORMAT); txtJackpotVal.Text = cJackpotTotal.ToString(MYFORMAT); }); double promoTotal = 0; List<TicketExceptions> lstPromo = busTreasury.GetPromoCashableTickets(oTicketsClaimed, lstPositionstoDisplay); if (lstPromo != null) { foreach (TicketExceptions item in lstPromo) { promoTotal += item.Value; } } System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { txtPromoCashableVal.Text = promoTotal.ToString(MYFORMAT); txtHandpayQty.Text = HandpayQty.ToString(); txtProgHandpayQty.Text = ProgressiveQty.ToString(); txtJackPotQty.Text = JackpotQty.ToString(); txtRefundQty.Text = RefundQty.ToString(); txtFillsQty.Text = RefillQty.ToString(); txtCashDeskShortPayQty.Text = ShortpayQty.ToString(); txtCashDeskFloatQty.Text = CashDeskFloatQty.ToString(); txtCashDeskTicketInQty.Text = CashDeskClaimedQty.ToString(); txtMachineTicketInQty.Text = MachineClaimedQty.ToString(); txtCashDeskTicketOutQty.Text = CashDeskPrintedQty.ToString(); txtMachineTicketOutQty.Text = MachinePrintedQty.ToString(); }); HandpayQty = 0; ProgressiveQty = 0; JackpotQty = 0; RefundQty = 0; RefillQty = 0; ShortpayQty = 0; CashDeskFloatQty = 0; CashDeskClaimedQty = 0; CashDeskPrintedQty = 0; MachineClaimedQty = 0; MachinePrintedQty = 0; return lstTicketsClaimed; }
public static List<TicketExceptions> RetrieveTicketAnomalies(TicketsClaimed oTickets, List<string> lstPositions) { string strTicketInException = string.Empty; List<TicketExceptions> lstTickets = null; TicketExceptions excep = null; try { DataTable dtTickets = ExecuteTable(DBConstants.CONST_SP_RSP_TICKET_ANOMALIES, oTickets); if (dtTickets == null && dtTickets.Rows.Count < 0) { return null; } else { lstTickets = new List<TicketExceptions>(); foreach (DataRow row in dtTickets.Rows) { excep = new TicketExceptions(); excep.SEGM = row["Machine"].ToString(); excep.Machine = DBBuilder.GetBarPositionFromAsset(row["Machine"].ToString()); if (!string.IsNullOrEmpty(excep.SEGM) && DBCommon.CheckPositionToDisplay(excep.Machine, lstPositions)) { excep.Reference = row["Reference"].ToString(); excep.Value = Convert.ToDouble(row["Amount"]); excep.PrintDate = Convert.ToDateTime(row["dtDate"].ToString()).ToString("dd MMM yyyy"); excep.Details = row["Details"].ToString(); } lstTickets.Add(excep); } } } catch (Exception ex) { ExceptionManager.Publish(ex); } return lstTickets; }
public List<TicketExceptions> TicketsPrinted(TicketsClaimed oTickets, List<string> lstPositionstoDisplay) { string strTicketInException = string.Empty; string sPosTer = string.Empty; List<TicketExceptions> lstTickets = null; TicketExceptions excep = null; try { DataTable dtTicketsClaimed = GetTicketsPrinted(oTickets); if (dtTicketsClaimed != null || dtTicketsClaimed.Rows.Count > 0) { lstTickets = new List<TicketExceptions>(); foreach (DataRow row in dtTicketsClaimed.Rows) { excep = new TicketExceptions(); excep.currValue = (float)Convert.ToDouble(row["tbr_payout_value"]) / 100; if (DBCommon.CheckPositionToDisplay(row["bar_pos_name"].ToString(), lstPositionstoDisplay)) { if (row["tbr_payout_claimed"].ToString().Equals("1")) { excep.Position = GetBarPositionFromAsset(row["TBR_Payout_Machine_Serial"].ToString()); excep.PrintDate = row["TBR_Payout_Print_Time"].ToString().ToShortDateTimeString(); if (!(row["TBR_Payout_Time"] == null)) { if (Convert.ToDateTime(row["TBR_Payout_Time"]) != null) { excep.PayDate = row["TBR_Payout_Time"].ToString().ToShortDateTimeString(); } else { excep.PayDate = string.Empty; } Convert.ToDateTime(row["TBR_Payout_Time"] != null ? row["TBR_Payout_Time"] : string.Empty).ToString("HH:mm"); } excep.ClaimedTerminal = GetBarPositionFromAsset(row["TBR_Payout_Claimed_Terminal"].ToString()); excep.Ticket = row["TBR_Payout_ExternalIndex"].ToString(); excep.Status = "Printed prior to period, Claimed within"; excep.Value = Convert.ToDouble(row["tbr_payout_value"]) / 100; // excep.Amount = excep.Value.ToString("###0.#0") ; excep.Amount = CurrencySymbol + " " + Convert.ToDecimal(excep.Value).GetUniversalCurrencyFormat(); excep.cTicketTotal += excep.currValue; } } lstTickets.Add(excep); } } } catch (Exception ex) { LogManager.WriteLog(ex.Message, LogManager.enumLogLevel.Info); ExceptionManager.Publish(ex); } return lstTickets; }
private static DataTable ExecuteTable(string ProcedureName, TicketsClaimed oTickets) { return SqlHelper.ExecuteDataset(GetExchangeConnectionString(), ProcedureName, GetSpParameters(oTickets)).Tables[0]; }
private DataTable GetTicketsPrinted(TicketsClaimed oTickets) { return ExecuteTable(DBConstants.CONST_SP_GET_TICKETS_PRINTED, oTickets); }
private static SqlDataReader ExecuteReader(string StoredProcedure, TicketsClaimed oTickets) { return SqlHelper.ExecuteReader(SQLConnection(), StoredProcedure, CommandType.StoredProcedure, GetSpParameters(oTickets)); }
private DataTable ExecuteTable(string ProcedureName, TicketsClaimed oTickets) { try { return SqlHelper.ExecuteDataset(SQLConnection(), ProcedureName, GetSpParameters(oTickets)).Tables[0]; } catch (Exception ex) { ExceptionManager.Publish(ex); return null; } }
public static List<TicketExceptions> TicketsClaimed(TicketsClaimed oTickets, List<string> lstPositionstoDisplay) { string strTicketInException = string.Empty; string sPosTer = string.Empty; List<TicketExceptions> lstTickets = null; TicketExceptions excep = null; try { DataTable dtTicketsClaimed = GetTicketsClaimed(oTickets); if (dtTicketsClaimed != null && dtTicketsClaimed.Rows.Count > 0) { lstTickets = new List<TicketExceptions>(); foreach (DataRow row in dtTicketsClaimed.Rows) { excep = new TicketExceptions(); excep.currValue = (float)Convert.ToDouble(row["tbr_payout_value"]) / 100; if (DBCommon.CheckPositionToDisplay(row["bar_pos_name"].ToString(), lstPositionstoDisplay)) { if (Convert.ToDateTime(row["tbr_payout_time"].ToString()) <= Convert.ToDateTime(oTickets.TicketsClaimedFrom)) { excep.Position = DBBuilder.GetBarPositionFromAsset(row["TBR_Payout_Machine_Serial"].ToString()); excep.PrintDate = Convert.ToDateTime(row["TBR_Payout_Print_Time"]).ToString("dd MMM yyyy") + " " + Convert.ToDateTime(row["TBR_Payout_Print_Time"]).ToString("HH:mm"); if (!(row["TBR_Payout_Time"] == null)) { excep.PayDate = Convert.ToDateTime(row["TBR_Payout_Time"] != null ? row["TBR_Payout_Time"] : string.Empty).ToString("dd MMM yyyy") + " " + Convert.ToDateTime(row["TBR_Payout_Time"] != null ? row["TBR_Payout_Time"] : string.Empty).ToString("HH:mm"); } excep.ClaimedTerminal = DBBuilder.GetBarPositionFromAsset(row["TBR_Payout_Claimed_Terminal"].ToString()); excep.Ticket = row["TBR_Payout_ExternalIndex"].ToString(); excep.Status = "Printed prior to period, Claimed within"; excep.Value = -(Convert.ToDouble(row["tbr_payout_value"]) / 100); excep.Amount = "(" + excep.Value + ")"; excep.cTicketTotal += excep.currValue; } } lstTickets.Add(excep); } } } catch (Exception ex) { LogManager.WriteLog(ex.Message, LogManager.enumLogLevel.Info); ExceptionManager.Publish(ex); } return lstTickets; }
private DataTable ExecuteTable(TicketsClaimed oTickets) { try { return SqlHelper.ExecuteDataset(GetTicketingConnectionString(), DBConstants.CONST_SP_RSP_GETPROMOTICKETFORPERIODDETAILS, GetSpParameters(oTickets)).Tables[0]; } catch (Exception ex) { ExceptionManager.Publish(ex); return null; } }
private List<TicketExceptions> LoadActiveTickets() { objCashDeskManager = CashDeskManagerBusinessObject.CreateInstance(); System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { lvActiveTickets.Items.Clear(); }); List<string> lstPositionstoDisplay = objCashDeskManager.FillListOfFilteredPositions(RouteNumber); TicketsClaimed oTicketsClaimed = new TicketsClaimed(); oTicketsClaimed.TicketsClaimedFrom = StartDate; oTicketsClaimed.TicketsClaimedTo = EndDate; Tickets oTickets = new Tickets(); oTickets.EndDate = EndDate; oTickets.StartDate = StartDate; oTickets.IsLiability = false; oTickets.BarCode = "%"; oTickets.Type = "U"; oTickets.UserNo = UserNo; System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { prgActiveTickets.Value += 50; }); List<TicketExceptions> lstTitoTicketsUnclaimed = objCashDeskManager.TitoTicketsUnclaimed(oTickets, lstPositionstoDisplay); if (lstTitoTicketsUnclaimed == null) { lstTitoTicketsUnclaimed = new List<TicketExceptions>(); } System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { prgActiveTickets.Value += 50; }); List<TicketExceptions> lstTicketsUnClaimed = objCashDeskManager.TicketsUnclaimed(oTicketsClaimed, lstPositionstoDisplay); if (lstTicketsUnClaimed != null) { foreach (TicketExceptions item in lstTicketsUnClaimed) { lstTitoTicketsUnclaimed.Add(item); } } decimal ExceptionTotal = 0; TicketExceptions Total = new TicketExceptions(); Total.PrintDate = string.Empty; Total.PrintDate = "Total"; Total.PayDate = string.Empty; foreach (TicketExceptions exep in lstTitoTicketsUnclaimed) { ExceptionTotal += (decimal)exep.Value; } Total.Value = (double)Decimal.Round(ExceptionTotal, 2); Total.Amount = CurrencySymbol + "" + Convert.ToDecimal(ExceptionTotal).GetUniversalCurrencyFormat(); lstTitoTicketsUnclaimed.Insert(0, Total); System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { prgActiveTickets.Value += 50; }); return lstTitoTicketsUnclaimed; }
private SqlDataReader ExecuteReader(string StoredProcedure, TicketsClaimed oTickets) { try { return SqlHelper.ExecuteReader(SQLConnection(), StoredProcedure, CommandType.StoredProcedure, GetSpParameters(oTickets)); } catch (Exception ex) { ExceptionManager.Publish(ex); return null; } }
private List<TicketExceptions> LoadPromoTickets() { objCashDeskManager = CashDeskManagerBusinessObject.CreateInstance(); System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { lvPromoCashable.Items.Clear(); }); List<string> lstPositionstoDisplay = objCashDeskManager.FillListOfFilteredPositions(RouteNumber); TicketsClaimed oTicketsClaimed = new TicketsClaimed(); oTicketsClaimed.TicketsClaimedFrom = StartDate; oTicketsClaimed.TicketsClaimedTo = EndDate; oTicketsClaimed.UserNo = UserNo; System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { prgPromo.Value += 50; }); List<TicketExceptions> lstPromoTickets = objCashDeskManager.GetPromoCashableTickets(oTicketsClaimed, lstPositionstoDisplay); decimal ExceptionTotal = 0; TicketExceptions Total = new TicketExceptions(); Total.PrintDate = "Total"; if (lstPromoTickets != null) { foreach (TicketExceptions exep in lstPromoTickets) { ExceptionTotal += (decimal)exep.Value; } Total.Value = (double)Decimal.Round(ExceptionTotal, 2); Total.Amount = CurrencySymbol + "" + Convert.ToDecimal(ExceptionTotal).GetUniversalCurrencyFormat(); lstPromoTickets.Insert(0, Total); System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate { prgPromo.Value += 50; }); } return lstPromoTickets; }
public List<TicketExceptions> GetPromoCashableTickets(TicketsClaimed oTickets, List<string> lstPositions) { string strTicketInException = string.Empty; List<TicketExceptions> lstTickets = null; TicketExceptions excep = null; try { DataTable dtTickets = cashdeskmanagerDataAccess.GetPromoTickets(oTickets); if (dtTickets == null && dtTickets.Rows.Count < 0) { } else { lstTickets = new List<TicketExceptions>(); foreach (DataRow row in dtTickets.Rows) { excep = new TicketExceptions(); excep.SEGM = row["PrintDevice"].ToString(); excep.Machine = cashdeskmanagerDataAccess.GetBarPositionFromAsset(row["PrintDevice"].ToString()); excep.currValue = (float)Convert.ToDouble(row["iAmount"]) / 100; if (DBCommon.CheckPositionToDisplay(excep.Machine, lstPositions)) { excep.Position = cashdeskmanagerDataAccess.GetBarPositionFromAsset(row["PrintDevice"].ToString()); excep.TransactionType = "PROMO"; excep.Zone = row["GameTitle"].ToString(); System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-GB"); DateTime dt = DateTime.Parse(row["dtPrinted"].ToString(), System.Threading.Thread.CurrentThread.CurrentCulture.DateTimeFormat); //excep.PrintDate = row["dtPrinted"].ToString().ReadDateTimeWithSeconds().ToString(); //excep.PayDate = row["dtPrinted"].ToString().ReadDateTimeWithSeconds().ToString(); excep.PrintDate = Convert.ToDateTime(row["dtPrinted"]).ToString("dd MMM yyyy HH:mm:ss").ReadDateTimeWithSeconds().ToString(); excep.PayDate = Convert.ToDateTime(row["dtPrinted"]).ToString("dd MMM yyyy HH:mm:ss").ReadDateTimeWithSeconds().ToString(); excep.Value = Convert.ToDouble(row["iAmount"]) / 100; excep.Amount = CurrencySymbol + " " + (Convert.ToDecimal(row["iAmount"]) / 100).GetUniversalCurrencyFormat(); excep.Status = (row["StrVoucherStatus"] == "NA" ? "Auto Cancelled" : "Void"); excep.cExceptionsTotal += excep.currValue; } else if (DBCommon.IsMachineATicketWorkstation(row["PrintDevice"].ToString())) { excep.Position = cashdeskmanagerDataAccess.GetBarPositionFromAsset(row["PrintDevice"].ToString()); excep.TransactionType = "PROMO"; excep.Zone = row["GameTitle"].ToString(); excep.PrintDate = Convert.ToDateTime(row["dtPrinted"]).ToString("dd MMM yyyy HH:mm:ss").ReadDateTimeWithSeconds().ToString(); excep.PayDate = Convert.ToDateTime(row["dtPrinted"]).ToString("dd MMM yyyy HH:mm:ss").ReadDateTimeWithSeconds().ToString(); excep.Value = Convert.ToDouble(row["iAmount"]) / 100; //excep.Amount = (Convert.ToDouble(row["iAmount"]) / 100).ToString("###0.#0") ; excep.Amount = CurrencySymbol + " " + (Convert.ToDecimal(row["iAmount"]) / 100).GetUniversalCurrencyFormat(); excep.Status = (row["StrVoucherStatus"] == "NA" ? "Auto Cancelled" : "Void"); excep.cExceptionsTotal += excep.currValue; } lstTickets.Add(excep); } } } catch (Exception ex) { LogManager.WriteLog(ex.Message, LogManager.enumLogLevel.Info); ExceptionManager.Publish(ex); } return lstTickets; }