/// <summary>
/// A list of all options and standard for the given derivative
/// </summary>
/// <param name="derivId">The derivative id</param>
/// <returns>The list of options</returns>
public List <IOption> GetOptionsByDerivativeId(int derivId)
{
Sproc procedure = new Sproc("DerOption_S", DatabaseName);
procedure.Parameters.Add("@CARDerId", SqlDbType.Int).Value = derivId;
return(procedure.ExecuteList <IOption>(this.GetOptionFromDataReader));
}
/// <summary>
/// Gets the list of manufacturer ids
/// </summary>
/// <returns>The list of manufacturer ids</returns>
private List <int> GetManufacturerIds()
{
List <int> result = new List <int>();
Sproc sp = new Sproc("Man_List_S", DatabaseName);
result = sp.ExecuteList <int>(dr => DataUtil.GetInt32(dr, "CARManId"));
return(result);
}
/// <summary>
/// Gets the server data versions.
/// </summary>
/// <returns>A collection of server data version info</returns>
public IEnumerable <KeyValuePair <string, int> > GetServerDataVersions()
{
IEnumerable <KeyValuePair <string, int> > result = null;
using (Sproc procedure = new Sproc("SelectServerDataVersion", DatabaseName))
{
result = procedure.ExecuteList(GetServerDataVersionsFromDataReader);
}
return(result);
}