public async Task <TM_RUTA> Update(TM_RUTA input) { try { return(await this._rutaRepository.Update(input)); } catch (Exception ex) { throw ex; } }
public async Task <List <TM_RUTA> > GetCombo(TM_RUTA input) { try { return(await this._rutaRepository.GetCombo(input)); } catch (Exception ex) { throw ex; } }
public async Task <List <TM_RUTA> > GetCombo(TM_RUTA input) { using (var connection = _connectionFactory.GetConnectionSIROS()) { var dyParam = new OracleDynamicParameters(); dyParam.Add("num_identidadusuario_", OracleDbType.Int32, ParameterDirection.Input, input.NUM_IDENTIDADUSUARIO); dyParam.Add("p_cursor_", OracleDbType.RefCursor, ParameterDirection.Output); var query = _connectionFactory.GetQueryForSIROS("PKG_RUTA.SP_GetListaComboRutaxEmp"); var result = await connection.QueryAsync <TM_RUTA>(query, param : dyParam, commandType : CommandType.StoredProcedure); return(result.AsList()); } }
public async Task <TM_RUTA> Delete(TM_RUTA input) { using (var connection = _connectionFactory.GetConnectionSIROS()) { var dyParam = new OracleDynamicParameters(); dyParam.Add("num_idruta_", OracleDbType.Int32, ParameterDirection.Input, input.NUM_IDRUTA); dyParam.Add("num_identidadusuario_", OracleDbType.Int32, ParameterDirection.Input, input.NUM_IDENTIDADUSUARIO); 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_RUTA.SP_EliminarRuta"); var result = await connection.QueryFirstOrDefaultAsync <TM_RUTA>(query, param : dyParam, commandType : CommandType.StoredProcedure); return(result); } }
public async Task <TM_RUTA> Update(TM_RUTA input) { using (var connection = _connectionFactory.GetConnectionSIROS()) { var dyParam = new OracleDynamicParameters(); dyParam.Add("num_idruta_", OracleDbType.Int32, ParameterDirection.Input, input.NUM_IDRUTA); dyParam.Add("str_itinerario_", OracleDbType.Varchar2, ParameterDirection.Input, input.STR_ITINERARIO); dyParam.Add("str_kilometro_", OracleDbType.Varchar2, ParameterDirection.Input, input.STR_KILOMETRO); dyParam.Add("str_estado_", OracleDbType.Varchar2, ParameterDirection.Input, input.STR_ESTADO); 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_RUTA.SP_ActualizarRuta"); var result = await connection.QueryFirstOrDefaultAsync <TM_RUTA>(query, param : dyParam, commandType : CommandType.StoredProcedure); return(result); } }