public async Task <ExecutionStatus> Run(CallForSpeechId id, JudgeId judge, CallForSpeechStatus status) { using var connection = new SqliteConnection(_geekLemonContext.ConnectionString); var q = @"UPDATE CallForSpeakes SET FinalDecision_DecisionBy = @JudgeId, FinalDecision_Date = @Date, Status = @Status WHERE Id = @Id;"; try { var result = await connection.ExecuteAsync(q, new { @JudgeId = judge.Value, @Date = AppTime.Now().ToLongDateString(), @Id = id.Value, @Status = (int)status }); return(ExecutionStatus.DbOk()); } catch (Exception ex) { if (ExecutionFlow.Options.ThrowExceptions) { throw; } return(ExecutionStatus.DbError(ex)); } }
public async Task <ExecutionStatus <CallForSpeech> > Run(CallForSpeechId id) { using var connection = new SqliteConnection (_geekLemonContext.ConnectionString); 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 async Task <ExecutionStatus> Run(CallForSpeechId id, CallForSpeechScoringResult score, CallForSpeechStatus status) { using var connection = new SqliteConnection(_geekLemonContext.ConnectionString); var q = @"UPDATE CallForSpeakes SET Score_Score = @Score, Score_RejectExplanation = @RejectExplanation, Score_WarringExplanation = @WarringExplanation, Status = @Status WHERE Id = @Id;"; try { var result = await connection.ExecuteAsync(q, new { @Score = (int)score.Score, @WarringExplanation = score.WarringExplanation, @RejectExplanation = score.RejectExplanation, @Id = id.Value, @Status = (int)status }); return(ExecutionStatus.DbOk()); } catch (Exception ex) { if (ExecutionFlow.Options.ThrowExceptions) { throw; } return(ExecutionStatus.DbError(ex)); } }
public Task <ExecutionStatus> SavePreliminaryAcceptenceAsync(CallForSpeechId id, JudgeId judge, CallForSpeechStatus status) { return(_callForSpeechSavePreliminaryAcceptenceDoer.Run(id, judge, status)); }
public Task <ExecutionStatus> SaveEvaluatationAsync(CallForSpeechId id, CallForSpeechScoringResult score, CallForSpeechStatus status) { return(_callForSpeechSaveEvaluatationDoer.Run(id, score, status)); }
public Task <ExecutionStatus <CallForSpeech> > GetByIdAsync(CallForSpeechId id) { return(_callForSpeechGetByIdDoer.Run(id)); }
public Task <ExecutionStatus> SaveRejectionAsync(CallForSpeechId id, JudgeId judge, CallForSpeechStatus status) { return(_callForSpeechSaveRejectionDoer.Run(id, judge, status)); }