Пример #1
0
        //Delete Existing project Method
        public void DeleteProject(int id)
        {
            ProjectManagerContext dbCtxt = new ProjectManagerContext();
            var deleteProject            = dbCtxt.Projects.Where(m => m.ProjectId == id).FirstOrDefault();

            if (deleteProject != null)
            {
                dbCtxt.Projects.Remove(deleteProject);
                dbCtxt.SaveChanges();
            }
        }
Пример #2
0
        // Update User
        public void UpdateUser(User editUser)
        {
            ProjectManagerContext dbCtxt = new ProjectManagerContext();
            var existingUser             = dbCtxt.Users.Where(m => m.UserId == editUser.UserId).FirstOrDefault();

            existingUser.FirstName  = editUser.FirstName;
            existingUser.LastName   = editUser.LastName;
            existingUser.EmployeeId = editUser.EmployeeId;

            dbCtxt.SaveChanges();
        }
        public void WriteToDatabase(string description, int projectID)
        {
            var activityMonitor = new ActivityMonitor();

            activityMonitor.Timestamp   = DateTime.Now;
            activityMonitor.ProjectID   = projectID;
            activityMonitor.Description = description;

            dbContext.Activities.Add(activityMonitor);
            dbContext.SaveChanges();
        }
Пример #4
0
        //Delete User
        public void DeleteUser(int id)
        {
            ProjectManagerContext dbCtxt = new ProjectManagerContext();
            var deleteUser = dbCtxt.Users.Where(m => m.UserId == id).FirstOrDefault();

            if (deleteUser != null)
            {
                dbCtxt.Users.Remove(deleteUser);
                dbCtxt.SaveChanges();
            }
        }
Пример #5
0
        // end Task
        public void EndTask(int id)
        {
            ProjectManagerContext dbCtxt = new ProjectManagerContext();

            var endTask = dbCtxt.Tasks.Where(m => m.TaskId == id).FirstOrDefault();

            if (endTask != null)
            {
                endTask.Status = false;
                dbCtxt.SaveChanges();
            }
        }
Пример #6
0
 /// <summary>
 /// This is the method to end the existing task based on user interaction
 /// </summary>
 /// <param name="taskID">Task id which needs to be ended</param>
 public void EndTask(int taskID)
 {
     using (ProjectManagerContext db = new ProjectManagerContext())
     {
         var itemToEnd = db.Task.SingleOrDefault(task => task.Task_ID.Equals(taskID));
         if (itemToEnd != null)
         {
             itemToEnd.Status = true;
             db.SaveChanges();
         }
     }
 }
 /// <summary>
 /// Method to delete the task based on the user interaction
 /// </summary>
 /// <param name="taskID">Task Id which needs to be deleted</param>
 public void DeleteUser(int userID)
 {
     using (ProjectManagerContext db = new ProjectManagerContext())
     {
         var itemToDelete = db.User.SingleOrDefault(task => task.User_ID.Equals(userID));
         if (itemToDelete != null)
         {
             db.User.Remove(itemToDelete);
             db.SaveChanges();
         }
     }
 }
Пример #8
0
 /// <summary>
 /// Method to delete the task based on the user interaction
 /// </summary>
 /// <param name="taskID">Task Id which needs to be deleted</param>
 public void DeleteTask(int taskID)
 {
     using (ProjectManagerContext db = new ProjectManagerContext())
     {
         var itemToDelete = db.Task.SingleOrDefault(task => task.Task_ID.Equals(taskID));
         if (itemToDelete != null)
         {
             db.Task.Remove(itemToDelete);
             db.SaveChanges();
         }
     }
 }
 public void DeleteProject(int Id)
 {
     using (ProjectManagerContext db = new ProjectManagerContext())
     {
         var Prj = db.Projects.First(i => i.ProjectId == Id);
         if (Prj != null)
         {
             db.Entry(Prj).State = System.Data.Entity.EntityState.Deleted;
             db.SaveChanges();
         }
     }
 }
Пример #10
0
 public void DeleteUser(int Id)
 {
     using (ProjectManagerContext db = new ProjectManagerContext())
     {
         var Usr = db.Users.First(i => i.UserId == Id);
         if (Usr != null)
         {
             db.Entry(Usr).State = System.Data.Entity.EntityState.Deleted;
             db.SaveChanges();
         }
     }
 }
Пример #11
0
        // delete Task
        public void DeleteTask(int id)
        {
            ProjectManagerContext dbCtxt = new ProjectManagerContext();

            var deleteTask = dbCtxt.Tasks.Where(m => m.TaskId == id).FirstOrDefault();

            if (deleteTask != null)
            {
                dbCtxt.Tasks.Remove(deleteTask);
                dbCtxt.SaveChanges();
            }
        }
Пример #12
0
        public ActionResult Create([Bind(Include = "ID,Username,Email,UserRole")] User user)
        {
            if (ModelState.IsValid)
            {
                User dbUser = dbContext.Users.ToList()
                              .Where(u => u.Email == user.Email || u.Username == user.Username)
                              .FirstOrDefault();

                if (dbUser != null)
                {
                    return(FailedAction("User with specified details already exists!", user));
                }

                if (!user.UserRole.HasValue)
                {
                    return(FailedAction("Please specify a role for the new user!", user));
                }

                dbContext.Users.Add(user);
                dbContext.SaveChanges();

                var description = ApplicationState.Instance.CurrentUser.FirstName + " " + ApplicationState.Instance.CurrentUser.LastName + " added new user with username "
                                  + user.Username + " and role " + user.UserRole.ToString();
                new ActivityMonitorUpdater(dbContext).WriteToDatabase(description, -1);

                return(RedirectToAction("Index"));
            }

            return(View(user));
        }
Пример #13
0
 public void AddTask(Task item)
 {
     using (ProjectManagerContext db = new ProjectManagerContext())
     {
         db.Tasks.Add(item);
         db.SaveChanges();
         //if (item.ParentTask != null && !string.IsNullOrEmpty(item.ParentTask))
         //{
         //    ProjectBL obj = new ProjectBL();
         //    obj.UpdateProject(item.ProjectId);
         //}
     }
 }
Пример #14
0
 public void DeleteTask(int Id)
 {
     using (ProjectManagerContext db = new ProjectManagerContext())
     {
         var Tsk = db.Tasks.First(i => i.TaskId == Id);
         //var Tsk = GetById(item.TaskId);
         if (Tsk != null)
         {
             db.Entry(Tsk).State = System.Data.Entity.EntityState.Deleted;
             db.SaveChanges();
         }
     }
 }
Пример #15
0
        // Update Task
        public void UpdateTask(Task editTask)
        {
            ProjectManagerContext dbCtxt = new ProjectManagerContext();
            var existingTask             = dbCtxt.Tasks.Where(m => m.TaskId == editTask.TaskId).FirstOrDefault();

            existingTask.ParentId      = editTask.ParentId;
            existingTask.TaskName      = editTask.TaskName;
            existingTask.TaskStartDate = editTask.TaskStartDate;
            existingTask.TaskEndDate   = editTask.TaskEndDate;
            existingTask.Priority      = editTask.Priority;
            existingTask.User_ID       = editTask.User_ID;
            dbCtxt.SaveChanges();
        }
        public void Can_Add_Projects_And_Orders()
        {
            using (var db = new ProjectManagerContext())
            {
                var proj1 = new PROJECT {
                    NAME = "TEST PROJ 1"
                };
                var proj2 = new PROJECT {
                    NAME = "TEST PROJ 2"
                };
                var proj3 = new PROJECT {
                    NAME = "TEST PROJ 3"
                };
                db.PROJECTs.Add(proj1);
                db.PROJECTs.Add(proj2);
                db.PROJECTs.Add(proj3);
                db.SaveChanges();

                var order1 = new ORDER {
                    NAME = "ORDER 1"
                };
                var order2 = new ORDER {
                    NAME = "ORDER 2"
                };

                db.ORDERs.Add(order1);
                db.ORDERs.Add(order2);
                db.SaveChanges();

                proj1.ORDERS.Add(order1);
                proj1.ORDERS.Add(order2);
                proj2.ORDERS.Add(order2);

                db.SaveChanges();
            }
        }
Пример #17
0
        // Update Existing Project
        public void UpdateProject(Project editProject)

        {
            ProjectManagerContext dbCtxt = new ProjectManagerContext();
            var existingProject          = dbCtxt.Projects.Where(m => m.ProjectId == editProject.ProjectId).FirstOrDefault();

            existingProject.ProjectId        = editProject.ProjectId;
            existingProject.ProjectName      = editProject.ProjectName;
            existingProject.ProjectStartDate = editProject.ProjectStartDate;
            existingProject.ProjectEndDate   = editProject.ProjectEndDate;
            existingProject.Priority         = editProject.Priority;
            existingProject.User_ID          = editProject.User_ID;

            dbCtxt.SaveChanges();
        }
 /// <summary>
 /// Method to update  the task into the database
 /// </summary>
 /// <param name="item">Task which needs to be updated</param>
 public void UpdateUser(User item)
 {
     using (ProjectManagerContext db = new ProjectManagerContext())
     {
         var itemToUpdate = db.User.SingleOrDefault(data => data.User_ID.Equals(item.User_ID));
         if (itemToUpdate != null)
         {
             itemToUpdate.User_ID     = item.User_ID;
             itemToUpdate.FirstName   = item.FirstName;
             itemToUpdate.LastName    = item.LastName;
             itemToUpdate.Employee_ID = item.Employee_ID;
             db.SaveChanges();
         }
     }
 }
Пример #19
0
        public ActionResult ValidateLogin([Bind(Include = "Username,Password")] User user)
        {
            if (ModelState.IsValid)
            {
                User dbUser = dbContext.Users.ToList()
                              .Where(u => u.Username.Equals(user.Username) && u.Password.Equals(user.Password))
                              .FirstOrDefault();

                if (dbUser == null)
                {
                    TempData[Constants.NOTICE] = "Invalid username or password! Please try again!";
                    return(RedirectToAction("Login"));
                }

                dbUser.LastLogin = DateTime.UtcNow;
                ApplicationState.Instance.CurrentUser = dbUser;

                dbContext.Entry(dbUser).State = System.Data.Entity.EntityState.Modified;
                dbContext.SaveChanges();

                return(RedirectToAction("Activity"));
            }
            return(RedirectToAction("Login"));
        }
Пример #20
0
 public void UpdateProject(int ProjID)
 {
     using (ProjectManagerContext db = new ProjectManagerContext())
     {
         var Proj = db.Projects.First(i => i.ProjectId == ProjID);
         //var Tsk = GetById(item.TaskId);
         if (Proj != null)
         {
             //Proj.TotalTasks += 1;
             db.Entry(Proj).State = System.Data.Entity.EntityState.Modified;
             db.SaveChanges();
         }
         //db.Entry(Tsk).CurrentValues.SetValues(item);
         //db.Tasks.AddOrUpdate(item);
     }
 }
        public void Can_Remove_Projects_And_Orders_Relation()
        {
            using (var db = new ProjectManagerContext())
            {
                var proj1 = db.PROJECTs.Single(p => p.NAME == "TEST PROJ 1");

                Debug.WriteLine($"Num of proj1 orders = [{proj1.ORDERS.Count}]");
                foreach (var order in proj1.ORDERS.ToList())
                {
                    Debug.WriteLine($"Removed proj order = [{proj1.NAME}] [{order.NAME}]");
                    proj1.ORDERS.Remove(order);
                }

                db.SaveChanges();
            }
        }
Пример #22
0
 /// <summary>
 /// Method to update  the task into the database
 /// </summary>
 /// <param name="item">Task which needs to be updated</param>
 public void UpdateTask(Task item)
 {
     using (ProjectManagerContext db = new ProjectManagerContext())
     {
         var itemToUpdate = db.Task.SingleOrDefault(task => task.Task_ID.Equals(item.Task_ID));
         if (itemToUpdate != null)
         {
             itemToUpdate.Task_Name  = item.Task_Name;
             itemToUpdate.Parent_ID  = item.Parent_ID;
             itemToUpdate.Priority   = item.Priority;
             itemToUpdate.Start_Date = item.Start_Date;
             itemToUpdate.End_Date   = item.End_Date;
             db.SaveChanges();
         }
     }
 }
Пример #23
0
 /// <summary>
 /// Method to update  the task into the database
 /// </summary>
 /// <param name="item">Task which needs to be updated</param>
 public void UpdateProject(Project item)
 {
     using (ProjectManagerContext db = new ProjectManagerContext())
     {
         var itemToUpdate = db.Project.SingleOrDefault(data => data.Project_ID.Equals(item.Project_ID));
         if (itemToUpdate != null)
         {
             itemToUpdate.Project_ID   = item.Project_ID;
             itemToUpdate.Project_Name = item.Project_Name;
             itemToUpdate.Start_Date   = item.Start_Date;
             itemToUpdate.End_Date     = item.End_Date;
             itemToUpdate.Priority     = item.Priority;
             db.SaveChanges();
         }
     }
 }
Пример #24
0
        public void UpdateNormal()
        {
            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.Activities.Add(new Activity
                {
                    Name        = "teste1",
                    InitialDate = DateTime.Now,
                    FinalDate   = DateTime.Now.AddDays(1),
                    ProjectId   = 1,
                    Finished    = false
                });

                context.SaveChanges();
            }

            using (var context = new ProjectManagerContext(options, null))
            {
                var repoA = new ActivityRepository(context);

                var service = new ActivityService(repoA);

                var activity = service.Get(1).Result;

                activity.Name = "testeUpdate";

                service.Update(activity).Wait();

                var newActivity = service.Get(1).Result;

                Assert.Equal("testeUpdate", newActivity.Name);
            }
        }
Пример #25
0
        public static void EnsureSeedDataForContext(this ProjectManagerContext context)
        {
            if (context.Projects.Any())
            {
                return; // database already seeded
            }

            var projects = new List <Project>()
            {
                new Project()
                {
                    Id          = 1,
                    Name        = "Project 1",
                    Description = "The first project",
                    UserStories = new List <UserStory>()
                    {
                        new UserStory()
                        {
                            Id            = 1,
                            Name          = "Add Login Screen",
                            Description   = "A login screen needs to be added to the homepage",
                            WorkRemaining = "3 hours",
                            Completed     = false
                        }
                    }
                },
                new Project()
                {
                    Id          = 2,
                    Name        = "Project 2",
                    Description = "The second project",
                },
                new Project()
                {
                    Id          = 3,
                    Name        = "Project Alpha",
                    Description = "The finished project",
                }
            };

            context.Projects.AddRange(projects);
            if (context.SaveChanges() > 0)
            {
                Console.WriteLine("Data seeded to ProjectManagerContext");
            }
        }
Пример #26
0
        public void UpdateWithoutField()
        {
            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.Activities.Add(new Activity
                {
                    Name        = "teste1",
                    InitialDate = DateTime.Now,
                    FinalDate   = DateTime.Now.AddDays(1),
                    ProjectId   = 1,
                    Finished    = false
                });

                context.SaveChanges();
            }

            using (var context = new ProjectManagerContext(options, null))
            {
                var repoA = new ActivityRepository(context);

                var service = new ActivityService(repoA);

                var activity = service.Get(1).Result;

                activity.ProjectId = 0;

                Assert.ThrowsAsync <AggregateException>(
                    () => service.Update(activity)
                    );
            }
        }
Пример #27
0
 public void UpdateUser(User item)
 {
     using (ProjectManagerContext db = new ProjectManagerContext())
     {
         var User = db.Users.First(i => i.UserId == item.UserId);
         //var Tsk = GetById(item.TaskId);
         if (User != null)
         {
             User.FirstName       = item.FirstName;
             User.LastName        = item.LastName;
             User.EmployeeID      = item.EmployeeID;
             db.Entry(User).State = System.Data.Entity.EntityState.Modified;
             db.SaveChanges();
         }
         //db.Entry(Tsk).CurrentValues.SetValues(item);
         //db.Tasks.AddOrUpdate(item);
     }
 }
Пример #28
0
 public void UpdateProject(Project item)
 {
     using (ProjectManagerContext db = new ProjectManagerContext())
     {
         var Proj = db.Projects.First(i => i.ProjectId == item.ProjectId);
         //var Tsk = GetById(item.TaskId);
         if (Proj != null)
         {
             Proj.ProjectName     = item.ProjectName;
             Proj.Priority        = item.Priority;
             Proj.SDate           = item.SDate;
             Proj.EDate           = item.EDate;
             db.Entry(Proj).State = System.Data.Entity.EntityState.Modified;
             db.SaveChanges();
         }
         //db.Entry(Tsk).CurrentValues.SetValues(item);
         //db.Tasks.AddOrUpdate(item);
     }
 }
        public IHttpActionResult UserProjects(UsersProjectsDTO dto)
        {
            var userId = User.Identity.GetUserId();

            if (_context.UsersProjects.Any(u => u.UserId == userId && u.ProjectId == dto.ProjectId))
            {
                return(BadRequest("Project Already Exists."));
            }

            var userprojects = new UsersProjects
            {
                ProjectId = dto.ProjectId,
                UserId    = userId
            };

            _context.UsersProjects.Add(userprojects);
            _context.SaveChanges();

            return(Ok());
        }
Пример #30
0
        public JsonResult Delete(int[] data)
        {
            int taskId = Convert.ToInt32(data[0]);

            db.Tasks.Remove(db.Tasks.Find(taskId));
            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateException ex)
            {
                //TODO
            }

            //TODO
            return(Json(""));
        }