public object Get(SearchQuestions request)
{
var query = Db.From <Question>();
if (request.Tags != null && request.Tags.Count > 0)
{
query.Join <QuestionTag>((q, t) => q.QuestionId == t.QuestionId)
.Where <QuestionTag>(x => Sql.In(x.Tag, request.Tags));
}
var response = new SearchQuestionsResponse
{
Results = Db.Select(query)
};
return(response);
}
private async void GetQuestions()
{
var task = new SearchQuestions().GetDataAsync(txtSearchQuery.Text);
try
{
var result = await task;
dataGridView2.DataSource = result;
if (result.Count == 0)
{
timer2.Stop();
lblLoading2.Hide();
lblCountGrid2.Text = "0 - No results found!";
}
}
catch (Exception ex)
{
MessageBox.Show("Please check if you are connected to the internet. If you have not used the VPN Google may block your IP, stop using the app immediately! " + ex.Message, "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1);
}
}
