public async Task <ExecutionStatus <IReadOnlyList <CallForSpeech> > > Run(FilterCallForSpeechStyles filtrer)
{
using var connection = new SqliteConnection
(_geekLemonContext.ConnectionString);
IEnumerable <CallForSpeechTemp> r;
var q = @$ "SELECT
c.UniqueId ,c.Version,
c.Id,c.Number,c.Status,c.PreliminaryDecision_DecisionBy,
c.PreliminaryDecision_Date,c.FinalDecision_DecisionBy,
c.FinalDecision_Date,c.Speaker_Name_First,c.Speaker_Name_Last,
c.Speaker_Adress_Country,c.Speaker_Adress_ZipCode, c.Speaker_Adress_City,
c.Speaker_Adress_Street,c.Speaker_Websites_Facebook,c.Speaker_Websites_Twitter,
c.Speaker_Websites_Instagram,c.Speaker_Websites_LinkedIn,c.Speaker_Websites_TikTok,
c.Speaker_Websites_Youtube,c.Speaker_Websites_FanPageOnFacebook,c.Speaker_Websites_GitHub,
c.Speaker_Websites_Blog, c.Speaker_BIO,
c.Speaker_Contact_Phone,c.Speaker_Contact_Email, c.Speech_Tags,
c.Speech_ForWhichAudience,c.Speech_TechnologyOrBussinessStory,c.Registration_RegistrationDate,
c.CategoryId,c.Score_Score, c.Score_RejectExplanation,c.Score_WarringExplanation,
c.Speaker_Birthdate,c.Speech_Title,c.Speech_Description,
k.Name AS {nameof(JudgeTemp.Category_Name)},
public Task <ExecutionStatus <IReadOnlyList <CallForSpeech> > > GetCollectionAsync(FilterCallForSpeechStyles filtrer)
{
return(_callForSpeechGetCollectionDoer.Run(filtrer));
}
