public PC_ServerTrackingResult Get_PCMessages_SendToComms(int maxRows, ref int?noOfRowsToProcess)
{
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
return(DataContext.rsp_Get_PC_ServerTracking(maxRows, ref noOfRowsToProcess).FirstOrDefault());
}
}
catch (Exception ex)
{
Log.Exception(ex);
return(new PC_ServerTrackingResult());
}
}
public List <CMPErrorCodes> GetCMPErrorCodes()
{
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
return(DataContext.rsp_GetCMPErrorCode().ToList());
}
}
catch (Exception ex)
{
Log.Exception(ex);
return(new List <CMPErrorCodes>());
}
}
public rsp_GetSiteDetailsResult GetSiteDetails()
{
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
return(DataContext.rsp_GetSiteDetails().FirstOrDefault());
}
}
catch (Exception ex)
{
Log.Exception(ex);
return(null);
}
}
public MeterDeltaForPCSessionResult GetMeterDeltaForPCSession(int installationNo, string pCcardNo, string sessionType)
{
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
return(DataContext.rsp_GetMeterDeltaForPCSession(installationNo, pCcardNo, sessionType).FirstOrDefault());
}
}
catch (Exception ex)
{
Log.Exception(ex);
return(new MeterDeltaForPCSessionResult());
}
}
public int StartGameCapSession(int installationNo, string slot, string stand, string reservedCardNo, string reservedForCardNo)
{
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
return(DataContext.StartGameCappingSession(installationNo, slot, stand, reservedCardNo, reservedForCardNo));
}
}
catch (Exception ex)
{
Log.Exception(ex);
return(-1);
}
}
public GameCapInformation GetGameCappingInformation(int installationNo, string cardNo, bool isGameUnCapping)
{
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
return(DataContext.GetGameCappingInformation(installationNo, cardNo, isGameUnCapping).FirstOrDefault());
}
}
catch (Exception ex)
{
Log.Exception(ex);
return(null);
}
}
public InstallationDetailsForComms GetInstallationDetailsForComms(int?installationNo)
{
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
return(DataContext.GetInstallationDetailsForComms(installationNo).FirstOrDefault());
}
}
catch (Exception ex)
{
Log.Exception(ex);
return(null);
}
}
public bool IsCardSessionExists(int installationNo, int cardNo)
{
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
var result = DataContext.IsCardSessionExists(installationNo, cardNo).FirstOrDefault();
return(result != null);
}
}
catch (Exception ex)
{
Log.Exception(ex);
return(false);
}
}
public bool UpdateDisplayMessageForEFT(int installationNo, string cardNo, Guid requestID, string displayMessage)
{
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
DataContext.usp_UpdatePlayerGatewayMessages(installationNo, cardNo, requestID, displayMessage);
return(true);
}
}
catch (Exception ex)
{
Log.Exception(ex);
return(false);
}
}
public bool InsertAFTTransactions(int instalaltionNo, int playerID, int collectionNo, double cashableAmt, double noncashableAmt, double wATAmt, DateTime transactionDate, string transactionType, int transferID, string accountType, bool transactionStatus)
{
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
DataContext.esp_InsertAFTTransactions(instalaltionNo, playerID, collectionNo, cashableAmt, noncashableAmt, wATAmt, transactionDate, transactionType, transferID, accountType, transactionStatus);
return(true);
}
}
catch (Exception ex)
{
Log.Exception(ex);
return(false);
}
}
public bool AuditAFTTransactions(int installationNo, DateTime transactionDate, string transactionType, double cashableAmt, double nonCashableAmt, double watAmt, int playerID, bool ecashEnabled, int errorCode, string errorMsg, int transferID)
{
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
DataContext.esp_AuditAFTTransactions(installationNo, transactionDate, transactionType, cashableAmt, nonCashableAmt, watAmt, playerID, ecashEnabled, errorCode, errorMsg, transferID);
return(true);
}
}
catch (Exception ex)
{
Log.Exception(ex);
return(false);
}
}
public bool ResetCompVerificationRequestStatus(int installationNo, string type)
{
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
DataContext.ResetCompVerificationRequestStatus(installationNo, type);
return(true);
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
return(false);
}
}
public void UpdateInstallationGameInfo(int installation_No, int game_Number, int max_Bet, int prog_Group, int prog_Level, string game_Name, string paytables, bool isInstall, int isFramed, string game_Payout)
{
using (ModuleProc PROC = new ModuleProc(this.DYN_MODULE_NAME, "UpdateInstallationGameInfo"))
{
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
DataContext.usp_UpdateInstallationGameInfo(installation_No, game_Number, max_Bet, prog_Group, prog_Level, game_Name, paytables, isInstall, isFramed, game_Payout);
}
}
catch (Exception ex)
{
Log.Exception(ex);
}
}
}
public void UpdateBaseDenomAndGamesCount(int installation_No, int denom, int games_Count, int maxBet, string percentagePayout)
{
using (ModuleProc PROC = new ModuleProc(this.DYN_MODULE_NAME, "UpdateBaseDenomAndGamesCount"))
{
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
DataContext.usp_UpdateBaseDenomAndGamesCount(installation_No, denom, games_Count, maxBet, percentagePayout);
}
}
catch (Exception ex)
{
Log.Exception(ex);
}
}
}
public void UpdateGamesCount(int installation_No, int games_Count)
{
using (ModuleProc PROC = new ModuleProc(this.DYN_MODULE_NAME, "UpdateGamesCount"))
{
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
DataContext.usp_UpdateGamesCount(installation_No, games_Count);
}
}
catch (Exception ex)
{
Log.Exception(ex);
}
}
}
public void CheckToIncludeGameDetails(int installationNo, ref int?gameDetails)
{
using (ModuleProc PROC = new ModuleProc(this.DYN_MODULE_NAME, "CheckToIncludeGameDetails"))
{
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
DataContext.rsp_CheckToIncludeGameDetails(installationNo, ref gameDetails);
}
}
catch (Exception ex)
{
Log.Exception(ex);
}
}
}
public void UpdateInPlayStatus(int gMUNumber, string current_Credit, ref int?errorCode)
{
using (ModuleProc PROC = new ModuleProc(this.DYN_MODULE_NAME, "UpdateInPlayStatus"))
{
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
DataContext.usp_UpdateInPlayStatus(gMUNumber, current_Credit, ref errorCode);
}
}
catch (Exception ex)
{
Log.Exception(ex);
}
}
}
public void CopySNAPMeterHistoryTo(int installation_No, string process, string type)
{
using (ModuleProc PROC = new ModuleProc(this.DYN_MODULE_NAME, "CopySNAPMeterHistoryTo"))
{
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
DataContext.usp_Copy_MH_Snap_To(process, type, installation_No);
}
}
catch (Exception ex)
{
Log.Exception(ex);
}
}
}
public void DeleteGMULoginEntry(int installation_No)
{
using (ModuleProc PROC = new ModuleProc(this.DYN_MODULE_NAME, "DeleteGMULoginEntry"))
{
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
DataContext.usp_RemoveGMULogin(installation_No);
}
}
catch (Exception ex)
{
Log.Exception(ex);
}
}
}
public void UpdateReEnrollMachineStatus(int installation_No, byte status)
{
using (ModuleProc PROC = new ModuleProc(this.DYN_MODULE_NAME, "UpdateReEnrollMachineStatus"))
{
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
DataContext.usp_UpdateReEnrollStatus(installation_No, status);
}
}
catch (Exception ex)
{
Log.Exception(ex);
}
}
}
public int GetInstallationNoByBarPosition(string bar_Position_Name)
{
int?installationNo = null;
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
DataContext.rsp_GetInstallationNoByBarPosition(bar_Position_Name, ref installationNo);
}
}
catch (Exception ex)
{
Log.Exception(ex);
}
return(installationNo.GetValueOrDefault());
}
public string GetLocalSiteCode()
{
string siteCode = string.Empty;
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
DataContext.rsp_GetSiteCode(ref siteCode);
}
}
catch (Exception ex)
{
Log.Exception(ex);
}
return(siteCode);
}
public void GetSASVersionFromGMULogin(int installationNo, ref string gmuVersion)
{
using (ModuleProc PROC = new ModuleProc(this.DYN_MODULE_NAME, "GetSASVersionFromGMULogin"))
{
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
DataContext.rsp_GetSASVersionFromGMULogin(installationNo, ref gmuVersion);
}
}
catch (Exception ex)
{
Log.Exception(ex);
}
}
}
public List <InstallationDetailsForMSMQ> GetInstallationDetailsByDatapak()
{
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
List <InstallationDetailsForMSMQ> retInstallationDetailsForMSMQ = null;
retInstallationDetailsForMSMQ = DataContext.rsp_GetInstallationDetailsForMSMQ(0, false).ToList();
return(retInstallationDetailsForMSMQ);
}
}
catch (Exception ex)
{
Log.Exception(ex);
return(null);
}
}
public bool UpdateTicketExceptionResponseMeters(int installation_No, int handpay, int jackpot, int ticketOut)
{
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
if (DataContext.usp_UpdateTicketExceptionResponseMeters(installation_No, handpay, jackpot, ticketOut) == 0)
{
return(true);
}
}
}
catch (Exception ex)
{
Log.Exception(ex);
}
return(false);
}
public bool GetTicketExpire(ref int?exprDays)
{
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
if (DataContext.rsp_GetTicketExpire(ref exprDays) > -1)
{
return(true);
}
}
}
catch (Exception ex)
{
Log.Exception(ex);
}
return(false);
}
public EPIDetailsResult GetEPIDetails(int installationNo)
{
EPIDetailsResult epiDetailsResult = null;
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
epiDetailsResult = DataContext.GetEPIDetails(installationNo).FirstOrDefault();
}
return(epiDetailsResult);
}
catch (Exception ex)
{
Log.Exception(ex);
return(new EPIDetailsResult());
}
}
public bool InsertPCMessage(string cardNo, string slot, string stand, int?handlepulls, string ratingInterval, string displayMessage, char?lockType, string ackType, int breakPeriodInterval, bool pcEnrolled)
{
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
if (DataContext.usp_InsertPCNotificationResponse(cardNo, slot, stand, handlepulls, ratingInterval, displayMessage, lockType, ackType, breakPeriodInterval, pcEnrolled) > -1)
{
return(true);
}
}
}
catch (Exception ex)
{
Log.Exception(ex);
}
return(false);
}
public bool InsertPCCardResponse(string cardNo, string messageType, string messageCode, string slotNo, string stand, string message, DateTime recvDate, int handlePulls, string ratingInterval, string breakPeriod, bool pcEnrolled)
{
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
if (DataContext.esp_InsertPCCardResponse(cardNo, messageType, messageCode, slotNo, stand, message, recvDate, handlePulls, ratingInterval, breakPeriod, pcEnrolled) > -1)
{
return(true);
}
}
}
catch (Exception ex)
{
Log.Exception(ex);
}
return(false);
}
public bool UpdateSentMonitorMessagestatus(int id, bool status)
{
try
{
using (ExCommsSQLDataAccess DataContext = this.GetDataContext())
{
if (DataContext.usp_UpdateSentFreeFormToCommsStatus(id, status) > -1)
{
return(true);
}
}
}
catch (Exception ex)
{
Log.Exception(ex);
}
return(false);
}