private void Save_Button_Click(object sender, RoutedEventArgs e)
{
ReturnPerson = (Nobel_Prize_winner)PersonForm.DataContext;
if (ReturnPerson.cansave == true)
{
baza.SavePerson(ReturnPerson);
this.Close();
}
else
{
MessageBox.Show("Wrong data.");
}
}
private void BtnLoadFromFile_Click(object sender, RoutedEventArgs e)
{
OpenFileDialog openFileDialog = new OpenFileDialog();
if (openFileDialog.ShowDialog() == true)
{
Uri fileUri = new Uri(openFileDialog.FileName);
imgDynamic.Source = new BitmapImage(fileUri);
Picture = new BitmapImage(fileUri);
ReturnPerson = (Nobel_Prize_winner)PersonForm.DataContext;
ReturnPerson.Picture = Picture;
}
}
private void New_Person_Click(object sender, RoutedEventArgs e)
{
NewWindow addPerson = new NewWindow(baza);
Nobel_Prize_winner person = new Nobel_Prize_winner();
addPerson.PersonForm.DataContext = person;
addPerson.ShowDialog();
if ((addPerson.ReturnPerson != null && addPerson.ReturnPerson.FirstName != null && addPerson.ReturnPerson.LastName != null && addPerson.ReturnPerson.Year > 1900))
{
NobelList.Add(addPerson.ReturnPerson);
}
ListPersons.ItemsSource = NobelList;
ListPersons.Items.Refresh();
}
public void SavePerson(Nobel_Prize_winner person)
{
command = new SqlCommand();
command.CommandText = "InsertPerson";
command.CommandType = CommandType.StoredProcedure;
command.Connection = cnn;
command.Parameters.Add("@DB", SqlDbType.Date).Value = person.BirthD;
command.Parameters.Add("@DD", SqlDbType.Date).Value = person.DeathD;
command.Parameters.Add("@FN", SqlDbType.NVarChar).Value = person.FirstName;
command.Parameters.Add("@LN", SqlDbType.NVarChar).Value = person.LastName;
command.Parameters.Add("@N", SqlDbType.NVarChar).Value = person.Nationality;
command.Parameters.Add("@F", SqlDbType.NVarChar).Value = person.Field;
command.Parameters.Add("@Y", SqlDbType.Int).Value = person.Year;
command.Parameters.Add("@PIC", SqlDbType.NVarChar).Value = Convert.ToBase64String(person.LargeIconSerialized);
command.ExecuteNonQuery();
}
