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); } }