private List<TicketExceptions> LoadTicketsAll()
{
objCashDeskManager = CashDeskManagerBusinessObject.CreateInstance();
List<string> lstPositionstoDisplay = objCashDeskManager.FillListOfFilteredPositions(RouteNumber);
Tickets oTickets = new Tickets();
oTickets.EndDate = EndDate;
oTickets.StartDate = StartDate;
oTickets.IsLiability = false;
oTickets.BarCode = "%";
oTickets.Type = "A";
oTickets.UserNo = UserNo;
System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate
{
prgDebugState.Value += 50;
});
List<TicketExceptions> lstExceptions = objCashDeskManager.TitoTicketsAll(oTickets, lstPositionstoDisplay);
System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate
{
prgDebugState.Value += 150;
});
return lstExceptions;
}
private List<TicketExceptions> LoadTicketsAll()
{
busTreasury = new TreasuryTransactions();
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 = "A";
System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate
{
prgDebugState.Value += 50;
});
List<TicketExceptions> lstExceptions = busTreasury.TitoTicketsAll(oTickets, lstPositionstoDisplay);
System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate
{
prgDebugState.Value += 150;
});
return lstExceptions;
}
private List<TicketExceptions> LoadVoidExpiredTickets()
{
busTreasury = new TreasuryTransactions();
System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate
{
lvVoidExpired.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 = "D";
System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate
{
prgVoidExpiredState.Value += 75;
});
List<TicketExceptions> lstVoidExpired = busTreasury.GetTicket_VoidnExpired(oTickets, lstPositionstoDisplay);
decimal ExceptionTotal = 0;
TicketExceptions Total = new TicketExceptions();
Total.PrintDate = "Total";
if (lstVoidExpired != null)
{
foreach (TicketExceptions exep in lstVoidExpired)
{
ExceptionTotal += (decimal)exep.Value;
}
Total.Value = (double)Decimal.Round(ExceptionTotal, 2);
lstVoidExpired.Insert(0, Total);
System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart)delegate
{
prgVoidExpiredState.Value += 50;
});
}
return lstVoidExpired;
}
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> 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> 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 static DataTable GetTickets(Tickets oTickets)
{
DataTable dtTickets = null;
try
{
string strVoucherInformation = "rsp_BGS_VoucherInformation";
dtTickets = ExecuteTable(strVoucherInformation, oTickets);
return dtTickets;
}
catch (Exception ex)
{
LogManager.WriteLog(ex.Message, LogManager.enumLogLevel.Info);
ExceptionManager.Publish(ex);
return dtTickets;
}
}
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;
}
private static DataTable ExecuteTable(string ExchangeConnectionString, Tickets oTickets,bool flag)
{
return SqlHelper.ExecuteDataset(ExchangeConnectionString, DBConstants.CONST_SP_RSP_GETTREASURYITEMS,
GetTreasuryParameters(oTickets)).Tables[0];
// return SqlHelper.ExecuteDataset(SQLConnection(), StoredProcedure,CommandType.StoredProcedure, GetVoucherParameters(oTickets)).Tables[0];
}
private static object[] GetVoucherParameters(Tickets oTickets)
{
SqlParameter[] ObjParams = new SqlParameter[5];
ObjParams[0] = new SqlParameter(DBConstants.CONST_PARAM_STARTDATE, oTickets.StartDate);
ObjParams[1] = new SqlParameter(DBConstants.CONST_PARAM_ENDDATE, oTickets.EndDate);
ObjParams[2] = new SqlParameter(DBConstants.CONST_PARAM_TYPE, oTickets.Type);
ObjParams[3] = new SqlParameter(DBConstants.CONST_PARAM_BARCODE, oTickets.BarCode);
ObjParams[4] = new SqlParameter(DBConstants.CONST_PARAM_LIABILITY, Convert.ToInt16(oTickets.IsLiability));
return ObjParams;
}
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> 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> 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;
}
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;
}
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> 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> GetTreasuryItems(Tickets oTickets, List<string> lstPositions)
{
return DBBuilder.GetTreasuryItems(oTickets, lstPositions);
}
private static DataTable ExecuteTable(string StoredProcedure, Tickets oTickets)
{
return SqlHelper.ExecuteDataset(TicketSQLConnection(), StoredProcedure, GetVoucherParameters(oTickets)).Tables[0];
// return SqlHelper.ExecuteDataset(SQLConnection(), StoredProcedure,CommandType.StoredProcedure, GetVoucherParameters(oTickets)).Tables[0];
}
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 static object[] GetTicketsParameters(Tickets oTickets)
{
SqlParameter[] ObjParams = new SqlParameter[4];
ObjParams[0] = new SqlParameter(DBConstants.CONST_PARAM_STARTDATE, oTickets.StartDate);
ObjParams[1] = new SqlParameter(DBConstants.CONST_PARAM_ENDDATE, oTickets.EndDate);
ObjParams[2] = new SqlParameter(DBConstants.CONST_PARAM_TYPE, oTickets.Type);
ObjParams[3] = new SqlParameter(DBConstants.CONST_PARAM_LIABILITY, oTickets.IsLiability);
return ObjParams;
}
private DataTable ExecuteTable(string StoredProcedure, Tickets oTickets)
{
try
{
return SqlHelper.ExecuteDataset(TicketSQLConnection(), StoredProcedure, GetVoucherParameters(oTickets)).Tables[0];
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
return null;
}
// return SqlHelper.ExecuteDataset(SQLConnection(), StoredProcedure,CommandType.StoredProcedure, GetVoucherParameters(oTickets)).Tables[0];
}
private static object[] GetTreasuryParameters(Tickets oTickets)
{
SqlParameter[] ObjParams = new SqlParameter[3];
ObjParams[0] = new SqlParameter(DBConstants.CONST_PARAM_STARTDATE, oTickets.StartDate);
ObjParams[1] = new SqlParameter(DBConstants.CONST_PARAM_ENDDATE, oTickets.EndDate);
ObjParams[2] = new SqlParameter(DBConstants.CONST_PARAM_TYPE, oTickets.Type);
return ObjParams;
}
private DataTable ExecuteTable(Tickets oTickets, bool flag)
{
try
{
return SqlHelper.ExecuteDataset(SQLConnection(), DBConstants.CONST_SP_RSP_GETTREASURYITEMS, GetTreasuryParameters(oTickets)).Tables[0];
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
return null;
}
// return SqlHelper.ExecuteDataset(SQLConnection(), StoredProcedure,CommandType.StoredProcedure, GetVoucherParameters(oTickets)).Tables[0];
}
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;
}
private object[] GetVoucherParameters(Tickets oTickets)
{
try
{
SqlParameter[] ObjParams = new SqlParameter[6];
ObjParams[0] = new SqlParameter(DBConstants.CONST_PARAM_STARTDATE, oTickets.StartDate);
ObjParams[1] = new SqlParameter(DBConstants.CONST_PARAM_ENDDATE, oTickets.EndDate);
ObjParams[2] = new SqlParameter(DBConstants.CONST_PARAM_TYPE, oTickets.Type);
ObjParams[3] = new SqlParameter(DBConstants.CONST_PARAM_BARCODE, oTickets.BarCode);
ObjParams[4] = new SqlParameter(DBConstants.CONST_PARAM_LIABILITY, Convert.ToInt16(oTickets.IsLiability));
ObjParams[5] = new SqlParameter("@User", oTickets.UserNo);
return ObjParams;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
return null;
}
}
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;
}
private object[] GetTreasuryParameters(Tickets oTickets)
{
try
{
SqlParameter[] ObjParams = new SqlParameter[3];
ObjParams[0] = new SqlParameter(DBConstants.CONST_PARAM_STARTDATE, oTickets.StartDate);
ObjParams[1] = new SqlParameter(DBConstants.CONST_PARAM_ENDDATE, oTickets.EndDate);
ObjParams[2] = new SqlParameter(DBConstants.CONST_PARAM_TYPE, oTickets.Type);
return ObjParams;
}
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;
}
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;
}
