/// <summary>
/// Sets the reader to object.
/// </summary>
/// <param name="objTalentTreeSexRequirement">The object talent tree sex requirement.</param>
/// <param name="result">The result.</param>
private void SetReaderToObject(ref TalentTreeSexRequirement objTalentTreeSexRequirement, ref SqlDataReader result)
{
if (result.HasRows)
{
objTalentTreeSexRequirement.TalentTreeID = (int)result.GetValue(result.GetOrdinal("TalentTreeID"));
objTalentTreeSexRequirement.Sex = result.GetValue(result.GetOrdinal("Sex")).ToString();
}
}
/// <summary>
/// Clones the specified LST TalentTreeSexRequirement.
/// </summary>
/// <param name="lstTalentTreeSexRequirement">The LST TalentTreeSexRequirement.</param>
/// <returns>List<TalentTreeSexRequirement></returns>
static public List <TalentTreeSexRequirement> Clone(List <TalentTreeSexRequirement> lstTalentTreeSexRequirement)
{
List <TalentTreeSexRequirement> lstCTalentTreeSexRequirement = new List <TalentTreeSexRequirement>();
foreach (TalentTreeSexRequirement objTalentTreeSexRequirement in lstTalentTreeSexRequirement)
{
lstCTalentTreeSexRequirement.Add(TalentTreeSexRequirement.Clone(objTalentTreeSexRequirement));
}
return(lstCTalentTreeSexRequirement);
}
/// <summary>
/// Gets the talent tree sex requirement list.
/// </summary>
/// <param name="strSprocName">Name of the string sproc.</param>
/// <param name="strWhere">The string where.</param>
/// <param name="strOrderBy">The string order by.</param>
/// <returns>List of TalentTreeSexRequirement Objects</returns>
private List <TalentTreeSexRequirement> GetTalentTreeSexRequirementList(string strSprocName, string strWhere, string strOrderBy)
{
List <TalentTreeSexRequirement> talentTreeSexRequirements = new List <TalentTreeSexRequirement>();
SqlDataReader result;
DatabaseConnection dbconn = new DatabaseConnection();
SqlCommand command = new SqlCommand();
SqlConnection connection = new SqlConnection(dbconn.SQLSEVERConnString);
try
{
connection.Open();
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = strSprocName;
command.Parameters.Add(dbconn.GenerateParameterObj("@strWhere", SqlDbType.VarChar, strWhere, 1000));
command.Parameters.Add(dbconn.GenerateParameterObj("@strOrderBy", SqlDbType.VarChar, strOrderBy, 1000));
result = command.ExecuteReader();
while (result.Read())
{
TalentTreeSexRequirement objTalentTreeSexRequirement = new TalentTreeSexRequirement();
SetReaderToObject(ref objTalentTreeSexRequirement, ref result);
talentTreeSexRequirements.Add(objTalentTreeSexRequirement);
}
}
catch
{
Exception e = new Exception();
throw e;
}
finally
{
command.Dispose();
connection.Close();
}
return(talentTreeSexRequirements);
}
/// <summary>
/// Clones the specified object TalentTreeSexRequirement.
/// </summary>
/// <param name="objTalentTreeSexRequirement">The object TalentTreeSexRequirement.</param>
/// <returns>TalentTreeSexRequirement</returns>
static public TalentTreeSexRequirement Clone(TalentTreeSexRequirement objTalentTreeSexRequirement)
{
TalentTreeSexRequirement objCTalentTreeSexRequirement = new TalentTreeSexRequirement(objTalentTreeSexRequirement.TalentTreeID);
return(objCTalentTreeSexRequirement);
}
