private void SetReaderToObject(ref WeaponDamageType objWeaponDamageType, ref SqlDataReader result)
{
if (result.HasRows)
{
objWeaponDamageType.WeaponDamageTypeID = (int)result.GetValue(result.GetOrdinal("WeaponDamageTypeID"));
objWeaponDamageType.WeaponDamageTypeName = result.GetValue(result.GetOrdinal("WeaponDamageTypeName")).ToString();
objWeaponDamageType.WeaponDamageTypeDescription = result.GetValue(result.GetOrdinal("WeaponDamageTypeDescription")).ToString();
}
}
private List <WeaponDamageType> GetWeaponDamageTypeList(string strSprocName, string strWhere, string strOrderBy)
{
List <WeaponDamageType> WeaponDamageTypes = new List <WeaponDamageType>();
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())
{
WeaponDamageType objWeaponDamageType = new WeaponDamageType();
SetReaderToObject(ref objWeaponDamageType, ref result);
WeaponDamageTypes.Add(objWeaponDamageType);
}
}
catch
{
Exception e = new Exception();
throw e;
}
finally
{
command.Dispose();
connection.Close();
}
return(WeaponDamageTypes);
}