private void loadData()
{
using (Connection sqlConn = new Connection(SQLiteBoostDB.GetDBPath())) {
VehicleAssetsDB vadb = new VehicleAssetsDB(sqlConn);
listArea = vadb.GetDamageAreas(categoryid);
listType = vadb.GetDamageTypes(categoryid);
listAreaType = vadb.GetDamageAreaTypes();
}
if (damageid > 0)
{
using (Connection sqlConn = new Connection(SQLiteBoostDB.GetDBPath()))
damage = new DamageDB(sqlConn).GetDamage(damageid);
}
}
private void LoadDataFromDB()
{
//******************************LOAD DATA FROM DB*********************************************
using (Connection sqlConn = new Connection(SQLiteBoostDB.GetDBPath())) {
VehicleAssetsDB vadb = new VehicleAssetsDB(sqlConn);
listMakes = vadb.GetMakes();
listModels = vadb.GetModels();
listBodies = vadb.GetBodies();
listDrivetrains = vadb.GetDrivetrains();
listTransmissions = vadb.GetTransmissions().Select(t => t.TransmissionName).ToArray();
listExteriorColours = vadb.GetExteriorColours().Select(e => e.Colour).ToArray();
listInteriorColours = vadb.GetInteriorColours().Select(i => i.Colour).ToArray();
listDoors = vadb.GetDoors().Select(d => d.NumberOfDoors).ToArray();
listSeats = vadb.GetSeats().Select(s => s.NumberOfSeats).ToArray();
listFeatures = vadb.GetAvailableFeatures();
listInteriorFeatures = listFeatures.Where(af => af.FeatureCategoryID == 2).Select(af => af.Feature).ToArray();
listExteriorFeatures = listFeatures.Where(af => af.FeatureCategoryID == 3).Select(af => af.Feature).ToArray();
listSafetyFeatures = listFeatures.Where(af => af.FeatureCategoryID == 4).Select(af => af.Feature).ToArray();
listMechanicalFeatures = listFeatures.Where(af => af.FeatureCategoryID == 5).Select(af => af.Feature).ToArray();
}
//years
int nextYear = DateTime.Now.Year + 1;
List <string> listColYears = new List <string>();
for (int i = nextYear; i >= nextYear - 45; i--)
{
listColYears.Add(i.ToString());
}
listYears = listColYears.ToArray();
//engine
List <string> listColEngine = new List <string>();
for (double i = 0.1; i <= 13.0; i += 0.1)
{
listColEngine.Add(Math.Round(i, 1).ToString() + "L");
}
listEngine = listColEngine.ToArray();
}
