public double GetOperationalHours(DateTime?date)
{
double?result = 0;
using (LinqDataAccessDataContext context = new LinqDataAccessDataContext(CommonDataAccess.ExchangeConnectionString))
context.GetOperationalHours(date, ref result);
return(Convert.ToDouble(result));
}
public DataSet CreateTickeException_HandpayCage(int Bar_Pos, Double TicketValue, string Server, int isHandpayResponse, string HP_Type)
{
try
{
LinqDataAccessDataContext linqDB = new LinqDataAccessDataContext();
return(linqDB.createTickeException_HandpayCAGE(Bar_Pos, TicketValue, Server, isHandpayResponse, HP_Type));
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
}
return(null);
}
public jackpotProcessInfoDTO payJackpot(string SequenceNumber, int SiteId, string userId, string firstName, string lastName, string cashDeskLocation)
{
LinqDataAccessDataContext linqDB = new LinqDataAccessDataContext(CommonDataAccess.ExchangeConnectionString);
jackpotProcessInfoDTO jpinfo = getJackpotStatusAmount(SequenceNumber, SiteId);
Treasury objTreasury = new Treasury();
int? Treasury_No = 0;
int result;
int iInstallationNumber = 0;
ISingleResult <HandpayEntities> lstHpDetails = linqDB.GetHpDetails(Convert.ToInt32(jpinfo.sequenceNumber));
int IsManualAttendantPay = 0;
try
{
foreach (HandpayEntities ticket in lstHpDetails)
{
IsManualAttendantPay = ticket.IsManualAttendantPay;
iInstallationNumber = int.Parse(ticket.installation_no.ToString());
result = linqDB.InsertTreasuryCage(ticket.installation_no, 0, userId, ticket.handpaytype, "", Convert.ToDecimal(ticket.amount)
, false, "", 0, 0, false, 0, ticket.TeDate, userId, userId, DateTime.Now, 0, int.Parse(SequenceNumber), ref Treasury_No);
}
if (Treasury_No.Value > 0)
{
if (Convert.ToInt32(SequenceNumber) > 0)
{
result = linqDB.UpdateFinalStatusTicketException(Convert.ToInt32(SequenceNumber));
}
jpinfo.processSuccessful = true;
}
if (Treasury_No.Value <= 0)
{
jpinfo.errCode = -1;
}
//LogManager.WriteLog("Clear Handpay/Jackpot Lock InstallatioNo:[" + iInstallationNumber.ToString() + "Manual:" + IsManualAttendantPay.ToString () + " ]", LogManager.enumLogLevel.Debug);
////Clear the lock in the slot
//if (IsManualAttendantPay == 0)
//{
// Clearhandpay(iInstallationNumber);
//}
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
jpinfo.errCode = -1;
}
return(jpinfo);
}
public int GetInstallationNo(string SequenceNumber, int SiteId, out int InstallationNo)
{
LinqDataAccessDataContext linqDB = new LinqDataAccessDataContext(CommonDataAccess.ExchangeConnectionString);
InstallationNo = 0;
try
{
ISingleResult <HandpayEntities> lstHpDetails = linqDB.GetHpDetails(int.Parse(SequenceNumber));
foreach (HandpayEntities ticket in lstHpDetails)
{
InstallationNo = int.Parse(ticket.installation_no.ToString());
return(ticket.IsManualAttendantPay);
}
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
}
return(0);
}
public List <BarPositions> getBarPositions()
{
LinqDataAccessDataContext context = new LinqDataAccessDataContext(CommonDataAccess.ExchangeConnectionString);
return(context.GetBarPositions().ToList <BarPositions>());
}
