}//UpdateDBData ends
/// <summary>
/// Public method that is in charge to add records to the TASK table.
/// </summary>
public void CreateTask(Persistence.Task Task)
{
try
{
using (var connection = new Persistence.LHEntities())
{
var task = new Persistence.Task
{
Task_Description = Task.Task_Description,
Task_Date = DateTime.Today,
};
connection.Tasks.Add(task);
connection.SaveChanges();
}
}
catch (DbEntityValidationException e)
{
var exception = Util.HandleDbEntityValidationException(e);
throw exception;
}
catch (DbUpdateException e)
{
var exception = Util.HandleDbUpdateException(e);
throw exception;
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}//create task ends
public void TestAddTask()
{
try
{
var data = new List <ProjectManager.Persistence.Task>()
{
}.AsQueryable();
var mockSet = new Mock <DbSet <ProjectManager.Persistence.Task> >();
mockSet.As <IQueryable <ProjectManager.Persistence.Task> >().Setup(m => m.Provider).Returns(data.Provider);
mockSet.As <IQueryable <ProjectManager.Persistence.Task> >().Setup(m => m.Expression).Returns(data.Expression);
mockSet.As <IQueryable <ProjectManager.Persistence.Task> >().Setup(m => m.ElementType).Returns(data.ElementType);
mockSet.As <IQueryable <ProjectManager.Persistence.Task> >().Setup(m => m.GetEnumerator()).Returns(data.GetEnumerator());
mockSet.As <IQueryable <ProjectManager.Persistence.Task> >().Setup(m => m.Provider).Returns(data.Provider);
Task Task = new Persistence.Task {
ProjectId = 25, TaskName = "Support Test Driven Development", IsParentTask = true, Priority = 2, ParentTask = 5, StartDate = new DateTime(2018, 8, 12), EndDate = DateTime.Now, UserId = 20
};
var mockContext = new Mock <ProjectManagerContext>();
mockContext.Setup(m => m.tasks).Returns(mockSet.Object);
var service = new TaskRepository(mockContext.Object);
List <Task> TaskList = service.GetAllTasks();
Assert.That(TaskList.Count == 0);
bool ret = service.AddTask(Task);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Assert.That(1 == 0);
}
}
/// <summary>
/// Public method that queries the task table from the data base to get the record
/// that matches the Task_ID.
/// </summary>
/// <param name="idTask"> Task_ID, Type INT </param>
public void UpdateDBData(int idTask, Persistence.Task Task)
{
try
{
using (var connection = new Persistence.LHEntities())
{
var task = connection.Tasks
.Where(t => t.Task_ID == idTask)
.FirstOrDefault();
task.Task_Description = Task.Task_Description;
task.Task_Date = Task.Task_Date;
connection.SaveChanges();
}
}
catch (DbEntityValidationException e)
{
var exception = Util.HandleDbEntityValidationException(e);
throw exception;
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}//UpdateDBData ends