public static void CreateTasks(Tasks task) { ProjectEntiryDbcontext db = new ProjectEntiryDbcontext(); db.Tasks.Add(task); db.SaveChanges(); }
public static void CreateStory(Userstories story) { ProjectEntiryDbcontext db = new ProjectEntiryDbcontext(); db.Userstories.Add(story); db.SaveChanges(); }
public static void CreateProject(Projects pro) { ProjectEntiryDbcontext db = new ProjectEntiryDbcontext(); db.Projects.Add(pro); db.SaveChanges(); }
public static void Create(ManagerComment comment) { ProjectEntiryDbcontext db = new ProjectEntiryDbcontext(); db.ManagerComments.Add(comment); db.SaveChanges(); }
public static void Delete(ManagerComment comment) { ProjectEntiryDbcontext db = new ProjectEntiryDbcontext(); comment = Search(comment, db); db.ManagerComments.Remove(comment); db.SaveChanges(); }
public static void DeleteEmpo(Employees emp) { ProjectEntiryDbcontext db = new ProjectEntiryDbcontext(); Employees e = SearchEmployee(emp, db); db.Employees.Remove(e); db.SaveChanges(); }
public static void DeleteTask(Tasks task) { ProjectEntiryDbcontext db = new ProjectEntiryDbcontext(); Tasks t = SearchTask(task, db); db.Tasks.Remove(t); db.SaveChanges(); }
// GET: api/ManagerComment/5 public ManagerComment Get(int id) { ProjectEntiryDbcontext db = new ProjectEntiryDbcontext(); ManagerComment comment = new ManagerComment(); comment.managerid = id; return(CommentsRepository.Search(comment, db)); }
public static void DeleteProject(Projects pro) { ProjectEntiryDbcontext db = new ProjectEntiryDbcontext(); Projects p = SearchProjects(pro, db); db.Projects.Remove(p); db.SaveChanges(); }
public static void DeleteStory(Userstories story) { ProjectEntiryDbcontext db = new ProjectEntiryDbcontext(); Userstories u = UserStoriesRepository.SearchStory(story, db); db.Userstories.Remove(u); db.SaveChanges(); }
public static void Edit(Userstories user) { ProjectEntiryDbcontext db = new ProjectEntiryDbcontext(); Userstories u = SearchStory(user, db); u.projectid = user.projectid; u.story = user.story; db.SaveChanges(); }
public static void Edit(ManagerComment comment) { ProjectEntiryDbcontext db = new ProjectEntiryDbcontext(); ManagerComment c = Search(comment, db); c.comments = comment.comments; c.taskid = comment.taskid; db.SaveChanges(); }
public static void Edit(Projects pro) { ProjectEntiryDbcontext db = new ProjectEntiryDbcontext(); Projects p = SearchProjects(pro, db); p.projectname = pro.projectname; p.startdate = pro.startdate; p.enddate = pro.enddate; p.clientname = pro.clientname; db.SaveChanges(); }
public static void CreateEmployee(Employees emp) { if (emp.managerid == 0) { emp.managerid = null; } ProjectEntiryDbcontext db = new ProjectEntiryDbcontext(); db.Employees.Add(emp); db.SaveChanges(); }
public static void Edit(Tasks task) { ProjectEntiryDbcontext db = new ProjectEntiryDbcontext(); Tasks t = SearchTask(task, db); t.empid = task.empid; t.taskstartdate = task.taskstartdate; t.taskenddate = task.taskenddate; t.taskcompletion = task.taskcompletion; t.userstoryid = task.userstoryid; db.SaveChanges(); }
public static void Edit(Employees emp) { ProjectEntiryDbcontext db = new ProjectEntiryDbcontext(); Employees e = SearchEmployee(emp, db); e.employeename = emp.employeename; e.designation = emp.designation; e.contactno = emp.contactno; e.managerid = emp.managerid; e.emailid = emp.emailid; e.skillset = emp.skillset; db.SaveChanges(); }
public static Tasks SearchTask(Tasks task, ProjectEntiryDbcontext db) { return(db.Tasks.Select(t => t).Where(t => t.projecttaskid == task.projecttaskid).FirstOrDefault()); }
public static List <Tasks> ShowAllTasks() { ProjectEntiryDbcontext db = new ProjectEntiryDbcontext(); return(db.Tasks.Select(task => task).ToList()); }
public static List <Userstories> ShowAllStories() { ProjectEntiryDbcontext db = new ProjectEntiryDbcontext(); return(db.Userstories.Select(story => story).ToList()); }
public static Projects SearchProjects(Projects pro) { ProjectEntiryDbcontext db = new ProjectEntiryDbcontext(); return((db.Projects.Select(p => p).Where(p => p.projectid == pro.projectid)).First()); }
public static List <Projects> ShowAllProjects() { ProjectEntiryDbcontext db = new ProjectEntiryDbcontext(); return(db.Projects.Select(pro => pro).ToList()); }
public static Tasks SearchTask(Tasks task) { ProjectEntiryDbcontext db = new ProjectEntiryDbcontext(); return((db.Tasks.Select(t => t).Where(t => t.projecttaskid == task.projecttaskid)).First()); }
public static List <ManagerComment> ShowAll() { ProjectEntiryDbcontext db = new ProjectEntiryDbcontext(); return(db.ManagerComments.Select(comment => comment).ToList()); }
public static List <Employees> ShowAllEmployees() { ProjectEntiryDbcontext db = new ProjectEntiryDbcontext(); return(db.Employees.Select(emp => emp).ToList()); }
public static Employees SearchEmployee(Employees emp) { ProjectEntiryDbcontext db = new ProjectEntiryDbcontext(); return((db.Employees.Select(e => e).Where(e => e.employeeid == emp.employeeid)).First()); }
public static ManagerComment Search(ManagerComment comment, ProjectEntiryDbcontext db) { return((db.ManagerComments.Select(s => s).Where(s => s.managerid == comment.managerid)).First()); }
public static Userstories SearchStory(Userstories story) { ProjectEntiryDbcontext db = new ProjectEntiryDbcontext(); return((db.Userstories.Select(s => s).Where(s => s.userstoryid == story.userstoryid)).First()); }
public static List <ManagerComment> Getbytask(int id) { ProjectEntiryDbcontext db = new ProjectEntiryDbcontext(); return(db.ManagerComments.Select(m => m).Where(m => m.taskid == id).ToList()); }