public DAL.Task GetTaskByID(int TaskID) { DAL.Task Task = new DAL.Task(); using (MyContext DB = new MyContext()) { var TaskDetails = (from T in DB.Task where T.Task_ID == TaskID select new { Task_ID = T.Task_ID, TaskName = T.TaskName, ParentTask_ID = T.ParentTask_ID, ParentTaskName = T.ParentTaskName, Start_Date = T.Start_Date, End_Date = T.End_Date, Priority = T.Priority, Status = T.Status }).FirstOrDefault(); if (TaskDetails != null) { Task.Task_ID = TaskDetails.Task_ID; Task.TaskName = TaskDetails.TaskName; Task.ParentTask_ID = TaskDetails.ParentTask_ID; Task.ParentTaskName = TaskDetails.ParentTaskName; Task.Start_Date = TaskDetails.Start_Date; Task.End_Date = TaskDetails.End_Date; Task.Priority = TaskDetails.Priority; Task.Status = TaskDetails.Status; } } return(Task); }
public List <DAL.Task> GetAllTaskBySearchCriteria(DAL.SearchTask Search) { List <DAL.Task> Task = new List <DAL.Task>(); using (MyContext DB = new MyContext()) { var TaskDetails = (from p in DB.Task where (Search.Task == null || Search.Task == p.TaskName) && (Search.ParentTaskID == null || Search.ParentTaskID == p.ParentTask_ID) && (Search.Start_Date == null || Search.Start_Date == p.Start_Date) && (Search.End_Date == null || Search.End_Date == p.End_Date) && (Search.PriorityFrom == null || Search.PriorityFrom == p.Priority) && (Search.PriorityTo == null || Search.PriorityTo == p.Priority) select new { Task_ID = p.Task_ID, TaskName = p.TaskName, ParentTask_ID = p.ParentTask_ID, ParentTaskName = p.ParentTaskName, Start_Date = p.Start_Date, End_Date = p.End_Date, Priority = p.Priority, Status = p.Status } ).ToList(); foreach (var item in TaskDetails) { DAL.Task T = new DAL.Task(); T.Task_ID = item.Task_ID; T.TaskName = item.TaskName; T.ParentTask_ID = item.ParentTask_ID; T.ParentTaskName = item.ParentTaskName; T.Start_Date = item.Start_Date; T.End_Date = item.End_Date; T.Priority = item.Priority; T.Status = item.Status; Task.Add(T); } } return(Task); }
public bool EditTask(DAL.Task Task) { try { if (Task.ParentTask_ID != null) { List <DAL.DropDown> DD = new List <DAL.DropDown>(); DD = GetAllParent(); Task.ParentTaskName = DD.Where(x => x.Id == Task.ParentTask_ID).Select(x => x.Value).FirstOrDefault(); } using (MyContext DB = new MyContext()) { var taskDB = (from t in DB.Task where t.Task_ID == Task.Task_ID select t).FirstOrDefault(); var ChildTaskDB = (from t in DB.Task where t.ParentTask_ID == Task.Task_ID && t.ParentTaskName != Task.TaskName select t); if (taskDB != null) { taskDB.TaskName = Task.TaskName; taskDB.ParentTask_ID = Task.ParentTask_ID; taskDB.ParentTaskName = Task.ParentTaskName; taskDB.Start_Date = Task.Start_Date; taskDB.End_Date = Task.End_Date; taskDB.Priority = Task.Priority; taskDB.Status = Task.Status; DB.SaveChanges(); } if (ChildTaskDB != null) { foreach (var item in ChildTaskDB) { item.ParentTaskName = Task.TaskName; } DB.SaveChanges(); } return(true); } } catch (Exception) { return(false); } }
public bool AddTask(DAL.Task Task) { try { if (Task.ParentTask_ID != null) { List <DAL.DropDown> DD = new List <DAL.DropDown>(); DD = GetAllParent(); Task.ParentTaskName = DD.Where(x => x.Id == Task.ParentTask_ID).Select(x => x.Value).FirstOrDefault(); } using (MyContext DB = new MyContext()) { DB.Task.Add(Task); DB.SaveChanges(); return(true); } } catch (Exception ex) { return(false); } }
public List <DAL.Task> GetAllTask() { List <DAL.Task> Task = new List <DAL.Task>(); using (MyContext DB = new MyContext()) { var TaskDetails = (from p in DB.Task select new { Task_ID = p.Task_ID, TaskName = p.TaskName, ParentTask_ID = p.ParentTask_ID, ParentTaskName = p.ParentTaskName, Start_Date = p.Start_Date, End_Date = p.End_Date, Priority = p.Priority, Status = p.Status } ).ToList(); foreach (var item in TaskDetails) { DAL.Task T = new DAL.Task(); T.Task_ID = item.Task_ID; T.TaskName = item.TaskName; T.ParentTask_ID = item.ParentTask_ID; T.ParentTaskName = item.ParentTaskName; T.Start_Date = item.Start_Date; T.End_Date = item.End_Date; T.Priority = item.Priority; T.Status = item.Status; Task.Add(T); } } return(Task); }