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