public List <HistoryTaskEntity> GetHistoryTasks()
{
List <HistoryTaskEntity> output = new List <HistoryTaskEntity>();
using (var connection = GetConnection())
{
connection.Open();
var command = connection.CreateCommand();
command.CommandText = $"SELECT Id, TaskId, EditorId, Date, Status FROM {TableNames.HistoryTasks};";
using var reader = command.ExecuteReader();
while (reader.Read())
{
var id = reader.GetInt32(0);
var taskId = reader.GetInt32(1);
var editorId = reader.GetString(2);
var date = reader.GetDateTime(3);
var status = reader.GetInt32(4);
output.Add(new HistoryTaskEntity
{
Id = id,
TaskId = taskId,
EditorId = editorId,
Date = date,
Status = ProcessingStatusHelper.IdToProcessingStatus(status)
});
}
}
return(output);
}
public void UpdateHistoryTask(HistoryTaskEntity task)
{
int numberOfRow = RunCommand($"UPDATE {TableNames.HistoryTasks} SET TaskId = '{task.TaskId}',EditorId = '{task.EditorId}', Date ='{task.Date}', Status = {ProcessingStatusHelper.ProcessingStatusToId(task.Status)} WHERE Id = {task.Id};");
IsRowEffected(numberOfRow, "Beim Ändern des Nutzers ist ein Fehler aufgetreten.");
}
public void CreateHistoryTask(HistoryTaskEntity task)
{
task.Id = GetGlobalCounter();
int numberOfRow = RunCommand($"INSERT INTO {TableNames.HistoryTasks} (Id, TaskId, EditorId, Date, Status) VALUES ({task.Id}, {task.TaskId}, '{task.EditorId}', '{task.Date}', {ProcessingStatusHelper.ProcessingStatusToId(task.Status)} );");
IsRowEffected(numberOfRow, "Beim Erstellen des Nutzers ist ein Fehler aufgetreten.");
}
