/// <summary>
/// Update
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="RoutedEventArgs"/> instance containing the event data.</param>
/// =====================================================================================
/// Modification : Initial : 26/10/2018 |N.Wilcké (SESA474351)
/// XX/XX/XXXX | X.XXX (SESAXXXXX)
/// =====================================================================================
private void updateButton_Click(object sender, RoutedEventArgs e)
{
try
{
using (var db = new Model.Booking())
{
ClientsSet client = new ClientsSet()
{
Id = this.client.Id
};
db.ClientsSet.Attach(client);
client.Nom = nomTextBox.Text;
client.Prenom = prenomTextBox.Text;
client.DateNaissance = dateNaissanceDatePicker.DisplayDate;
db.SaveChanges();
}
((MainWindow)Window.GetWindow(this))._mainFrame.Navigate(new Clients());
}
catch (Exception ex)
{
MessageBox.Show("Internal error :" + Environment.NewLine + ex, "Alert", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
/// <summary>
/// delete
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="RoutedEventArgs"/> instance containing the event data.</param>
/// =====================================================================================
/// Modification : Initial : 25/10/2018 |N.Wilcké (SESA474351)
/// XX/XX/XXXX | X.XXX (SESAXXXXX)
/// =====================================================================================
private void MenuItem_Click(object sender, RoutedEventArgs e)
{
try
{
ClientsSet row = (ClientsSet)clientsSetDataGrid.SelectedItems[0];
using (var db = new Model.Booking())
{
var client = new ClientsSet()
{
Id = row.Id
};
db.ClientsSet.Attach(client);
db.ClientsSet.Remove(client);
db.SaveChanges();
}
DisplayClients();
}
catch (Exception ex)
{
MessageBox.Show("Internal error :" + Environment.NewLine + ex, "Alert", MessageBoxButton.OK,
MessageBoxImage.Information);
}
}
private void buttonAdd_Click(object sender, EventArgs e)
{
ClientsSet clientSet = new ClientsSet();
clientSet.FirstName = FirstName.Text;
clientSet.MiddleName = MiddleName.Text;
clientSet.LastName = LastName.Text;
clientSet.Phone = Phone.Text;
Program.wftDb.ClientsSet.Add(clientSet);
Program.wftDb.SaveChanges();
ShowClient();
}
/// <summary>
/// Update
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="RoutedEventArgs"/> instance containing the event data.</param>
/// =====================================================================================
/// Modification : Initial : 26/10/2018 |N.Wilcké (SESA474351)
/// XX/XX/XXXX | X.XXX (SESAXXXXX)
/// =====================================================================================
private void MenuItem_Click_1(object sender, RoutedEventArgs e)
{
try
{
ClientsSet row = (ClientsSet)clientsSetDataGrid.SelectedItems[0];
((MainWindow)Window.GetWindow(this))._mainFrame.Navigate(new ClientsUpdate(row));
}
catch (Exception ex)
{
MessageBox.Show("Internal error :" + Environment.NewLine + ex, "Alert", MessageBoxButton.OK,
MessageBoxImage.Information);
}
}
private void buttonEdit_Click(object sender, EventArgs e)
{
if (listViewClient.SelectedItems.Count == 1)
{
ClientsSet clientsSet = listViewClient.SelectedItems[0].Tag as ClientsSet;
clientsSet.FirstName = FirstName.Text;
clientsSet.MiddleName = MiddleName.Text;
clientsSet.LastName = LastName.Text;
clientsSet.Phone = Phone.Text;
Program.wftDb.SaveChanges();
ShowClient();
}
}
public ClientsUpdate(ClientsSet row)
{
InitializeComponent();
try
{
client = row;
nomTextBox.Text = client.Nom;
prenomTextBox.Text = client.Prenom;
dateNaissanceDatePicker.DisplayDate = client.DateNaissance;
dateNaissanceDatePicker.Text = client.DateNaissance.ToString();
}
catch (Exception ex)
{
MessageBox.Show("Internal error :" + Environment.NewLine + ex, "Alert", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
private void listViewClients_SelectedIndexChanged(object sender, EventArgs e)
{
if (listViewClients.SelectedItems.Count == 1)
{
ClientsSet clients = listViewClients.SelectedItems[0].Tag as ClientsSet;
textBoxName.Text = clients.Name;
textBoxPhone.Text = clients.Phone;
textBoxEmail.Text = clients.Email;
}
else
{
textBoxName.Text = "";
textBoxPhone.Text = "";
textBoxEmail.Text = "";
}
}
private void buttonAdd_Click(object sender, EventArgs e)
{
if (textBoxName.Text != "" && textBoxPhone.Text != "" && textBoxEmail.Text != "")
{
ClientsSet clientsSet = new ClientsSet();
clientsSet.Name = textBoxName.Text;
clientsSet.Phone = textBoxPhone.Text;
clientsSet.Email = textBoxEmail.Text;
Program.RBS_Project.ClientsSet.Add(clientsSet);
Program.RBS_Project.SaveChanges();
ShowClients();
}
else
{
MessageBox.Show("Заполнены не все поля!", "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void listViewClient_SelectedIndexChanged(object sender, EventArgs e)
{
if (listViewClient.SelectedItems.Count == 1)
{
ClientsSet clientsSet = listViewClient.SelectedItems[0].Tag as ClientsSet;
clientsSet.FirstName = FirstName.Text;
clientsSet.MiddleName = MiddleName.Text;
clientsSet.LastName = LastName.Text;
clientsSet.Phone = Phone.Text;
}
else
{
FirstName.Text = "";
MiddleName.Text = "";
LastName.Text = "";
Phone.Text = "";
}
}
private void buttonEdit_Click(object sender, EventArgs e)
{
if (listViewClients.SelectedItems.Count == 1)
{
if (textBoxName.Text != "" && textBoxPhone.Text != "" && textBoxEmail.Text != "")
{
ClientsSet clientsSet = listViewClients.SelectedItems[0].Tag as ClientsSet;
clientsSet.Name = textBoxName.Text;
clientsSet.Phone = textBoxPhone.Text;
clientsSet.Email = textBoxEmail.Text;
Program.RBS_Project.SaveChanges();
ShowClients();
}
else
{
MessageBox.Show("Заполнены не все поля!", "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
private void buttonDelete_Click(object sender, EventArgs e)
{
try
{
if (listViewClients.SelectedItems.Count == 1)
{
ClientsSet clientsSet = listViewClients.SelectedItems[0].Tag as ClientsSet;
Program.RBS_Project.ClientsSet.Remove(clientsSet);
Program.RBS_Project.SaveChanges();
ShowClients();
}
textBoxName.Text = "";
textBoxPhone.Text = "";
textBoxEmail.Text = "";
}
catch
{
MessageBox.Show("Невозможно удалить, эта запись используется!", "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void buttonDel_Click(object sender, EventArgs e)
{
try
{
if (listViewClient.SelectedItems.Count == 1)
{
ClientsSet clientsSet = listViewClient.SelectedItems[0].Tag as ClientsSet;
Program.wftDb.ClientsSet.Remove(clientsSet);
Program.wftDb.SaveChanges();
ShowClient();
}
//очищаем textBoxt-ы
FirstName.Text = "";
MiddleName.Text = "";
LastName.Text = "";
Phone.Text = "";
}
catch
{
MessageBox.Show("Невозможно удалить, эта запись используется!", "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// add new record
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="RoutedEventArgs"/> instance containing the event data.</param>
/// =====================================================================================
/// Modification : Initial : 25/10/2018 |N.Wilcké (SESA474351)
/// XX/XX/XXXX | X.XXX (SESAXXXXX)
/// =====================================================================================
private void validateClient_Click(object sender, RoutedEventArgs e)
{
try
{
using (var db = new Model.Booking())
{
ClientsSet client = new ClientsSet();
client.Nom = nomTextBox.Text;
client.Prenom = prenomTextBox.Text;
client.DateNaissance = dateNaissanceDatePicker.DisplayDate;
db.ClientsSet.Add(client);
db.SaveChanges();
}
DisplayClients();
}
catch (Exception ex)
{
MessageBox.Show("Internal error :" + Environment.NewLine + ex, "Alert", MessageBoxButton.OK,
MessageBoxImage.Information);
}
}
