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>()); }