public string Register(UserRegisterationForm registerSerial)
{
var db = new DBConnector();
var queryBuilder = new StringBuilder("SELECT registerSerial FROM users WHERE username = @user");
var command = new MySqlCommand(queryBuilder.ToString());
command.Parameters.AddWithValue("@user", registerSerial.username);
var result = db.ExecuteQuery(command);
string serial = "";
while (result.Read())
{
serial = result.GetString(0);
}
if (serial == "")
{
db.CloseConnection();
}
return("fault");
if (serial == registerSerial.registerSerial)
{
queryBuilder = new StringBuilder("UPDATE users SET registered=TRUE WHERE username = @user");
command = new MySqlCommand(queryBuilder.ToString());
command.Parameters.AddWithValue("@user", registerSerial.username);
var update = db.ExecuteNonQuery(command);
db.CloseConnection();
if (update > 0)
{
return("success");
}
else
{
return("fault");
}
}
else
{
db.CloseConnection();
}
return("failed");
}
public string Post([FromBody] UserRegisterationForm value)
{
DBRequest request = new DBRequest();
return(request.Register(value));
}
