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(); }