예제 #1
0
 protected override void Dispose(bool disposing)
 {
     if (disposing)
     {
         db.Dispose();
     }
     base.Dispose(disposing);
 }
예제 #2
0
        private void Window_Loaded(object sender, RoutedEventArgs e)
        {
            CoffeeContext db = new CoffeeContext();

            db.Roles.Find("Admin");
            if (!db.Roles.Any())
            {
                try
                {
                    db.Roles.AddRange(new List <UserRole>()
                    {
                        new UserRole()
                        {
                            Role = "User"
                        }, new UserRole()
                        {
                            Role = "Employee"
                        },
                        new UserRole()
                        {
                            Role = "Admin"
                        }
                    });
                    db.SaveChanges();
                    db.Users.Add(new User()
                    {
                        Login   = "******", Password = "******".GetSha256Hash(), RoleFK = "Admin", Name = "John",
                        Surname = "Doe"
                    });
                    db.SaveChanges();
                }
                catch (DbUpdateException ex)
                {
                    MessageBox.Show(ex.Message);
                    throw;
                }

                db.Dispose();
            }

            e.Handled = true;
        }