/// <summary>
/// Clones the specified LST SizeDefenseModifier.
/// </summary>
/// <param name="lstSizeDefenseModifier">The LST SizeDefenseModifier.</param>
/// <returns>List<SizeDefenseModifier></returns>
static public List <SizeDefenseModifier> Clone(List <SizeDefenseModifier> lstSizeDefenseModifier)
{
List <SizeDefenseModifier> lstCSizeDefenseModifier = new List <SizeDefenseModifier>();
foreach (SizeDefenseModifier objSizeDefenseModifier in lstSizeDefenseModifier)
{
lstCSizeDefenseModifier.Add(SizeDefenseModifier.Clone(objSizeDefenseModifier));
}
return(lstCSizeDefenseModifier);
}
/// <summary>
/// Sets the reader to object.
/// </summary>
/// <param name="objSizeDefenseModifier">The object size defense modifier.</param>
/// <param name="result">The result.</param>
private void SetReaderToObject(ref SizeDefenseModifier objSizeDefenseModifier, ref SqlDataReader result)
{
if (result.HasRows)
{
objSizeDefenseModifier.SizeID = (int)result.GetValue(result.GetOrdinal("SizeID"));
objSizeDefenseModifier.DefenseTypeID = (int)result.GetValue(result.GetOrdinal("DefenseID"));
objSizeDefenseModifier.ModifierID = (int)result.GetValue(result.GetOrdinal("ModifierID"));
DefenseType objDefenseType = new DefenseType();
Modifier objModifier = new Modifier();
objSizeDefenseModifier.objDefenseType = objDefenseType.GetDefenseType(objSizeDefenseModifier.DefenseTypeID);
objSizeDefenseModifier.objModifier = objModifier.GetModifier(objSizeDefenseModifier.ModifierID);
}
}
/// <summary>
/// Sets the reader to object.
/// </summary>
/// <param name="objSize">Size of the object.</param>
/// <param name="result">The result.</param>
private void SetReaderToObject(ref Size objSize, ref SqlDataReader result)
{
if (result.HasRows)
{
objSize.SizeID = (int)result.GetValue(result.GetOrdinal("SizeID"));
objSize.SizeName = result.GetValue(result.GetOrdinal("SizeName")).ToString();
objSize.SizeModifier = (int)result.GetValue(result.GetOrdinal("SizeModifier"));
SizeSkillModifier objSizeSkillModifier = new SizeSkillModifier();
SizeDefenseModifier objSizeDefenseModifier = new SizeDefenseModifier();
objSize.objSizeSkillModifier = objSizeSkillModifier.GetSizeSkillModifier(objSize.SizeID);
objSize.objSizeDefenseModifier = objSizeDefenseModifier.GetSizeDefenseModifier(objSize.SizeID);
objSize._objComboBoxData.Add(objSize.SizeID, objSize.SizeName);
}
}
/// <summary>
/// Gets the size defense modifier 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 SizeDefenseModifier objects</returns>
private List <SizeDefenseModifier> GetSizeDefenseModifierList(string strSprocName, string strWhere, string strOrderBy)
{
List <SizeDefenseModifier> sizeDefenseModifiers = new List <SizeDefenseModifier>();
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())
{
SizeDefenseModifier objSizeDefenseModifier = new SizeDefenseModifier();
SetReaderToObject(ref objSizeDefenseModifier, ref result);
sizeDefenseModifiers.Add(objSizeDefenseModifier);
}
}
catch
{
Exception e = new Exception();
throw e;
}
finally
{
command.Dispose();
connection.Close();
}
return(sizeDefenseModifiers);
}
/// <summary>
/// Clones the specified object SizeDefenseModifier.
/// </summary>
/// <param name="objSizeDefenseModifier">The object SizeDefenseModifier.</param>
/// <returns>SizeDefenseModifier</returns>
static public SizeDefenseModifier Clone(SizeDefenseModifier objSizeDefenseModifier)
{
SizeDefenseModifier objCSizeDefenseModifier = new SizeDefenseModifier(objSizeDefenseModifier.SizeID, objSizeDefenseModifier.DefenseTypeID, objSizeDefenseModifier.ModifierID);
return(objCSizeDefenseModifier);
}
