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));
}
