public void DBExecuteRedemptionOption(string mobile, int offerID, int optionReferenceID) { try { OfferID = offerID; OptionReferenceID = optionReferenceID; string CMSPlayerID = ServerSide.DBGetCMSPlayerID(mobile); DataSet result = new DataSet(); List <SqlParameter> spParams = new List <SqlParameter>(); spParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); spParams.Add(new SqlParameter("@OfferID", OfferID)); spParams.Add(new SqlParameter("@OptionReferenceID", OptionReferenceID)); result = DataAcess.ExecuteQuerySP("PEC.TODO", spParams); if (result.Tables[0].Rows.Count > 0) { RedemptionExecutionSucess = true; HeaderCaptionLine1 = result.Tables[0].Rows[0][""].ToString(); BodyCaptionLine1 = result.Tables[0].Rows[0][""].ToString(); HeaderCaptionLine2 = result.Tables[0].Rows[0][""].ToString(); BodyCaptionLine2 = result.Tables[0].Rows[0][""].ToString(); FooterCaptionLine1 = result.Tables[0].Rows[0][""].ToString(); FooterCaptionLine2 = result.Tables[0].Rows[0][""].ToString(); MemoryStream ms = new MemoryStream((byte[])result.Tables[0].Rows[0][""]); byte[] bytes = ms.ToArray(); if (bytes != null) { BodyImage1 = bytes; } else { BodyImage1 = null; } MemoryStream bodyImage2MS = new MemoryStream((byte[])result.Tables[0].Rows[0][""]); byte[] bodyImage2Bytes = bodyImage2MS.ToArray(); if (bodyImage2Bytes != null) { BodyImage2 = bodyImage2Bytes; } else { BodyImage2 = null; } BodyImage2 = bodyImage2Bytes; } else { RemoveData(); RedemptionExecutionSucess = false; } } catch (SqlException ex) { string errorMessage = ex.Message; RemoveData(); } }
public void DBGetStoredPin(string mobile, string pinCode) { try { DataSet result = new DataSet(); List <SqlParameter> spParams = new List <SqlParameter>(); spParams.Add(new SqlParameter("@Mobile", mobile)); spParams.Add(new SqlParameter("@PIN", pinCode)); result = DataAcess.ExecuteQuerySP("PEC.TODO", spParams); if (result.Tables[0].Rows.Count > 0) { isRegistered = true; isLocked = false; } else { //Increment some form of counter for login attempts int loginAttempts = 0; if (loginAttempts > 3) { isLocked = true; isRegistered = false; } else { isLocked = false; isRegistered = false; } } } catch (SqlException ex) { string errorMessage = ex.Message; } }
public void DBEnterRemoteEntry(string mobile, int promotionID) { PromotionID = promotionID; try { string CMSPlayerID = ServerSide.DBGetCMSPlayerID(mobile); DataSet result = new DataSet(); List <SqlParameter> spParams = new List <SqlParameter>(); spParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); spParams.Add(new SqlParameter("@PromotionID", promotionID)); result = DataAcess.ExecuteQuerySP("PEC.TODO", spParams); if (result.Tables[0].Rows.Count > 0) { UpdateEntryCount = Convert.ToInt32(result.Tables[0].Rows[0]["UpdateEntryCount"].ToString()); RemoteEntryAvaliable = Convert.ToBoolean(result.Tables[0].Rows[0]["RemoteEntryAvaliable"].ToString()); } else { RemoveData(); } } catch (SqlException ex) { string errorMessage = ex.Message; RemoveData(); } }
//Convert parameters into object, save to database, and return object public void DBSaveWinInfo(string mobile, int gameID, string gameToken, string objectsSelected) { try { string CMSPlayerID = ServerSide.DBGetCMSPlayerID(mobile); DataSet result = new DataSet(); List <SqlParameter> spParams = new List <SqlParameter>(); spParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); spParams.Add(new SqlParameter("@GameID", gameID)); spParams.Add(new SqlParameter("@GameToken", gameToken)); spParams.Add(new SqlParameter("@ObjectsSelected", objectsSelected)); result = DataAcess.ExecuteQuerySP("PEC.TODO", spParams); if (result.Tables[0].Rows.Count > 0) { GameNameForDisplay = result.Tables[0].Rows[0]["GameName"].ToString(); ClosingCaption = result.Tables[0].Rows[0]["ClosingCaption"].ToString(); PrizePickUpDescription = result.Tables[0].Rows[0]["PrizePickupDescription"].ToString(); CallToActionCaption = result.Tables[0].Rows[0]["CallToActionCaption"].ToString(); CallToActionText = result.Tables[0].Rows[0]["CallToActionText"].ToString(); CallToActionIsScrolling = Convert.ToBoolean(result.Tables[0].Rows[0]["CallToActionScrolling"].ToString()); } else { throw new Exception("DBSaveWinInfo Failed"); } } catch (SqlException ex) { string errorMessage = ex.Message; RemoveData(); } }
public void DBEnrollGuestInEvent(string mobile, int eventID, int optionReferenceID) { try { EventID = eventID; OptionReferenceID = optionReferenceID; string CMSPlayerID = ServerSide.DBGetCMSPlayerID(mobile); DataSet result = new DataSet(); List <SqlParameter> spParams = new List <SqlParameter>(); spParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); spParams.Add(new SqlParameter("@EventID", eventID)); result = DataAcess.ExecuteQuerySP("PEC.TODO", spParams); HeaderCaptionLine1 = result.Tables[0].Rows[0]["HeaderCaptionLine1"].ToString(); HeaderCaptionLine2 = result.Tables[0].Rows[0][""].ToString(); IsEnrolled = Convert.ToBoolean(result.Tables[0].Rows[0][""].ToString()); ConfirmationNumber = result.Tables[0].Rows[0][""].ToString(); MemoryStream bodyImage1MS = new MemoryStream((byte[])result.Tables[0].Rows[0][""]); byte[] bodyImage1Byte = bodyImage1MS.ToArray(); BodyImage1 = bodyImage1Byte; MemoryStream bodyImage2MS = new MemoryStream((byte[])result.Tables[0].Rows[0][""]); byte[] bodyImage2Byte = bodyImage2MS.ToArray(); BodyImage2 = bodyImage2Byte; FooterCaptionLine1 = result.Tables[0].Rows[0][""].ToString(); FooterCaptionLine2 = result.Tables[0].Rows[0][""].ToString(); } catch (SqlException ex) { string errorMessage = ex.Message; RemoveData(); } }
public void DBStartGame(string mobile, int gameID, long PromotionID) { try { string CMSPlayerID = ServerSide.DBGetCMSPlayerID(mobile); StartGameReturn data = new StartGameReturn(); DataSet result = new DataSet(); List <SqlParameter> spParams = new List <SqlParameter>(); spParams.Add(new SqlParameter("@GameID", gameID)); spParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); spParams.Add(new SqlParameter("@PromotionID", PromotionID)); result = DataAcess.ExecuteQuerySP("PEC.MG_PROMOTION_StartGame", spParams); if (result.Tables[0].Rows.Count > 0) { GameToken = result.Tables[0].Rows[0]["GameToken"].ToString(); StartGameCaption = result.Tables[0].Rows[0]["StartGameCaption"].ToString(); StartGameText = result.Tables[0].Rows[0]["StartGameText"].ToString(); } else { RemoveData(); } } catch (SqlException ex) { string errorMessage = ex.Message; RemoveData(); } }
public void DBGetAccountBalancesSet(string mobile) { try { string CMSPlayerID = ServerSide.DBGetCMSPlayerID(mobile); DataSet result = new DataSet(); List <SqlParameter> spParams = new List <SqlParameter>(); spParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); result = DataAcess.ExecuteQuerySP("PEC.TODO", spParams); if (result.Tables[0].Rows.Count > 0) { for (int i = 0; i < result.Tables[0].Rows.Count; i++) { Account newAccount = new Account(); newAccount.accountName = result.Tables[0].Rows[i][""].ToString(); newAccount.accountBalance = result.Tables[0].Rows[i][""].ToString(); AccountBalances.Add(newAccount); } } else { AccountBalances = null; } } catch (SqlException ex) { string errorMessage = ex.Message; } }
public void DBGetStoredPin(string mobile, string pinCode) { try { DataSet result = new DataSet(); List <SqlParameter> spParams = new List <SqlParameter>(); spParams.Add(new SqlParameter("@Mobile", mobile)); spParams.Add(new SqlParameter("@PIN", pinCode)); result = DataAcess.ExecuteQuerySP("PEC.TODO", spParams); if (result.Tables[0].Rows.Count > 0) { isValid = true; GenerateOneWayHash(mobile); } else { isValid = false; userToken = ""; } } catch (SqlException ex) { string errorMessage = ex.Message; } }
public void DBGetLogo(string mobile) { try { string CMSPlayerID = ServerSide.DBGetCMSPlayerID(mobile); DataSet result = new DataSet(); List <SqlParameter> spParams = new List <SqlParameter>(); spParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); result = DataAcess.ExecuteQuerySP("PEC.TODO", spParams); if (result.Tables[0].Rows.Count > 0) { MemoryStream ms = new MemoryStream((byte[])result.Tables[0].Rows[0][""]); byte[] bytes = ms.ToArray(); logo = bytes; } else { logo = null; } } catch (SqlException ex) { string errorMessage = ex.Message; logo = null; } }
public void DBGetEventsScreenWrapper(string mobile) { try { string CMSPlayerID = ServerSide.DBGetCMSPlayerID(mobile); DataSet result = new DataSet(); List <SqlParameter> spParams = new List <SqlParameter>(); spParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); result = DataAcess.ExecuteQuerySP("PEC.TODO", spParams); if (result.Tables[0].Rows.Count > 0) { Line1Caption = result.Tables[0].Rows[0][""].ToString(); Line1Data = result.Tables[0].Rows[0][""].ToString(); Line2Caption = result.Tables[0].Rows[0][""].ToString(); Line2Data = result.Tables[0].Rows[0][""].ToString(); DataSet buttonDS = new DataSet(); List <SqlParameter> buttonParams = new List <SqlParameter>(); buttonParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); buttonDS = DataAcess.ExecuteQuerySP("PEC.TODO", buttonParams); if (buttonDS.Tables[0].Rows.Count > 0) { for (int i = 0; i < buttonDS.Tables[0].Rows.Count; i++) { EventButton newButton = new EventButton(); newButton.ButtonCaption = result.Tables[0].Rows[i][""].ToString(); newButton.ButtonOrdPos = Convert.ToInt32(result.Tables[0].Rows[i][""].ToString()); newButton.ButtonEventID = Convert.ToInt32(result.Tables[0].Rows[i][""].ToString()); MemoryStream ButtonMS = new MemoryStream((byte[])result.Tables[0].Rows[i][""]); byte[] ButtonBytes = ButtonMS.ToArray(); newButton.ButtonImage = ButtonBytes; Buttons.Add(newButton); } } else { Buttons = null; } } else { RemoveData(); } } catch (SqlException ex) { string errorMessage = ex.Message; RemoveData(); } }
//DB Get Promotions Screen Wrapper from SQL Server public void DBGetPromotionsScreenWrapperReturn(string mobile) { try { string CMSPlayerID = ServerSide.DBGetCMSPlayerID(mobile); DataSet result = new DataSet(); List <SqlParameter> spParams = new List <SqlParameter>(); spParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); result = DataAcess.ExecuteQuerySP("PEC.PROMOTIONS_GetWrapper", spParams); if (result.Tables[0].Rows.Count > 0) { Line1Caption = result.Tables[0].Rows[0]["Line1Caption"].ToString(); Line1Data = result.Tables[0].Rows[0]["Line1Data"].ToString(); Line2Caption = result.Tables[0].Rows[0]["Line2Caption"].ToString(); Line2Data = result.Tables[0].Rows[0]["Line2Data"].ToString(); DataSet buttonDS = new DataSet(); List <SqlParameter> buttonParams = new List <SqlParameter>(); buttonParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); buttonDS = DataAcess.ExecuteQuerySP("PEC.PROMOTIONS_WrapperButtons", buttonParams); if (buttonDS.Tables[0].Rows.Count > 0) { for (int i = 0; i < buttonDS.Tables[0].Rows.Count; i++) { PromoButton newButton = new PromoButton(); newButton.ButtonCaption = buttonDS.Tables[0].Rows[i]["ButtonCaption"].ToString(); newButton.ButtonOrdPos = Convert.ToInt32(buttonDS.Tables[0].Rows[i]["ButtonOrdPos"].ToString()); Buttons.Add(newButton); } } else { RemoveData(); } } else { RemoveData(); } } catch (SqlException ex) { RemoveData(); string errorMessage = ex.Message; } }
public void DBListEntriesInNextDraw(string mobile, int promotionID) { try { PromotionID = promotionID; string CMSPlayerID = ServerSide.DBGetCMSPlayerID(mobile); DataSet result = new DataSet(); List <SqlParameter> spParams = new List <SqlParameter>(); spParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); spParams.Add(new SqlParameter("@PromotionID", PromotionID)); result = DataAcess.ExecuteQuerySP("PEC.TODO", spParams); if (result.Tables[0].Rows.Count > 0) { NextDrawDate = Convert.ToDateTime(result.Tables[0].Rows[0]["NextDrawDate"].ToString()); NextDrawTime = Convert.ToDateTime(result.Tables[0].Rows[0]["NextDrawTime"].ToString()); EntriesForNextDraw = Convert.ToInt32(result.Tables[0].Rows[0]["EntriesForNextDraw"].ToString()); IsDrumPopulated = Convert.ToBoolean(result.Tables[0].Rows[0]["IsPopulated"].ToString()); SpecialMessage = result.Tables[0].Rows[0]["SpecialMessage"].ToString(); if (IsDrumPopulated) { DataSet entryDS = new DataSet(); entryDS = DataAcess.ExecuteQuerySP("PEC.TODO", spParams); if (entryDS.Tables[0].Rows.Count > 0) { for (int i = 0; i < entryDS.Tables[0].Rows.Count; i++) { string entryNum = entryDS.Tables[0].Rows[i]["EntryNumber"].ToString(); EntryNumbers.Add(entryNum); } } else { EntryNumbers = null; } } else { EntryNumbers = null; } } else { RemoveData(); } } catch (SqlException ex) { string errorMessage = ex.Message; RemoveData(); } }
// TODO: Binary Data for background // LARS: What is the binary data I'm looking for here? Not sure based on API Doc public void DBGetIntervalsAndBackgrounds(string mobile, int gameID, int variantID) { string CMSPlayerID = ServerSide.DBGetCMSPlayerID(mobile); DataSet result = new DataSet(); List <SqlParameter> spParams = new List <SqlParameter>(); spParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); spParams.Add(new SqlParameter("@GameID", gameID)); spParams.Add(new SqlParameter("@VariantID", variantID)); result = DataAcess.ExecuteQuerySP("MG_PROMOTION_BACKGROUND_GetByGameID", spParams); if (result.Tables[0].Rows.Count > 0) { for (int j = 0; j < result.Tables[0].Rows.Count; j++) { AttributeInfo gameAttributes = new AttributeInfo(); gameAttributes.GameName = result.Tables[0].Rows[j]["gameName"].ToString(); gameAttributes.PageName = result.Tables[0].Rows[j]["pageName"].ToString(); gameAttributes.TypeName = result.Tables[0].Rows[j]["typename"].ToString(); gameAttributes.ObjectName = result.Tables[0].Rows[j]["objectName"].ToString(); gameAttributes.AttributeName = result.Tables[0].Rows[j]["attributeName"].ToString(); gameAttributes.AttributeValue = result.Tables[0].Rows[j]["attributeValue"].ToString(); DataSet binaryData = new DataSet(); List <SqlParameter> binaryParams = new List <SqlParameter>(); binaryParams.Add(new SqlParameter("@GameID", gameID)); binaryParams.Add(new SqlParameter("@VariantID", variantID)); binaryData = DataAcess.ExecuteQuerySP("TODO", binaryParams); if (binaryData.Tables[0].Rows.Count > 0) { MemoryStream ms = new MemoryStream((byte[])binaryData.Tables[0].Rows[0]["attributeBinaryData"]); byte[] bytes = ms.ToArray(); gameAttributes.AttributeBinaryValue = bytes; } else { gameAttributes.AttributeBinaryValue = null; } Attributes.Add(gameAttributes); } } else { RemoveData(); } }
public void GenerateOneWayHash(string mobile) { try { DataSet result = new DataSet(); List <SqlParameter> spParams = new List <SqlParameter>(); spParams.Add(new SqlParameter("@Mobile", mobile)); result = DataAcess.ExecuteQuerySP("PEC.TODO", spParams); userToken = result.Tables[0].Rows[0][""].ToString(); } catch (SqlException ex) { string errorMessage = ex.Message; isValid = false; userToken = ""; } }
public void DBPurchaseTicketsToEventWithPoints(string mobile, int eventID, int optionReferenceID, int ticketCountRequested) { try { EventID = eventID; OptionReferenceID = optionReferenceID; string CMSPlayerID = ServerSide.DBGetCMSPlayerID(mobile); DataSet result = new DataSet(); List <SqlParameter> spParams = new List <SqlParameter>(); spParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); spParams.Add(new SqlParameter("@EventID", eventID)); spParams.Add(new SqlParameter("@OptionReferenceID", optionReferenceID)); spParams.Add(new SqlParameter("@TicketCountRequested", ticketCountRequested)); result = DataAcess.ExecuteQuerySP("PEC.TODO", spParams); HeaderCaptionLine1 = result.Tables[0].Rows[0]["HeaderCaptionLine1"].ToString(); HeaderCaptionLine2 = result.Tables[0].Rows[0][""].ToString(); IsPurchaseSuccessful = Convert.ToBoolean(result.Tables[0].Rows[0][""].ToString()); NewPointsBalance = float.Parse(result.Tables[0].Rows[0][""].ToString()); IsEnrolled = Convert.ToBoolean(result.Tables[0].Rows[0][""].ToString()); ConfirmationNumber = result.Tables[0].Rows[0][""].ToString(); TicketCountAwarded = Convert.ToInt32(result.Tables[0].Rows[0][""].ToString()); IsOnWaitList = Convert.ToBoolean(result.Tables[0].Rows[0][""].ToString()); ExpectedResponseInterval = result.Tables[0].Rows[0][""].ToString(); MemoryStream bodyImage1MS = new MemoryStream((byte[])result.Tables[0].Rows[0][""]); byte[] bodyImage1Byte = bodyImage1MS.ToArray(); BodyImage1 = bodyImage1Byte; MemoryStream bodyImage2MS = new MemoryStream((byte[])result.Tables[0].Rows[0][""]); byte[] bodyImage2Byte = bodyImage2MS.ToArray(); BodyImage2 = bodyImage2Byte; FooterCaptionLine1 = result.Tables[0].Rows[0][""].ToString(); FooterCaptionLine2 = result.Tables[0].Rows[0][""].ToString(); } catch (SqlException ex) { string errorMessage = ex.Message; RemoveData(); } }
// Query Database for existing mobile number. Return true if mobile number exists, false if it does not. public void checkIsRegistered(string mobile) { try { DataSet result = new DataSet(); List <SqlParameter> spParams = new List <SqlParameter>(); spParams.Add(new SqlParameter("@Mobile", mobile)); result = DataAcess.ExecuteQuerySP("PEC.TODO", spParams); if (result.Tables[0].Rows.Count > 0) { IsRegistered = true; } else { IsRegistered = false; } //Add logic for showbalancesnopin. Not specified in API doc (default to false?) ShowBalancesNoPin = false; } catch (SqlException ex) { string errorMessage = ex.Message; } }
public void DBClaimBonusCoupons(string mobile, int promotionID) { try { PromotionID = promotionID; string CMSPlayerID = ServerSide.DBGetCMSPlayerID(mobile); DataSet result = new DataSet(); List <SqlParameter> spParams = new List <SqlParameter>(); spParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); spParams.Add(new SqlParameter("@PromotionID", PromotionID)); result = DataAcess.ExecuteQuerySP("PEC.TODO", spParams); if (result.Tables[0].Rows.Count > 0) { ClaimButtonRemainsVisible = Convert.ToBoolean(result.Tables[0].Rows[0][""].ToString()); ClaimButtonRemainsActive = Convert.ToBoolean(result.Tables[0].Rows[0][""].ToString()); ClaimButtonNewCaption = result.Tables[0].Rows[0][""].ToString(); MemoryStream ms = new MemoryStream((byte[])result.Tables[0].Rows[0]["Image"]); byte[] bytes = ms.ToArray(); ClaimButtonNewImage = bytes; DataSet descDS = new DataSet(); List <SqlParameter> descParams = new List <SqlParameter>(); descParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); descParams.Add(new SqlParameter("@PromotionID", PromotionID)); descDS = DataAcess.ExecuteQuerySP("PEC.TODO", descParams); if (descDS.Tables[0].Rows.Count > 0) { for (int i = 0; i < descDS.Tables[0].Rows.Count; i++) { ResultDescriptionBonus newRDB = new ResultDescriptionBonus(); newRDB.ResultCaption = descDS.Tables[0].Rows[i][""].ToString(); newRDB.ResultUpdatedElement = descDS.Tables[0].Rows[i][""].ToString(); MemoryStream msResult = new MemoryStream((byte[])descDS.Tables[0].Rows[i]["Image"]); byte[] resultBytes = msResult.ToArray(); newRDB.ResultImage = resultBytes; DataSet dP = new DataSet(); List <SqlParameter> pointsParams = new List <SqlParameter>(); pointsParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); pointsParams.Add(new SqlParameter("@PromotionID", PromotionID)); dP = DataAcess.ExecuteQuerySP("PEC.TODO", pointsParams); if (dP.Tables[0].Rows.Count > 0) { for (int j = 0; j < dP.Tables[0].Rows.Count; j++) { DataPoint newPoint = new DataPoint(); newPoint.DataPointCaption = dP.Tables[0].Rows[i]["DataPointCaption"].ToString(); newPoint.DataPointData = dP.Tables[0].Rows[i]["DataPointData"].ToString(); newRDB.DataPoints.Add(newPoint); } } else { newRDB.DataPoints = null; } } } else { ResultDescriptions = null; } } else { RemoveData(); } } catch (SqlException ex) { string errorMessage = ex.Message; RemoveData(); } }
//SQL DB Function to get games wrapper from DB public void DBGetGamesScreenWrapper(string mobile) { try { string CMSPlayerID = ServerSide.DBGetCMSPlayerID(mobile); DataSet headerDS = new DataSet(); List <SqlParameter> headerParams = new List <SqlParameter>(); headerParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); headerDS = DataAcess.ExecuteQuerySP("PEC.", headerParams); if (headerDS.Tables[0].Rows.Count > 0) { headerCaption = headerDS.Tables[0].Rows[0]["HeaderCaption"].ToString(); headerData = headerDS.Tables[0].Rows[0]["HeaderData"].ToString(); } DataSet result = new DataSet(); List <SqlParameter> spParams = new List <SqlParameter>(); spParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); result = DataAcess.ExecuteQuerySP("PEC.PROMOTION_ID_GetByCMSPlayerID", spParams); if (result.Tables[0].Rows.Count > 0) { for (int i = 0; i < result.Tables[0].Rows.Count; i++) { PromotionID.Add(Int64.Parse(result.Tables[0].Rows[i]["PromotionID"].ToString())); } foreach (long ID in PromotionID) { //GET Game Attributes from GD_PROMOtionGames DataSet ds = new DataSet(); List <SqlParameter> gameParams = new List <SqlParameter>(); gameParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); gameParams.Add(new SqlParameter("@PromotionID", ID)); ds = DataAcess.ExecuteQuerySP("PEC.MG_PROMOTION_WRAPPER_GetByPromotionID", gameParams); DataSet imageSet = new DataSet(); if (ds.Tables[0].Rows.Count > 0) { Game newGame = new Game(); newGame.GameID = ds.Tables[0].Rows[0]["GameID"].ToString(); newGame.GameName = ds.Tables[0].Rows[0]["GameName"].ToString(); newGame.GameDescription = ds.Tables[0].Rows[0]["GameDescription"].ToString(); newGame.ButtonDescription = ds.Tables[0].Rows[0]["ButtonDesc"].ToString(); newGame.IsButtonEnabled = Convert.ToBoolean(ds.Tables[0].Rows[0]["isButtonEnabled"].ToString()); DataSet imageData = new DataSet(); List <SqlParameter> imageParam = new List <SqlParameter>(); imageParam.Add(new SqlParameter("@PromotionID", ID)); imageData = DataAcess.ExecuteQuerySP("MG_PROMOTION_WRAPPER_ReadGameIcon", imageParam); if (imageData.Tables[0].Rows.Count > 0) { MemoryStream ms = new MemoryStream((byte[])imageData.Tables[0].Rows[0]["promoKioskImage"]); byte[] bytes = ms.ToArray(); newGame.GameIcon = bytes; } else { newGame.GameIcon = null; } Games.Add(newGame); } } } } catch (SqlException ex) { RemoveData(); string errorMessage = ex.Message; } }
public void DBGetEventDetails(string mobile, int eventID) { try { EventID = eventID; string CMSPlayerID = ServerSide.DBGetCMSPlayerID(mobile); DataSet result = new DataSet(); List <SqlParameter> spParams = new List <SqlParameter>(); spParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); spParams.Add(new SqlParameter("@EventID", eventID)); result = DataAcess.ExecuteQuerySP("PEC.TODO", spParams); if (result.Tables[0].Rows.Count > 0) { HeaderCaptionLine1 = result.Tables[0].Rows[0][""].ToString(); HeaderCaptionLine2 = result.Tables[0].Rows[0][""].ToString(); EventCaption = result.Tables[0].Rows[0][""].ToString(); EventStartDate = Convert.ToDateTime(result.Tables[0].Rows[0][""]); EventStartTime = Convert.ToDateTime(result.Tables[0].Rows[0][""]); EventEndDate = Convert.ToDateTime(result.Tables[0].Rows[0][""]); EventEndTime = Convert.ToDateTime(result.Tables[0].Rows[0][""]); DisplayOptions = Convert.ToBoolean(result.Tables[0].Rows[0][""]); FooterCaptionLine1 = result.Tables[0].Rows[0][""].ToString(); FooterCaptionLine2 = result.Tables[0].Rows[0][""].ToString(); MemoryStream ms = new MemoryStream((byte[])result.Tables[0].Rows[0]["LargeImage"]); byte[] largeImage = ms.ToArray(); EventLargeImage = largeImage; if (DisplayOptions) { DataSet optionDS = new DataSet(); List <SqlParameter> optionParams = new List <SqlParameter>(); optionParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); optionParams.Add(new SqlParameter("@EventID", EventID)); optionDS = DataAcess.ExecuteQuerySP("PEC.TODO", optionParams); if (optionDS.Tables[0].Rows.Count > 0) { for (int i = 0; i < optionDS.Tables[0].Rows.Count; i++) { EventOption newEvent = new EventOption(); newEvent.OptionCaption = optionDS.Tables[0].Rows[i]["OptionCaption"].ToString(); newEvent.OptionExecutable = Convert.ToBoolean(optionDS.Tables[0].Rows[i]["OptionExecutable"].ToString()); MemoryStream optionMS = new MemoryStream((byte[])optionDS.Tables[0].Rows[i]["OptionImage"]); byte[] optionImageByte = optionMS.ToArray(); newEvent.OptionImage = optionImageByte; newEvent.OptionReferenceID = Convert.ToInt32(optionDS.Tables[0].Rows[i]["ReferenceID"].ToString()); EventOptions.Add(newEvent); } } else { EventOptions = null; } } else { EventOptions = null; } } else { RemoveData(); } } catch (SqlException ex) { string errorMessage = ex.Message; RemoveData(); } }
// TODO: ADD binary data SP // LARS: Where do I find the binary data for page attributes? Not clear from API DOC public void DBGetPageAttributes(string mobile, string inPageName, int gameID) { try { string CMSPlayerID = ServerSide.DBGetCMSPlayerID(mobile); DataSet result = new DataSet(); List <SqlParameter> spParams = new List <SqlParameter>(); spParams.Add(new SqlParameter("@GameID", gameID)); result = DataAcess.ExecuteQuerySP("PEC.MG_PROMOTION_GetGameNameANDCaption_ByGameID", spParams); if (result.Tables[0].Rows.Count > 0) { GameName = result.Tables[0].Rows[0]["GameName"].ToString(); PageName = inPageName; Caption = result.Tables[0].Rows[0]["Caption"].ToString(); DataSet aR = new DataSet(); List <SqlParameter> attParams = new List <SqlParameter>(); attParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); attParams.Add(new SqlParameter("@GameID", gameID)); attParams.Add(new SqlParameter("@PageName", PageName)); aR = DataAcess.ExecuteQuerySP("PEC.MG_PROMOTION_GetPageAttributes", attParams); if (aR.Tables[0].Rows.Count > 0) { for (int j = 0; j < aR.Tables[0].Rows.Count; j++) { Attributes pageAttributes = new Attributes(); pageAttributes.TypeName = aR.Tables[0].Rows[j]["TypeName"].ToString(); pageAttributes.ObjectName = aR.Tables[0].Rows[j]["ObjectName"].ToString(); pageAttributes.AttributeName = aR.Tables[0].Rows[j]["AttributeName"].ToString(); pageAttributes.AttributeValue = aR.Tables[0].Rows[j]["AttributeValue"].ToString(); DataSet binaryData = new DataSet(); List <SqlParameter> binaryParams = new List <SqlParameter>(); binaryParams.Add(new SqlParameter("@GameID", gameID)); binaryParams.Add(new SqlParameter("@PageName", PageName)); binaryData = DataAcess.ExecuteQuerySP("TODO", binaryParams); if (binaryData.Tables[0].Rows.Count > 0) { MemoryStream ms = new MemoryStream((byte[])binaryData.Tables[0].Rows[0]["attributeBinaryData"]); byte[] bytes = ms.ToArray(); pageAttributes.AttributeValueBinary = bytes; } else { pageAttributes.AttributeValueBinary = null; } listAttributes.Add(pageAttributes); } } //ELSE: There are no attributes for a given pageNumber else { RemoveData(); } } else { RemoveData(); } } catch (SqlException ex) { string errorMessage = ex.Message; RemoveData(); } }
public static DateTime GetTime() { DataTable dt = DataAcess.ExecuteQuerySP("DRAW_GET_TIMEATSERVER", null).Tables[0]; return(DateTime.Parse(dt.Rows[0][0].ToString())); }
public void DBGetGameInfoForPromotion(string mobile, int gameID, string gameToken) { try { string CMSPlayerID = ServerSide.DBGetCMSPlayerID(mobile); DataSet result = new DataSet(); List <SqlParameter> spParams = new List <SqlParameter>(); spParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); spParams.Add(new SqlParameter("@GameID", gameID)); spParams.Add(new SqlParameter("@GameToken", gameToken)); result = DataAcess.ExecuteQuerySP("PEC.MG_", spParams); if (result.Tables[0].Rows.Count > 0) { variantID = Convert.ToInt32(result.Tables[0].Rows[0]["VariantID"].ToString()); gameNameForDisplay = result.Tables[0].Rows[0]["GameName"].ToString(); playInstructions = result.Tables[0].Rows[0]["PlayInstructions"].ToString(); gameType = result.Tables[0].Rows[0]["GameType"].ToString(); DataSet gameDS = new DataSet(); List <SqlParameter> gParams = new List <SqlParameter>(); gParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); gParams.Add(new SqlParameter("@GameID", gameID)); gParams.Add(new SqlParameter("@VariantID", variantID)); gameDS = DataAcess.ExecuteQuerySP("PEC.MG_PROMOTIONS_GetGameObjects", gParams); for (int i = 0; i < gameDS.Tables[0].Rows.Count; i++) { GameObject newObject = new GameObject(); newObject.ObjectName = gameDS.Tables[0].Rows[i]["ObjectName"].ToString(); newObject.ObjectID = Convert.ToInt32(gameDS.Tables[0].Rows[i]["ObjectID"].ToString()); newObject.GOAttributeName = gameDS.Tables[0].Rows[i]["AttributeName"].ToString(); newObject.GOAttributeValue = gameDS.Tables[0].Rows[i]["AttributeValue"].ToString(); DataSet imageData = new DataSet(); List <SqlParameter> imageParam = new List <SqlParameter>(); imageParam.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); imageParam.Add(new SqlParameter("@GameID", gameID)); imageParam.Add(new SqlParameter("@VariantID", variantID)); imageData = DataAcess.ExecuteQuerySP("MG_PROMOTION_GameObjectGetImage", imageParam); if (imageData.Tables[0].Rows.Count > 0) { MemoryStream ms = new MemoryStream((byte[])imageData.Tables[0].Rows[0]["GameObjectAttributeBinary"]); byte[] bytes = ms.ToArray(); newObject.GOAttributeValueBinary = bytes; } else { newObject.GOAttributeValueBinary = null; } GameObjects.Add(newObject); } } else { throw new Exception("No data"); } } catch (Exception) { RemoveData(); } }
public void DBGetOfferDetails(string mobile, int offerID) { try { OfferID = offerID; string CMSPlayerID = ServerSide.DBGetCMSPlayerID(mobile); DataSet result = new DataSet(); List <SqlParameter> spParams = new List <SqlParameter>(); spParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); spParams.Add(new SqlParameter("@OfferID", OfferID)); result = DataAcess.ExecuteQuerySP("PEC.TODO", spParams); if (result.Tables[0].Rows.Count > 0) { HeaderCaptionLine1 = result.Tables[0].Rows[0][""].ToString(); HeaderCaptionLine2 = result.Tables[0].Rows[0][""].ToString(); OfferCaption = result.Tables[0].Rows[0][""].ToString(); FooterCaptionLine1 = result.Tables[0].Rows[0][""].ToString(); FooterCaptionLine2 = result.Tables[0].Rows[0][""].ToString(); OfferID = Convert.ToInt32(result.Tables[0].Rows[0][""].ToString()); DisplayOptions = Convert.ToBoolean(result.Tables[0].Rows[0][""].ToString()); MemoryStream ms = new MemoryStream((byte[])result.Tables[0].Rows[0][""]); byte[] bytes = ms.ToArray(); OfferLargeImage = bytes; MemoryStream barcodeMS = new MemoryStream((byte[])result.Tables[0].Rows[0][""]); byte[] barcodeBytes = barcodeMS.ToArray(); OfferBarcode = barcodeBytes; if (DisplayOptions) { DataSet optionDS = new DataSet(); List <SqlParameter> optionParams = new List <SqlParameter>(); optionParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); optionParams.Add(new SqlParameter("@OfferID", OfferID)); optionDS = DataAcess.ExecuteQuerySP("PEC.TODO", optionParams); if (optionDS.Tables[0].Rows.Count > 0) { for (int i = 0; i < optionDS.Tables[0].Rows.Count; i++) { Option newOption = new Option(); newOption.OptionCaption = result.Tables[0].Rows[i][""].ToString(); MemoryStream optionMS = new MemoryStream((byte[])result.Tables[0].Rows[i][""]); byte[] optionBytes = optionMS.ToArray(); newOption.OptionImage = optionBytes; newOption.OptionExecutable = Convert.ToBoolean(result.Tables[0].Rows[i][""].ToString()); newOption.OptionReferenceID = Convert.ToInt32(result.Tables[0].Rows[i][""].ToString()); OfferOptions.Add(newOption); } } else { OfferOptions = null; } } else { OfferOptions = null; } } else { RemoveData(); } } catch (SqlException ex) { string errorMessage = ex.Message; RemoveData(); } }
//SQL DB Retrieval Function: public void DBViewOfferRedemptionHistoryReturn(string mobile) { try { string CMSPlayerID = ServerSide.DBGetCMSPlayerID(mobile); DataSet result = new DataSet(); List <SqlParameter> spParams = new List <SqlParameter>(); spParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); result = DataAcess.ExecuteQuerySP("PEC.TODO", spParams); if (result.Tables[0].Rows.Count > 0) { HeaderCaptionLine1 = result.Tables[0].Rows[0]["HeaderCaption"].ToString(); HeaderCaptionLine2 = result.Tables[0].Rows[0]["HeaderCaptionLine2"].ToString(); OfferHistoryExists = Convert.ToBoolean(result.Tables[0].Rows[0]["OfferHistoryExists"].ToString()); FooterCaptionLine1 = result.Tables[0].Rows[0]["HeaderCaption"].ToString(); FooterCaptionLine2 = result.Tables[0].Rows[0]["HeaderCaption"].ToString(); if (OfferHistoryExists) { DataSet oHDS = new DataSet(); List <SqlParameter> offerHistoryParams = new List <SqlParameter>(); offerHistoryParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); oHDS = DataAcess.ExecuteQuerySP("PEC.TODO", offerHistoryParams); for (int i = 0; i < oHDS.Tables[0].Rows.Count; i++) { Offer newOffer = new Offer(); newOffer.Description = oHDS.Tables[0].Rows[i][""].ToString(); newOffer.Value = oHDS.Tables[0].Rows[i][""].ToString(); newOffer.ExpiresDate = Convert.ToDateTime(oHDS.Tables[0].Rows[i][""].ToString()); newOffer.IssuedDate = Convert.ToDateTime(oHDS.Tables[0].Rows[i][""].ToString()); newOffer.PrizeType = oHDS.Tables[0].Rows[i][""].ToString(); newOffer.IsExpired = Convert.ToBoolean(oHDS.Tables[0].Rows[i][""].ToString()); newOffer.IsRedeemed = Convert.ToBoolean(oHDS.Tables[0].Rows[i][""].ToString()); newOffer.HasBarcode = Convert.ToBoolean(oHDS.Tables[0].Rows[i][""].ToString()); if (newOffer.HasBarcode) { MemoryStream ms = new MemoryStream((byte[])oHDS.Tables[0].Rows[i][""]); byte[] bytes = ms.ToArray(); newOffer.Barcode = bytes; } else { newOffer.Barcode = null; } OfferHistory.Add(newOffer); } } } else { RemoveData(); } } catch (SqlException ex) { string errorMessage = ex.Message; } }
//DB Get Promotion List public void DBGetPromotionList(string mobile) { try { string CMSPlayerID = ServerSide.DBGetCMSPlayerID(mobile); DataSet ds = new DataSet(); List <SqlParameter> spParams = new List <SqlParameter>(); spParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); ds = DataAcess.ExecuteQuerySP("PEC.PROMOTIONS_GetPromotionList_ByCMSPlayerID", spParams); if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Promotion newPromo = new Promotion(); newPromo.PromotionID = Convert.ToInt32(ds.Tables[0].Rows[i][""].ToString()); newPromo.PromoVersionID = Convert.ToInt32(ds.Tables[0].Rows[i][""].ToString()); newPromo.GameID = Convert.ToInt32(ds.Tables[0].Rows[i][""].ToString()); newPromo.PromotionName = ds.Tables[0].Rows[i][""].ToString(); newPromo.StartDate = Convert.ToDateTime(ds.Tables[0].Rows[i][""].ToString()); newPromo.EndDate = Convert.ToDateTime(ds.Tables[0].Rows[i][""].ToString()); newPromo.Enrolled = Convert.ToBoolean(ds.Tables[0].Rows[i][""].ToString()); newPromo.CouponsAvaliable = Convert.ToBoolean(ds.Tables[0].Rows[i][""].ToString()); newPromo.NextDrawingDate = Convert.ToDateTime(ds.Tables[0].Rows[i][""].ToString()); newPromo.CheckInAvaliable = Convert.ToBoolean(ds.Tables[0].Rows[i][""].ToString()); newPromo.CheckInStatusMessage = ds.Tables[0].Rows[i][""].ToString(); newPromo.FreeEntryAvaliable = Convert.ToBoolean(ds.Tables[0].Rows[i][""].ToString()); newPromo.RemoteEntryAvaliable = Convert.ToBoolean(ds.Tables[0].Rows[i][""].ToString()); newPromo.PointsToDate = Convert.ToInt32(ds.Tables[0].Rows[i][""].ToString()); newPromo.EntriesToDate = Convert.ToInt32(ds.Tables[0].Rows[i][""].ToString()); newPromo.PointsPerEntry = Convert.ToInt32(ds.Tables[0].Rows[i][""].ToString()); newPromo.TodaysPoint = Convert.ToInt32(ds.Tables[0].Rows[i][""].ToString()); newPromo.DailyEntryLImit = Convert.ToInt32(ds.Tables[0].Rows[i][""].ToString()); newPromo.ThresholdType = ds.Tables[0].Rows[i][""].ToString(); newPromo.ThresholdPoints = Convert.ToInt32(ds.Tables[0].Rows[i][""].ToString()); newPromo.PrizeName = ds.Tables[0].Rows[i][""].ToString(); newPromo.ThresholdReached = Convert.ToBoolean(ds.Tables[0].Rows[i][""].ToString()); newPromo.PrizeClaimed = Convert.ToBoolean(ds.Tables[0].Rows[i][""].ToString()); newPromo.GameAvaliable = Convert.ToBoolean(ds.Tables[0].Rows[i][""].ToString()); newPromo.RaffleAvaliable = Convert.ToBoolean(ds.Tables[0].Rows[i][""].ToString()); DataSet raffleDS = new DataSet(); List <SqlParameter> raffleParams = new List <SqlParameter>(); raffleParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); raffleDS = DataAcess.ExecuteQuerySP("PEC.PROMOTIONS_GetPromotionRaffleTickets", raffleParams); if (raffleDS.Tables[0].Rows.Count > 0) { for (int j = 0; j < raffleDS.Tables[0].Rows.Count; j++) { RaffleTicketList newRaffleTicket = new RaffleTicketList(); newRaffleTicket.RaffleTicket = raffleDS.Tables[0].Rows[j][""].ToString(); newPromo.RaffleTickets.Add(newRaffleTicket); } } else { newPromo.RaffleTickets = null; } DataSet imageDS = new DataSet(); List <SqlParameter> imageParams = new List <SqlParameter>(); imageParams.Add(new SqlParameter("@CMSPlayerID", CMSPlayerID)); imageDS = DataAcess.ExecuteQuerySP("PEC.PROMOTIONS_GetPromotionImage", imageParams); if (imageDS.Tables[0].Rows.Count > 0) { MemoryStream ms = new MemoryStream((byte[])imageDS.Tables[0].Rows[0]["Image"]); byte[] bytes = ms.ToArray(); newPromo.PromotionImage = bytes; } else { newPromo.PromotionImage = null; } Promotions.Add(newPromo); } } else { RemoveData(); } } catch (SqlException ex) { string errorMessage = ex.Message; RemoveData(); } }