public DbDataReader consultaCuentasPropias(ConsultaCuentaModel consulta, SqlServer sql)
{
var com = sql.Database.GetDbConnection().CreateCommand();
com.CommandText = "exec ConsultaCuentas @Cliente = '" + consulta.id_cliente + "', @Costo ='" + consulta.costo + "'";
sql.Database.OpenConnection();
DbDataReader result = com.ExecuteReader();
return(result);
}
public object consulta_cuentas(ConsultaCuentaModel consulta)
{
List <CuentasModel> cuentasModel = new List <CuentasModel>();
DbDataReader result = null;
try
{
result = query.consultaCuentasPropias(consulta, connection);
} catch (SqlException e)
{
Console.WriteLine(e.Message);
log.logger(e.Message);
return(new{ m = "Ha ocurrido una desgracia", ok = 0 });
}
if (result.HasRows)
{
while (result.Read())
{
cuentasModel.Add(new CuentasModel
{
name_client = result["name_client"].ToString(),
saldo = (double)result["saldo"],
number_account = (int)result["number_account"],
type_account = (int)result["type_account"]
}
);
}
string str = string.Join(',', cuentasModel);
var res = encrypt.GetMD5(str);
return(new { m = "satifactorio", ok = 1, data = res });
}
else
{
return(new { m = "No existe", ok = 0 });
}
}
