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