/// <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 SignUpForSelectedRole(int RoleToSignUp, int UserID, int CampaignID, int StatusID)
{
int CampaignPlayerID = 0;
string Username = "";
if (Session["Username"] == null)
{
Username = "";
}
else
{
Username = Session["Username"].ToString();
}
Classes.cUserCampaign CampaignPlayer = new Classes.cUserCampaign();
CampaignPlayer.Load(UserID, CampaignID);
CampaignPlayerID = CampaignPlayer.CampaignPlayerID; // if this comes back empty (-1) make one
if (CampaignPlayerID == -1)
{
CreatePlayerInCampaign(UserID, CampaignID);
CampaignPlayer.Load(UserID, CampaignID);
CampaignPlayerID = CampaignPlayer.CampaignPlayerID;
}
int RoleAlignment = 2;
if (RoleToSignUp == 8)
{
RoleAlignment = 1;
}
Classes.cPlayerRole PlayerRole = new Classes.cPlayerRole();
PlayerRole.CampaignPlayerRoleID = -1;
PlayerRole.CampaignPlayerID = CampaignPlayerID;
PlayerRole.RoleID = RoleToSignUp;
PlayerRole.RoleAlignmentID = RoleAlignment;
PlayerRole.Save(UserID);
if (Username != "")
{
Classes.cUser LastLogged = new Classes.cUser(Username, "Password");
string LastCampaign = LastLogged.LastLoggedInCampaign.ToString();
if (LastCampaign == null || LastCampaign == "0")
{
LastLogged.LastLoggedInCampaign = CampaignID;
LastLogged.Save();
Session["CampaignID"] = CampaignID;
}
}
}
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);
}
}
