/// <summary>
/// Clones the specified LST CharacterClassLevel.
/// </summary>
/// <param name="lstCharacterClassLevel">The LST CharacterClassLevel.</param>
/// <returns>List<CharacterClassLevel></returns>
static public List <CharacterClassLevel> Clone(List <CharacterClassLevel> lstCharacterClassLevel)
{
List <CharacterClassLevel> lstCCharacterClassLevel = new List <CharacterClassLevel>();
foreach (CharacterClassLevel objCharacterClassLevel in lstCharacterClassLevel)
{
lstCCharacterClassLevel.Add(CharacterClassLevel.Clone(objCharacterClassLevel));
}
return(lstCCharacterClassLevel);
}
/// <summary>
/// Determines whether [is character class level in list] [the specified object character class level].
/// </summary>
/// <param name="objCharacterClassLevel">The object character class level.</param>
/// <param name="lstCharacterClassLevel">The LST character class level.</param>
/// <returns>Boolean</returns>
static public bool IsCharacterClassLevelInList(CharacterClassLevel objCharacterClassLevel, List <CharacterClassLevel> lstCharacterClassLevel)
{
bool blnCharacterClassLevelFound = false;
foreach (CharacterClassLevel lstObjCharacterClassLevel in lstCharacterClassLevel)
{
if (objCharacterClassLevel.ClassID == lstObjCharacterClassLevel.ClassID)
{
blnCharacterClassLevelFound = true;
}
}
return(blnCharacterClassLevelFound);
}
/// <summary>
/// Sets the reader to object.
/// </summary>
/// <param name="obCharacterClassLevel">The ob character class level.</param>
/// <param name="result">The result.</param>
private void SetReaderToObject(ref CharacterClassLevel obCharacterClassLevel, ref SqlDataReader result)
{
if (result.HasRows)
{
obCharacterClassLevel.CharacterID = (int)result.GetValue(result.GetOrdinal("CharacterID"));
obCharacterClassLevel.ClassID = (int)result.GetValue(result.GetOrdinal("ClassID"));
obCharacterClassLevel.ClassLevel = (int)result.GetValue(result.GetOrdinal("ClassLevel"));
Class objClass = new Class();
obCharacterClassLevel.objCharacterClass = objClass.GetClass(obCharacterClassLevel.ClassID);
ClassLevelInfo objClassLevel = new ClassLevelInfo();
obCharacterClassLevel.objCharacterClassLevelInfo = objClassLevel.GetClassLevels("ClassID=" + obCharacterClassLevel.ClassID.ToString() + " AND ClassLevel <=" + obCharacterClassLevel.ClassLevel.ToString(), "");
}
}
/// <summary>
/// Clones the specified object CharacterClassLevel.
/// </summary>
/// <param name="objCharacterClassLevel">The object CharacterClassLevel.</param>
/// <returns>CharacterClassLevel</returns>
static public CharacterClassLevel Clone(CharacterClassLevel objCharacterClassLevel, 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
CharacterClassLevel objCCharacterClassLevel = new CharacterClassLevel();
if (blnFromDatabase)
{
objCCharacterClassLevel.GetCharacterClassLevel(objCharacterClassLevel.CharacterID, objCharacterClassLevel.ClassLevel);
}
else
{
objCCharacterClassLevel.CharacterID = objCharacterClassLevel.CharacterID;
objCCharacterClassLevel.ClassID = objCharacterClassLevel.ClassID;
objCCharacterClassLevel.ClassLevel = objCharacterClassLevel.ClassLevel;
}
return(objCCharacterClassLevel);
}
/// <summary>
/// Gets the character class level 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 CharacterClassLevel Objects</returns>
private List <CharacterClassLevel> GetCharacterClassLevelList(string strSprocName, string strWhere, string strOrderBy)
{
List <CharacterClassLevel> characterClassLevels = new List <CharacterClassLevel>();
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())
{
CharacterClassLevel objCharacterClassLevel = new CharacterClassLevel();
SetReaderToObject(ref objCharacterClassLevel, ref result);
characterClassLevels.Add(objCharacterClassLevel);
}
}
catch
{
Exception e = new Exception();
throw e;
}
finally
{
command.Dispose();
connection.Close();
}
return(characterClassLevels);
}
