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();
}
