public Auto LoadAuto(int id)
{
var auto = new Auto();
auto.Id = id;
auto.IsCanEdit = false;
DataTable dt = Program.GetAccess($"SELECT * FROM MainTable WHERE id = {id}");
auto.Id = id;
auto.CarId = int.Parse(dt.Rows[0]["car_id"].ToString());
auto.Datetime = TryParseDTOrGetDefault(dt.Rows[0]["Data"].ToString(), "Data");
//+ " VidTS, " -->tab_1_tip
auto.Road.RoadType = (RoadType)(int.Parse(dt.Rows[0]["RoadTypeId"].ToString()));
auto.Ppvk = dt.Rows[0]["punkt_name"].ToString();
auto.MestoKontrolya = dt.Rows[0]["address"].ToString();
auto.Scales.CheckDateFrom = TryParseDTOrGetDefault(dt.Rows[0]["vesi_date_OT"].ToString(), "vesi_date_OT");
auto.Scales.CheckDateTo = TryParseDTOrGetDefault(dt.Rows[0]["vesi_date_DO"].ToString(), "vesi_date_DO");
auto.Scales.Number = dt.Rows[0]["vesi_zavod_nomer"].ToString();
auto.Scales.Inaccuracy = TryParseFloatOrGetDefault(dt.Rows[0]["vesi_inaccuracy"].ToString(), def: 0);
auto.InaccuracyRoulette = TryParseFloatOrGetDefault(dt.Rows[0]["inaccuracy_roulette"].ToString(), def: 0);
string strpath = $@"{Application.StartupPath}\Files\Foto\{auto.Id}.jpg";
if (File.Exists(strpath))
{
auto.Foto = Image.FromFile(strpath);
}
auto.AutoType = (AutoType)(int.Parse(dt.Rows[0]["AutoTypeId"].ToString()));
auto.Mark = dt.Rows[0]["tab_1_mark"].ToString();
auto.Model = dt.Rows[0]["tab_1_model"].ToString();
auto.RegNumber = dt.Rows[0]["tab_1_reg"].ToString();
auto.Trailer1.Kind = dt.Rows[0]["tab_2_tip"].ToString();
auto.Trailer1.Mark = dt.Rows[0]["tab_2_mark"].ToString();
auto.Trailer1.Model = dt.Rows[0]["tab_2_model"].ToString();
auto.Trailer1.RegNomer = dt.Rows[0]["tab_2_reg"].ToString();
auto.Trailer2.Kind = dt.Rows[0]["tab_3_tip"].ToString();
auto.Trailer2.Mark = dt.Rows[0]["tab_3_mark"].ToString();
auto.Trailer2.Model = dt.Rows[0]["tab_3_model"].ToString();
auto.Trailer2.RegNomer = dt.Rows[0]["tab_3_reg"].ToString();
auto.Sobstvenik = dt.Rows[0]["sobstvenik"].ToString();
auto.SobstvenikAddess = dt.Rows[0]["address_sobstvenik"].ToString();
auto.SobstvenikSvidetelstvo = dt.Rows[0]["sobstvenik_svidetelstvo"].ToString();
auto.SobstvenikPricep = dt.Rows[0]["sobstvenik_pricep"].ToString();
auto.SobstvenikPricepAddess = dt.Rows[0]["sobstvenik_pricep_address"].ToString();
auto.SobstvenikPricepSvidetelstvo = dt.Rows[0]["sobstvenik_pricep_svidetelstvo"].ToString();
auto.Road.County = dt.Rows[0]["strana"].ToString();
auto.Road.Region = dt.Rows[0]["sub"].ToString();
auto.Road.WayText = dt.Rows[0]["marshrut"].ToString();
auto.Road.RegionKode = TryParseIntOrGetDefault(dt.Rows[0]["kog_strani"].ToString(), "kog_strani");
auto.Road.Distance = TryParseFloatOrGetDefault(dt.Rows[0]["marshrut_dlina"].ToString(), "marshrut_dlina");
auto.Road.CountWays = TryParseIntOrGetDefault(dt.Rows[0]["marshrut_kol_poezdok"].ToString(), "marshrut_kol_poezdok");
auto.HarakterGruza = dt.Rows[0]["harakter_gruza"].ToString();
auto.VidGruza = dt.Rows[0]["vid_gruza"].ToString();
auto.FullWeightData.Value = TryParseFloatOrGetDefault(dt.Rows[0]["fakt_massa"].ToString(), "fakt_massa");
auto.FullWeightData.Limit = TryParseFloatOrGetDefault(dt.Rows[0]["dopus_massa"].ToString(), "dopus_massa");
auto.FullWeightData.Damage = TryParseFloatOrGetDefault(dt.Rows[0]["dmg_massa"].ToString());
int count = TryParseIntOrGetDefault(dt.Rows[0]["count_os"].ToString(), "count_os");
for (int i = 1; i <= count; i++)
{
int axisType = int.Parse(dt.Rows[0]["v_os_" + i].ToString());
float weightValue = TryParseFloatOrGetDefault(dt.Rows[0]["m_f_os_" + i].ToString());
float loadLimit = TryParseFloatOrGetDefault(dt.Rows[0]["m_d_os_" + i].ToString());
float distanceToNext = TryParseFloatOrGetDefault(dt.Rows[0]["r_os_" + i].ToString());
float damage = TryParseFloatOrGetDefault(dt.Rows[0]["os_dmg_" + i].ToString());
auto.AddLoadedAxis(axisType: (AxisType)axisType,
distanceToNext: distanceToNext,
weightValue: weightValue,
loadLimit: loadLimit,
damage: damage);
}
auto.VoditelObyasnenie = dt.Rows[0]["obyas_vodit"].ToString();
auto.OperatorPvk = dt.Rows[0]["oper_ppvk"].ToString();
auto.Driver = dt.Rows[0]["vodit"].ToString();
auto.DriverLicense = dt.Rows[0]["udostov_vodit"].ToString();
auto.InspectorGibdd = dt.Rows[0]["insp_police"].ToString();
auto.Primechanie = dt.Rows[0]["primechanie"].ToString();
auto.SpecIndex = TryParseFloatOrGetDefault(dt.Rows[0]["kom_index"].ToString(), "kom_index");
auto.FullAutoDamage = TryParseFloatOrGetDefault(dt.Rows[0]["razmer_usherba"].ToString(), "razmer_usherba");
return(auto);
}