public int GetDepartmentIdByName(string departmentName)
{
using (var context = new PowerCoEntity())
{
return(context.Deprtments.FirstOrDefault(d => d.DepartmentName == departmentName).DepartmentId);
}
}
public Department GetDepartment(int id)
{
using (var context = new PowerCoEntity())
{
return(context.Deprtments.FirstOrDefault(d => d.DepartmentId == id));
}
}
public void AddUser(User user)
{
using (var context = new PowerCoEntity())
{
context.Users.Add(user);
context.SaveChanges();
}
}
public void RemoveEmployee(int id)
{
using (var context = new PowerCoEntity())
{
var employee = context.Employees.FirstOrDefault(e => id == e.EmployeeId);
context.Employees.Remove(employee);
context.SaveChanges();
}
}
public List <Employee> GetEmployees()
{
using (var context = new PowerCoEntity())
{
return(context.Employees
.Include(e => e.Department)
.Include(e => e.Position)
.ToList());
}
}
public Employee GetEmployee(int id)
{
using (var context = new PowerCoEntity())
{
return(context.Employees
.Include(e => e.Department)
.Include(e => e.Position)
.FirstOrDefault(e => id == e.EmployeeId));
}
}
public void AddEmployee(Employee employee)
{
using (var context = new PowerCoEntity())
{
context.EmployeePositions.Attach(employee.Position);
context.Deprtments.Attach(employee.Department);
context.Employees.Add(employee);
context.SaveChanges();
}
}
public override string[] GetRolesForUser(string username)
{
using (var context = new PowerCoEntity())
{
var user = context.Users.FirstOrDefault(u => u.Name == username);
if (user == null)
{
return(null);
}
else
{
string[] userRoles = user.Roles.Select(x => x.Name).ToArray();
return(userRoles);
}
}
}
