private void Create_Click(object sender, RoutedEventArgs e) { if (name.Text != "" && lastName.Text != "" && age.Text != "" && phone.Text != "" && language.Text != "") { try { int agePers = Convert.ToInt32(age.Text); StudentQueryDb query = new StudentQueryDb(); string[] studentCharacteristics = new string[5] { name.Text, lastName.Text, age.Text, phone.Text, language.Text }; bool result = query.CreatePers(studentCharacteristics); if (result == true) { MessageBox.Show("Student added!"); } } catch { MessageBox.Show("You entered wrong AGE!\r\nEnter number!", "Exception"); } } else { MessageBox.Show("Not all data entered!"); } }
private void Save_Click(object sender, RoutedEventArgs e) { if (name.Text != "" && lastName.Text != "" && age.Text != "" && phone.Text != "" && language.Text != "") { try { int agePers = Convert.ToInt32(age.Text); StudentQueryDb query = new StudentQueryDb(); string[] updateData = new string[6] { name.Text, lastName.Text, age.Text, phone.Text, language.Text, id.Content.ToString() }; bool result = query.UpdatePers(updateData); if (result == true) { MessageBox.Show("Student updated!"); } } catch { MessageBox.Show("You entered wrong AGE!\r\nEnter number!", "Exception"); } } else { MessageBox.Show("Not all data entered!"); } }
public void List_Click(object sender, RoutedEventArgs e) { ListEntities window = new ListEntities(); Close(); window.Show(); StudentQueryDb query = new StudentQueryDb(); window.list.ItemsSource = query.SelectPers(); }