private void CB_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
Teams_Tbl a1 = (Teams_Tbl)CB.SelectedItem;
if (a1 == null)
{
TeamS.Text = "";
TeamN.Text = "";
Ecombo.Text = "";
TeamL.Text = "";
return;
}
TeamN.Text = a1.TeamName;
TeamS.Text = a1.TeamStartDate;
if (a1.TeamEmployee == null)
{
Ecombo.Text = "";
}
else
{
Ecombo.Text = a1.Employees_Tbl.EmpName;
}
TeamL.Text = a1.TeamLevel;
}
private void Update_Click(object sender, RoutedEventArgs e)
{
Teams_Tbl a1 = (Teams_Tbl)CB.SelectedItem;
Teams_Tbl a2 = (from s in db.Teams_Tbl where s.TeamId == a1.TeamId select s).FirstOrDefault();
a2.TeamStartDate = TeamS.Text;
a2.TeamName = TeamN.Text;
a2.TeamLevel = TeamL.Text;
a2.TeamEmployee = (Ecombo.SelectedItem as Employees_Tbl).EmpId;
a2.TeamEmployeeName = (Ecombo.SelectedItem as Employees_Tbl).EmpName;
db.SaveChanges();
updateCB();
UpdateDGV();
}
private void Add_click(object sender, RoutedEventArgs e)
{
String Name = TeamN.Text;
String Date = TeamS.Text;
String Level = TeamL.Text;
String Ename = (Ecombo.SelectedItem as Employees_Tbl).EmpName;
int Emp = (Ecombo.SelectedItem as Employees_Tbl).EmpId;
/*בודק שהוכנסו כל הנתונים שהם חובה
* EmpN name of textBox*/
if (TeamL.Text == "" || TeamN.Text == "" || Ecombo.Text == "")
{
this.Title = "Erorr";
return;
}
/* שומר את הנתונים שהוקלדו והוכנסו אל המשתנים המתאימים בטבלה
* EmpName השם של העמודה בטבלה*/
Teams_Tbl a1 = new Teams_Tbl();
a1.TeamStartDate = Date;
a1.TeamName = Name;
a1.TeamEmployee = Emp;
a1.TeamLevel = Level;
a1.TeamEmployeeName = Ename;
db.Teams_Tbl.Add(a1);
db.SaveChanges();
this.Title = "Employee Add";
TeamS.Text = "";
TeamN.Text = "";
Ecombo.Text = "";
TeamL.Text = "";
this.Title = "sucsses";
UpdateDGV();
updateCB();
}
