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);
}
}
