public static async Task <sellerRequest> readSellerRequest(int id)
{
sellerRequest request = new sellerRequest();
await databaseManager.selectQuery("SELECT * FROM sellerrequests WHERE userId = @id", delegate(DbDataReader reader)
{
if (reader.HasRows)
{
request.username = (String)reader["username"];
request.age = (int)reader["age"];
request.date = (DateTime)reader["date"];
request.userId = (int)reader["userId"];
request.nationality = (string)reader["nationality"];
request.description = (string)reader["description"];
request.question = (string)reader["question"];
request.phoneNumber = (string)reader["phoneNumber"];
}
}).addValue("@id", id).Execute();
return(request);
}
public static async Task <List <sellerRequest> > readAllSellerRequests()
{
List <sellerRequest> dataToReturn = new List <sellerRequest>();
await databaseManager.selectQuery("SELECT * FROM sellerrequests", delegate(DbDataReader reader)
{
if (reader.HasRows)
{
sellerRequest request = new sellerRequest();
request.username = (String)reader["username"];
request.age = (int)reader["age"];
request.nationality = (string)reader["nationality"];
request.description = (string)reader["description"];
request.userId = (int)reader["userId"];
request.date = (DateTime)reader["date"];
request.question = (string)reader["question"];
dataToReturn.Add(request);
}
}).Execute();
return(dataToReturn);
}
