// 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);
}
}
// 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);
}
}
// POST: api/User
public void Post(User_New item)
{
using (SBAEntities db = new SBAEntities())
{
db.User_New.Add(item);
db.SaveChanges();
}
}
public List <User_New> Get()
{
using (SBAEntities db = new SBAEntities())
{
return(db.User_New.ToList());
}
}
// POST: api/User
public void Post(Parent_Task_New item)
{
using (SBAEntities db = new SBAEntities())
{
db.Parent_Task_New.Add(item);
db.SaveChanges();
}
}
public List <Parent_Task_New> Get()
{
using (SBAEntities db = new SBAEntities())
{
return(db.Parent_Task_New.ToList());
}
}
// POST: api/Project
public void Post(Project_new item)
{
using (SBAEntities db = new SBAEntities())
{
db.Project_new.Add(item);
db.SaveChanges();
}
}
// DELETE: api/User/5
public void Delete(int id)
{
using (SBAEntities db = new SBAEntities())
{
User_New obj = db.User_New.Find(id);
db.User_New.Remove(obj);
db.SaveChanges();
}
}
// PUT: api/User/5
public void Put(User_New item)
{
using (SBAEntities db = new SBAEntities())
{
User_New obj = db.User_New.Find(item.User_id);
obj.Employee_id = item.Employee_id;
obj.First_Name = item.First_Name;
obj.Last_name = item.Last_name;
db.SaveChanges();
}
}
// 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();
}
}
// PUT: api/Project/5
public void Put(Project_new item)
{
using (SBAEntities db = new SBAEntities())
{
Project_new obj = db.Project_new.Find(item.Project_id);
obj.User_id = item.User_id;
obj.Priority = item.Priority;
obj.Project_Name = item.Project_Name;
obj.Start_Date = item.Start_Date;
obj.End_Date = item.End_Date;
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();
}
}
// GET: api/User/5
public User_New Get(int id)
{
User_New usr = new User_New();
using (SBAEntities db = new SBAEntities())
{
List <User_New> userList = db.User_New.ToList();
var r4 = from i in userList
where i.User_id == id
select new { i.Employee_id, i.First_Name, i.Last_name };
foreach (var item in r4)
{
usr.Employee_id = item.Employee_id;
usr.First_Name = item.First_Name;
usr.Last_name = item.Last_name;
}
}
return(usr);
}
// 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();
}
}
}
// GET: api/Project/5
public Project_new Get(int id)
{
Project_new prj = new Project_new();
using (SBAEntities db = new SBAEntities())
{
List <Project_new> projList = db.Project_new.ToList();
var r4 = from i in projList
where i.Project_id == id
select new { i.Project_id, i.User_id, i.Priority, i.Start_Date, i.End_Date, i.Project_Name };
foreach (var item in r4)
{
prj.Project_id = item.Project_id;
prj.User_id = item.User_id;
prj.Priority = item.Priority;
prj.Start_Date = item.Start_Date;
prj.End_Date = item.End_Date;
prj.Project_Name = item.Project_Name;
}
}
return(prj);
}
