public int InsertTaskDetails(Task task) { using (dbcontext) { if (task.Priority == 0) { dbcontext.ParentTasks.Add(new DAC.ParentTask() { Parent_Task_Name = task.Task_Name }); } else { DAC.Task taskDetail = new DAC.Task() { Task_Name = task.Task_Name, Project_ID = task.Project_ID, Start_Date = task.Start_Date, End_Date = task.End_Date, Parent_ID = task.Parent_ID, Priority = task.Priority, Status = task.Status }; dbcontext.Tasks.Add(taskDetail); dbcontext.SaveChanges(); var editDetails = (from editUser in dbcontext.Users where editUser.User_ID.ToString().Contains(task.User.UserId.ToString()) select editUser).First(); // Modify existing records if (editDetails != null) { editDetails.Task_ID = taskDetail.Task_ID; } } return(dbcontext.SaveChanges()); } }
public int InsertProjectDetails(MODEL.Project project) { using (dbContext) { DAC.Project proj = new DAC.Project() { Project_Name = project.ProjectName, Start_Date = project.ProjectStartDate, End_Date = project.ProjectEndDate, Priority = project.Priority }; dbContext.Projects.Add(proj); dbContext.SaveChanges(); var editDetails = (from editUser in dbContext.Users where editUser.User_ID.ToString().Contains(project.User.UserId.ToString()) select editUser).First(); // Modify existing records if (editDetails != null) { editDetails.Project_ID = proj.Project_ID; } return(dbContext.SaveChanges()); } }