public async Task <TM_OPERADOR_EMPRESA> Update(TM_OPERADOR_EMPRESA input)
{
try
{
return(await _operadorEmpresaRepository.Update(input));
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <List <TM_OPERADOR_EMPRESA> > GetCombo(TM_OPERADOR_EMPRESA input)
{
try
{
return(await this._operadorEmpresaRepository.GetCombo(input));
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <TM_OPERADOR_EMPRESA> Get(TM_OPERADOR_EMPRESA input)
{
using (var connection = _connectionFactory.GetConnectionSIROS())
{
var dyParam = new OracleDynamicParameters();
dyParam.Add("num_idnominaxemp_", OracleDbType.Varchar2, ParameterDirection.Input, input.NUM_IDNOMINAXEMP);
dyParam.Add("p_cursor_", OracleDbType.RefCursor, ParameterDirection.Output);
var query = _connectionFactory.GetQueryForSIROS("PKG_EMPRESA.SP_GetListaOperadorEmpxId");
var result = await connection.QueryFirstOrDefaultAsync <TM_OPERADOR_EMPRESA>(query, param : dyParam, commandType : CommandType.StoredProcedure);
return(result);
}
}
public async Task <TM_OPERADOR_EMPRESA> Update(TM_OPERADOR_EMPRESA input)
{
using (var connection = _connectionFactory.GetConnectionSIROS())
{
var dyParam = new OracleDynamicParameters();
dyParam.Add("num_idnominaxemp_ ", OracleDbType.Int32, ParameterDirection.Input, input.NUM_IDNOMINAXEMP);
dyParam.Add("num_idtipooper_", OracleDbType.Varchar2, ParameterDirection.Input, input.NUM_IDTIPOOPER);
dyParam.Add("dte_fecnacimiento_", OracleDbType.Int32, ParameterDirection.Input, input.DTE_FECNACIMIENTO.ToBDSirosDate());
dyParam.Add("str_usuact_", OracleDbType.Varchar2, ParameterDirection.Input, input.STR_USUACT);
dyParam.Add("num_idsesion_", OracleDbType.Int32, ParameterDirection.Input, input.NUM_IDSESION);
dyParam.Add("p_cursor_", OracleDbType.RefCursor, ParameterDirection.Output);
var query = _connectionFactory.GetQueryForSIROS("PKG_EMPRESA.SP_ActualizarOperadorEmp");
var result = await connection.QueryFirstOrDefaultAsync <TM_OPERADOR_EMPRESA>(query, param : dyParam, commandType : CommandType.StoredProcedure);
return(result);
}
}
public async Task <TM_OPERADOR_EMPRESA> Insert(TM_OPERADOR_EMPRESA input)
{
using (var connection = _connectionFactory.GetConnectionSIROS())
{
var dyParam = new OracleDynamicParameters();
dyParam.Add("num_idempresa_", OracleDbType.Int32, ParameterDirection.Input, input.NUM_IDEMPRESA);
dyParam.Add("num_idtpdocumento_", OracleDbType.Int32, ParameterDirection.Input, input.NUM_IDTPDOCUMENTO);
dyParam.Add("str_numdocumento_", OracleDbType.Varchar2, ParameterDirection.Input, input.STR_NUMDOCUMENTO);
dyParam.Add("str_apepaterno_", OracleDbType.Varchar2, ParameterDirection.Input, input.STR_APEPATERNO);
dyParam.Add("str_apematerno_", OracleDbType.Varchar2, ParameterDirection.Input, input.STR_APEMATERNO);
dyParam.Add("str_nombre_", OracleDbType.Varchar2, ParameterDirection.Input, input.STR_NOMBRE);
dyParam.Add("num_idtipooper_", OracleDbType.Varchar2, ParameterDirection.Input, input.NUM_IDTIPOOPER);
dyParam.Add("dte_fecnacimiento_", OracleDbType.Varchar2, ParameterDirection.Input, input.DTE_FECNACIMIENTO.ToBDSirosDate());
dyParam.Add("str_foto_", OracleDbType.Varchar2, ParameterDirection.Input, input.STR_FOTO);
dyParam.Add("str_usucreacion_", OracleDbType.Varchar2, ParameterDirection.Input, input.STR_USUCREACION);
dyParam.Add("num_idsesion_", OracleDbType.Int32, ParameterDirection.Input, input.NUM_IDSESION);
dyParam.Add("p_cursor_", OracleDbType.RefCursor, ParameterDirection.Output);
var query = _connectionFactory.GetQueryForSIROS("PKG_EMPRESA.SP_RegistrarOperadorEmp");
var result = await connection.QueryFirstOrDefaultAsync <TM_OPERADOR_EMPRESA>(query, param : dyParam, commandType : CommandType.StoredProcedure);
return(result);
}
}
public Task <List <TM_OPERADOR_EMPRESA> > GetCombo(TM_OPERADOR_EMPRESA input)
{
throw new NotImplementedException();
}
