public List <Project> GetAllProjects()
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
return(db.Projects.Select(pro => pro).ToList());
}
// GET: api/projecttask
public IEnumerable <projecttask> Get()
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
return(db.Projecttasks.Select(t => t).ToList());
//return new string[] { "value1", "value2" };
}
// POST: api/Userstory
public void Post(Userstory value)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
db.Userstories.Add(value);
db.SaveChanges();
}
public static void Delete(managercomments comment)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
db.Managercomments.Remove(comment);
db.SaveChanges();
}
public Userstory searchbyid(Userstory u)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
return((Userstory)db.Userstories.Where(story => story.userstory_id == u.userstory_id));
}
// GET: api/projecttask/5
public projecttask Get(int id)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
return(db.Projecttasks.Where(pro => pro.projecttask_id == id).FirstOrDefault());
//return "value";
}
public static void Create(managercomments comment)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
db.Managercomments.Add(comment);
db.SaveChanges();
}
public Employee searchbyname(Employee e)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
return(db.Employees.Where(emp => emp.employee_name == e.employee_name).FirstOrDefault());
}
public Project searchbyname(Project p)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
return((Project)db.Projects.Where(Pro => Pro.project_name == p.project_name).FirstOrDefault());
}
public List <Employee> GetAllEmployees()
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
return(db.Employees.Select(emp => emp).ToList());
}
// POST: api/Employee
public void Post(Employee value)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
db.Employees.Add(value);
db.SaveChanges();
}
// POST: api/Project
public void Post(Project value)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
db.Projects.Add(value);
db.SaveChanges();
}
public projecttask searchbyid(projecttask t)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
return((projecttask)db.Projecttasks.Where(ta => ta.projecttask_id == t.projecttask_id));
}
public void CreateNewProject(Project P)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
db.Projects.Add(P);
db.SaveChanges();
}
// GET: api/ManagerComment/5
public managercomments Get(int id)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
managercomments comment = new managercomments();
comment.managercomment_id = id;
return(CommentsRepository.Search(comment, db));
}
public Employee searchbyid(Employee e, ProjectTrackingDbcontext db)
{
//ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
return(db.Employees.Where(emp => emp.employee_id == e.employee_id).FirstOrDefault());
}
public void CreateNewUserstory(Userstory u)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
db.Userstories.Add(u);
db.SaveChanges();
}
public void CreateNewTask(projecttask t)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
db.Projecttasks.Add(t);
db.SaveChanges();
}
// DELETE: api/ManagerComment/5
public void Delete(int id)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
managercomments com = db.Managercomments.Where(c => c.managercomment_id == id).FirstOrDefault();
db.Managercomments.Remove(com);
db.SaveChanges();
}
public void CreateNewEmployee(Employee e)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
db.Employees.Add(e);
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();
}
// GET: api/Project
public IEnumerable <Project> Get()
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
return(db.Projects.ToList());
//return new string[] { "value1", "value2" };
}
// DELETE: api/Employee/5
public void Delete(int id)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
Employee emp = db.Employees.Where(em => em.employee_id == id).FirstOrDefault();
db.Employees.Remove(emp);
db.SaveChanges();
}
// DELETE: api/Userstory/5
public void Delete(int id)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
Userstory user = db.Userstories.Where(u => u.userstory_id == id).FirstOrDefault();
db.Userstories.Remove(user);
db.SaveChanges();
}
public static void Edit(managercomments comment)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
managercomments c = Search(comment, db);
c.comments = comment.comments;
c.projecttask_id = comment.projecttask_id;
db.SaveChanges();
}
// DELETE: api/Project/5
public void Delete(int id)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
Project pro = db.Projects.Where(p => p.project_id == id).FirstOrDefault();
db.Projects.Remove(pro);
db.SaveChanges();
}
public void DeleteProject(Project p)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
Project pro = db.Projects.Where(pr => pr.project_id == p.project_id).FirstOrDefault();
db.Projects.Remove(p);
db.SaveChanges();
}
public void DeleteEmployee(Userstory u)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
Userstory user = db.Userstories.Where(story => story.userstory_id == u.userstory_id).FirstOrDefault();
db.Userstories.Remove(u);
db.SaveChanges();
}
public void Edit(Userstory u)
{
ProjectTrackingDbcontext db = new ProjectTrackingDbcontext();
Userstory u1 = searchbyid(u);
u.story = u1.story;
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();
}