public void Can_Update()
{
var provider = new PetaPocoUnitOfWorkProvider(Logger);
var unitOfWork = provider.GetUnitOfWork();
using (var repo = new TaskRepository(unitOfWork, CacheHelper, Logger, SqlSyntax))
{
var task = new Task(new TaskType("asdfasdf"))
{
AssigneeUserId = 0,
Closed = false,
Comment = "hello world",
EntityId = -1,
OwnerUserId = 0
};
repo.AddOrUpdate(task);
unitOfWork.Commit();
//re-get
task = repo.Get(task.Id);
task.Comment = "blah";
task.Closed = true;
repo.AddOrUpdate(task);
unitOfWork.Commit();
//re-get
task = repo.Get(task.Id);
Assert.AreEqual(true, task.Closed);
Assert.AreEqual("blah", task.Comment);
}
}
private async Task SynchronizeTasks()
{
var tasks = await TaskService.GetUnsynced(AppSettings.LastSyncDate);
TaskRepository.AddOrUpdate(tasks);
await TaskService.SaveNewTasks();
}
public void Can_Add()
{
var provider = new PetaPocoUnitOfWorkProvider(Logger);
var unitOfWork = provider.GetUnitOfWork();
using (var repo = new TaskRepository(unitOfWork, CacheHelper, Logger, SqlSyntax))
{
var created = DateTime.Now;
repo.AddOrUpdate(new Task(new TaskType("asdfasdf"))
{
AssigneeUserId = 0,
Closed = false,
Comment = "hello world",
EntityId = -1,
OwnerUserId = 0
});
unitOfWork.Commit();
var found = repo.GetAll().ToArray();
Assert.AreEqual(1, found.Count());
Assert.AreEqual(0, found.First().AssigneeUserId);
Assert.AreEqual(false, found.First().Closed);
Assert.AreEqual("hello world", found.First().Comment);
Assert.GreaterOrEqual(found.First().CreateDate.TruncateTo(DateTimeExtensions.DateTruncate.Second), created.TruncateTo(DateTimeExtensions.DateTruncate.Second));
Assert.AreEqual(-1, found.First().EntityId);
Assert.AreEqual(0, found.First().OwnerUserId);
Assert.AreEqual(true, found.First().HasIdentity);
Assert.AreEqual(true, found.First().TaskType.HasIdentity);
}
}
public void Can_Delete()
{
var provider = new PetaPocoUnitOfWorkProvider(Logger);
var unitOfWork = provider.GetUnitOfWork();
using (var repo = new TaskRepository(unitOfWork, CacheHelper, Logger, SqlSyntax))
{
var created = DateTime.Now;
var task = new Task(new TaskType("asdfasdf"))
{
AssigneeUserId = 0,
Closed = false,
Comment = "hello world",
EntityId = -1,
OwnerUserId = 0
};
repo.AddOrUpdate(task);
unitOfWork.Commit();
repo.Delete(task);
unitOfWork.Commit();
task = repo.Get(task.Id);
Assert.IsNull(task);
}
}
public void Can_Delete()
{
var provider = new PetaPocoUnitOfWorkProvider(Logger);
var unitOfWork = provider.GetUnitOfWork();
var taskType = new TaskType("asdfasdf");
using (var repo = new TaskRepository(unitOfWork, CacheHelper, Logger, SqlSyntax))
using (var taskTypeRepo = new TaskTypeRepository(unitOfWork, CacheHelper, Logger, SqlSyntax))
{
var created = DateTime.Now;
var task = new Task(taskType)
{
AssigneeUserId = 0,
Closed = false,
Comment = "hello world",
EntityId = -1,
OwnerUserId = 0
};
repo.AddOrUpdate(task);
unitOfWork.Commit();
var alltasktypes = taskTypeRepo.GetAll();
taskTypeRepo.Delete(taskType);
unitOfWork.Commit();
Assert.AreEqual(alltasktypes.Count() - 1, taskTypeRepo.GetAll().Count());
Assert.AreEqual(0, repo.GetAll().Count());
}
}
private void CreateTestData(bool closed, int count, int entityId = -1)
{
var provider = new PetaPocoUnitOfWorkProvider(Logger);
var unitOfWork = provider.GetUnitOfWork();
using (var repo = new TaskRepository(unitOfWork, CacheHelper, Logger, SqlSyntax))
{
for (int i = 0; i < count; i++)
{
repo.AddOrUpdate(new Task(new TaskType("asdfasdf"))
{
AssigneeUserId = 0,
Closed = closed,
Comment = "hello world " + i,
EntityId = entityId,
OwnerUserId = 0
});
unitOfWork.Commit();
}
}
}
