// POST: api/Employee
public void Post(Employee value)
{
ProjectdbContext db = new ProjectdbContext();
db.Employees.Add(value);
db.SaveChanges();
}
// POST: api/Managercomments
public void Post([FromBody] Managercomments value)
{
ProjectdbContext db = new ProjectdbContext();
db.Mcom.Add(value);
db.SaveChanges();
}
// POST: api/Userstory
public void Post(Userstory value)
{
ProjectdbContext db = new ProjectdbContext();
db.Userstories.Add(value);
db.SaveChanges();
}
// POST: api/Project
public void Post([FromBody] Project value)
{
ProjectdbContext db = new ProjectdbContext();
db.Project.Add(value);
db.SaveChanges();
}
// DELETE: api/Managercomments/5
public void Delete(int id)
{
ProjectdbContext db = new ProjectdbContext();
var del = db.Mcom.FirstOrDefault(d => d.Commission == id);
if (del != null)
{
db.Mcom.Remove(del);
db.SaveChanges();
}
}
// DELETE: api/Userstory/5
public void Delete(int id)
{
ProjectdbContext db = new ProjectdbContext();
var del = db.Userstories.FirstOrDefault(d => d.Us_id == id);
if (del != null)
{
db.Userstories.Remove(del);
db.SaveChanges();
}
}
// PUT: api/Userstory/5
public void Put(int id, [FromBody] Userstory value)
{
ProjectdbContext db = new ProjectdbContext();
Userstory user = db.Userstories.Where(emp => emp.Us_id == id).FirstOrDefault();
if (user != null)
{
user.story = value.story;
user.Project_id = value.Project_id;
db.SaveChanges();
}
}
// PUT: api/Managercomments/5
public void Put(int id, [FromBody] Managercomments value)
{
ProjectdbContext db = new ProjectdbContext();
Managercomments com = db.Mcom.Where(emp => emp.Commission == id).FirstOrDefault();
if (com != null)
{
com.Comments = value.Comments;
com.Pid = value.Pid;
db.SaveChanges();
}
}
// PUT: api/Project/5
public void Put(int id, [FromBody] Project value)
{
ProjectdbContext db = new ProjectdbContext();
Project project = db.Project.Where(emp => emp.Project_Id == id).FirstOrDefault();
if (project != null)
{
project.Pname = value.Pname;
project.StartDate = value.StartDate;
project.endDate = value.endDate;
project.ClientName = value.ClientName;
db.SaveChanges();
}
}
// PUT: api/Employee/5
public void Put(int id, [FromBody] Employee e)
{
ProjectdbContext db = new ProjectdbContext();
Employee e1 = db.Employees.Where(emp => emp.Eid == id).FirstOrDefault();
if (e1 != null)
{
e1.EName = e.EName;
e1.Desg = e.Desg;
e1.Mid = e.Mid;
e1.Email = e.Email;
e1.SkillSet = e.SkillSet;
db.SaveChanges();
}
}
// PUT: api/Ptask/5
public void Put(int id, [FromBody] Ptask value)
{
ProjectdbContext db = new ProjectdbContext();
Ptask p = db.Ptask.Where(emp => emp.Tid == id).FirstOrDefault();
if (p != null)
{
p.Tid = value.Tid;
p.AsTo = value.AsTo;
p.tsdate = value.tsdate;
p.tedate = value.tedate;
p.Tc = value.Tc;
p.uid = value.uid;
db.SaveChanges();
}
}
// GET: api/Managercomments
public IEnumerable <Managercomments> Get()
{
ProjectdbContext db = new ProjectdbContext();
return(db.Mcom.Select(emp => emp).ToList());
}
// GET: api/Ptask/5
public Ptask Get(int id)
{
ProjectdbContext db = new ProjectdbContext();
return(db.Ptask.Where(d => d.Tid == id).FirstOrDefault());
}
// GET: api/Userstory/5
public Userstory Get(int id)
{
ProjectdbContext db = new ProjectdbContext();
return(db.Userstories.Where(emp => emp.Us_id == id).FirstOrDefault());
}
// GET: api/Userstory
public IEnumerable <Userstory> Get()
{
ProjectdbContext db = new ProjectdbContext();
return(db.Userstories.Select(emp => emp).ToList());
}
// GET: api/Project
public IEnumerable <Project> Get()
{
ProjectdbContext db = new ProjectdbContext();
return(db.Project.Select(emp => emp).ToList());
}
// GET: api/Employee/5
public Employee Get(int id)
{
ProjectdbContext db = new ProjectdbContext();
return(db.Employees.Where(d => d.Eid == id).FirstOrDefault());
}
// GET: api/Employee
public IEnumerable <Employee> Get()
{
ProjectdbContext db = new ProjectdbContext();
return(db.Employees.Select(emp => emp).ToList());
}
// GET: api/Managercomments/5
public Managercomments Get(int id)
{
ProjectdbContext db = new ProjectdbContext();
return(db.Mcom.Where(d => d.Commission == id).FirstOrDefault());
}
// GET: api/Project/5
public Project Get(int id)
{
ProjectdbContext db = new ProjectdbContext();
return(db.Project.Where(d => d.Project_Id == id).FirstOrDefault());
}
