public Project GetByName(string Name)
{
using (ProjectManagerContext db = new ProjectManagerContext())
{
return(db.Projects.SingleOrDefault(k => k.ProjectName == Name));
}
}
public static ProjectManagerContext Start()
{
var options = new DbContextOptionsBuilder <ProjectManagerContext>()
.UseInMemoryDatabase(databaseName: "save")
.Options;
// Run the test against one instance of the context
var context = new ProjectManagerContext(options, null);
context.Projects.Add(new Project
{
Name = "teste1",
InitialDate = DateTime.Now,
FinalDate = DateTime.Now.AddMonths(1),
PercentComplete = 0,
Late = false,
});
context.SaveChanges();
context.Activities.Add(new Activity
{
Name = "teste1",
InitialDate = DateTime.Now,
FinalDate = DateTime.Now.AddDays(1),
ProjectId = 1,
Finished = false
});
context.SaveChanges();
return(context);
}
// Add new Task
public void AddParentTask(ParentTask newTask)
{
ProjectManagerContext dbCtxt = new ProjectManagerContext();
dbCtxt.ParentTasks.Add(newTask);
dbCtxt.SaveChanges();
}
//Get Completed Tasks
public List <Task> GetCompletedTasksByProjectId(int projectId)
{
ProjectManagerContext dbCtxt = new ProjectManagerContext();
var tasks = dbCtxt.Tasks.Where(m => m.Project_ID == projectId && m.TaskEndDate < DateTime.Now);
return(tasks.ToList());
}
public List <Project> GetAll()
{
using (ProjectManagerContext db = new ProjectManagerContext())
{
return(db.Projects.ToList());
}
}
private void DeleteDB()
{
using (ProjectManagerContext _dbContext = CreateContext())
{
_dbContext.Database.EnsureDeleted();
}
}
public void SaveNormal()
{
var options = new DbContextOptionsBuilder <ProjectManagerContext>()
.UseInMemoryDatabase(databaseName: "save")
.Options;
using (var context = new ProjectManagerContext(options, null))
{
var repoP = new ProjectRepository(context);
var service = new ProjectService(repoP);
var newP = service.Save(new Project
{
Name = "teste1",
InitialDate = DateTime.Now,
FinalDate = DateTime.Now.AddDays(1),
PercentComplete = 0,
Late = false,
Removed = false
}).Result;
Assert.NotNull(newP);
}
}
/// <summary>
/// Method to get only one user from the database
/// </summary>
/// <Return>users with details</return>
public List <Project> GetFilteredProjects(string searchBy)
{
List <Project> projects = new List <Project>();
DateTime dDate;
using (ProjectManagerContext db = new ProjectManagerContext())
{
if (Regex.IsMatch(searchBy, @"^\d+$"))
{
long searchId = Convert.ToInt64(searchBy);
projects = db.Project.Where(data => data.Priority != null &&
data.Priority.ToString().Contains(searchBy)).ToList();
}
else if (DateTime.TryParse(searchBy, out dDate))
{
String.Format("{0:yyyy/MM/dd}", dDate);
projects = db.Project.Where(data => data.Start_Date >= dDate ||
data.End_Date >= dDate).ToList();
}
else
{
projects = db.Project.Where(data => data.Project_Name.Contains(searchBy)).ToList();
}
return(projects);
}
}
public Project GetById(int Id)
{
using (ProjectManagerContext db = new ProjectManagerContext())
{
return(db.Projects.SingleOrDefault(k => k.ProjectId == Id));
}
}
public void ValidDatesEquals()
{
var options = new DbContextOptionsBuilder <ProjectManagerContext>()
.UseInMemoryDatabase(databaseName: "save")
.Options;
using (var context = new ProjectManagerContext(options, null))
{
var repoA = new ActivityRepository(context);
var service = new ActivityService(repoA);
try
{
var date = DateTime.Now;
service.ValidDates(date, date);
Assert.True(true);
}
catch {
Assert.True(false);
}
}
}
public void GetAll()
{
var options = new DbContextOptionsBuilder <ProjectManagerContext>()
.UseInMemoryDatabase(databaseName: "save")
.Options;
using (var context = new ProjectManagerContext(options, null))
{
context.Projects.Add(new Project
{
Name = "teste1",
InitialDate = DateTime.Now,
FinalDate = DateTime.Now.AddMonths(1),
PercentComplete = 0,
Late = false,
Removed = false
});
context.SaveChanges();
}
using (var context = new ProjectManagerContext(options, null))
{
var repoP = new ProjectRepository(context);
var service = new ProjectService(repoP);
var projects = service.GetAll().Result;
Assert.Equal(3, projects.Count);
}
}
//Add New User
public void AddUser(User newUser)
{
ProjectManagerContext dbCtxt = new ProjectManagerContext();
dbCtxt.Users.Add(newUser);
dbCtxt.SaveChanges();
}
// Add New Project
public void AddProject(Project newProject)
{
ProjectManagerContext dbCtxt = new ProjectManagerContext();
dbCtxt.Projects.Add(newProject);
dbCtxt.SaveChanges();
}
//[HttpGet]
public void AddProject(Project item)
{
using (ProjectManagerContext db = new ProjectManagerContext())
{
db.Projects.Add(item);
db.SaveChanges();
}
}
/// <summary>
/// Method to add the task to the database
/// </summary>
/// <param name="item">Task with details</param>
public void AddTask(Task item)
{
using (ProjectManagerContext db = new ProjectManagerContext())
{
db.Task.Add(item);
db.SaveChanges();
}
}
public void AddUser(User item)
{
using (ProjectManagerContext db = new ProjectManagerContext())
{
db.User.Add(item);
db.SaveChanges();
}
}
private List <Project> GetAllProjects()
{
using (ProjectManagerContext _dbContext = CreateContext())
{
IProjectRepository _repo = new ProjectRepository(_dbContext);
var controller = new ProjectController(_repo);
return(controller.GetAllProjects());
}
}
private ParentTask GetFirstParentTask()
{
using (ProjectManagerContext _dbContext = CreateContext())
{
ITaskRepository _repo = new TaskRepository(_dbContext);
var controller = new TaskController(_repo);
return(controller.GetAllParentTasks().First());
}
}
private bool UpdateProject(Project project)
{
using (ProjectManagerContext _dbContext = CreateContext())
{
IProjectRepository _repo = new ProjectRepository(_dbContext);
var controller = new ProjectController(_repo);
return(controller.UpdateProject(project));
}
}
private Project GetProject(int id)
{
using (ProjectManagerContext _dbContext = CreateContext())
{
IProjectRepository _repo = new ProjectRepository(_dbContext);
var controller = new ProjectController(_repo);
return(controller.GetProject(id));
}
}
private List <User> GetAllUsers()
{
using (ProjectManagerContext _dbContext = CreateContext())
{
IUserRepository _repo = new UserRepository(_dbContext);
var controller = new UserController(_repo);
return(controller.GetAllUsers());
}
}
private bool AddUser(User user)
{
using (ProjectManagerContext _dbContext = CreateContext())
{
IUserRepository _repo = new UserRepository(_dbContext);
var controller = new UserController(_repo);
return(controller.AddUser(user));
}
}
private List <Task> GetAllTypesOfTasks()
{
using (ProjectManagerContext _dbContext = CreateContext())
{
ITaskRepository _repo = new TaskRepository(_dbContext);
var controller = new TaskController(_repo);
return(controller.GetAllTypeOfTasks());
}
}
private Task GetTask(int id)
{
using (ProjectManagerContext _dbContext = CreateContext())
{
ITaskRepository _repo = new TaskRepository(_dbContext);
var controller = new TaskController(_repo);
return(controller.GetTask(id, false));
}
}
private User GetUser(int id)
{
using (ProjectManagerContext _dbContext = CreateContext())
{
IUserRepository _repo = new UserRepository(_dbContext);
var controller = new UserController(_repo);
return(controller.GetUser(id));
}
}
private bool DeleteTask(Task task)
{
using (ProjectManagerContext _dbContext = CreateContext())
{
ITaskRepository _repo = new TaskRepository(_dbContext);
var controller = new TaskController(_repo);
return(controller.DeleteTask(task));
}
}
// Get All Users
public List <User> GetAllUsers()
{
ProjectManagerContext dbCtxt = new ProjectManagerContext();
List <User> UserList = new List <User>();
UserList = dbCtxt.Users.ToList();
UserList = UserList.ToList();
return(UserList);
}
/// <summary>
/// Method to get all user from the database
/// </summary>
/// <Return>users with details</return>
public List <Project> GetAllProjects()
{
//from p in context.ParentTable
//let cCount =
//(
// from c in context.ChildTable
// where p.ParentId == c.ChildParentId
// select c
//).Count()
//select new { ParentId = p.Key, Count = cCount };
List <Project> projects = new List <Project>();
using (ProjectManagerContext db = new ProjectManagerContext())
{
//projects = db.Project.ToList();
//return projects;
var data = from p in db.Project
let numberoftasks =
(from t in db.Task
where p.Project_ID == t.Project_ID
select t).Count()
let completed =
(from t in db.Task
where p.Project_ID == t.Project_ID && t.Status == true
select t).Count()
select new
{
p.Project_ID,
p.Project_Name,
NumberofTasks = numberoftasks,
Completed = completed,
p.Priority,
p.Start_Date,
p.End_Date
};
if (data != null)
{
foreach (var val in data)
{
Project pt = new Project();
pt.Project_ID = val.Project_ID;
pt.Project_Name = val.Project_Name;
pt.Start_Date = val.Start_Date;
pt.End_Date = val.End_Date;
pt.NumberOfTasks = val.NumberofTasks;
pt.Completed = val.Completed;
pt.Priority = val.Priority;
projects.Add(pt);
}
}
return(projects);
}
}
/// <summary>
/// Method to get all the existing tasks from database
/// </summary>
/// <returns>Returns list of task from databse</returns>
public List <ParentTask> GetParentTasks()
{
List <ParentTask> tasks = new List <ParentTask>();
using (ProjectManagerContext db = new ProjectManagerContext())
{
tasks = db.ParentTask.ToList();
return(tasks);
}
}
private bool AddTask(Task task)
{
using (ProjectManagerContext _dbContext = CreateContext())
{
ITaskRepository _repo = new TaskRepository(_dbContext);
var controller = new TaskController(_repo);
var result = controller.AddTask(task);
return(result);
}
}
