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); }