/// <summary>
/// Clones the specified LST CharacterAbility.
/// </summary>
/// <param name="lstCharacterAbility">The LST CharacterAbility.</param>
/// <returns>List<CharacterAbility></returns>
static public List <CharacterAbility> Clone(List <CharacterAbility> lstCharacterAbility)
{
List <CharacterAbility> lstCCharacterAbility = new List <CharacterAbility>();
foreach (CharacterAbility objCharacterAbility in lstCharacterAbility)
{
lstCCharacterAbility.Add(CharacterAbility.Clone(objCharacterAbility));
}
return(lstCCharacterAbility);
}
private void SetReaderToObject(ref CharacterAbility objCharacterAbility, ref SqlDataReader result)
{
if (result.HasRows)
{
objCharacterAbility.CharacterID = (int)result.GetValue(result.GetOrdinal("CharacterID"));
objCharacterAbility.AbilityID = (int)result.GetValue(result.GetOrdinal("AbilityID"));
objCharacterAbility.Score = (int)result.GetValue(result.GetOrdinal("Score"));
objCharacterAbility.ScoreMod = (int)result.GetValue(result.GetOrdinal("ScoreMod"));
Ability objAbil = new Ability();
objCharacterAbility.objAbility = objAbil.GetAbility(objCharacterAbility.AbilityID);
}
}
/// <summary>
/// Clones the specified object CharacterAbility.
/// </summary>
/// <param name="objCharacterAbility">The object CharacterAbility.</param>
/// <returns>CharacterAbility</returns>
static public CharacterAbility Clone(CharacterAbility objCharacterAbility, bool blnFromDatabase = false)
{
//Get the data from the database(?) then match it with what is passed in, we want to clone what is passed in for Character Items, not List Items
CharacterAbility objCCharacterAbility = new CharacterAbility();
if (blnFromDatabase)
{
objCCharacterAbility.GetCharacterAbility(objCharacterAbility.CharacterID, objCharacterAbility.AbilityID);
}
else
{
objCCharacterAbility.AbilityID = objCharacterAbility.AbilityID;
objCCharacterAbility.CharacterID = objCharacterAbility.CharacterID;
objCCharacterAbility.objAbility = objCharacterAbility.objAbility;
objCCharacterAbility.Score = objCharacterAbility.Score;
objCCharacterAbility.ScoreMod = objCharacterAbility.ScoreMod;
}
return(objCCharacterAbility);
}
private List <CharacterAbility> GetCharacterAbilityList(string strSprocName, string strWhere, string strOrderBy)
{
List <CharacterAbility> CharacterAbilitys = new List <CharacterAbility>();
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())
{
CharacterAbility objCharacterAbility = new CharacterAbility();
SetReaderToObject(ref objCharacterAbility, ref result);
CharacterAbilitys.Add(objCharacterAbility);
}
}
catch
{
Exception e = new Exception();
throw e;
}
finally
{
command.Dispose();
connection.Close();
}
return(CharacterAbilitys);
}
