/// <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); } }