// редактирование записи
private void updateButton_Click(object sender, RoutedEventArgs e)
{
if (clientsGrid.SelectedItem != null)
{
Clients.Clients client = clientsGrid.SelectedItem as Clients.Clients;
Clients.CClient.Id = client.Id;
Clients.CClient.FirstName = client.FirstName;
Clients.CClient.LastName = client.LastName;
Clients.CClient.DateBirth = client.DateBirth;
// форма редактирования
EditForm newF = new EditForm();
newF.ShowDialog();
// сохранение изменений
client.FirstName = Clients.CClient.FirstName;
client.LastName = Clients.CClient.LastName;
client.DateBirth = Clients.CClient.DateBirth;
clientsGrid.Items.Refresh();
try
{
db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
// вставка записи
private void insertButton_Click(object sender, RoutedEventArgs e)
{
Clients.CClient.DateBirth = DateTime.Now;
Clients.CClient.FirstName = "";
Clients.CClient.LastName = "";
// форма вставки
EditForm newForm = new EditForm();
newForm.ShowDialog();
if (Clients.CClient.FirstName != "")
{
// добавляем новую запись
Clients.Clients newClient = new Clients.Clients();
newClient.FirstName = Clients.CClient.FirstName;
newClient.LastName = Clients.CClient.LastName;
newClient.DateBirth = Clients.CClient.DateBirth;
db.Clients.Add(newClient);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
// удаление записи
private void deleteButton_Click(object sender, RoutedEventArgs e)
{
if (clientsGrid.SelectedItems.Count > 0)
{
for (int i = 0; i < clientsGrid.SelectedItems.Count; i++)
{
Clients.Clients client = clientsGrid.SelectedItems[i] as Clients.Clients;
if (client != null)
{
db.Clients.Remove(client);
}
}
}
try
{
db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}