/// <summary>
/// Get the makes that start with partial.
/// </summary>
/// <param name="partial">The partial search term.</param>
/// <returns></returns>
static public IEnumerable <string> GetPartialMakes(string partial)
{
var makes = new AutoMakeModels
{
Query = string.Format("select AUTO_MAKE_MODEL_ID, YEAR, MAKE, MODEL from AUTO_MAKE_MODEL where MAKE LIKE '{0}%' ORDER BY MAKE", partial.ToUpper())
};
return(makes.Results().Select(a => GeneralUtility.ToTitleCase(a.Make)).Distinct().ToArray());
}
/// <summary>
/// Gets the models.
/// </summary>
/// <param name="make">The make.</param>
/// <param name="partial">The partial.</param>
/// <returns></returns>
static public IEnumerable <string> GetModels(string make, string partial)
{
string query;
if (!string.IsNullOrEmpty(partial))
{
query =
string.Format(
"select AUTO_MAKE_MODEL_ID, YEAR, MAKE, MODEL from AUTO_MAKE_MODEL where MAKE = :make and MODEL like '{0}%' ORDER BY MODEL",
partial.ToUpper());
}
else
{
query = "select AUTO_MAKE_MODEL_ID, YEAR, MAKE, MODEL from AUTO_MAKE_MODEL where MAKE = :make ORDER BY MODEL";
}
var makes = new AutoMakeModels
{
Query = query
};
makes.AddParameter("make", make.ToUpper());
return(makes.Results().Select(a => GeneralUtility.ToTitleCase(a.Model)).Distinct().ToArray());
}
