public TEntity GetById(int id) { var entity = Db.Set <TEntity>().Find(id); Db.Entry <TEntity>(entity).Reload(); return(entity); //return Db.Set<TEntity>().Find(id); }
/// <summary> /// Method to create new task or update an existing task /// </summary> /// <param name="taskModel"></param> /// <returns></returns> public string InsertTask(TaskModel taskModel) { string result = string.Empty; using (TaskManagerEntities entity = new TaskManagerEntities()) { if (taskModel != null) { Task addTask = new Task(); addTask.Task1 = taskModel.Task; if (taskModel.StartDateString != null) { addTask.Start_Date = Convert.ToDateTime(taskModel.StartDateString); } if (taskModel.EndDateString != null) { addTask.End_Date = Convert.ToDateTime(taskModel.EndDateString); } addTask.Priority = taskModel.Priority; addTask.Parent_Id = taskModel.ParentId; addTask.Task_Id = taskModel.TaskId; addTask.IsActive = 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(); } } return(result); }
/// <summary> /// Method to end task /// </summary> /// <param name="taskModel"></param> /// <returns></returns> public bool UpdateTask(TaskModel taskModel) { using (TaskManagerEntities entity = new TaskManagerEntities()) { 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.IsActive = false; entity.Entry(endTask).State = System.Data.Entity.EntityState.Modified; entity.SaveChanges(); } return(true); } }
public string SaveProject(Project projectModel) { if (projectModel != null) { Project Project = GetProject(projectModel.ProjectID); using (TaskManagerEntities db = new TaskManagerEntities()) { if (Project == null) { projectModel.Status = true; db.Projects.Add(projectModel); } else { Project.ProjectName = projectModel.ProjectName; Project.Priority = projectModel.Priority; Project.EndDate = projectModel.EndDate; Project.StartDate = projectModel.StartDate; Project.Status = projectModel.Status; db.Entry(Project).State = EntityState.Modified; } db.SaveChanges(); } } return(projectModel.ProjectID.ToString()); }
public int UpdateTask(int taskid, Task taskdetails) { try { if (taskdetails != null) { if (taskdetails.Task_ID != 0) { Task t = TME.Tasks.Where(x => x.Task_ID == taskid).FirstOrDefault(); if (t != null) { t.Task1 = taskdetails.Task1; t.Parent_ID = taskdetails.Parent_ID; t.Priority = taskdetails.Priority; t.Start_Date = taskdetails.Start_Date; t.End_Date = taskdetails.End_Date; TME.Tasks.Add(t); TME.Entry(t).State = System.Data.Entity.EntityState.Modified; return(TME.SaveChanges()); } } return(TME.SaveChanges()); } } catch (Exception e) { throw e; } return(0); }
public void InsertarentTask(Parent_Task task) { using (taskManagerEntities = new TaskManagerEntities()) { if (task.Parent_Task_Id == 0) { taskManagerEntities.Parent_Task.Add(task); taskManagerEntities.Entry(task).State = System.Data.Entity.EntityState.Added; } else { taskManagerEntities.Parent_Task.Add(task); taskManagerEntities.Entry(task).State = System.Data.Entity.EntityState.Modified; } taskManagerEntities.SaveChanges(); } }
public void SaveProject(Project project) { using (taskManagerEntities = new TaskManagerEntities()) { project.Is_Active = true; if (project.Project_Id == 0) { taskManagerEntities.Projects.Add(project); taskManagerEntities.Entry(project).State = System.Data.Entity.EntityState.Added; } else { taskManagerEntities.Projects.Add(project); taskManagerEntities.Entry(project).State = System.Data.Entity.EntityState.Modified; } taskManagerEntities.SaveChanges(); } }
public void SaveUser(User user) { using (taskManagerEntities = new TaskManagerEntities()) { user.Is_Active = true; if (user.User_Id == 0) { taskManagerEntities.Users.Add(user); taskManagerEntities.Entry(user).State = System.Data.Entity.EntityState.Added; } else { taskManagerEntities.Users.Add(user); taskManagerEntities.Entry(user).State = System.Data.Entity.EntityState.Modified; } taskManagerEntities.SaveChanges(); } }
public void Delete(int ProjectId) { TaskManagerEntities taskmanagerEntities = new TaskManagerEntities(); var DeletedProjects = taskmanagerEntities.Projects.Where(x => x.Project_Id == ProjectId).FirstOrDefault(); taskmanagerEntities.Entry <Project>(DeletedProjects).State = System.Data.Entity.EntityState.Deleted; taskmanagerEntities.SaveChanges(); }
public void Delete(int UserId) { TaskManagerEntities taskmanagerEntities = new TaskManagerEntities(); var DeletedUsers = taskmanagerEntities.Users.Where(x => x.User_Id == UserId).FirstOrDefault(); taskmanagerEntities.Entry <User>(DeletedUsers).State = System.Data.Entity.EntityState.Deleted; taskmanagerEntities.SaveChanges(); }
public int InsertTask(Task task) { using (taskManagerEntities = new TaskManagerEntities()) { if (task.Task_Id == 0) { task.Is_Active = true; taskManagerEntities.Tasks.Add(task); taskManagerEntities.Entry(task).State = System.Data.Entity.EntityState.Added; } else { taskManagerEntities.Tasks.Add(task); taskManagerEntities.Entry(task).State = System.Data.Entity.EntityState.Modified; } taskManagerEntities.SaveChanges(); } return(task.Task_Id); }
public void DeleteProject(Project project) { using (taskManagerEntities = new TaskManagerEntities()) { project.Is_Active = false; taskManagerEntities.Projects.Add(project); taskManagerEntities.Entry(project).State = System.Data.Entity.EntityState.Modified; taskManagerEntities.SaveChanges(); } }
public void DeleteUser(User user) { using (taskManagerEntities = new TaskManagerEntities()) { user.Is_Active = false; taskManagerEntities.Users.Add(user); taskManagerEntities.Entry(user).State = System.Data.Entity.EntityState.Modified; taskManagerEntities.SaveChanges(); } }
public void DeleteTask(Task task) { using (taskManagerEntities = new TaskManagerEntities()) { task.Is_Active = false; taskManagerEntities.Tasks.Add(task); taskManagerEntities.Entry(task).State = System.Data.Entity.EntityState.Modified; //taskManagerEntities.Entry(task).State = System.Data.Entity.EntityState.Deleted; taskManagerEntities.SaveChanges(); } }
public string SaveUser(User userModel) { if (userModel != null) { User user = GetUser(userModel.Employee_ID); using (TaskManagerEntities db = new TaskManagerEntities()) { if (user == null) { db.Users.Add(userModel); } else { user.FirstName = userModel.FirstName; user.LastName = userModel.LastName; user.IsActive = userModel.IsActive; db.Entry(user).State = System.Data.Entity.EntityState.Modified; } db.SaveChanges(); } } return(userModel.User_ID.ToString()); }
public void UpdateTask(int id, ITask task) { _taskContext.Entry(task).State = EntityState.Modified; _taskContext.SaveChanges(); }