public async Task <TM_CONTRATOES> Update(TM_CONTRATOES input) { try { return(await _contratoEsRepository.Update(input)); } catch (Exception ex) { throw ex; } }
public async Task <List <TM_CONTRATOES> > GetCombo(TM_CONTRATOES input) { try { return(await this._contratoEsRepository.GetCombo(input)); } catch (Exception ex) { throw ex; } }
public async Task <TM_CONTRATOES> Get(TM_CONTRATOES input) { using (var connection = _connectionFactory.GetConnectionSIROS()) { var dyParam = new OracleDynamicParameters(); dyParam.Add("num_idestservicioxent_", OracleDbType.Varchar2, ParameterDirection.Input, input.NUM_IDESTSERVICIOXENT); dyParam.Add("p_cursor_", OracleDbType.RefCursor, ParameterDirection.Output); var query = _connectionFactory.GetQueryForSIROS("PKG_CONTRATOES.SP_GetListaContratoESxId"); var result = await connection.QueryFirstOrDefaultAsync <TM_CONTRATOES>(query, param : dyParam, commandType : CommandType.StoredProcedure); return(result); } }
public async Task <TM_CONTRATOES> Update(TM_CONTRATOES input) { using (var connection = _connectionFactory.GetConnectionSIROS()) { var dyParam = new OracleDynamicParameters(); dyParam.Add("num_idestservicioxent_", OracleDbType.Int32, ParameterDirection.Input, input.NUM_IDESTSERVICIOXENT); dyParam.Add("str_numcontrato_", OracleDbType.Varchar2, ParameterDirection.Input, input.STR_NUMCONTRATO); dyParam.Add("dte_feccontrato_", OracleDbType.Varchar2, ParameterDirection.Input, input.DTE_FECCONTRATO.ToBDSirosDate()); dyParam.Add("dte_fecinivig_", OracleDbType.Varchar2, ParameterDirection.Input, input.DTE_FECINIVIG.ToBDSirosDate()); dyParam.Add("dte_fecvenvig_", OracleDbType.Varchar2, ParameterDirection.Input, input.DTE_FECVENVIG.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_CONTRATOES.SP_ActualizarContratoES"); var result = await connection.QueryFirstOrDefaultAsync <TM_CONTRATOES>(query, param : dyParam, commandType : CommandType.StoredProcedure); return(result); } }
public async Task <List <TM_CONTRATOES> > GetCombo(TM_CONTRATOES input) { throw new NotImplementedException(); }