private void btnRegister_Click(object sender, EventArgs e)
{
string ime = txtBxIme.Text;
string prezime = txtBxPrezime.Text;
string oib = txtBxOib.Text;
string username = txtBxUsername.Text;
string password = txtBxPassword.Text;
// using (var context = new restoranDBEntities())
//{
// var query = from k in context.korisniks where k.korisnickoIme == username select k;
//
// }
var context = new restoranDBEntities1();
var query = from k in context.korisniks select k;
int id = query.Count() + 1;
korisnik korisnik = new korisnik()
{
korisnikID = id, ime = ime, korisnickoIme = username, prezime = prezime, oib = oib, lozinka = password, tipKorisnika = "konobar", racuns = null
};
context.korisniks.Add(korisnik);
context.SaveChanges();
Console.WriteLine(korisnik);
var query2 = from k in context.korisniks where k.ime == ime select k;
Console.WriteLine(query2.First().ime);
}
private void loadData()
{
using (var context = new restoranDBEntities1())
{
var query = from k in context.korisniks select k;
dataGridView1.DataSource = query.ToList();
}
}