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