// navigates user back to the participants view window
private void BtnBack_Click(object sender, RoutedEventArgs e)
{
ParticipantsView back = new ParticipantsView();
back.Show();
this.Close();
}
//users adds a new participant to the database
private void BtnAddParticipant_Click(object sender, RoutedEventArgs e)
{
// A try catch statement that asks the user to input data first
try
{
//temporary storage location for database columns
int id = Convert.ToInt32(txtParticipantID.Text);
string FirstName = txtFirstName.Text;
string Surname = txtSurname.Text;
string Address1 = txtAddress1.Text;
string Address2 = txtAddress2.Text;
string Town = txtTown.Text;
string County = txtCounty.Text;
string Postcode = txtPostcode.Text;
string ContactNo = txtContactNo.Text;
string DOB = txtDOB.Text;
//query that then inserts user inputs from the textboxes to the database
string query = "Insert into Participants(ParticipantID, FirstName, Surname, Address1, Address2, Town, County, Postcode, ContactNo,DOB) Values " +
"(" + id + ", '" + FirstName + "', '" + Surname + "', '" + Address1 + "', '" + Address2 + "', '" + Town + "', '" + County + "', '" + Postcode + "', '" + ContactNo + "', '" + DOB + "')";
//opens the connection to the datbase
SQLiteConnection conn = new SQLiteConnection("Data Source = C:\\SQLite\\CAWT.db; Version = 3;");
conn.Open();
//runs the query and the closes the connection to the database
SQLiteCommand cmd = new SQLiteCommand(query, conn);
cmd.ExecuteNonQuery();
MessageBox.Show("Client Successfully added");
conn.Close();
//navigates the user back to the participants view window after user has been added
ParticipantsView participant = new ParticipantsView();
participant.Show();
this.Close();
}
catch (Exception)
{
MessageBox.Show("Please enter some details");
}
}
//creates an appointment and loads data into the appointments table on the database
private void BtnMakeAppointment_Click(object sender, RoutedEventArgs e)
{
// A try catch statement that asks the user to input data first
try
{
//creates a temporary storage location the users inputs
int id = Convert.ToInt32(txtAppointmentID.Text);
string Time = txtTime.Text;
string Date = txtDate.Text;
string Location = txtLocation.Text;
int Sid = Convert.ToInt32(txtStaffID.Text);
int Pid = Convert.ToInt32(txtParticipantID.Text);
//inserts query that inserts the data into the appointments table on the database
string query = "Insert into Appointments(AppointmentID, Time, Date, Location, StaffID, ParticipantID) Values " +
"(" + id + ", '" + Time + "', '" + Date + "', '" + Location + "', " + Sid + ", " + Pid + ")";
//opens the database connection
SQLiteConnection conn = new SQLiteConnection("Data Source = C:\\SQLite\\CAWT.db; Version = 3;");
conn.Open();
SQLiteCommand cmd = new SQLiteCommand(query, conn);
cmd.ExecuteNonQuery();
MessageBox.Show("Appointment Successfully added");
conn.Close();
//navigates the user back to the participants view window after the insert is complete
ParticipantsView back = new ParticipantsView();
back.Show();
this.Close();
}
catch (Exception)
{
MessageBox.Show("Please enter valid appointment details");
}
}
//Login Button
private void BtnLogin_Click(object sender, RoutedEventArgs e)
{
//Path for the database
SQLiteConnection conn = new SQLiteConnection("Data Source = C:\\SQLite\\CAWT.db; Version = 3; ");
// A try catch statement that asks the user to input data first
try
{
//Opening the database connection
conn.Open();
//Query for the database that selects all users from the login table
string query = "Select * from Login where Username='******' and Password='******'";
SQLiteCommand cmd = new SQLiteCommand(query, conn);
SQLiteDataReader reader = cmd.ExecuteReader();
//creating the admin page requirements
string password = "******";
string userName, enterPassword;
userName = txtUsername.Text;
enterPassword = txtPassword.Password;
//setting the counter to 0 an incrementing it to check for different users
int count = 0;
while (reader.Read())
{
count++;
}
//log in successfully
if (count == 1)
{
MessageBox.Show("Username and Password was correct");
conn.Close();
//directs user with the password "password" to the admin page
if (password.Equals(enterPassword))
{
MessageBox.Show("Welcome admin user");
MainWindow main = new MainWindow();
main.Show();
this.Close();
}
//directs all other users to the user page
else
{
ParticipantsView user = new ParticipantsView();
user.Show();
this.Close();
}
}
//tells the user at login that the username is a duplicate
else if (count > 1)
{
MessageBox.Show("Duplicate Username and Password, Try Again");
}
//tells the user that there login credientals are wrong and try again
else if (count < 1)
{
MessageBox.Show("Invalid, please try again");
}
}
// error checker to check and display exceptions
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
