// 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()); }