/// <summary>
/// Query Get All Cars Data
/// </summary>
/// <returns></returns>
public IEnumerable <CarsModel> GetAllCars()
{
var db = new SqliteDbAccess();
string query = "SELECT * FROM CarsModel ";
IEnumerable <CarsModel> hasil = db.Get <CarsModel>(query, null);
db.Dispose();
return(hasil);
}
/// <summary>
/// Query Get Car data with filter id
/// </summary>
/// <param name="car"></param>
/// <returns></returns>
public IEnumerable <CarsModel> GetAllCarsFilter(CarsModel car)
{
var db = new SqliteDbAccess();
string query = "SELECT * FROM CarsModel where Id = @id";
Dictionary <string, object> dictionary = new Dictionary <string, object>();
dictionary.Add("@id", car.Id);
IEnumerable <CarsModel> hasil = db.Get <CarsModel>(query, dictionary);
db.Dispose();
return(hasil);
}