예제 #1
0
        private void btnAddCustomer_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                if (!string.IsNullOrWhiteSpace(tbFirstname.Text) && !string.IsNullOrWhiteSpace(tbLastname.Text) && !string.IsNullOrWhiteSpace(tbAddress.Text) && !string.IsNullOrWhiteSpace(tbZipcode.Text) && !string.IsNullOrWhiteSpace(tbCity.Text))
                {
                    string firstname = tbFirstname.Text;
                    string lastname  = tbLastname.Text;
                    string address   = tbAddress.Text;
                    string zipcode   = tbZipcode.Text;
                    string city      = tbCity.Text;

                    DBViini.AddNewCustomer(connectionStr, firstname, lastname, address, zipcode, city, out message);
                    lbMessages.Content = message;
                }
                else
                {
                    lbMessages.Content = "Please insert text into all fields above";
                }
            }
            catch (Exception ex)
            {
                lbMessages.Content = ex.Message;
            }
        }
예제 #2
0
 private void btnGetCustomers_Click(object sender, RoutedEventArgs e)
 {
     try
     {
         dgCustomers.ItemsSource = DBViini.GetAllCustomers(connectionStr, out message).DefaultView;
         lbMessages.Content      = message;
     }
     catch (Exception ex)
     {
         lbMessages.Content = ex.Message;
     }
 }
예제 #3
0
 private void btnDeleteCustomer_Click(object sender, RoutedEventArgs e)
 {
     if (dgCustomers.SelectedIndex > 0)
     {
         DataRowView      drv = (DataRowView)dgCustomers.SelectedItem;
         string           id  = (drv["id"].ToString());
         MessageBoxResult mbr = MessageBox.Show("Do you really want to delete customer id " + id + "?", "Delete customer", MessageBoxButton.YesNo);
         if (mbr == MessageBoxResult.Yes)
         {
             try
             {
                 DBViini.DeleteCustomer(connectionStr, id, out message);
                 lbMessages.Content = message;
             }
             catch (Exception ex)
             {
                 lbMessages.Content = ex.Message;
             }
         }
     }
 }