public MainLotListing Filter(LotFilter filter) { var model = new MainLotListing(); var parameters = new OracleDynamicParameters(); parameters.Add("o_result", null, OracleMappingType.RefCursor, ParameterDirection.Output); parameters.Add("o_Ending_Today_Lots_Count", null, OracleMappingType.Decimal, ParameterDirection.Output); parameters.Add("o_Active_Lots_Count", null, OracleMappingType.Decimal, ParameterDirection.Output); parameters.Add("o_My_Offers_Count", null, OracleMappingType.Decimal, ParameterDirection.Output); parameters.Add("o_Price_Range_Min", null, OracleMappingType.Decimal, ParameterDirection.Output); parameters.Add("o_Price_Range_Max", null, OracleMappingType.Decimal, ParameterDirection.Output); parameters.Add("p_Card_Size", filter.to - filter.from); parameters.Add("p_Region_Id", filter.regionId); parameters.Add("p_Company_Id", filter.companyId); parameters.Add("p_is_allowed_juridical", filter.isAllowedJuridic.HasValue && filter.isAllowedJuridic.Value ? 1 : 0); parameters.Add("p_is_allowed_individual", filter.isAllowedIndividual.HasValue && filter.isAllowedIndividual.Value ? 1 : 0); parameters.Add("p_price_from", filter.startPrice); parameters.Add("p_price_to", filter.endPrice); parameters.Add("p_Full_Numbers", filter.fullNumbers, OracleMappingType.Varchar2, size: 512); parameters.Add("p_is_today", filter.isToday.HasValue && filter.isToday.Value ? (int?)1 : null); parameters.Add("p_User_Id", null); using (var con = _connection) { model.Items = con.Query <MainLotItem>("Front.Get_Filtered_Lots", parameters, commandType: CommandType.StoredProcedure); model.EndingTodayLotsCount = (int?)parameters.Get <decimal?>("o_Ending_Today_Lots_Count"); model.ActiveLotsCount = (int?)parameters.Get <decimal?>("o_Active_Lots_Count"); model.MyOffersCount = (int?)parameters.Get <decimal?>("o_My_Offers_Count"); model.PriceRangeMin = (int?)parameters.Get <decimal?>("o_Price_Range_Min"); model.PriceRangeMax = (int?)parameters.Get <decimal?>("o_Price_Range_Max"); } return(model); }
/// <summary> /// LookupApplication calls a stored procedure to /// determine what id the hdb-poet application is using for the /// specific HDB you are logged into. /// /// Some other id's are also returned from the stored procedure: /// /// the values returned are: /// /// static_AGEN_ID /// static_COLLECTION_SYSTEM_ID /// static_LOADING_APPLICATION_ID /// static_METHOD_ID /// static_COMPUTATION_ID /// </summary> public void LookupApplication(IDbConnection db) { string agen_id_name = "Bureau of Reclamation"; string coll_sys_name = "(see agency)"; string load_app_name = "HDB API"; string meth_name = "unknown"; string comp_name = "unknown"; var p = new OracleDynamicParameters(); p.Add("AGEN_NAME", value: agen_id_name, dbType: OracleDbType.Varchar2); p.Add("COLLECTION_SYSTEM_NAME", value: coll_sys_name, dbType: OracleDbType.Varchar2); p.Add("LOADING_APPLICATION_NAME", value: load_app_name, dbType: OracleDbType.Varchar2); p.Add("METHOD_NAME", value: meth_name, dbType: OracleDbType.Varchar2); p.Add("COMPUTATION_NAME", value: comp_name, dbType: OracleDbType.Varchar2); p.Add("AGEN_ID", dbType: OracleDbType.Decimal, direction: ParameterDirection.Output); p.Add("COLLECTION_SYSTEM_ID", dbType: OracleDbType.Decimal, direction: ParameterDirection.Output); p.Add("LOADING_APPLICATION_ID", dbType: OracleDbType.Decimal, direction: ParameterDirection.Output); p.Add("METHOD_ID", dbType: OracleDbType.Decimal, direction: ParameterDirection.Output); p.Add("COMPUTATION_ID", dbType: OracleDbType.Decimal, direction: ParameterDirection.Output); var result = db.Query <dynamic>("LOOKUP_APPLICATION", param: p, commandType: CommandType.StoredProcedure); s_AGEN_ID = ToDecimal(p.Get <dynamic>("AGEN_ID")); s_COLLECTION_SYSTEM_ID = ToDecimal(p.Get <dynamic>("COLLECTION_SYSTEM_ID")); s_LOADING_APPLICATION_ID = ToDecimal(p.Get <dynamic>("LOADING_APPLICATION_ID")); s_METHOD_ID = ToDecimal(p.Get <dynamic>("METHOD_ID")); s_COMPUTATION_ID = ToDecimal(p.Get <dynamic>("COMPUTATION_ID")); }
public async Task <ResponsePostDetail> InsInformacionGeneral(InformacionGeneralQueryFilter informacionGeneralQueryFilter) { try { var affectedRows = 0; var dyParam = new OracleDynamicParameters(); dyParam.Add("id_pre_inscripcion", OracleDbType.Int32, ParameterDirection.Input, informacionGeneralQueryFilter.IdPreInscripcion); dyParam.Add("id_carrera", OracleDbType.Int32, ParameterDirection.Input, informacionGeneralQueryFilter.IdCarrera); dyParam.Add("id_periodo_academico", OracleDbType.Int32, ParameterDirection.Input, informacionGeneralQueryFilter.IdPeriodoAcademico); dyParam.Add("fecha_inscripcion", OracleDbType.Date, ParameterDirection.Input, informacionGeneralQueryFilter.FechaInscripcion); dyParam.Add("observacion", OracleDbType.Varchar2, ParameterDirection.Input, informacionGeneralQueryFilter.Observacion); dyParam.Add("estado_transaccion", OracleDbType.Varchar2, ParameterDirection.Input, informacionGeneralQueryFilter.EstadoTransaccion); dyParam.Add("affected_rows", OracleDbType.Int32, ParameterDirection.Output, 0); var query = "ACADEMICO.PREINSCRIPCION.SP_INSERTAR_INSCRIPCION"; await _coneccion.InsData(dyParam, query); affectedRows = dyParam.Get("affected_rows"); return(new ResponsePostDetail() { Process = "Pre Inscripcion", AffectedRows = affectedRows }); } catch (Exception err) { throw new Exception(err.Message); } }
public async Task <ResponsePostDetail> InsDatosColegio(PreColegioQueryFilter preColegioQueryFilter) { try { var affectedRows = 0; var dyParam = new OracleDynamicParameters(); dyParam.Add("id_pre_inscripcion", OracleDbType.Int32, ParameterDirection.Input, preColegioQueryFilter.IdPreInscripcion); dyParam.Add("id_colegio", OracleDbType.Int32, ParameterDirection.Input, preColegioQueryFilter.IdColegio); dyParam.Add("id_departamento", OracleDbType.Int32, ParameterDirection.Input, preColegioQueryFilter.IdDepartamento); dyParam.Add("id_provincia", OracleDbType.Int32, ParameterDirection.Input, preColegioQueryFilter.IdProvincia); dyParam.Add("turno", OracleDbType.Int32, ParameterDirection.Input, preColegioQueryFilter.ValorTurno); dyParam.Add("tipo_colegio", OracleDbType.Int32, ParameterDirection.Input, preColegioQueryFilter.ValorTipoColegio); dyParam.Add("anio_egreso", OracleDbType.Int32, ParameterDirection.Input, preColegioQueryFilter.AnioEgreso); dyParam.Add("affected_rows", OracleDbType.Int32, ParameterDirection.Output, 0); var query = "ACADEMICO.PREINSCRIPCION.SP_INSERTAR_COLEGIO"; await _coneccion.InsData(dyParam, query); affectedRows = dyParam.Get("affected_rows"); return(new ResponsePostDetail() { Process = "Pre Inscripcion", AffectedRows = affectedRows }); } catch (Exception err) { throw new Exception(err.Message); } }
public async Task <ResponsePostDetail> InsDatosPadre(PreDatosPadresQueryFilter preDatosPadresQueryFilter) { try { var affectedRows = 0; var dyParam = new OracleDynamicParameters(); dyParam.Add("id_pre_inscripcion", OracleDbType.Int32, ParameterDirection.Input, preDatosPadresQueryFilter.IdPreInscripcion); dyParam.Add("ap_paterno", OracleDbType.Varchar2, ParameterDirection.Input, preDatosPadresQueryFilter.PrimerApellido); dyParam.Add("ap_materno", OracleDbType.Varchar2, ParameterDirection.Input, preDatosPadresQueryFilter.SegundoApellido); dyParam.Add("nombre", OracleDbType.Varchar2, ParameterDirection.Input, preDatosPadresQueryFilter.Nombres); dyParam.Add("direccion", OracleDbType.Varchar2, ParameterDirection.Input, preDatosPadresQueryFilter.Direccion); dyParam.Add("id_departamento", OracleDbType.Int32, ParameterDirection.Input, preDatosPadresQueryFilter.IdDepartamento); dyParam.Add("telefono", OracleDbType.Varchar2, ParameterDirection.Input, preDatosPadresQueryFilter.Telefonos); dyParam.Add("id_profesion", OracleDbType.Int32, ParameterDirection.Input, preDatosPadresQueryFilter.IdProfesion); dyParam.Add("lugar_trabaja", OracleDbType.Varchar2, ParameterDirection.Input, preDatosPadresQueryFilter.LugarDeTrabajo); dyParam.Add("tipo", OracleDbType.Int32, ParameterDirection.Input, preDatosPadresQueryFilter.Tipo); dyParam.Add("affected_rows", OracleDbType.Int32, ParameterDirection.Output, 0); var query = "ACADEMICO.PREINSCRIPCION.SP_INSERTAR_DATOS_PADRES"; await _coneccion.InsData(dyParam, query); affectedRows = dyParam.Get("affected_rows"); return(new ResponsePostDetail() { Process = "Pre Inscripcion", AffectedRows = affectedRows }); } catch (Exception err) { throw new Exception(err.Message); } }
public async Task <ResponsePostDetail> InsViveCon(PreViveConQueryFilter preViveConQueryFilter) { try { var affectedRows = 0; var dyParam = new OracleDynamicParameters(); dyParam.Add("id_pre_inscripcion", OracleDbType.Int32, ParameterDirection.Input, preViveConQueryFilter.IdPreInscripcion); dyParam.Add("vive_con", OracleDbType.Int32, ParameterDirection.Input, preViveConQueryFilter.ValorViveCon); dyParam.Add("nombre_tutor", OracleDbType.Varchar2, ParameterDirection.Input, preViveConQueryFilter.NombreTutor); dyParam.Add("telefono", OracleDbType.Varchar2, ParameterDirection.Input, preViveConQueryFilter.Telefonos); dyParam.Add("celular", OracleDbType.Varchar2, ParameterDirection.Input, preViveConQueryFilter.Celulares); dyParam.Add("problema_salud", OracleDbType.Int32, ParameterDirection.Input, (int)(preViveConQueryFilter.TieneProblemasSalud ? TipoBooleano.si : TipoBooleano.no)); dyParam.Add("problema_salud_detalle", OracleDbType.Varchar2, ParameterDirection.Input, preViveConQueryFilter.ProblemaSaludDetalle); dyParam.Add("affected_rows", OracleDbType.Int32, ParameterDirection.Output, 0); var query = "ACADEMICO.PREINSCRIPCION.SP_INSERTAR_VIVE_CON"; await _coneccion.InsData(dyParam, query); affectedRows = dyParam.Get("affected_rows"); return(new ResponsePostDetail() { Process = "Pre Inscripcion", AffectedRows = affectedRows }); } catch (Exception err) { throw new Exception(err.Message); } }
protected Guid UpdateAndReturnKey(string sql, string pkName, OracleDynamicParameters oracleParameters, IDbConnection connection) { try { var affectedRows = connection.Execute(sql, param: oracleParameters, commandType: CommandType.StoredProcedure); if (affectedRows == -1) { s_log.Trace($"Update success [UpdateTag]"); var returnValueByteArray = oracleParameters.Get <byte[]>(pkName); var primaryKeyguidId = GuidConvert.FromRaw(returnValueByteArray); return(primaryKeyguidId); } throw new DBOperationException("Update Tag was not successful!"); } catch (Oracle.ManagedDataAccess.Client.OracleException ex) { s_log.ErrorException("Update Fails (Oracle Exception)", ex, "BaseStore"); throw new DBOperationException(ex.Message, ex.Number, GlobalOptions.DBExceptionScenarios.OracleExceptionOccured, ex); } catch (Exception ex) { s_log.ErrorException("Update Fails", ex, "BaseStore"); throw new DBOperationException(ex.Message, GlobalOptions.DBExceptionScenarios.ExceptionOccured, ex); } }
public async Task <ResponsePostDetail> InsPreDiscapacidadDetalle(PreDiscapacidadDetalleQueryFilter preDiscapacidadDetalleQueryFilter) { try { var affectedRows = 0; var dyParam = new OracleDynamicParameters(); dyParam.Add("id_pre_inscripcion", OracleDbType.Int32, ParameterDirection.Input, preDiscapacidadDetalleQueryFilter.IdPreInscripcion); dyParam.Add("valor", OracleDbType.Int32, ParameterDirection.Input, preDiscapacidadDetalleQueryFilter.ValorDiscapacidad); dyParam.Add("dominio", OracleDbType.Varchar2, ParameterDirection.Input, preDiscapacidadDetalleQueryFilter.Dominio); dyParam.Add("descripcion", OracleDbType.Varchar2, ParameterDirection.Input, preDiscapacidadDetalleQueryFilter.Descripcion); dyParam.Add("affected_rows", OracleDbType.Int32, ParameterDirection.Output, 0); var query = "ACADEMICO.PREINSCRIPCION.SP_INSERTAR_DISCAPACIDAD_DET"; await _coneccion.InsData(dyParam, query); affectedRows = dyParam.Get("affected_rows"); return(new ResponsePostDetail() { Process = "Pre Inscripcion", AffectedRows = affectedRows }); } catch (Exception err) { throw new Exception(err.Message); } }
public sys_role Add(sys_role entity) { try { StringBuilder sql = new StringBuilder(); sql.Append("insert into sys_role (id,status,title,code,adduser,addtime,addusername) values (SEQ_ROLEID.nextval,:status,:title,:code,:adduser,sysdate,(select name from sys_user where id = :adduser)) returning id into :id "); OracleDynamicParameters p = new OracleDynamicParameters(); p.Add(":status", entity.status, OracleMappingType.Int32, ParameterDirection.Input); p.Add(":title", entity.title, OracleMappingType.NVarchar2, ParameterDirection.Input); p.Add(":code", MaxCode(), OracleMappingType.NVarchar2, ParameterDirection.Input); p.Add(":adduser", entity.adduser, OracleMappingType.Int32, ParameterDirection.Input); p.Add(":addusername", entity.addusername, OracleMappingType.NVarchar2, ParameterDirection.Input); p.Add(":id", null, OracleMappingType.Int32, ParameterDirection.ReturnValue); using (var db = new OraDBHelper()) { int cnt = db.Conn.Execute(sql.ToString(), p); entity.id = p.Get <int>(":id"); return(entity); } } catch (Exception e) { log.Error(e.Message); throw; } }
public async Task <ResponsePostDetail> InsPreDiscapacidad(PreDiscapacidadesQueryFilter preDiscapacidadesQueryFilter) { try { var affectedRows = 0; var dyParam = new OracleDynamicParameters(); dyParam.Add("id_pre_inscripcion", OracleDbType.Int32, ParameterDirection.Input, preDiscapacidadesQueryFilter.IdPreInscripcion); dyParam.Add("apoyo_ensenianza", OracleDbType.Int32, ParameterDirection.Input, (int)(preDiscapacidadesQueryFilter.RequiereApoyoEnsenianza ? TipoBooleano.si : TipoBooleano.no)); dyParam.Add("trastorno_aprendizaje", OracleDbType.Varchar2, ParameterDirection.Input, (int)(preDiscapacidadesQueryFilter.PresentaTrastornoAprendizaje ? TipoBooleano.si : TipoBooleano.no)); dyParam.Add("discapacidad", OracleDbType.Varchar2, ParameterDirection.Input, (int)(preDiscapacidadesQueryFilter.PresentaDiscapacidad ? TipoBooleano.si : TipoBooleano.no)); dyParam.Add("trastorno", OracleDbType.Varchar2, ParameterDirection.Input, (int)(preDiscapacidadesQueryFilter.TieneTrastorno ? TipoBooleano.si : TipoBooleano.no)); dyParam.Add("affected_rows", OracleDbType.Int32, ParameterDirection.Output, 0); var query = "ACADEMICO.PREINSCRIPCION.SP_INSERTAR_DISCAPACIDAD"; await _coneccion.InsData(dyParam, query); affectedRows = dyParam.Get("affected_rows"); return(new ResponsePostDetail() { Process = "Pre Inscripcion", AffectedRows = affectedRows }); } catch (Exception err) { throw new Exception(err.Message); } }
public async Task <ResponsePostDetail> InsPreAutorizacion(PreAutorizacionesQueryFilter preAutorizacionesQueryFilter) { try { var affectedRows = 0; var dyParam = new OracleDynamicParameters(); dyParam.Add("id_pre_inscripcion", OracleDbType.Int32, ParameterDirection.Input, preAutorizacionesQueryFilter.IdPreInscripcion); dyParam.Add("nombre", OracleDbType.Varchar2, ParameterDirection.Input, preAutorizacionesQueryFilter.Nombre); dyParam.Add("email", OracleDbType.Varchar2, ParameterDirection.Input, preAutorizacionesQueryFilter.CorreoElectronico); dyParam.Add("affected_rows", OracleDbType.Int32, ParameterDirection.Output, 0); var query = "ACADEMICO.PREINSCRIPCION.SP_INSERTAR_AUTORIZACION"; await _coneccion.InsData(dyParam, query); affectedRows = dyParam.Get("affected_rows"); return(new ResponsePostDetail() { Process = "Pre Inscripcion", AffectedRows = affectedRows }); } catch (Exception err) { throw new Exception(err.Message); } }
public async Task <ResponsePostDetail> InsPreHermanos(PreHermanosQueryFilter preHermanosQueryFilter) { try { var affectedRows = 0; var dyParam = new OracleDynamicParameters(); dyParam.Add("id_pre_inscripcion", OracleDbType.Int32, ParameterDirection.Input, preHermanosQueryFilter.IdPreInscripcion); dyParam.Add("tiene_hermanos", OracleDbType.Int32, ParameterDirection.Input, preHermanosQueryFilter.TieneHermanos); dyParam.Add("nombre", OracleDbType.Varchar2, ParameterDirection.Input, preHermanosQueryFilter.Nombre); dyParam.Add("num_documento", OracleDbType.Varchar2, ParameterDirection.Input, preHermanosQueryFilter.NumeroDocumento); dyParam.Add("affected_rows", OracleDbType.Int32, ParameterDirection.Output, 0); var query = "ACADEMICO.PREINSCRIPCION.SP_INSERTAR_HERMANOS"; await _coneccion.InsData(dyParam, query); affectedRows = dyParam.Get("affected_rows"); return(new ResponsePostDetail() { Process = "Pre Inscripcion", AffectedRows = affectedRows }); } catch (Exception err) { throw new Exception(err.Message); } }
public bool GuardarUsuario(UsuarioBE entidad, OracleConnection db) { bool seGuardo = false; try { string sp = $"{Package.Admin}USP_PRC_GUARDAR_USUARIO"; var p = new OracleDynamicParameters(); p.Add("PI_ID_USUARIO", entidad.ID_USUARIO); p.Add("PI_CORREO", entidad.CORREO); p.Add("PI_NOMBRES", entidad.NOMBRES); p.Add("PI_APELLIDOS", entidad.APELLIDOS); p.Add("PI_CONTRASENA", entidad.CONTRASENA); p.Add("PI_ID_ROL", entidad.ID_ROL); p.Add("PI_FLAG_ESTADO", entidad.FLAG_ESTADO); p.Add("PI_UPD_USUARIO", entidad.UPD_USUARIO); p.Add("PO_ROWAFFECTED", dbType: OracleDbType.Int32, direction: ParameterDirection.Output); db.Execute(sp, p, commandType: CommandType.StoredProcedure); int filasAfectadas = (int)p.Get <dynamic>("PO_ROWAFFECTED").Value; seGuardo = filasAfectadas > 0; } catch (Exception ex) { Log.Error(ex); } return(seGuardo); }
public sys_user Add(sys_user entity) { try { string token = new JWTHelper().CreateToken(); entity.token = token; StringBuilder sql = new StringBuilder(); sql.Append("insert into sys_user(id, status, code, name, pwd, token, adduser,addtime) \r\n"); sql.Append("values \r\n"); sql.Append("(seq_userid.nextval,:status,:code,:name,:pwd,:token,:adduser,sysdate) returning id into :id \r\n"); OracleDynamicParameters p = new OracleDynamicParameters(); p.Add(":status", entity.status, OracleMappingType.Int32, ParameterDirection.Input); p.Add(":code", entity.code, OracleMappingType.NVarchar2, ParameterDirection.Input); p.Add(":name", entity.name, OracleMappingType.NVarchar2, ParameterDirection.Input); p.Add(":pwd", entity.pwd, OracleMappingType.NVarchar2, ParameterDirection.Input); p.Add(":token", token, OracleMappingType.NVarchar2, ParameterDirection.Input); p.Add(":adduser", entity.adduser, OracleMappingType.Int32, ParameterDirection.Input); p.Add(":id", null, OracleMappingType.Int32, ParameterDirection.ReturnValue); using (var db = new OraDBHelper()) { int cnt = db.Conn.Execute(sql.ToString(), p); int userid = p.Get <int>(":id"); entity.id = userid; return(entity); } } catch (Exception e) { log.Error(e.Message); throw; } }
/// <summary> /// カーソルを取得する。 /// </summary> /// <typeparam name="T">カーソルをマッピングするクラスの型</typeparam> /// <param name="parameters">OracleDynamicParameters</param> /// <param name="name">パラメータ名</param> /// <returns>Value</returns> public static List <T> GetRefCursorValue <T>(this OracleDynamicParameters parameters, string name) { var value = parameters.Get <OracleRefCursor>(name); if (value.IsNull) { return(new List <T>()); } var reader = value.GetDataReader(); var columnNames = Enumerable.Range(0, reader.FieldCount).Select(i => reader.GetName(i)).ToList(); var result = new List <T>(); while (reader.Read()) { var t = Activator.CreateInstance <T>(); foreach (var p in typeof(T).GetProperties()) { if (columnNames.Any(c => c == p.Name)) { p.SetValue(t, reader[p.Name]); } } result.Add(t); } return(result); }
public sys_menu Add(sys_menu menu) { try { StringBuilder sql = new StringBuilder(); sql.Append("insert into sys_menu(id,"); sql.Append("title,"); sql.Append("pid,"); sql.Append("icon,"); sql.Append("code,"); sql.Append("path,"); sql.Append("menutype,"); sql.Append("viewpath,"); sql.Append("addtime,"); sql.Append("adduser,"); sql.Append("addusername,comname,"); sql.Append("seq"); sql.Append(")"); sql.Append("values"); sql.Append("(SEQ_MENUID.NEXTVAL,"); sql.Append(":title,"); sql.Append(":pid,"); sql.Append(":icon,"); sql.Append(":code,"); sql.Append(":path,"); sql.Append(":menutype,"); sql.Append(":viewpath,"); sql.Append("sysdate,"); sql.Append(":adduser,"); sql.Append("(select name from sys_user where id = :adduser),:comname,"); sql.Append(":seq"); sql.Append(") returning id into :id"); using (var db = new OraDBHelper()) { OracleDynamicParameters param = new OracleDynamicParameters(); param.Add(":title", menu.title, OracleMappingType.NVarchar2, ParameterDirection.Input); param.Add(":pid", menu.pid, OracleMappingType.Int32, ParameterDirection.Input); param.Add(":icon", menu.icon, OracleMappingType.NVarchar2, ParameterDirection.Input); param.Add(":code", menu.code, OracleMappingType.NVarchar2, ParameterDirection.Input); param.Add(":path", menu.path, OracleMappingType.NVarchar2, ParameterDirection.Input); param.Add(":menutype", menu.menutype, OracleMappingType.NVarchar2, ParameterDirection.Input); param.Add(":viewpath", menu.viewpath, OracleMappingType.NVarchar2, ParameterDirection.Input); param.Add(":adduser", menu.adduser, OracleMappingType.Int32, ParameterDirection.Input); param.Add(":comname", menu.comname, OracleMappingType.NVarchar2, ParameterDirection.Input); param.Add(":seq", menu.seq, OracleMappingType.Int32, ParameterDirection.Input); param.Add(":id", null, OracleMappingType.Int32, ParameterDirection.Output); var ret = db.Conn.Execute(sql.ToString(), param); var menuid = param.Get <int>(":id"); menu.id = menuid; return(menu); } } catch (Exception e) { log.Error(e.Message); throw; } }
/// <summary> /// 文字列値を取得する。 /// </summary> /// <param name="parameters">OracleDynamicParameters</param> /// <param name="name">パラメータ名</param> /// <returns>Value</returns> public static string GetStringValue(this OracleDynamicParameters parameters, string name) { var value = parameters.Get <OracleString>(name); if (value.IsNull) { return(""); } return(value.ToString()); }
public async Task <string> TestProcedureAsync() { var parameters = new OracleDynamicParameters(); parameters.Add("genericParam", "aaaa", OracleMappingType.Varchar2, ParameterDirection.InputOutput); await this.DbConnection.ExecuteAsync("procOneINOUTParameter", parameters, commandType : CommandType.StoredProcedure); var a = parameters.Get <string>("genericParam"); return(a); }
public async static Task <IDTO> AddUpdate(Pricing pricing) { string SPName = ""; string message = ""; OracleDynamicParameters oracleParams = new OracleDynamicParameters(); ComplateOperation <int> complate = new ComplateOperation <int>(); if (pricing.ID.HasValue) { oracleParams.Add(PricingSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)pricing.ID ?? DBNull.Value); SPName = PricingSpName.SP_UPADTE_PRICING; message = "Updated Successfully"; } else { oracleParams.Add(PricingSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output); SPName = PricingSpName.SP_INSERT_PRICING; message = "Inserted Successfully"; } oracleParams.Add(PricingSpParams.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)pricing.Name ?? DBNull.Value); oracleParams.Add(PricingSpParams.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)pricing.Name2 ?? DBNull.Value); oracleParams.Add(PricingSpParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)pricing.CreatedBy ?? DBNull.Value); oracleParams.Add(PricingSpParams.PARAMETER_CREATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricing.CreationDate ?? DBNull.Value); oracleParams.Add(PricingSpParams.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)pricing.ModifiedBy ?? DBNull.Value); oracleParams.Add(PricingSpParams.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricing.ModificationDate ?? DBNull.Value); oracleParams.Add(PricingSpParams.PARAMETER_STATUS, OracleDbType.Int64, ParameterDirection.Input, (object)pricing.Status ?? DBNull.Value); oracleParams.Add(PricingSpParams.PARAMETER_STATUS_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricing.StatusDate ?? DBNull.Value, 1000); oracleParams.Add(PricingSpParams.PARAMETER_ST_PRD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)pricing.ProductID ?? DBNull.Value); oracleParams.Add(PricingSpParams.PARAMETER_EFFECTIVE_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricing.EffectiveDate ?? DBNull.Value, 1000); oracleParams.Add(PricingSpParams.PARAMETER_EXPIRY_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricing.ExpiryDate ?? DBNull.Value); oracleParams.Add(PricingSpParams.PARAMETER_LOC_PRICE_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)pricing.PricingType ?? DBNull.Value); oracleParams.Add(PricingSpParams.PARAMETER_FIN_CST_ID, OracleDbType.Int64, ParameterDirection.Input, (object)pricing.CustomerID ?? DBNull.Value); if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1) { complate.ID = oracleParams.Get(0); complate.message = message; } else { complate.message = message; } return(complate); }
public bool GuardarResultado(BusquedaBE obj, out int idresultado, OracleConnection db) { bool seGuardo = false; idresultado = -1; try { string sp = $"{Package.Filtro}USP_INS_GUARDAR_RESULTADO"; var p = new OracleDynamicParameters(); p.Add("PI_ID_TIPO_BUSQUEDA", obj.ID_TIPO_BUSQUEDA); p.Add("PI_ID_USUARIO", obj.UPD_USUARIO); p.Add("PI_ID_GET", 0, OracleDbType.Int32, ParameterDirection.Output); p.Add("PO_ROWAFFECTED", dbType: OracleDbType.Int32, direction: ParameterDirection.Output); db.Execute(sp, p, commandType: CommandType.StoredProcedure); idresultado = (int)p.Get <dynamic>("PI_ID_GET").Value; int filasAfectadas = (int)p.Get <dynamic>("PO_ROWAFFECTED").Value; seGuardo = filasAfectadas > 0 && idresultado > 0; } catch (Exception ex) { Log.Error(ex); } return(seGuardo); }
public async static Task <IDTO> AddUpdateMode(Share share) { string SPName = ""; string message = ""; OracleDynamicParameters oracleParams = new OracleDynamicParameters(); ComplateOperation <int> complate = new ComplateOperation <int>(); if (share.ID.HasValue) { oracleParams.Add(SharesSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)share.ID ?? DBNull.Value); SPName = SharesSpName.SP_UPADTE_SHARE; message = "Updated Successfully"; } else { oracleParams.Add(SharesSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output); SPName = SharesSpName.SP_INSERT_SHARE; message = "Inserted Successfully"; } oracleParams.Add(SharesSpParams.PARAMETER_LOC_SHARE_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)share.LocShareType ?? DBNull.Value); oracleParams.Add(SharesSpParams.PARAMETER_PRCNT, OracleDbType.Decimal, ParameterDirection.Input, (object)share.Percent ?? DBNull.Value); oracleParams.Add(SharesSpParams.PARAMETER_SHARE_PER, OracleDbType.Decimal, ParameterDirection.Input, (object)share.SharePercent ?? DBNull.Value); oracleParams.Add(SharesSpParams.PARAMETER_AMOUNT, OracleDbType.Decimal, ParameterDirection.Input, (object)share.Amount ?? DBNull.Value); oracleParams.Add(SharesSpParams.PARAMETER_AMOUNT_LC, OracleDbType.Decimal, ParameterDirection.Input, (object)share.AmountLC ?? DBNull.Value); oracleParams.Add(SharesSpParams.PARAMETER_NOTES, OracleDbType.Varchar2, ParameterDirection.Input, (object)share.Notes ?? DBNull.Value); oracleParams.Add(SharesSpParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)share.CreatedBy ?? DBNull.Value); oracleParams.Add(SharesSpParams.PARAMETER_CREATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)share.CreationDate ?? DBNull.Value); oracleParams.Add(SharesSpParams.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)share.ModifiedBy ?? DBNull.Value); oracleParams.Add(SharesSpParams.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)share.ModificationDate ?? DBNull.Value); oracleParams.Add(SharesSpParams.PARAMETER_UW_DOC_ID, OracleDbType.Int64, ParameterDirection.Input, (object)share.DocumentID ?? DBNull.Value); oracleParams.Add(SharesSpParams.PARAMETER_FIN_CST_ID, OracleDbType.Int64, ParameterDirection.Input, (object)share.CustomerId ?? DBNull.Value); oracleParams.Add(SharesSpParams.PARAMETER_ST_LOB, OracleDbType.Int64, ParameterDirection.Input, (object)share.StLOB ?? DBNull.Value); oracleParams.Add(SharesSpParams.PARAMETER_ST_SUB_LOB, OracleDbType.Int64, ParameterDirection.Input, (object)share.StSubLOB ?? DBNull.Value); oracleParams.Add(SharesSpParams.PARAMETER_DR_CR, OracleDbType.Int64, ParameterDirection.Input, (object)share.DrCr ?? DBNull.Value); if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1) { complate.message = message; complate.ID = oracleParams.Get(0); } else { complate.message = "Operation Failed"; } return(complate); }
public ResponseMessage QueryExecute(OracleConnection connection, string procedure, OracleDynamicParameters dyParam) { var result = connection.Execute(procedure, dyParam, commandType: CommandType.StoredProcedure); var properties = typeof(ResponseMessage).GetProperties(); var responseMessage = new ResponseMessage(); foreach (var v in properties) { if (dyParam.ParameterNames.Contains(v.Name) && dyParam.GetParameter(v.Name).ParameterDirection != ParameterDirection.Input) { SetObjectProperty(responseMessage, v.Name, dyParam.Get <string>("@" + v.Name)); } } return(responseMessage); }
public async static Task <IDTO> AddUpdate(Product Product) { var SPName = default(string); var message = default(string); OracleDynamicParameters oracleParams = new OracleDynamicParameters(); ComplateOperation <int> complate = new ComplateOperation <int>(); if (Product.ID.HasValue) { oracleParams.Add(ProductSPParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)Product.ID ?? DBNull.Value); SPName = ProductSPName.SP_UPADTE_PRODUCT; message = "Updated Successfully"; } else { oracleParams.Add(ProductSPParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output); SPName = ProductSPName.SP_INSERT_PRODUCT; message = "Inserted Successfully"; } oracleParams.Add(ProductSPParams.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)Product.Name ?? DBNull.Value, 1000); oracleParams.Add(ProductSPParams.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)Product.Name2 ?? DBNull.Value, 1000); oracleParams.Add(ProductSPParams.PARAMETER_STATUS, OracleDbType.Int64, ParameterDirection.Input, (object)Product.Status ?? DBNull.Value); oracleParams.Add(ProductSPParams.PARAMETER_STATUS_DATE, OracleDbType.Date, ParameterDirection.Input, (object)Product.StatusDate ?? DBNull.Value); oracleParams.Add(ProductSPParams.PARAMETER_LOGO, OracleDbType.Varchar2, ParameterDirection.Input, (object)Product.Logo ?? DBNull.Value, 1000); oracleParams.Add(ProductSPParams.PARAMETER_CODE, OracleDbType.Varchar2, ParameterDirection.Input, (object)Product.Code ?? DBNull.Value, 30); oracleParams.Add(ProductSPParams.PARAMETER_EFFECTIVE_DATE, OracleDbType.Date, ParameterDirection.Input, (object)Product.EffectiveDate ?? DBNull.Value); oracleParams.Add(ProductSPParams.PARAMETER_EXPIRY_DATE, OracleDbType.Date, ParameterDirection.Input, (object)Product.ExpiryDate ?? DBNull.Value); oracleParams.Add(ProductSPParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)Product.CreateBy ?? DBNull.Value, 50); oracleParams.Add(ProductSPParams.PARAMETER_CREATATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)Product.CreationDate ?? DBNull.Value); oracleParams.Add(ProductSPParams.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)Product.ModifiedBy ?? DBNull.Value, 50); oracleParams.Add(ProductSPParams.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)Product.ModificationDate ?? DBNull.Value); oracleParams.Add(ProductSPParams.PARAMETER_LOCK_INDV_GROUPE, OracleDbType.Int16, ParameterDirection.Input, (object)Product.LockIndvGroup ?? DBNull.Value); oracleParams.Add(ProductSPParams.PARAMETER_COMPANY_ID, OracleDbType.Int64, ParameterDirection.Input, (object)Product.CompanyID ?? DBNull.Value); oracleParams.Add(ProductSPParams.PARAMETER_FIN_CUSTOMER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)Product.FCustomerID ?? DBNull.Value); if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1) { complate.ID = oracleParams.Get(0); complate.message = message; } else { complate.message = "Operation Failed"; } return(complate); }
public async static Task <IDTO> AddUpdate(Domain.Entities.ProductSetup.ProductColumnValidation productColumns) { string SPName = ""; string message = ""; OracleDynamicParameters oracleParams = new OracleDynamicParameters(); ComplateOperation <int> complate = new ComplateOperation <int>(); if (productColumns.ID.HasValue) { oracleParams.Add(ProductValidationSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.ID ?? DBNull.Value); SPName = ProductValidationSpName.SP_UPADTE_VALIDATION; message = "Updated Successfully"; } else { oracleParams.Add(ProductValidationSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output); SPName = ProductValidationSpName.SP_INSERT_VALIDATION; message = "Inserted Successfully"; } oracleParams.Add(ProductValidationSpParams.PARAMETER_LABLE, OracleDbType.Varchar2, ParameterDirection.Input, (object)productColumns.Lable ?? DBNull.Value); oracleParams.Add(ProductValidationSpParams.PARAMETER_LABLE2, OracleDbType.Varchar2, ParameterDirection.Input, (object)productColumns.Lable2 ?? DBNull.Value); oracleParams.Add(ProductValidationSpParams.PARAMETER_DATA_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.DataType ?? DBNull.Value); oracleParams.Add(ProductValidationSpParams.PARAMETER_LOC_VALD_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.LocValidType ?? DBNull.Value); oracleParams.Add(ProductValidationSpParams.PARAMETER_IS_MANDETORY, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.IsMandetory ?? DBNull.Value); oracleParams.Add(ProductValidationSpParams.PARAMETER_MAX_VALUE, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.MaxValue ?? DBNull.Value); oracleParams.Add(ProductValidationSpParams.PARAMETER_MIN_VALUE, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.MinValue ?? DBNull.Value); oracleParams.Add(ProductValidationSpParams.PARAMETER_CHECK_DUPLICATION, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.CheckDuplication ?? DBNull.Value); oracleParams.Add(ProductValidationSpParams.PARAMETER_ST_CAT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.CategoryID ?? DBNull.Value); oracleParams.Add(ProductValidationSpParams.PARAMETER_ST_PRD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.ProductID ?? DBNull.Value); oracleParams.Add(ProductValidationSpParams.PARAMETER_ST_PRDT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.ProductDetailID ?? DBNull.Value); oracleParams.Add(ProductValidationSpParams.PARAMETER_ST_COL_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.ColumnID ?? DBNull.Value); if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1) { complate.ID = oracleParams.Get(0); complate.message = message; } else { complate.message = "Operation Failed"; } return(complate); }
public async static Task <IDTO> AddUpdate(Factor factor) { string SPName = ""; string message = ""; OracleDynamicParameters oracleParams = new OracleDynamicParameters(); ComplateOperation <int> complate = new ComplateOperation <int>(); if (factor.ID.HasValue) { oracleParams.Add(FactorSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)factor.ID ?? DBNull.Value); SPName = FactorSpName.SP_UPADTE_FACTOR; message = "Updated Successfully"; } else { oracleParams.Add(FactorSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output); SPName = FactorSpName.SP_INSERT_FACTOR; message = "Inserted Successfully"; } oracleParams.Add(FactorSpParams.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)factor.Name ?? DBNull.Value); oracleParams.Add(FactorSpParams.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)factor.Name2 ?? DBNull.Value); oracleParams.Add(FactorSpParams.PARAMETER_FACT_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)factor.FactorType ?? DBNull.Value); oracleParams.Add(FactorSpParams.PARAMETER_ST_PRD_PRCD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)factor.PricingID ?? DBNull.Value); oracleParams.Add(FactorSpParams.PARAMETER_ST_DIC_COL_ID, OracleDbType.Int64, ParameterDirection.Input, (object)factor.DictionaryID ?? DBNull.Value); oracleParams.Add(FactorSpParams.PARAMETER_ENTRY_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)factor.EntryType ?? DBNull.Value); oracleParams.Add(FactorSpParams.PARAMETER_ST_PRD_FACT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)factor.ProductFactorID ?? DBNull.Value); if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1) { complate.ID = oracleParams.Get(0); complate.message = "Operation Success"; } else { complate.message = "Operation Failed"; } return(complate); }
public bool CambiarContrasena(int idUsuario, string nuevacontrasena, OracleConnection db) { bool seActualizo = false; try { string sp = $"{Package.Admin}USP_UPD_CAMBIAR_CLAVE"; var p = new OracleDynamicParameters(); p.Add("PI_ID_USUARIO", idUsuario); p.Add("PI_CONTRASENA", nuevacontrasena); p.Add("PO_ROWAFFECTED", dbType: OracleDbType.Int32, direction: ParameterDirection.Output); db.Execute(sp, p, commandType: CommandType.StoredProcedure); int filasAfectadas = (int)p.Get <dynamic>("PO_ROWAFFECTED").Value; seActualizo = filasAfectadas > 0; } catch (Exception ex) { Log.Error(ex); } return(seActualizo); }
public bool VerificarCorreo(string correo, OracleConnection db) { bool verificacion = false; try { string sp = $"{Package.Admin}USP_SEL_VERIFICAR_EMAIL"; var p = new OracleDynamicParameters(); p.Add("PI_EMAIL_USUARIO", correo); p.Add("PI_VERIFICAR", dbType: OracleDbType.Int32, direction: ParameterDirection.Output); db.Execute(sp, p, commandType: CommandType.StoredProcedure); int cantidad = (int)p.Get <dynamic>("PI_VERIFICAR").Value; verificacion = cantidad > 0; } catch (Exception ex) { Log.Error(ex); } return(verificacion); }
public async Task <ResponsePostDetail> InsDatosPersonales(PreDatosPersonalesQueryFilter datosPersonalesQueryFilter) { try { var affectedRows = 0; var dyParam = new OracleDynamicParameters(); dyParam.Add("id_pre_inscripcion", OracleDbType.Int32, ParameterDirection.Input, datosPersonalesQueryFilter.IdPreInscripcion); dyParam.Add("documento_identidad", OracleDbType.Varchar2, ParameterDirection.Input, datosPersonalesQueryFilter.DocumentoIdentidad); dyParam.Add("numero_registro", OracleDbType.Varchar2, ParameterDirection.Input, datosPersonalesQueryFilter.NumeroRegistro); dyParam.Add("tipo_doc", OracleDbType.Int32, ParameterDirection.Input, datosPersonalesQueryFilter.ValorTipoDocumento); dyParam.Add("id_departamento_exp", OracleDbType.Int32, ParameterDirection.Input, datosPersonalesQueryFilter.IdDepartamentoExpedido); dyParam.Add("primer_apellido", OracleDbType.Varchar2, ParameterDirection.Input, datosPersonalesQueryFilter.PrimerApellido); dyParam.Add("segundo_apellido", OracleDbType.Varchar2, ParameterDirection.Input, datosPersonalesQueryFilter.SegundoApellido); dyParam.Add("tercer_apellido", OracleDbType.Varchar2, ParameterDirection.Input, datosPersonalesQueryFilter.TercerApellido); dyParam.Add("nombre", OracleDbType.Varchar2, ParameterDirection.Input, datosPersonalesQueryFilter.Nombres); dyParam.Add("fecha_nacimiento", OracleDbType.Date, ParameterDirection.Input, datosPersonalesQueryFilter.FechaNacimiento); dyParam.Add("id_pais_nacionalidad", OracleDbType.Int32, ParameterDirection.Input, datosPersonalesQueryFilter.IdPaisNacionalidad); dyParam.Add("id_departamento_nacimiento", OracleDbType.Int32, ParameterDirection.Input, datosPersonalesQueryFilter.IdDepartamentoNacimiento); dyParam.Add("sexo", OracleDbType.Int32, ParameterDirection.Input, datosPersonalesQueryFilter.ValorSexo); dyParam.Add("estado_civil", OracleDbType.Int32, ParameterDirection.Input, datosPersonalesQueryFilter.ValorEstadoCivil); dyParam.Add("tipo_sangre", OracleDbType.Int32, ParameterDirection.Input, datosPersonalesQueryFilter.ValorTipoSangre); dyParam.Add("direccion", OracleDbType.Varchar2, ParameterDirection.Input, datosPersonalesQueryFilter.Direccion); dyParam.Add("id_zona", OracleDbType.Int32, ParameterDirection.Input, datosPersonalesQueryFilter.IdZona); dyParam.Add("telefono", OracleDbType.Varchar2, ParameterDirection.Input, datosPersonalesQueryFilter.Telefonos); dyParam.Add("celular", OracleDbType.Varchar2, ParameterDirection.Input, datosPersonalesQueryFilter.Celulares); dyParam.Add("email", OracleDbType.Varchar2, ParameterDirection.Input, datosPersonalesQueryFilter.CorreoElectronico); dyParam.Add("trabaja", OracleDbType.Int32, ParameterDirection.Input, (int)(datosPersonalesQueryFilter.Trabaja ? TipoBooleano.si : TipoBooleano.no)); dyParam.Add("lugar_trabaja", OracleDbType.Varchar2, ParameterDirection.Input, datosPersonalesQueryFilter.LugarDeTrabajo); dyParam.Add("affected_rows", OracleDbType.Int32, ParameterDirection.Output, 0); var query = "ACADEMICO.PREINSCRIPCION.SP_INSERTAR_DATOS_PERSONALES"; await _coneccion.InsData(dyParam, query); affectedRows = dyParam.Get("affected_rows"); return(new ResponsePostDetail() { Process = "Pre Inscripcion", AffectedRows = affectedRows }); } catch (Exception err) { throw new Exception(err.Message); } }
public bool EliminarResultado(ResultadoBE obj, OracleConnection db) { bool seGuardo = false; try { string sp = $"{Package.Resultado}USP_DEL_ELIMINAR_RESULTADO"; var p = new OracleDynamicParameters(); p.Add("PI_ID_RESULTADO", obj.ID_RESULTADO); p.Add("PI_ID_USUARIO", obj.UPD_USUARIO); p.Add("PO_ROWAFFECTED", dbType: OracleDbType.Int32, direction: ParameterDirection.Output); db.Execute(sp, p, commandType: CommandType.StoredProcedure); int filasAfectadas = (int)p.Get <dynamic>("PO_ROWAFFECTED").Value; seGuardo = filasAfectadas > 0; } catch (Exception ex) { Log.Error(ex); } return(seGuardo); }
public async static Task <IDTO> AddUpdateMode(Entities.Production.Category category) { string SPName = ""; string message = ""; OracleDynamicParameters oracleParams = new OracleDynamicParameters(); ComplateOperation <int> complate = new ComplateOperation <int>(); if (category.ID.HasValue) { oracleParams.Add(CategorySpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)category.ID ?? DBNull.Value); SPName = CategorySpName.SP_UPADTE_CATEGORY; message = "Updated Successfully"; } else { oracleParams.Add(CategorySpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output); SPName = CategorySpName.SP_INSERT_CATEGORY; message = "Inserted Successfully"; } oracleParams.Add(CategorySpParams.PARAMETER_PRODUCT_CAT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)category.ProductCategoryID ?? DBNull.Value); oracleParams.Add(CategorySpParams.PARAMETER_LABLE, OracleDbType.Varchar2, ParameterDirection.Input, (object)category.Lable ?? DBNull.Value, 100); oracleParams.Add(CategorySpParams.PARAMETER_LABLE2, OracleDbType.Varchar2, ParameterDirection.Input, (object)category.Lable2 ?? DBNull.Value, 100); oracleParams.Add(CategorySpParams.PARAMETER_CAT_ORDER, OracleDbType.Int64, ParameterDirection.Input, (object)category.CategoryOrder ?? DBNull.Value); oracleParams.Add(CategorySpParams.PARAMETER_UW_RISK_ID, OracleDbType.Int64, ParameterDirection.Input, (object)category.RiskID ?? DBNull.Value, 50); oracleParams.Add(CategorySpParams.PARAMETER_UW_DOC_ID, OracleDbType.Int64, ParameterDirection.Input, (object)category.DocumentID ?? DBNull.Value); oracleParams.Add(CategorySpParams.PARAMETER_ST_LOB, OracleDbType.Int64, ParameterDirection.Input, (object)category.LineOfBusiness ?? DBNull.Value); oracleParams.Add(CategorySpParams.PARAMETER_ST_SUB_LOB, OracleDbType.Int64, ParameterDirection.Input, (object)category.SubLineOfBusiness ?? DBNull.Value); oracleParams.Add(CategorySpParams.PARAMETER_UW_MBR_ID, OracleDbType.Int64, ParameterDirection.Input, (object)category.MemberID ?? DBNull.Value); if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1) { complate.message = message; complate.ID = oracleParams.Get(0); } else { complate.message = "Operation Failed"; } return(complate); }