public DataTable Get_Datos_Reniec_Local_by_dni(Reniec Objeto)
{
DataTable dt = new DataTable();
try
{
clsConection Obj = new clsConection();
string Cadena = Obj.GetConexionString("Naylamp");
using (SqlConnection cn = new SqlConnection(Cadena))
{
cn.Open();
using (SqlCommand cm = new SqlCommand())
{
cm.CommandText = "[usp_Get_Datos_Reniec_Local_by_dni]";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("dni", Objeto.dni);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
dt.Load(dr);
}
}
}
catch (Exception)
{
throw;
}
return(dt);
}
public async Task <Reniec> GetAsync(string nuDNI)
{
using (var connection = _connectionFactory.GetConnection)
{
var query = "sps_mae_reniec";
var parameters = new DynamicParameters();
parameters.Add("@pi_nuDNI", nuDNI);
parameters.Add("@pi_id_usuario_login", 0);
parameters.Add("@po_error_number", 0, direction: ParameterDirection.Output);
parameters.Add("@po_error_message", "", direction: ParameterDirection.Output);
var reniec = await connection.QuerySingleOrDefaultAsync <Reniec>(query, param : parameters, commandType : CommandType.StoredProcedure);
if (reniec == null)
{
Reniec contribuyenteError = new Reniec();
contribuyenteError.error_number = parameters.Get <int>("@po_error_number");
contribuyenteError.error_message = parameters.Get <string>("@po_error_message");
return(contribuyenteError);
}
else
{
return(reniec);
}
}
}
private void CargarImagenReniec()
{
try
{
if (MyInfoReniec == null)
{
MyInfoReniec = new Reniec();
}
this.pbCapchatS.Image = MyInfoReniec.GetCapcha;
AplicacionFiltros();
LeerCaptchaReniec();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public DataTable Get_Datos_Reniec_Local_by_dni(Reniec Objeto)
{
DA_Reniec da = new DA_Reniec();
return(da.Get_Datos_Reniec_Local_by_dni(Objeto));
}
