/// <summary>
/// This will load the details of a particular player role
/// UserID optional to return a specific users' roles, else 0 to return all users
/// CampaignPlayerIDToLoad optional to return a specific role in a specific campaign, else 0 for all roles
/// CampaignIDToLoad optional to return all roles for a player in a specific campaign, else 0 for all campaigns
/// Mix the parameters to get mixed results
/// </summary>
public void Load(int UserID, int CampaignPlayerRoleIDToLoad, int CampaignIDToLoad, DateTime RoleExpirationDate)
{
string stStoredProc = "uspGetPlayerRoles";
string stCallingMethod = "cPlayerRoles.Load";
int iTemp;
PlayerRoleString = CampaignIDToLoad.ToString() + ":/";
SortedList slParameters = new SortedList();
slParameters.Add("@UserID", UserID);
slParameters.Add("@CampaignPlayerRoleID", CampaignPlayerRoleIDToLoad);
slParameters.Add("@CampaignID", CampaignIDToLoad);
slParameters.Add("@RoleExpirationDate", RoleExpirationDate);
DataSet dsPlayerRoles = new DataSet();
dsPlayerRoles = cUtilities.LoadDataSet(stStoredProc, slParameters, "LARPortal", UserID.ToString(), stCallingMethod);
foreach (DataRow dRow in dsPlayerRoles.Tables[0].Rows)
{
if (int.TryParse(dRow["CampaignPlayerRoleID"].ToString(), out iTemp))
{
cPlayerRole PlayerRole = new cPlayerRole();
PlayerRole.Load(UserID, iTemp, 0);
lsPlayerRoles.Add(PlayerRole);
PlayerRoleString = PlayerRoleString + PlayerRole.RoleID.ToString() + "/";
}
}
}
protected void btnGet_Click(object sender, EventArgs e)
{
int i;
Classes.cGameSystem GS = new Classes.cGameSystem();
if (int.TryParse(tbGameSystemID.Text, out i))
{
GS.Load(i, 2);
}
tbGameSystemName.Text = GS.GameSystemName;
tbGameSystemURL.Text = GS.GameSystemURL;
tbGameSystemWebPageDescription.Text = GS.GameSystemWebPageDescription;
Classes.cPlayerRole PR = new Classes.cPlayerRole();
if (int.TryParse(tbPlayerRoleID.Text, out i))
{
PR.Load(2, 0, 0);
}
}
