public void ChangeStatus(string investigationId, InvestigationStatuses status)
{
using (var conn = new SqlConnection(this.ConnectionStringProvider.GetConnectionString()))
{
var res = conn.Execute(InvestigationsQueries.ChangeStatusQuery(status), new { investigationId });
if (res == 0)
{
throw new InvalidOperationException("Error has occured!");
}
}
}
public static string ChangeStatusQuery(InvestigationStatuses status) =>
$@"UPDATE [dbo].[InvestigationsData] SET [Status] = {(int)status}
WHERE InvestigationId = @InvestigationId;";
