public async Task <IActionResult> InsertEmployee([FromBody] Entities.Concrete.Employee.Employee employeeRequest)
{
ActionResultResponse <EmployeeResponse> response;
Entities.Concrete.Employee.Employee employee = null;
try
{
if (_service.ValidateEmployee(employeeRequest.CompanyID, employeeRequest.UserName, false))
{
if (_service.InsertEmployee(employeeRequest))
{
employee = _service.GetEmployeeByCompanyID(employeeRequest.CompanyID);
}
response = EmployeeMapper.EmployeeGetByIdResult(employee);
}
else
{
response = new ActionResultResponse <EmployeeResponse>(System.Net.HttpStatusCode.Locked, MessageException.GetEmployeeAlreadyExists(employeeRequest.CompanyID, employeeRequest.UserName), null);
}
}
catch (Exception ex)
{
LogException.WriteLog(ex, "EmployeeController.InsertEmployee", JsonSerializer.Serialize(employeeRequest), LogType.Error);
response = new ActionResultResponse <EmployeeResponse>(System.Net.HttpStatusCode.InternalServerError, MessageException.GetGeneralMessage(ex), null);
}
return(GetResponse(response));
}
public static ActionResultResponse <EmployeeResponse> EmployeeGetByIdResult(Entities.Concrete.Employee.Employee prmEmployee)
{
EmployeeResponse response = new EmployeeResponse()
{
Employee = prmEmployee
};
return(new ActionResultResponse <EmployeeResponse>(System.Net.HttpStatusCode.OK, string.Empty, response));
}
public async Task <IActionResult> GetDummyEmployee()
{
Entities.Concrete.Employee.Employee employee = new Entities.Concrete.Employee.Employee();
ActionResultResponse <EmployeeResponse> response;
try
{
response = EmployeeMapper.EmployeeGetByIdResult(employee);
}
catch (Exception ex)
{
LogException.WriteLog(ex, "EmployeeController.InsertEmployee", JsonSerializer.Serialize(employee), LogType.Error);
response = new ActionResultResponse <EmployeeResponse>(System.Net.HttpStatusCode.InternalServerError, MessageException.GetGeneralMessage(ex), null);
}
return(GetResponse(response));
}
/// <summary>
/// Metodo utilitario para llenar parametros de un objeto SQLCommand, se usa en el insert y update(usan los mismos paramentros).
/// </summary>
/// <param name="prmCommand"> Objeto SQLCommand previamente instanciado.</param>
/// <param name="prmEmployee"></param>
public static void EntityToParameters(ref SqlCommand prmCommand, Entities.Concrete.Employee.Employee prmEmployee)
{
prmCommand.Parameters.Add(new SqlParameter {
ParameterName = "@prmCompanyID", SqlDbType = SqlDbType.BigInt, Direction = ParameterDirection.Input, Value = prmEmployee.CompanyID
});
prmCommand.Parameters.Add(new SqlParameter {
ParameterName = "@prmName", SqlDbType = SqlDbType.VarChar, Direction = ParameterDirection.Input, Value = prmEmployee.Name.Trim()
});
prmCommand.Parameters.Add(new SqlParameter {
ParameterName = "@prmUserName", SqlDbType = SqlDbType.VarChar, Direction = ParameterDirection.Input, Size = 50, Value = prmEmployee.UserName.Trim()
});
prmCommand.Parameters.Add(new SqlParameter {
ParameterName = "@prmEmail", SqlDbType = SqlDbType.VarChar, Direction = ParameterDirection.Input, Value = prmEmployee.Email.Trim()
});
prmCommand.Parameters.Add(new SqlParameter {
ParameterName = "@prmPassword", SqlDbType = SqlDbType.VarChar, Direction = ParameterDirection.Input, Value = Encryptor.EncryptSHA1Managed(prmEmployee.Password.Trim())
});
prmCommand.Parameters.Add(new SqlParameter {
ParameterName = "@prmTelephone", SqlDbType = SqlDbType.VarChar, Direction = ParameterDirection.Input, Value = prmEmployee.Telephone.Trim()
});
prmCommand.Parameters.Add(new SqlParameter {
ParameterName = "@prmFax", SqlDbType = SqlDbType.VarChar, Direction = ParameterDirection.Input, Value = prmEmployee.Fax.Trim()
});
prmCommand.Parameters.Add(new SqlParameter {
ParameterName = "@prmPortalID", SqlDbType = SqlDbType.SmallInt, Direction = ParameterDirection.Input, Value = prmEmployee.PortalID
});
prmCommand.Parameters.Add(new SqlParameter {
ParameterName = "@prmRoleID", SqlDbType = SqlDbType.SmallInt, Direction = ParameterDirection.Input, Value = prmEmployee.RoleID
});
prmCommand.Parameters.Add(new SqlParameter {
ParameterName = "@prmStatusID", SqlDbType = SqlDbType.SmallInt, Direction = ParameterDirection.Input, Value = prmEmployee.StatusID
});
prmCommand.Parameters.Add(new SqlParameter {
ParameterName = "@prmLastLogin", SqlDbType = SqlDbType.DateTime, Direction = ParameterDirection.Input, Value = NullOrEmptyToDBNull(prmEmployee.LastLogin)
});
prmCommand.Parameters.Add(new SqlParameter {
ParameterName = "@prmCreatedOn", SqlDbType = SqlDbType.DateTime, Direction = ParameterDirection.Input, Value = NullOrEmptyToDBNull(prmEmployee.CreatedOn)
});
prmCommand.Parameters.Add(new SqlParameter {
ParameterName = "@prmUpdatedOn", SqlDbType = SqlDbType.DateTime, Direction = ParameterDirection.Input, Value = NullOrEmptyToDBNull(prmEmployee.UpdatedOn)
});
prmCommand.Parameters.Add(new SqlParameter {
ParameterName = "@prmDeletedOn", SqlDbType = SqlDbType.DateTime, Direction = ParameterDirection.Input, Value = NullOrEmptyToDBNull(prmEmployee.DeletedOn)
});
}
public bool InsertEmployee(Entities.Concrete.Employee.Employee prmEmployee)
{
bool result = false;
using (var conn = GetConnection())
{
using (SqlCommand command = new SqlCommand("[dbo].[stpEmployeeInsert]", (SqlConnection)conn))
{
var parametersMapper = command;
command.CommandType = CommandType.StoredProcedure;
EmployeeMapper.EntityToParameters(ref parametersMapper, prmEmployee);
command.Parameters.Add(new SqlParameter {
ParameterName = "@prmSuccessFlag", SqlDbType = SqlDbType.Bit, Direction = ParameterDirection.Output, Value = result
});
var rowsAffected = command.ExecuteNonQuery();
result = (bool)command.Parameters["@prmSuccessFlag"].Value;
}
conn.Close();
}
return(result);
}
public Entities.Concrete.Employee.Employee GetEmployeeByCompanyID(long prmCompanyID)
{
Entities.Concrete.Employee.Employee employee = null;
using (var conn = GetConnection())
{
using (SqlCommand command = new SqlCommand("[dbo].[stpEmployeeSelectByCompanyID]", (SqlConnection)conn))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter {
ParameterName = "@prmCompanyID", SqlDbType = SqlDbType.BigInt, Direction = ParameterDirection.Input, Value = prmCompanyID
});
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
employee = EmployeeMapper.SqlDataReaderToEntity(reader);
}
}
}
conn.Close();
}
return(employee);
}
public bool UpdateEmployee(Entities.Concrete.Employee.Employee prmEmployee)
{
IEmployeeData employeeData = FactoryData.CreateEmployeeData();
return(employeeData.UpdateEmployee(prmEmployee));
}
public bool UpdateEmployee(Entities.Concrete.Employee.Employee prmEmployee)
{
IEmployeeBusiness employeeBusiness = FactoryBusiness.CreateEmployeeBusiness();
return(employeeBusiness.UpdateEmployee(prmEmployee));
}
