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 List <ParentTask_Master> ParentTask() { List <ParentTask_Master> parentTaskList = new List <DataLayer.ParentTask_Master>(); try { var PTask = (from task in dbContext.Task_Master select new { Id = task.Task_ID, Parent_Task = task.Task }).ToList(); foreach (var data in PTask) { ParentTask_Master ptask = new ParentTask_Master(); ptask.Parent_ID = data.Id; ptask.Parent_Task = data.Parent_Task; parentTaskList.Add(ptask); } return(parentTaskList); } catch (Exception ex) { using (var file = new StreamWriter(@"C:\FSD Capsule\WebPublish\log.txt", true)) { file.WriteLine(ex.ToString()); file.Close(); } return(parentTaskList); } }
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 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); } }
public List <ParentTask_Master> ParentTask() { List <ParentTask_Master> parentTaskList = new List <DataLayer.ParentTask_Master>(); try { var PTask = (from task in dbContext.Task_Master select new { Id = task.Task_ID, Parent_Task = task.Task }).ToList(); foreach (var data in PTask) { ParentTask_Master ptask = new ParentTask_Master(); ptask.Parent_ID = data.Id; ptask.Parent_Task = data.Parent_Task; parentTaskList.Add(ptask); } return(parentTaskList); } catch (Exception ex) { return(parentTaskList); } }