private void Update_Click(object sender, RoutedEventArgs e)
{
Students_Tbl a1 = (Students_Tbl)CB.SelectedItem;
Students_Tbl a2 = (from s in db.Students_Tbl where s.StudentId == a1.StudentId select s).FirstOrDefault();
a2.StudentName = StuN.Text;
a2.StudentMail = StuM.Text;
a2.StudentAddress = StuAdd.Text;
a2.StudentAge = StuAge.Text;
a2.StudentPhone = StuP.Text;
db.SaveChanges();
updateCB();
UpdateDGV();
}
private void Add_Click(object sender, RoutedEventArgs e)
{
String Name = StuN.Text;
String Email = StuM.Text;
String Phone = StuP.Text;
String Age = StuAge.Text;
String Address = StuAdd.Text;
/*בודק שהוכנסו כל הנתונים שהם חובה
* EmpN name of textBox*/
if (StuN.Text == "" || StuAge.Text == "" || StuP.Text == "" || StuAdd.Text == "")
{
this.Title = "Erorr";
return;
}
/* שומר את הנתונים שהוקלדו והוכנסו אל המשתנים המתאימים בטבלה
* EmpName השם של העמודה בטבלה*/
Students_Tbl a1 = new Students_Tbl();
a1.StudentName = Name;
a1.StudentMail = Email;
a1.StudentPhone = Phone;
a1.StudentAge = Age;
a1.StudentAddress = Address;
db.Students_Tbl.Add(a1);
db.SaveChanges();
this.Title = "Employe Add";
StuN.Text = "";
StuM.Text = "";
StuP.Text = "";
StuAdd.Text = "";
StuAge.Text = "";
this.Title = "sucsses";
UpdateDGV();
updateCB();
}
private void ComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
Students_Tbl a1 = (Students_Tbl)CB.SelectedItem;
if (a1 == null)
{
StuN.Text = "";
StuM.Text = "";
StuP.Text = "";
StuAdd.Text = "";
StuAge.Text = "";
return;
}
StuN.Text = a1.StudentName;
StuM.Text = a1.StudentMail;
StuP.Text = a1.StudentPhone;
StuAdd.Text = a1.StudentAddress;
StuAge.Text = a1.StudentAge;
}
