public void AddUser() { using (var db = new webshopHostEntities()) { Inventory userInventory = new Inventory(); // als die nog niet bestaat -> voeg toe if (!db.Users.Any(u => u.Username == regUsername.Text)) { var user = new User { Username = regUsername.Text, Password = regPassword.Text, Credit = 50, Inventory = userInventory }; db.Users.Add(user); db.SaveChanges(); MessageBox.Show("Account aangemaakt!", "Systeem melding"); } else { MessageBox.Show("Gebruikersnaam bestaat al!", "Systeem melding"); } } }
public MainWindow() { InitializeComponent(); using (var db = new webshopHostEntities()) { // dit snap ik niet helemaal // gaat niet helemaal lekker met foreign key als je hier new user en new invtory weghaald // is hier in principe niet nodig User admin = new User { User_ID = 3, Username = "******", Password = "******" }; var userInventory = new Inventory { Id = 1, User = admin }; db.Inventories.Add(userInventory); db.SaveChanges(); } }
public void AddStartUpProducts() { var appel = new Product { Product_ID = 1, Price = 2, Name = "Appel", Stock = 10, InventoryId = 1 }; var banaan = new Product { Product_ID = 2, Price = 1, Name = "Banaan", Stock = 6, InventoryId = 1 }; var kiwi = new Product { Product_ID = 3, Price = 105, Name = "Kiwi", Stock = 1, InventoryId = 1 }; var rabarber = new Product { Product_ID = 4, Price = 9000, Name = "Rabarber", Stock = 100, InventoryId = 1 }; var spinazie = new Product { Product_ID = 5, Price = 9000, Name = "Spinazie", Stock = 0, InventoryId = 1 }; db.Products.Add(appel); db.Products.Add(banaan); db.Products.Add(kiwi); db.Products.Add(rabarber); db.Products.Add(spinazie); db.SaveChanges(); MessageBox.Show("PRODUCTS ADDED "); }
private void Login_Click(object sender, RoutedEventArgs e) { if (string.IsNullOrWhiteSpace(txtUsername.Text) || string.IsNullOrWhiteSpace(txtPassword.Password)) { MessageBox.Show("Verkeerde inloggegevens!"); } else { try { using (var db = new webshopHostEntities()) { //hardcoded nieuwe user aanmaken om te testen // deze moet opgehaald worden uit invoergegevens var user = new User { User_ID = 1, Username = "******", Password = "******" }; db.Users.Add(user); db.SaveChanges(); var query = from b in db.Users orderby b.Username select b; Console.WriteLine(" All student in the database: "); foreach (var item in query) { Console.WriteLine(item.Username); } Console.WriteLine("Press any key to exit..."); Console.ReadKey(); } } catch (Exception exception) { } } }