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