public void GetDriverInfo(DriversAndLicences driversAndLicences, string statinf, string nameInd)
{
driversAndLicences.Status = statinf;
driversAndLicences.Ind = $@"{AppDomain.CurrentDomain.BaseDirectory}/Assets/{nameInd}C.png";
}
public DriverCardViewModel()
{
Licencess = new ObservableCollection <DriversAndLicences>();
using (ModelDB md = new ModelDB())
{
var querry = from D in md.Drivers
from L in md.Licences
where D.ID == L.id
select new
{
Name = D.Name,
MiddleName = D.MiddleName,
Adress = D.Adress,
LicenceDate = L.LicenceDate,
NameOrg = "null",
Number = L.LicenceNumber,
AdressLife = D.AdressLife,
Categories = L.Categories,
Photo = D.Photo,
ExpDate = L.ExpireDate,
LicenceSeries = L.LicenceSeries,
VIN = L.VIN,
Manufacturer = L.Manufacturer,
Model = L.Model,
Year = L.Year,
Weight = L.Weight,
Color = L.Color,
EngineType = L.EngineType,
TypeOfdrive = L.TypeOfDrive
};
foreach (var s in querry)
{
DriversAndLicences driversAndLicences = new DriversAndLicences
{
Name = s.Name,
MiddleName = s.MiddleName,
Adress = s.Adress,
AdressLife = s.AdressLife,
Categories = s.Categories,
Number = s.Number,
NameOrg = s.NameOrg,
DateOfIssure = s.LicenceDate,
Photo = $@"{AppDomain.CurrentDomain.BaseDirectory}/Assets/" + s.Photo,
LicenceSeries = s.LicenceSeries,
VIN = s.VIN,
Manufacturer = s.Manufacturer,
Model = s.Model,
Year = s.Year,
Weight = s.Weight,
Color = s.Color,
EngineType = s.EngineType,
TypeOfdrive = s.TypeOfdrive,
ExpireDate = s.ExpDate
};
if (s.ExpDate < DateTime.Now && s.LicenceDate.Value.Year != s.ExpDate.Value.Year)
{
GetDriverInfo(driversAndLicences, "Утратил силу", "white");
}
else if (s.ExpDate.Value.Year == s.LicenceDate.Value.Year)
{
GetDriverInfo(driversAndLicences, "Изъят", "red");
}
else
{
GetDriverInfo(driversAndLicences, "Активен", "green");
}
Licencess.Add(driversAndLicences);
CountObject();
}
}
}
