//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(); } }
// 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(); }
//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(); } }
// 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(); } }
/// <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(); } } }
/// <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(); } } }
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(); } } }
// 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(); } }
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)); }
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); //} } }
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(); } } }
// 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(); } }
// 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(); } } }
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")); }
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(); } }
/// <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(); } } }
/// <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(); } } }
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); } }
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"); } }
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) ); } }
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); } }
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()); }
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("")); }