// public BatchHistoryBreakdown(int CollectionID, int InstallationNo, string ExchangeConst, List<Transport.AllEvents> events, BMC.Transport.CollectionView collection) { InitializeComponent(); _CollectionID = CollectionID; _InstallationNo = InstallationNo; _collectionview = collection; _lstEvents = events; ExchangeConnection = ExchangeConst; txtBatchDate.Content = _collectionview.Collection_Date_Performed.GetUniversalDateTimeFormat(); txtGame.Content = ((_collectionview.MachineName).Length > 15) ? (_collectionview.MachineName).Substring(0, 15) : _collectionview.MachineName; txtGame.ToolTip = _collectionview.MachineName; txtGamingDay.Content = _collectionview.CollectionDate.GetUniversalDateTimeFormat(); txtPos.Content = _collectionview.PosName; txtUser.Content = _collectionview.UserName.Split(',').First(); txtUser.ToolTip = _collectionview.UserName; LogManager.WriteLog("Declared User Name : " + _collectionview.DeclaredUserName, LogManager.enumLogLevel.Info); txtDeclareBy.Content = _collectionview.DeclaredUserName; txtDeclareBy.ToolTip = _collectionview.DeclaredUserName; txtZone.Content = _collectionview.ZoneName; txtAsset.Content = _collectionview.Stock_No; ChangeHeader(); if (!Settings.IsAFTEnabledForSite ? true : false) { RemoveHeader("EFTIn"); RemoveHeader("EFTOut"); RemoveHeader("EFT"); } MessageBox.childOwner = this; dgEvents.ItemsSource = _lstEvents; BackgroundWorker _bgLoadPositionScreen = new BackgroundWorker(); _bgLoadPositionScreen.DoWork += OnPositionScreenInitialize; _bgLoadPositionScreen.RunWorkerCompleted += OnPositionScreenComplete; _bgLoadPositionScreen.RunWorkerAsync(); _bgLoadPositionScreen.WorkerSupportsCancellation = true; }
// public List<TreasuryUser> GetTreasuryTable(CollectionView _collectionRecords) { List<TreasuryUser> TreasuryUsers = null; try { TreasuryUsers = _batch.GetTreasuryDetails(_collectionRecords.Collection_No).ToList(); if (Convert.ToDecimal(_collectionRecords.DeclaredTicketPrintedValue) > 0) { TreasuryUser user = new TreasuryUser(); user.Treasury_Type = "Vouchers Out"; user.Treasury_Amount = Convert.ToDouble(_collectionRecords.DeclaredTicketPrintedValue); user.Treasury_Date = _collectionRecords.Collection_Date_Performed; user.User_ID = "n/a"; user.User_Name = "n/a"; TreasuryUsers.Add(user); } } catch (Exception ex) { LogError(ex); } return TreasuryUsers; }
// public BatchHistoryBreakdown(int CollectionID, int InstallationNo, string ExchangeConst, List <Transport.AllEvents> events, BMC.Transport.CollectionView collection) { InitializeComponent(); _CollectionID = CollectionID; _InstallationNo = InstallationNo; _collectionview = collection; _lstEvents = events; ExchangeConnection = ExchangeConst; txtBatchDate.Content = _collectionview.Collection_Date_Performed.GetUniversalDateTimeFormat(); txtGame.Content = ((_collectionview.MachineName).Length > 15) ? (_collectionview.MachineName).Substring(0, 15) : _collectionview.MachineName; txtGame.ToolTip = _collectionview.MachineName; txtGamingDay.Content = _collectionview.CollectionDate.GetUniversalDateTimeFormat(); txtPos.Content = _collectionview.PosName; txtUser.Content = _collectionview.UserName.Split(',').First(); txtUser.ToolTip = _collectionview.UserName; LogManager.WriteLog("Declared User Name : " + _collectionview.DeclaredUserName, LogManager.enumLogLevel.Info); txtDeclareBy.Content = _collectionview.DeclaredUserName; txtDeclareBy.ToolTip = _collectionview.DeclaredUserName; txtZone.Content = _collectionview.ZoneName; txtAsset.Content = _collectionview.Stock_No; ChangeHeader(); if (!Settings.IsAFTEnabledForSite ? true : false) { RemoveHeader("EFTIn"); RemoveHeader("EFTOut"); RemoveHeader("EFT"); } MessageBox.childOwner = this; dgEvents.ItemsSource = _lstEvents; BackgroundWorker _bgLoadPositionScreen = new BackgroundWorker(); _bgLoadPositionScreen.DoWork += OnPositionScreenInitialize; _bgLoadPositionScreen.RunWorkerCompleted += OnPositionScreenComplete; _bgLoadPositionScreen.RunWorkerAsync(); _bgLoadPositionScreen.WorkerSupportsCancellation = true; }
public List<Transport.TreasuryUser> GetTreasuryTable(CollectionView _collectionview) { return _batchHistoryBreakdown.GetTreasuryTable(_collectionview); }
public List<Transport.PartCollectionUser> GetCollectionUser(CollectionView _collectionRecords) { return _batchHistoryBreakdown.GetCollectionUser(_collectionRecords); }
public List<Transport.CollectionListView> GetCollectionDetailsforListView(CollectionView _collectionRecords) { return _batchHistoryBreakdown.GetCollectionDetailsforListView(_collectionRecords); }
// private BatchHistoryListView GetIndividualCollectionDetails(CollectionView item) { BatchHistoryListView view = new BatchHistoryListView(); try { double? casinoWin = 0; view.CollectionKey = item.Collection_No + "#" + item.Installation_No; view.Zone = item.ZoneName; view.Pos = item.PosName; view.Asset = item.Stock_No; view.Game = item.MachineName; if ((bool)item.Declaration == false) { view.Zone = "UNDECLARED"; } else { view.WinLoss = Convert.ToDouble(item.Declared_Total_Notes) + Convert.ToDouble(item.DecTicketBalance) - Convert.ToDouble(item.DecHandpay) + Convert.ToDouble(item.Net_Coin) + (_isAFTIncludedInCalculation ? (Convert.ToDouble(item.EftIn) / 100 //((Convert.ToDouble(item.Promo_Cashable_EFT_IN.Value) + Convert.ToDouble(item.NonCashable_EFT_IN.Value) + Convert.ToDouble(item.Cashable_EFT_IN.Value)) - Convert.ToDouble(item.EftOut) / 100) : 0) - (Settings.AddShortpayInVoucherOut? 0 : Convert.ToDouble(item.Shortpay.Value)); view.WinLossMeter = Convert.ToDouble(item.RDC_Notes) + Convert.ToDouble((item.DecTicketBalance - item.TicketVar)) - Convert.ToDouble(item.RDCHandpay) + Convert.ToDouble(item.RDC_Coin) + (_isAFTIncludedInCalculation ? ((((Convert.ToDouble(item.Promo_Cashable_EFT_IN) + Convert.ToDouble(item.NonCashable_EFT_IN) + Convert.ToDouble(item.Cashable_EFT_IN)))) - (Convert.ToDouble(item.Promo_Cashable_EFT_OUT.Value) + Convert.ToDouble(item.NonCashable_EFT_OUT.Value) + Convert.ToDouble(item.Cashable_EFT_OUT.Value))) : 0); view.WinLossVar = view.WinLoss - view.WinLossMeter; view.GrossCoin = item.Declared_Total_Coinage.Value; view.FloatRec = item.Defloat.Value; view.Refills = item.Refills.Value; view.Refunds = item.Refunds.Value; view.CoinNet = item.Net_Coin.Value; view.CoinMeter = item.RDC_Coin.Value; view.CoinVar = item.Coin_Var.Value; view.Bills = item.Declared_Total_Notes.Value; view.BillsMeter = item.RDC_Notes.Value; view.BillsVar = item.Note_Var.Value; view.Tickets = item.DecTicketBalance.Value; view.Shortpay = item.Shortpay.Value; view.VoidTicket = item.Void.Value; view.TicketsMeter = (item.DecTicketBalance - item.TicketVar).Value; view.TicketsVar = item.TicketVar.Value; view.Handpay = item.DecHandpay; view.HandpayNonTruncated = item.DecHandpay.Value.ToString("r"); view.HandpayMeter = item.RDCHandpay.Value; view.HandpayVar = item.HandpayVar.Value; view.Progressive = item.Progressive_Value_Declared.Value; view.ProgressiveMeter = item.Progressive_Value_Meter.Value; view.ProgressiveVar = item.Progressive_Value_Variance.Value; view.Handle = (item.VTP / 10).Value; casinoWin = Convert.ToDouble(item.RDC_Notes) + Convert.ToDouble((item.DecTicketBalance - item.TicketVar)) - Convert.ToDouble(item.RDCHandpay) + Convert.ToDouble(item.RDC_Coin) + (_isAFTIncludedInCalculation ? ((((Convert.ToDouble(item.Promo_Cashable_EFT_IN) + Convert.ToDouble(item.NonCashable_EFT_IN) + Convert.ToDouble(item.Cashable_EFT_IN)))) - (Convert.ToDouble(item.Promo_Cashable_EFT_OUT.Value) + Convert.ToDouble(item.NonCashable_EFT_OUT.Value) + Convert.ToDouble(item.Cashable_EFT_OUT.Value))) : 0); if (item.VTP != 0) { view.PercentPayout = ((view.Handle -view.WinLossMeter) / view.Handle) * 100.00; // view.PercentHold = (100 - ((((Convert.ToDouble(item.VTP) / 10) - casinoWin) / (Convert.ToDouble(item.VTP) / 10)) * 100)).Value; } else { view.PercentPayout = 0; view.PercentHold = 100; } view.Faults = item.CollectionNoFaultEvents.Value; view.Door = item.CollectionNoDoorEvents.Value; view.Power = item.CollectionNoPowerEvents.Value; } } catch (Exception ex) { LogError(ex); } return view; }
// public List<PartCollectionUser> GetCollectionUser(CollectionView _collectionView) { List<PartCollectionUser> CollectionList = new List<PartCollectionUser>(); PartCollectionUser Collection = new PartCollectionUser(); Collection = new PartCollectionUser { Part_Collection_Date_Performed = _collectionView.Collection_Performed_Date, Part_Collection_DateOnly = _collectionView.Collection_Date.GetUniversalDateFormat(), Part_Collection_Time = _collectionView.Collection_Date.GetUniversalTimeFormat(), User_Name = _collectionView.UserName, Part_Collection_CashCollected = (float)(_collectionView.CashCollected) }; Collection.Description = _collectionView.DropType; CollectionList.Add(Collection); return CollectionList; }
// private decimal CalculateCashDiff(CollectionView cRecord) { decimal cashDiff = Settings.Region != "US" ? 0 : (Convert.ToDecimal(cRecord.CASH_IN_100P) - Convert.ToDecimal(cRecord.CASH_OUT_100P)); cashDiff += (Settings.Region == "UK" ? 0 : (Convert.ToDecimal(cRecord.CASH_IN_200P) - Convert.ToDecimal(cRecord.CASH_OUT_200P)) * 2); cashDiff += (Convert.ToDecimal(cRecord.CASH_IN_500P) - Convert.ToDecimal(cRecord.CASH_OUT_500P)) * 5; cashDiff += (Convert.ToDecimal(cRecord.CASH_IN_1000P) - Convert.ToDecimal(cRecord.CASH_OUT_1000P)) * 10; cashDiff += (Convert.ToDecimal(cRecord.CASH_IN_2000P) - Convert.ToDecimal(cRecord.CASH_OUT_2000P)) * 20; cashDiff += (Convert.ToDecimal(cRecord.CASH_IN_5000P) - Convert.ToDecimal(cRecord.CASH_OUT_5000P)) * 50; cashDiff += (Convert.ToDecimal(cRecord.CASH_IN_10000P) - Convert.ToDecimal(cRecord.CASH_OUT_10000P)) * 100; cashDiff += (Convert.ToDecimal(cRecord.CASH_IN_20000P) - Convert.ToDecimal(cRecord.CASH_OUT_20000P)) * 200; cashDiff += (Convert.ToDecimal(cRecord.CASH_IN_50000P) - Convert.ToDecimal(cRecord.CASH_OUT_50000P)) * 500; cashDiff += (Convert.ToDecimal(cRecord.CASH_IN_100000P) - Convert.ToDecimal(cRecord.CASH_OUT_100000P)) * 1000; cashDiff += (Convert.ToDecimal(cRecord.COLLECTION_RDC_TICKETS_INSERTED_VALUE) / 100) + (Convert.ToDecimal(cRecord.RDC_TICKETS_INSERTED_NONCASHABLE_VALUE)); cashDiff += (_isAFTIncludedInCalculation ? ((((Convert.ToDecimal(cRecord.Promo_Cashable_EFT_IN) + Convert.ToDecimal(cRecord.NonCashable_EFT_IN) + Convert.ToDecimal(cRecord.Cashable_EFT_IN))))) : 0); return cashDiff; }
// public List<CollectionListView> GetCollectionDetailsforListView(CollectionView _collectionRecords) { var collectionDetails = new List<CollectionListView>(); var collGrossView = new CollectionListView(); var collNetView = new CollectionListView(); var colShortpayview = new CollectionListView(); decimal treasurySum = Convert.ToDecimal(_collectionRecords.DecHandpay); decimal shortPayTreasurySum = Convert.ToDecimal(_collectionRecords.Shortpay); decimal OfflineshortPayTreasurySum = Convert.ToDecimal(_collectionRecords.OffLineShortpay); decimal voidTreasurySum = Convert.ToDecimal(_collectionRecords.Void); decimal CoinsOut = Convert.ToDecimal(_collectionRecords.RDC_Total_Coinage_Out); decimal totalCollection = Convert.ToDecimal(_collectionRecords.CashIn); int POP = Convert.ToInt32(_collectionRecords.Installation_Price_of_Play); collGrossView.Name = "Gross"; collNetView.Name = "Net"; collNetView.Total = collGrossView.Total = Convert.ToDecimal(_collectionRecords.CashCollected) + (_isAFTIncludedInCalculation ? (Convert.ToDecimal(_collectionRecords.EftIn) / 100) : 0); collNetView.V1000 = collGrossView.V1000 = Convert.ToDecimal(_collectionRecords.Cash_Collected_100000p); collNetView.V500 = collGrossView.V500 = Convert.ToDecimal(_collectionRecords.Cash_Collected_50000p); collNetView.V200 = collGrossView.V200 = Convert.ToDecimal(_collectionRecords.Cash_Collected_20000p); collNetView.V100 = collGrossView.V100 = Convert.ToDecimal(_collectionRecords.Cash_Collected_10000p); collNetView.V50 = collGrossView.V50 = Convert.ToDecimal(_collectionRecords.Cash_Collected_5000p); collNetView.V20 = collGrossView.V20 = Convert.ToDecimal(_collectionRecords.Cash_Collected_2000p); collNetView.V10 = collGrossView.V10 = Convert.ToDecimal(_collectionRecords.Cash_Collected_1000p); collNetView.V5 = collGrossView.V5 = Convert.ToDecimal(_collectionRecords.Cash_Collected_500p); collNetView.V2 = collGrossView.V2 = Convert.ToDecimal(_collectionRecords.Cash_Collected_200p); collNetView.V1 = collGrossView.V1 = Convert.ToDecimal(_collectionRecords.Cash_Collected_100p); collNetView.V50p = collGrossView.V50p = Convert.ToDecimal(_collectionRecords.Cash_Collected_50p); collNetView.V20p = collGrossView.V20p = Convert.ToDecimal(_collectionRecords.Cash_Collected_20p); collNetView.V10P = collGrossView.V10P = Convert.ToDecimal(_collectionRecords.Cash_Collected_10p); decimal grossTotalCoins = Convert.ToDecimal(_collectionRecords.Declared_Total_TrueCoin_In); collNetView.TotalCoins = collGrossView.TotalCoins = Convert.ToDecimal(grossTotalCoins) - CoinsOut; collNetView.CoinsIn = collGrossView.CoinsIn = Convert.ToDecimal(grossTotalCoins); collNetView.CoinsOut = collGrossView.CoinsOut = CoinsOut; collNetView.TicketsIn = collGrossView.TicketsIn = Convert.ToDecimal(_collectionRecords.DeclaredTicketValue); // Non cashable has been removed as it is added in the declared value (Convert.ToDecimal(_collectionRecords.RDC_TICKETS_INSERTED_NONCASHABLE_VALUE)/100); if (Settings.Client == "SGVI" && Settings.TicketDeclaration.ToUpper() == "AUTO") collNetView.TicketsOut = collGrossView.TicketsOut = Convert.ToDecimal(_collectionRecords.DeclaredTicketPrintedValue); else { if (Settings.AddShortpayInVoucherOut) collNetView.TicketsOut = collGrossView.TicketsOut = Convert.ToDecimal(_collectionRecords.DeclaredTicketPrintedValue) + (Convert.ToDecimal(shortPayTreasurySum) + Convert.ToDecimal(OfflineshortPayTreasurySum)) - Convert.ToDecimal(voidTreasurySum); else { collNetView.TicketsOut = collGrossView.TicketsOut = Convert.ToDecimal(_collectionRecords.DeclaredTicketPrintedValue) + +Convert.ToDecimal(OfflineshortPayTreasurySum) - Convert.ToDecimal(voidTreasurySum); } } collNetView.PromoCashableValue = collGrossView.PromoCashableValue = Convert.ToDecimal(_collectionRecords.PromoCashableValue); collNetView.PromoNonCashableValue = collGrossView.PromoNonCashableValue = Convert.ToDecimal(_collectionRecords.PromoNonCashableValue); // Non cashable voucher out is removed as it is added in the declared ticket printed value(Convert.ToDecimal(_collectionRecords.RDC_TICKETS_PRINTED_NONCASHABLE_VALUE)/100); collNetView.EFTIn = collGrossView.EFTIn = (Convert.ToDecimal(_collectionRecords.EftIn) / 100); // (((Convert.ToDecimal(_collectionRecords.Promo_Cashable_EFT_IN) + Convert.ToDecimal(_collectionRecords.NonCashable_EFT_IN) + Convert.ToDecimal(_collectionRecords.Cashable_EFT_IN))) / 100); collNetView.EFTOut = collGrossView.EFTOut = (Convert.ToDecimal(_collectionRecords.EftOut) / 100); collNetView.EFT = collGrossView.EFT = (Convert.ToDecimal(_collectionRecords.EftIn) / 100) - (Convert.ToDecimal(_collectionRecords.EftOut) / 100); collNetView.Tickets = collGrossView.Tickets = Convert.ToDecimal(collGrossView.TicketsIn) - Convert.ToDecimal(collGrossView.TicketsOut); collNetView.Handpay = collGrossView.Handpay = Convert.ToDecimal(_collectionRecords.DecHandpay.Value.ToString("r"));// Value Calculated in View/Function collNetView.Progressive = collGrossView.Progressive = Convert.ToDecimal(_collectionRecords.Progressive_Value_Declared); collNetView.IsMatch = collGrossView.IsMatch = totalCollection == Convert.ToDecimal(_collectionRecords.CashCollected) ? true : false; collectionDetails.Add(collGrossView); //ShortPay colShortpayview.Name = "Shortpay"; colShortpayview.TicketsOut = Convert.ToDecimal(_collectionRecords.Shortpay); colShortpayview.Tickets = ((_collectionRecords.Shortpay > 0) ? Convert.ToDecimal((_collectionRecords.Shortpay * -1)) : Convert.ToDecimal(_collectionRecords.Shortpay)); collectionDetails.Add(colShortpayview); //copy the gross object to net collectionDetails.Add(collNetView); CollectionListView collMeterView = new CollectionListView(); collMeterView.Name = "Meters"; var collVarView = new CollectionListView { Name = "Variance" }; decimal totaCashDiff = CalculateCashDiff(_collectionRecords); decimal totalCoins; collVarView.Total = (Convert.ToDecimal(_collectionRecords.CashCollected) + (_isAFTIncludedInCalculation ? (Convert.ToDecimal(_collectionRecords.EftIn) / 100) : 0)) - (CalculateCashDiff(_collectionRecords) + Convert.ToDecimal(_collectionRecords.RDC_Total_Coinage_In)); if (_collectionRecords.Collection_EDC_Status == 0) { collMeterView.Total = CalculateCashDiff(_collectionRecords) + Convert.ToDecimal(_collectionRecords.RDC_Total_Coinage_In); collMeterView.V1000 = (Convert.ToDecimal(_collectionRecords.CASH_IN_100000P) - Convert.ToDecimal(_collectionRecords.CASH_OUT_100000P)) * 1000; collMeterView.V500 = (Convert.ToDecimal(_collectionRecords.CASH_IN_50000P) - Convert.ToDecimal(_collectionRecords.CASH_OUT_50000P)) * 500; collMeterView.V200 = (Convert.ToDecimal(_collectionRecords.CASH_IN_20000P) - Convert.ToDecimal(_collectionRecords.CASH_OUT_20000P)) * 200; collMeterView.V100 = (Convert.ToDecimal(_collectionRecords.CASH_IN_10000P) - Convert.ToDecimal(_collectionRecords.CASH_OUT_10000P)) * 100; collMeterView.V50 = (Convert.ToDecimal(_collectionRecords.CASH_IN_5000P) - Convert.ToDecimal(_collectionRecords.CASH_OUT_5000P)) * 50; collMeterView.V20 = (Convert.ToDecimal(_collectionRecords.CASH_IN_2000P) - Convert.ToDecimal(_collectionRecords.CASH_OUT_2000P)) * 20; collMeterView.V10 = (Convert.ToDecimal(_collectionRecords.CASH_IN_1000P) - Convert.ToDecimal(_collectionRecords.CASH_OUT_1000P)) * 10; collMeterView.V5 = (Convert.ToDecimal(_collectionRecords.CASH_IN_500P) - Convert.ToDecimal(_collectionRecords.CASH_OUT_500P)) * 5; collMeterView.V2 = (Convert.ToDecimal(_collectionRecords.CASH_IN_200P) - Convert.ToDecimal(_collectionRecords.CASH_OUT_200P)) * 2; collMeterView.V1 = Convert.ToDecimal(_collectionRecords.CASH_IN_100P) - Convert.ToDecimal(_collectionRecords.CASH_OUT_100P); collMeterView.V50p = (Convert.ToDecimal(_collectionRecords.CASH_IN_50P) - Convert.ToDecimal(_collectionRecords.CASH_OUT_50P)) / 2; collMeterView.V20p = (Convert.ToDecimal(_collectionRecords.CASH_IN_20P) - Convert.ToDecimal(_collectionRecords.CASH_OUT_20P)) / 5; collMeterView.V10P = (Convert.ToDecimal(_collectionRecords.CASH_IN_10P) - Convert.ToDecimal(_collectionRecords.CASH_OUT_10P)) / 10; totalCoins = (Convert.ToDecimal(_collectionRecords.RDC_Total_Coinage_In) - Convert.ToDecimal(_collectionRecords.RDC_Total_Coinage_Out)); collMeterView.TotalCoins = Convert.ToDecimal(totalCoins); collMeterView.CoinsIn = Convert.ToDecimal(totalCoins) + CoinsOut; collMeterView.CoinsOut = CoinsOut; collMeterView.TotalCoins = Convert.ToDecimal(totalCoins); collMeterView.TicketsIn = (Convert.ToDecimal(_collectionRecords.COLLECTION_RDC_TICKETS_INSERTED_VALUE) / 100) + (Convert.ToDecimal(_collectionRecords.RDC_TICKETS_INSERTED_NONCASHABLE_VALUE)); collMeterView.TicketsOut = (Convert.ToDecimal(_collectionRecords.COLLECTION_RDC_TICKETS_PRINTED_VALUE) / 100) + (Convert.ToDecimal(_collectionRecords.RDC_TICKETS_PRINTED_NONCASHABLE_VALUE)); collMeterView.Tickets = collMeterView.TicketsIn - collMeterView.TicketsOut; collMeterView.EFTIn = (Convert.ToDecimal(_collectionRecords.Promo_Cashable_EFT_IN) + Convert.ToDecimal(_collectionRecords.NonCashable_EFT_IN) + Convert.ToDecimal(_collectionRecords.Cashable_EFT_IN)); collMeterView.EFTOut = (Convert.ToDecimal(_collectionRecords.Promo_Cashable_EFT_OUT) + Convert.ToDecimal(_collectionRecords.NonCashable_EFT_OUT) + Convert.ToDecimal(_collectionRecords.Cashable_EFT_OUT)); collMeterView.EFT = collMeterView.EFTIn - collMeterView.EFTOut; collMeterView.Handpay = ((Convert.ToDecimal(_collectionRecords.COLLECTION_RDC_HANDPAY) * POP) / 100) + (Convert.ToDecimal(_collectionRecords.COLLECTION_RDC_JACKPOT)); collMeterView.Progressive = ((Convert.ToDecimal(_collectionRecords.progressive_win_Handpay_value)) * POP / 100); collectionDetails.Add(collMeterView); //Difference between net and meter collVarView.V1000 = collNetView.V1000 - collMeterView.V1000; collVarView.V500 = collNetView.V500 - collMeterView.V500; collVarView.V200 = collNetView.V200 - collMeterView.V200; collVarView.V100 = collNetView.V100 - collMeterView.V100; collVarView.V50 = collNetView.V50 - collMeterView.V50; collVarView.V20 = collNetView.V20 - collMeterView.V20; collVarView.V10 = collNetView.V10 - collMeterView.V10; collVarView.V5 = collNetView.V5 - collMeterView.V5; collVarView.V2 = collNetView.V2 - collMeterView.V2; collVarView.V1 = collNetView.V1 - collMeterView.V1; collVarView.V50p = collNetView.V50p - collMeterView.V50p; collVarView.V20p = collNetView.V20p - collMeterView.V20p; collVarView.V10P = collNetView.V10P - collMeterView.V10P; collVarView.TotalCoins = collNetView.TotalCoins - collMeterView.TotalCoins; collVarView.CoinsIn = collNetView.CoinsIn - collMeterView.CoinsIn; collVarView.CoinsOut = 0; collVarView.TicketsIn = collNetView.TicketsIn - collMeterView.TicketsIn; collVarView.TicketsOut = collNetView.TicketsOut - collMeterView.TicketsOut; collVarView.Tickets = collVarView.TicketsIn - collVarView.TicketsOut; collVarView.EFTIn = collNetView.EFTIn - collMeterView.EFTIn; collVarView.EFTOut = collNetView.EFTOut - collMeterView.EFTOut; collVarView.EFT = collVarView.EFTIn - collVarView.EFTOut; collVarView.Handpay = collNetView.Handpay - collMeterView.Handpay; collVarView.Progressive = collNetView.Progressive - collMeterView.Progressive; collVarView.PromoCashableValue = collNetView.PromoCashableValue - collMeterView.PromoCashableValue; collVarView.PromoNonCashableValue = collNetView.PromoNonCashableValue - collMeterView.PromoNonCashableValue; collectionDetails.Add(collVarView); } else { collMeterView.Total = 0; collMeterView.V1000 = 0; collMeterView.V500 = 0; collMeterView.V200 = 0; collMeterView.V100 = 0; collMeterView.V50 = 0; collMeterView.V20 = 0; collMeterView.V10 = 0; collMeterView.V5 = 0; collMeterView.V2 = 0; collMeterView.V1 = 0; collMeterView.V50p = 0; collMeterView.V20p = 0; collMeterView.V10P = 0; collMeterView.TotalCoins = 0; collMeterView.CoinsIn = 0; collMeterView.CoinsOut = 0; collMeterView.TicketsIn = 0; collMeterView.TicketsOut = 0; collMeterView.EFTIn = 0; collMeterView.EFTOut = 0; collMeterView.EFT = 0; collMeterView.Tickets = 0; collMeterView.Handpay = 0; collMeterView.Progressive = 0; collectionDetails.Add(collMeterView); //Reusing Gross View as Variance since Meters values are zero collGrossView.Name = "Variance"; collectionDetails.Add(collGrossView); } return collectionDetails; }
// private void CalculateTotalSum(CollectionView item) { try { double? casinoWin = 0; double? WinLossMeter = 0; _details.BatchNo = _weekID > 0 ? item.WeekNo.ToString() : item.Collection_Batch_No.ToString(); _details.BatchName = item.Collection_Batch_Name; _details.BatchDate = _weekID > 0 ? (DateTime)item.WeekStartDate : (DateTime)item.BatchDate; _details.CollectionDate = _weekID > 0 ? (DateTime)item.WeekEndDate : (DateTime)item.Collection_Performed_Date; _details.UserName = item.UserName; _details.GrossCoin += Convert.ToDecimal(item.Declared_Total_Coinage); _details.FloatRec += Convert.ToDecimal(item.Defloat); _details.RefillsSum += Convert.ToDecimal(item.Refills); _details.RefundsSum += Convert.ToDecimal(item.Refunds); _details.ProgressiveSum += Convert.ToDecimal(item.Progressive_Value_Declared); _details.Shortpay += Convert.ToDecimal(item.Shortpay); _details.NetCoinSum += Convert.ToDecimal(item.Net_Coin); _details.NotesSum += Convert.ToDecimal(item.Declared_Total_Notes); _details.HandpaySum += Convert.ToDecimal(item.DecHandpay.Value.ToString("r")); _details.TicketBalanceSum += Convert.ToDecimal(item.DecTicketBalance); _details.CashTakeSum += Convert.ToDecimal(item.Declared_Total_Notes) + Convert.ToDecimal(item.DecTicketBalance) - Convert.ToDecimal(item.DecHandpay.Value.ToString("r")) + Convert.ToDecimal(item.Net_Coin) + (_isAFTIncludedInCalculation ? (Convert.ToDecimal(item.EftIn) / 100 - Convert.ToDecimal(item.EftOut) / 100) : 0) - (Settings.AddShortpayInVoucherOut? 0 : Convert.ToDecimal(item.Shortpay)); _details.CoinVarSum += Convert.ToDecimal(item.Coin_Var); _details.ProgressiveVarSum += Convert.ToDecimal(item.Progressive_Value_Variance); _details.NotesVarSum += Convert.ToDecimal(item.Note_Var); _details.TicketsVarSum += Convert.ToDecimal(item.TicketVar); _details.HandpayVarSum += Convert.ToDecimal(item.HandpayVar); casinoWin += Convert.ToDouble(Convert.ToDecimal(item.RDC_Notes) + Convert.ToDecimal((item.DecTicketBalance - item.TicketVar)) - Convert.ToDecimal(item.RDCHandpay) + Convert.ToDecimal(item.RDC_Coin) + (_isAFTIncludedInCalculation ? ((((Convert.ToDecimal(item.Promo_Cashable_EFT_IN) + Convert.ToDecimal(item.NonCashable_EFT_IN) + Convert.ToDecimal(item.Cashable_EFT_IN)))) - (Convert.ToDecimal(item.Promo_Cashable_EFT_OUT.Value) + Convert.ToDecimal(item.NonCashable_EFT_OUT.Value) + Convert.ToDecimal(item.Cashable_EFT_OUT.Value))) : 0)); WinLossMeter = Convert.ToDouble(item.RDC_Notes) + Convert.ToDouble((item.DecTicketBalance - item.TicketVar)) - Convert.ToDouble(item.RDCHandpay) + Convert.ToDouble(item.RDC_Coin) + (_isAFTIncludedInCalculation ? ((((Convert.ToDouble(item.Promo_Cashable_EFT_IN) + Convert.ToDouble(item.NonCashable_EFT_IN) + Convert.ToDouble(item.Cashable_EFT_IN)))) - (Convert.ToDouble(item.Promo_Cashable_EFT_OUT.Value) + Convert.ToDouble(item.NonCashable_EFT_OUT.Value) + Convert.ToDouble(item.Cashable_EFT_OUT.Value))) : 0); if (item.VTP != null) { _details.VTPSum += Convert.ToDecimal((Convert.ToDecimal(item.VTP) / 10)); _details.WinLossSum += Convert.ToDecimal(WinLossMeter); } if (item.VTP != 0) { _details.PayoutSum += ((_details.VTPSum - Convert.ToDecimal(WinLossMeter)) / _details.VTPSum) * 100; //_details.PayoutSum += ((((Convert.ToDecimal(item.VTP) / 10) - Convert.ToDecimal(casinoWin)) / (Convert.ToDecimal(item.VTP) / 10)) * 100); _details.HoldSum += (100 - ((((Convert.ToDecimal(item.VTP) / 10) - Convert.ToDecimal(casinoWin)) / (Convert.ToDecimal(item.VTP) / 10)) * 100)); } _details.NoofCollections += 1; } catch (Exception ex) { LogError(ex); } }