public cPlayer(Int32 intUserId, string strUserName) { Picture = new cPicture(); UserID = -1; PlayerProfileID = -1; AuthorName = ""; DateOfBirth = DateTime.Now; GenderStandared = ""; GenderOther = ""; EmergencyContactName = ""; EmergencyContactPhoneID = -1; EmergencyContactPhone = ""; MaxNumberOfEventsPerYear = 0; CPPreferenceDefault = ""; CPDestinationDefault = -1; PhotoPreference = -1; PhotoPreferenceDescription = ""; UserPhoto = ""; SearchableProfile = false; _RolePlayPercentage = 0; _CombatPercentage = 0; WriteUpLeadTimeNeeded = 0; WriteUpLengthPreference = 0; BackGroundKnowledge = ""; LinkedInURL = ""; Allergies = ""; Comments = ""; MedicalComments = ""; DateAdded = DateTime.Now; DateChanged = DateTime.Now; MethodBase lmth = MethodBase.GetCurrentMethod(); string lsRoutineName = lmth.DeclaringType + "." + lmth.Name; UserID = intUserId; UserName = strUserName; SortedList slParams = new SortedList(); slParams.Add("@UserID", UserID); try { DataSet lds = cUtilities.LoadDataSet("uspGetPlayerProfileByUserID", slParams, "LARPortal", strUserName, lsRoutineName); if (lds.Tables[0].Rows.Count > 0) { DataRow dRow = lds.Tables[0].Rows[0]; PlayerProfileID = dRow["PlayerProfileID"].ToString().ToInt32(); AuthorName = dRow["AuthorName"].ToString(); DateOfBirth = Convert.ToDateTime(dRow["DateOfBirth"].ToString()); GenderStandared = dRow["GenderStandard"].ToString(); GenderOther = dRow["GenderOther"].ToString(); EmergencyContactName = dRow["EmergencyContactName"].ToString(); EmergencyContactPhone = dRow["EmergencyContactPhone"].ToString(); MaxNumberOfEventsPerYear = dRow["MaxNumberEventsPerYear"].ToString().ToInt32(); CPPreferenceDefault = dRow["CPPreferenceDefault"].ToString(); CPDestinationDefault = dRow["CPDestinationDefault"].ToString().ToInt32(); PhotoPreference = dRow["PhotoPreference"].ToString().ToInt32(); UserPhoto = dRow["UserPhoto"].ToString(); int iTemp = 0; if (int.TryParse(dRow["PlayerPictureID"].ToString(), out iTemp)) { PictureID = iTemp; } else { Picture.PictureID = -1; } if (PictureID > 0) { Picture.Load(PictureID, intUserId.ToString()); } SearchableProfile = dRow["SearchableProfile"].ToString().ToBoolean(); RolePlayPercentage = dRow["RoleplayPercentage"].ToString().ToInt32(); CombatPercentage = dRow["CombatPercentage"].ToString().ToInt32(); WriteUpLeadTimeNeeded = dRow["WriteUpLeadTimeNeeded"].ToString().ToInt32(); WriteUpLengthPreference = dRow["WriteUpLengthPreference"].ToString().ToInt32(); BackGroundKnowledge = dRow["BackgroundKnowledge"].ToString(); LinkedInURL = dRow["LinkedInURL"].ToString(); Allergies = dRow["Allergies"].ToString(); Comments = dRow["Comments"].ToString(); LARPResumeComments = dRow["LARPResumeComments"].ToString(); ResumeComments = dRow["ResumeComments"].ToString(); MedicalComments = dRow["MedicalComments"].ToString(); DateAdded = Convert.ToDateTime(dRow["DateAdded"].ToString()); DateChanged = Convert.ToDateTime(dRow["DateChanged"].ToString()); // Cleaning up the Phone Number. EmergencyContactPhone = EmergencyContactPhone.Replace("(", "").Replace(")", "").Replace("-", "").Replace(".", ""); } LoadInventory(lds.Tables[1]); LoadLARPResumes(lds.Tables[2]); LoadOccasionExceptions(lds.Tables[3]); LoadSkills(lds.Tables[4]); LoadWaivers(lds.Tables[5]); LoadAffiliations(lds.Tables[6]); LoadMedical(lds.Tables[7]); LoadLimitations(lds.Tables[8]); } catch (Exception ex) { ErrorAtServer lobjError = new ErrorAtServer(); lobjError.ProcessError(ex, lsRoutineName, strUserName + lsRoutineName); } }
public cPlayerInventory(Int32 intPlayerInventoryID, string strUserName, Int32 intUserID) { MethodBase lmth = MethodBase.GetCurrentMethod(); string lsRoutineName = lmth.DeclaringType + "." + lmth.Name; PlayerInventoryID = intPlayerInventoryID; SortedList slParams = new SortedList(); slParams.Add("@PlayerInventoryID", PlayerInventoryID); try { DataTable ldt = cUtilities.LoadDataTable("uspGetPlayerInventoryByID", slParams, "LARPortal", strUserName, lsRoutineName); if (ldt.Rows.Count > 0) { ItemName = ldt.Rows[0]["ItemName"].ToString(); Description = ldt.Rows[0]["Description"].ToString(); Quantity = ldt.Rows[0]["Quantity"].ToString(); Size = ldt.Rows[0]["Size"].ToString(); PowerNeeded = ldt.Rows[0]["PowerNeeded"].ToString(); Location = ldt.Rows[0]["Location"].ToString(); InventoryNotes = ldt.Rows[0]["InventoryNotes"].ToString(); // InventoryImage = ldt.Rows[0]["InventoryImage"].ToString(); ImageURL = ldt.Rows[0]["ImageURL"].ToString(); PlayerComments = ldt.Rows[0]["PlayerComments"].ToString(); Comments = ldt.Rows[0]["Comments"].ToString(); int iTemp; if (int.TryParse(ldt.Rows[0]["PlayerProfileID"].ToString(), out iTemp)) { PlayerProfileID = iTemp; } if (int.TryParse(ldt.Rows[0]["InventoryTypeID"].ToString(), out iTemp)) { InventoryTypeID = iTemp; } if (int.TryParse(ldt.Rows[0]["ImageID"].ToString(), out iTemp)) { ImageID = iTemp; } if (int.TryParse(ldt.Rows[0]["ImageID"].ToString(), out iTemp)) { ImageID = iTemp; InvImage = new cPicture(); InvImage.Load(iTemp, strUserName); } bool bTemp; if (bool.TryParse(ldt.Rows[0]["WillShare"].ToString(), out bTemp)) { WillShare = bTemp; } } } catch (Exception ex) { ErrorAtServer lobjError = new ErrorAtServer(); lobjError.ProcessError(ex, lsRoutineName, strUserName + lsRoutineName); } }