public bool UpdateTask(Task_Master task, ParentTask_Master parentTask) { try { Task_Master existTask = dbContext.Task_Master.Find(task.Task_ID); ((IObjectContextAdapter)dbContext).ObjectContext.Detach(existTask); dbContext.Entry(task).State = EntityState.Modified; dbContext.SaveChanges(); ParentTask_Master existPTask = dbContext.ParentTask_Master.Find(parentTask.Parent_ID); ((IObjectContextAdapter)dbContext).ObjectContext.Detach(existPTask); //User_Master user = dbContext.User_Master.Find(task.userID); //user.Task_ID = task.Task_ID; //((IObjectContextAdapter)dbContext).ObjectContext.Detach(user); dbContext.Entry(parentTask).State = EntityState.Modified; dbContext.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public bool AddTask(Task_Master task, ParentTask_Master parentTask) { try { var addTask = dbContext.Task_Master.Add(task); var addParentTask = dbContext.ParentTask_Master.Add(parentTask); dbContext.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public bool EndTask(int taskId) { try { Task_Master taskData = dbContext.Task_Master.Find(taskId); taskData.IsTaskEnded = 1; dbContext.Entry(taskData).State = EntityState.Modified; dbContext.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public Task_Master GetTaskById(int taskId) { Task_Master taskData = new Task_Master(); try { // taskData = dbContext.Task_Master.Find(taskId); var Query = (from task in dbContext.Task_Master join Ptask in dbContext.ParentTask_Master on task.Parent_ID equals Ptask.Parent_ID into td from Task_Masters in td.DefaultIfEmpty() where task.Task_ID == taskId select new { Task_ID = task.Task_ID, Parent_ID = task.Parent_ID, Task = task.Task, StartDate = task.Start_Date, EndDate = task.End_Date, Priority = task.Priority, IsTaskEnded = task.isTaskEnded, ParentTask = Task_Masters.Parent_Task, ProjectID = task.Project_Master.Project_ID, //user_ID = Task_Masters.User_ID, }).Distinct().ToList(); taskData = Query.ToList().Select(r => new Task_Master { Task_ID = r.Task_ID, Parent_ID = r.Parent_ID, Task = r.Task, Start_Date = r.StartDate, End_Date = r.EndDate, Priority = r.Priority, isTaskEnded = r.IsTaskEnded, ParentTask = r.ParentTask, Project_ID = r.ProjectID, userID = dbContext.User_Master.Where(i => i.Task_ID == r.Task_ID).FirstOrDefault().User_ID }).FirstOrDefault(); return(taskData); } catch (Exception ex) { return(taskData); } }
public bool AddTask(Task_Master task, ParentTask_Master parentTask) { try { var addTask = dbContext.Task_Master.Add(task); var addParentTask = dbContext.ParentTask_Master.Add(parentTask); User_Master user = dbContext.User_Master.Where(i => i.User_ID == task.userID).FirstOrDefault(); user.Project_ID = task.Project_ID; user.Task_ID = addTask.Task_ID; dbContext.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }