public static void Create(Employee e)
{
ProjectTrackingContest Db = new ProjectTrackingContest();
Db.Employee.Add(e);
Db.SaveChanges();
}
public static void Create(Userstory u)
{
ProjectTrackingContest Db = new ProjectTrackingContest();
Db.userstory.Add(u);
Db.SaveChanges();
}
public static void Create(Manager comment)
{
ProjectTrackingContest Db = new ProjectTrackingContest();
Db.manager.Add(comment);
Db.SaveChanges();
}
public static void Create(ProjTask p)
{
ProjectTrackingContest Db = new ProjectTrackingContest();
Db.projtask.Add(p);
Db.SaveChanges();
}
public static void Edit(Manager comment)
{
ProjectTrackingContest Db = new ProjectTrackingContest();
Manager c = Search(comment, Db);
c.comment = comment.comment;
c.tid = comment.tid;
Db.SaveChanges();
}
public static void Delete(int mid)
{
ProjectTrackingContest Db = new ProjectTrackingContest();
var manager = Db.manager.FirstOrDefault(s => s.mcid == mid);
if (manager != null)
{
Db.manager.Remove(manager);
Db.SaveChanges();
}
}
public static void Edit(Userstory u)
{
ProjectTrackingContest Db = new ProjectTrackingContest();
Userstory e1 = Search(u, Db);
e1.userstoryid = u.userstoryid;
e1.story = u.story;
e1.ProjId = u.ProjId;
Db.SaveChanges();
}
public static void Delete(int tid)
{
ProjectTrackingContest Db = new ProjectTrackingContest();
var protask = Db.projtask.FirstOrDefault(u => u.tid == tid);
if (protask != null)
{
Db.projtask.Remove(protask);
Db.SaveChanges();
}
}
public static void Delete(int eid)
{
ProjectTrackingContest Db = new ProjectTrackingContest();
var Employee = Db.Employee.FirstOrDefault(s => s.employeeID == eid);
if (Employee != null)
{
Db.Employee.Remove(Employee);
Db.SaveChanges();
}
}
public static void Delete(int uid)
{
ProjectTrackingContest Db = new ProjectTrackingContest();
var user = Db.userstory.FirstOrDefault(u => u.userstoryid == uid);
if (user != null)
{
Db.userstory.Remove(user);
Db.SaveChanges();
}
}
public static void Edit(ProjTask t)
{
ProjectTrackingContest Db = new ProjectTrackingContest();
ProjTask ta = SearchById(t, Db);
ta.assignedto = t.assignedto;
ta.startdate = t.startdate;
ta.enddate = t.enddate;
ta.completion = t.completion;
ta.userstoryid = t.userstoryid;
Db.SaveChanges();
}
public static void Edit(Employee e)
{
ProjectTrackingContest Db = new ProjectTrackingContest();
Employee e1 = Search(e, Db);
e1.employeeID = e.employeeID;
e1.FirstName = e.FirstName;
e1.LastName = e.LastName;
e1.Age = e.Age;
e1.ManagerId = e.ManagerId;
e1.EmailId = e.EmailId;
e1.salary = e.salary;
Db.SaveChanges();
}
// GET: api/Project/5
public Project Get(int id)
{
ProjectTrackingContest Db = new ProjectTrackingContest();
return(Db.Project.Where(p => p.ProjId == id).FirstOrDefault());
}
// GET: api/Userstory/5
public Userstory Get(int id)
{
ProjectTrackingContest Db = new ProjectTrackingContest();
return(Db.userstory.Where(p => p.userstoryid == id).FirstOrDefault());
}
// GET: api/Userstory
public IEnumerable <Userstory> Get()
{
ProjectTrackingContest Db = new ProjectTrackingContest();
return(Db.userstory.Select(u => u).ToList());
}
// GET: api/Employee/5
public Employee Get(int id)
{
ProjectTrackingContest Db = new ProjectTrackingContest();
return(Db.Employee.Where(p => p.employeeID == id).FirstOrDefault());
}
// GET: api/Employee
public IEnumerable <Employee> Get()
{
ProjectTrackingContest Db = new ProjectTrackingContest();
return(Db.Employee.Select(emp => emp).ToList());
}
// GET: api/ProjTask/5
public ProjTask Get(int id)
{
ProjectTrackingContest Db = new ProjectTrackingContest();
return(Db.projtask.Where(p => p.tid == id).FirstOrDefault());
}
public static ProjTask SearchById(ProjTask ta, ProjectTrackingContest Db)
{
return((Db.projtask.Select(t => t).Where(t => t.tid == ta.tid)).First());
}
public static List <Manager> ShowAll()
{
ProjectTrackingContest Db = new ProjectTrackingContest();
return(Db.manager.Select(comment => comment).ToList());
}
// GET: api/Manager/5
public Manager Get(int id)
{
ProjectTrackingContest Db = new ProjectTrackingContest();
return(Db.manager.Where(p => p.mcid == id).FirstOrDefault());
}
// GET: api/Manager
public IEnumerable <Manager> Get()
{
ProjectTrackingContest Db = new ProjectTrackingContest();
return(Db.manager.Select(emp => emp).ToList());
}
// GET: api/Project
public IEnumerable <Project> Get()
{
ProjectTrackingContest Db = new ProjectTrackingContest();
return(Db.Project.Select(p => p).ToList());
}
public static Userstory Search(Userstory uid, ProjectTrackingContest Db)
{
return(Db.userstory.Select(u => u).Where(u => u.userstoryid == uid.userstoryid).First());
}
// GET: api/ProjTask
public IEnumerable <ProjTask> Get()
{
ProjectTrackingContest Db = new ProjectTrackingContest();
return(Db.projtask.Select(emp => emp).ToList());
}
public static Manager Search(Manager comment, ProjectTrackingContest Db)
{
return((Db.manager.Select(s => s).Where(s => s.mcid == comment.mcid)).First());
}
public static Employee Search(Employee eid, ProjectTrackingContest Db)
{
return(Db.Employee.Select(emp => emp).Where(emp => emp.employeeID == eid.employeeID).First());
}
