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