public cPlayerAffiliation(Int32 iPlayerAffilID, string sUserName, Int32 iUserID)
{
MethodBase lmth = MethodBase.GetCurrentMethod();
string lsRoutineName = lmth.DeclaringType + "." + lmth.Name;
PlayerAffiliationID = iPlayerAffilID;
SortedList slParams = new SortedList();
slParams.Add("@PlayerAffiliationID", iPlayerAffilID);
try
{
DataTable ldt = cUtilities.LoadDataTable("uspGetPlayerAffiliationByID", slParams, "LARPortal", sUserName, lsRoutineName);
if (ldt.Rows.Count > 0)
{
AffiliationName = ldt.Rows[0]["AffiliationName"].ToString();
AffiliationRole = ldt.Rows[0]["AffiliationRole"].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;
}
RecordStatus = RecordStatuses.Active;
}
}
catch (Exception ex)
{
ErrorAtServer lobjError = new ErrorAtServer();
lobjError.ProcessError(ex, lsRoutineName, sUserName + lsRoutineName);
}
}
public cPlayerResume()
{
PlayerProfileID = -1;
PlayerSkills = new List <cPlayerSkill>();
PlayerAffiliations = new List <cPlayerAffiliation>();
RecordStatus = RecordStatuses.Active;
}
public cPlayerWaiver()
{
PlayerWaiverID = -1;
PlayerProfileID = -1;
AcceptedDate = null;
DeclinedDate = null;
DeclineApprovedByID = null;
WaiverImage = "";
PlayerNotes = "";
StaffNotes = "";
Comments = "";
WaiverID = -1;
SourceID = null;
WaiverText = "";
WaiverNotes = "";
RequiredToPlay = null;
WaiverStartDate = null;
WaiverEndDate = null;
WaiverComments = "";
WaiverTypeID = null;
WaiverType = "";
WaiverTypeComments = "";
CampaignName = "";
WaiverStatus = "";
WaiverStatusDate = null;
RecordStatus = RecordStatuses.Active;
}
public void Load(Int32 intPlayerLimitationID, string UserName)
{
MethodBase lmth = MethodBase.GetCurrentMethod();
string lsRoutineName = lmth.DeclaringType + "." + lmth.Name;
PlayerLimitationID = intPlayerLimitationID;
SortedList slParams = new SortedList();
slParams.Add("@PlayerLimitationID", intPlayerLimitationID);
try
{
DataTable ldt = cUtilities.LoadDataTable("uspGetPlayerLimitationsByID", slParams, "LARPortal", UserName, lsRoutineName);
if (ldt.Rows.Count > 0)
{
int iTemp;
bool bTemp;
DateTime dtTemp;
DataRow dRow = ldt.Rows[0];
if (int.TryParse(dRow["PlayerLimitationID"].ToString(), out iTemp))
{
PlayerLimitationID = iTemp;
}
if (int.TryParse(dRow["PlayerProfileID"].ToString(), out iTemp))
{
PlayerProfileID = iTemp;
}
Description = dRow["Description"].ToString();
if (bool.TryParse(dRow["ShareInfo"].ToString(), out bTemp))
{
ShareInfo = bTemp;
}
if (bool.TryParse(dRow["PrintOnCard"].ToString(), out bTemp))
{
PrintOnCard = bTemp;
}
if (DateTime.TryParse(dRow["StartDate"].ToString(), out dtTemp))
{
StartDate = dtTemp;
}
if (DateTime.TryParse(dRow["EndDate"].ToString(), out dtTemp))
{
EndDate = dtTemp;
}
Comments = dRow["Comments"].ToString();
RecordStatus = RecordStatuses.Active;
}
}
catch (Exception ex)
{
ErrorAtServer lobjError = new ErrorAtServer();
lobjError.ProcessError(ex, lsRoutineName, UserName + lsRoutineName);
}
}
public cPlayerSkill()
{
PlayerSkillID = -1;
PlayerProfileID = -1;
SkillName = "";
SkillLevel = "";
PlayerComments = "";
Comments = "";
RecordStatus = RecordStatuses.Active;
}
public cPlayerAffiliation()
{
PlayerAffiliationID = -1;
PlayerProfileID = -1;
AffiliationName = "";
AffiliationRole = "";
PlayerComments = "";
Comments = "";
RecordStatus = RecordStatuses.Active;
}
//public Int32 PlayerOccasionExceptionID
//{
// get { return _PlayerOccasionExceptionID; }
//}
//public Int32 PlayerProfileID
//{
// get { return _PlayerProfileID; }
//}
//public Int32 CampaignID
//{
// get { return _CampaignID; }
// set { _CampaignID = value; }
//}
//public Int32 OccasionID
//{
// get { return _OccasionID; }
// set { _OccasionID = value; }
//}
//public Boolean AttendPartial
//{
// get { return _AttendPartial; }
// set { _AttendPartial = value; }
//}
//public string PlayerComments
//{
// get { return _PlayerComments; }
// set { _PlayerComments = value; }
//}
//public string Comments
//{
// get { return _Comments; }
// set { _Comments = value; }
//}
//public DateTime DateAdded
//{
// get { return _DateAdded; }
//}
//public DateTime DateChanged
//{
// get { return _DateChanged; }
//}
public cPlayerOccasionExceptions()
{
PlayerOccasionExceptionID = -1;
PlayerProfileID = -1;
CampaignID = -1;
OccasionID = -1;
AttendPartial = false;
PlayerComments = "";
Comments = "";
RecordStatus = RecordStatuses.Active;
}
public cPlayerLimitation()
{
PlayerLimitationID = -1;
PlayerProfileID = -1;
Description = "";
ShareInfo = false;
PrintOnCard = false;
StartDate = null;
EndDate = null;
Comments = "";
RecordStatus = RecordStatuses.Active;
}
public cCharacterPlace()
{
CharacterPlaceID = -1;
CharacterID = -1;
CampaignPlaceID = null;
PlaceTypeID = -1;
PlaceName = "";
LocaleID = -1;
LocaleName = "";
StaffComments = "";
Comments = "";
RecordStatus = RecordStatuses.Active;
}
public cPlayerMedical()
{
PlayerMedicalID = -1;
PlayerProfileID = -1;
MedicalTypeID = -1;
MedicalTypeDescription = "";
Description = "";
Medication = "";
ShareInfo = false;
PrintOnCard = false;
StartDate = null;
EndDate = null;
Comments = "";
RecordStatus = RecordStatuses.Active;
}
/// <summary>
/// Load a character place record. Make sure to set CampaignPlaceID to the record to load.
/// </summary>
public void Load(string UserName)
{
MethodBase lmth = MethodBase.GetCurrentMethod();
string lsRoutineName = lmth.DeclaringType + "." + lmth.Name;
if (CharacterPlaceID > 0)
{
SortedList sParams = new SortedList();
sParams.Add("@CharacterPlaceID", CharacterPlaceID);
DataTable dtPlaces = cUtilities.LoadDataTable("uspGetCharacterPlaces", sParams, "LARPortal", UserName, lsRoutineName);
foreach (DataRow dRow in dtPlaces.Rows)
{
PlaceName = dRow["PlaceName"].ToString();
Comments = dRow["PlayerComments"].ToString();
LocaleName = dRow["LocaleName"].ToString();
int iTemp;
if (int.TryParse(dRow["CharacterID"].ToString(), out iTemp))
{
CharacterID = iTemp;
}
if (int.TryParse(dRow["CampaignID"].ToString(), out iTemp))
{
CampaignID = iTemp;
}
CampaignPlaceID = null;
if (int.TryParse(dRow["CampaignPlaceID"].ToString(), out iTemp))
{
if (iTemp > 0)
{
CampaignPlaceID = iTemp;
}
}
if (int.TryParse(dRow["LocaleID"].ToString(), out iTemp))
{
LocaleID = iTemp;
}
RecordStatus = RecordStatuses.Active;
}
}
}
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;
}
/// <summary>
/// Load a character type record. Make sure to set CharacterTypeID to the record to load. Use this if you have a connection open.
/// </summary>
/// <param name="connPortal">SQL Connection to the portal.</param>
public void Load(SqlConnection connPortal)
{
if (CharacterTypeID > 0)
{
SqlCommand CmdGetCampaignPlaceRecord = new SqlCommand("select * from CHCharacterType where CharacterTypeID = @CharacterTypeID", connPortal);
CmdGetCampaignPlaceRecord.Parameters.AddWithValue("@v", CharacterTypeID);
SqlDataAdapter SDAGetCampaignPlaceRecord = new SqlDataAdapter(CmdGetCampaignPlaceRecord);
DataTable dtCampaignPlaceRecord = new DataTable();
SDAGetCampaignPlaceRecord.Fill(dtCampaignPlaceRecord);
foreach (DataRow dRow in dtCampaignPlaceRecord.Rows)
{
Description = dRow["Description"].ToString();
Comments = dRow["Comments"].ToString();
RecordStatus = RecordStatuses.Active;
}
}
}
/// <summary>
/// Load a character status record. Make sure to set StatusID to the record to load.
/// </summary>
/// <param name="connPortal">SQL Connection to the portal.</param>
public void Load(SqlConnection connPortal)
{
if (StatusID > 0)
{
SqlCommand CmdGetCharacterStatusRecord = new SqlCommand("select * from CHCharacterStatus where StatusID = @StatusID", connPortal);
CmdGetCharacterStatusRecord.Parameters.AddWithValue("@StatusID", StatusID);
SqlDataAdapter SDAGetCharacterStatusRecord = new SqlDataAdapter(CmdGetCharacterStatusRecord);
DataTable dtCharacterStatusRecord = new DataTable();
SDAGetCharacterStatusRecord.Fill(dtCharacterStatusRecord);
foreach (DataRow dRow in dtCharacterStatusRecord.Rows)
{
StatusType = dRow["StatusType"].ToString();
StatusName = dRow["StatusName"].ToString();
Comments = dRow["Comments"].ToString();
RecordStatus = RecordStatuses.Active;
}
}
}
/// <summary>
/// Load a character death record. Make sure to set CharacterDeathID to the record to load. Use this if you have a connection open.
/// </summary>
/// <param name="connPortal">SQL Connection to the portal.</param>
public void Load(SqlConnection connPortal)
{
if (CampaignRaceID > 0)
{
SqlCommand CmdGetDeathRecord = new SqlCommand("select * from CHCampaignRaces where CampaignRaceID = @CampaignRaceID", connPortal);
CmdGetDeathRecord.Parameters.AddWithValue("@CampaignRaceID", CampaignRaceID);
SqlDataAdapter SDAGetDeathRecord = new SqlDataAdapter(CmdGetDeathRecord);
DataTable dtDeathRecord = new DataTable();
SDAGetDeathRecord.Fill(dtDeathRecord);
foreach (DataRow dRow in dtDeathRecord.Rows)
{
Comments = dRow["Comments"].ToString();
RaceName = dRow["RaceName"].ToString();
SubRace = dRow["SubRace"].ToString();
Description = dRow["Description"].ToString();
MakeupRequirements = dRow["MakeupRequirements"].ToString();
Photo = dRow["Photo"].ToString();
int iTemp;
if (int.TryParse(dRow["GameSystemID"].ToString(), out iTemp))
{
GameSystemID = iTemp;
}
if (int.TryParse(dRow["CampaignID"].ToString(), out iTemp))
{
CampaignID = iTemp;
}
RecordStatus = RecordStatuses.Active;
}
}
}
public RecordStatusAttribute(RecordStatuses status)
{
Status = status;
}
public RecordStatusAttribute()
{
Status = RecordStatuses.Actual;
}
public void Add()
{
CreateDate = DateTime.Now;
UpdateDate = null;
Status = RecordStatuses.ACTIVE;
}
public void Update()
{
UpdateDate = DateTime.Now;
Status = RecordStatuses.ACTIVE;
}
public void Delete()
{
UpdateDate = DateTime.Now;
Status = RecordStatuses.PASSIVE;
}
/// <summary>
/// Load a character relationship record. Make sure to set CharacterRelationshipID to the record to load.
/// </summary>
/// <param name="connPortal">SQL Connection to the portal.</param>
public void Load(SqlConnection connPortal)
{
if (CharacterRelationshipID > 0)
{
SqlCommand CmdGetCharacterRelationshipRecord = new SqlCommand(
"select * from CHCharacterRelationship where CharacterRelationshipID = @CharacterRelationshipID", connPortal);
CmdGetCharacterRelationshipRecord.Parameters.AddWithValue("@CharacterRelationshipID", CharacterRelationshipID);
SqlDataAdapter SDAGetCharacterRelationshipRecord = new SqlDataAdapter(CmdGetCharacterRelationshipRecord);
DataTable dtCharacterRelationshipRecord = new DataTable();
SDAGetCharacterRelationshipRecord.Fill(dtCharacterRelationshipRecord);
foreach (DataRow dRow in dtCharacterRelationshipRecord.Rows)
{
StaffComments = dRow["StaffComments"].ToString();
Comments = dRow["Comments"].ToString();
Name = dRow["Name"].ToString();
PlayerComments = dRow["PlayerComments"].ToString();
RelationDescription = dRow["RelationDescription"].ToString();
OtherDescription = dRow["OtherDescription"].ToString();
int iTemp;
if (int.TryParse(dRow["CharacterID"].ToString(), out iTemp))
{
CharacterID = iTemp;
}
if (int.TryParse(dRow["CampaignID"].ToString(), out iTemp))
{
CampaignID = iTemp;
}
if (int.TryParse(dRow["RelationTypeID"].ToString(), out iTemp))
{
RelationTypeID = iTemp;
}
if (int.TryParse(dRow["RelationCharacterID"].ToString(), out iTemp))
{
RelationCharacterID = iTemp;
}
if (int.TryParse(dRow["PlayerAssignedStatus"].ToString(), out iTemp))
{
PlayerAssignedStatus = iTemp;
}
if (int.TryParse(dRow["RulebookCharacterID"].ToString(), out iTemp))
{
RulebookCharacterID = iTemp;
}
if (int.TryParse(dRow["StaffAssignedRelationCharacterID"].ToString(), out iTemp))
{
StaffAssignedRelationCharacterID = iTemp;
}
if (int.TryParse(dRow["StaffAssignedStatus"].ToString(), out iTemp))
{
StaffAssignedStatus = iTemp;
}
bool bTemp;
if (bool.TryParse(dRow["ListedInHistory"].ToString(), out bTemp))
{
ListedInHistory = bTemp;
}
if (bool.TryParse(dRow["RulebookCharacter"].ToString(), out bTemp))
{
RulebookCharacter = bTemp;
}
if (bool.TryParse(dRow["HideFromPC"].ToString(), out bTemp))
{
HideFromPC = bTemp;
}
RecordStatus = RecordStatuses.Active;
}
}
}
public cPlayerLARPResume()
{
PlayerLARPResumeID = -1;
RecordStatus = RecordStatuses.Active;
}
public void Load(Int32 intPlayerWaiverID, string strUserName)
{
MethodBase lmth = MethodBase.GetCurrentMethod();
string lsRoutineName = lmth.DeclaringType + "." + lmth.Name;
PlayerProfileID = -1;
AcceptedDate = null;
DeclinedDate = null;
DeclineApprovedByID = null;
WaiverImage = "";
PlayerNotes = "";
StaffNotes = "";
Comments = "";
WaiverID = -1;
SourceID = null;
WaiverText = "";
WaiverNotes = "";
RequiredToPlay = null;
WaiverStartDate = null;
WaiverEndDate = null;
WaiverComments = "";
WaiverTypeID = null;
WaiverType = "";
WaiverTypeComments = "";
CampaignName = "";
WaiverStatus = "";
WaiverStatusDate = null;
RecordStatus = RecordStatuses.Active;
PlayerWaiverID = intPlayerWaiverID;
SortedList slParams = new SortedList();
slParams.Add("@PlayerWaiverID", PlayerWaiverID);
try
{
DataTable ldt = cUtilities.LoadDataTable("uspGetPlayerWaiverByID", slParams, "LARPortal", strUserName, lsRoutineName);
if (ldt.Rows.Count > 0)
{
DataRow ldr = ldt.Rows[0];
WaiverImage = ldr["WaiverImage"].ToString();
PlayerNotes = ldr["PlayerNotes"].ToString();
StaffNotes = ldr["StaffNotes"].ToString();
Comments = ldr["Comments"].ToString();
WaiverText = ldr["WaiverText"].ToString();
WaiverNotes = ldr["WaiverNotes"].ToString();
WaiverComments = ldr["WaiverComments"].ToString();
WaiverType = ldr["WaiverTypeDescription"].ToString();
WaiverTypeComments = ldr["WaiverTypeComments"].ToString();
WaiverStatus = ldr["WaiverStatus"].ToString();
CampaignName = ldr["CampaignName"].ToString();
DateTime dtTemp;
if (DateTime.TryParse(ldr["AcceptedDate"].ToString(), out dtTemp))
{
AcceptedDate = dtTemp;
}
else
{
AcceptedDate = null;
}
if (DateTime.TryParse(ldr["DeclinedDate"].ToString(), out dtTemp))
{
DeclinedDate = dtTemp;
}
else
{
DeclinedDate = null;
}
if (DateTime.TryParse(ldr["WaiverStartDate"].ToString(), out dtTemp))
{
WaiverStartDate = dtTemp;
}
else
{
WaiverStartDate = null;
}
if (DateTime.TryParse(ldr["WaiverEndDate"].ToString(), out dtTemp))
{
WaiverEndDate = dtTemp;
}
else
{
WaiverEndDate = null;
}
if (DateTime.TryParse(ldr["WaiverStatusDate"].ToString(), out dtTemp))
{
WaiverStatusDate = dtTemp;
}
else
{
WaiverStatusDate = null;
}
int iTemp;
if (int.TryParse(ldr["DeclineApprovedByID"].ToString(), out iTemp))
{
DeclineApprovedByID = iTemp;
}
else
{
DeclineApprovedByID = null;
}
if (int.TryParse(ldr["WaiverID"].ToString(), out iTemp))
{
WaiverID = iTemp;
}
if (int.TryParse(ldr["SourceID"].ToString(), out iTemp))
{
SourceID = iTemp;
}
else
{
SourceID = null;
}
if (int.TryParse(ldr["WaiverTypeID"].ToString(), out iTemp))
{
WaiverTypeID = iTemp;
}
else
{
WaiverTypeID = null;
}
if (int.TryParse(ldr["PlayerProfileID"].ToString(), out iTemp))
{
PlayerProfileID = iTemp;
}
bool bTemp;
if (bool.TryParse(ldr["RequiredToPlay"].ToString(), out bTemp))
{
RequiredToPlay = bTemp;
}
else
{
RequiredToPlay = false;
}
}
}
catch (Exception ex)
{
ErrorAtServer lobjError = new ErrorAtServer();
lobjError.ProcessError(ex, lsRoutineName, strUserName + lsRoutineName);
throw ex;
}
}
