private void PokazWszystko_Click(object sender, RoutedEventArgs e)
{
var con = new KolDb();
var emp = con
.EMPs
.Include(d => d.DEPT)
.Select(o => new {
o.ENAME,
o.JOB,
o.DEPT.DNAME
}).ToList();
DataGrid.ItemsSource = emp;
}
private void Odswiez()
{
var con = new KolDb();
var emp = con
.EMPs
.Include(d => d.DEPT)
.Select(o => new {
o.ENAME,
o.JOB,
o.DEPT.DNAME
}).ToList();
DataGrid.ItemsSource = emp;
}
private void Szukaj_Click(object sender, RoutedEventArgs e)
{
Szukaj.Text.ToString();
var con = new KolDb();
var emp = con
.EMPs
.Include(d => d.DEPT)
.Where(d => d.ENAME == Szukaj.Text.ToString())
.Select(o => new {
o.ENAME,
o.JOB,
o.DEPT.DNAME
}).ToList();
DataGrid.ItemsSource = emp;
}
public MainWindow()
{
InitializeComponent();
var con = new KolDb();
var emp = con
.EMPs
.Include(d => d.DEPT)
.Select(o => new {
o.ENAME,
o.JOB,
o.DEPT.DNAME
}).ToList();
DataGrid.ItemsSource = emp;
var deptname = con.DEPTs.ToList();
Ddname.ItemsSource = deptname.Select(x => x.DNAME);
}
private void Dodaj_Click(object sender, RoutedEventArgs e)
{
var con = new KolDb();
var max = con.EMPs.Max(d => d.EMPNO);
var deptno = con.DEPTs
.Where(x => x.DNAME == Ddname.SelectedItem.ToString())
.Select(x => x.DEPTNO).First();
EMP tempemp = new EMP()
{
EMPNO = max + 1,
ENAME = Eename.Text,
JOB = Jjob.Text,
DEPTNO = deptno,
};
con.EMPs.Add(tempemp);
con.SaveChanges();
Odswiez();
}