public IEnumerable <Employee> ListEmployeesByPosition(String position)
{
Dictionary <String, String> dict = new Dictionary <String, String> {
{ ConstOfStoreProcedures.PARAM_POS_FOR_PROC_GET_EMPLOYEES_BY_POSITION,
position }
};
var param = SqlParametrHelper.FillSqlParametrs(dict);
return(EmployeeConvertor.FromDTO(dataSetExecutor.Get(ConstOfStoreProcedures.PROC_GET_EMPLOYEES_BY_POSITION, param)));
}
public void DeleteEmployee(Employee employee)
{
var employeeDTO = EmployeeConvertor.ToDTO(employee);
Dictionary <String, Int32> dictParams = new Dictionary <String, Int32> {
{ ConstOfStoreProcedures.PARAM_IDEMPLOYEE_FOR_DELETE_EMPLOYEE, employeeDTO.EmployeeId },
{ ConstOfStoreProcedures.PARAM_IDPOSITION_FOR_DELETE_EMPLOYEE, employeeDTO.PositionId },
{ ConstOfStoreProcedures.PARAM_IDSALARY_FOR_DELETE_EMPLOYEE, employeeDTO.SalaryId }
};
var param = SqlParametrHelper.FillSqlParametrs(dictParams);
dataSetExecutor.InsertDelete(ConstOfStoreProcedures.PROC_DELETE_EMPLOYEE, param);
}
public void InsertEmployee(Employee employee)
{
var employeeDTO = EmployeeConvertor.ToDTO(employee);
Dictionary <String, String> dictParams = new Dictionary <String, String> {
{ ConstOfStoreProcedures.PARAM_NAME_FOR_PROC_INSERT_EMPLOYEE, employeeDTO.FirstName },
{ ConstOfStoreProcedures.PARAM_LASTNAME_FOR_PROC_INSERT_EMPLOYEE, employeeDTO.LastName },
{ ConstOfStoreProcedures.PARAM_BIRTHDAY_FOR_PROC_INSERT_EMPLOYEE, employeeDTO.Birthday },
{ ConstOfStoreProcedures.PARAM_POSITION_FOR_PROC_INSERT_EMPLOYEE, employeeDTO.PositionName },
{ ConstOfStoreProcedures.PARAM_SALARY_FOR_PROC_INSERT_EMPLOYEE, employeeDTO.Salary.ToString() }
};
var param = SqlParametrHelper.FillSqlParametrs(dictParams);
dataSetExecutor.InsertDelete(ConstOfStoreProcedures.PROC_INSERT_EMPLOYEE, param);
}
