public RetrievedUserForm RetrievePersonToGift(ReceivedRequestForm secretSanta)
{
var retrieved = new RetrievedUserForm();
var db = new DBConnector();
var queryBuilder = new StringBuilder("SELECT * FROM users (")
.Append("SELECT targetuserID FROM @eventdb WHERE hostuser = @host AS target )")
.Append("WHERE userID = target;");
var command = new MySqlCommand(queryBuilder.ToString());
command.Parameters.AddWithValue("@eventdb", secretSanta.eventName);
command.Parameters.AddWithValue("@host", secretSanta.username);
var result = db.ExecuteQuery(command);
db.CloseConnection();
while (result.Read())
{
retrieved.firstname = result.GetString(result.GetOrdinal("firstname"));
retrieved.gender = result.GetChar(result.GetOrdinal("gender"));
retrieved.address = result.GetString(result.GetOrdinal("address"));
retrieved.city = result.GetString(result.GetOrdinal("city"));
retrieved.state = result.GetString(result.GetOrdinal("state"));
retrieved.country = result.GetString(result.GetOrdinal("country"));
retrieved.postal = result.GetString(result.GetOrdinal("postal"));
retrieved.aboutMe = result.GetString(result.GetOrdinal("aboutme"));
retrieved.wishList = result.GetString(result.GetOrdinal("wishlist"));
}
return(retrieved);
}
public RetrievedUserForm Post([FromBody] ReceivedRequestForm value)
{
DBRequest request = new DBRequest();
return(request.RetrievePersonToGift(value));
}
