public void GetHistoryTasksTest()
{
CreateOrUpdateHistoryTaskTest();
List <HistoryTaskEntity> tasks = access.GetHistoryTasks();
Assert.IsNotNull(tasks);
Assert.AreEqual(2, tasks.Count);
HistoryTaskEntity task1 = tasks.First();
Assert.AreEqual(1, task1.Id);
Assert.AreEqual(1, task1.TaskId);
Assert.AreEqual("2", task1.EditorId);
Assert.AreEqual(DateTime.Parse("01.01.2020 12:00:00"), task1.Date);
Assert.AreEqual(ProcessingStatus.Done, task1.Status);
HistoryTaskEntity task2 = tasks.Last();
Assert.AreEqual(2, task2.Id);
Assert.AreEqual(2, task2.TaskId);
Assert.AreEqual("3", task2.EditorId);
Assert.AreEqual(DateTime.Parse("01.01.2020 13:00:00"), task2.Date);
Assert.AreEqual(ProcessingStatus.NotDone, task2.Status);
}
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.");
}
public void CreateOrUpdate(HistoryTaskEntity task)
{
if (task.Id == 0)
{
CreateHistoryTask(task);
}
else
{
UpdateHistoryTask(task);
}
}
public void CreateOrUpdateHistoryTaskTest()
{
access.InitDataBase();
int version = access.GetCounter(CounterNames.GlobalCounter);
Assert.AreEqual(1, version);
HistoryTaskEntity task = new HistoryTaskEntity
{
TaskId = 1,
EditorId = "2",
Date = DateTime.Parse("01.01.2020 12:00:00"),
Status = ProcessingStatus.InProgress
};
access.CreateOrUpdate(task);
Assert.AreEqual(1, task.Id);
version = access.GetCounter(CounterNames.GlobalCounter);
Assert.AreEqual(task.Id + 1, version);
task.Status = ProcessingStatus.Done;
access.CreateOrUpdate(task);
version = access.GetCounter(CounterNames.GlobalCounter);
Assert.AreEqual(task.Id + 1, version);
HistoryTaskEntity task2 = new HistoryTaskEntity
{
TaskId = 2,
EditorId = "3",
Date = DateTime.Parse("01.01.2020 13:00:00"),
Status = ProcessingStatus.NotDone
};
access.CreateOrUpdate(task2);
Assert.AreEqual(2, task2.Id);
version = access.GetCounter(CounterNames.GlobalCounter);
Assert.AreEqual(task2.Id + 1, version);
}
public void InitTest()
{
int id = 1;
int taskId = 2;
string editorId = "3";
DateTime date = DateTime.Now;
HistoryTaskEntity taskHistory = new HistoryTaskEntity
{
Id = id,
Date = date,
EditorId = editorId,
TaskId = taskId,
Status = ProcessingStatus.InProgress
};
Assert.IsNotNull(taskHistory);
Assert.AreEqual(id, taskHistory.Id);
Assert.AreEqual(taskId, taskHistory.TaskId);
Assert.AreEqual(editorId, taskHistory.EditorId);
Assert.AreEqual(date, taskHistory.Date);
Assert.AreEqual(ProcessingStatus.InProgress, taskHistory.Status);
}
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.");
}
