public void RegisterUserInDB(string name, string surname, DateTime dob, string email, string password, DBSelection SelectDB)
{
DataBaseConnection DBConnection = new DataBaseConnection();
if (SelectDB == DBSelection.MySql)
{
using (MySqlConnection connection = DBConnection.GetMySqlConnection())
{
MySqlCommand command = new MySqlCommand();
command.Connection = connection;
command.CommandType = CommandType.Text;
command.CommandText = "INSERT INTO users (FirstName, LastName, DateOfBirth, Email, Password) VALUES (@FirstName, @LastName, @DateOfBirth, @Email, @Password)";
command.Parameters.AddWithValue("@FirstName", name);
command.Parameters.AddWithValue("@LastName", surname);
command.Parameters.AddWithValue("@DateOfBirth", dob);
command.Parameters.AddWithValue("@Email", email);
command.Parameters.AddWithValue("@Password", password);
try
{
connection.Open();
command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("Error message:" + ex.Message, "ERROR !!!");
}
}
}
else if (SelectDB == DBSelection.SqlServer)
{
using (SqlConnection connection = DBConnection.GetSqlConnection())
{
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandType = CommandType.Text;
command.CommandText = "INSERT INTO [users] ([Name], [Surname], [DateOfBirth], [Email], [Password]) VALUES (@Name, @Surname, @DateOfBirth, @Email, @Password)";
command.Parameters.AddWithValue("@Name", name);
command.Parameters.AddWithValue("@Surname", surname);
command.Parameters.AddWithValue("@DateOfBirth", dob);
command.Parameters.AddWithValue("@Email", email);
command.Parameters.AddWithValue("@Password", password);
try
{
connection.Open();
command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("Error message:" + ex.Message, "ERROR !!!");
}
}
}
MessageBox.Show("Account successfully created !", "Hoooray !!!");
}
public DBDiffUtility(DBSelection selection, string Path1, string Path2)
{
Selection = selection;
this.Path1 = Path1;
this.Path2 = Path2;
}
public void RegisterUser(string name, string surname, DateTime dateOfBirth, string email, string password, DBSelection selectDB)
{
PasswordEncrypter encrypter = new PasswordEncrypter();
RegisterUserInDb registration = new RegisterUserInDb();
registration.RegisterUserInDB(name, surname, dateOfBirth, email, encrypter.encryptPassword(password), selectDB);
}
