public List <ProjectTaskInfo> GetAllTasks() { List <ProjectTaskInfo> TaskList = new List <ProjectTaskInfo>(); using (ProductDBEntities tstDb = new ProductDBEntities()) { //ProductDBEntities tstDb = new ProductDBEntities(); var lstTask = from k in tstDb.TblTasks select k; foreach (var item in lstTask) { ProjectTaskInfo _task = new ProjectTaskInfo(); _task.Task_Id = item.Task_ID; _task.Project_ID = item.Project_ID; _task.Task = item.Task; _task.StartDate = item.StartDate; _task.EndDate = item.EndDate; _task.Priority = item.Priority; _task.Parent_ID = item.Parent_ID; _task.Project_ID = item.Project_ID; _task.Status = item.Status; TaskList.Add(_task); } } return(TaskList); }
public int UpdateTask(int TaskId, bool taskStatus) { int Retval = -1; ProductDBEntities tstDb = new ProductDBEntities(); ProjectTaskInfo tempProd = new ProjectTaskInfo();; TblTask result = tstDb.TblTasks.SingleOrDefault(b => b.Task_ID == TaskId); if (result != null) { result.Status = taskStatus; tstDb.Entry(result).State = EntityState.Modified; Retval = tstDb.SaveChanges(); } return(Retval); }
public ProjectTaskInfo GetTaskById(int Taskid) { ProductDBEntities tstDb = new ProductDBEntities(); var lstUsr = from k in tstDb.TblTasks where k.Task_ID == Taskid select k; ProjectTaskInfo TaskInfo = new ProjectTaskInfo(); foreach (var item in lstUsr) { TaskInfo.Project_ID = item.Project_ID; TaskInfo.StartDate = item.StartDate; TaskInfo.EndDate = item.EndDate; TaskInfo.Priority = item.Priority; TaskInfo.Task = item.Task; TaskInfo.Parent_ID = item.Parent_ID; TaskInfo.Status = item.Status; } return(TaskInfo); }
public int UpdateTaskDetails(int TaskId, int ParentId, int ProjectId, string Task, DateTime StartDate, DateTime EndDate, int Priority, bool status) { int Retval = -1; ProductDBEntities tstDb = new ProductDBEntities(); ProjectTaskInfo tempProd = new ProjectTaskInfo();; TblTask result = tstDb.TblTasks.SingleOrDefault(b => b.Task_ID == TaskId); if (result != null) { result.Parent_ID = ParentId; result.Project_ID = ProjectId; result.Task = Task; result.StartDate = StartDate; result.EndDate = EndDate; result.Priority = Priority; result.Status = status; tstDb.Entry(result).State = EntityState.Modified; Retval = tstDb.SaveChanges(); } return(Retval); }