// POST: api/Project
public void Post(Project_new item)
{
using (SBAEntities db = new SBAEntities())
{
db.Project_new.Add(item);
db.SaveChanges();
}
}
// DELETE: api/Project/5
public void Delete(int id)
{
using (SBAEntities db = new SBAEntities())
{
Project_new obj = db.Project_new.Find(id);
db.Project_new.Remove(obj);
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);
}
}
// 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);
}