// GET: api/Task_new/5
public TaskParent Get(int id)
{
TaskParent tskParent = new TaskParent();
using (SBAEntities db = new SBAEntities())
{
List <Task_New> taskList = db.Task_New.ToList();
List <Parent_Task_New> parentTaskList = db.Parent_Task_New.ToList();
var r4taskParent = from i in taskList
join
i2 in parentTaskList
on i.Parent_id equals i2.Parent_Id
where i.Task_id == id
select new { i.Parent_id, i.Priority, i.Start_Date, i.End_Date, i2.Parent_Task, i.Task_Name, i.User_id, i.Project_id };
foreach (var itemTaskParent in r4taskParent)
{
tskParent.End_Date = itemTaskParent.End_Date.Value;
tskParent.Start_Date = itemTaskParent.Start_Date.Value;
if (itemTaskParent.Parent_id.Equals(0))
{
tskParent.isParent = true;
tskParent.parentId = 0;
}
else
{
tskParent.parentId = itemTaskParent.Parent_id;
tskParent.isParent = true;
}
}
return(tskParent);
}
}
// GET: api/Task_new
public List <TaskParent> Get()
{
List <TaskParent> tskParentList = new List <TaskParent>();
using (SBAEntities db = new SBAEntities())
{
List <Task_New> taskList = db.Task_New.ToList();
List <Parent_Task_New> parentTaskList = db.Parent_Task_New.ToList();
var r4taskParent = from i in taskList
join
i2 in parentTaskList
on i.Parent_id equals i2.Parent_Id
select new { i.Parent_id, i.Priority, i.Start_Date, i.End_Date, i2.Parent_Task, i.Task_Name, i.User_id, i.Project_id };
foreach (var itemTaskParent in r4taskParent)
{
TaskParent tskParent = new TaskParent();
tskParent.parentId = itemTaskParent.Parent_id;
tskParent.parentTaskName = itemTaskParent.Parent_Task;
tskParent.priority = itemTaskParent.Priority;
tskParent.Start_Date = itemTaskParent.Start_Date.Value;
tskParent.End_Date = itemTaskParent.End_Date.Value;
tskParent.taskName = itemTaskParent.Task_Name;
tskParent.UserId = itemTaskParent.User_id.Value;
tskParentList.Add(tskParent);
}
return(tskParentList);
}
}
// POST: api/Project
public void Post(TaskParent item)
{
Task_New tskNew = new Task_New();
Parent_Task_New tskParentNew = new Parent_Task_New();
using (SBAEntities db = new SBAEntities())
{
tskNew.Task_id = item.taskId;
tskNew.Task_Name = item.taskName;
tskNew.Project_id = item.projectId;
tskNew.Start_Date = item.Start_Date;
tskNew.End_Date = item.End_Date;
tskNew.Priority = item.priority;
tskNew.User_id = item.UserId;
db.Task_New.Add(tskNew);
db.SaveChanges();
}
}
// PUT: api/Project/5
public void Put(TaskParent item)
{
using (SBAEntities db = new SBAEntities())
{
Task_New tskNew = db.Task_New.Find(item.taskId);
tskNew.User_id = item.UserId;
tskNew.End_Date = item.End_Date;
tskNew.Start_Date = item.Start_Date;
tskNew.Project_id = item.projectId;
tskNew.Task_Name = item.taskName;
tskNew.Parent_id = item.parentId;
tskNew.Priority = item.priority;
db.SaveChanges();
if (item.isParent == true)
{
Parent_Task_New tskParentNew = db.Parent_Task_New.Find(item.taskId);
tskParentNew.Parent_Task = item.parentTaskName;
db.SaveChanges();
}
}
}