public IEnumerable <Employee> GetAllEmployees()
{
try
{
using (var ctx = new DevoxContext())
{
return(ctx.Employee.ToList());
}
}
catch (Exception e)
{
throw e;
}
}
public IEnumerable <Activity> GetAllActivities()
{
try
{
using (var ctx = new DevoxContext())
{
return(ctx.Activity.ToList());
}
}
catch (Exception e)
{
throw e;
}
}
public IEnumerable <Project> GetAllProjects()
{
try
{
using (var ctx = new DevoxContext())
{
return(ctx.Project.ToList());
}
}
catch (Exception e)
{
throw e;
}
}
public void DeleteActivity(int activityID)
{
try
{
using (var ctx = new DevoxContext())
{
var act = ctx.Activity.FirstOrDefault(x => x.ActivityId == activityID);
ctx.Activity.Remove(act);
}
}
catch (Exception e)
{
throw e;
}
}
public async void UpdateEmployee(Employee emp)
{
try
{
using (var ctx = new DevoxContext())
{
ctx.Employee.Update(emp);
await ctx.SaveChangesAsync();
}
}
catch (Exception e)
{
throw e;
}
}
public Employee GetEmployee(int empID)
{
try
{
using (var ctx = new DevoxContext())
{
var emp = ctx.Employee.FirstOrDefault(x => x.EmployeeId == empID);
return(emp);
}
}
catch (Exception e)
{
throw e;
}
}
public Project GetProject(int projectID)
{
try
{
using (var ctx = new DevoxContext())
{
var p = ctx.Project.FirstOrDefault(x => x.ProjectId == projectID);
return(p);
}
}
catch (Exception e)
{
throw e;
}
}
public async void UpdateActivityType(ActivityType type)
{
try
{
using (var ctx = new DevoxContext())
{
ctx.Update(type);
await ctx.SaveChangesAsync();
}
}
catch (Exception e)
{
throw e;
}
}
public async void UpdateRole(Role role)
{
try
{
using (var ctx = new DevoxContext())
{
ctx.Role.Update(role);
await ctx.SaveChangesAsync();
}
}
catch (Exception e)
{
throw e;
}
}
public ActivityType GetActivityType(int activityTypeID)
{
try
{
using (var ctx = new DevoxContext())
{
var act = ctx.ActivityType.FirstOrDefault(x => x.ActivityTypeId == activityTypeID);
return(act);
}
}
catch (Exception e)
{
throw e;
}
}
public async void UpdateProject(Project p)
{
try
{
using (var ctx = new DevoxContext())
{
ctx.Project.Update(p);
await ctx.SaveChangesAsync();
}
}
catch (Exception e)
{
throw e;
}
}
public Role GetRole(int roleID)
{
try
{
using (var ctx = new DevoxContext())
{
var role = ctx.Role.FirstOrDefault(x => x.RoleId == roleID);
return(role);
}
}
catch (Exception e)
{
throw e;
}
}
public async void DeleteActivityType(int activityTypeID)
{
try
{
using (var ctx = new DevoxContext())
{
var act = ctx.ActivityType.FirstOrDefault(x => x.ActivityTypeId == activityTypeID);
ctx.ActivityType.Remove(act);
await ctx.SaveChangesAsync();
}
}
catch (Exception e)
{
throw e;
}
}
public async void DeleteRole(int roleID)
{
try
{
using (var ctx = new DevoxContext())
{
var role = ctx.Role.FirstOrDefault(x => x.RoleId == roleID);
ctx.Remove(role);
await ctx.SaveChangesAsync();
}
}
catch (Exception e)
{
throw e;
}
}
public async void DeleteEmployee(int empID)
{
try
{
using (var ctx = new DevoxContext())
{
var emp = ctx.Employee.FirstOrDefault(x => x.EmployeeId == empID);
ctx.Employee.Remove(emp);
await ctx.SaveChangesAsync();
}
}
catch (Exception e)
{
throw e;
}
}
public async Task DeleteProject(int projectID)
{
try
{
using (var ctx = new DevoxContext())
{
var p = ctx.Project.FirstOrDefault(x => x.ProjectId == projectID);
ctx.Remove(p);
await ctx.SaveChangesAsync();
}
}
catch (Exception e)
{
throw e;
}
}
public async Task <int> CreateEmployeeAsync(Employee emp)
{
try
{
using (var ctx = new DevoxContext())
{
var r = await ctx.AddAsync(emp);
await ctx.SaveChangesAsync();
return(r.Entity.EmployeeId);
}
}
catch (Exception e)
{
throw e;
}
}
public async Task <int> CreateActivityTypeAsync(ActivityType type)
{
try
{
using (var ctx = new DevoxContext())
{
var r = await ctx.ActivityType.AddAsync(type);
await ctx.SaveChangesAsync();
return(r.Entity.ActivityTypeId);
}
}
catch (Exception e)
{
throw e;
}
}
public async Task <int> CreateRoleAsync(Role role)
{
try
{
using (var ctx = new DevoxContext())
{
var r = await ctx.Role.AddAsync(role);
return(r.Entity.RoleId);
await ctx.SaveChangesAsync();
}
}
catch (Exception e)
{
throw e;
}
}
public async Task <int> CreateProjectAsync(Project p)
{
try
{
using (var ctx = new DevoxContext())
{
var proj = await ctx.Project.AddAsync(p);
await ctx.SaveChangesAsync();
return(proj.Entity.ProjectId);
}
}
catch (Exception e)
{
throw e;
}
}
