public async Task <TM_FORMULARIO_OGTU> Insert(TM_FORMULARIO_OGTU input)
{
using (var connection = _connectionFactory.GetConnectionSIROS())
{
var dyParam = new OracleDynamicParameters();
dyParam.Add("str_placa_", OracleDbType.Varchar2, ParameterDirection.Input, input.STR_PLACA);
dyParam.Add("num_idempresa_", OracleDbType.Int32, ParameterDirection.Input, input.NUM_IDEMPRESA);
dyParam.Add("num_idsucursalxes_", OracleDbType.Int32, ParameterDirection.Input, input.NUM_IDSUCURSALXES);
dyParam.Add("num_idvehxemp_", OracleDbType.Int32, ParameterDirection.Input, input.NUM_IDVEHXEMP);
dyParam.Add("num_monto_", OracleDbType.Decimal, ParameterDirection.Input, input.NUM_MONTO);
dyParam.Add("dte_fecsum_", OracleDbType.Varchar2, ParameterDirection.Input, input.DTE_FECSUM.ToBDSirosDate());
dyParam.Add("str_horasum_", OracleDbType.Varchar2, ParameterDirection.Input, input.STR_HORASUM);
dyParam.Add("str_minutosum_", OracleDbType.Varchar2, ParameterDirection.Input, input.STR_MINUTOSUM);
dyParam.Add("str_nombrearchivo_", OracleDbType.Varchar2, ParameterDirection.Input, input.STR_NOMBREARCHIVO);
dyParam.Add("num_idtpdocumentoopexemp_", OracleDbType.Int32, ParameterDirection.Input, input.NUM_IDTPDOCUMENTOOPEXEMP);
dyParam.Add("str_numdocumentoopexemp_", OracleDbType.Varchar2, ParameterDirection.Input, input.STR_NUMDOCUMENTOOPEXEMP);
dyParam.Add("num_idtpdocumentoopexest_", OracleDbType.Int32, ParameterDirection.Input, input.NUM_IDTPDOCUMENTOOPEXEST);
dyParam.Add("str_numdocumentoopexest_", OracleDbType.Varchar2, ParameterDirection.Input, input.STR_NUMDOCUMENTOOPEXEST);
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_FORMULARIOGTU.SP_RegistroFormularioGTU");
var result = await connection.QueryFirstOrDefaultAsync <TM_FORMULARIO_OGTU>(query, param : dyParam, commandType : CommandType.StoredProcedure);
return(result);
}
}
public async Task <TM_FORMULARIO_OGTU> Update(TM_FORMULARIO_OGTU input)
{
try
{
return(await this._formularioOGTURepository.Update(input));
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <TM_FORMULARIO_OGTU> Get(TM_FORMULARIO_OGTU input)
{
using (var connection = _connectionFactory.GetConnectionSIROS())
{
var dyParam = new OracleDynamicParameters();
dyParam.Add("num_idformulariotu_", OracleDbType.Varchar2, ParameterDirection.Input, input.NUM_IDFORMULARIOTU);
dyParam.Add("num_identidadusuario_", OracleDbType.Varchar2, ParameterDirection.Input, input.NUM_IDENTIDADUSUARIO);
dyParam.Add("p_cursor_", OracleDbType.RefCursor, ParameterDirection.Output);
var query = _connectionFactory.GetQueryForSIROS("PKG_FORMULARIOGTU.SP_GetListaFormularioGTUxId");
var result = await connection.QueryFirstOrDefaultAsync <TM_FORMULARIO_OGTU>(query, param : dyParam, commandType : CommandType.StoredProcedure);
return(result);
}
}
public async Task <TM_FORMULARIO_OGTU> Delete(TM_FORMULARIO_OGTU input)
{
using (var connection = _connectionFactory.GetConnectionSIROS())
{
var dyParam = new OracleDynamicParameters();
dyParam.Add("num_idformulariotu_", OracleDbType.Varchar2, ParameterDirection.Input, input.NUM_IDFORMULARIOTU);
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_FORMULARIOGTU.SP_EliminarFormularioGTU");
var result = await connection.QueryFirstOrDefaultAsync <TM_FORMULARIO_OGTU>(query, param : dyParam, commandType : CommandType.StoredProcedure);
return(result);
}
}
public async Task <List <TM_FORMULARIO_OGTU> > GetCombo(TM_FORMULARIO_OGTU input)
{
throw new NotImplementedException();
}
