/// <summary> /// Generic Delete method for the entities /// </summary> /// <param name="entityToDelete"></param> public virtual void Delete(TEntity entityToDelete) { if (Context.Entry(entityToDelete).State == EntityState.Detached) { DbSet.Attach(entityToDelete); } DbSet.Remove(entityToDelete); }
public IHttpActionResult PutProjectTable(int id, ProjectTable projectTable) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != projectTable.ProjectId) { return(BadRequest()); } db.Entry(projectTable).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!ProjectTableExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public int DeleteUserDetails(UserModel userModel) { int returnVal = 0; using (ProjectManagerEntities userEntity = new ProjectManagerEntities()) { User objUser = userEntity.Users.Where(x => x.User_ID == userModel.User_ID).FirstOrDefault(); if (objUser != null) { objUser.First_Name = userModel.First_Name; objUser.Last_Name = userModel.Last_Name; objUser.Employee_ID = userModel.Employee_ID; //objUser.Project_ID = userModel.ProjectId; objUser.IsActive = false; userEntity.Entry(objUser).State = EntityState.Modified; try { userEntity.SaveChanges(); returnVal = 1; } catch (Exception ex) { return(returnVal); } } } return(returnVal); }
public IHttpActionResult PutUser(int id, User user) { //if (!ModelState.IsValid) //{ // return BadRequest(ModelState); //} if (id != user.EmployeeID) { return(BadRequest()); } db.Entry(user).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!UserExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public int UpdateTaskRepository(TaskModel taskModel) { int returnVal = 0; using (ProjectManagerEntities taskManagerEntity = new ProjectManagerEntities()) { Task objtask = taskManagerEntity.Tasks.Where(x => x.Task_ID == taskModel.Task_ID).FirstOrDefault(); if (objtask != null) { objtask.Task1 = taskModel.Task; objtask.Parent_ID = taskModel.Parent_ID; objtask.Start_Date = taskModel.Start_Date; objtask.End_Date = taskModel.End_Date; objtask.IsActive = taskModel.IsActive; objtask.Priority = taskModel.Priority; objtask.Project_ID = taskModel.Project_ID; objtask.User_ID = taskModel.User_ID; taskManagerEntity.Entry(objtask).State = EntityState.Modified; try { taskManagerEntity.SaveChanges(); returnVal = 1; } catch (Exception ex) { return(returnVal); } } } return(returnVal); }
/// <summary> /// Task update method for the entities /// </summary> /// <param name="entityToUpdate"></param> public virtual int Put(int id, Task entityToUpdate) { Context.Entry(entityToUpdate).State = EntityState.Modified; return(Context.SaveChanges()); //DbSet.Attach(entityToUpdate); //Context.Entry(entityToUpdate).State = EntityState.Modified; }
/// <summary> /// Method to suspend project /// </summary> /// <param name="projectModel"></param> /// <returns></returns> public bool SuspendProject(ProjectModel projectModel) { using (ProjectManagerEntities entity = new ProjectManagerEntities()) { if (projectModel != null && projectModel.ProjectId != 0) { Project suspendProject = new Project(); suspendProject.Project1 = projectModel.Project; suspendProject.Project_ID = projectModel.ProjectId; if (projectModel.StartDateString != null) { suspendProject.Start_Date = Convert.ToDateTime(projectModel.StartDateString); } if (projectModel.EndDateString != null) { suspendProject.End_Date = Convert.ToDateTime(projectModel.EndDateString); } suspendProject.Priority = projectModel.Priority; suspendProject.Status = false; entity.Entry(suspendProject).State = System.Data.Entity.EntityState.Modified; entity.SaveChanges(); } return(true); } }
public IHttpActionResult Puttbl_parent_task(int id, tbl_parent_task tbl_parent_task) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tbl_parent_task.parent_id) { return(BadRequest()); } db.Entry(tbl_parent_task).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tbl_parent_taskExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
/// <summary> /// User update method for the entities /// </summary> /// <param name="entityToUpdate"></param> public virtual int Put(int id, User entityToUpdate) { Context.Entry(entityToUpdate).State = EntityState.Modified; return(Context.SaveChanges()); //DbSet.Attach(entityToUpdate); //ProjectManagerDB.Entry(entityToUpdate).State = EntityState.Modified; }
/// <summary> /// Method to create new project or update an existing project /// </summary> /// <param name="projectModel"></param> /// <returns></returns> public string AddOrUpdateProject(ProjectModel projectModel) { string result = string.Empty; using (ProjectManagerEntities entity = new ProjectManagerEntities()) { if (projectModel != null) { Project addProject = new Project(); addProject.Project_ID = projectModel.ProjectId; addProject.Project1 = projectModel.Project; if (projectModel.StartDateString != null && !string.IsNullOrEmpty(projectModel.StartDateString)) { addProject.Start_Date = Convert.ToDateTime(projectModel.StartDateString); } if (projectModel.EndDateString != null && !string.IsNullOrEmpty(projectModel.EndDateString)) { addProject.End_Date = Convert.ToDateTime(projectModel.EndDateString); } addProject.Priority = projectModel.Priority; addProject.Manager_ID = projectModel.ManagerId; addProject.Status = true; result = addProject.Project_ID == 0 ? "ADD" : "UPDATE"; entity.Entry(addProject).State = addProject.Project_ID == 0 ? System.Data.Entity.EntityState.Added : System.Data.Entity.EntityState.Modified; entity.SaveChanges(); } } return(result); }
/// <summary> /// Method to end task /// </summary> /// <param name="taskModel"></param> /// <returns></returns> public bool End(TaskModel taskModel) { using (ProjectManagerEntities entity = new ProjectManagerEntities()) { if (taskModel != null && taskModel.TaskId != 0) { Task endTask = new Task(); endTask.Task_ID = taskModel.TaskId; endTask.Task1 = taskModel.Task; if (taskModel.StartDateString != null) { endTask.Start_Date = Convert.ToDateTime(taskModel.StartDateString); } if (taskModel.EndDateString != null) { endTask.End_Date = Convert.ToDateTime(taskModel.EndDateString); } endTask.Priority = taskModel.Priority; endTask.Parent_ID = taskModel.ParentId; endTask.Project_ID = taskModel.ProjectId; endTask.Status = false; entity.Entry(endTask).State = System.Data.Entity.EntityState.Modified; entity.SaveChanges(); } return(true); } }
public int UpdateProjectDetails(ProjectModel prjModel) { int returnVal = 0; using (ProjectManagerEntities projEntity = new ProjectManagerEntities()) { Project objProject = projEntity.Projects.Where(x => x.Project_ID == prjModel.Project_ID).FirstOrDefault(); if (objProject != null) { objProject.Project1 = prjModel.Project; objProject.Start_Date = prjModel.Start_Date; objProject.End_Date = prjModel.End_Date; objProject.Priority = prjModel.Priority; objProject.Manager_ID = prjModel.Manager_ID; objProject.Status = prjModel.Status; projEntity.Entry(objProject).State = EntityState.Modified; try { projEntity.SaveChanges(); returnVal = 1; } catch (Exception ex) { return(returnVal); } } } return(returnVal); }
public void DeleteUser(CommonLibrary.Users user) { DataAccessLayer.User usr = new DataAccessLayer.User { UserID = user.UserID }; _projectManager.Entry(usr).State = EntityState.Deleted; _projectManager.SaveChanges(); }
/// <summary> /// Method to create a new task or update an existing task /// </summary> /// <param name="taskModel"></param> /// <returns></returns> public string ManageTask(TaskModel taskModel) { string result = string.Empty; using (ProjectManagerEntities entity = new ProjectManagerEntities()) { if (taskModel != null) { Task addTask = new Task(); addTask.Task1 = taskModel.Task; if (taskModel.StartDateString != null && !string.IsNullOrEmpty(taskModel.StartDateString)) { addTask.Start_Date = Convert.ToDateTime(taskModel.StartDateString); } if (taskModel.EndDateString != null && !string.IsNullOrEmpty(taskModel.EndDateString)) { addTask.End_Date = Convert.ToDateTime(taskModel.EndDateString); } addTask.Priority = taskModel.Priority; addTask.Parent_ID = taskModel.ParentId; addTask.Task_ID = taskModel.TaskId; addTask.Project_ID = taskModel.ProjectId; addTask.Status = true; result = addTask.Task_ID == 0 ? "ADD" : "UPDATE"; entity.Entry(addTask).State = addTask.Task_ID == 0 ? System.Data.Entity.EntityState.Added : System.Data.Entity.EntityState.Modified; entity.SaveChanges(); if (result == "ADD") { int taskId = GetTaskId(); if (taskModel.UserId != 0) { User userTask = GetUserById(taskModel.UserId); userTask.Project_ID = taskModel.ProjectId; userTask.Task_ID = taskId; userTask.User_ID = taskModel.UserId; entity.Entry(userTask).State = System.Data.Entity.EntityState.Modified; entity.SaveChanges(); } } } } return(result); }
public void DeleteUser(CommonEntities.Users user) { Users ur = new Users { UserID = user.UserID }; _projectManager.Entry(ur).State = EntityState.Deleted; _projectManager.SaveChanges(); }
public void SuspendProject(int ProjectID) { DataAccessLayer.Project proj = new DataAccessLayer.Project { ProjectID = ProjectID }; var user = _projectManager.Users.Where(x => x.ProjectID == ProjectID).FirstOrDefault(); if (user != null) { user.ProjectID = null; } _projectManager.Entry(proj).State = EntityState.Deleted; _projectManager.SaveChanges(); }
public bool DeleteUser(UsersModel user) { //using (ProjectManagerEntities dbContext = new ProjectManagerEntities()) //{ try { var userData = new Users_Table { User_ID = user.User_ID }; dbContext.Entry(userData).State = EntityState.Deleted; dbContext.SaveChanges(); } catch (Exception e) { return false; } return true; }
public void SuspendProject(int projectID) { Projects proj = new Projects { ProjectID = projectID }; var user = _projectManager.Users1.Where(x => x.ProjectID == projectID).FirstOrDefault(); if (user != null) { user.ProjectID = null; } _projectManager.Entry(proj).State = EntityState.Deleted; _projectManager.SaveChanges(); }
/// <summary> /// Method to create a new task or update an existing task /// </summary> /// <param name="taskModel"></param> /// <returns></returns> public string AddParent(TaskModel taskModel) { string result = string.Empty; using (ProjectManagerEntities entity = new ProjectManagerEntities()) { if (taskModel != null) { ParentTask parentTask = new ParentTask(); parentTask.Parent_Task = taskModel.Task; entity.Entry(parentTask).State = System.Data.Entity.EntityState.Added; entity.SaveChanges(); result = "ADD"; } } return(result); }
/// <summary> /// Method to delete user /// </summary> /// <param name="userModel"></param> /// <returns></returns> public bool DeleteUser(UserModel userModel) { using (ProjectManagerEntities entity = new ProjectManagerEntities()) { if (userModel != null && userModel.UserId != 0) { User deleteUser = new User(); deleteUser.User_ID = userModel.UserId; deleteUser.First_Name = userModel.FirstName; deleteUser.Last_Name = userModel.LastName; deleteUser.Employee_ID = userModel.EmployeeId; deleteUser.IsActive = false; entity.Entry(deleteUser).State = System.Data.Entity.EntityState.Modified; entity.SaveChanges(); } return(true); } }
public bool DeleteProject(ProjectModel project) { try { var userData = dbContext.Users_Table.Where(c => c.User_ID == project.User_ID).First(); userData.Project_ID = null; dbContext.SaveChanges(); var projectData = new Project_Table { Project_ID = project.Project_ID }; dbContext.Entry(projectData).State = EntityState.Deleted; dbContext.SaveChanges(); } catch (Exception e) { return(false); } return(true); }
/// <summary> /// Method to create or update a user /// </summary> /// <param name="userModel"></param> /// <returns></returns> public string AddOrUpdateUser(UserModel userModel) { string result = string.Empty; using (ProjectManagerEntities entity = new ProjectManagerEntities()) { if (userModel != null) { User addUser = new User(); addUser.First_Name = userModel.FirstName; addUser.Last_Name = userModel.LastName; addUser.Employee_ID = userModel.EmployeeId; addUser.IsActive = true; addUser.User_ID = userModel.UserId; result = addUser.User_ID == 0 ? "ADD" : "UPDATE"; entity.Entry(addUser).State = addUser.User_ID == 0 ? System.Data.Entity.EntityState.Added : System.Data.Entity.EntityState.Modified; entity.SaveChanges(); } } return(result); }
public void DeleteUser(int iUserID) { try { using (ProjectManagerEntities context = new ProjectManagerEntities()) { User user = GetUsersByID(iUserID); if (user != null) { User usrDelete = new User { User_ID = iUserID }; context.Entry(usrDelete).State = EntityState.Deleted; context.SaveChanges(); } } } catch (Exception ex) { throw ex.InnerException; } }
public void SuspendProject(int projectID) { Project proj = new Project { Project_ID = projectID }; //var friends = db.Friends.Where(f => idList.Contains(f.ID)).ToList(); //friends.ForEach(a => a.msgSentBy = '1234'); //db.SaveChanges(); var user = _projectManager.Users.Where(x => x.Project_ID == projectID).ToList(); if (user.Count > 0) { user.ForEach(a => a.Project_ID = null); } var task = _projectManager.Tasks.Where(x => x.Project_ID == projectID).ToList(); if (task.Count > 0) { task.ForEach(a => a.Project_ID = null); } _projectManager.Entry(proj).State = EntityState.Deleted; _projectManager.SaveChanges(); }