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 DeleteStory(Userstories story)
{
ProjectEntiryDbcontext db = new ProjectEntiryDbcontext();
Userstories u = UserStoriesRepository.SearchStory(story, db);
db.Userstories.Remove(u);
db.SaveChanges();
}
public static void DeleteTask(Tasks task)
{
ProjectEntiryDbcontext db = new ProjectEntiryDbcontext();
Tasks t = SearchTask(task, db);
db.Tasks.Remove(t);
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 DeleteProject(Projects pro)
{
ProjectEntiryDbcontext db = new ProjectEntiryDbcontext();
Projects p = SearchProjects(pro, db);
db.Projects.Remove(p);
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 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 CreateEmployee(Employees emp)
{
if (emp.managerid == 0)
{
emp.managerid = null;
}
ProjectEntiryDbcontext db = new ProjectEntiryDbcontext();
db.Employees.Add(emp);
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 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();
}