public static List <ProjectService> FindProjects(string key)
{
List <ProjectService> projects = null;
using (HumanResourcesDepartmentContext db = new HumanResourcesDepartmentContext())
{
var query = from b in db.Projects
where b.Name.StartsWith(key)
select b;
if (query.Count() > 0)
{
projects = new List <ProjectService>();
foreach (var item in query)
{
projects.Add(new ProjectService
(item.ProjectId,
item.Name,
item.Price));
}
}
}
return(projects);
}
public static List <PositionService> FindPositions(string key)
{
List <PositionService> positions = null;
using (HumanResourcesDepartmentContext db = new HumanResourcesDepartmentContext())
{
var query = from b in db.Positions
where b.Name.StartsWith(key)
select b;
if (query.Count() > 0)
{
positions = new List <PositionService>();
foreach (var item in query)
{
positions.Add(new PositionService
(item.PositionID,
item.Name,
item.Hours,
item.Payment));
}
}
}
return(positions);
}
public static List <EmployeeService> ExtendedFindEmployees(string key, int keyNumber)
{
List <EmployeeService> employees = null;
using (HumanResourcesDepartmentContext db = new HumanResourcesDepartmentContext())
{
var query = from b in db.Employees
where b.Name.StartsWith(key) ||
b.Surname.StartsWith(key) ||
b.AccountNumber.Equals(keyNumber) ||
b.Experience.Equals(keyNumber)
select b;
if (query.Count() > 0)
{
employees = new List <EmployeeService>();
foreach (var item in query)
{
employees.Add(new EmployeeService
(item.Id,
item.Name,
item.Surname,
item.AccountNumber,
item.Experience,
item.Department.Name,
item.Position.Name));
}
}
}
return(employees);
}
public static List <DepartmentService> FindDepartments(string key)
{
List <DepartmentService> departments = null;
using (HumanResourcesDepartmentContext db = new HumanResourcesDepartmentContext())
{
var query = from b in db.Departments
where b.Name.StartsWith(key)
select b;
if (query.Count() > 0)
{
departments = new List <DepartmentService>();
foreach (var item in query)
{
departments.Add(new DepartmentService
(item.DepartmentID,
item.Name));
}
}
}
return(departments);
}
public static List <EmployeeService> GetByPayment()
{
List <EmployeeService> employees = new List <EmployeeService>();
using (HumanResourcesDepartmentContext db = new HumanResourcesDepartmentContext())
{
var query = from b in db.Employees
orderby b.Position.Payment
select b;
foreach (var item in query)
{
EmployeeService toAdd = new EmployeeService
(item.Id,
item.Name,
item.Surname,
item.AccountNumber,
item.Experience,
item.Department.Name,
item.Position.Name);
employees.Add(toAdd);
}
}
return(employees);
}
public static EmployeeService GetTopEmployee(int positionId)
{
EmployeeService employee = null;
using (HumanResourcesDepartmentContext db = new HumanResourcesDepartmentContext())
{
if (db.Positions.Find(positionId) != null && db.Positions.Find(positionId).Employees.Count != 0)
{
List <Employee> dbEmployees = db.Positions.Find(positionId).Employees;
List <EmployeeService> employees = new List <EmployeeService>();
foreach (var item in dbEmployees)
{
EmployeeService toAdd = new EmployeeService(
item.Id,
item.Name,
item.Surname,
item.AccountNumber,
item.Experience,
item.Department.Name,
item.Position.Name);
employees.Add(toAdd);
}
employee = employees.OrderBy(o => o.Experience / o.SumProjectPrice).ToList()[0];
}
}
return(employee);
}
public static List <EmployeeService> GetEmployeeList(int id)
{
List <EmployeeService> employees = new List <EmployeeService>();
using (HumanResourcesDepartmentContext db = new HumanResourcesDepartmentContext())
{
if (db.Departments.Find(id) != null)
{
Department find = db.Departments.Find(id);
List <Employee> findEmployees = db.Departments.Find(id).Employees;
foreach (Employee item in findEmployees)
{
EmployeeService toAdd = new EmployeeService(
item.Id,
item.Name,
item.Surname,
item.AccountNumber,
item.Experience,
item.Department.Name,
item.Position.Name);
employees.Add(toAdd);
}
}
}
return(employees);
}
public static void ChangeHours(int positionId, double hours)
{
using (HumanResourcesDepartmentContext db = new HumanResourcesDepartmentContext())
{
if (db.Positions.Find(positionId) != null)
{
db.Positions.Find(positionId).Hours = hours;
}
}
}
public static void ChangeName(int positionId, string name)
{
using (HumanResourcesDepartmentContext db = new HumanResourcesDepartmentContext())
{
if (db.Positions.Find(positionId) != null)
{
db.Positions.Find(positionId).Name = name;
}
}
}
public static void ChangePayment(int positionId, double payment)
{
using (HumanResourcesDepartmentContext db = new HumanResourcesDepartmentContext())
{
if (db.Positions.Find(positionId) != null)
{
db.Positions.Find(positionId).Payment = payment;
}
}
}
public static void ChangeAccountNumber(int id, int accountNummber)
{
using (HumanResourcesDepartmentContext db = new HumanResourcesDepartmentContext())
{
if (db.Employees.Find(id) != null)
{
db.Employees.Find(id).AccountNumber = accountNummber;
db.SaveChanges();
}
}
}
public static void ChangePosition(int id, int positionId)
{
using (HumanResourcesDepartmentContext db = new HumanResourcesDepartmentContext())
{
if (db.Employees.Find(id) != null)
{
db.Employees.Find(id).Position = db.Positions.Find(positionId);
db.SaveChanges();
}
}
}
public static void ChangeDepartment(int id, int departmentId)
{
using (HumanResourcesDepartmentContext db = new HumanResourcesDepartmentContext())
{
if (db.Employees.Find(id) != null)
{
db.Employees.Find(id).Department = db.Departments.Find(departmentId);
db.SaveChanges();
}
}
}
public static void ChangeExperience(int id, int experience)
{
using (HumanResourcesDepartmentContext db = new HumanResourcesDepartmentContext())
{
if (db.Employees.Find(id) != null)
{
db.Employees.Find(id).Experience = experience;
db.SaveChanges();
}
}
}
public static void ChangeSurname(int id, string surname)
{
using (HumanResourcesDepartmentContext db = new HumanResourcesDepartmentContext())
{
if (db.Employees.Find(id) != null)
{
db.Employees.Find(id).Surname = surname;
db.SaveChanges();
}
}
}
public static void ChangeDepartment(int departmentId, string name)
{
using (HumanResourcesDepartmentContext db = new HumanResourcesDepartmentContext())
{
if (db.Departments.Find(departmentId) != null)
{
db.Departments.Find(departmentId).Name = name;
db.SaveChanges();
}
}
}
public static void AddDepartment(string name)
{
using (HumanResourcesDepartmentContext db = new HumanResourcesDepartmentContext())
{
Department department = new Department {
Name = name
};
db.Departments.Add(department);
db.SaveChanges();
}
}
public static void AddPosition(string name, double hours, double payment)
{
using (HumanResourcesDepartmentContext db = new HumanResourcesDepartmentContext())
{
Position position = new Position {
Name = name, Hours = hours, Payment = payment
};
db.Positions.Add(position);
db.SaveChanges();
}
}
public static void AddProject(string name, int price, int employeeId)
{
using (HumanResourcesDepartmentContext db = new HumanResourcesDepartmentContext())
{
Project project = new Project
{
Name = name,
Price = price,
Employee = db.Employees.Find(employeeId)
};
db.Projects.Add(project);
db.SaveChanges();
}
}
public static bool DeleteDepartments(int departmentId)
{
bool flag = false;
using (HumanResourcesDepartmentContext db = new HumanResourcesDepartmentContext())
{
if (db.Departments.Find(departmentId) != null)
{
db.Departments.Remove(db.Departments.Find(departmentId));
db.SaveChanges();
flag = true;
}
}
return(flag);
}
public static DepartmentService GetDepartment(int departmentId)
{
DepartmentService department = null;
using (HumanResourcesDepartmentContext db = new HumanResourcesDepartmentContext())
{
if (db.Departments.Find(departmentId) != null)
{
Department find = db.Departments.Find(departmentId);
department = new DepartmentService(find.DepartmentID, find.Name);
}
}
return(department);
}
public static void AddEmployee(string name, string surname, int accountnumber,
int experience, int idDepartment, int idPosition)
{
using (HumanResourcesDepartmentContext db = new HumanResourcesDepartmentContext())
{
Employee employee = new Employee
{
Name = name,
Surname = surname,
AccountNumber = accountnumber,
Experience = experience,
Department = db.Departments.Find(idDepartment),
Position = db.Positions.Find(idPosition)
};
db.Employees.Add(employee);
db.SaveChanges();
}
}
public static bool DeleteEmployee(int id)
{
bool flag = false;
using (HumanResourcesDepartmentContext db = new HumanResourcesDepartmentContext())
{
if (db.Employees.Find(id) != null)
{
foreach (var item in db.Employees.Find(id).Projects)
{
item.Employee = null;
}
db.Employees.Remove(db.Employees.Find(id));
db.SaveChanges();
flag = true;
}
}
return(flag);
}
public static List <DepartmentService> GetDepartments()
{
List <DepartmentService> departments = new List <DepartmentService>();
using (HumanResourcesDepartmentContext db = new HumanResourcesDepartmentContext())
{
var query = from b in db.Departments
select b;
foreach (var item in query)
{
DepartmentService toAdd = new DepartmentService(
item.DepartmentID,
item.Name);
departments.Add(toAdd);
}
}
return(departments);
}
public static List <ProjectService> GetEmployeeProjects(int id)
{
List <ProjectService> projects = new List <ProjectService>();
using (HumanResourcesDepartmentContext db = new HumanResourcesDepartmentContext())
{
if (db.Employees.Find(id) != null)
{
List <Project> dbProjects = db.Employees.Find(id).Projects;
foreach (Project item in dbProjects)
{
projects.Add(new ProjectService
(item.ProjectId,
item.Name,
item.Price));
}
}
}
return(projects);
}
public static List <PositionService> GetPositions()
{
List <PositionService> positions = new List <PositionService>();
using (HumanResourcesDepartmentContext db = new HumanResourcesDepartmentContext())
{
var query = from b in db.Positions
select b;
foreach (var item in query)
{
PositionService toAdd = new PositionService(
item.PositionID,
item.Name,
item.Hours,
item.Payment);
positions.Add(toAdd);
}
}
return(positions);
}
public static EmployeeService GetEmployee(int id)
{
EmployeeService employee = null;
Employee find = null;
using (HumanResourcesDepartmentContext db = new HumanResourcesDepartmentContext())
{
if (db.Employees.Find(id) != null)
{
find = db.Employees.Find(id);
employee = new EmployeeService(
find.Id,
find.Name,
find.Surname,
find.AccountNumber,
find.Experience,
find.Department.Name,
find.Position.Name);
}
}
return(employee);
}