private void LoadAffiliations(DataTable dtAffiliations)
{
MethodBase lmth = MethodBase.GetCurrentMethod();
string lsRoutineName = lmth.DeclaringType + "." + lmth.Name;
try
{
foreach (DataRow ldr in dtAffiliations.Rows)
{
cPlayerAffiliation cAdd = new
cPlayerAffiliation
{
AffiliationName = ldr["AffiliationName"].ToString(),
AffiliationRole = ldr["AffiliationRole"].ToString(),
PlayerComments = ldr["PlayerComments"].ToString(),
Comments = ldr["Comments"].ToString(),
RecordStatus = RecordStatuses.Active
};
int iTemp;
if (int.TryParse(ldr["PlayerProfileID"].ToString(), out iTemp))
{
cAdd.PlayerProfileID = iTemp;
}
if (int.TryParse(ldr["PlayerAffiliationID"].ToString(), out iTemp))
{
cAdd.PlayerAffiliationID = iTemp;
}
PlayerAffiliations.Add(cAdd);
}
}
catch (Exception ex)
{
ErrorAtServer lobjError = new ErrorAtServer();
lobjError.ProcessError(ex, lsRoutineName, UserName + lsRoutineName);
}
}
public void Load(string UserName, Int32 intUserID)
{
MethodBase lmth = MethodBase.GetCurrentMethod(); // this is where we use refelection to store the name of the method and class to use it to report errors
string lsRoutineName = lmth.DeclaringType + "." + lmth.Name;
SortedList slParams = new SortedList(); // I use a sortedlist wich is a C# hash table to store the paramter and value
slParams.Add("@PlayerResumeID", PlayerProfileID);
try
{
DataSet ldsPlayerInfo = cUtilities.LoadDataSet("uspGetPlayerResumeByID", slParams, "LARPortal", UserName, lsRoutineName);
if (ldsPlayerInfo.Tables[0].Rows.Count > 0)
{
PlayerComments = ldsPlayerInfo.Tables[0].Rows[0]["ResumeContents"].ToString();
}
PlayerSkills = new List <cPlayerSkill>();
foreach (DataRow dRow in ldsPlayerInfo.Tables[1].Rows)
{
cPlayerSkill NewSkill = new cPlayerSkill
{
SkillName = dRow["SkillName"].ToString(),
SkillLevel = dRow["SkillLevel"].ToString(),
PlayerComments = dRow["PlayerComments"].ToString()
};
NewSkill.PlayerProfileID = PlayerProfileID;
int iTemp;
if (int.TryParse(dRow["'PlayerSkillID"].ToString(), out iTemp))
{
NewSkill.PlayerSkillID = iTemp;
}
PlayerSkills.Add(NewSkill);
}
PlayerAffiliations = new List <cPlayerAffiliation>();
foreach (DataRow dRow in ldsPlayerInfo.Tables[2].Rows)
{
cPlayerAffiliation NewAffil = new cPlayerAffiliation
{
AffiliationName = dRow["AffiliationName"].ToString(),
AffiliationRole = dRow["AffiliationRole"].ToString(),
PlayerComments = dRow["PlayerComments"].ToString(),
Comments = dRow["Comments"].ToString()
};
NewAffil.PlayerProfileID = PlayerProfileID;
int iTemp;
if (int.TryParse(dRow["'PlayerAffiliationID"].ToString(), out iTemp))
{
NewAffil.PlayerAffiliationID = iTemp;
}
PlayerAffiliations.Add(NewAffil);
}
}
catch (Exception ex)
{
ErrorAtServer lobjError = new ErrorAtServer();
lobjError.ProcessError(ex, lsRoutineName, UserName + lsRoutineName);
}
}