public List <TipoMoneda> TraeTipoMoneda()
{
string xClase = string.Format("{0}|{1}", MethodBase.GetCurrentMethod().Module.Name, MethodBase.GetCurrentMethod().DeclaringType.Name);
string xProceso = MethodBase.GetCurrentMethod().Name;
var dto_excepcion = new UTL_TRA_EXCEPCION
{
STR_CLASE = xClase,
STR_EVENTO = xProceso,
STR_APLICATIVO = ConfigurationManager.AppSettings["APLICATIVO"].ToString(),
STR_SERVIDOR = System.Net.Dns.GetHostName(),
FEC_CREACION = DateTime.Now
};
var dto = new DynamicDto();
dto.ParameterList = new List <SpParameter>();
dto.Result = null;
dto.SPName = "usp_TraeTipoMoneda";
try
{
DynamicDto ds = DynamicSqlDAO.ExecuterSp(dto, GlobalClass.connectionString.Where(a => a.Key == infDto.STR_COD_PAIS).FirstOrDefault().Value);
return(JsonConvert.DeserializeObject <List <TipoMoneda> >(JsonConvert.SerializeObject(ds.Result.Tables[0])));
}
catch (Exception ex)
{
dto_excepcion.STR_MENSAJE = ex.Message;
dto_excepcion.STR_DETALLE = ex.StackTrace;
TwoFunTwoMe_DataAccess.Utility.guardaExcepcion(dto_excepcion, GlobalClass.connectionString.Where(a => a.Key == infDto.STR_COD_PAIS).FirstOrDefault().Value);
throw;
}
}
public static DynamicDto ExecuterSp(DynamicDto xDynamicDto, string xConnectionString)
{
try
{
SqlDatabase sqlDatabase = new SqlDatabase(xConnectionString);
using (DbCommand storedProcCommand = ((Database)sqlDatabase).GetStoredProcCommand(xDynamicDto.SPName))
{
int result = 150000;
storedProcCommand.CommandTimeout = result;
((Database)sqlDatabase).DiscoverParameters(storedProcCommand);
foreach (SqlParameter parameter in storedProcCommand.Parameters)
{
SqlParameter xParameter = parameter;
foreach (SpParameter spParameter in xDynamicDto.ParameterList.Where <SpParameter>((Func <SpParameter, bool>)(param => xParameter.ParameterName.Equals(string.Format("@{0}", (object)param.Name)))))
{
xParameter.Value = (object)spParameter.Value;
}
}
using (DataSet dataSet = ((Database)sqlDatabase).ExecuteDataSet(storedProcCommand))
xDynamicDto.Result = dataSet;
}
}
catch (Exception ex)
{
throw ex;
}
return(xDynamicDto);
}
public List <DTO_GiniMachineConfig> ObtenerConfigGiniMachine(DTO_GiniMachineConfig objConfig)
{
var dto = new DynamicDto();
dto.ParameterList = new List <SpParameter>();
dto.ParameterList.AddRange(from nodo in objConfig.GetType().GetProperties()
where nodo.GetValue(objConfig) != null
select new SpParameter
{
Name = nodo.Name,
Value = nodo.GetValue(objConfig).ToString()
}
);
dto.Result = null;
dto.SPName = "usp_ObtenerConfiguracionGiniMachine";
var dto_result = new List <DTO_GiniMachineConfig>();
try
{
var objRet = DynamicSqlDAO.ExecuterSp(dto, GlobalClass.connectionString.Where(a => a.Key == infDto.STR_COD_PAIS).FirstOrDefault().Value);
if (objRet.HasResult)
{
dto_result = JsonConvert.DeserializeObject <List <DTO_GiniMachineConfig> >(JsonConvert.SerializeObject(objRet.Result.Tables[0]));
}
}
catch (Exception ex)
{
//dto_result.Mensaje = "Ocurrio un Error";
throw;
}
return(dto_result);
}
static void Main(string[] args)
{
//var dto = new DynamicDto
//{ new SpParameter
// {
// Name = "INT_SUB_ORIGEN",
// Value = xInfoClass.INT_SUB_ORIGEN.ToString()
// },
// SPName = "usp_ConsultarAgentes"
//};
var dto = new DynamicDto
{
ParameterList = new List <SpParameter>
{
},
Result = null,
SPName = "usp_ConsultarAgentes"
};
dto.Result = null;
DynamicDto ds = DynamicSqlDAO.ExecuterSp(dto, "Data Source=192.168.110.15 ;Initial Catalog=FinTech_DEV;Persist Security Info=True;User ID=icortes;Password=Ics5355.;");
var res = ds.Result.Tables[0];
foreach (DataRow row in res.Rows)
{
var data = row[0];
}
}
internal static List <FrecuenciaCredito> TraeFrecuenciaCalcu()
{
string xClase = string.Format("{0}|{1}", MethodBase.GetCurrentMethod().Module.Name, MethodBase.GetCurrentMethod().DeclaringType.Name);
string xProceso = MethodBase.GetCurrentMethod().Name;
var dto = new DynamicDto();
dto.ParameterList = new List <SpParameter>();
FrecuenciaCredito frec = new FrecuenciaCredito();
dto.Result = null;
dto.SPName = "usp_TraeFrecuenciaCredito";
var dto_excepcion = new UTL_TRA_EXCEPCION
{
STR_CLASE = xClase,
STR_EVENTO = xProceso,
STR_PARAMETROS = JsonConvert.SerializeObject(frec),
STR_APLICATIVO = ConfigurationManager.AppSettings["Aplicativo"],
STR_SERVIDOR = System.Net.Dns.GetHostName()
};
var dto_obj = new List <FrecuenciaCredito>();
try
{
var obj = DynamicSqlDAO.ExecuterSp <FrecuenciaCredito>(dto, GlobalClass.connectionString.Where(a => a.Key == infDto.STR_COD_PAIS).FirstOrDefault().Value);
dto_obj = obj.ToList();
}
catch (Exception ex)
{
dto_excepcion.STR_MENSAJE = ex.Message;
dto_excepcion.STR_DETALLE = ex.StackTrace;
TwoFunTwoMe_DataAccess.Utility.guardaExcepcion(dto_excepcion, GlobalClass.connectionString.Where(a => a.Key == infDto.STR_COD_PAIS).FirstOrDefault().Value);
}
return(dto_obj);
}
private static DataSet GetStoreParameter(DynamicDto xDynamicDto, string xConnectionString)
{
try
{
using (SqlConnection connection = new SqlConnection(xConnectionString))
{
connection.Open();
DataSet dataSet = new DataSet();
SqlCommand sqlCommand = new SqlCommand("sp_sproc_columns", connection);
sqlCommand.CommandType = CommandType.StoredProcedure;
SqlCommand selectCommand = sqlCommand;
using (SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(selectCommand))
{
selectCommand.Parameters.Add(new SqlParameter("procedure_name", (object)xDynamicDto.SPName));
sqlDataAdapter.Fill(dataSet);
xDynamicDto.Result = dataSet;
connection.Close();
}
connection.Close();
return(dataSet);
}
}
catch (Exception ex)
{
throw ex;
}
}
internal static void ApiSolicitudEndConsul(InsertPersonasWeb insertPersonasWeb, ref DTO_SOLICITUD_VENTAS persona)
{
string xClase = string.Format("{0}|{1}", MethodBase.GetCurrentMethod().Module.Name, MethodBase.GetCurrentMethod().DeclaringType.Name);
string xProceso = MethodBase.GetCurrentMethod().Name;
var dto = new DynamicDto();
dto.ParameterList = new List <SpParameter>();
dto.ParameterList.AddRange(from nodo in insertPersonasWeb.GetType().GetProperties()
where nodo.GetValue(insertPersonasWeb) != null
select new SpParameter
{
Name = nodo.Name,
Value = nodo.GetValue(insertPersonasWeb).ToString()
}
);
dto.Result = null;
dto.SPName = "usp_ValidarPIN";
var dto_excepcion = new UTL_TRA_EXCEPCION
{
STR_CLASE = xClase,
STR_EVENTO = xProceso,
STR_PARAMETROS = JsonConvert.SerializeObject(insertPersonasWeb),
STR_APLICATIVO = ConfigurationManager.AppSettings["Aplicativo"],
STR_SERVIDOR = System.Net.Dns.GetHostName()
};
try
{
var obj = DynamicSqlDAO.ExecuterSp(dto, GlobalClass.connectionString.Where(a => a.Key == infDto.STR_COD_PAIS).FirstOrDefault().Value);
var dto_result = new List <DTO_SOLICITUD_VENTAS>();
if (obj.HasResult)
{
dto_result = JsonConvert.DeserializeObject <List <DTO_SOLICITUD_VENTAS> >(JsonConvert.SerializeObject(obj.Result.Tables[0]));
}
persona = dto_result.ToList().FirstOrDefault();
if (persona != null)
{
persona.Status = dto_result.Any() ? dto_result.ToList().FirstOrDefault().Status : null;
}
else
{
persona = new DTO_SOLICITUD_VENTAS();
}
}
catch (Exception ex)
{
dto_excepcion.STR_MENSAJE = ex.Message;
dto_excepcion.STR_DETALLE = ex.StackTrace;
TwoFunTwoMe_DataAccess.Utility.guardaExcepcion(dto_excepcion, GlobalClass.connectionString.Where(a => a.Key == infDto.STR_COD_PAIS).FirstOrDefault().Value);
}
}
public async Task <DynamicDto <PublicHoliday, Guid> > UpdateAsync(DynamicDto <PublicHoliday, Guid> input)
{
var entity = await _repository.GetAsync(input.Id);
await MapDynamicDtoToEntityAsync <DynamicDto <PublicHoliday, Guid>, PublicHoliday, Guid>(input, entity);
await _repository.UpdateAsync(entity);
return(await MapToDynamicDtoAsync <PublicHoliday, Guid>(entity));
}
private List <Tab_ConfigSys> GetConfigRabbit(Tab_ConfigSys config)
{
manage = new Manager();
string xClase = string.Format("{0}|{1}", MethodBase.GetCurrentMethod().Module.Name, MethodBase.GetCurrentMethod().DeclaringType.Name);
string xProceso = MethodBase.GetCurrentMethod().Name;
string strHostName = System.Net.Dns.GetHostName();
//IPHostEntry ipHostInfo = Dns.Resolve(Dns.GetHostName()); <-- Obsolete
IPHostEntry ipHostInfo = Dns.GetHostEntry(strHostName);
IPAddress ipAddress = ipHostInfo.AddressList[0];
var dto_excepcion = new UTL_TRA_EXCEPCION
{
STR_CLASE = xClase,
STR_EVENTO = xProceso,
STR_APLICATIVO = ConfigurationManager.AppSettings["APLICATIVO"].ToString(),
STR_SERVIDOR = ipAddress.ToString(),
STR_PARAMETROS = JsonConvert.SerializeObject(config)
};
var dto = new DynamicDto();
dto.ParameterList = new List <SpParameter>();
dto.ParameterList.AddRange(from nodo in config.GetType().GetProperties()
where nodo.GetValue(config) != null
select new SpParameter
{
Name = nodo.Name,
Value = nodo.GetValue(config).ToString()
}
);
dto.Result = null;
dto.SPName = "usp_consulta_configuracion_general";
var dto_result = new List <Tab_ConfigSys>();
try
{
var objRet = DynamicSqlDAO.ExecuterSp(dto, GlobalClass.connectionString.Where(a => a.Key == infDto.STR_COD_PAIS).FirstOrDefault().Value);
if (objRet.HasResult)
{
dto_result = JsonConvert.DeserializeObject <List <Tab_ConfigSys> >(JsonConvert.SerializeObject(objRet.Result.Tables[0]));
}
}
catch (Exception ex)
{
dto_excepcion.STR_MENSAJE = ex.Message;
DynamicSqlDAO.guardaExcepcion(dto_excepcion, GlobalClass.connectionString.Where(a => a.Key == infDto.STR_COD_PAIS).FirstOrDefault().Value);
}
return(dto_result);
}
public bool ValidarCuentaSinpe(CuentaBancaria cuentabancaria)
{
string xClase = string.Format("{0}|{1}", MethodBase.GetCurrentMethod().Module.Name, MethodBase.GetCurrentMethod().DeclaringType.Name);
string xProceso = MethodBase.GetCurrentMethod().Name;
var dto_excepcion = new UTL_TRA_EXCEPCION
{
STR_CLASE = xClase,
STR_EVENTO = xProceso,
STR_APLICATIVO = ConfigurationManager.AppSettings["APLICATIVO"].ToString(),
STR_SERVIDOR = System.Net.Dns.GetHostName(),
FEC_CREACION = DateTime.Now
};
var dto = new DynamicDto();
dto.ParameterList = new List <SpParameter>();
dto.ParameterList.AddRange(from nodo in cuentabancaria.GetType().GetProperties()
where nodo.GetValue(cuentabancaria) != null
select new SpParameter
{
Name = nodo.Name,
Value = nodo.GetValue(cuentabancaria).ToString()
}
);
dto.Result = null;
dto.SPName = "usp_ValidaSinpe";
var dto_result = new List <CuentaBancaria>();
try
{
var objRet = DynamicSqlDAO.ExecuterSp(dto, GlobalClass.connectionString.Where(a => a.Key == infDto.STR_COD_PAIS).FirstOrDefault().Value);
if (objRet.HasResult)
{
dto_result = JsonConvert.DeserializeObject <List <CuentaBancaria> >(JsonConvert.SerializeObject(objRet.Result.Tables[0]));
//dto_result.FirstOrDefault().Mensaje = string.Concat("Se creo Buckets N#: ", dto_result.FirstOrDefault().Id);
}
}
catch (Exception ex)
{
dto_excepcion.STR_MENSAJE = ex.Message;
dto_excepcion.STR_DETALLE = ex.StackTrace;
TwoFunTwoMe_DataAccess.Utility.guardaExcepcion(dto_excepcion, GlobalClass.connectionString.Where(a => a.Key == infDto.STR_COD_PAIS).FirstOrDefault().Value);
cuentabancaria.Respuesta = "ERR";
dto_result.Add(cuentabancaria);
//throw;
}
return(dto_result.Any()? dto_result.FirstOrDefault().result:false);
}
public static DynamicDto ExecuterSpOld(DynamicDto xDynamicDto, string xConnectionString)
{
try
{
DataSet dataSet1 = new DataSet();
if (xDynamicDto.ParameterList.Count >= 1)
{
dataSet1 = DynamicSqlDAO.GetStoreParameter(xDynamicDto, xConnectionString);
}
using (SqlConnection connection = new SqlConnection(xConnectionString))
{
connection.Open();
using (SqlCommand selectCommand = new SqlCommand(xDynamicDto.SPName, connection))
{
int result = 150000;
selectCommand.CommandTimeout = result;
selectCommand.CommandType = CommandType.StoredProcedure;
if (dataSet1 != null && dataSet1.Tables.Count > 0)
{
foreach (DataRow row in (InternalDataCollectionBase)dataSet1.Tables[0].Rows)
{
DataRow store = row;
foreach (SpParameter spParameter in xDynamicDto.ParameterList.Where <SpParameter>((Func <SpParameter, bool>)(parameter => store["column_name"].ToString().Replace("@", string.Empty).ToLower().Equals(parameter.Name.Replace("@", string.Empty).ToLower()))))
{
SqlDbType sqlDbType = (SqlDbType)Enum.Parse(typeof(SqlDbType), row["type_name"].ToString(), true);
selectCommand.Parameters.Add(spParameter.Name, sqlDbType, (int)row["LENGTH"]);
selectCommand.Parameters[spParameter.Name].Value = (object)spParameter.Value;
}
}
}
using (SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(selectCommand))
{
DataSet dataSet2 = new DataSet();
sqlDataAdapter.Fill(dataSet2);
xDynamicDto.Result = dataSet2;
connection.Close();
}
}
return(xDynamicDto);
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <DTO_GiniMachine> ObtenerJSON(DTO_GiniMachine dto_Entrada)
{
string xClase = string.Format("{0}|{1}", MethodBase.GetCurrentMethod().Module.Name, MethodBase.GetCurrentMethod().DeclaringType.Name);
string xProceso = MethodBase.GetCurrentMethod().Name;
var dto_excepcion = new UTL_TRA_EXCEPCION
{
STR_CLASE = xClase,
STR_EVENTO = xProceso
};
var dto = new DynamicDto();
dto.ParameterList = new List <SpParameter>();
dto.ParameterList.AddRange(from nodo in dto_Entrada.GetType().GetProperties()
where nodo.GetValue(dto_Entrada) != null
select new SpParameter
{
Name = nodo.Name,
Value = nodo.GetValue(dto_Entrada).ToString()
}
);
dto.Result = null;
dto.SPName = "usp_GeneraProspectoModeloGini";
var dto_result = new List <DTO_GiniMachine>();
try
{
var objRet = DynamicSqlDAO.ExecuterSp(dto, GlobalClass.connectionString.Where(a => a.Key == infDto.STR_COD_PAIS).FirstOrDefault().Value);
if (objRet.HasResult)
{
dto_result = JsonConvert.DeserializeObject <List <DTO_GiniMachine> >(JsonConvert.SerializeObject(objRet.Result.Tables[0]));
dto_result.FirstOrDefault().Mensaje = string.Concat("", dto_result.FirstOrDefault().Mensaje);
}
}
catch (Exception ex)
{
dto_excepcion.STR_MENSAJE = ex.Message;
DynamicSqlDAO.guardaExcepcion(dto_excepcion, ConfigurationManager.ConnectionStrings["TwoFunTwoMeConnection"].ConnectionString);
dto_Entrada.Mensaje = "ERR";
}
return(dto_result);
}
public List <ConsultaRules> consultaRules(ConsultaRules rules)
{
string xClase = string.Format("{0}|{1}", MethodBase.GetCurrentMethod().Module.Name, MethodBase.GetCurrentMethod().DeclaringType.Name);
string xProceso = MethodBase.GetCurrentMethod().Name;
var dto_excepcion = new UTL_TRA_EXCEPCION
{
STR_CLASE = xClase,
STR_EVENTO = xProceso,
STR_APLICATIVO = ConfigurationManager.AppSettings["Aplicativo"],
STR_PARAMETROS = JsonConvert.SerializeObject(rules),
STR_SERVIDOR = System.Net.Dns.GetHostName()
};
var dto = new DynamicDto();
dto.ParameterList = new List <SpParameter>();
var dto_result = new List <ConsultaRules>();
try
{
dto.ParameterList.AddRange(from nodo in rules.GetType().GetProperties()
where nodo.GetValue(rules) != null
select new SpParameter
{
Name = nodo.Name,
Value = nodo.GetValue(rules).ToString()
}
);
dto.Result = null;
dto.SPName = "usp_consultaAnalisisRules";
var objRet = DynamicSqlDAO.ExecuterSp(dto, GlobalClass.connectionString.Where(a => a.Key == infDto.STR_COD_PAIS).FirstOrDefault().Value);
if (objRet.HasResult)
{
dto_result = JsonConvert.DeserializeObject <List <ConsultaRules> >(JsonConvert.SerializeObject(objRet.Result.Tables[0]));
}
}
catch (Exception ex)
{
dto_excepcion.STR_MENSAJE = ex.Message;
dto_excepcion.STR_DETALLE = ex.StackTrace;
}
return(dto_result);
}
private static bool ConsultaUltimoIngresoSolicitud(InsertPersonasWeb persona)
{
string xClase = string.Format("{0}|{1}", MethodBase.GetCurrentMethod().Module.Name, MethodBase.GetCurrentMethod().DeclaringType.Name);
string xProceso = MethodBase.GetCurrentMethod().Name;
var dto_excepcion = new UTL_TRA_EXCEPCION
{
STR_CLASE = xClase,
STR_EVENTO = xProceso,
STR_PARAMETROS = JsonConvert.SerializeObject(persona),
STR_APLICATIVO = ConfigurationManager.AppSettings["Aplicativo"],
STR_SERVIDOR = System.Net.Dns.GetHostName()
};
var dto = new DynamicDto();
dto.ParameterList = new List <SpParameter>();
dto.ParameterList.AddRange(from nodo in persona.GetType().GetProperties()
where nodo.GetValue(persona) != null
select new SpParameter
{
Name = nodo.Name,
Value = nodo.GetValue(persona).ToString()
}
);
dto.Result = null;
dto.SPName = "usp_consulta_ultimo_ingreso_solicitud";
try
{
var obj = DynamicSqlDAO.ExecuterSp <InsertPersonasWeb>(dto, GlobalClass.connectionString.Where(a => a.Key == infDto.STR_COD_PAIS).FirstOrDefault().Value);
return(obj.Any());
}
catch (Exception ex)
{
dto_excepcion.STR_MENSAJE = ex.Message;
dto_excepcion.STR_DETALLE = ex.StackTrace;
TwoFunTwoMe_DataAccess.Utility.guardaExcepcion(dto_excepcion, GlobalClass.connectionString.Where(a => a.Key == infDto.STR_COD_PAIS).FirstOrDefault().Value);
}
return(false);
}
internal static List <DTO_SOLICITUD_VENTAS> GuardaProducto(DTO_SOLICITUD_VENTAS solicitudes)
{
string xClase = string.Format("{0}|{1}", MethodBase.GetCurrentMethod().Module.Name, MethodBase.GetCurrentMethod().DeclaringType.Name);
string xProceso = MethodBase.GetCurrentMethod().Name;
var dto = new DynamicDto();
dto.ParameterList = new List <SpParameter>();
dto.ParameterList.AddRange(from nodo in solicitudes.GetType().GetProperties()
where nodo.GetValue(solicitudes) != null
select new SpParameter
{
Name = nodo.Name,
Value = nodo.GetValue(solicitudes).ToString()
}
);
dto.Result = null;
dto.SPName = "usp_GuardarProducto";
var dto_excepcion = new UTL_TRA_EXCEPCION
{
STR_CLASE = xClase,
STR_EVENTO = xProceso,
STR_PARAMETROS = JsonConvert.SerializeObject(solicitudes),
STR_APLICATIVO = ConfigurationManager.AppSettings["Aplicativo"],
STR_SERVIDOR = System.Net.Dns.GetHostName()
};
var dto_obj = new List <DTO_SOLICITUD_VENTAS>();
try
{
var obj = DynamicSqlDAO.ExecuterSp <DTO_SOLICITUD_VENTAS>(dto, GlobalClass.connectionString.Where(a => a.Key == infDto.STR_COD_PAIS).FirstOrDefault().Value);
dto_obj = obj.ToList();
}
catch (Exception ex)
{
dto_excepcion.STR_MENSAJE = ex.Message;
dto_excepcion.STR_DETALLE = ex.StackTrace;
TwoFunTwoMe_DataAccess.Utility.guardaExcepcion(dto_excepcion, GlobalClass.connectionString.Where(a => a.Key == infDto.STR_COD_PAIS).FirstOrDefault().Value);
}
return(dto_obj);
}
public List <CuentaBancaria> uspConsultaEditCuentaBancaria(CuentaBancaria cuentaBancaria)
{
string xClase = string.Format("{0}|{1}", MethodBase.GetCurrentMethod().Module.Name, MethodBase.GetCurrentMethod().DeclaringType.Name);
string xProceso = MethodBase.GetCurrentMethod().Name;
var dto_excepcion = new UTL_TRA_EXCEPCION
{
STR_CLASE = xClase,
STR_EVENTO = xProceso,
STR_APLICATIVO = ConfigurationManager.AppSettings["Aplicativo"],
STR_PARAMETROS = JsonConvert.SerializeObject(cuentaBancaria),
STR_SERVIDOR = System.Net.Dns.GetHostName()
};
var dto = new DynamicDto();
dto.ParameterList = new List <SpParameter>();
try
{
dto.ParameterList.AddRange(from nodo in cuentaBancaria.GetType().GetProperties()
where nodo.GetValue(cuentaBancaria) != null
select new SpParameter
{
Name = nodo.Name,
Value = nodo.GetValue(cuentaBancaria).ToString()
}
);
dto.Result = null;
dto.SPName = "usp_ConsultarPersonasCuenta_Edit_Ventas_Fenix";
return(DynamicSqlDAO.ExecuterSp <CuentaBancaria>(dto, GlobalClass.connectionString.Where(a => a.Key == infDto.STR_COD_PAIS).FirstOrDefault().Value).ToList());
}
catch (Exception ex)
{
dto_excepcion.STR_MENSAJE = ex.Message;
dto_excepcion.STR_DETALLE = ex.StackTrace;
Utility.guardaExcepcion(dto_excepcion, GlobalClass.connectionString.Where(a => a.Key == infDto.STR_COD_PAIS).FirstOrDefault().Value);
}
return(new List <CuentaBancaria>());
}
public bool guardarAsignacionAgenciaExterna(DtoAsignacionAgenciaExterna row)
{
string xClase = string.Format("{0}|{1}", MethodBase.GetCurrentMethod().Module.Name, MethodBase.GetCurrentMethod().DeclaringType.Name);
string xProceso = MethodBase.GetCurrentMethod().Name;
var dto_excepcion = new UTL_TRA_EXCEPCION
{
STR_CLASE = xClase,
STR_EVENTO = xProceso,
STR_APLICATIVO = ConfigurationManager.AppSettings["Aplicativo"],
STR_PARAMETROS = JsonConvert.SerializeObject(row),
STR_SERVIDOR = System.Net.Dns.GetHostName()
};
var dto = new DynamicDto();
dto.ParameterList = new List <SpParameter>();
dto.ParameterList.AddRange(from nodo in row.GetType().GetProperties()
where nodo.GetValue(row) != null
select new SpParameter
{
Name = nodo.Name,
Value = nodo.GetValue(row).ToString()
}
);
dto.Result = null;
dto.SPName = "usp_asignar_agencia_externa";
try
{
var objRet = DynamicSqlDAO.ExecuterSp(dto, GlobalClass.connectionString.Where(a => a.Key == infDto.STR_COD_PAIS).FirstOrDefault().Value);
return(true);
}
catch (Exception ex)
{
dto_excepcion.STR_MENSAJE = ex.Message;
dto_excepcion.STR_DETALLE = ex.StackTrace;
Utility.guardaExcepcion(dto_excepcion, GlobalClass.connectionString.Where(a => a.Key == infDto.STR_COD_PAIS).FirstOrDefault().Value);
throw ex;
}
}
public override async Task <DynamicDto <Person, Guid> > UpdateAsync([DynamicBinder(UseDtoForEntityReferences = true)] DynamicDto <Person, Guid> input)
{
return(await base.UpdateAsync(input));
}
