public void AddStatus(Statuses status)
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
db.Statuses.Add(status);
db.SaveChanges();
}
public void AddGender(Genders gender)
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
db.Genders.Add(gender);
db.SaveChanges();
}
public void AddPosition(Positions position)
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
db.Positions.Add(position);
db.SaveChanges();
}
public void AddEmployee(Employees employee)
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
db.Employees.Add(employee);
db.SaveChanges();
}
public List <EmployeesForView> GetEmployees()
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
return((
from employee in db.Employees
select new EmployeesForView
{
LastName = employee.LastName,
FirstName = employee.FirstName,
Code = employee.Code,
DateBirth = employee.DateBirth,
Pesel = employee.Pesel,
PhoneNumber = employee.PhoneNumber,
AdressEmail = employee.AdressEmail,
ExpirationDateIdentityCard = employee.ExpirationDateIdentityCard,
ExpirationDatePassport = employee.ExpirationDatePassport,
GenderName = employee.Genders.Value,
StatusName = employee.Statuses.Value,
GenderId = employee.GenderId,
ID = employee.ID,
IsseuDateIdentityCard = employee.IsseuDateIdentityCard,
IssueDatePassport = employee.IssueDatePassport,
PassportNumber = employee.PassportNumber,
StatusId = employee.StatusId
}
).ToList());
}
public void AddDepartment(Departments department)
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
db.Departments.Add(department);
db.SaveChanges();
}
public void AddTerminationWay(TerminationWays terminationWay)
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
db.TerminationWays.Add(terminationWay);
db.SaveChanges();
}
public void AddEmploymentHistoryEdu(EmploymentHistoryEducation employmentHistoryEdu)
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
db.EmploymentHistoryEducation.Add(employmentHistoryEdu);
db.SaveChanges();
}
public void AddCurrency(Currencies currency)
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
db.Currencies.Add(currency);
db.SaveChanges();
}
public void AddContract(Contracts contract)
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
db.Contracts.Add(contract);
db.SaveChanges();
}
public void AddTypeContract(TypeContracts typeContract)
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
db.TypeContracts.Add(typeContract);
db.SaveChanges();
}
public void UpdateStatus(Statuses status)
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
db.Statuses.FirstOrDefault(x => x.ID == status.ID).Value = status.Value;
db.SaveChanges();
}
public void UpdateTypeContract(TypeContracts typeContract)
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
db.TypeContracts.FirstOrDefault(x => x.ID == typeContract.ID).Value = typeContract.Value;
db.SaveChanges();
}
public void AddEmploymentHistory(EmploymentHistory employmentHistory)
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
db.EmploymentHistory.Add(employmentHistory);
db.SaveChanges();
}
public void AddTypeRate(TypeRates typeRate)
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
db.TypeRates.Add(typeRate);
db.SaveChanges();
}
public List <ContractsForView> GetContracts()
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
return((
from contract in db.Contracts
select new ContractsForView
{
ID = contract.ID,
CurrencyId = contract.CurrencyId,
CurrencyName = contract.Currencies.Value,
DateFrom = contract.DateFrom,
DateTo = contract.DateTo,
DepartmentId = contract.DepartmentId,
EmployeDepartmentName = contract.Departments.Name,
TypeContractsID = contract.TypeContractsID,
TypeContractName = contract.TypeContracts.Value,
TerminationWayId = contract.TerminationWayId,
TerminationWayName = contract.TerminationWays.Value,
Salary = contract.Salary,
EmployeeName = contract.Employees.FirstName + " " + contract.Employees.LastName,
EmployeeId = contract.EmployeeId,
PositionId = contract.PositionId,
PositionName = contract.Positions.Name,
TypeRateId = contract.TypeRateId,
TypeRateName = contract.TypeRates.Value
}
).ToList());
}
public void UpdateGender(Genders gender)
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
db.Genders.FirstOrDefault(x => x.ID == gender.ID).Value = gender.Value;
db.SaveChanges();
}
public void UpdateCurrency(Currencies currency)
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
db.Currencies.FirstOrDefault(x => x.ID == currency.ID).Value = currency.Value;
db.SaveChanges();
}
public void UpdateDepartment(Departments departent)
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
db.Departments.FirstOrDefault(x => x.ID == departent.ID).Name = departent.Name;
db.Departments.FirstOrDefault(x => x.ID == departent.ID).Location = departent.Location;
db.Departments.FirstOrDefault(x => x.ID == departent.ID).ManagerId = departent.ManagerId;
db.SaveChanges();
}
public int?EmployeeCount(int idDepartment)
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
return((from emp in db.Contracts
where emp.DepartmentId == idDepartment
select emp
).Count());
}
public IQueryable <Employees> EmployeeDepartment(int idDepartment)
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
return(from emp in db.Contracts
where emp.DepartmentId == idDepartment
select emp.Employees
);
}
public void UpdatePosition(Positions position)
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
db.Positions.FirstOrDefault(x => x.ID == position.ID).Name = position.Name;
db.Positions.FirstOrDefault(x => x.ID == position.ID).MinSalary = position.MinSalary;
db.Positions.FirstOrDefault(x => x.ID == position.ID).MaxSalary = position.MaxSalary;
db.SaveChanges();
}
public int?EmployeeSalariesRaport(decimal?salaryFrom, decimal?salaryTo)
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
return((from emp in db.Contracts
where emp.Salary >= salaryFrom && emp.Salary <= salaryTo
select emp
).Count());
}
public int?EmployeeIsActive(DateTime dateFrom, DateTime dateTo)
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
return((from emp in db.Contracts
where emp.DateFrom >= dateFrom && emp.DateTo <= dateTo &&
emp.Employees.StatusId == 2
select emp
).Count());
}
public IQueryable <Employees> EmployeeEndContract(int idStatus, DateTime?dateFrom, DateTime?dateTo)
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
return(from emp in db.Contracts
where emp.DateFrom >= dateFrom &&
emp.DateTo <= dateTo &&
emp.Employees.StatusId == idStatus
select emp.Employees
);
}
public IQueryable <Employees> EmployeeSalaries(int idEmployee, decimal salaryFrom, decimal salaryTo)
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
return(from emp in db.Contracts
where emp.EmployeeId == idEmployee &&
emp.Positions.MinSalary >= salaryFrom &&
emp.Positions.MaxSalary <= salaryTo
select emp.Employees
);
}
public List <TypeRatesForView> GetTyperates()
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
return((
from typeRate in db.TypeRates
select new TypeRatesForView
{
ID = typeRate.ID,
Value = typeRate.Value
}
).ToList());
}
public void UpdateEmpHistEdu(EmploymentHistoryEducation employmentHistoryEdu)
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
db.EmploymentHistoryEducation.FirstOrDefault(x => x.ID == employmentHistoryEdu.ID).EmployeeId = employmentHistoryEdu.EmployeeId;
db.EmploymentHistoryEducation.FirstOrDefault(x => x.ID == employmentHistoryEdu.ID).SchoolAdress = employmentHistoryEdu.SchoolAdress;
db.EmploymentHistoryEducation.FirstOrDefault(x => x.ID == employmentHistoryEdu.ID).Comments = employmentHistoryEdu.Comments;
db.EmploymentHistoryEducation.FirstOrDefault(x => x.ID == employmentHistoryEdu.ID).DateFrom = employmentHistoryEdu.DateFrom;
db.EmploymentHistoryEducation.FirstOrDefault(x => x.ID == employmentHistoryEdu.ID).DateTo = employmentHistoryEdu.DateTo;
db.EmploymentHistoryEducation.FirstOrDefault(x => x.ID == employmentHistoryEdu.ID).SchoolName = employmentHistoryEdu.SchoolName;
db.EmploymentHistoryEducation.FirstOrDefault(x => x.ID == employmentHistoryEdu.ID).CertificateName = employmentHistoryEdu.CertificateName;
db.SaveChanges();
}
public List <CurrenciesForView> GetCurrencies()
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
return((
from currency in db.Currencies
select new CurrenciesForView
{
ID = currency.ID,
Value = currency.Value
}
).ToList());
}
public List <TypeContractsForView> GetTypeContracts()
{
HumanResourcesDBEntities db = new HumanResourcesDBEntities();
return((
from typeContract in db.TypeContracts
select new TypeContractsForView
{
ID = typeContract.ID,
Value = typeContract.Value
}
).ToList());
}
