public int DeleteTask(int TaskID) { TaskManagerDbEntities tmdb = new TaskManagerDbEntities(); Task_Tbl taskTbl = tmdb.Task_Tbl.Where(t => t.Task_ID == TaskID).FirstOrDefault(); tmdb.Task_Tbl.Remove(taskTbl); return(tmdb.SaveChanges()); }
public int DeleteParentTask(int ParentTaskID) { TaskManagerDbEntities tmdb = new TaskManagerDbEntities(); Parent_Task_Tbl parentTaskTbl = tmdb.Parent_Task_Tbl.Where(t => t.Parent_ID == ParentTaskID).FirstOrDefault(); tmdb.Parent_Task_Tbl.Remove(parentTaskTbl); return(tmdb.SaveChanges()); }
//public int EditParentTask(int parentID, string parentName) //{ // TaskManagerDbEntities tmdb = new TaskManagerDbEntities(); // Parent_Task_Tbl ParentTaskDb = tmdb.Parent_Task_Tbl.Find(parentID); // ParentTaskDb.Parent_Task = parentName; // tmdb.SaveChanges(); // return parentID; //} public int CreateTask(Task_Tbl Task) { TaskManagerDbEntities tmdb = new TaskManagerDbEntities(); tmdb.Task_Tbl.Add(Task); tmdb.SaveChanges(); return(Task.Task_ID); }
public int CreateParentTask(Parent_Task_Tbl ParentTask) { TaskManagerDbEntities tmdb = new TaskManagerDbEntities(); tmdb.Parent_Task_Tbl.Add(ParentTask); tmdb.SaveChanges(); return(ParentTask.Parent_ID); }
public int EditEndTask(int taskID, bool IsCompleted) { TaskManagerDbEntities tmdb = new TaskManagerDbEntities(); Task_Tbl TaskDb = tmdb.Task_Tbl.Find(taskID); TaskDb.Is_Completed = IsCompleted; tmdb.SaveChanges(); return(taskID); }
public int EditTask(Task_Tbl Task) { TaskManagerDbEntities tmdb = new TaskManagerDbEntities(); Task_Tbl TaskDb = tmdb.Task_Tbl.Find(Task.Task_ID); tmdb.Entry(TaskDb).CurrentValues.SetValues(Task); tmdb.SaveChanges(); return(Task.Task_ID); }
public int EditTask(Task_Tbl Task) { TaskManagerDbEntities tmdb = new TaskManagerDbEntities(); Task_Tbl TaskDb = tmdb.Task_Tbl.Find(Task.Task_ID); TaskDb.Priority = Task.Priority; TaskDb.Start_Date = Task.Start_Date; TaskDb.End_Date = Task.End_Date; TaskDb.Parent_ID = Task.Parent_ID; TaskDb.Is_Completed = Task.Is_Completed; tmdb.Entry(TaskDb).CurrentValues.SetValues(Task); tmdb.SaveChanges(); return(Task.Task_ID); }
public Task_Tbl GetTaskRepo(int TaskID) { TaskManagerDbEntities tmdb = new TaskManagerDbEntities(); return(tmdb.Task_Tbl.Where(p => p.Task_ID == TaskID).Select(p => p).FirstOrDefault()); }
public IQueryable <Task_Tbl> GetAllTaskRepo() { TaskManagerDbEntities tmdb = new TaskManagerDbEntities(); return(tmdb.Task_Tbl); }
public Parent_Task_Tbl GetParentTaskRepo(int ParentID) { TaskManagerDbEntities tmdb = new TaskManagerDbEntities(); return(tmdb.Parent_Task_Tbl.Where(p => p.Parent_ID == ParentID).Select(p => p).FirstOrDefault()); }
public IQueryable <Parent_Task_Tbl> GetAllParentTasksRepo() { TaskManagerDbEntities tmdb = new TaskManagerDbEntities(); return(tmdb.Parent_Task_Tbl); }
public IQueryable <Task_Tbl> GetAllTaskRepo() { TaskManagerDbEntities tmdb = new TaskManagerDbEntities(); return(tmdb.Task_Tbl.Where(t => t.Parent_ID == null || t.Parent_ID == 0)); }