private void Window_Loaded(object sender, RoutedEventArgs e) { try { PSSCEntities Con = new PSSCEntities(); List <TABELA_CONSULTATIE> TableData = Con.TABELA_CONSULTATIE.ToList(); grd_consult.ItemsSource = TableData; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void Button_Click(object sender, RoutedEventArgs e) { try { var context = new PSSCEntities(); var consult = new TABELA_CONSULTATIE() { NUME_PACIENT = tb_numepacient.Text, CABINET = Convert.ToString(cb_cabinet.SelectedItem).Split(' ')[1], NUME_MEDIC = Convert.ToString(cb_medic.SelectedItem).Split(' ')[1], PROBLEMA = Convert.ToString(tb_problema.Text), DATA = Convert.ToString(dt_data.SelectedDate).Split(' ')[0], ORA = Convert.ToString(cb_ora.SelectedItem).Split(' ')[1] }; context.TABELA_CONSULTATIE.Add(consult); context.SaveChanges(); MessageBox.Show("Programare adaugata!", "Adaugat!", MessageBoxButton.OK); } catch { MessageBox.Show("Eroare la adaugare", "Eroare!", MessageBoxButton.OK); } }