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