private void CB_SelectionChanged(object sender, SelectionChangedEventArgs e) { Schedule_Tbl a1 = (Schedule_Tbl)CB.SelectedItem; if (a1 == null) { Pcombo.Text = ""; SchD.Text = ""; Tcombo.Text = ""; return; } Pcombo.Text = a1.Pool; SchD.Text = a1.ScheduleDate; Tcombo.Text = a1.Team; }
private void Update(object sender, RoutedEventArgs e) { Schedule_Tbl a1 = (Schedule_Tbl)CB.SelectedItem; Schedule_Tbl a2 = (from s in db.Schedule_Tbl where s.ScheduleId == a1.ScheduleId select s).FirstOrDefault(); a2.ScheduleDate = SchD.Text; a2.Team = (Tcombo.SelectedItem as Teams_Tbl).TeamName; a2.ScheduleTeamId = (Tcombo.SelectedItem as Teams_Tbl).TeamId; a2.Pool = (Pcombo.SelectedItem as Pool_Tbl).PoolName; a2.SchedulePoolId = (Pcombo.SelectedItem as Pool_Tbl).PoolId; db.SaveChanges(); updateCB(); UpdateDGV(); }
private void ADD(object sender, RoutedEventArgs e) { int Pid, Tid; String Pname = (Pcombo.SelectedItem as Pool_Tbl).PoolName; String Date = SchD.Text; String Tname = (Tcombo.SelectedItem as Teams_Tbl).TeamName; try { Pid = (Pcombo.SelectedItem as Pool_Tbl).PoolId; Tid = (Tcombo.SelectedItem as Teams_Tbl).TeamId; } catch { this.Title = "Erorr"; return; } /*בודק שהוכנסו כל הנתונים שהם חובה * EmpN name of textBox*/ if (SchD.Text == "") { this.Title = "Erorr"; return; } /* שומר את הנתונים שהוקלדו והוכנסו אל המשתנים המתאימים בטבלה * EmpName השם של העמודה בטבלה*/ Schedule_Tbl a1 = new Schedule_Tbl(); a1.ScheduleDate = Date; a1.Team = Tname; a1.ScheduleTeamId = Tid; a1.Pool = Pname; a1.SchedulePoolId = Pid; db.Schedule_Tbl.Add(a1); db.SaveChanges(); this.Title = "schedule Add"; SchD.Text = ""; Pcombo.Text = ""; Tcombo.Text = ""; this.Title = "sucsses"; UpdateDGV(); updateCB(); }