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)); }