public void FoundbyId()
{
ToDoTableRow FirstToDo = _repo.GetById(0);
ToDoTableRow SecondToDo = _repo.GetById(1);
ToDoTableRow ThirdToDo = _repo.GetById(2);
Assert.AreEqual("(Mock Repo0) Go for a bike ride near home.", FirstToDo.Name);
Assert.AreEqual("(Mock Repo1) Go for a bike ride far from home.", SecondToDo.Name);
Assert.AreEqual("(Mock Repo2) Oil bike chain", ThirdToDo.Name);
}
public void AddNewTodoForTesting()
{
ToDoTableRow newToDo = new ToDoTableRow();
newToDo.Name = "Fix code.";
newToDo.Completed = true;
newToDo.Note = "Some note";
// MockRepo repo = new MockRepo();
_repo.Create(newToDo);
}
public void CanAddTodo()
{
AddNewTodoForTesting();
ToDoTableRow newestToDo = new ToDoTableRow();
newestToDo = _repo.GetById(3);
Assert.AreEqual("Fix code.", newestToDo.Name);
_repo.Delete(3);
}
public void CanAddTodo()
{
AddNewTodoForTesting();
ToDoTableRow newestToDo = new ToDoTableRow();
newestToDo = _repo.GetById(3);
Assert.AreEqual("Fix code.", newestToDo.Name);
_repo.Delete(3);
//NOTE: Future errs are likely because I do not have a output
//var here, to update the IDs that will likely have changed.
}
public void CanUpdateTodo()
{
AddNewTodoForTesting();
ToDoTableRow updatedToDo = new ToDoTableRow();
updatedToDo = _repo.GetById(3);
updatedToDo.Name = "New name.";
Assert.AreEqual("New name.", updatedToDo.Name);
_repo.Delete(3);
}
public void Create(ToDoTableRow newToDo)
{
if (_ToDos.Any())
{
newToDo.Id = _ToDos.Max(d => d.Id) + 1;
}
else
{
newToDo.Id = 0;
}
_ToDos.Add(newToDo);
}
public void Update(ToDoTableRow updatedToDo)
{
var cn = new SqlConnection();
cn.ConnectionString = "Server=localhost; Database = ToDoXperi;;Trusted_Connection = True;";
// create parameter object
var parameters = new DynamicParameters();
parameters.Add("@Id", updatedToDo.Id);
parameters.Add("@Name", updatedToDo.Name);
parameters.Add("@Completed", updatedToDo.Completed);
parameters.Add("@Note", updatedToDo.Note);
cn.Query <ToDoTableRow>(
"ToDoInsert",
parameters,
commandType: CommandType.StoredProcedure);
}
public void Update(ToDoTableRow updatedToDo)
{
_ToDos.RemoveAll(d => d.Id == updatedToDo.Id);
_ToDos.Add(updatedToDo);
}
