public static int DoRegisterNewUser(UserInfo NewUser)
{
return DoRegisterNewuserindb(NewUser);
}
private static int DoRegisterNewuserindb(UserInfo NewUser)
{
int returnVal = 0;
MySql.Data.MySqlClient.MySqlConnection msqlConnection = OpenDbConnection();
try
{
//define the command reference
MySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand();
//define the connection used by the command object
msqlCommand.Connection = msqlConnection;
msqlCommand.CommandText = "INSERT INTO user(id,userid,passwrd,hints) " + "VALUES(@id,@userid,@passwrd,@hints)";
msqlCommand.Parameters.AddWithValue("@id", NewUser.userId);
msqlCommand.Parameters.AddWithValue("@userid", NewUser.userId);
msqlCommand.Parameters.AddWithValue("@passwrd", NewUser.userName);
msqlCommand.Parameters.AddWithValue("@hints", NewUser.deviceOwned);
msqlCommand.ExecuteNonQuery();
returnVal = 1;
}
catch (Exception er)
{
returnVal = 0;
}
finally
{
//always close the connection
msqlConnection.Close();
}
return returnVal;
}