//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 createButtons()
{
buttons.Clear();
for (int i = 0; i < promotesTo.Count; i++)
{
PromoButton pb = Instantiate(promoPrefab, Vector3.zero, Quaternion.identity).GetComponent <PromoButton>();
RectTransform trans = pb.GetComponent <RectTransform>();
trans.SetParent(transform, false);
pb.piece = promotesTo[i];
pb.Init(promotesTo[i]);
buttons.Add(pb);
}
}
