static void Main(string[] args) { GringottsDbContext gringottsDbContext = new GringottsDbContext(); UsersContext usersDbContext = new UsersContext(); HospitalDbContext hospitalDbDbContext = new HospitalDbContext(); // InsertWizzards(gringottsDbContext); // InsertUsers(usersDbContext); // CreateHospitalDb(hospitalDbDbContext); // ModifyHospitalDb(hospitalDbDbContext); // GetUsersByEmailProvider(usersDbContext); RemoveInactiveUsers(usersDbContext); }
//Exercise 7 static void InsertWizzards(GringottsDbContext db) { //some hardcoded data (no sql file given for this) var data = new List <WizardDeposit>() { new WizardDeposit { FirstName = "Albus", LastName = "Dumbledore", Age = 150, MagicWandCreator = "Antioch Peverell", MagicWandSize = 15, DepositStartDate = new DateTime(2016, 10, 20), DepositExpirationDate = new DateTime(2020, 10, 20), DepositAmount = 20000.24m, DepositCharge = 0.2m, IsDepositExpired = false }, new WizardDeposit { FirstName = "Harry", LastName = "Poten", Age = 16, MagicWandCreator = "Mincho Praznikov", MagicWandSize = 9, DepositStartDate = new DateTime(2014, 9, 15), DepositExpirationDate = new DateTime(2018, 9, 15), DepositAmount = 15325.25m, DepositCharge = 0.5m, IsDepositExpired = false }, new WizardDeposit { FirstName = "Emma", LastName = "Watson", Age = 150, MagicWandCreator = "Hagrid Debeliya", MagicWandSize = 10, DepositStartDate = new DateTime(2014, 08, 25), DepositExpirationDate = new DateTime(2018, 08, 25), DepositAmount = 7825.10m, DepositCharge = 0.5m, IsDepositExpired = false }, }; db.WizzardDeposits.AddRange(data); try { db.SaveChanges(); Console.WriteLine("Entries successfully saved!"); } catch (DbEntityValidationException ex) { foreach (var dbEntityValidationResult in ex.EntityValidationErrors) { foreach (var validationError in dbEntityValidationResult.ValidationErrors) { Console.WriteLine(validationError.ErrorMessage); } } } }