using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.WindowsAzure.StorageClient;

namespace LendingRateTable
{
 public class LendingInstitutionRate : TableServiceEntity
 {
   public string LendingInstitution { get; set; }
   public string ID { get; set; }
   public string Instrument { get; set; }
   public int Year { get; set; }
   public double Rate { get; set; }
   public double Points { get; set; }
   public double APR { get; set; }
   public string Lock { get; set; }
   public string InstrumentRateDisplayName { get; set; }

   public LendingInstitutionRate(string ID)
   {
     PartitionKey = "LendingRates";
     RowKey = ID;
   }

   public LendingInstitutionRate()
   {
     PartitionKey = "LendingRates";
   }
 }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.WindowsAzure.StorageClient;
using Microsoft.WindowsAzure;

namespace LendingRateTable
{
 public class LendingDataContext : TableServiceContext
 {
   public LendingDataContext(string baseAddress, StorageCredentials credentials)
     : base(baseAddress, credentials)
   {

   }

   public IQueryable<LendingInstitutionRate> LendingInstitutionRate
   {
     get
     {
       return this.CreateQuery<LendingInstitutionRate>("LendingInstitutionRate");
     }
   }
 }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.WindowsAzure;
using Microsoft.WindowsAzure.StorageClient;

namespace LendingRateTable
{
 public class LendingDataSource
 {
   private static CloudStorageAccount storageAccount;
   private LendingDataContext context;

   static LendingDataSource()
   {
     try
     {
       storageAccount = CloudStorageAccount.DevelopmentStorageAccount;

       CloudTableClient c = new CloudTableClient(
           storageAccount.TableEndpoint.AbsoluteUri, storageAccount.Credentials);

       if (!c.DoesTableExist("LendingInstitutionRate"))
       {
           CloudTableClient.CreateTablesFromModel(typeof(LendingDataContext),
               storageAccount.TableEndpoint.AbsoluteUri,
               storageAccount.Credentials);
       }
     }
      catch (Exception e)
      {
          Console.WriteLine(e.Message);
      }
    }

    public LendingDataSource()
    {
      this.context = new LendingDataContext(
        storageAccount.TableEndpoint.AbsoluteUri, storageAccount.Credentials);

      this.context.RetryPolicy = RetryPolicies.Retry(3, TimeSpan.FromSeconds(1));
    }

    // Retrieve all lending institution rates entities in the table
    public IEnumerable<LendingInstitutionRate> Select()
    {
      var results = from g in this.context.LendingInstitutionRate
                    where g.PartitionKey == "LendingRates"
                    select g;
        return results;
    }

    // Add a single lending institution rate entity
    public void AddLendingInstitutionRate(LendingInstitutionRate newItem)
    {
      this.context.AddObject("LendingInstitutionRate", newItem);
      this.context.SaveChanges();
    }

    // Use to add multiple lending institutions in a batch - one at a time.
    // Then, call Save() after adding the institutions
    public void AddLendingInstitutionRates(LendingInstitutionRate newItem)
    {
      this.context.AddObject("LendingInstitutionRate", newItem);
    }

    // Save the entities to Azure
    public void Save()
    {
      this.context.SaveChanges
(System.Data.Services.Client.SaveChangesOptions.Batch);
    }

    // Delete a specific entity
    public void DeleteLendingInstitutionRate(LendingInstitutionRate item)
    {
      this.context.DeleteObject(item);
      this.context.SaveChanges();
    }

    // Delete ALL entities in the table at one time
    public void DeleteLendingInstitutionRates()
    {
      foreach (var p in this.Select())
      {
          this.context.DeleteObject(p);
      }
      this.context.SaveChanges
(System.Data.Services.Client.SaveChangesOptions.Batch);
    }
  }
}

     Console.WriteLine("Creating two test entities…");

     LendingDataSource ds = new LendingDataSource();

     // So this can be run more than one time
     // (i.e. RowKeys must be unique)
     ds.DeleteLendingInstitutionRates();

     // Create an entity and add it
     LendingInstitutionRate lir = new LendingInstitutionRate();
     lir.PartitionKey = "LendingRates";
     lir.RowKey = "1";
     lir.LendingInstitution = "Woodgrove Bank";
     lir.ID = "1";
     lir.Instrument = "30 Year Fixed";
     lir.Year = 30;
     lir.Rate = 0.05;
     lir.Points = 0.0;
     lir.APR = 0.051;
     lir.Lock = "30 day";
     lir.InstrumentRateDisplayName = "Woodgrove Bank 30 Year 5%";
     ds.AddLendingInstitutionRates(lir);

     // Create a second entity and add it
     LendingInstitutionRate lir2 = new LendingInstitutionRate();
     lir2.PartitionKey = "LendingRates";
     lir2.RowKey = "2";
     lir2.LendingInstitution = "Fabrikam Loans";
     lir2.ID = "2";
     lir2.Instrument = "25 Year Fixed";
     lir2.Year = 25;
     lir2.Rate = 0.04;
     lir2.Points = 0.0;
     lir2.APR = 0.041;
     lir2.Lock = "20 day";
     lir2.InstrumentRateDisplayName = "Fabrikam Loans 25 Year 4%";
     ds.AddLendingInstitutionRates(lir2);

      // Save all pending changes in a single batch
      ds.Save();

      Console.WriteLine("
Entities created.");
      Console.WriteLine("
Retrieving Lending Institution Entities...");

      foreach (var r in ds.Select())
      {
          Console.WriteLine("Institution name: {0}",
              r.LendingInstitution);
      }

      Console.WriteLine("
Press <enter> to end...");
      Console.ReadLine();

using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.ServiceModel.Activation;
using System.ServiceModel.Web;
using System.Text;

namespace LendingRateRoleJSON
{
 [AspNetCompatibilityRequirements(RequirementsMode =
  AspNetCompatibilityRequirementsMode.Allowed)]
 public class LendingRateJSONService:ILendingRateJSONService
 {
     // To use HTTP GET, add [WebGet] attribute. (Default ResponseFormat is
     // WebMessageFormat.Json)
     // To create an operation that returns XML,
     //     add [WebGet(ResponseFormat=WebMessageFormat.Xml)],
     //     and include the following line in the operation body:
     //         WebOperationContext.Current.OutgoingResponse.ContentType =
     // "text/xml";

     public String[] GetLendingInstitutions()
     {

         LendingDataSource ds = new LendingDataSource();

         //Get the specific lending institution names (sorted) that have rates
         var results = (from i in ds.Select()
                          orderby i.LendingInstitution
                          select i.LendingInstitution).Distinct();

          return results.ToArray();
      }

      public IEnumerable<OutputInstitutionRate>
      GetALendingInstitutionsRates(string lendingInstitutionName)
      {
          //lendingInstitutionName = "Fabrikam Loans";
          LendingDataSource ds = new LendingDataSource();

          List<OutputInstitutionRate> oirList = new List<OutputInstitutionRate>();

          //Get all the rates a specific lending institution offers
          foreach (var i in
          ds.GetALendingInstitutionsRates(lendingInstitutionName))
          {
              OutputInstitutionRate oir = new OutputInstitutionRate();
              oir.APR = i.APR;
              oir.ID = i.ID;
              oir.Instrument = i.Instrument;
              oir.InstrumentRateDisplayName = i.InstrumentRateDisplayName;
              oir.LendingInstitution = i.LendingInstitution;
              oir.Lock = i.Lock;
              oir.Points = i.Points;
              oir.Rate = i.Rate;
              oir.Year = i.Year;
              oirList.Add(oir);
          }

          oirList = (from u in oirList
                      orderby u.InstrumentRateDisplayName
                      select u).ToList();

          return oirList;
      }

      public OutputInstitutionRate
      GetASpecificLendingInstitutionsRate(string lendingRateIdentifier)
      {
          //lendingRateIdentifier = "1";
          LendingDataSource ds = new LendingDataSource();

          List<OutputInstitutionRate> oirList = new List<OutputInstitutionRate>();

          //Get a specific lending rate for a lending institution by ID
          foreach (var i in
          ds.GetASpecificLendingInstitutionsRate(lendingRateIdentifier))
          {
              OutputInstitutionRate temp = new OutputInstitutionRate();
              temp.APR = i.APR;
              temp.ID = i.ID;
              temp.Instrument = i.Instrument;
              temp.InstrumentRateDisplayName = i.InstrumentRateDisplayName;
              temp.LendingInstitution = i.LendingInstitution;
              temp.Lock = i.Lock;
              temp.Points = i.Points;
              temp.Rate = i.Rate;
              temp.Year = i.Year;
              oirList.Add(temp);
          }

          OutputInstitutionRate oir = new OutputInstitutionRate();

          if (oirList.Count > 0)
          {
              oir.APR = oirList[0].APR;
              oir.ID = oirList[0].ID;
              oir.Instrument = oirList[0].Instrument;
              oir.InstrumentRateDisplayName = 
                oirList[0].InstrumentRateDisplayName;
              oir.LendingInstitution = oirList[0].LendingInstitution;
              oir.Lock = oirList[0].Lock;
              oir.Points = oirList[0].Points;
              oir.Rate = oirList[0].Rate;
              oir.Year = oirList[0].Year;
          }
          else
          {
              oir = null;
          }

          return oir;
      }
  }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.ServiceModel;
using System.ServiceModel.Web;

namespace LendingRateRoleJSON
{
 [ServiceContract(Namespace = "LendingRates", Name = "JSONService")]
 interface ILendingRateJSONService
 {
   [OperationContract, WebGet]
   string[] GetLendingInstitutions();

   [OperationContract, WebGet]
   IEnumerable<OutputInstitutionRate> GetALendingInstitutionsRates(String
     lendingInstitutionName);

   [OperationContract, WebGet]
   OutputInstitutionRate GetASpecificLendingInstitutionsRate(String
     lendingRateIdentifier);
 }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using Microsoft.WindowsAzure.StorageClient;

namespace LendingRateRoleJSON
{
 public class LendingInstitutionRate : TableServiceEntity
 {
   public string LendingInstitution { get; set; }
   public string ID { get; set; }
   public string Instrument { get; set; }
   public int Year { get; set; }
   public double Rate { get; set; }
   public double Points { get; set; }
   public double APR { get; set; }
   public string Lock { get; set; }
   public string InstrumentRateDisplayName { get; set; }

   public LendingInstitutionRate(string ID)
   {
       PartitionKey = "LendingRates";
       RowKey = ID;
   }

   public LendingInstitutionRate()
   {
       PartitionKey = "LendingRates";
   }
 }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Runtime.Serialization;

namespace LendingRateRoleJSON
{
 [DataContract]
 public class OutputInstitutionRate
 {
   [DataMember]
   public string LendingInstitution { get; set; }
   [DataMember]
   public string ID { get; set; }
   [DataMember]
   public string Instrument { get; set; }
   [DataMember]
   public int Year { get; set; }
   [DataMember]
   public double Rate { get; set; }
   [DataMember]
   public double Points { get; set; }
   [DataMember]
   public double APR { get; set; }
   [DataMember]
   public string Lock { get; set; }
   [DataMember]
   public string InstrumentRateDisplayName { get; set; }
 }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using Microsoft.WindowsAzure;
using Microsoft.WindowsAzure.StorageClient;

namespace LendingRateRoleJSON
{
 public class LendingDataContext : TableServiceContext
 {

    public LendingDataContext(string baseAddress, StorageCredentials credentials)
        : base(baseAddress, credentials)
    {

    }

    public IQueryable<LendingInstitutionRate> LendingInstitutionRate
    {
      get
      {
          return this.CreateQuery<LendingInstitutionRate>
("LendingInstitutionRate");
      }
    }
  }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using Microsoft.WindowsAzure;
using Microsoft.WindowsAzure.StorageClient;

namespace LendingRateRoleJSON
{
 public class LendingDataSource
 {
   private static CloudStorageAccount storageAccount;
   private LendingDataContext context;

   static LendingDataSource()
   {
       try
       {

         storageAccount =
CloudStorageAccount.Parse("DefaultEndpointsProtocol=https;
AccountName={youraccountname};AccountKey={youraccountkey}");

           CloudTableClient c = new CloudTableClient(
             storageAccount.TableEndpoint.AbsoluteUri,
storageAccount.Credentials);

           if (!c.DoesTableExist("LendingRates"))
           {
             CloudTableClient.CreateTablesFromModel(typeof(LendingDataContext),
                  storageAccount.TableEndpoint.AbsoluteUri,
                  storageAccount.Credentials);
            }
        }
        catch (Exception e)
        {
          //System.Windows.Forms.MessageBox.Show(e.Message);
        }
    }

    public LendingDataSource()
    {
        this.context = new LendingDataContext(
          storageAccount.TableEndpoint.AbsoluteUri, storageAccount.Credentials);

        this.context.RetryPolicy = RetryPolicies.Retry(3,
TimeSpan.FromSeconds(1));
    }

    public IEnumerable<LendingInstitutionRate> Select()
    {
        var results = from g in this.context.LendingInstitutionRate
                      where g.PartitionKey == "LendingRates"
                      select g;

        return results;
    }

    public IEnumerable<LendingInstitutionRate> GetALendingInstitutionsRates(String
lendingInstitutionName)
    {
        var results = from g in this.context.LendingInstitutionRate
            where g.PartitionKey == "LendingRates" && g.LendingInstitution ==
lendingInstitutionName
            select g;

        return results;
    }

    public IEnumerable<LendingInstitutionRate>
GetASpecificLendingInstitutionsRate(String lendingRateIdentifier)
    {

        var results = from g in this.context.LendingInstitutionRate
            where g.PartitionKey == "LendingRates" && g.ID ==
lendingRateIdentifier
            select g;

        return results;
    }

    public void AddLendingInstitutionRate(LendingInstitutionRate newItem)
    {
        this.context.AddObject("LendingInstitutionRate", newItem);
        this.context.SaveChanges();
    }

    // Use to add multiple lending institutions in a batch
    // Call Save() after adding the institutions
    public void AddLendingInstitutionRates(LendingInstitutionRate newItem)
    {
        this.context.AddObject("LendingInstitutionRate", newItem);
    }

    public void Save()
    {
        this.context.SaveChanges
(System.Data.Services.Client.SaveChangesOptions.Batch);
    }

    public void DeleteLendingInstitutionRate(LendingInstitutionRate item)
    {
        this.context.DeleteObject(item);
        this.context.SaveChanges();
    }

    public void DeleteLendingInstitutionRates()
    {
        foreach (var p in this.Select())
        {
            this.context.DeleteObject(p);
        }
        this.context.SaveChanges
(System.Data.Services.Client.SaveChangesOptions.Batch);
    }
  }
}

        <behavior name="LendingRateJSONServiceBehavior">
          <serviceMetadata httpGetEnabled="true" />
          <serviceDebug includeExceptionDetailInFaults="true" />
        </behavior>

   <service name="LendingRateRoleJSON.LendingRateJSONService"
       behaviorConfiguration="LendingRateJSONServiceBehavior">

contract="LendingRateRoleJSON.ILendingRateJSONService"

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.WindowsAzure.StorageClient;

namespace ExcelMortgageAzure
{
 public class LendingInstitutionRate:TableServiceEntity
 {
   public string LendingInstitution { get; set; }
   public string ID { get; set; }
   public string Instrument { get; set; }
   public int Year { get; set; }
   public double Rate { get; set; }
   public double Points { get; set; }
   public double APR { get; set; }
   public string Lock { get; set; }
   public string InstrumentRateDisplayName { get; set; }

   public LendingInstitutionRate(string ID)
   {
       PartitionKey = "LendingRates";
       RowKey = ID;
   }

   public LendingInstitutionRate()
   {
       PartitionKey = "LendingRates";
   }
 }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.WindowsAzure;
using Microsoft.WindowsAzure.StorageClient;

namespace ExcelMortgageAzure
{
 public class LendingDataContext:TableServiceContext
 {

   public LendingDataContext(string baseAddress, StorageCredentials credentials)
           : base(baseAddress, credentials)
   {

   }

   public IQueryable<LendingInstitutionRate> LendingInstitutionRate
   {
     get
     {
         return
this.CreateQuery<LendingInstitutionRate>("LendingInstitutionRate");
     }
   }
 }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.WindowsAzure;
using Microsoft.WindowsAzure.StorageClient;

namespace ExcelMortgageAzure
{
 public class LendingDataSource
 {
   private static CloudStorageAccount storageAccount;
   private LendingDataContext context;

   static LendingDataSource()
   {
     try
     {

         storageAccount =
CloudStorageAccount.Parse("DefaultEndpointsProtocol=https;
AccountName={youraccountname};AccountKey={youraccountkey}");

         CloudTableClient c = new CloudTableClient(
             storageAccount.TableEndpoint.AbsoluteUri,
storageAccount.Credentials);

         if (!c.DoesTableExist("LendingInstitutionRate"))
         {
             CloudTableClient.CreateTablesFromModel(typeof(LendingDataContext),

                  storageAccount.TableEndpoint.AbsoluteUri,
                  storageAccount.Credentials);   
          }
      }
      catch (Exception e)
      {
          System.Windows.Forms.MessageBox.Show(e.Message);
      }
    }

    public LendingDataSource()
    {
      this.context = new LendingDataContext(
          storageAccount.TableEndpoint.AbsoluteUri, storageAccount.Credentials);

      this.context.RetryPolicy = RetryPolicies.Retry(3, TimeSpan.FromSeconds(1));
    }

    public IEnumerable<LendingInstitutionRate> Select()
    {
        var results = from g in this.context.LendingInstitutionRate
                      where g.PartitionKey == "LendingRates"
                      select g;

        return results;
    }

    public void AddLendingInstitutionRate(LendingInstitutionRate newItem)
    {
        this.context.AddObject("LendingInstitutionRate", newItem);
        this.context.SaveChanges();
    }

    // Use to add multiple products in a batch
    // call Save() after adding the products
    public void AddLendingInstitutionRates(LendingInstitutionRate newItem)
    {
        this.context.AddObject("LendingInstitutionRate", newItem);
    }

    public void Save()
    {
        this.context.SaveChanges
(System.Data.Services.Client.SaveChangesOptions.Batch);
    }

    public void DeleteLendingInstitutionRate(LendingInstitutionRate item)
    {
        this.context.DeleteObject(item);
        this.context.SaveChanges();
    }

    public void DeleteLendingInstitutionRates()
    {
        foreach (var p in this.Select())
        {
            this.context.DeleteObject(p);
        }
        this.context.SaveChanges
(System.Data.Services.Client.SaveChangesOptions.Batch);
    }

  }
}

List<LendingInstitutionRate> liRates = new List<LendingInstitutionRate>();

//Instantiate the data source
LendingDataSource ds = new LendingDataSource();

//Retrieve Azure data from table storage and save into a list for reuse

foreach (var lir in ds.Select())
 {
   LendingInstitutionRate tempLir = new LendingInstitutionRate();
   tempLir.ID = lir.ID;
   tempLir.LendingInstitution = lir.LendingInstitution;
   tempLir.Instrument = lir.Instrument;
   tempLir.Year = lir.Year;
   tempLir.Rate = lir.Rate;
   tempLir.Points = lir.Points;
   tempLir.APR = lir.APR;
   tempLir.Lock = lir.Lock;
   tempLir.InstrumentRateDisplayName = lir.InstrumentRateDisplayName;

   liRates.Add(tempLir);
  }

//Load a variable with only the lending institutions
var lendingInstitutions = (from i in liRates
   select i.LendingInstitution).Distinct();

//Load the combobox with the institution names
comboBoxLenders.DataSource = lendingInstitutions.ToArray();
comboBoxLenders.DisplayMember = "LendingInstitution";

//On selection change selects only the institution's
//rates from the list
var lendingInstitutionRates = from i in liRates
   where i.LendingInstitution ==
         comboBoxLenders.SelectedValue.ToString()
         orderby i.LendingInstitution,
         i.Instrument, i.Year, i.Rate
         select i;

//Load the rates combobox for the lending institution
comboBoxRates.DataSource = lendingInstitutionRates.ToArray();
comboBoxRates.DisplayMember = "InstrumentRateDisplayName";
comboBoxRates.ValueMember = "ID";

//Select the specific rate for the institution and
//apply the data appropriately to
//the named ranges on the spreadsheet.
var lendingInstitutionRates = from i in liRates
   where i.ID ==
   comboBoxRates.SelectedValue.ToString()
   select i;

//Load the named ranges
foreach (var lir in lendingInstitutionRates)
 {
   this.TERM.Cells.Value = lir.Year;
   this.FIR.Cells.Value = lir.Rate;
   this.LENDER.Cells.Value = lir.LendingInstitution;
   this.POINTS.Cells.Value = lir.Points;
   this.INSTRUMENT.Cells.Value = lir.InstrumentRateDisplayName;
   this.LOCK.Cells.Value = lir.Lock;
   this.APR.Cells.Value = lir.APR;
   }

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
 <head>
   <script src="/Shared%20Documents/MortgageAssetsJS/jquery.js"
type="text/javascript"></script>
   <script src="/Shared%20Documents/MortgageAssetsJS/jquery-jtemplates.js"
type="text/javascript"></script>
   <script src="/Shared%20Documents/MortgageAssetsJS/LendingServiceProxy.js"
type="text/javascript"></script>
   <link href="/Shared%20Documents/MortgageAssetsJS/LendingStyles.css"
rel="stylesheet" type="text/css" />
   <title>Lending Institution Rate Selection</title>
 </head>

 <body>
   <div>
     <div id="Institutions">
       <div id="InstitutionSelection">
         <b>Lending Agency:</b>
         <select id=‘lendinginstdd’ style=‘width:175px’
               onchange=‘dropdownlending_onchange(this)’></select>
           <br /><br />
         <b>Lending Program:</b>
         <select id=‘lendingratesdd’ style=‘width:175px’
               onchange=‘dropdownlendingrates_onchange(this)’></select>
           <br /><br />
         </div>
       <div id="RateDisplay">

          <img id="RetrievingImg"
            src="/Shared%20Documents/MortgageAssetsJS/ajax-loader.gif"
              class="Hidden" />
          <div id="SingleRate">
          </div>
        </div>
      </div>
    </div>
  </body>

  <script type="text/javascript">

    // Script level variables
    var xlWebPart;
    var proxy = new LendingServiceProxy();
    var APR = null;
    var Instrument = null;
    var LendingInstitution = null;
    var Lock = null;
    var Points = null;
    var Rate = null;

    // Set the page event handlers for onload and unload.
    if (window.attachEvent) {
      window.attachEvent("onload", Page_Load);
    }
    else {
      // For some browsers window.attachEvent does not exist.
      window.addEventListener("DOMContentLoaded", Page_Load, false);
    }

    // Load the page.
    function Page_Load() {
      Ewa.EwaControl.add_applicationReady(GetEwa);
    }

    // Get handle to EWA instance, set event handlers and initialize content
    function GetEwa() {
      xlWebPart = Ewa.EwaControl.getInstances().getItem(0);

      // Retrieve all lending institutions
      $("#RetrievingImg").removeClass("Hidden");
      proxy.GetLendingInstitutions(institutionsRetrieved,
serviceDefaultErrorHandler);
    }
   
  // institutionsRetrieved()
  // called when the service returns a list of lending institutions
  // loads lendinginstdd dropdown list
  function institutionsRetrieved(results) {
    if (results) {
      if (results.length > 0) {
          var list = document.getElementById(‘lendinginstdd’);
          // Clear options before loading
          list.selectedIndex = 0;
          list.options.length = 0;
          for (n in results) {
              var opt = document.createElement("option");
              opt.text = results[n];
              opt.value = results[n];
              list.options.add(opt);
          }
        }
        else {
          alert("no lending institutions found");
        }
      }
      $("#RetrievingImg").addClass("Hidden");
  }

  // ratesRetrieved()
  // called when the service returns a list of lending institution rates
  // loads lendingratesdd dropdown list
  function ratesRetrieved(results)
  {
    if (results) {
      if (results.length > 0) {
          var list = document.getElementById(‘lendingratesdd’);
          // Clear options before loading
          list.selectedIndex = 0;
          list.options.length = 0;
      for (n in results) {
          var opt = document.createElement("option");
          opt.text = results[n].InstrumentRateDisplayName;
          opt.value = results[n].ID;
          list.options.add(opt);
      }
    }
      else {
        alert("no lending rates found for this institution");
      }
    }
    $("#RetrievingImg").addClass("Hidden");
  }

  // loadexcelwebpart()
  // called when the service returns a specific lending institution rate
  // loads the Excel Web Access web part
  function loadexcelwebpart(results) {
    if (results) {
      APR = results.APR;
      Instrument = results.Instrument;
      LendingInstitution = results.LendingInstitution;
      Lock = results.Lock;
      Points = results.Points;
      Rate = results.Rate;
      // load web part named ranges
      xlWebPart.getActiveWorkbook().getRangeA1Async(‘’Sheet1‘!FIR’,
setFIRNamedRangeValue);
      xlWebPart.getActiveWorkbook().getRangeA1Async(‘’Sheet1‘!LENDER’,
setLENDERNamedRangeValue);
      xlWebPart.getActiveWorkbook().getRangeA1Async(‘’Sheet1‘!INSTRUMENT’,
setINSTRUMENTNamedRangeValue);
      xlWebPart.getActiveWorkbook().getRangeA1Async(‘’Sheet1‘!POINTS’,
setPOINTSNamedRangeValue);
      xlWebPart.getActiveWorkbook().getRangeA1Async(‘’Sheet1‘!APR’,
setAPRNamedRangeValue);
      xlWebPart.getActiveWorkbook().getRangeA1Async(‘’Sheet1‘!LOCK’,
 setLOCKNamedRangeValue);
    }
    else {
      alert("no specific lending rate found for this institution");
    }
  }

  // dropdownlending_onchange()
  // Event handler for changes with the selection drop down
  function dropdownlending_onchange(event) {
    if (event == null || event.selectedIndex < 0)
        return;
    var listIndex = event.options[event.selectedIndex].value;
    // If first item in the list not an actual selection.
    if (listIndex == "null")
        return;
        // Retrieve the lending rate programs offered by lending institution
    var lendingInstitutionName = event.options[event.selectedIndex].text;
    $("#RetrievingImg").removeClass("Hidden");
    proxy.GetALendingInstitutionsRates(lendingInstitutionName, ratesRetrieved,
serviceDefaultErrorHandler);
  }

  // dropdownlendingrates_onchange()
  // Event handler for changes with the selection drop down
  function dropdownlendingrates_onchange(event) {
    if (event == null || event.selectedIndex < 0)
        return;
    var listIndex = event.options[event.selectedIndex].value;
    // If first item in the list not an actual selection.
    if (listIndex == "null")
        return;
    // retrieve the lending rate programs offered by lending institution
    var lendingRateID = event.options[event.selectedIndex].value;
    proxy.GetASpecificLendingInstitutionsRate(lendingRateID, loadexcelwebpart,
serviceDefaultErrorHandler);
  }

  // serviceDefaultErrorHandler()
  // called when service returns an error
  function serviceDefaultErrorHandler(xhr, context, method)
  {
    alert(xhr.statusText);
    if (!$("#RetrievingImg").hasClass("Hidden"))
$("#RetrievingImg").addClass("Hidden");
  }

  function setFIRNamedRangeValue(asyncResult) {
    var range = asyncResult.getReturnValue();
    var valueArray = new Array(1);
    valueArray[0] = new Array(1);
    valueArray[0][0] = Rate * 100;
    range.setValuesAsync(valueArray);
  }

  function setLENDERNamedRangeValue(asyncResult) {
    var range = asyncResult.getReturnValue();
    var valueArray = new Array(1);
    valueArray[0] = new Array(1);
    valueArray[0][0] = LendingInstitution;
    range.setValuesAsync(valueArray);
  }

  function setINSTRUMENTNamedRangeValue(asyncResult) {
    var range = asyncResult.getReturnValue();
    var valueArray = new Array(1);
    valueArray[0] = new Array(1);
    valueArray[0][0] = Instrument;
    range.setValuesAsync(valueArray);
  }

  function setPOINTSNamedRangeValue(asyncResult) {
    var range = asyncResult.getReturnValue();
    var valueArray = new Array(1);
    valueArray[0] = new Array(1);
    valueArray[0][0] = Points;
    range.setValuesAsync(valueArray);
  }

  function setAPRNamedRangeValue(asyncResult) {
    var range = asyncResult.getReturnValue();
    var valueArray = new Array(1);
    valueArray[0] = new Array(1);
    valueArray[0][0] = APR * 100;
    range.setValuesAsync(valueArray);
  }

  function setLOCKNamedRangeValue(asyncResult) {
    var range = asyncResult.getReturnValue();
    var valueArray = new Array(1);
    valueArray[0] = new Array(1);
    valueArray[0][0] = Lock;
    range.setValuesAsync(valueArray);
  }

  </script>
</html>