/// <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); }