// DELETE: api/User/5
public void Delete(int id)
{
using (SBAEntities db = new SBAEntities())
{
List <Task_New> taskList = db.Task_New.ToList();
Task_New objTask = db.Task_New.Find(id);
Parent_Task_New objParentTask = db.Parent_Task_New.Find(id);
objTask.Status = "Completed";
db.SaveChanges();
db.Parent_Task_New.Remove(objParentTask);
db.SaveChanges();
}
}
// GET: api/Project_New
public List <TaskProject> Get()
{
Project_new prj = new Project_new();
Task_New tsk = new Task_New();
List <TaskProject> taskProjects = new List <TaskProject>();
int taskCount;
int taskCompleted;
using (SBAEntities db = new SBAEntities())
{
List <Project_new> prjList = db.Project_new.ToList();
List <Task_New> tskList = db.Task_New.ToList();
var r4Project = from i in prjList
join
i2 in tskList
on i.Project_id equals i2.Project_id
select new { i.Project_id, i.Project_Name, i.Start_Date, i.End_Date, i.Priority, i2.Task_id, i2.Status };
var r3Project = from i in prjList
select new { i.End_Date, i.Start_Date, i.Project_id, i.Project_Name, i.Priority };
foreach (var itemPrj in r3Project)
{
TaskProject objTaskProject = new TaskProject();
objTaskProject.Start_Date = itemPrj.Start_Date.Value;
objTaskProject.End_Date = itemPrj.End_Date.Value;
objTaskProject.priority = itemPrj.Priority;
objTaskProject.projectId = itemPrj.Project_id;
objTaskProject.projectName = itemPrj.Project_Name;
taskCount = 0;
taskCompleted = 0;
foreach (var item in r4Project)
{
if (objTaskProject.projectId == item.Project_id)
{
taskCount = taskCount + 1;
}
}
objTaskProject.taskCount = taskCount;
foreach (var item in r4Project)
{
if (objTaskProject.projectId == item.Project_id || (item.Status == "Completed"))
{
taskCompleted = taskCompleted + 1;
}
}
objTaskProject.statusCompleted = taskCompleted;
taskProjects.Add(objTaskProject);
}
return(taskProjects);
}
}
// 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();
}
}
}
