public void CreateProcessingTime(ProcessingTimeEntity task)
{
task.Id = GetGlobalCounter();
int numberOfRow = RunCommand($"INSERT INTO {TableNames.ProcessingTimes} (Id, Every, Replay, InitialDate) VALUES ({task.Id}, {task.Every}, {ProcessingDateReplayHelper.ProcessingDateReplayToId(task.Replay)}, '{task.InitialDate}');");
IsRowEffected(numberOfRow, "Beim Erstellen des Nutzers ist ein Fehler aufgetreten.");
}
public static ProcessingTimeEntity GetProcessingTime()
{
ProcessingTimeEntity processingTime = new ProcessingTimeEntity
{
Id = processingTimeId,
InitialDate = initialDate,
Replay = ProcessingDateReplay.Daily
};
return(processingTime);
}
public void CreateOrUpdate(ProcessingTimeEntity time)
{
if (time.Id == 0)
{
CreateProcessingTime(time);
}
else
{
UpdateProcessingTime(time);
}
}
public void InitTest()
{
DateTime initialDate = DateTime.Now;
ProcessingTimeEntity processingTime = new ProcessingTimeEntity
{
InitialDate = initialDate,
Replay = ProcessingDateReplay.Daily
};
Assert.IsNotNull(processingTime);
Assert.AreEqual(initialDate, processingTime.InitialDate);
Assert.AreEqual(ProcessingDateReplay.Daily, processingTime.Replay);
}
public void GetNextWorkingTime_Yearly_Test()
{
ProcessingTimeEntity processingTime = HouseholdTaskTest.GetProcessingTime();
processingTime.InitialDate = DateTime.ParseExact("01.01.2020 12:00:00", "dd.MM.yyyy HH:mm:ss", CultureInfo.CurrentCulture);
processingTime.Replay = ProcessingDateReplay.Yearly;
NextWorkingTimeService service = new NextWorkingTimeService
{
ProcessingTime = processingTime
};
DateTime expectedDate = DateTime.ParseExact("01.01.2021 12:00:00", "dd.MM.yyyy HH:mm:ss", CultureInfo.CurrentCulture);
DateTime actualDate = service.GetNextWorkingTime();
Assert.IsNotNull(actualDate);
Assert.AreEqual(expectedDate, actualDate);
}
public void InitTest()
{
HouseholdTaskEntity householdTask = GetHouseholdTask();
Assert.IsNotNull(householdTask);
Assert.AreEqual(id, householdTask.Id);
Assert.AreEqual(creatorId, householdTask.CreatorId);
Assert.AreEqual(description, householdTask.Description);
Assert.AreEqual(title, householdTask.Title);
Assert.AreEqual(processingTimeId, householdTask.ProcessingTimeId);
ProcessingTimeEntity processingTime = GetProcessingTime();
Assert.IsNotNull(processingTime);
Assert.AreEqual(processingTimeId, processingTime.Id);
Assert.AreEqual(initialDate, processingTime.InitialDate);
Assert.AreEqual(ProcessingDateReplay.Daily, processingTime.Replay);
}
public void GetCreateOrUpdateProcessingTimesTest()
{
CreateOrUpdateProcessingTimeTest();
List <ProcessingTimeEntity> times = access.GetProcessingTimes();
Assert.IsNotNull(times);
Assert.AreEqual(2, times.Count);
ProcessingTimeEntity time1 = times.First();
Assert.AreEqual(1, time1.Id);
Assert.AreEqual(DateTime.Parse("01.01.2020 12:00:00"), time1.InitialDate);
Assert.AreEqual(ProcessingDateReplay.Weekly, time1.Replay);
ProcessingTimeEntity time2 = times.Last();
Assert.AreEqual(2, time2.Id);
Assert.AreEqual(DateTime.Parse("01.01.2020 13:00:00"), time2.InitialDate);
Assert.AreEqual(ProcessingDateReplay.Once, time2.Replay);
}
public void CreateOrUpdateProcessingTimeTest()
{
access.InitDataBase();
int version = access.GetCounter(CounterNames.GlobalCounter);
Assert.AreEqual(1, version);
ProcessingTimeEntity time1 = new ProcessingTimeEntity
{
InitialDate = DateTime.Parse("01.01.2020 12:00:00"),
Replay = ProcessingDateReplay.Once
};
access.CreateOrUpdate(time1);
Assert.AreEqual(1, time1.Id);
version = access.GetCounter(CounterNames.GlobalCounter);
Assert.AreEqual(time1.Id + 1, version);
time1.Replay = ProcessingDateReplay.Weekly;
access.CreateOrUpdate(time1);
version = access.GetCounter(CounterNames.GlobalCounter);
Assert.AreEqual(time1.Id + 1, version);
ProcessingTimeEntity time2 = new ProcessingTimeEntity
{
InitialDate = DateTime.Parse("01.01.2020 13:00:00"),
Replay = ProcessingDateReplay.Once
};
access.CreateOrUpdate(time2);
Assert.AreEqual(2, time2.Id);
version = access.GetCounter(CounterNames.GlobalCounter);
Assert.AreEqual(time2.Id + 1, version);
}
public void UpdateProcessingTime(ProcessingTimeEntity task)
{
int numberOfRow = RunCommand($"UPDATE {TableNames.ProcessingTimes} SET Every = {task.Every}, Replay={ProcessingDateReplayHelper.ProcessingDateReplayToId(task.Replay)}, InitialDate='{task.InitialDate}' WHERE Id = {task.Id};");
IsRowEffected(numberOfRow, "Beim Ändern des Nutzers ist ein Fehler aufgetreten.");
}