private cPlayer() { // JBradshaw 7/11/2016 Added to make sure the values are defined. 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 = ""; LARPResumeComments = ""; ResumeComments = ""; MedicalComments = ""; DateAdded = DateTime.Now; DateChanged = DateTime.Now; }
public cCharacter() { CharacterID = -1; // -1 Means that no character has been loaded. Will be a new character. TotalCP = 0; ProfilePicture = new cPicture(); // AllowCharacterRebuild = false; // JBradshaw 7/10/2016 Request #1293 }
public cPlayerInventory() { PlayerInventoryID = -1; PlayerProfileID = -1; Description = ""; ItemName = ""; InventoryTypeID = -1; InventoryTypeDesc = ""; Quantity = ""; Size = ""; PowerNeeded = ""; Location = ""; WillShare = false; InventoryNotes = ""; // InventoryImage = ""; InvImage = new cPicture(); PlayerComments = ""; Comments = ""; RecordStatus = RecordStatuses.Active; }
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); } }
private int _LoadCharacter(DataSet dsCharacterInfo) { int iNumCharacterRecords = 0; MethodBase lmth = MethodBase.GetCurrentMethod(); string lsRoutineName = lmth.DeclaringType + "." + lmth.Name; int iTemp; bool bTemp; DateTime dtTemp; double dTemp; Places = new List <cCharacterPlace>(); Deaths = new List <cCharacterDeath>(); Actors = new List <cActor>(); Relationships = new List <cRelationship>(); Pictures = new List <cPicture>(); CharacterSkills = new List <cCharacterSkill>(); Descriptors = new List <cDescriptor>(); CharacterItems = new List <cCharacterItems>(); Race = new cRace(); CharType = new cCharacterType(); Status = new cCharacterStatus(); SkillPools = new List <cSkillPool>(); Teams = new List <cTeamInfo>(); DateTime?dtDateCharacterCreated = null; Dictionary <int, string> TableInfo = new Dictionary <int, string>(); for (int i = 0; i < dsCharacterInfo.Tables.Count; i++) { if (dsCharacterInfo.Tables[i].Rows.Count > 0) { if (dsCharacterInfo.Tables[i].Columns["TableName"] != null) { TableInfo.Add(i, dsCharacterInfo.Tables[i].Rows[0]["TableName"].ToString()); } else { TableInfo.Add(i, "Unknown"); } } else { TableInfo.Add(i, "No Rows"); } } dsCharacterInfo.Tables[0].TableName = "CHCharacters"; dsCharacterInfo.Tables[1].TableName = "CHCharacterActors"; dsCharacterInfo.Tables[2].TableName = "CHCharacterSkillSets"; dsCharacterInfo.Tables[3].TableName = "CHCharacterPlaces"; dsCharacterInfo.Tables[4].TableName = "CHCharacterStaffComments"; dsCharacterInfo.Tables[5].TableName = "CHCharacterRelationships"; dsCharacterInfo.Tables[6].TableName = "CHCharacterPictures"; dsCharacterInfo.Tables[7].TableName = "CHCharacterDeaths"; dsCharacterInfo.Tables[8].TableName = "CHCampaignRaces"; dsCharacterInfo.Tables[9].TableName = "CHCharacterTypes"; dsCharacterInfo.Tables[10].TableName = "MDBStatus"; dsCharacterInfo.Tables[11].TableName = "CurrentCharacterUser"; dsCharacterInfo.Tables[12].TableName = "PlotUser"; dsCharacterInfo.Tables[13].TableName = "CharacterSkills"; dsCharacterInfo.Tables[14].TableName = "Descriptors"; dsCharacterInfo.Tables[15].TableName = "CharacterItems"; dsCharacterInfo.Tables[16].TableName = "ProfilePicture"; dsCharacterInfo.Tables[17].TableName = "CampaignInfo"; dsCharacterInfo.Tables[18].TableName = "CHCharacterSkillsPoints"; dsCharacterInfo.Tables[19].TableName = "CMTeamMemberInfo"; dsCharacterInfo.Tables[20].TableName = "SkillCost"; iNumCharacterRecords = dsCharacterInfo.Tables["CHCharacters"].Rows.Count; foreach (DataRow dRow in dsCharacterInfo.Tables["CHCharacters"].Rows) { if (int.TryParse(dRow["CharacterID"].ToString(), out iTemp)) { CharacterID = iTemp; } if (int.TryParse(dRow["CurrentUserID"].ToString(), out iTemp)) { CurrentUserID = iTemp; } if (int.TryParse(dRow["CharacterStatus"].ToString(), out iTemp)) { CharacterStatusID = iTemp; } FirstName = dRow["CharacterFirstName"].ToString(); MiddleName = dRow["CharacterMiddleName"].ToString(); LastName = dRow["CharacterLastName"].ToString(); AKA = dRow["CharacterAKA"].ToString(); Title = dRow["CharacterTitle"].ToString(); if (int.TryParse(dRow["CharacterType"].ToString(), out iTemp)) { CharacterType = iTemp; } else { CharacterType = -1; } if (int.TryParse(dRow["PlotLeadPerson"].ToString(), out iTemp)) { PlotLeadPerson = iTemp; } else { PlotLeadPerson = -1; } if (bool.TryParse(dRow["RulebookCharacter"].ToString(), out bTemp)) { RulebookCharacter = bTemp; } else { RulebookCharacter = false; } CharacterHistory = dRow["CharacterHistory"].ToString(); DateOfBirth = dRow["DateOfBirth"].ToString(); WhereFrom = dRow["WhereFrom"].ToString(); CurrentHome = dRow["CurrentHome"].ToString(); CardPrintName = dRow["CardPrintName"].ToString(); HousingListName = dRow["HousingListName"].ToString(); if (DateTime.TryParse(dRow["StartDate"].ToString(), out dtTemp)) { StartDate = dtTemp; } else { StartDate = null; } if (DateTime.TryParse(dRow["DateHistorySubmitted"].ToString(), out dtTemp)) { DateHistorySubmitted = dtTemp; } else { DateHistorySubmitted = null; } if (DateTime.TryParse(dRow["DateHistoryApproved"].ToString(), out dtTemp)) { DateHistoryApproved = dtTemp; } else { DateHistoryApproved = null; } CharacterEmail = dRow["CharacterEmail"].ToString(); if (double.TryParse(dRow["TotalCP"].ToString(), out dTemp)) { TotalCP = dTemp; } else { TotalCP = 0.0; } CharacterPhoto = dRow["CharacterPhoto"].ToString(); Costuming = dRow["Costuming"].ToString(); Weapons = dRow["Weapons"].ToString(); Accessories = dRow["Accessories"].ToString(); Items = dRow["Items"].ToString(); Treasure = dRow["Treasure"].ToString(); Makeup = dRow["Makeup"].ToString(); PlayerComments = dRow["PlayerComments"].ToString(); StaffComments = dRow["Comments"].ToString(); if (int.TryParse(dRow["CampaignID"].ToString(), out iTemp)) { CampaignID = iTemp; } //CampaignName = dRow["CampaignName"].ToString(); //if (int.TryParse(dRow["CharacterSkillSetID"].ToString(), out iTemp)) // CharacterSkillSetID[0] = iTemp; if (int.TryParse(dRow["PrimaryTeamID"].ToString(), out iTemp)) { TeamID = iTemp; TeamName = dRow["TeamName"].ToString(); } else { TeamName = ""; } if (int.TryParse(dRow["PlayerID"].ToString(), out iTemp)) { PlayerID = iTemp; PlayerName = dRow["PlayerName"].ToString(); PlayerEMail = dRow["PlayerEMail"].ToString(); } if (DateTime.TryParse(dRow["LatestEventDate"].ToString(), out dtTemp)) { LatestEventDate = dtTemp; } else { LatestEventDate = null; } if (bool.TryParse(dRow["VisibleToPCs"].ToString(), out bTemp)) { VisibleToPCs = bTemp; } else { VisibleToPCs = true; } // J.Bradshaw 7/10/2016 Request #1293 //if (bool.TryParse(dRow["AllowCharacterRebuild"].ToString(), out bTemp)) // AllowCharacterRebuild = bTemp; if (DateTime.TryParse(dRow["AllowSkillRebuildToDate"].ToString(), out dtTemp)) { AllowCharacterRebuildToDate = dtTemp; } if (DateTime.TryParse(dRow["DateAdded"].ToString(), out dtTemp)) { dtDateCharacterCreated = dtTemp; } if (int.TryParse(dRow["CharacterSkillSetID"].ToString(), out iTemp)) { SkillSetID = iTemp; } SkillSetName = dRow["SkillSetName"].ToString(); CampaignName = dRow["CampaignName"].ToString(); } //foreach (DataRow dSkillSet in dsCharacterInfo.Tables["CHCharacterSkillSets"].Rows) //{ // if (!(CharacterSkillSetID.HasValue) || // ((CharacterSkillSetID.HasValue) && (CharacterSkillSetID.Value.ToString() == dSkillSet["CharacterSkillSetID"].ToString()))) // { // cCharacterSkillSet cSkillSet = new cCharacterSkillSet() // { // SkillSetName = dSkillSet["SkillSetName"].ToString(), // CampaignName = dSkillSet["CampaignName"].ToString(), // PlayerComments = dSkillSet["PlayerComments"].ToString(), // Comments = dSkillSet["Comments"].ToString() // }; // if (int.TryParse(dSkillSet["CharacterSkillSetID"].ToString(), out iTemp)) // cSkillSet.CharacterSkillSetID = iTemp; // if (int.TryParse(dSkillSet["CharacterID"].ToString(), out iTemp)) // cSkillSet.CharacterID = iTemp; // if (int.TryParse(dSkillSet["CampaignID"].ToString(), out iTemp)) // cSkillSet.CampaignID = iTemp; // if (int.TryParse(dSkillSet["SkillSetStatusID"].ToString(), out iTemp)) // cSkillSet.SkillSetStatusID = iTemp; // if (int.TryParse(dSkillSet["SkillSetTypeID"].ToString(), out iTemp)) // cSkillSet.SkillSetTypeID = iTemp; // if (DateTime.TryParse(dSkillSet["AllowSkillRebuildToDate"].ToString(), out dtTemp)) // cSkillSet.AllowSkillRebuildToDate = dtTemp; // else // cSkillSet.AllowSkillRebuildToDate = null; // if (DateTime.TryParse(dSkillSet["DateAdded"].ToString(), out dtTemp)) // cSkillSet.DateAdded = dtTemp; // else // cSkillSet.DateAdded = null; // if (DateTime.TryParse(dSkillSet["DateChanged"].ToString(), out dtTemp)) // cSkillSet.DateChanged = dtTemp; // else // cSkillSet.DateChanged = null; // SkillSet.Add(cSkillSet); // } //} if (SkillSet.Count == 1) { this.SingleSkillSet = true; } else { this.SingleSkillSet = false; } foreach (DataRow dItems in dsCharacterInfo.Tables["CharacterItems"].Rows) { int CharacterItemID; int CharacterID; int?ItemPictureID; if ((int.TryParse(dItems["CharacterItemID"].ToString(), out CharacterItemID)) && (int.TryParse(dItems["CharacterID"].ToString(), out CharacterID))) { ItemPictureID = null; if (!dItems.IsNull("ItemPictureID")) { if (int.TryParse(dItems["ItemPictureID"].ToString(), out iTemp)) { ItemPictureID = iTemp; } } cCharacterItems NewItem = new cCharacterItems(CharacterItemID, CharacterID, dItems["ItemDescription"].ToString(), ItemPictureID); CharacterItems.Add(NewItem); } } foreach (DataRow dPicture in dsCharacterInfo.Tables["CHCharacterPictures"].Rows) { cPicture NewPicture = new cPicture() { PictureID = -1, PictureFileName = dPicture["PictureFileName"].ToString(), CreatedBy = dPicture["CreatedBy"].ToString(), RecordStatus = RecordStatuses.Active }; string sPictureType = dPicture["PictureType"].ToString(); NewPicture.PictureType = (cPicture.PictureTypes)Enum.Parse(typeof(cPicture.PictureTypes), sPictureType); if (int.TryParse(dPicture["MDBPictureID"].ToString(), out iTemp)) { NewPicture.PictureID = iTemp; } if (int.TryParse(dPicture["CharacterID"].ToString(), out iTemp)) { NewPicture.CharacterID = iTemp; } Pictures.Add(NewPicture); } foreach (DataRow dPlaces in dsCharacterInfo.Tables["CHCharacterPlaces"].Rows) { cCharacterPlace NewPlace = new cCharacterPlace() { CharacterPlaceID = -1, CharacterID = CharacterID, CampaignPlaceID = -1, LocaleID = -1, PlaceName = dPlaces["PlaceName"].ToString(), Comments = dPlaces["PlayerComments"].ToString(), RecordStatus = RecordStatuses.Active }; if (int.TryParse(dPlaces["CharacterPlaceID"].ToString(), out iTemp)) { NewPlace.CharacterPlaceID = iTemp; } if (int.TryParse(dPlaces["CharacterID"].ToString(), out iTemp)) { NewPlace.CharacterID = iTemp; } if (int.TryParse(dPlaces["PlaceID"].ToString(), out iTemp)) { NewPlace.CampaignPlaceID = iTemp; } if (int.TryParse(dPlaces["LocaleID"].ToString(), out iTemp)) { NewPlace.LocaleID = iTemp; } Places.Add(NewPlace); } foreach (DataRow dDeaths in dsCharacterInfo.Tables["CHCharacterDeaths"].Rows) { cCharacterDeath NewDeath = new cCharacterDeath() { CharacterDeathID = -1, CharacterID = CharacterID, StaffComments = dDeaths["StaffComments"].ToString(), Comments = dDeaths["Comments"].ToString(), RecordStatus = RecordStatuses.Active }; if (int.TryParse(dDeaths["CharacterDeathID"].ToString(), out iTemp)) { NewDeath.CharacterDeathID = iTemp; } if (bool.TryParse(dDeaths["DeathPermanent"].ToString(), out bTemp)) { NewDeath.DeathPermanent = bTemp; } if (DateTime.TryParse(dDeaths["DeathDate"].ToString(), out dtTemp)) { NewDeath.DeathDate = dtTemp; } Deaths.Add(NewDeath); } foreach (DataRow dActors in dsCharacterInfo.Tables["CHCharacterActors"].Rows) { cActor NewActor = new cActor() { CharacterActorID = -1, UserID = -1, StartDate = null, EndDate = null, loginUserName = dActors["loginUserName"].ToString(), ActorFirstName = dActors["FirstName"].ToString(), ActorMiddleName = dActors["MiddleName"].ToString(), ActorLastName = dActors["LastName"].ToString(), ActorNickName = dActors["NickName"].ToString(), StaffComments = dActors["StaffComments"].ToString(), Comments = dActors["Comments"].ToString(), RecordStatus = RecordStatuses.Active }; NewActor.CharacterID = CharacterID; if (int.TryParse(dActors["CharacterActorID"].ToString(), out iTemp)) { NewActor.CharacterActorID = iTemp; } if (int.TryParse(dActors["UserID"].ToString(), out iTemp)) { NewActor.UserID = iTemp; } if (DateTime.TryParse(dActors["StartDate"].ToString(), out dtTemp)) { NewActor.StartDate = dtTemp; } if (DateTime.TryParse(dActors["EndDate"].ToString(), out dtTemp)) { NewActor.EndDate = dtTemp; } Actors.Add(NewActor); } foreach (DataRow dRelationship in dsCharacterInfo.Tables["CHCharacterRelationships"].Rows) { cRelationship NewRelationship = new cRelationship() { CharacterRelationshipID = -1, CharacterID = CharacterID, Name = dRelationship["Name"].ToString(), RelationDescription = dRelationship["RelationDescription"].ToString(), OtherDescription = dRelationship["OtherDescription"].ToString(), RelationTypeID = -1, RelationCharacterID = -1, PlayerAssignedStatus = -1, ListedInHistory = false, RulebookCharacter = false, RulebookCharacterID = -1, PlayerComments = dRelationship["PlayerComments"].ToString(), HideFromPC = false, StaffAssignedRelationCharacterID = -1, StaffAssignedStatus = -1, StaffComments = dRelationship["StaffComments"].ToString(), Comments = dRelationship["Comments"].ToString(), RecordStatus = RecordStatuses.Active }; if (int.TryParse(dRelationship["CharacterRelationshipID"].ToString(), out iTemp)) { NewRelationship.CharacterRelationshipID = iTemp; } if (int.TryParse(dRelationship["RelationTypeID"].ToString(), out iTemp)) { NewRelationship.RelationTypeID = iTemp; } if (int.TryParse(dRelationship["RelationCharacterID"].ToString(), out iTemp)) { NewRelationship.RelationCharacterID = iTemp; } if (int.TryParse(dRelationship["PlayerAssignedStatus"].ToString(), out iTemp)) { NewRelationship.PlayerAssignedStatus = iTemp; } if (int.TryParse(dRelationship["RulebookCharacterID"].ToString(), out iTemp)) { NewRelationship.RulebookCharacterID = iTemp; } // StaffAssignedRelationCharacterID if (int.TryParse(dRelationship["StaffAssignedRelationCharacterID"].ToString(), out iTemp)) { NewRelationship.StaffAssignedRelationCharacterID = iTemp; } if (int.TryParse(dRelationship["StaffAssignedStatus"].ToString(), out iTemp)) { NewRelationship.StaffAssignedStatus = iTemp; } if (bool.TryParse(dRelationship["ListedInHistory"].ToString(), out bTemp)) { NewRelationship.ListedInHistory = bTemp; } if (bool.TryParse(dRelationship["RulebookCharacter"].ToString(), out bTemp)) { NewRelationship.RulebookCharacter = bTemp; } if (bool.TryParse(dRelationship["HideFromPC"].ToString(), out bTemp)) { NewRelationship.HideFromPC = bTemp; } Relationships.Add(NewRelationship); } foreach (DataRow dRace in dsCharacterInfo.Tables["CHCampaignRaces"].Rows) { if (int.TryParse(dRace["CampaignRaceID"].ToString(), out iTemp)) { Race.CampaignRaceID = iTemp; } if (int.TryParse(dRace["GameSystemID"].ToString(), out iTemp)) { Race.GameSystemID = iTemp; } if (int.TryParse(dRace["CampaignID"].ToString(), out iTemp)) { Race.CampaignID = iTemp; } Race.RaceName = dRace["RaceName"].ToString(); Race.SubRace = dRace["SubRace"].ToString(); Race.Description = dRace["Description"].ToString(); Race.MakeupRequirements = dRace["MakeupRequirements"].ToString(); Race.Photo = dRace["Photo"].ToString(); Race.Comments = dRace["Comments"].ToString(); } foreach (DataRow dCharType in dsCharacterInfo.Tables["CHCharacterTypes"].Rows) { if (int.TryParse(dCharType["CharacterTypeID"].ToString(), out iTemp)) { CharType.CharacterTypeID = iTemp; } CharType.Description = dCharType["Description"].ToString(); CharType.Comments = dCharType["Comments"].ToString(); } foreach (DataRow dStatus in dsCharacterInfo.Tables["MDBStatus"].Rows) { if (int.TryParse(dStatus["StatusID"].ToString(), out iTemp)) { Status.StatusID = iTemp; } Status.StatusType = dStatus["StatusType"].ToString(); Status.StatusName = dStatus["StatusName"].ToString(); Status.Comments = dStatus["Comments"].ToString(); } foreach (DataRow dSkill in dsCharacterInfo.Tables["CharacterSkills"].Rows) { cCharacterSkill NewSkill = new cCharacterSkill() { CharacterSkillSetID = -1, SkillSetName = dSkill["SkillSetName"].ToString(), StatusName = dSkill["SkillName"].ToString(), SkillSetTypeDescription = dSkill["SkillSetTypeDescription"].ToString(), SkillName = dSkill["SkillName"].ToString(), SkillShortDescription = dSkill["SkillShortDescription"].ToString(), CampaignSkillsStandardComments = dSkill["CampaignSkillsStandardComments"].ToString(), SkillTypeComments = dSkill["SkillTypeComments"].ToString(), PlayerDescription = dSkill["PlayerDescription"].ToString(), PlayerIncant = dSkill["PlayerIncant"].ToString(), SkillCardDescription = dSkill["SkillCardDescription"].ToString(), SkillCardIncant = dSkill["SkillIncant"].ToString(), AddInfoValue = dSkill["AddInfoValue"].ToString(), AddInfoType = (int)enumAddInfoType.None }; //if (int.TryParse(dSkill["CharacterSkillsStandardID"].ToString(), out iTemp)) // NewSkill.CharacterSkillsStandardID = iTemp; if (int.TryParse(dSkill["CharacterID"].ToString(), out iTemp)) { NewSkill.CharacterID = iTemp; } if (int.TryParse(dSkill["CharacterSkillSetStatusID"].ToString(), out iTemp)) { NewSkill.CharacterSkillSetStatusID = iTemp; } if (int.TryParse(dSkill["CharacterSkillSetID"].ToString(), out iTemp)) { NewSkill.CharacterSkillSetID = iTemp; } if (int.TryParse(dSkill["StatusType"].ToString(), out iTemp)) { NewSkill.StatusType = iTemp; } //if (int.TryParse(dSkill["CharacterSkillSetTypeID"].ToString(), out iTemp)) // NewSkill.CharacterSkillSetTypeID = iTemp; if (int.TryParse(dSkill["CharacterSkillID"].ToString(), out iTemp)) { NewSkill.CharacterSkillID = iTemp; } if (int.TryParse(dSkill["CampaignSkillNodeID"].ToString(), out iTemp)) { NewSkill.CampaignSkillNodeID = iTemp; } //if (int.TryParse(dSkill["CampaignSkillsStandardID"].ToString(), out iTemp)) // NewSkill.CampaignSkillsStandardID = iTemp; if (int.TryParse(dSkill["SkillTypeID"].ToString(), out iTemp)) { NewSkill.SkillTypeID = iTemp; } // if (int.TryParse(dSkill["SkillHeaderTypeID"].ToString(), out iTemp)) // NewSkill.SkillHeaderTypeID = iTemp; if (int.TryParse(dSkill["CharacterSkillSetID"].ToString(), out iTemp)) { NewSkill.CharacterSkillSetID = iTemp; } //if (int.TryParse(dSkill["HeaderAssociation"].ToString(), out iTemp)) // NewSkill.HeaderAssociation = iTemp; //if (int.TryParse(dSkill["SkillCostFixed"].ToString(), out iTemp)) // NewSkill.SkillCostFixed = iTemp; if (int.TryParse(dSkill["DisplayOrder"].ToString(), out iTemp)) { NewSkill.DisplayOrder = iTemp; } if (double.TryParse(dSkill["SkillCPCost"].ToString(), out dTemp)) { NewSkill.SkillCPCost = dTemp; } if (double.TryParse(dSkill["CPCostPaid"].ToString(), out dTemp)) { NewSkill.CPCostPaid = dTemp; } if (bool.TryParse(dSkill["CanBeUsedPassively"].ToString(), out bTemp)) { NewSkill.CanBeUsedPassively = bTemp; } if (bool.TryParse(dSkill["AllowPassiveUse"].ToString(), out bTemp)) { NewSkill.AllowPassiveUse = bTemp; } if (bool.TryParse(dSkill["OpenToAll"].ToString(), out bTemp)) { NewSkill.OpenToAll = bTemp; } if (bool.TryParse(dSkill["CardDisplayDescription"].ToString(), out bTemp)) { NewSkill.CardDisplayDescription = bTemp; } if (bool.TryParse(dSkill["CardDisplayIncant"].ToString(), out bTemp)) { NewSkill.CardDisplayIncant = bTemp; } if (bool.TryParse(dSkill["CardDisplayDescription"].ToString(), out bTemp)) { NewSkill.CardDisplayDescription = bTemp; } if (bool.TryParse(dSkill["CardDisplayIncant"].ToString(), out bTemp)) { NewSkill.CardDisplayIncant = bTemp; } NewSkill.AddInfoValue = ""; if (int.TryParse(dSkill["AddInfoType"].ToString(), out iTemp)) { switch (iTemp) { case (int)enumAddInfoType.DropDown: NewSkill.AddInfoType = enumAddInfoType.DropDown; NewSkill.AddInfoValue = dSkill["AddInfoValue"].ToString(); SortedList sSkillAddValues = new SortedList(); sSkillAddValues.Add("@CharacterSkillID", NewSkill.CharacterSkillID); //DataTable dtValues = cUtilities.LoadDataTable("uspGetCharacterSkillAddValuesList", sSkillAddValues, "LARPortal", // "GeneralUser", lsRoutineName + ".GetAvailValues"); //foreach (DataRow dRow in dtValues.Rows) //{ // cCharacterSkillAddValues NewValue = new cCharacterSkillAddValues(); // NewValue.Value = dRow["DisplayValue"].ToString(); // if (int.TryParse(dRow["SortOrder"].ToString(), out iTemp)) // NewValue.SortOrder = iTemp; // else // NewValue.SortOrder = 1; // NewSkill.AddAvailableValues.Add(NewValue); //} break; case (int)enumAddInfoType.FreeText: NewSkill.AddInfoType = enumAddInfoType.FreeText; NewSkill.AddInfoValue = dSkill["AddInfoValue"].ToString(); NewSkill.AddAvailableValues = new List <cCharacterSkillAddValues>(); break; } ; } NewSkill.RecordStatus = RecordStatuses.Active; CharacterSkills.Add(NewSkill); } foreach (DataRow dRow in dsCharacterInfo.Tables["Descriptors"].Rows) { cDescriptor NewDesc = new cDescriptor(); NewDesc.SkillSetName = dRow["SkillSetName"].ToString(); NewDesc.DescriptorValue = dRow["DescriptorValue"].ToString(); NewDesc.CharacterDescriptor = dRow["CharacterDescriptor"].ToString(); NewDesc.PlayerComments = dRow["PlayerComments"].ToString(); int iValue; if (int.TryParse(dRow["CharacterSkillSetID"].ToString(), out iValue)) { NewDesc.CharacterSkillSetID = iValue; } else { NewDesc.CharacterSkillSetID = 0; } if (int.TryParse(dRow["CharacterAttributesBasicID"].ToString(), out iValue)) { NewDesc.CharacterAttributesBasicID = iValue; } else { NewDesc.CharacterAttributesBasicID = 0; } if (int.TryParse(dRow["CampaignAttributeStandardID"].ToString(), out iValue)) { NewDesc.CampaignAttributeStandardID = iValue; } else { NewDesc.CampaignAttributeStandardID = 0; } if (int.TryParse(dRow["CampaignAttributeDescriptorID"].ToString(), out iValue)) { NewDesc.CampaignAttributeDescriptorID = iValue; } else { NewDesc.CampaignAttributeDescriptorID = 0; } Descriptors.Add(NewDesc); } ProfilePicture = null; foreach (DataRow dRow in dsCharacterInfo.Tables["ProfilePicture"].Rows) { if (int.TryParse(dRow["MDBPictureID"].ToString(), out iTemp)) { ProfilePicture = new cPicture(); ProfilePicture.PictureID = iTemp; ProfilePictureID = iTemp; ProfilePicture.PictureFileName = dRow["PictureFileName"].ToString(); ProfilePicture.PictureType = cPicture.PictureTypes.Profile; ProfilePicture.RecordStatus = RecordStatuses.Active; } } foreach (DataRow dRow in dsCharacterInfo.Tables["CHCharacterSkillsPoints"].Rows) { Classes.cSkillPool NewPool = new cSkillPool(); NewPool.PoolDescription = dRow["PoolDescription"].ToString(); NewPool.PoolDisplayColor = dRow["DisplayColor"].ToString(); if (int.TryParse(dRow["PoolID"].ToString(), out iTemp)) { NewPool.PoolID = iTemp; } if (bool.TryParse(dRow["DefaultPool"].ToString(), out bTemp)) { NewPool.DefaultPool = bTemp; } else { NewPool.DefaultPool = false; } if (double.TryParse(dRow["TotalPoints"].ToString(), out dTemp)) { NewPool.TotalPoints = dTemp; } else { NewPool.TotalPoints = 0.0; } SkillPools.Add(NewPool); } // The only teams we want to do are teams where the person is an actual member. DataView dvTeams = new DataView(dsCharacterInfo.Tables["CMTeamMemberInfo"], "Approval or Member", "", DataViewRowState.CurrentRows); foreach (DataRowView dRow in dvTeams) { Classes.cTeamInfo NewTeam = new cTeamInfo(); NewTeam.TeamName = dRow["TeamName"].ToString(); NewTeam.RoleDescription = dRow["RoleDescription"].ToString(); if (int.TryParse(dRow["TeamID"].ToString(), out iTemp)) { NewTeam.TeamID = iTemp; } if (int.TryParse(dRow["CharacterID"].ToString(), out iTemp)) { NewTeam.CharacterID = iTemp; } if (int.TryParse(dRow["RoleID"].ToString(), out iTemp)) { NewTeam.RoleID = iTemp; } if (bool.TryParse(dRow["Approval"].ToString(), out bTemp)) { NewTeam.Approval = bTemp; } if (bool.TryParse(dRow["Member"].ToString(), out bTemp)) { NewTeam.Member = bTemp; } if (bool.TryParse(dRow["Requested"].ToString(), out bTemp)) { NewTeam.Requested = bTemp; } if (bool.TryParse(dRow["Invited"].ToString(), out bTemp)) { NewTeam.Invited = bTemp; } Teams.Add(NewTeam); } foreach (DataRow dRow in dsCharacterInfo.Tables["SkillCost"].Rows) { Classes.cCharacterSkillCost skillCost = new cCharacterSkillCost(); if (int.TryParse(dRow["CharacterSkillCostID"].ToString(), out iTemp)) { skillCost.CharacterSkillCostID = iTemp; } if (int.TryParse(dRow["CharacterSkillID"].ToString(), out iTemp)) { skillCost.CharacterSkillID = iTemp; } if (int.TryParse(dRow["CampaignSkillPoolID"].ToString(), out iTemp)) { skillCost.CampaignSkillPoolID = iTemp; } if (double.TryParse(dRow["CPCostPaid"].ToString(), out dTemp)) { skillCost.CPCostPaid = dTemp; } if (DateTime.TryParse(dRow["WhenPurchased"].ToString(), out dtTemp)) { skillCost.WhenPurchased = dtTemp; } skillCost.PoolDescription = dRow["PoolDescription"].ToString(); skillCost.DisplayColor = dRow["DisplayColor"].ToString(); } return(iNumCharacterRecords); }
protected void btnUpload_Click(object sender, EventArgs e) { if (ulFile.HasFile) { try { //If file is not an image do not let it in the system System.Drawing.Imaging.ImageFormat imgFormat = System.Drawing.Imaging.ImageFormat.Jpeg; string fExt = ulFile.FileName.Substring(ulFile.FileName.IndexOf(".") + 1).ToUpper(); string[] validImageExt = { "BMP", "GIF", "ICO", "JPG", "JPEG", "PNG" }; if (!validImageExt.Contains(fExt)) { lblMessage.Text = "Invalid File time. Supported types are " + string.Join(", ", validImageExt); return; } else { if (fExt == "BMP") { imgFormat = System.Drawing.Imaging.ImageFormat.Bmp; } if (fExt == "GIF") { imgFormat = System.Drawing.Imaging.ImageFormat.Gif; } if (fExt == "ICO") { imgFormat = System.Drawing.Imaging.ImageFormat.Icon; } if (fExt == "PNG") { imgFormat = System.Drawing.Imaging.ImageFormat.Png; } } string sUser = Session["LoginName"].ToString(); Classes.cPicture NewPicture = new Classes.cPicture(); NewPicture.PictureType = Classes.cPicture.PictureTypes.Player; NewPicture.CreateNewPictureRecord(sUser); string sExtension = Path.GetExtension(ulFile.FileName); ////The new picture should always be userId + '_2' so when we save the information we finalize it as userId + '_1' //NewPicture.PictureFileName = Demography.UserID.ToString() + "_2" + sExtension; //While the stored procedure is created I will safe the picture with the users name NewPicture.PictureFileName = Demography.UserID.ToString() + "_" + ulFile.FileName; //Not sure I understand what this means //int iCharacterID = 0; //int.TryParse(Session["dem_Img"].ToString(), out iCharacterID); //NewPicture.CharacterID = iCharacterID; string LocalName = NewPicture.PictureLocalName; if (!Directory.Exists(Path.GetDirectoryName(NewPicture.PictureLocalName))) { Directory.CreateDirectory(Path.GetDirectoryName(NewPicture.PictureLocalName)); } ulFile.SaveAs(NewPicture.PictureLocalName); NewPicture.Save(sUser); Session["dem_Img_Id"] = NewPicture.PictureID; Session["dem_Img_Url"] = NewPicture.PictureURL; imgPlayerImage.ImageUrl = NewPicture.PictureURL; /* If picture size if greater than half a megabyte we need to resize the image to 150 x 150 pixels*/ //FileInfo fInfo = new FileInfo(NewPicture.PictureLocalName); //if (fInfo.Length > 500000) //{ // System.Drawing.Image image = System.Drawing.Bitmap.FromFile(NewPicture.PictureLocalName); // System.Drawing.Image newImage = ScaleImage(image, 150, 150); // newImage.Save(NewPicture.PictureURL, imgFormat); //} } catch (Exception ex) { lblMessage.Text = ex.Message + "<br>" + ex.StackTrace; } } }