public static void ImportAstronomers(ICollection <AstronomerDTO> astronomers) { using (var context = new PlanetHuntersContext()) { foreach (var astronomer in astronomers) { if (astronomer.FirstName == null || astronomer.LastName == null) { Console.WriteLine("Invalid data format."); continue; } Astronomer astronomerEntity = new Astronomer() { FirstName = astronomer.FirstName, LastName = astronomer.LastName }; context.Astronomers.Add(astronomerEntity); Console.WriteLine($"Successfully imported {nameof(astronomerEntity)} {astronomerEntity.FirstName}."); } context.SaveChanges(); } }
public static bool IsAstronomerExisting(PlanetHuntersContext context, string firstName, string lastName) { Astronomer astronomerEntity = context.Astronomers .FirstOrDefault(astronomer => astronomer.FirstName == firstName && astronomer.LastName == lastName); if (astronomerEntity == null) { return(false); } return(true); }
public static void AddAstronomerToDatabase(PlanetHuntersContext context, Astronomer astronomerEntity) { try { context.Astronomers.Add(astronomerEntity); context.SaveChanges(); Console.WriteLine(Messages.AstronomerImported, astronomerEntity.FirstName, astronomerEntity.LastName); } catch (DbEntityValidationException) { context.Astronomers.Remove(astronomerEntity); Console.WriteLine(Messages.Error); } }