public projecttask searchbyid(projecttask t)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
return((projecttask)db.Projecttasks.Where(ta => ta.projecttask_id == t.projecttask_id));
}
// POST: api/projecttask
public void Post(projecttask value)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
db.Projecttasks.Add(value);
db.SaveChanges();
}
public void CreateNewTask(projecttask t)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
db.Projecttasks.Add(t);
db.SaveChanges();
}
// DELETE: api/projecttask/5
public void Delete(int id)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
projecttask t1 = db.Projecttasks.Where(ta => ta.projecttask_id == id).FirstOrDefault();
db.Projecttasks.Remove(t1);
db.SaveChanges();
}
public void Edit(projecttask t)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
projecttask t2 = searchbyid(t);
t.projecttask_id = t2.projecttask_id;
t.taskstartdate = t2.taskstartdate;
t.taskenddate = t2.taskenddate;
t.taskcompletion = t2.taskcompletion;
db.SaveChanges();
}
// PUT: api/projecttask/5
public void Put(int id, projecttask value)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
var existingptask = db.Projecttasks.Where(ptask => ptask.projecttask_id == id).FirstOrDefault();
if (existingptask != null)
{
existingptask.assignedto = value.assignedto;
existingptask.taskstartdate = value.taskstartdate;
existingptask.taskenddate = value.taskenddate;
existingptask.taskcompletion = value.taskcompletion;
existingptask.userstory_id = value.userstory_id;
}
db.SaveChanges();
}
