private void txt_Password_TextChanged(object sender, TextChangedEventArgs e) { connect = new CTUConnection(); // refreshens the 'CTUConnection' class // connect.SelectCustomer(); //*Selects the specified columns in the Patient table*// connect.SearchCustomerPassword(txt_Password.Text); //Searches the customer's 'name' within the populated table// DGV_Cust.ItemsSource = connect.dataset; //*All the selected fields are filtered inside the table and stored inside the grid-view*// }
private void can_Show_MouseLeftButtonDown(object sender, System.Windows.Input.MouseButtonEventArgs e) { try { connect = new CTUConnection(); connect.SelectCustomer(); DGV_Cust.ItemsSource = connect.table.DefaultView; } catch (Exception) { } }
private void can_Delete_MouseLeftButtonDown(object sender, MouseButtonEventArgs e) { connect = new CTUConnection(); // refreshens the 'Connection' class // try { connect.DeleteCustomer(int.Parse(ID)); connect.SelectCustomer(); DGV_Cust.ItemsSource = connect.table.DefaultView; } catch (Exception) { } }
private void can_Submit_MouseDown(object sender, MouseButtonEventArgs e) { connect = new CTUConnection(); viewCust = new ViewCustomer(); if (txt_BankNO.MaxLength != 18 || string.IsNullOrEmpty(txt_BankNO.Text)) { MessageBox.Show("Make sure the bank account number is correct"); } else if (string.IsNullOrEmpty(txt_firstname.Text)) { MessageBox.Show("Please enter the firstname of the customer"); } else if (txt_IDnumber.MaxLength != 13 || string.IsNullOrEmpty(txt_IDnumber.Text)) { MessageBox.Show("Please enter the ID number of the customer"); } else if (string.IsNullOrEmpty(txt_Surname.Text)) { MessageBox.Show("Please enter the surname of the customer"); } else if (string.IsNullOrEmpty(txt_Password.Text)) { MessageBox.Show("Please enter the password of the customer"); } else { connect.GetCustomer(txt_username.Text, txt_Password.Text, txt_firstname.Text, txt_Surname.Text, txt_IDnumber.Text, txt_BankNO.Text); connect.SelectCustomer(); viewCust.DGV_Cust.ItemsSource = connect.table.DefaultView; } }