public static void CreateTrucker(TruckerDTO truckerDTO)
{
var db = new TruckerProjectDBEntities();
if (truckerDTO.TruckerID == 0)
{
truckerDTO.TruckerID = db.Truckers.Count() == 0 ? 1 : db.Truckers.OrderByDescending(p => p.TruckerID).FirstOrDefault().TruckerID + 1;
}
List <License> dbLicenses = db.Licenses.ToList();
var dbTrucker = convertToDb(truckerDTO, dbLicenses);
db.Truckers.Add(dbTrucker);
db.SaveChanges();
}
private static Trucker convertToDb(TruckerDTO truckerDTO, List <License> dbLicenses)
{
var dbTrucker = new Trucker();
dbTrucker.TruckerID = truckerDTO.TruckerID;
dbTrucker.FirstName = truckerDTO.FirstName;
dbTrucker.LastName = truckerDTO.LastName;
dbTrucker.Address = truckerDTO.Address;
dbTrucker.City = truckerDTO.City;
dbTrucker.State = truckerDTO.State;
dbTrucker.Zip = truckerDTO.Zip;
dbTrucker.LicenseNumber = truckerDTO.LicenseNumber;
dbTrucker.ExpirationDate = truckerDTO.ExpirationDate;
foreach (var license in truckerDTO.Licenses)
{
dbTrucker.Licenses.Add(dbLicenses.Where(p => p.LicenseType == license.LicenseType).FirstOrDefault());
}
return(dbTrucker);
}
