public List<TicketExceptions> TitoTicketsPrinted(Tickets oTickets, List<string> lstPositionstoDisplay)
{
string strTicketInException = string.Empty;
string sPosTer = string.Empty;
List<TicketExceptions> lstTickets = null;
TicketExceptions excep = null;
double CurrentCashDesk = 0, currEGM = 0;
try
{
DataTable dtTickets = GetTickets(oTickets);
if (dtTickets == null || dtTickets.Rows.Count < 0)
{
}
else
{
lstTickets = new List<TicketExceptions>();
foreach (DataRow row in dtTickets.Rows)
{
excep = new TicketExceptions();
excep.bExceptionRecordFound = false;
excep.SEGM = row["PrintDevice"].ToString();
excep.VoucherStatus = row["strVoucherStatus"].ToString();
excep.TicketAddedtoList = false;
excep.currValue = (float)Convert.ToDouble(row["iAmount"]) / 100;
if (!string.IsNullOrEmpty(excep.SEGM))
{
if (row["strDeviceType"].ToString().Equals("EXTITO") || string.IsNullOrEmpty(row["strDeviceType"].ToString()))
{
if (DBCommon.IsMachineATicketWorkstation(excep.SEGM))
{
sPosTer = excep.SEGM;
excep.Position = excep.SEGM;
excep.Machine = "";
CurrentCashDesk += excep.currValue;
excep.CashDeskPrintedQty += 1;
if (oTickets.IsPrintedInCashDesk)
{
excep.TicketAddedtoList = true;
}
}
else
{
sPosTer = string.Empty;
excep.Machine = GetBarPositionFromAsset(excep.SEGM);
if (DBCommon.CheckPositionToDisplay(excep.Machine, lstPositionstoDisplay))
{
currEGM += excep.currValue;
excep.MachinePrintedQty += 1;
if (oTickets.IsPrintedInMachine)
{
excep.TicketAddedtoList = true;
}
}
else
{
excep.TicketAddedtoList = false;
}
}
}
else
{
excep.Position = GetBarPositionFromAsset(excep.SEGM);
excep.Machine = "";
excep.CurrentCashDesk += excep.currValue;
excep.CashDeskPrintedQty += 1;
excep.TicketAddedtoList = true;
}
}
if (excep.TicketAddedtoList)
{
excep.Value = Convert.ToDouble(row["iAmount"]) / 100;
//excep.Amount = excep.Value.ToString("###0.#0");
excep.Amount = CurrencySymbol + " " + Convert.ToDecimal(excep.Value).GetUniversalCurrencyFormat();
string dPrintDate = row["dtPrinted"].ToString().ToShortDateTimeString();
string dClaimDate = string.IsNullOrEmpty(row["dtPaid"].ToString()) ? "01/01/2100" : row["dtPaid"].ToString();
if(excep.MachinePrintedQty > 0)
excep.TransactionType = "M/c Voucher Issued";
else if(excep.CashDeskPrintedQty > 0)
excep.TransactionType = "C/D Voucher Issued";
excep.Zone = "n/a";
excep.Asset = row["Asset"].ToString();
if ((Convert.ToDateTime(row["dtPrinted"].ToString()) >= Convert.ToDateTime(oTickets.StartDate)) &&
(Convert.ToDateTime(string.IsNullOrEmpty(row["dtPaid"].ToString()) ? DateTime.Now.ToString() : row["dtPaid"].ToString())
<= Convert.ToDateTime(oTickets.EndDate)))
{
excep.Status = "Printed within, Claimed in different category";
}
else if (string.IsNullOrEmpty(row["dtPaid"].ToString()))
{
excep.Status = "Active Ticket";
}
else
{
excep.Value = -excep.Value;
// excep.Amount = excep.Value.ToString("###0.#0");
excep.Amount = CurrencySymbol + " " + Convert.ToDecimal(excep.Value).GetUniversalCurrencyFormat();
excep.Status = "Printed within period, claimed later";
}
excep.Position = sPosTer;
excep.PrintDate = row["dtPrinted"].ToString().ToShortDateTimeString();
// excep.PrintDate = row["dtPrinted"].ToShortDateTimeString();
if (!(row["dtPrinted"] == null))
{
excep.PayDate = Convert.ToDateTime(row["dtPrinted"]) != null ? row["dtPrinted"].ToString().ToShortDateTimeString() :
string.Empty;
}
excep.PayDate = Convert.ToDateTime(row["dtPrinted"]) != null ? row["dtPrinted"].ToString().ToShortDateTimeString() :
string.Empty;
excep.PayDevice = (row["PayDevice"] != null ? row["PayDevice"].ToString() : string.Empty);
if (!string.IsNullOrEmpty(row["strBarCode"].ToString()))
{
excep.Ticket = row["ActualBarcode"].ToString();
}
else
{
excep.Ticket = row["strBarcode"].ToString();
}
// excep.Details = excep.Ticket;
excep.Details = string.Empty;
}
lstTickets.Add(excep);
}
}
}
catch (Exception ex)
{
LogManager.WriteLog(ex.Message, LogManager.enumLogLevel.Info);
ExceptionManager.Publish(ex);
}
if (lstTickets != null && lstTickets.Count > 0)
{
lstTickets[0].currEGM = currEGM;
lstTickets[0].CurrentCashDesk = CurrentCashDesk;
}
return lstTickets;
}
private List<TicketExceptions> LoadVoidCancelledTickets()
{
objCashDeskManager = CashDeskManagerBusinessObject.CreateInstance();
System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate
{
lvVoidCancelled.Items.Clear();
});
List<string> lstPositionstoDisplay = objCashDeskManager.FillListOfFilteredPositions(RouteNumber);
Tickets oTickets = new Tickets();
oTickets.EndDate = EndDate;
oTickets.StartDate = StartDate;
oTickets.IsLiability = false;
oTickets.BarCode = "%";
oTickets.Type = "B";
oTickets.UserNo = UserNo;
System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate
{
prgVoidcancelled.Value += 50;
});
List<TicketExceptions> lstVoidCancelled = objCashDeskManager.GetTicket_VoidnExpired(oTickets, lstPositionstoDisplay);
if (lstVoidCancelled != null)
{
decimal ExceptionTotal = 0;
TicketExceptions Total = new TicketExceptions();
Total.PrintDate = "Total";
foreach (TicketExceptions exep in lstVoidCancelled)
{
ExceptionTotal += (decimal)exep.Value;
}
Total.Value = (double)Decimal.Round(ExceptionTotal, 2);
// Total.Amount = Total.Value.ToString("###0.#0");
Total.Amount = CurrencySymbol + "" + Convert.ToDecimal(ExceptionTotal).GetUniversalCurrencyFormat();
lstVoidCancelled.Insert(0, Total);
System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate
{
prgVoidcancelled.Value += 50;
});
}
return lstVoidCancelled;
}
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;
}
public List<TicketExceptions> TITOTicketInExceptions(Tickets oTickets, List<string> lstPositions)
{
// '
//'
//Dim oRs As adodb.Recordset
//Dim myItem As ListItem
//Dim cTicketTotal As Currency
//Dim currValue As Currency
string strTicketInException = string.Empty;
List<TicketExceptions> lstTickets = null;
try
{
DataTable dtTickets=cashdeskmanagerDataAccess.GetTickets(oTickets);
if (dtTickets == null && dtTickets.Rows.Count < 0)
{
}
else
{
lstTickets = new List<TicketExceptions>();
TicketExceptions excep = null;
// DataTable dtTickets = cashdeskmanagerDataAccess.GetTickets(oTickets);
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;
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-GB");
DateTime dt = DateTime.Parse(row["dtPrinted"].ToString(),
System.Threading.Thread.CurrentThread.CurrentCulture.DateTimeFormat);
if (!string.IsNullOrEmpty(excep.SEGM) && DBCommon.CheckPositionToDisplay(excep.Machine, lstPositions))
{
excep.bExceptionRecordFound = true;
excep.Type = "IN";
excep.Position = cashdeskmanagerDataAccess.GetBarPositionFromAsset(row["PrintDevice"].ToString());
// excep.PrintDate = row["dtPrinted"].ToString().ReadDateTimeWithSeconds().ToString();
excep.PrintDate = Convert.ToDateTime(row["dtPrinted"]).ToString("dd MMM yyyy HH:mm:ss").ReadDateTimeWithSeconds().ToString();
if (!string.IsNullOrEmpty(row["strBarCode"].ToString()))
{
excep.Ticket = row["ActualBarcode"].ToString();
}
else
{
excep.Ticket = row["strBarcode"].ToString();
}
excep.Value = Convert.ToDouble(row["iAmount"]) / 100;
// excep.Amount = excep.Value.ToString("###0.#0");
excep.Amount = CurrencySymbol + " " + Convert.ToDecimal(excep.Value).GetUniversalCurrencyFormat();
excep.Asset = row["Asset"].ToString();
excep.PayDevice = row["PayDevice"].ToString();
excep.CreateCompleted = string.Empty;
excep.DeviceID = row["DeviceID"].ToString();
excep.cTicketTotal += excep.currValue;
excep.cExceptionsTotal += excep.currValue;
}
else if (DBCommon.IsMachineATicketWorkstation(row["PrintDevice"].ToString()))
{
excep.bExceptionRecordFound = true;
excep.Type = "IN";
excep.Position = cashdeskmanagerDataAccess.GetBarPositionFromAsset(row["PrintDevice"].ToString());
excep.PrintDate = Convert.ToDateTime(row["dtPrinted"]).ToString("dd MMM yyyy HH:mm:ss").ReadDateTimeWithSeconds().ToString();
// excep.PrintDate = dt.ToString().ReadDateTimeWithSeconds().ToString();
if (!string.IsNullOrEmpty(row["strBarCode"].ToString()))
{
excep.Ticket = row["ActualBarcode"].ToString();
}
else
{
excep.Ticket = row["strBarcode"].ToString();
}
excep.Value = Convert.ToDouble(row["iAmount"]) / 100;
excep.Amount = CurrencySymbol + " " + Convert.ToDecimal(excep.Value).GetUniversalCurrencyFormat();
//excep.Amount = excep.Value.ToString("###0.#0");
excep.Asset = row["Asset"].ToString();
excep.PayDevice = row["PayDevice"].ToString();
excep.CreateCompleted = string.Empty;
excep.cTicketTotal += excep.currValue;
excep.cExceptionsTotal += excep.currValue;
}
lstTickets.Add(excep);
}
}
}
catch (Exception ex)
{
LogManager.WriteLog(ex.Message, LogManager.enumLogLevel.Info);
ExceptionManager.Publish(ex);
}
return lstTickets;
}
public static List<TicketExceptions> TitoTicketsClaimed(Tickets oTickets, List<string> lstPositionstoDisplay)
{
string strTicketInException = string.Empty;
string sPosTer = string.Empty;
List<TicketExceptions> lstTickets = null;
TicketExceptions excep = null;
try
{
DataTable dtTickets = DBBuilder.GetTickets(oTickets);
if (dtTickets == null && dtTickets.Rows.Count < 0)
{
}
else
{
lstTickets = new List<TicketExceptions>();
foreach (DataRow row in dtTickets.Rows)
{
excep = new TicketExceptions();
excep.bExceptionRecordFound = false;
excep.SEGM = row["PayDevice"].ToString();
excep.currValue = (float)Convert.ToDouble(row["iAmount"]) / 100;
if (!string.IsNullOrEmpty(excep.SEGM) && row["strDeviceType"].ToString().Equals("EXTITO"))
{
if (DBCommon.IsMachineATicketWorkstation(excep.SEGM))
{
if (DBCommon.CheckPositionToDisplay(GetBarPositionFromAsset(row["PrintDevice"].ToString()), lstPositionstoDisplay))
{
sPosTer = excep.SEGM;
excep.Machine = GetBarPositionFromAsset(row["PrintDevice"].ToString());
excep.CurrentCashDesk += excep.currValue;
excep.CashDeskClaimedQty += 1;
if (oTickets.IsClaimedInCashDesk == true)
{
excep.bExceptionRecordFound = true;
}
}
}
else
{
sPosTer = string.Empty;
excep.Machine = GetBarPositionFromAsset(excep.SEGM);
if (DBCommon.CheckPositionToDisplay(excep.Machine, lstPositionstoDisplay))
{
excep.currEGM += excep.currValue;
excep.MachineClaimedQty += 1;
if (oTickets.IsClaimedInMachine)
{
excep.bExceptionRecordFound = true;
}
}
}
}
else
{
sPosTer = row["PrintDevice"].ToString();
excep.Machine = row["PayDevice"].ToString();
excep.CurrentCashDesk += excep.currValue;
excep.CashDeskClaimedQty += 1;
if (oTickets.IsClaimedInCashDesk)
{
excep.bExceptionRecordFound = true;
}
}
if (excep.bExceptionRecordFound)
{
string dPrintDate = row["dtPrinted"].ToString();
string dClaimDate = row["dtPaid"].ToString();
excep.Position = sPosTer;
excep.Machine = DBBuilder.GetBarPositionFromAsset(excep.Machine);
// excep.Machine = sPosTer;
excep.TransactionType="TITO Claimed";
excep.Zone = "n/a";
excep.PrintDate = Convert.ToDateTime(row["dtPrinted"]).ToString("dd MMM yyyy") + " " +
Convert.ToDateTime(row["dtPrinted"]).ToString("HH:mm");
if (!(row["dtPaid"] == null))
{
excep.PayDate = Convert.ToDateTime(row["dtPaid"] != null ? row["dtPaid"] : string.Empty).ToString("dd MMM yyyy") + " " +
Convert.ToDateTime(row["dtPaid"] != null ? row["dtPaid"] : string.Empty).ToString("hh:mm");
}
excep.PayDevice = (row["PayDevice"] != null ? GetBarPositionFromAsset(row["PayDevice"].ToString()) : string.Empty);
if (!string.IsNullOrEmpty(row["strBarCode"].ToString()))
{
excep.Ticket = row["ActualBarcode"].ToString();
}
else
{
excep.Ticket = row["strBarcode"].ToString();
}
excep.Value = -(Convert.ToDouble(row["iAmount"]) / 100);
excep.Amount = (-(excep.Value)).ToString();
if ((Convert.ToDateTime(dPrintDate) >= Convert.ToDateTime(oTickets.StartDate)) &&
(Convert.ToDateTime(dClaimDate) <= Convert.ToDateTime(oTickets.EndDate)))
{
excep.Status = "Printed in different category, Claimed within";
}
else
{
excep.Status = "Printed prior to period, Claimed within";
}
excep.Details = "";
excep.cExceptionsTotal += (float)excep.Value;
}
lstTickets.Add(excep);
}
}
}
catch (Exception ex)
{
LogManager.WriteLog(ex.Message, LogManager.enumLogLevel.Info);
ExceptionManager.Publish(ex);
}
return lstTickets;
}
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 List<TicketExceptions> LoadExceptions()
{
decimal ExceptionTotal = 0;
List<string> lstPositionstoDisplay = objCashDeskManager.FillListOfFilteredPositions(RouteNumber);
//FillListOfFilteredPositions
Tickets oTickets = new Tickets();
oTickets.EndDate = dtTo;
oTickets.StartDate = dtFrom;
oTickets.IsLiability = false;
oTickets.BarCode = "%";
oTickets.Type = "E";
oTickets.UserNo = UserNo;
System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate
{
prgExceptions.Value += 50;
});
List<TicketExceptions> lstExceptions = objCashDeskManager.TITOTicketInExceptions(oTickets, lstPositionstoDisplay);
if (lstExceptions == null)
{
lstExceptions = new List<TicketExceptions>();
}
System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate
{
prgExceptions.Value += 50;
});
List<TicketExceptions> lstExceptionsOut = objCashDeskManager.TitoTicketOutExceptions(oTickets, lstPositionstoDisplay);
if (lstExceptionsOut != null)
{
foreach (TicketExceptions exep in lstExceptionsOut)
{
lstExceptions.Add(exep);
}
}
//CreateTotals cExceptionsTotal
foreach (TicketExceptions item in lstExceptions)
{
ExceptionTotal += (decimal) item.currValue;
}
TicketExceptions Total = new TicketExceptions();
Total.Type = "Total";
Total.Amount = CurrencySymbol + "" + Convert.ToDecimal(ExceptionTotal).GetUniversalCurrencyFormat();
lstExceptions.Insert(0, Total);
System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate
{
prgExceptions.Value += 50;
});
return lstExceptions;
}
public static List<TicketExceptions> GetTreasuryItems(Tickets oTickets, List<string> lstPositions)
{
List<TicketExceptions> items = null;
TicketExceptions treasury = null;
try
{
DataTable dtTreasury = ExecuteTable(GetExchangeConnectionString(), oTickets, false);
items = new List<TicketExceptions>();
foreach (DataRow row in dtTreasury.Rows)
{
if (DBCommon.CheckPositionToDisplay(row["bar_pos_name"].ToString(), lstPositions))
{
treasury = new TicketExceptions();
treasury.PayDate = row["treasury_date"].ToString() + " " + row["treasury_time"].ToString();
treasury.PrintDate = row["treasury_date"].ToString() + " " + row["treasury_time"].ToString();
treasury.TransactionType = oTickets.Type;
treasury.Zone = row["Zone_name"].ToString();
treasury.Position = row["bar_pos_name"].ToString();
treasury.Machine = row["machine_name"].ToString();
treasury.Amount = row["treasury_amount"].ToString();
treasury.Details = "";
switch (oTickets.Type)
{
case DBConstants.CONST_HANDPAYCREDIT:
{
treasury.HandpayQty += 1;
break;
}
case DBConstants.CONST_JACKPOT:
{
treasury.JackPotQty += 1;
break;
}
case DBConstants.CONST_PROG:
{
treasury.ProgQty += 1;
break;
}
case DBConstants.CONST_REFILL:
{
treasury.RefillQty += 1;
break;
}
case DBConstants.CONST_REFUND:
{
treasury.RefundQty += 1;
break;
}
case DBConstants.CONST_SHORTPAY:
{
treasury.ShortQty += 1;
break;
}
case DBConstants.CONST_FLOAT:
{
treasury.FloatQty += 1;
break;
}
default:
break;
}
items.Add(treasury);
}
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
return items;
}
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;
}
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;
}
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;
}
public List<TicketExceptions> TITOTicketInExceptions(Tickets oTickets, List<string> lstPositions)
{
// '
//'
//Dim oRs As adodb.Recordset
//Dim myItem As ListItem
//Dim cTicketTotal As Currency
//Dim currValue As Currency
string strTicketInException = string.Empty;
List<TicketExceptions> lstTickets = null;
try
{
if (DBBuilder.GetTickets(oTickets) == null && DBBuilder.GetTickets(oTickets).Rows.Count < 0)
{
}
else
{
lstTickets = new List<TicketExceptions>();
TicketExceptions excep = null;
DataTable dtTickets = DBBuilder.GetTickets(oTickets);
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 (!string.IsNullOrEmpty(excep.SEGM) && DBCommon.CheckPositionToDisplay(excep.Machine, lstPositions))
{
excep.bExceptionRecordFound = true;
excep.Type = "IN";
excep.Position = DBBuilder.GetBarPositionFromAsset(row["PrintDevice"].ToString());
excep.PrintDate = Convert.ToDateTime(row["dtPrinted"]).ToString("dd MMM yyyy") + " " +
Convert.ToDateTime(row["dtPrinted"]).ToString("HH:mm");
if (!string.IsNullOrEmpty(row["strBarCode"].ToString()))
{
excep.Ticket = row["ActualBarcode"].ToString();
}
else
{
excep.Ticket = row["strBarcode"].ToString();
}
excep.Value = Convert.ToDouble(row["iAmount"]) / 100;
excep.Asset = row["PrintDevice"].ToString();
excep.PayDevice = row["PayDevice"].ToString();
excep.CreateCompleted = string.Empty;
excep.cTicketTotal += excep.currValue;
excep.cExceptionsTotal += excep.currValue;
}
else if (DBCommon.IsMachineATicketWorkstation(row["PrintDevice"].ToString()))
{
excep.bExceptionRecordFound = true;
excep.Type = "IN";
excep.Position = DBBuilder.GetBarPositionFromAsset(row["PrintDevice"].ToString());
excep.PrintDate = Convert.ToDateTime(row["dtPrinted"]).ToString("dd MMM yyyy") + " " +
Convert.ToDateTime(row["dtPrinted"]).ToString("HH:mm");
if (!string.IsNullOrEmpty(row["strBarCode"].ToString()))
{
excep.Ticket = row["ActualBarcode"].ToString();
}
else
{
excep.Ticket = row["strBarcode"].ToString();
}
excep.Value = Convert.ToDouble(row["iAmount"]) / 100;
excep.Asset = row["PrintDevice"].ToString();
excep.PayDevice = row["PayDevice"].ToString();
excep.CreateCompleted = string.Empty;
excep.cTicketTotal += excep.currValue;
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> 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 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> LoadVoidCancelledTickets()
{
busTreasury = new TreasuryTransactions();
System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate
{
lvVoidCancelled.Items.Clear();
});
List<string> lstPositionstoDisplay = busTreasury.FillListOfFilteredPositions(RouteNumber);
Tickets oTickets = new Tickets();
oTickets.EndDate = EndDate + " " + EndTime;
oTickets.StartDate = StartDate + " " + StartTime;
oTickets.IsLiability = false;
oTickets.BarCode = "%";
oTickets.Type = "B";
System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate
{
prgVoidcancelled.Value += 50;
});
List<TicketExceptions> lstVoidCancelled = busTreasury.GetTicket_VoidnExpired(oTickets, lstPositionstoDisplay);
if (lstVoidCancelled != null)
{
decimal ExceptionTotal = 0;
TicketExceptions Total = new TicketExceptions();
Total.PrintDate = "Total";
foreach (TicketExceptions exep in lstVoidCancelled)
{
ExceptionTotal += (decimal)exep.Value;
}
Total.Value = (double)Decimal.Round(ExceptionTotal, 2);
lstVoidCancelled.Insert(0, Total);
System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate
{
prgVoidcancelled.Value += 50;
});
}
return lstVoidCancelled;
}
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;
}
private List<TicketExceptions> LoadExceptions()
{
busTreasury = new TreasuryTransactions();
float ExceptionTotal = 0F;
System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate
{
lvExceptions.Items.Clear();
});
List<string> lstPositionstoDisplay = busTreasury.FillListOfFilteredPositions(RouteNumber);
//FillListOfFilteredPositions
Tickets oTickets = new Tickets();
oTickets.EndDate = dtTo + " " + TimeTo;
oTickets.StartDate = dtFrom + " " + TimeFrom;
oTickets.IsLiability = false;
oTickets.BarCode = "%";
oTickets.Type = "E";
System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate
{
prgExceptions.Value += 50;
});
List<TicketExceptions> lstExceptions = busTreasury.TITOTicketInExceptions(oTickets, lstPositionstoDisplay);
System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate
{
prgExceptions.Value += 50;
});
List<TicketExceptions> lstExceptionsOut = busTreasury.TitoTicketOutExceptions(oTickets, lstPositionstoDisplay);
if (lstExceptionsOut.Count > 0)
{
if (lstExceptionsOut[0].bExceptionRecordFound)
{
TicketExceptions Total = new TicketExceptions();
Total.Type = "Total";
foreach (TicketExceptions exep in lstExceptionsOut)
{
ExceptionTotal += exep.cExceptionsTotal;
}
Total.Value = Convert.ToDouble(ExceptionTotal.ToString("###0.00"));
lstExceptionsOut.Insert(0, Total);
//CreateTotals cExceptionsTotal
}
}
System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate
{
prgExceptions.Value += 50;
});
return lstExceptionsOut;
}
public static List<TicketExceptions> TitoTicketOutExceptions(Tickets oTickets, List<string> lstPositionstoDisplay)
{
List<TicketExceptions> lstTickets = null;
try
{
SqlParameter[] parameters = SqlHelperParameterCache.GetSpParameterSet(GetExchangeConnectionString(), "rsp_GetNonCompletedTicketPrints");
foreach (SqlParameter param in parameters)
{
if (param.ParameterName == "@StartDate")
{
param.Value = oTickets.StartDate;
}
if (param.ParameterName == "@EndDate")
{
param.Value = oTickets.EndDate;
}
}
SqlDataReader reader = SqlHelper.ExecuteReader(GetExchangeConnectionString(), "rsp_GetNonCompletedTicketPrints", parameters);
lstTickets = new List<TicketExceptions>();
TicketExceptions excep = null;
while (reader.Read())
{
excep = new TicketExceptions();
excep.SEGM = reader["bar_pos_name"].ToString();
excep.Machine = DBBuilder.GetBarPositionFromAsset(reader["bar_pos_name"].ToString());
excep.currValue = (float)Convert.ToDouble(reader["TE_Value"]) / 100;
if (!string.IsNullOrEmpty(excep.SEGM) && DBCommon.CheckPositionToDisplay(excep.Machine, lstPositionstoDisplay))
{
excep.bExceptionRecordFound = true;
excep.Type = "OUT";
excep.Position = DBBuilder.GetBarPositionFromAsset(reader["bar_pos_name"].ToString());
excep.PrintDate = Convert.ToDateTime(reader["TE_Date"]).ToString("dd MMM yyyy") + " " +
Convert.ToDateTime(reader["TE_Date"]).ToString("HH:mm");
if (!string.IsNullOrEmpty(reader["TE_TicketNumber"].ToString()))
{
excep.Ticket = reader["ActualBarcode"].ToString();
}
else
{
excep.Ticket = reader["TE_TicketNumber"].ToString();
}
excep.Value = Convert.ToDouble(reader["TE_Value"]) / 100;
excep.Asset = reader["stock_no"].ToString();
excep.COLINSTALLID = Convert.ToInt16(reader["TE_Installation_No"].ToString());
excep.CreateCompleted = reader["CreateExpected"].ToString();
excep.cTicketTotal += excep.currValue;
excep.cExceptionsTotal += excep.currValue;
}
else if (DBCommon.IsMachineATicketWorkstation(excep.Machine))
{
excep.bExceptionRecordFound = true;
excep.Type = "OUT";
excep.Position = DBBuilder.GetBarPositionFromAsset(reader["bar_pos_name"].ToString());
excep.PrintDate = Convert.ToDateTime(reader["TE_Date"]).ToString("dd MMM yyyy") + " " +
Convert.ToDateTime(reader["TE_Date"]).ToString("HH:mm");
if (!string.IsNullOrEmpty(reader["TE_TicketNumber"].ToString()))
{
excep.Ticket = reader["ActualBarcode"].ToString();
}
else
{
excep.Ticket = reader["TE_TicketNumber"].ToString();
}
excep.Value = Convert.ToDouble(reader["TE_Value"]) / 100;
excep.Asset = reader["stock_no"].ToString();
excep.COLINSTALLID = Convert.ToInt16(reader["TE_Installation_No"].ToString());
excep.CreateCompleted = reader["CreateExpected"].ToString();
excep.cTicketTotal += excep.currValue;
excep.cExceptionsTotal += excep.currValue;
}
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;
}
public static List<TicketExceptions> TitoTicketsPrintedLiability(Tickets oTickets, List<string> lstPositionstoDisplay)
{
string strTicketInException = string.Empty;
string sPosTer = string.Empty;
List<TicketExceptions> lstTickets = null;
TicketExceptions excep = null;
try
{
DataTable dtTickets = DBBuilder.GetTickets(oTickets);
if (dtTickets == null && dtTickets.Rows.Count < 0)
{
}
else
{
lstTickets = new List<TicketExceptions>();
foreach (DataRow row in dtTickets.Rows)
{
excep = new TicketExceptions();
excep.bExceptionRecordFound = false;
excep.SEGM = row["PrintDevice"].ToString();
excep.VoucherStatus = row["strVoucherStatus"].ToString();
excep.TicketAddedtoList = false;
excep.currValue = (float)Convert.ToDouble(row["iAmount"]) / 100;
if (!string.IsNullOrEmpty(excep.SEGM))
{
if (row["strDeviceType"].ToString().Equals("EXTITO") || string.IsNullOrEmpty(row["strDeviceType"].ToString()))
{
if (DBCommon.IsMachineATicketWorkstation(excep.SEGM))
{
excep.TicketAddedtoList = true;
}
else
{
sPosTer = string.Empty;
excep.Machine = GetBarPositionFromAsset(excep.SEGM);
if (DBCommon.CheckPositionToDisplay(excep.Machine, lstPositionstoDisplay))
{
excep.TicketAddedtoList = true;
}
}
}
else
{
excep.TicketAddedtoList = true;
}
}
if (excep.TicketAddedtoList)
{
string dPrintDate = row["dtPrinted"].ToString();
string dClaimDate = string.IsNullOrEmpty(row["dtPaid"].ToString()) ? "01/01/3100" : row["dtPaid"].ToString();
excep.TransactionType = "TITO Printed";
excep.Zone = "n/a";
if ((Convert.ToDateTime(dPrintDate) >= Convert.ToDateTime(oTickets.StartDate)) &&
(Convert.ToDateTime(dClaimDate) <= Convert.ToDateTime(oTickets.EndDate)))
{
excep.Status = "Printed within, Claimed in different category";
}
else if (string.IsNullOrEmpty(row["dtPaid"].ToString()))
{
excep.Status = "Active Ticket";
}
else
{
excep.Status = "Printed within period, claimed later";
}
excep.Position = DBBuilder.GetBarPositionFromAsset(row["PrintDevice"].ToString());
excep.PrintDate = Convert.ToDateTime(row["dtPrinted"]).ToString("dd MMM yyyy") + " " +
Convert.ToDateTime(row["dtPrinted"]).ToString("HH:mm");
if (!(row["dtPaid"] == null))
{
excep.PayDate = Convert.ToDateTime(row["dtPaid"] != null ? row["dtPaid"] : string.Empty).ToString("dd MMM yyyy") + " " +
Convert.ToDateTime(row["dtPaid"] != null ? row["dtPaid"] : string.Empty).ToString("HH:mm");
}
excep.PayDevice = (row["PayDevice"] != null ? GetBarPositionFromAsset( row["PayDevice"].ToString() ): string.Empty);
if (!string.IsNullOrEmpty(row["strBarCode"].ToString()))
{
excep.Ticket = row["ActualBarcode"].ToString();
}
else
{
excep.Ticket = row["strBarcode"].ToString();
}
excep.Value = Convert.ToDouble(row["iAmount"]) / 100;
excep.Amount = "(" + excep.Value + ")";
}
lstTickets.Add(excep);
}
}
}
catch (Exception ex)
{
LogManager.WriteLog(ex.Message, LogManager.enumLogLevel.Info);
ExceptionManager.Publish(ex);
}
return lstTickets;
}
public List<TicketExceptions> GetTreasuryItems(Tickets oTickets, List<string> lstPositions)
{
List<TicketExceptions> items = null;
TicketExceptions treasury = null;
try
{
DataTable dtTreasury = ExecuteTable(oTickets, false);
items = new List<TicketExceptions>();
foreach (DataRow row in dtTreasury.Rows)
{
if (DBCommon.CheckPositionToDisplay(row["bar_pos_name"].ToString(), lstPositions))
{
treasury = new TicketExceptions();
//treasury.PayDate = row["treasury_date"].ToString() + " " + row["treasury_time"].ToString();
//treasury.PrintDate = row["treasury_date"].ToString() + " " + row["treasury_time"].ToString();
//treasury.PayDate = Convert.ToDateTime(row["treasury_date"]).ToString("dd MMM yyyy HH:mm:ss").ReadDateTimeWithSeconds().ToString();
//treasury.PrintDate = Convert.ToDateTime(row["treasury_date"]).ToString("dd MMM yyyy HH:mm:ss").ReadDateTimeWithSeconds().ToString();
treasury.PayDate = row["treasury_date"].ToString().ToShortDateTimeString();
treasury.PrintDate = row["treasury_date"].ToString().ToShortDateTimeString();
treasury.TransactionType = oTickets.Type;
treasury.Zone = row["Zone_name"].ToString();
treasury.Position = row["bar_pos_name"].ToString();
treasury.Machine = row["machine_name"].ToString();
//treasury.Amount = Convert.ToDouble(row["treasury_amount"]).ToString("###0.#0");
treasury.Amount = CurrencySymbol + " " + Convert.ToDecimal(row["treasury_amount"]).GetUniversalCurrencyFormat();
treasury.currValue = Convert.ToInt64(row["treasury_amount"]);
treasury.Value = Convert.ToDouble(row["treasury_amount"]);
treasury.Reason = row["treasury_reason"].ToString();
treasury.ReasonCode = row["treasury_reason_code"].ToString();
treasury.Asset = row["Asset"].ToString();
treasury.TreasuryTemp = Convert.ToBoolean(row["Treasury_Temp"].ToString());
treasury.Details = "";
if (string.IsNullOrEmpty(treasury.Reason))
{
switch (oTickets.Type)
{
case DBConstants.CONST_HANDPAYCREDIT:
{
treasury.HandpayQty += 1;
treasury.TransactionType = row["TreasuryTypeDisplayText"].ToString();
break;
}
case DBConstants.CONST_JACKPOT:
{
treasury.JackPotQty += 1;
treasury.TransactionType = row["TreasuryTypeDisplayText"].ToString();
break;
}
case DBConstants.CONST_PROG:
{
treasury.ProgQty += 1;
treasury.TransactionType = row["TreasuryTypeDisplayText"].ToString();
break;
}
case DBConstants.CONST_REFILL:
{
treasury.RefillQty += 1;
break;
}
case DBConstants.CONST_REFUND:
{
treasury.RefundQty += 1;
break;
}
case DBConstants.CONST_SHORTPAY:
{
treasury.ShortQty += 1;
break;
}
case DBConstants.CONST_FLOAT:
{
treasury.FloatQty += 1;
break;
}
default:
break;
}
}
items.Add(treasury);
}
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
return items;
}
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;
}
public List<TicketExceptions> TitoTicketsClaimedLiability(Tickets oTickets, List<string> lstPositionstoDisplay)
{
string strTicketInException = string.Empty;
string sPosTer = string.Empty;
List<TicketExceptions> lstTickets = null;
TicketExceptions excep = null;
try
{
DataTable dtTickets = GetTickets(oTickets);
if (dtTickets == null || dtTickets.Rows.Count < 0)
{
}
else
{
lstTickets = new List<TicketExceptions>();
foreach (DataRow row in dtTickets.Rows)
{
excep = new TicketExceptions();
excep.bExceptionRecordFound = false;
excep.SEGM = row["PayDevice"].ToString();
excep.currValue = (float)Convert.ToDouble(row["iAmount"]) / 100;
excep.VoucherStatus = row["strVoucherStatus"].ToString();
if (!string.IsNullOrEmpty(excep.SEGM) && row["strDeviceType"].ToString().Equals("EXTITO"))
{
if (DBCommon.IsMachineATicketWorkstation(excep.SEGM))
{
if (DBCommon.CheckPositionToDisplay(GetBarPositionFromAsset(row["PrintDevice"].ToString()), lstPositionstoDisplay))
{
sPosTer = excep.SEGM;
excep.Machine = GetBarPositionFromAsset(row["PrintDevice"].ToString());
excep.bExceptionRecordFound = true;
}
}
else
{
sPosTer = string.Empty;
excep.Machine = GetBarPositionFromAsset(excep.SEGM);
if (DBCommon.CheckPositionToDisplay(excep.Machine, lstPositionstoDisplay))
{
excep.bExceptionRecordFound = true;
}
}
}
else
{
excep.bExceptionRecordFound = true;
}
if (excep.bExceptionRecordFound)
{
string dPrintDate = row["dtPrinted"].ToString();
string dClaimDate = row["dtPaid"].ToString();
excep.VoucherStatus = row["strVoucherStatus"].ToString();
excep.Position = GetBarPositionFromAsset(row["PrintDevice"].ToString());
excep.TransactionType = "Voucher Claimed";
excep.Zone = "n/a";
excep.PrintDate = row["dtPrinted"].ToString().ToShortDateTimeString();
// + " " + Convert.ToDateTime(row["dtPrinted"]).ToString("HH:mm");
if (!(row["dtPaid"] == null))
{
excep.PayDate = row["dtPaid"].ToString().ToShortDateTimeString();
//+" " + Convert.ToDateTime(row["dtPaid"] != null ? row["dtPaid"] : string.Empty).ToString("HH:mm");
}
excep.PayDevice = (row["PayDevice"] != null ? GetBarPositionFromAsset(row["PayDevice"].ToString()) : string.Empty);
if (!string.IsNullOrEmpty(row["strBarCode"].ToString()))
{
excep.Ticket = row["ActualBarcode"].ToString();
}
else
{
excep.Ticket = row["strBarcode"].ToString();
}
excep.Value = -(Convert.ToDouble(row["iAmount"]) / 100);
// excep.Amount = (-(excep.Value)).ToString("###0.#0");
excep.Amount = CurrencySymbol + " " + Convert.ToDecimal(-excep.Value).GetUniversalCurrencyFormat();
if ((Convert.ToDateTime(dPrintDate) >= Convert.ToDateTime(oTickets.StartDate)) &&
(Convert.ToDateTime(dClaimDate) <= Convert.ToDateTime(oTickets.EndDate)))
{
excep.Status = "Printed in different category, Claimed within";
}
else
{
excep.Status = "Printed prior to period, Claimed within";
}
excep.cExceptionsTotal += (float)excep.Value;
excep.Asset = row["Asset"].ToString();
lstTickets.Add(excep);
}
}
}
}
catch (Exception ex)
{
LogManager.WriteLog(ex.Message, LogManager.enumLogLevel.Info);
ExceptionManager.Publish(ex);
}
return lstTickets;
}
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;
}