[hpc4finance] r4 committed - check in Excel plugin source

2 views

Skip to first unread message

hpc4f...@googlecode.com

unread,

Jan 17, 2010, 4:20:15 AM1/17/10

to hpc4fin...@googlegroups.com

Revision: 4
Author: warunapww
Date: Sun Jan 17 01:18:44 2010
Log: check in Excel plugin source
http://code.google.com/p/hpc4finance/source/detail?r=4

Added:
/trunk/Excel_Plugin
/trunk/Excel_Plugin/README.txt
/trunk/Excel_Plugin/XClient
/trunk/Excel_Plugin/XClient/ClientEngine.cs
/trunk/Excel_Plugin/XClient/DataDBTableManager.cs
/trunk/Excel_Plugin/XClient/DataEntity.cs
/trunk/Excel_Plugin/XClient/DataFetcher.cs
/trunk/Excel_Plugin/XClient/DataWriter.cs
/trunk/Excel_Plugin/XClient/DatabaseSettingsForm.Designer.cs
/trunk/Excel_Plugin/XClient/DatabaseSettingsForm.cs
/trunk/Excel_Plugin/XClient/DatabaseSettingsForm.resx
/trunk/Excel_Plugin/XClient/Finance.Designer.cs
/trunk/Excel_Plugin/XClient/Finance.cs
/trunk/Excel_Plugin/XClient/Finance.resx
/trunk/Excel_Plugin/XClient/HPC4FinanceDBManager.cs
/trunk/Excel_Plugin/XClient/Properties
/trunk/Excel_Plugin/XClient/Properties/AssemblyInfo.cs
/trunk/Excel_Plugin/XClient/Properties/Resources.resx
/trunk/Excel_Plugin/XClient/Properties/Settings.settings
/trunk/Excel_Plugin/XClient/Ribbon.cs
/trunk/Excel_Plugin/XClient/Ribbon.xml
/trunk/Excel_Plugin/XClient/ServerSetingsForm.Designer.cs
/trunk/Excel_Plugin/XClient/ServerSetingsForm.cs
/trunk/Excel_Plugin/XClient/ServerSetingsForm.resx
/trunk/Excel_Plugin/XClient/SimulationSettings.Designer.cs
/trunk/Excel_Plugin/XClient/SimulationSettings.cs
/trunk/Excel_Plugin/XClient/SimulationSettings.resx
/trunk/Excel_Plugin/XClient/ThisAddIn.Designer.xml
/trunk/Excel_Plugin/XClient/ThisAddIn.cs
/trunk/Excel_Plugin/XClient/WSIRFetcher.cs
/trunk/Excel_Plugin/XClient/WSIRWriter.cs
/trunk/Excel_Plugin/XClient/WSSPFetcher.cs
/trunk/Excel_Plugin/XClient/WSSPWriter.cs
/trunk/Excel_Plugin/XClient/WSSettingsForm.Designer.cs
/trunk/Excel_Plugin/XClient/WSSettingsForm.cs
/trunk/Excel_Plugin/XClient/WSSettingsForm.resx
/trunk/Excel_Plugin/XClient/Web_References
/trunk/Excel_Plugin/XClient/Web_References/README.txt
/trunk/Excel_Plugin/XClient/Web_References/com.xignite
/trunk/Excel_Plugin/XClient/Web_References/com.xignite/Reference.map
/trunk/Excel_Plugin/XClient/Web_References/com.xignite/xRates.wsdl
/trunk/Excel_Plugin/XClient/Web_References/com.xignite.www
/trunk/Excel_Plugin/XClient/Web_References/com.xignite.www/Reference.map
/trunk/Excel_Plugin/XClient/Web_References/com.xignite.www/xHistorical.wsdl
/trunk/Excel_Plugin/XClient/XClient.csproj
/trunk/Excel_Plugin/XClient/XClient.csproj.user
/trunk/Excel_Plugin/XClient/app.config
/trunk/Excel_Plugin/XClient/uytuyu.cd

=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/README.txt Sun Jan 17 01:18:44 2010
@@ -0,0 +1,17 @@
+Installing From the source
+==========================
+
+
+
+This document describes the steps to be followed to deploy the HPC4Finance
client using Visual Studio 2005.
+
+1. Make sure that VSTO 2005 SE, Office Interop 2007 and MySQL Connector
for .Net 5.2.5 already installed in the destinated client machine. If not
install them before proceeding to the second step.
+
+2. Open the project using Visual Studio. Either project file or solution
file can be used to load the entire project into Visual Studio.
+
+3. Build Solution. (Short Key: F6)
+
+
+After successfully following above three steps, HPC4Finance Client will
automatically have been deployed.
+
+
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/ClientEngine.cs Sun Jan 17 01:18:44 2010
@@ -0,0 +1,133 @@
+/*
+ Copyright (c) 2008 by contributors:
+
+ * Damitha Premadasa
+ * Nilendra Weerasinghe
+ * Thilina Dampahala
+ * Waruna Ranasinghe - (http://warunapw.blogspot.com)
+
+ Licensed under the Apache License, Version 2.0 (the "License");
+ you may not use this file except in compliance with the License.
+ You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+*/
+
+using System;
+using System.Collections.Generic;
+using System.Text;
+using System.Net.Sockets;
+using System.Configuration;
+using XClient.Properties;
+
+
+class ClientEngine
+{
+ /// <summary>
+ /// Execute a job in the cluster
+ /// </summary>
+ /// <param name="args">Execution string to be passed to the
server</param>
+ /// <returns>String of results</returns>
+ public string ExecuteJob(string args)
+ {
+ String responseData = String.Empty;
+ try
+ {
+ Settings set = Settings.Default;
+ string mnIp = set.mnIP;
+ int port = Convert.ToInt32(set.mnServicePort);
+
+ TcpClient client = new TcpClient(mnIp, port);
+ Byte[] data = System.Text.Encoding.ASCII.GetBytes(args);
+
+ NetworkStream stream = client.GetStream();
+ stream.Write(data, 0, data.Length);
+ data = new Byte[1];
+
+ do
+ {
+ Int32 bytes = stream.Read(data, 0, data.Length);
+ responseData += System.Text.Encoding.ASCII.GetString(data,
0, bytes);
+ }
+ while (stream.DataAvailable);
+
+ stream.Close();
+ client.Close();
+ }
+ catch (Exception)
+ {
+ }
+ return responseData;
+ }
+
+ /// <summary>
+ /// Get a job ID from the server
+ /// </summary>
+ /// <returns>ticket</returns>
+ public string GetTicket()
+ {
+ string ticket = String.Empty;
+ string args = "ticket";
+ try
+ {
+ Settings set = Settings.Default;
+ string mnIp = set.mnIP;
+ int port = Convert.ToInt32(set.mnServicePort);
+
+ TcpClient client = new TcpClient(mnIp, port);
+ Byte[] data = System.Text.Encoding.ASCII.GetBytes(args);
+
+ NetworkStream stream = client.GetStream();
+ stream.Write(data, 0, data.Length);
+ data = new Byte[1];
+
+ do
+ {
+ Int32 bytes = stream.Read(data, 0, data.Length);
+ ticket += System.Text.Encoding.ASCII.GetString(data, 0,
bytes);
+ }
+ while (stream.DataAvailable);
+
+ stream.Close();
+ client.Close();
+ }
+ catch (Exception)
+ {
+ }
+ return ticket;
+ }
+
+ /// <summary>
+ /// Request to kill a Job
+ /// </summary>
+ /// <param name="args">request string</param>
+ public void KillJob(string args)
+ {
+ string ticket = String.Empty;
+ try
+ {
+ Settings set = Settings.Default;
+ string mnIp = set.mnIP;
+ int port = Convert.ToInt32(set.mnServicePort);
+
+ TcpClient client = new TcpClient(mnIp, port);
+ Byte[] data = System.Text.Encoding.ASCII.GetBytes(args);
+
+ NetworkStream stream = client.GetStream();
+ stream.Write(data, 0, data.Length);
+
+ stream.Close();
+ client.Close();
+ }
+ catch (Exception)
+ {
+ }
+ }
+}
+
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/DataDBTableManager.cs Sun Jan 17 01:18:44
2010
@@ -0,0 +1,120 @@
+/*
+ Copyright (c) 2008 by contributors:
+
+ * Damitha Premadasa
+ * Nilendra Weerasinghe
+ * Thilina Dampahala
+ * Waruna Ranasinghe - (http://warunapw.blogspot.com)
+
+ Licensed under the Apache License, Version 2.0 (the "License");
+ you may not use this file except in compliance with the License.
+ You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+*/
+
+using System;
+using System.Collections.Generic;
+using System.Text;
+using System.Data;
+using MySql.Data.MySqlClient;
+using System.Configuration;
+using XClient.Properties;
+
+class DataDBTableManager
+{
+ Settings set = Settings.Default;
+
+ /// <summary>
+ /// Return all tables in the database
+ /// </summary>
+ /// <returns>List of strings</returns>
+ public List<string> GetAllTables()
+ {
+ DataTable tables = null;
+ List<string> tableList = new List<string>();
+ DataTableReader r = null;
+ MySqlConnection connection = new
MySqlConnection(set.dataConnectionString);
+
+
+ try
+ {
+ connection.Open();
+ tables = connection.GetSchema("Tables");
+ r = tables.CreateDataReader();
+
+ while (r.Read())
+ {
+ tableList.Add(r[2].ToString());
+ }
+ r.Close();
+ }
+ catch (Exception)
+ {
+ }
+ finally
+ {
+ connection.Close();
+
+ }
+ return tableList;
+ }
+
+
+ /// <summary>
+ /// Create a new data table
+ /// </summary>
+ /// <param name="tableName">Table name</param>
+ public void CreateTable(string tableName)
+ {
+ MySqlConnection connection = new
MySqlConnection(set.dataConnectionString);
+ try
+ {
+ string createQuery = "CREATE TABLE IF NOT EXISTS " +
tableName.ToLower() + " (ID INT UNSIGNED AUTO_INCREMENT, Date Date, Value
Double, PRIMARY KEY(ID))";
+ MySqlCommand createCommand = new MySqlCommand(createQuery);
+ createCommand.Connection = connection;
+ connection.Open();
+ createCommand.ExecuteNonQuery();
+ }
+ catch (Exception ex)
+ {
+ throw ex;
+ }
+ finally
+ {
+ connection.Close();
+ }
+ }
+
+ /// <summary>
+ /// Delete a table from the database
+ /// </summary>
+ /// <param name="tableName">Table Name</param>
+ public void DeleteTable(string tableName)
+ {
+ MySqlConnection connection = new
MySqlConnection(set.dataConnectionString);
+ try
+ {
+ string deleteQuery = "DROP TABLE " + tableName.ToLower();
+ MySqlCommand deleteCommand = new MySqlCommand(deleteQuery);
+ deleteCommand.Connection = connection;
+ connection.Open();
+ deleteCommand.ExecuteNonQuery();
+ }
+ catch (Exception ex)
+ {
+ throw ex;
+ }
+ finally
+ {
+ connection.Close();
+ }
+ }
+}
+
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/DataEntity.cs Sun Jan 17 01:18:44 2010
@@ -0,0 +1,46 @@
+/*
+ Copyright (c) 2008 by contributors:
+
+ * Damitha Premadasa
+ * Nilendra Weerasinghe
+ * Thilina Dampahala
+ * Waruna Ranasinghe - (http://warunapw.blogspot.com)
+
+ Licensed under the Apache License, Version 2.0 (the "License");
+ you may not use this file except in compliance with the License.
+ You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+*/
+
+using System;
+using System.Collections.Generic;
+using System.Text;
+
+class DataEntity
+{
+ //Private variables
+ private string date = null;
+ private string value = "0";
+
+ //Properties
+ public string Date
+ {
+ get { return date; }
+ set { date = value; }
+ }
+
+ public string Value
+ {
+ get { return value; }
+ set { this.value = value; }
+ }
+
+}
+
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/DataFetcher.cs Sun Jan 17 01:18:44 2010
@@ -0,0 +1,68 @@
+/*
+ Copyright (c) 2008 by contributors:
+
+ * Damitha Premadasa
+ * Nilendra Weerasinghe
+ * Thilina Dampahala
+ * Waruna Ranasinghe - (http://warunapw.blogspot.com)
+
+ Licensed under the Apache License, Version 2.0 (the "License");
+ you may not use this file except in compliance with the License.
+ You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+*/
+
+using System;
+using System.Collections.Generic;
+using System.Text;
+using System.IO;
+
+
+class DataFetcher
+{
+ /// <summary>
+ /// Get data entity list from .csv file
+ /// </summary>
+ /// <param name="dataFile">.CSV file</param>
+ /// <returns>DataEntity list</returns>
+ public List<DataEntity> GetDataEntityList(string dataFile)
+ {
+ List<DataEntity> entityList = new List<DataEntity>();
+ try
+ {
+ using (StreamReader sr = new StreamReader(dataFile))
+ {
+ string line;
+ while ((line = sr.ReadLine()) != null)
+ {
+ string[] split = line.Split(new string[]
{ ",", ",,", ",,,", ",,,," }, StringSplitOptions.RemoveEmptyEntries);
+ DataEntity entity = new DataEntity();
+ try
+ {
+ DateTime dt = Convert.ToDateTime(split[0]); //Date
parser
+
+ entity.Date = dt.Year.ToString() + "-" +
dt.Month.ToString() + "-" + dt.Day.ToString();
+ entity.Value = split[1];
+ entityList.Add(entity);
+ }
+ catch (Exception)
+ {
+ }
+ }
+ }
+ }
+ catch (Exception ex)
+ {
+ throw ex;
+ }
+ return entityList;
+ }
+}
+
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/DataWriter.cs Sun Jan 17 01:18:44 2010
@@ -0,0 +1,128 @@
+/*
+ Copyright (c) 2008 by contributors:
+
+ * Damitha Premadasa
+ * Nilendra Weerasinghe
+ * Thilina Dampahala
+ * Waruna Ranasinghe - (http://warunapw.blogspot.com)
+
+ Licensed under the Apache License, Version 2.0 (the "License");
+ you may not use this file except in compliance with the License.
+ You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+*/
+
+using System;
+using System.Collections.Generic;
+using System.Text;
+using MySql.Data.MySqlClient;
+using XClient.Properties;
+
+
+class DataWriter
+{
+ Settings set = Settings.Default;
+
+ /// <summary>
+ /// Committing Data To Database
+ /// </summary>
+ /// <param name="entityList">Entity List</param>
+ /// <param name="tableName">Table Name</param>
+ public void WriteData(List<DataEntity> entityList, string tableName)
+ {
+ MySqlConnection connection = new
MySqlConnection(set.dataConnectionString);
+ try
+ {
+ entityList = GetUpdateList(entityList, tableName);
+ connection.Open();
+ foreach (DataEntity i in entityList)
+ {
+ string queryString = "INSERT INTO " + tableName.ToLower()
+ "(Date, Value) VALUES ('" + i.Date + "','" + i.Value + "')";
+ MySqlCommand command = new MySqlCommand(queryString);
+ command.Connection = connection;
+ command.ExecuteNonQuery();
+ }
+ }
+ catch (Exception ex)
+ {
+ throw ex;
+ }
+ finally
+ {
+ connection.Close();
+ }
+
+ }
+
+ /// <summary>
+ /// Get the list of items to be appended
+ /// </summary>
+ /// <param name="entityList">Entity list</param>
+ /// <param name="tableName">Table mane</param>
+ /// <returns>Entity list</returns>
+ private List<DataEntity> GetUpdateList(List<DataEntity> entityList,
string tableName)
+ {
+ DateTime dt = DateTime.MinValue;
+ List<DataEntity> localList = new List<DataEntity>();
+
+
+ MySqlConnection connection = new
MySqlConnection(set.dataConnectionString);
+ try
+ {
+ localList.AddRange(entityList);
+ connection.Open();
+ string queryString = "SELECT MAX(DATE) FROM " +
tableName.ToLower();
+ MySqlCommand countCommand = new MySqlCommand(queryString);
+ countCommand.Connection = connection;
+ object o = countCommand.ExecuteScalar();
+
+ try
+ {
+ dt = Convert.ToDateTime(o);
+ }
+ catch (Exception)
+ {
+ //do nothing
+ }
+ foreach (DataEntity s in entityList)
+ {
+ if (Convert.ToDateTime(s.Date) <= dt)
+ {
+ localList.Remove(s);
+ }
+ }
+ }
+ catch (Exception ex)
+ {
+ throw ex;
+ }
+ finally
+ {
+ connection.Close();
+ }
+
+ if (localList.Count > 1)
+ {
+ try
+ {
+ DateTime d1 = Convert.ToDateTime(localList[0].Date);
+ DateTime d2 = Convert.ToDateTime(localList[localList.Count
- 1].Date);
+ if (d1 >= d2)
+ {
+ localList.Reverse();
+ }
+ }
+ catch { }
+ }
+
+ return localList;
+ }
+}
+
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/DatabaseSettingsForm.Designer.cs Sun Jan 17
01:18:44 2010
@@ -0,0 +1,146 @@
+/*
+ Copyright (c) 2008 by contributors:
+
+ * Damitha Premadasa
+ * Nilendra Weerasinghe
+ * Thilina Dampahala
+ * Waruna Ranasinghe - (http://warunapw.blogspot.com)
+
+ Licensed under the Apache License, Version 2.0 (the "License");
+ you may not use this file except in compliance with the License.
+ You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+*/
+
+namespace XClient
+{
+ partial class DatabaseSettingsForm
+ {
+ /// <summary>
+ /// Required designer variable.
+ /// </summary>
+ private System.ComponentModel.IContainer components = null;
+
+ /// <summary>
+ /// Clean up any resources being used.
+ /// </summary>
+ /// <param name="disposing">true if managed resources should be
disposed; otherwise, false.</param>
+ protected override void Dispose(bool disposing)
+ {
+ if (disposing && (components != null))
+ {
+ components.Dispose();
+ }
+ base.Dispose(disposing);
+ }
+
+ #region Windows Form Designer generated code
+
+ /// <summary>
+ /// Required method for Designer support - do not modify
+ /// the contents of this method with the code editor.
+ /// </summary>
+ private void InitializeComponent()
+ {
+ this.label1 = new System.Windows.Forms.Label();
+ this.label3 = new System.Windows.Forms.Label();
+ this.textBox1 = new System.Windows.Forms.TextBox();
+ this.textBox2 = new System.Windows.Forms.TextBox();
+ this.button1 = new System.Windows.Forms.Button();
+ this.label2 = new System.Windows.Forms.Label();
+ this.SuspendLayout();
+ //
+ // label1
+ //
+ this.label1.AutoSize = true;
+ this.label1.Location = new System.Drawing.Point(13, 13);
+ this.label1.Name = "label1";
+ this.label1.Size = new System.Drawing.Size(192, 13);
+ this.label1.TabIndex = 0;
+ this.label1.Text = "Processes Database Connection String";
+ //
+ // label3
+ //
+ this.label3.AutoSize = true;
+ this.label3.Location = new System.Drawing.Point(13, 66);
+ this.label3.Name = "label3";
+ this.label3.Size = new System.Drawing.Size(186, 13);
+ this.label3.TabIndex = 2;
+ this.label3.Text = "Historical Database Connection String";
+ //
+ // textBox1
+ //
+ this.textBox1.Location = new System.Drawing.Point(16, 30);
+ this.textBox1.Name = "textBox1";
+ this.textBox1.Size = new System.Drawing.Size(256, 20);
+ this.textBox1.TabIndex = 3;
+ //
+ // textBox2
+ //
+ this.textBox2.Location = new System.Drawing.Point(16, 83);
+ this.textBox2.Name = "textBox2";
+ this.textBox2.Size = new System.Drawing.Size(256, 20);
+ this.textBox2.TabIndex = 5;
+ //
+ // button1
+ //
+ this.button1.Location = new System.Drawing.Point(197, 141);
+ this.button1.Name = "button1";
+ this.button1.Size = new System.Drawing.Size(75, 23);
+ this.button1.TabIndex = 6;
+ this.button1.Text = "Save";
+ this.button1.UseVisualStyleBackColor = true;
+ this.button1.Click += new
System.EventHandler(this.button1_Click);
+ //
+ // label2
+ //
+ this.label2.AutoSize = true;
+ this.label2.Location = new System.Drawing.Point(16, 110);
+ this.label2.Name = "label2";
+ this.label2.Size = new System.Drawing.Size(253, 26);
+ this.label2.TabIndex = 7;
+ this.label2.Text = "You have to restart Excel for these
changes to take \r\neffect.";
+ //
+ // DatabaseSettingsForm
+ //
+ this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
+ this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
+ this.ClientSize = new System.Drawing.Size(284, 176);
+ this.Controls.Add(this.label2);
+ this.Controls.Add(this.button1);
+ this.Controls.Add(this.textBox2);
+ this.Controls.Add(this.textBox1);
+ this.Controls.Add(this.label3);
+ this.Controls.Add(this.label1);
+ this.Cursor = System.Windows.Forms.Cursors.Default;
+ this.FormBorderStyle =
System.Windows.Forms.FormBorderStyle.FixedDialog;
+ this.MaximizeBox = false;
+ this.MinimizeBox = false;
+ this.Name = "DatabaseSettingsForm";
+ this.ShowInTaskbar = false;
+ this.StartPosition =
System.Windows.Forms.FormStartPosition.CenterScreen;
+ this.Text = "Database Settings";
+ this.TopMost = true;
+ this.Load += new
System.EventHandler(this.DatabaseSettingsForm_Load);
+ this.ResumeLayout(false);
+ this.PerformLayout();
+
+ }
+
+ #endregion
+
+ private System.Windows.Forms.Label label1;
+ private System.Windows.Forms.Label label3;
+ private System.Windows.Forms.TextBox textBox1;
+ private System.Windows.Forms.TextBox textBox2;
+ private System.Windows.Forms.Button button1;
+ private System.Windows.Forms.Label label2;
+ }
+}
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/DatabaseSettingsForm.cs Sun Jan 17 01:18:44
2010
@@ -0,0 +1,61 @@
+using System;
+using System.Collections.Generic;
+using System.ComponentModel;
+using System.Data;
+using System.Drawing;
+using System.Text;
+using System.Windows.Forms;
+using System.Configuration;
+using XClient.Properties;
+
+namespace XClient
+{
+ public partial class DatabaseSettingsForm : Form
+ {
+ public DatabaseSettingsForm()
+ {
+ InitializeComponent();
+ }
+
+ /// <summary>
+ /// Event Form_Load
+ /// </summary>
+ /// <param name="sender">sender</param>
+ /// <param name="e">Event argument</param>
+ private void DatabaseSettingsForm_Load(object sender, EventArgs e)
+ {
+ try
+ {
+ Settings set = Settings.Default;
+ textBox1.Text = set.mnConnectionString;
+ textBox2.Text = set.dataConnectionString;
+ }
+ catch (Exception)
+ {
+ }
+ }
+
+ /// <summary>
+ /// Event button1_Click
+ /// </summary>
+ /// <param name="sender">sender</param>
+ /// <param name="e">event argument</param>
+ private void button1_Click(object sender, EventArgs e)
+ {
+ try
+ {
+ Settings set = Settings.Default;
+ set.mnConnectionString = textBox1.Text;
+ set.dataConnectionString = textBox2.Text;
+ set.Save();
+
+ this.Close();
+ }
+ catch (Exception)
+ {
+ }
+ }
+
+
+ }
+}
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/DatabaseSettingsForm.resx Sun Jan 17
01:18:44 2010
@@ -0,0 +1,120 @@
+<?xml version="1.0" encoding="utf-8"?>
+<root>
+ 
+ <xsd:schema id="root" xmlns=""
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
+ <xsd:import namespace="http://www.w3.org/XML/1998/namespace" />
+ <xsd:element name="root" msdata:IsDataSet="true">
+ <xsd:complexType>
+ <xsd:choice maxOccurs="unbounded">
+ <xsd:element name="metadata">
+ <xsd:complexType>
+ <xsd:sequence>
+ <xsd:element name="value" type="xsd:string" minOccurs="0"
/>
+ </xsd:sequence>
+ <xsd:attribute name="name" use="required" type="xsd:string"
/>
+ <xsd:attribute name="type" type="xsd:string" />
+ <xsd:attribute name="mimetype" type="xsd:string" />
+ <xsd:attribute ref="xml:space" />
+ </xsd:complexType>
+ </xsd:element>
+ <xsd:element name="assembly">
+ <xsd:complexType>
+ <xsd:attribute name="alias" type="xsd:string" />
+ <xsd:attribute name="name" type="xsd:string" />
+ </xsd:complexType>
+ </xsd:element>
+ <xsd:element name="data">
+ <xsd:complexType>
+ <xsd:sequence>
+ <xsd:element name="value" type="xsd:string" minOccurs="0"
msdata:Ordinal="1" />
+ <xsd:element name="comment" type="xsd:string"
minOccurs="0" msdata:Ordinal="2" />
+ </xsd:sequence>
+ <xsd:attribute name="name" type="xsd:string" use="required"
msdata:Ordinal="1" />
+ <xsd:attribute name="type" type="xsd:string"
msdata:Ordinal="3" />
+ <xsd:attribute name="mimetype" type="xsd:string"
msdata:Ordinal="4" />
+ <xsd:attribute ref="xml:space" />
+ </xsd:complexType>
+ </xsd:element>
+ <xsd:element name="resheader">
+ <xsd:complexType>
+ <xsd:sequence>
+ <xsd:element name="value" type="xsd:string" minOccurs="0"
msdata:Ordinal="1" />
+ </xsd:sequence>
+ <xsd:attribute name="name" type="xsd:string" use="required"
/>
+ </xsd:complexType>
+ </xsd:element>
+ </xsd:choice>
+ </xsd:complexType>
+ </xsd:element>
+ </xsd:schema>
+ <resheader name="resmimetype">
+ <value>text/microsoft-resx</value>
+ </resheader>
+ <resheader name="version">
+ <value>2.0</value>
+ </resheader>
+ <resheader name="reader">
+ <value>System.Resources.ResXResourceReader, System.Windows.Forms,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
+ </resheader>
+ <resheader name="writer">
+ <value>System.Resources.ResXResourceWriter, System.Windows.Forms,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
+ </resheader>
+</root>
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/Finance.Designer.cs Sun Jan 17 01:18:44 2010
@@ -0,0 +1,929 @@
+/*
+ Copyright (c) 2008 by contributors:
+
+ * Damitha Premadasa
+ * Nilendra Weerasinghe
+ * Thilina Dampahala
+ * Waruna Ranasinghe - (http://warunapw.blogspot.com)
+
+ Licensed under the Apache License, Version 2.0 (the "License");
+ you may not use this file except in compliance with the License.
+ You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+*/
+
+namespace XClient
+{
+ partial class Finance
+ {
+ /// <summary>
+ /// Required designer variable.
+ /// </summary>
+ private System.ComponentModel.IContainer components = null;
+
+ /// <summary>
+ /// Clean up any resources being used.
+ /// </summary>
+ /// <param name="disposing">true if managed resources should be
disposed; otherwise, false.</param>
+ protected override void Dispose(bool disposing)
+ {
+ if (disposing && (components != null))
+ {
+ components.Dispose();
+ }
+ base.Dispose(disposing);
+ }
+
+ #region Component Designer generated code
+
+ /// <summary>
+ /// Required method for Designer support - do not modify
+ /// the contents of this method with the code editor.
+ /// </summary>
+ private void InitializeComponent()
+ {
+ this.openFileDialog = new
System.Windows.Forms.OpenFileDialog();
+ this.tabWindow = new System.Windows.Forms.TabControl();
+ this.tabForecast = new System.Windows.Forms.TabPage();
+ this.groupBox8 = new System.Windows.Forms.GroupBox();
+ this.periodTypeComboBox2 = new System.Windows.Forms.ComboBox();
+ this.label10 = new System.Windows.Forms.Label();
+ this.periodTextBox = new System.Windows.Forms.TextBox();
+ this.periodTypeComboBox = new System.Windows.Forms.ComboBox();
+ this.label5 = new System.Windows.Forms.Label();
+ this.executeButton = new System.Windows.Forms.Button();
+ this.groupBox3 = new System.Windows.Forms.GroupBox();
+ this.paraFormatTextBox = new System.Windows.Forms.TextBox();
+ this.groupBox2 = new System.Windows.Forms.GroupBox();
+ this.usingParaRadioButton = new
System.Windows.Forms.RadioButton();
+ this.panel1 = new System.Windows.Forms.Panel();
+ this.label3 = new System.Windows.Forms.Label();
+ this.tablesComboBox = new System.Windows.Forms.ComboBox();
+ this.panel2 = new System.Windows.Forms.Panel();
+ this.label2 = new System.Windows.Forms.Label();
+ this.paraTextBox = new System.Windows.Forms.TextBox();
+ this.usingDataRadioButton = new
System.Windows.Forms.RadioButton();
+ this.groupBox1 = new System.Windows.Forms.GroupBox();
+ this.label1 = new System.Windows.Forms.Label();
+ this.modelComboBox = new System.Windows.Forms.ComboBox();
+ this.tabData = new System.Windows.Forms.TabPage();
+ this.groupBox7 = new System.Windows.Forms.GroupBox();
+ this.tableNameTextBox = new System.Windows.Forms.TextBox();
+ this.label12 = new System.Windows.Forms.Label();
+ this.addButton = new System.Windows.Forms.Button();
+ this.groupBox6 = new System.Windows.Forms.GroupBox();
+ this.wsPanel = new System.Windows.Forms.Panel();
+ this.identifier = new System.Windows.Forms.TextBox();
+ this.quotesRadioButton = new
System.Windows.Forms.RadioButton();
+ this.ratesRadioButton = new System.Windows.Forms.RadioButton();
+ this.rateTypesComboBox = new System.Windows.Forms.ComboBox();
+ this.toDate = new System.Windows.Forms.DateTimePicker();
+ this.fromDate = new System.Windows.Forms.DateTimePicker();
+ this.label15 = new System.Windows.Forms.Label();
+ this.label18 = new System.Windows.Forms.Label();
+ this.webServiceRadioButton = new
System.Windows.Forms.RadioButton();
+ this.infileRadioButton = new
System.Windows.Forms.RadioButton();
+ this.filePanel = new System.Windows.Forms.Panel();
+ this.label20 = new System.Windows.Forms.Label();
+ this.irBrowseButton = new System.Windows.Forms.Button();
+ this.filePathTextBox = new System.Windows.Forms.TextBox();
+ this.updateButton = new System.Windows.Forms.Button();
+ this.deleteButton = new System.Windows.Forms.Button();
+ this.tablsComboBox = new System.Windows.Forms.ComboBox();
+ this.label11 = new System.Windows.Forms.Label();
+ this.tabPage1 = new System.Windows.Forms.TabPage();
+ this.groupBox4 = new System.Windows.Forms.GroupBox();
+ this.endJobButton = new System.Windows.Forms.Button();
+ this.listView1 = new System.Windows.Forms.ListView();
+ this.columnHeader1 = new System.Windows.Forms.ColumnHeader();
+ this.columnHeader2 = new System.Windows.Forms.ColumnHeader();
+ this.columnHeader3 = new System.Windows.Forms.ColumnHeader();
+ this.columnHeader4 = new System.Windows.Forms.ColumnHeader();
+ this.columnHeader5 = new System.Windows.Forms.ColumnHeader();
+ this.columnHeader6 = new System.Windows.Forms.ColumnHeader();
+ this.columnHeader7 = new System.Windows.Forms.ColumnHeader();
+ this.button1 = new System.Windows.Forms.Button();
+ this.button2 = new System.Windows.Forms.Button();
+ this.comboBox2 = new System.Windows.Forms.ComboBox();
+ this.textBox2 = new System.Windows.Forms.TextBox();
+ this.label8 = new System.Windows.Forms.Label();
+ this.button3 = new System.Windows.Forms.Button();
+ this.label9 = new System.Windows.Forms.Label();
+ this.tabWindow.SuspendLayout();
+ this.tabForecast.SuspendLayout();
+ this.groupBox8.SuspendLayout();
+ this.groupBox3.SuspendLayout();
+ this.groupBox2.SuspendLayout();
+ this.panel1.SuspendLayout();
+ this.panel2.SuspendLayout();
+ this.groupBox1.SuspendLayout();
+ this.tabData.SuspendLayout();
+ this.groupBox7.SuspendLayout();
+ this.groupBox6.SuspendLayout();
+ this.wsPanel.SuspendLayout();
+ this.filePanel.SuspendLayout();
+ this.tabPage1.SuspendLayout();
+ this.groupBox4.SuspendLayout();
+ this.SuspendLayout();
+ //
+ // openFileDialog
+ //
+ this.openFileDialog.DefaultExt = "csv";
+ this.openFileDialog.Filter = "CSV files | *.csv";
+ this.openFileDialog.FileOk += new
System.ComponentModel.CancelEventHandler(this.openFileDialog_FileOk);
+ //
+ // tabWindow
+ //
+ this.tabWindow.Controls.Add(this.tabForecast);
+ this.tabWindow.Controls.Add(this.tabData);
+ this.tabWindow.Controls.Add(this.tabPage1);
+ this.tabWindow.Dock = System.Windows.Forms.DockStyle.Fill;
+ this.tabWindow.ImeMode =
System.Windows.Forms.ImeMode.NoControl;
+ this.tabWindow.Location = new System.Drawing.Point(0, 0);
+ this.tabWindow.Name = "tabWindow";
+ this.tabWindow.SelectedIndex = 0;
+ this.tabWindow.Size = new System.Drawing.Size(175, 530);
+ this.tabWindow.TabIndex = 32;
+ //
+ // tabForecast
+ //
+ this.tabForecast.BackColor = System.Drawing.Color.AliceBlue;
+ this.tabForecast.Controls.Add(this.groupBox8);
+ this.tabForecast.Controls.Add(this.executeButton);
+ this.tabForecast.Controls.Add(this.groupBox3);
+ this.tabForecast.Controls.Add(this.groupBox2);
+ this.tabForecast.Controls.Add(this.groupBox1);
+ this.tabForecast.ForeColor = System.Drawing.Color.DarkBlue;
+ this.tabForecast.Location = new System.Drawing.Point(4, 22);
+ this.tabForecast.Name = "tabForecast";
+ this.tabForecast.Padding = new System.Windows.Forms.Padding(3);
+ this.tabForecast.Size = new System.Drawing.Size(167, 504);
+ this.tabForecast.TabIndex = 0;
+ this.tabForecast.Text = "Forecast";
+ this.tabForecast.UseVisualStyleBackColor = true;
+ //
+ // groupBox8
+ //
+ this.groupBox8.Controls.Add(this.periodTypeComboBox2);
+ this.groupBox8.Controls.Add(this.label10);
+ this.groupBox8.Controls.Add(this.periodTextBox);
+ this.groupBox8.Controls.Add(this.periodTypeComboBox);
+ this.groupBox8.Controls.Add(this.label5);
+ this.groupBox8.Location = new System.Drawing.Point(-1, 281);
+ this.groupBox8.Name = "groupBox8";
+ this.groupBox8.Size = new System.Drawing.Size(168, 75);
+ this.groupBox8.TabIndex = 37;
+ this.groupBox8.TabStop = false;
+ this.groupBox8.Text = "Forecasts";
+ //
+ // periodTypeComboBox2
+ //
+ this.periodTypeComboBox2.DropDownStyle =
System.Windows.Forms.ComboBoxStyle.DropDownList;
+ this.periodTypeComboBox2.FormattingEnabled = true;
+ this.periodTypeComboBox2.Items.AddRange(new object[] {
+ "daily",
+ "monthly",
+ "quarterly",
+ "yearly"});
+ this.periodTypeComboBox2.Location = new
System.Drawing.Point(85, 41);
+ this.periodTypeComboBox2.Name = "periodTypeComboBox2";
+ this.periodTypeComboBox2.Size = new System.Drawing.Size(75,
21);
+ this.periodTypeComboBox2.TabIndex = 29;
+ //
+ // label10
+ //
+ this.label10.AutoSize = true;
+ this.label10.Location = new System.Drawing.Point(4, 45);
+ this.label10.Name = "label10";
+ this.label10.Size = new System.Drawing.Size(42, 13);
+ this.label10.TabIndex = 28;
+ this.label10.Text = "Periods";
+ //
+ // periodTextBox
+ //
+ this.periodTextBox.Location = new System.Drawing.Point(47, 42);
+ this.periodTextBox.Name = "periodTextBox";
+ this.periodTextBox.Size = new System.Drawing.Size(34, 20);
+ this.periodTextBox.TabIndex = 27;
+ this.periodTextBox.TabStop = false;
+ //
+ // periodTypeComboBox
+ //
+ this.periodTypeComboBox.DropDownStyle =
System.Windows.Forms.ComboBoxStyle.DropDownList;
+ this.periodTypeComboBox.FormattingEnabled = true;
+ this.periodTypeComboBox.Location = new
System.Drawing.Point(85, 15);
+ this.periodTypeComboBox.Name = "periodTypeComboBox";
+ this.periodTypeComboBox.Size = new System.Drawing.Size(75, 21);
+ this.periodTypeComboBox.TabIndex = 26;
+ this.periodTypeComboBox.TabStop = false;
+ //
+ // label5
+ //
+ this.label5.AutoSize = true;
+ this.label5.Location = new System.Drawing.Point(4, 18);
+ this.label5.Name = "label5";
+ this.label5.Size = new System.Drawing.Size(55, 13);
+ this.label5.TabIndex = 25;
+ this.label5.Text = "Time Step";
+ //
+ // executeButton
+ //
+ this.executeButton.Location = new System.Drawing.Point(84,
369);
+ this.executeButton.Name = "executeButton";
+ this.executeButton.Size = new System.Drawing.Size(75, 23);
+ this.executeButton.TabIndex = 36;
+ this.executeButton.TabStop = false;
+ this.executeButton.Text = "Execute";
+ this.executeButton.UseVisualStyleBackColor = true;
+ this.executeButton.Click += new
System.EventHandler(this.executeButton_Click);
+ //
+ // groupBox3
+ //
+ this.groupBox3.Controls.Add(this.paraFormatTextBox);
+ this.groupBox3.Location = new System.Drawing.Point(3, 405);
+ this.groupBox3.Name = "groupBox3";
+ this.groupBox3.Size = new System.Drawing.Size(168, 93);
+ this.groupBox3.TabIndex = 34;
+ this.groupBox3.TabStop = false;
+ this.groupBox3.Text = "Parameter Format";
+ //
+ // paraFormatTextBox
+ //
+ this.paraFormatTextBox.Location = new System.Drawing.Point(9,
19);
+ this.paraFormatTextBox.Multiline = true;
+ this.paraFormatTextBox.Name = "paraFormatTextBox";
+ this.paraFormatTextBox.ReadOnly = true;
+ this.paraFormatTextBox.Size = new System.Drawing.Size(150, 55);
+ this.paraFormatTextBox.TabIndex = 100;
+ this.paraFormatTextBox.TabStop = false;
+ //
+ // groupBox2
+ //
+ this.groupBox2.Controls.Add(this.usingParaRadioButton);
+ this.groupBox2.Controls.Add(this.panel1);
+ this.groupBox2.Controls.Add(this.panel2);
+ this.groupBox2.Controls.Add(this.usingDataRadioButton);
+ this.groupBox2.Location = new System.Drawing.Point(0, 94);
+ this.groupBox2.Name = "groupBox2";
+ this.groupBox2.Size = new System.Drawing.Size(168, 178);
+ this.groupBox2.TabIndex = 33;
+ this.groupBox2.TabStop = false;
+ this.groupBox2.Text = "Parameters";
+ //
+ // usingParaRadioButton
+ //
+ this.usingParaRadioButton.AutoSize = true;
+ this.usingParaRadioButton.BackColor =
System.Drawing.Color.Transparent;
+ this.usingParaRadioButton.Checked = true;
+ this.usingParaRadioButton.Location = new
System.Drawing.Point(5, 13);
+ this.usingParaRadioButton.Name = "usingParaRadioButton";
+ this.usingParaRadioButton.Size = new System.Drawing.Size(108,
17);
+ this.usingParaRadioButton.TabIndex = 2;
+ this.usingParaRadioButton.TabStop = true;
+ this.usingParaRadioButton.Text = "Using Parameters";
+ this.usingParaRadioButton.UseVisualStyleBackColor = false;
+ this.usingParaRadioButton.CheckedChanged += new
System.EventHandler(this.usingParaRadioButton_CheckedChanged);
+ //
+ // panel1
+ //
+ this.panel1.BackColor = System.Drawing.Color.Transparent;
+ this.panel1.Controls.Add(this.label3);
+ this.panel1.Controls.Add(this.tablesComboBox);
+ this.panel1.Enabled = false;
+ this.panel1.Location = new System.Drawing.Point(20, 107);
+ this.panel1.Name = "panel1";
+ this.panel1.Size = new System.Drawing.Size(142, 59);
+ this.panel1.TabIndex = 33;
+ //
+ // label3
+ //
+ this.label3.AutoSize = true;
+ this.label3.Location = new System.Drawing.Point(4, 9);
+ this.label3.Name = "label3";
+ this.label3.Size = new System.Drawing.Size(100, 13);
+ this.label3.TabIndex = 24;
+ this.label3.Text = "Select Data Source";
+ //
+ // tablesComboBox
+ //
+ this.tablesComboBox.DropDownStyle =
System.Windows.Forms.ComboBoxStyle.DropDownList;
+ this.tablesComboBox.FormattingEnabled = true;
+ this.tablesComboBox.Location = new System.Drawing.Point(7, 29);
+ this.tablesComboBox.Name = "tablesComboBox";
+ this.tablesComboBox.Size = new System.Drawing.Size(132, 21);
+ this.tablesComboBox.TabIndex = 5;
+ this.tablesComboBox.TabStop = false;
+ //
+ // panel2
+ //
+ this.panel2.BackColor = System.Drawing.Color.Transparent;
+ this.panel2.Controls.Add(this.label2);
+ this.panel2.Controls.Add(this.paraTextBox);
+ this.panel2.Location = new System.Drawing.Point(20, 36);
+ this.panel2.Name = "panel2";
+ this.panel2.Size = new System.Drawing.Size(142, 43);
+ this.panel2.TabIndex = 32;
+ //
+ // label2
+ //
+ this.label2.AutoSize = true;
+ this.label2.Location = new System.Drawing.Point(3, 0);
+ this.label2.Name = "label2";
+ this.label2.Size = new System.Drawing.Size(125, 13);
+ this.label2.TabIndex = 23;
+ this.label2.Text = "Space Seperated Values";
+ //
+ // paraTextBox
+ //
+ this.paraTextBox.Location = new System.Drawing.Point(7, 19);
+ this.paraTextBox.Name = "paraTextBox";
+ this.paraTextBox.Size = new System.Drawing.Size(132, 20);
+ this.paraTextBox.TabIndex = 3;
+ this.paraTextBox.TabStop = false;
+ //
+ // usingDataRadioButton
+ //
+ this.usingDataRadioButton.AutoSize = true;
+ this.usingDataRadioButton.BackColor =
System.Drawing.Color.Transparent;
+ this.usingDataRadioButton.Location = new
System.Drawing.Point(5, 86);
+ this.usingDataRadioButton.Name = "usingDataRadioButton";
+ this.usingDataRadioButton.Size = new System.Drawing.Size(124,
17);
+ this.usingDataRadioButton.TabIndex = 4;
+ this.usingDataRadioButton.Text = "Using Historical Data";
+ this.usingDataRadioButton.UseVisualStyleBackColor = false;
+ this.usingDataRadioButton.CheckedChanged += new
System.EventHandler(this.usingDataRadioButton_CheckedChanged);
+ //
+ // groupBox1
+ //
+ this.groupBox1.Controls.Add(this.label1);
+ this.groupBox1.Controls.Add(this.modelComboBox);
+ this.groupBox1.Location = new System.Drawing.Point(3, 3);
+ this.groupBox1.Name = "groupBox1";
+ this.groupBox1.Size = new System.Drawing.Size(165, 82);
+ this.groupBox1.TabIndex = 32;
+ this.groupBox1.TabStop = false;
+ this.groupBox1.Text = "Model ";
+ //
+ // label1
+ //
+ this.label1.AutoSize = true;
+ this.label1.BackColor = System.Drawing.Color.Transparent;
+ this.label1.Location = new System.Drawing.Point(6, 23);
+ this.label1.Name = "label1";
+ this.label1.Size = new System.Drawing.Size(69, 13);
+ this.label1.TabIndex = 30;
+ this.label1.Text = "Select Model";
+ //
+ // modelComboBox
+ //
+ this.modelComboBox.DropDownStyle =
System.Windows.Forms.ComboBoxStyle.DropDownList;
+ this.modelComboBox.FormattingEnabled = true;
+ this.modelComboBox.Location = new System.Drawing.Point(9, 43);
+ this.modelComboBox.Name = "modelComboBox";
+ this.modelComboBox.Size = new System.Drawing.Size(150, 21);
+ this.modelComboBox.TabIndex = 1;
+ this.modelComboBox.TabStop = false;
+ this.modelComboBox.SelectedIndexChanged += new
System.EventHandler(this.modelComboBox_SelectedIndexChanged);
+ //
+ // tabData
+ //
+ this.tabData.BackColor = System.Drawing.Color.AliceBlue;
+ this.tabData.Controls.Add(this.groupBox7);
+ this.tabData.Controls.Add(this.groupBox6);
+ this.tabData.ForeColor = System.Drawing.Color.DarkBlue;
+ this.tabData.Location = new System.Drawing.Point(4, 22);
+ this.tabData.Name = "tabData";
+ this.tabData.Padding = new System.Windows.Forms.Padding(3);
+ this.tabData.Size = new System.Drawing.Size(167, 504);
+ this.tabData.TabIndex = 2;
+ this.tabData.Text = "Data";
+ this.tabData.UseVisualStyleBackColor = true;
+ //
+ // groupBox7
+ //
+ this.groupBox7.BackColor = System.Drawing.Color.AliceBlue;
+ this.groupBox7.Controls.Add(this.tableNameTextBox);
+ this.groupBox7.Controls.Add(this.label12);
+ this.groupBox7.Controls.Add(this.addButton);
+ this.groupBox7.Location = new System.Drawing.Point(1, 433);
+ this.groupBox7.Name = "groupBox7";
+ this.groupBox7.Size = new System.Drawing.Size(165, 66);
+ this.groupBox7.TabIndex = 36;
+ this.groupBox7.TabStop = false;
+ this.groupBox7.Text = "Add Table";
+ //
+ // tableNameTextBox
+ //
+ this.tableNameTextBox.Location = new System.Drawing.Point(6,
34);
+ this.tableNameTextBox.Name = "tableNameTextBox";
+ this.tableNameTextBox.Size = new System.Drawing.Size(71, 20);
+ this.tableNameTextBox.TabIndex = 12;
+ this.tableNameTextBox.TabStop = false;
+ //
+ // label12
+ //
+ this.label12.AutoSize = true;
+ this.label12.ForeColor = System.Drawing.Color.DarkBlue;
+ this.label12.Location = new System.Drawing.Point(6, 18);
+ this.label12.Name = "label12";
+ this.label12.Size = new System.Drawing.Size(65, 13);
+ this.label12.TabIndex = 33;
+ this.label12.Text = "Table Name";
+ //
+ // addButton
+ //
+ this.addButton.Location = new System.Drawing.Point(84, 32);
+ this.addButton.Name = "addButton";
+ this.addButton.Size = new System.Drawing.Size(75, 23);
+ this.addButton.TabIndex = 13;
+ this.addButton.TabStop = false;
+ this.addButton.Text = "Add";
+ this.addButton.UseVisualStyleBackColor = true;
+ this.addButton.Click += new
System.EventHandler(this.addButton_Click);
+ //
+ // groupBox6
+ //
+ this.groupBox6.BackColor = System.Drawing.Color.AliceBlue;
+ this.groupBox6.Controls.Add(this.wsPanel);
+ this.groupBox6.Controls.Add(this.webServiceRadioButton);
+ this.groupBox6.Controls.Add(this.infileRadioButton);
+ this.groupBox6.Controls.Add(this.filePanel);
+ this.groupBox6.Controls.Add(this.updateButton);
+ this.groupBox6.Controls.Add(this.deleteButton);
+ this.groupBox6.Controls.Add(this.tablsComboBox);
+ this.groupBox6.Controls.Add(this.label11);
+ this.groupBox6.Location = new System.Drawing.Point(2, 3);
+ this.groupBox6.Name = "groupBox6";
+ this.groupBox6.Size = new System.Drawing.Size(165, 424);
+ this.groupBox6.TabIndex = 35;
+ this.groupBox6.TabStop = false;
+ this.groupBox6.Text = "Update Database";
+ //
+ // wsPanel
+ //
+ this.wsPanel.Controls.Add(this.identifier);
+ this.wsPanel.Controls.Add(this.quotesRadioButton);
+ this.wsPanel.Controls.Add(this.ratesRadioButton);
+ this.wsPanel.Controls.Add(this.rateTypesComboBox);
+ this.wsPanel.Controls.Add(this.toDate);
+ this.wsPanel.Controls.Add(this.fromDate);
+ this.wsPanel.Controls.Add(this.label15);
+ this.wsPanel.Controls.Add(this.label18);
+ this.wsPanel.Enabled = false;
+ this.wsPanel.Location = new System.Drawing.Point(19, 202);
+ this.wsPanel.Name = "wsPanel";
+ this.wsPanel.Size = new System.Drawing.Size(141, 182);
+ this.wsPanel.TabIndex = 45;
+ //
+ // identifier
+ //
+ this.identifier.Enabled = false;
+ this.identifier.Location = new System.Drawing.Point(6, 73);
+ this.identifier.Name = "identifier";
+ this.identifier.Size = new System.Drawing.Size(132, 20);
+ this.identifier.TabIndex = 7;
+ this.identifier.TabStop = false;
+ //
+ // quotesRadioButton
+ //
+ this.quotesRadioButton.AutoSize = true;
+ this.quotesRadioButton.Location = new System.Drawing.Point(8,
52);
+ this.quotesRadioButton.Name = "quotesRadioButton";
+ this.quotesRadioButton.Size = new System.Drawing.Size(59, 17);
+ this.quotesRadioButton.TabIndex = 6;
+ this.quotesRadioButton.Text = "Quotes";
+ this.quotesRadioButton.UseVisualStyleBackColor = true;
+ this.quotesRadioButton.CheckedChanged += new
System.EventHandler(this.quotesRadioButton_CheckedChanged);
+ //
+ // ratesRadioButton
+ //
+ this.ratesRadioButton.AutoSize = true;
+ this.ratesRadioButton.Checked = true;
+ this.ratesRadioButton.Location = new System.Drawing.Point(8,
3);
+ this.ratesRadioButton.Name = "ratesRadioButton";
+ this.ratesRadioButton.Size = new System.Drawing.Size(53, 17);
+ this.ratesRadioButton.TabIndex = 40;
+ this.ratesRadioButton.TabStop = true;
+ this.ratesRadioButton.Text = "Rates";
+ this.ratesRadioButton.UseVisualStyleBackColor = true;
+ this.ratesRadioButton.CheckedChanged += new
System.EventHandler(this.ratesRadioButton_CheckedChanged);
+ //
+ // rateTypesComboBox
+ //
+ this.rateTypesComboBox.DropDownStyle =
System.Windows.Forms.ComboBoxStyle.DropDownList;
+ this.rateTypesComboBox.FormattingEnabled = true;
+ this.rateTypesComboBox.ItemHeight = 13;
+ this.rateTypesComboBox.Location = new System.Drawing.Point(6,
25);
+ this.rateTypesComboBox.Name = "rateTypesComboBox";
+ this.rateTypesComboBox.Size = new System.Drawing.Size(134, 21);
+ this.rateTypesComboBox.TabIndex = 5;
+ this.rateTypesComboBox.TabStop = false;
+ //
+ // toDate
+ //
+ this.toDate.Format =
System.Windows.Forms.DateTimePickerFormat.Short;
+ this.toDate.Location = new System.Drawing.Point(6, 158);
+ this.toDate.MinDate = new System.DateTime(1995, 1, 1, 0, 0, 0,
0);
+ this.toDate.Name = "toDate";
+ this.toDate.Size = new System.Drawing.Size(135, 20);
+ this.toDate.TabIndex = 9;
+ this.toDate.TabStop = false;
+ //
+ // fromDate
+ //
+ this.fromDate.Format =
System.Windows.Forms.DateTimePickerFormat.Short;
+ this.fromDate.Location = new System.Drawing.Point(6, 112);
+ this.fromDate.MinDate = new System.DateTime(1995, 1, 1, 0, 0,
0, 0);
+ this.fromDate.Name = "fromDate";
+ this.fromDate.Size = new System.Drawing.Size(135, 20);
+ this.fromDate.TabIndex = 8;
+ this.fromDate.TabStop = false;
+ this.fromDate.Value = new System.DateTime(1995, 1, 1, 0, 0, 0,
0);
+ //
+ // label15
+ //
+ this.label15.AutoSize = true;
+ this.label15.ForeColor = System.Drawing.Color.DarkBlue;
+ this.label15.Location = new System.Drawing.Point(5, 94);
+ this.label15.Name = "label15";
+ this.label15.Size = new System.Drawing.Size(30, 13);
+ this.label15.TabIndex = 39;
+ this.label15.Text = "From";
+ //
+ // label18
+ //
+ this.label18.AutoSize = true;
+ this.label18.ForeColor = System.Drawing.Color.DarkBlue;
+ this.label18.Location = new System.Drawing.Point(2, 139);
+ this.label18.Name = "label18";
+ this.label18.Size = new System.Drawing.Size(20, 13);
+ this.label18.TabIndex = 37;
+ this.label18.Text = "To";
+ //
+ // webServiceRadioButton
+ //
+ this.webServiceRadioButton.AutoSize = true;
+ this.webServiceRadioButton.Location = new
System.Drawing.Point(5, 181);
+ this.webServiceRadioButton.Name = "webServiceRadioButton";
+ this.webServiceRadioButton.Size = new System.Drawing.Size(117,
17);
+ this.webServiceRadioButton.TabIndex = 4;
+ this.webServiceRadioButton.Text = "Using Web Service";
+ this.webServiceRadioButton.UseVisualStyleBackColor = true;
+ this.webServiceRadioButton.CheckedChanged += new
System.EventHandler(this.webServiceRadioButton_CheckedChanged);
+ //
+ // infileRadioButton
+ //
+ this.infileRadioButton.AutoSize = true;
+ this.infileRadioButton.Checked = true;
+ this.infileRadioButton.Location = new System.Drawing.Point(5,
70);
+ this.infileRadioButton.Name = "infileRadioButton";
+ this.infileRadioButton.Size = new System.Drawing.Size(104, 17);
+ this.infileRadioButton.TabIndex = 1;
+ this.infileRadioButton.TabStop = true;
+ this.infileRadioButton.Text = "Using a CSV File";
+ this.infileRadioButton.UseVisualStyleBackColor = true;
+ this.infileRadioButton.CheckedChanged += new
System.EventHandler(this.infileRadioButton_CheckedChanged);
+ //
+ // filePanel
+ //
+ this.filePanel.Controls.Add(this.label20);
+ this.filePanel.Controls.Add(this.irBrowseButton);
+ this.filePanel.Controls.Add(this.filePathTextBox);
+ this.filePanel.Location = new System.Drawing.Point(19, 93);
+ this.filePanel.Name = "filePanel";
+ this.filePanel.Size = new System.Drawing.Size(141, 82);
+ this.filePanel.TabIndex = 42;
+ //
+ // label20
+ //
+ this.label20.AutoSize = true;
+ this.label20.ForeColor = System.Drawing.Color.DarkBlue;
+ this.label20.Location = new System.Drawing.Point(3, 7);
+ this.label20.Name = "label20";
+ this.label20.Size = new System.Drawing.Size(87, 13);
+ this.label20.TabIndex = 33;
+ this.label20.Text = "Browse Data File";
+ //
+ // irBrowseButton
+ //
+ this.irBrowseButton.Location = new System.Drawing.Point(64,
52);
+ this.irBrowseButton.Name = "irBrowseButton";
+ this.irBrowseButton.Size = new System.Drawing.Size(75, 23);
+ this.irBrowseButton.TabIndex = 3;
+ this.irBrowseButton.TabStop = false;
+ this.irBrowseButton.Text = "Browse";
+ this.irBrowseButton.UseVisualStyleBackColor = true;
+ this.irBrowseButton.Click += new
System.EventHandler(this.browseButton_Click);
+ //
+ // filePathTextBox
+ //
+ this.filePathTextBox.Location = new System.Drawing.Point(6,
26);
+ this.filePathTextBox.Name = "filePathTextBox";
+ this.filePathTextBox.Size = new System.Drawing.Size(135, 20);
+ this.filePathTextBox.TabIndex = 2;
+ this.filePathTextBox.TabStop = false;
+ //
+ // updateButton
+ //
+ this.updateButton.Location = new System.Drawing.Point(85, 390);
+ this.updateButton.Name = "updateButton";
+ this.updateButton.Size = new System.Drawing.Size(75, 23);
+ this.updateButton.TabIndex = 11;
+ this.updateButton.TabStop = false;
+ this.updateButton.Text = "Update";
+ this.updateButton.UseVisualStyleBackColor = true;
+ this.updateButton.Click += new
System.EventHandler(this.updateButton_Click);
+ //
+ // deleteButton
+ //
+ this.deleteButton.Location = new System.Drawing.Point(4, 390);
+ this.deleteButton.Name = "deleteButton";
+ this.deleteButton.Size = new System.Drawing.Size(75, 23);
+ this.deleteButton.TabIndex = 10;
+ this.deleteButton.TabStop = false;
+ this.deleteButton.Text = "Delete";
+ this.deleteButton.UseVisualStyleBackColor = true;
+ this.deleteButton.Click += new
System.EventHandler(this.deleteButton_Click);
+ //
+ // tablsComboBox
+ //
+ this.tablsComboBox.DropDownStyle =
System.Windows.Forms.ComboBoxStyle.DropDownList;
+ this.tablsComboBox.FormattingEnabled = true;
+ this.tablsComboBox.Location = new System.Drawing.Point(9, 41);
+ this.tablsComboBox.Name = "tablsComboBox";
+ this.tablsComboBox.Size = new System.Drawing.Size(150, 21);
+ this.tablsComboBox.TabIndex = 0;
+ this.tablsComboBox.TabStop = false;
+ //
+ // label11
+ //
+ this.label11.AutoSize = true;
+ this.label11.BackColor = System.Drawing.Color.Transparent;
+ this.label11.ForeColor = System.Drawing.Color.DarkBlue;
+ this.label11.Location = new System.Drawing.Point(6, 23);
+ this.label11.Name = "label11";
+ this.label11.Size = new System.Drawing.Size(67, 13);
+ this.label11.TabIndex = 30;
+ this.label11.Text = "Select Table";
+ //
+ // tabPage1
+ //
+ this.tabPage1.BackColor = System.Drawing.Color.AliceBlue;
+ this.tabPage1.Controls.Add(this.groupBox4);
+ this.tabPage1.ForeColor = System.Drawing.Color.DarkBlue;
+ this.tabPage1.Location = new System.Drawing.Point(4, 22);
+ this.tabPage1.Name = "tabPage1";
+ this.tabPage1.Padding = new System.Windows.Forms.Padding(3);
+ this.tabPage1.Size = new System.Drawing.Size(167, 504);
+ this.tabPage1.TabIndex = 3;
+ this.tabPage1.Text = "Jobs";
+ this.tabPage1.UseVisualStyleBackColor = true;
+ //
+ // groupBox4
+ //
+ this.groupBox4.Controls.Add(this.endJobButton);
+ this.groupBox4.Controls.Add(this.listView1);
+ this.groupBox4.Location = new System.Drawing.Point(0, 3);
+ this.groupBox4.Name = "groupBox4";
+ this.groupBox4.Size = new System.Drawing.Size(165, 495);
+ this.groupBox4.TabIndex = 33;
+ this.groupBox4.TabStop = false;
+ this.groupBox4.Text = "Job Manager";
+ //
+ // endJobButton
+ //
+ this.endJobButton.Location = new System.Drawing.Point(84, 464);
+ this.endJobButton.Name = "endJobButton";
+ this.endJobButton.Size = new System.Drawing.Size(75, 23);
+ this.endJobButton.TabIndex = 1;
+ this.endJobButton.TabStop = false;
+ this.endJobButton.Text = "End Job";
+ this.endJobButton.UseVisualStyleBackColor = true;
+ this.endJobButton.Click += new
System.EventHandler(this.endJobButton_Click);
+ //
+ // listView1
+ //
+ this.listView1.Columns.AddRange(new
System.Windows.Forms.ColumnHeader[] {
+ this.columnHeader1,
+ this.columnHeader2,
+ this.columnHeader3,
+ this.columnHeader4,
+ this.columnHeader5,
+ this.columnHeader6,
+ this.columnHeader7});
+ this.listView1.FullRowSelect = true;
+ this.listView1.Location = new System.Drawing.Point(3, 19);
+ this.listView1.MultiSelect = false;
+ this.listView1.Name = "listView1";
+ this.listView1.Size = new System.Drawing.Size(152, 431);
+ this.listView1.TabIndex = 0;
+ this.listView1.TabStop = false;
+ this.listView1.UseCompatibleStateImageBehavior = false;
+ this.listView1.View = System.Windows.Forms.View.Details;
+ //
+ // columnHeader1
+ //
+ this.columnHeader1.Text = "ID";
+ //
+ // columnHeader2
+ //
+ this.columnHeader2.Text = "Model";
+ //
+ // columnHeader3
+ //
+ this.columnHeader3.Text = "D/M";
+ //
+ // columnHeader4
+ //
+ this.columnHeader4.Text = "Time";
+ //
+ // columnHeader5
+ //
+ this.columnHeader5.Text = "Simulations";
+ //
+ // columnHeader6
+ //
+ this.columnHeader6.Text = "Nodes";
+ //
+ // columnHeader7
+ //
+ this.columnHeader7.Text = "Data";
+ //
+ // button1
+ //
+ this.button1.Location = new System.Drawing.Point(84, 148);
+ this.button1.Name = "button1";
+ this.button1.Size = new System.Drawing.Size(75, 23);
+ this.button1.TabIndex = 37;
+ this.button1.Text = "Update";
+ this.button1.UseVisualStyleBackColor = true;
+ //
+ // button2
+ //
+ this.button2.Location = new System.Drawing.Point(4, 148);
+ this.button2.Name = "button2";
+ this.button2.Size = new System.Drawing.Size(75, 23);
+ this.button2.TabIndex = 36;
+ this.button2.Text = "Delete";
+ this.button2.UseVisualStyleBackColor = true;
+ //
+ // comboBox2
+ //
+ this.comboBox2.FormattingEnabled = true;
+ this.comboBox2.Location = new System.Drawing.Point(9, 41);
+ this.comboBox2.Name = "comboBox2";
+ this.comboBox2.Size = new System.Drawing.Size(150, 21);
+ this.comboBox2.TabIndex = 35;
+ //
+ // textBox2
+ //
+ this.textBox2.Location = new System.Drawing.Point(9, 93);
+ this.textBox2.Name = "textBox2";
+ this.textBox2.Size = new System.Drawing.Size(150, 20);
+ this.textBox2.TabIndex = 34;
+ //
+ // label8
+ //
+ this.label8.AutoSize = true;
+ this.label8.ForeColor = System.Drawing.Color.DarkBlue;
+ this.label8.Location = new System.Drawing.Point(6, 72);
+ this.label8.Name = "label8";
+ this.label8.Size = new System.Drawing.Size(87, 13);
+ this.label8.TabIndex = 33;
+ this.label8.Text = "Browse Data File";
+ //
+ // button3
+ //
+ this.button3.Location = new System.Drawing.Point(84, 119);
+ this.button3.Name = "button3";
+ this.button3.Size = new System.Drawing.Size(75, 23);
+ this.button3.TabIndex = 32;
+ this.button3.Text = "Browse";
+ this.button3.UseVisualStyleBackColor = true;
+ //
+ // label9
+ //
+ this.label9.AutoSize = true;
+ this.label9.BackColor = System.Drawing.Color.Transparent;
+ this.label9.ForeColor = System.Drawing.Color.DarkBlue;
+ this.label9.Location = new System.Drawing.Point(6, 23);
+ this.label9.Name = "label9";
+ this.label9.Size = new System.Drawing.Size(67, 13);
+ this.label9.TabIndex = 30;
+ this.label9.Text = "Select Table";
+ //
+ // Finance
+ //
+ this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
+ this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
+ this.Controls.Add(this.tabWindow);
+ this.Name = "Finance";
+ this.Size = new System.Drawing.Size(175, 530);
+ this.Load += new System.EventHandler(this.Finance_Load);
+ this.tabWindow.ResumeLayout(false);
+ this.tabForecast.ResumeLayout(false);
+ this.groupBox8.ResumeLayout(false);
+ this.groupBox8.PerformLayout();
+ this.groupBox3.ResumeLayout(false);
+ this.groupBox3.PerformLayout();
+ this.groupBox2.ResumeLayout(false);
+ this.groupBox2.PerformLayout();
+ this.panel1.ResumeLayout(false);
+ this.panel1.PerformLayout();
+ this.panel2.ResumeLayout(false);
+ this.panel2.PerformLayout();
+ this.groupBox1.ResumeLayout(false);
+ this.groupBox1.PerformLayout();
+ this.tabData.ResumeLayout(false);
+ this.groupBox7.ResumeLayout(false);
+ this.groupBox7.PerformLayout();
+ this.groupBox6.ResumeLayout(false);
+ this.groupBox6.PerformLayout();
+ this.wsPanel.ResumeLayout(false);
+ this.wsPanel.PerformLayout();
+ this.filePanel.ResumeLayout(false);
+ this.filePanel.PerformLayout();
+ this.tabPage1.ResumeLayout(false);
+ this.groupBox4.ResumeLayout(false);
+ this.ResumeLayout(false);
+
+ }
+
+ #endregion
+
+ private System.Windows.Forms.OpenFileDialog openFileDialog;
+ private System.Windows.Forms.TabControl tabWindow;
+ private System.Windows.Forms.TabPage tabForecast;
+ private System.Windows.Forms.ComboBox modelComboBox;
+ private System.Windows.Forms.Label label1;
+ private System.Windows.Forms.GroupBox groupBox1;
+ private System.Windows.Forms.GroupBox groupBox2;
+ private System.Windows.Forms.RadioButton usingParaRadioButton;
+ private System.Windows.Forms.Panel panel1;
+ private System.Windows.Forms.Label label3;
+ private System.Windows.Forms.ComboBox tablesComboBox;
+ private System.Windows.Forms.Panel panel2;
+ private System.Windows.Forms.Label label2;
+ private System.Windows.Forms.TextBox paraTextBox;
+ private System.Windows.Forms.RadioButton usingDataRadioButton;
+ private System.Windows.Forms.GroupBox groupBox3;
+ private System.Windows.Forms.TextBox paraFormatTextBox;
+ private System.Windows.Forms.TabPage tabData;
+ private System.Windows.Forms.GroupBox groupBox7;
+ private System.Windows.Forms.TextBox tableNameTextBox;
+ private System.Windows.Forms.Label label12;
+ private System.Windows.Forms.Button addButton;
+ private System.Windows.Forms.GroupBox groupBox6;
+ private System.Windows.Forms.Button updateButton;
+ private System.Windows.Forms.Button deleteButton;
+ private System.Windows.Forms.ComboBox tablsComboBox;
+ private System.Windows.Forms.TextBox filePathTextBox;
+ private System.Windows.Forms.Button irBrowseButton;
+ private System.Windows.Forms.Label label11;
+ private System.Windows.Forms.Button button1;
+ private System.Windows.Forms.Button button2;
+ private System.Windows.Forms.ComboBox comboBox2;
+ private System.Windows.Forms.TextBox textBox2;
+ private System.Windows.Forms.Label label8;
+ private System.Windows.Forms.Button button3;
+ private System.Windows.Forms.Label label9;
+ private System.Windows.Forms.Panel wsPanel;
+ private System.Windows.Forms.DateTimePicker toDate;
+ private System.Windows.Forms.DateTimePicker fromDate;
+ private System.Windows.Forms.Label label15;
+ private System.Windows.Forms.Label label18;
+ private System.Windows.Forms.RadioButton webServiceRadioButton;
+ private System.Windows.Forms.RadioButton infileRadioButton;
+ private System.Windows.Forms.Panel filePanel;
+ private System.Windows.Forms.Label label20;
+ private System.Windows.Forms.ComboBox rateTypesComboBox;
+ private System.Windows.Forms.TextBox identifier;
+ private System.Windows.Forms.RadioButton quotesRadioButton;
+ private System.Windows.Forms.RadioButton ratesRadioButton;
+ private System.Windows.Forms.GroupBox groupBox8;
+ private System.Windows.Forms.Label label10;
+ private System.Windows.Forms.TextBox periodTextBox;
+ private System.Windows.Forms.ComboBox periodTypeComboBox;
+ private System.Windows.Forms.Label label5;
+ private System.Windows.Forms.Button executeButton;
+ private System.Windows.Forms.TabPage tabPage1;
+ private System.Windows.Forms.GroupBox groupBox4;
+ private System.Windows.Forms.ListView listView1;
+ private System.Windows.Forms.ColumnHeader columnHeader1;
+ private System.Windows.Forms.ColumnHeader columnHeader2;
+ private System.Windows.Forms.ColumnHeader columnHeader3;
+ private System.Windows.Forms.ColumnHeader columnHeader4;
+ private System.Windows.Forms.ColumnHeader columnHeader5;
+ private System.Windows.Forms.ColumnHeader columnHeader6;
+ private System.Windows.Forms.Button endJobButton;
+ private System.Windows.Forms.ColumnHeader columnHeader7;
+ private System.Windows.Forms.ComboBox periodTypeComboBox2;
+ }
+}
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/Finance.cs Sun Jan 17 01:18:44 2010
@@ -0,0 +1,973 @@
+/*
+ Copyright (c) 2008 by contributors:
+
+ * Damitha Premadasa
+ * Nilendra Weerasinghe
+ * Thilina Dampahala
+ * Waruna Ranasinghe - (http://warunapw.blogspot.com)
+
+ Licensed under the Apache License, Version 2.0 (the "License");
+ you may not use this file except in compliance with the License.
+ You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+*/
+
+using System;
+using System.Collections.Generic;
+using System.ComponentModel;
+using System.Drawing;
+using System.Data;
+using System.Text;
+using System.Windows.Forms;
+using System.Runtime.Remoting;
+using System.Diagnostics;
+using System.IO;
+using XClient.com.xignite.www;
+using XClient.com.xignite;
+using System.Configuration;
+using XClient.Properties;
+using System.Threading;
+using System.Security;
+
+namespace XClient
+{
+ public partial class Finance : UserControl
+ {
+ /// <summary>
+ /// Finance Constructor
+ /// </summary>
+ public Finance()
+ {
+ InitializeComponent();
+
+ updateButton.Enabled = true;
+ filePathTextBox.Clear();
+
+ }
+
+
+ /// <summary>
+ /// Event openFileDialog_FileOk
+ /// </summary>
+ /// <param name="sender">sender</param>
+ /// <param name="e">event arguments</param>
+ private void openFileDialog_FileOk(object sender, CancelEventArgs
e)
+ {
+ filePathTextBox.Text = openFileDialog.FileName;
+ }
+
+ /// <summary>
+ /// Event Finance_Load
+ /// </summary>
+ /// <param name="sender">sender</param>
+ /// <param name="e">event arguments</param>
+ private void Finance_Load(object sender, EventArgs e)
+ {
+ try
+ {
+ PopulateWithModels(this.modelComboBox);
+
+ }
+ catch { }
+
+ try
+ {
+ PopulateWithPeriodTyps(this.periodTypeComboBox);
+ PopulateWithPeriodTyps2(this.periodTypeComboBox2);
+ }
+ catch {}
+
+ try
+ {
+ PopulateWithParaFormat(this.paraFormatTextBox,
modelComboBox.SelectedItem.ToString());
+ }
+ catch { }
+
+ try
+ {
+ PopulateWithTables(this.tablsComboBox);
+ PopulateWithTables(this.tablesComboBox);
+ }
+ catch { }
+ try
+ {
+ PopulateWithInterestRateTypes(this.rateTypesComboBox);
+ }
+ catch { }
+
+ }
+
+ /// <summary>
+ /// Populate the ComboBox with time period types
+ /// </summary>
+ /// <param name="cb">ComboBox</param>
+ private void PopulateWithPeriodTyps(ComboBox cb)
+ {
+ cb.Items.Clear();
+
+ cb.Items.Add("Daily");
+ cb.Items.Add("Monthly");
+ cb.Items.Add("Quarterly");
+ cb.Items.Add("Yearly");
+
+ try
+ {
+ cb.SelectedIndex = 0;
+ }
+ catch (Exception)
+ { }
+ }
+ private void PopulateWithPeriodTyps2(ComboBox cb)
+ {
+ cb.Items.Clear();
+
+ cb.Items.Add("Days");
+ cb.Items.Add("Months");
+ cb.Items.Add("Quarters");
+ cb.Items.Add("Years");
+
+ try
+ {
+ cb.SelectedIndex = 0;
+ }
+ catch (Exception)
+ { }
+ }
+ /// <summary>
+ /// Populate the TextBox with parameter format for corresponding
model
+ /// </summary>
+ /// <param name="tb">TextBox</param>
+ /// <param name="model">model</param>
+ private void PopulateWithParaFormat(TextBox tb, string model)
+ {
+ tb.Clear();
+ tb.Text = new HPC_FinanceDBManager().GetParaList(model);
+ }
+
+ /// <summary>
+ /// Populate the ComboBox with all models
+ /// </summary>
+ /// <param name="cb">ComboBox</param>
+ private void PopulateWithModels(ComboBox cb)
+ {
+ HPC_FinanceDBManager manager = new HPC_FinanceDBManager();
+ cb.Items.Clear();
+
+ List<string> tablesList = manager.GetModels();
+ foreach (string s in tablesList)
+ {
+ cb.Items.Add(s);
+ }
+ try
+ {
+ cb.SelectedIndex = 0;
+ }
+ catch (Exception)
+ { }
+ }
+
+ /// <summary>
+ /// Populate the ComboBox with all tbles
+ /// </summary>
+ /// <param name="cb">ComboBox</param>
+ private void PopulateWithTables(ComboBox cb)
+ {
+ DataDBTableManager tManager = new DataDBTableManager();
+ cb.Items.Clear();
+ List<string> tablesList = tManager.GetAllTables();
+ foreach (string s in tablesList)
+ {
+ cb.Items.Add(s.ToUpper());
+ }
+ try
+ {
+ cb.SelectedIndex = 0;
+ }
+ catch (Exception)
+ { }
+
+ }
+
+ /// <summary>
+ /// Event usingDataRadioButton_CheckedChanged
+ /// </summary>
+ /// <param name="sender">sender</param>
+ /// <param name="e">event arguments</param>
+ private void usingDataRadioButton_CheckedChanged(object sender,
EventArgs e)
+ {
+ if (usingParaRadioButton.Checked)
+ {
+ panel2.Enabled = true;
+ panel1.Enabled = false;
+ groupBox3.Visible = true;
+ }
+ else
+ {
+ panel2.Enabled = false;
+ panel1.Enabled = true;
+ groupBox3.Visible = false;
+ }
+ }
+
+ /// <summary>
+ /// Event usingParaRadioButton_CheckedChanged
+ /// </summary>
+ /// <param name="sender">sender</param>
+ /// <param name="e">event arguments</param>
+ private void usingParaRadioButton_CheckedChanged(object sender,
EventArgs e)
+ {
+ if (usingDataRadioButton.Checked)
+ {
+ panel1.Enabled = true;
+ panel2.Enabled = false;
+ groupBox3.Visible = false;
+ }
+ else
+ {
+ panel1.Enabled = false;
+ panel2.Enabled = true;
+ groupBox3.Visible = true;
+ }
+ }
+
+
+ /// <summary>
+ /// Event browseButton_Click
+ /// </summary>
+ /// <param name="sender">sender</param>
+ /// <param name="e">event arguments</param>
+ private void browseButton_Click(object sender, EventArgs e)
+ {
+ openFileDialog.ShowDialog();
+ }
+
+ /// <summary>
+ /// Event addButton_Click
+ /// </summary>
+ /// <param name="sender">sender</param>
+ /// <param name="e">event arguments</param>
+ private void addButton_Click(object sender, EventArgs e)
+ {
+ if (tableNameTextBox.Text.Trim().Length > 0)
+ {
+ try
+ {
+ new Thread(new
ThreadStart(this.AddOperationWorker)).Start();
+ }
+ catch (ThreadStartException)
+ { }
+ catch (InvalidOperationException)
+ { }
+ catch (SecurityException)
+ { }
+ catch (OutOfMemoryException)
+ { }
+ }
+ else
+ {
+ MessageBox.Show("Enter Table Name!");
+ }
+ }
+
+ /// <summary>
+ /// Worker of Add operation
+ /// </summary>
+ private void AddOperationWorker()
+ {
+ try
+ {
+ string table = tableNameTextBox.Text;
+ tableNameTextBox.Clear();
+
+ DataDBTableManager tManager = new DataDBTableManager();
+ string[] array = table.Split(new Char[] { ' ' });
+ string temp = null;
+ foreach (string s in array)
+ {
+ temp += s;
+ }
+ tManager.CreateTable(temp);
+ PopulateWithTables(this.tablsComboBox);
+ PopulateWithTables(this.tablesComboBox);
+ }
+ catch (Exception)
+ {
+ MessageBox.Show("Invalid Operation or Database
Connection!");
+ }
+ }
+
+ /// <summary>
+ /// Event updateButton_Click
+ /// </summary>
+ /// <param name="sender">sender</param>
+ /// <param name="e">event arguments</param>
+ private void updateButton_Click(object sender, EventArgs e)
+ {
+ //UpdateOperationWorker();
+ if (infileRadioButton.Checked)
+ {
+ if (!File.Exists(filePathTextBox.Text))
+ {
+ MessageBox.Show("File Does Not Exist!");
+ return;
+ }
+ }
+
+ try
+ {
+ new Thread(new
ThreadStart(this.UpdateOperationWorker)).Start();
+ }
+ catch (ThreadStartException)
+ { }
+ catch (InvalidOperationException)
+ { }
+ catch (SecurityException)
+ { }
+ catch (OutOfMemoryException)
+ { }
+
+ }
+
+ /// <summary>
+ /// Worker method for update operation
+ /// </summary>
+ private void UpdateOperationWorker()
+ {
+ string path = filePathTextBox.Text;
+ string table = tablsComboBox.SelectedItem.ToString();
+ filePathTextBox.Clear();
+ MessageBox.Show(table + " Update Started");
+
+ try
+ {
+ if (infileRadioButton.Checked)
+ {
+ new DataWriter().WriteData(new
DataFetcher().GetDataEntityList(path), table);
+ filePathTextBox.Clear();
+ }
+
+ if (webServiceRadioButton.Checked)
+ {
+ if (ratesRadioButton.Checked)
+ {
+ new WSIRWriter().WriteData(new
WSIRFetcher().GetDataEntityList(rateTypesComboBox.SelectedItem.ToString(),
fromDate.Value.ToShortDateString(), toDate.Value.ToShortDateString()),
tablsComboBox.SelectedItem.ToString());
+ }
+ else
+ {
+ new WSSPWriter().WriteData(new
WSSPFetcher().GetDataEntityList(identifier.Text,
fromDate.Value.ToShortDateString(), toDate.Value.ToShortDateString()),
tablsComboBox.SelectedItem.ToString());
+ }
+ }
+ MessageBox.Show(table + " Update Complete");
+ }
+ catch (Exception ex)
+ {
+ MessageBox.Show(ex.Message);
+ }
+
+ }
+
+ /// <summary>
+ /// Event deleteButton_Click
+ /// </summary>
+ /// <param name="sender">sender</param>
+ /// <param name="e">event arguments</param>
+ private void deleteButton_Click(object sender, EventArgs e)
+ {
+ new Thread(new
ThreadStart(this.DeleteOperationWorker)).Start();
+ }
+
+ /// <summary>
+ /// Worker thread for delete operation
+ /// </summary>
+ private void DeleteOperationWorker()
+ {
+ if (tablsComboBox.Items.Count > 0)
+ {
+ try
+ {
+ DataDBTableManager tManager = new DataDBTableManager();
+
tManager.DeleteTable(tablsComboBox.SelectedItem.ToString());
+ PopulateWithTables(this.tablsComboBox);
+ PopulateWithTables(this.tablesComboBox);
+ }
+ catch (Exception ex)
+ {
+ MessageBox.Show(ex.Message);
+ }
+ }
+ }
+
+ /// <summary>
+ /// Event infileRadioButton_CheckedChanged
+ /// </summary>
+ /// <param name="sender">sender</param>
+ /// <param name="e">event arguments</param>
+ private void infileRadioButton_CheckedChanged(object sender,
EventArgs e)
+ {
+ if (infileRadioButton.Checked)
+ {
+ filePanel.Enabled = true;
+ wsPanel.Enabled = false;
+ }
+ }
+
+ /// <summary>
+ /// Event webServiceRadioButton_CheckedChanged
+ /// </summary>
+ /// <param name="sender">sender</param>
+ /// <param name="e">event arguments</param>
+ private void webServiceRadioButton_CheckedChanged(object sender,
EventArgs e)
+ {
+ if (webServiceRadioButton.Checked)
+ {
+ wsPanel.Enabled = true;
+ filePanel.Enabled = false;
+ }
+ }
+
+ /// <summary>
+ /// Populates combo box with supporting interest rate types
+ /// </summary>
+ /// <param name="comboBox">Combobox</param>
+ private void PopulateWithInterestRateTypes(ComboBox cb)
+ {
+ cb.Items.Clear();
+ Type rates = typeof(RateTypes);
+ string[] typesArray = Enum.GetNames(rates);
+ foreach (string s in typesArray)
+ {
+ cb.Items.Add(s);
+ }
+ try
+ {
+ cb.SelectedIndex = 0;
+ }
+ catch (Exception)
+ { }
+ }
+
+
+
+
+ /// <summary>
+ /// Worker for execute operation
+ /// </summary>
+ private void ExecuteWorker()
+ {
+ try
+ {
+
+
+ int per = int.Parse(periodTextBox.Text);
+ //string period = Convert.ToString(per *
int.Parse(periodTypeComboBox2.SelectedItem.ToString()));
+ this.periodTextBox.Clear();
+ string model = modelComboBox.SelectedItem.ToString();
+ string fullArg = null;
+ string path = new HPC_FinanceDBManager().GetPath(model);
+ string paraList = null;
+ string result = null;
+ Settings set = Settings.Default;
+ string table = tablesComboBox.SelectedItem.ToString();
+ string periodType =
periodTypeComboBox.SelectedItem.ToString();
+ string periodType2 =
periodTypeComboBox2.SelectedItem.ToString();
+ double factor1, factor2;
+ if (periodType.Equals("Daily"))
+ {
+ factor1 = 252;
+ }
+ else if (periodType.Equals("Monthly"))
+ {
+ factor1 = 12;
+ }
+ else if (periodType.Equals("Quarterly"))
+ {
+ factor1 = 4;
+ }
+ else
+ {
+ factor1 = 1;
+ }
+ if (periodType2.Equals("Days"))
+ {
+ factor2 = 252;
+ }
+ else if (periodType2.Equals("Months"))
+ {
+ factor2 = 12;
+ }
+ else if (periodType2.Equals("Quarters"))
+ {
+ factor2 = 4;
+ }
+ else
+ {
+ factor2 = 1;
+ }
+ int temp = (int)(per * (factor1 / factor2));
+ string period = Convert.ToString(temp);
+ string para = paraTextBox.Text;
+ bool paraRadButtonStatus = usingParaRadioButton.Checked;
+ bool dataRadButtonStatus = usingDataRadioButton.Checked;
+ paraTextBox.Clear();
+ string ticket = new ClientEngine().GetTicket();
+ string dataS = "Manual";
+ if (dataRadButtonStatus)
+ {
+ dataS = table;
+ }
+ ListViewItem item = new ListViewItem(new string[] {
ticket, model, periodType, period, set.nMC, set.nodes, dataS });
+ lock (listView1)
+ {
+ listView1.Items.Add(item);
+ }
+
+
+ MessageBox.Show("Model : " + model + "\n" + "Job
Submitted" + "\n");
+
+
+ if (paraRadButtonStatus)
+ {
+ paraList = para;
+ }
+ if (dataRadButtonStatus)
+ {
+ paraList = "-t" + " " + table.ToLower();
+ }
+
+ if (periodType.Equals("Daily"))
+ {
+ paraList += " " + "-d" + " " + period;
+ }
+ else if (periodType.Equals("Monthly"))
+ {
+ paraList += " " + "-m" + " " + period;
+ }
+ else if (periodType.Equals("Quarterly"))
+ {
+ paraList += " " + "-q" + " " + period;
+ }
+ else
+ {
+ paraList += " " + "-y" + " " + period;
+ }
+
+ paraList += " " + "-s" + " " + set.nMC;
+
+ fullArg = set.nodes + " " + "-a" + " " + ticket + " " +
path + " " + paraList;
+
+
+ result = new ClientEngine().ExecuteJob(fullArg);
+ try
+ {
+ lock (listView1)
+ {
+ listView1.Items.Remove(item);
+ }
+
+ }
+ catch(Exception)
+ { }
+
+ string[] rCategiries = result.Split(new Char[] { ':' });
+
+
+ if (rCategiries.Length == 1)
+ {
+ if (rCategiries[0] == "")
+ {
+ MessageBox.Show("Contact Cluster Administrator");
+ }
+ else
+ {
+ string[] error = rCategiries[0].Split(new Char[]
{ ',' });
+ try
+ {
+ MessageBox.Show(error[1]);
+ }
+ catch (System.Exception)
+ {
+ MessageBox.Show("Contact Cluster
Administrator");
+ }
+
+ }
+
+ }
+ else if (rCategiries.Length == 2)
+ {
+
+ string title = "Model:" + " " + model + "," +
periodType + ":" + " " + period + "," + "Simulations:" + " " + set.nMC
+ "," + "Nodes:" + " " + set.nodes;
+ string data = "Manual";
+ if (dataRadButtonStatus)
+ {
+ data = table;
+ }
+ title += "," + "Data:" + " " + data;
+ DrawToSpreadSheet(result, title);
+
+ }
+ else
+ {
+
+ MessageBox.Show("Contact Cluster Administrator");
+ }
+ }
+ catch (Exception)
+ {
+ MessageBox.Show("Contact Cluster Administrator");
+ }
+
+ }
+
+ /// <summary>
+ /// Validate parameters entered
+ /// </summary>
+ /// <returns>true/flase</returns>
+ private bool ValidateParameters()
+ {
+ try
+ {
+ string[] current = paraTextBox.Text.Split(new Char[] { ' '
});
+ string[] format = new
HPC_FinanceDBManager().GetParaTypes(modelComboBox.SelectedItem.ToString()).Split(new
Char[] { ',' });
+ if(format.Length == 0)
+ {
+ return true;
+ }
+ if(format.Length != current.Length)
+ {
+ return false;
+ }
+
+ for(int i = 0; i < format.Length ; i++)
+ {
+ if(format[i].Equals("double"))
+ {
+ double d = Convert.ToDouble(current[i]);
+ }
+ if(format[i].Equals("int"))
+ {
+ int ii = Convert.ToInt32(current[i]);
+ }
+ }
+
+ double temp = Convert.ToDouble(periodTextBox.Text);
+ }
+ catch (System.Exception)
+ {
+ return false;
+ }
+ return true;
+ }
+
+ /// <summary>
+ /// Draw the final result in a spreadsheet
+ /// </summary>
+ /// <param name="result">result returned from server</param>
+ /// <param name="title">meta data</param>
+ private void DrawToSpreadSheet(string result, string title)
+ {
+ string[] results = result.Split(new Char[] { ':' });
+
+ Microsoft.Office.Interop.Excel.Worksheet ws;
+
+ if (Globals.ThisAddIn.Application.Workbooks.Count == 0)
+ {
+ Microsoft.Office.Interop.Excel.Workbook wb =
Globals.ThisAddIn.Application.Workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
+ ws =
(Microsoft.Office.Interop.Excel.Worksheet)wb.ActiveSheet;
+ }
+ else
+ {
+ ws =
(Microsoft.Office.Interop.Excel.Worksheet)Globals.ThisAddIn.Application.ActiveWorkbook.Worksheets.Add(Type.Missing,
Type.Missing, Type.Missing,
Microsoft.Office.Interop.Excel.XlSheetType.xlWorksheet);
+ }
+
+ ws.Cells[1, 1] = "Time";
+ ws.Cells[1, 2] = "Value";
+
+ string[] titles = title.Split(new Char[] { ',' });
+ if (titles.Length == 5)
+ {
+ ws.Cells[1, 4] = titles[0];
+ ws.Cells[1, 7] = titles[1];
+ ws.Cells[1, 10] = titles[2];
+ ws.Cells[2, 4] = titles[3];
+ ws.Cells[2, 7] = titles[4];
+ }
+
+ string[] values = results[1].Split(new Char[] { ',' });
+
+ int paramCell = 0;
+ double xUnit = 0;
+ if (titles.Length == 5)
+ {
+ string[] periodArray = titles[1].Split(new Char[] { ':' });
+ if (periodArray.Length == 2)
+ {
+ try
+ {
+ double d = Convert.ToDouble(periodArray[1]);
+ xUnit = d / (values.Length - 1);
+ }
+ catch { }
+ }
+ }
+
+ string periodType = "";
+ if (titles.Length == 5)
+ {
+ string[] periodTypeArray = titles[1].Split(new Char[]
{ ':' });
+ if (periodTypeArray.Length == 2)
+ {
+ periodType = periodTypeArray[0];
+ }
+ }
+
+
+ for (int i = 1; i < values.Length; i++)
+ {
+ double d = i * xUnit;
+ ws.Cells[i + 1, 1] = d.ToString();
+ ws.Cells[i + 1, 2] = values[i];
+
+ paramCell = i + 4;
+ }
+
+ string[] paras = results[0].Split(new Char[] { ',' });
+ for (int i = 1; i < paras.Length; i++)
+ {
+ string[] temp = paras[i].Split(new Char[] { '=' });
+ ws.Cells[paramCell, 1] = temp[0];
+ ws.Cells[paramCell, 2] = temp[1];
+ paramCell++;
+ }
+
+ paramCell = 0;
+
+ if (values.Length > 2)
+ {
+
+
+ Microsoft.Office.Interop.Excel.ChartObjects charts =
(Microsoft.Office.Interop.Excel.ChartObjects)ws.ChartObjects(Type.Missing);
+ Microsoft.Office.Interop.Excel.ChartObject chart =
charts.Add(110, 40, 600, 300);
+ Microsoft.Office.Interop.Excel.Chart xlChart = chart.Chart;
+ Microsoft.Office.Interop.Excel.Range rg;
+ int end = values.Length + 1;
+ rg = ws.get_Range("A2", "B" + end.ToString());
+
+
+ xlChart.Legend.Clear();
+
+ Microsoft.Office.Interop.Excel.Axis x;
+ x =
(Microsoft.Office.Interop.Excel.Axis)xlChart.Axes(Microsoft.Office.Interop.Excel.XlAxisType.xlCategory,
Microsoft.Office.Interop.Excel.XlAxisGroup.xlPrimary);
+ x.HasTitle = true;
+ x.AxisTitle.Text = "Time" + "(" + periodType + ")";
+
+ Microsoft.Office.Interop.Excel.Axis y;
+ y =
(Microsoft.Office.Interop.Excel.Axis)xlChart.Axes(Microsoft.Office.Interop.Excel.XlAxisType.xlValue,
Microsoft.Office.Interop.Excel.XlAxisGroup.xlPrimary);
+ y.HasTitle = true;
+ y.AxisTitle.Text = "Estimated Value";
+
+ xlChart.ChartType =
Microsoft.Office.Interop.Excel.XlChartType.xlXYScatterLinesNoMarkers;
+ xlChart.SetSourceData(rg, Type.Missing);
+
+ Microsoft.Office.Interop.Excel.Series s =
(Microsoft.Office.Interop.Excel.Series)xlChart.SeriesCollection(1);
+ s.Format.Line.Weight = (float)0.25;
+ s.MarkerStyle =
Microsoft.Office.Interop.Excel.XlMarkerStyle.xlMarkerStyleNone;
+ }
+ }
+
+ /// <summary>
+ /// Event modelComboBox_SelectedIndexChanged
+ /// </summary>
+ /// <param name="sender">sender</param>
+ /// <param name="e">event arguments</param>
+ private void modelComboBox_SelectedIndexChanged(object sender,
EventArgs e)
+ {
+ PopulateWithParaFormat(this.paraFormatTextBox,
this.modelComboBox.SelectedItem.ToString());
+ }
+
+ /// <summary>
+ /// Event executeButton_Click
+ /// </summary>
+ /// <param name="sender">sender</param>
+ /// <param name="e">event arguments</param>
+ private void executeButton_Click(object sender, EventArgs e)
+ {
+
+ if (usingParaRadioButton.Checked)
+ {
+ if(!ValidateParameters())
+ {
+ MessageBox.Show("Parameters Invalid!");
+ return;
+ }
+
+ }
+
+ if(!ValidatePeriods())
+ {
+ MessageBox.Show("Time Step Not Compatible!");
+ return;
+ }
+
+
+ try
+ {
+ double d = Convert.ToDouble(periodTextBox.Text);
+ }
+ catch (Exception)
+ {
+ MessageBox.Show("Period Invalid!");
+ periodTextBox.Clear();
+ return;
+ }
+
+ //ExecuteWorker();
+ try
+ {
+ new Thread(new ThreadStart(this.ExecuteWorker)).Start();
+ }
+ catch (ThreadStartException)
+ { }
+ catch (InvalidOperationException)
+ { }
+ catch (SecurityException)
+ { }
+ catch (OutOfMemoryException)
+ { }
+ }
+
+ /// <summary>
+ /// Validating time step compatibility
+ /// </summary>
+ /// <returns>bool</returns>
+ private bool ValidatePeriods()
+ {
+ try
+ {
+ int per = int.Parse(periodTextBox.Text);
+ string periodType =
periodTypeComboBox.SelectedItem.ToString();
+ string periodType2 =
periodTypeComboBox2.SelectedItem.ToString();
+ double factor1, factor2;
+ if (periodType.Equals("Daily"))
+ {
+ factor1 = 252;
+ }
+ else if (periodType.Equals("Monthly"))
+ {
+ factor1 = 12;
+ }
+ else if (periodType.Equals("Quarterly"))
+ {
+ factor1 = 4;
+ }
+ else
+ {
+ factor1 = 1;
+ }
+ if (periodType2.Equals("Days"))
+ {
+ factor2 = 252;
+ }
+ else if (periodType2.Equals("Months"))
+ {
+ factor2 = 12;
+ }
+ else if (periodType2.Equals("Quarters"))
+ {
+ factor2 = 4;
+ }
+ else
+ {
+ factor2 = 1;
+ }
+
+ if (factor1 * per / factor2 < 1)
+ {
+ return false;
+ }
+ return true;
+ }
+ catch (System.Exception)
+ {
+ return false;
+ }
+
+ }
+
+ /// <summary>
+ /// Event ratesRadioButton_CheckedChanged
+ /// </summary>
+ /// <param name="sender">sender</param>
+ /// <param name="e">event arguments</param>
+ private void ratesRadioButton_CheckedChanged(object sender,
EventArgs e)
+ {
+ if (ratesRadioButton.Checked)
+ {
+ rateTypesComboBox.Enabled = true;
+ identifier.Enabled = false;
+ }
+ }
+
+ /// <summary>
+ /// Event quotesRadioButton_CheckedChanged
+ /// </summary>
+ /// <param name="sender">sender</param>
+ /// <param name="e">event arguments</param>
+ private void quotesRadioButton_CheckedChanged(object sender,
EventArgs e)
+ {
+ if (quotesRadioButton.Checked)
+ {
+ rateTypesComboBox.Enabled = false;
+ identifier.Enabled = true;
+ }
+ }
+
+ /// <summary>
+ /// Event endJobButton_Click
+ /// </summary>
+ /// <param name="sender">sender</param>
+ /// <param name="e">event arguments</param>
+ private void endJobButton_Click(object sender, EventArgs e)
+ {
+ try
+ {
+ new Thread(new ThreadStart(this.KillJobWorker)).Start();
+ }
+ catch (ThreadStartException)
+ { }
+ catch (InvalidOperationException)
+ { }
+ catch (SecurityException)
+ { }
+ catch (OutOfMemoryException)
+ { }
+ }
+
+ /// <summary>
+ /// Worker procedure for thread kill operation
+ /// </summary>
+ private void KillJobWorker()
+ {
+ try
+ {
+ string key;
+ lock (listView1)
+ {
+ key = listView1.SelectedItems[0].SubItems[0].Text;
+ listView1.SelectedItems[0].Remove();
+ }
+ string args = "mpdkilljob -a " + key;
+ new ClientEngine().KillJob(args);
+ }
+ catch (Exception)
+ { }
+ }
+
+ }
+}
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/Finance.resx Sun Jan 17 01:18:44 2010
@@ -0,0 +1,144 @@
+
+
+<?xml version="1.0" encoding="utf-8"?>
+<root>
+ 
+ <xsd:schema id="root" xmlns=""
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
+ <xsd:import namespace="http://www.w3.org/XML/1998/namespace" />
+ <xsd:element name="root" msdata:IsDataSet="true">
+ <xsd:complexType>
+ <xsd:choice maxOccurs="unbounded">
+ <xsd:element name="metadata">
+ <xsd:complexType>
+ <xsd:sequence>
+ <xsd:element name="value" type="xsd:string" minOccurs="0"
/>
+ </xsd:sequence>
+ <xsd:attribute name="name" use="required" type="xsd:string"
/>
+ <xsd:attribute name="type" type="xsd:string" />
+ <xsd:attribute name="mimetype" type="xsd:string" />
+ <xsd:attribute ref="xml:space" />
+ </xsd:complexType>
+ </xsd:element>
+ <xsd:element name="assembly">
+ <xsd:complexType>
+ <xsd:attribute name="alias" type="xsd:string" />
+ <xsd:attribute name="name" type="xsd:string" />
+ </xsd:complexType>
+ </xsd:element>
+ <xsd:element name="data">
+ <xsd:complexType>
+ <xsd:sequence>
+ <xsd:element name="value" type="xsd:string" minOccurs="0"
msdata:Ordinal="1" />
+ <xsd:element name="comment" type="xsd:string"
minOccurs="0" msdata:Ordinal="2" />
+ </xsd:sequence>
+ <xsd:attribute name="name" type="xsd:string" use="required"
msdata:Ordinal="1" />
+ <xsd:attribute name="type" type="xsd:string"
msdata:Ordinal="3" />
+ <xsd:attribute name="mimetype" type="xsd:string"
msdata:Ordinal="4" />
+ <xsd:attribute ref="xml:space" />
+ </xsd:complexType>
+ </xsd:element>
+ <xsd:element name="resheader">
+ <xsd:complexType>
+ <xsd:sequence>
+ <xsd:element name="value" type="xsd:string" minOccurs="0"
msdata:Ordinal="1" />
+ </xsd:sequence>
+ <xsd:attribute name="name" type="xsd:string" use="required"
/>
+ </xsd:complexType>
+ </xsd:element>
+ </xsd:choice>
+ </xsd:complexType>
+ </xsd:element>
+ </xsd:schema>
+ <resheader name="resmimetype">
+ <value>text/microsoft-resx</value>
+ </resheader>
+ <resheader name="version">
+ <value>2.0</value>
+ </resheader>
+ <resheader name="reader">
+ <value>System.Resources.ResXResourceReader, System.Windows.Forms,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
+ </resheader>
+ <resheader name="writer">
+ <value>System.Resources.ResXResourceWriter, System.Windows.Forms,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
+ </resheader>
+ <metadata name="openFileDialog.TrayLocation" type="System.Drawing.Point,
System.Drawing, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a">
+ <value>17, 17</value>
+ </metadata>
+</root>
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/HPC4FinanceDBManager.cs Sun Jan 17 01:18:44
2010
@@ -0,0 +1,157 @@
+/*
+ Copyright (c) 2008 by contributors:
+
+ * Damitha Premadasa
+ * Nilendra Weerasinghe
+ * Thilina Dampahala
+ * Waruna Ranasinghe - (http://warunapw.blogspot.com)
+
+ Licensed under the Apache License, Version 2.0 (the "License");
+ you may not use this file except in compliance with the License.
+ You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+*/
+
+using System;
+using System.Collections.Generic;
+using System.Text;
+using MySql.Data.MySqlClient;
+using System.Configuration;
+using XClient.Properties;
+
+class HPC_FinanceDBManager
+{
+ Settings set = Settings.Default;
+
+ /// <summary>
+ /// Get available financial models
+ /// </summary>
+ /// <returns>List of Models</returns>
+ public List<string> GetModels()
+ {
+ List<string> list = new List<string>();
+ MySqlConnection connection = new
MySqlConnection(set.mnConnectionString);
+ MySqlDataReader reader;
+ try
+ {
+ connection.Open();
+
+ string queryString = "select distinct name from model";
+ MySqlCommand command = new MySqlCommand(queryString);
+ command.Connection = connection;
+ reader = command.ExecuteReader();
+
+ while (reader.Read())
+ {
+ list.Add(reader[0].ToString());
+ }
+ reader.Close();
+ }
+ catch (Exception)
+ {
+ }
+ finally
+ {
+ connection.Close();
+ }
+ return list;
+ }
+
+ /// <summary>
+ /// Get the path in the server of a corresponding model
+ /// </summary>
+ /// <param name="name">mane of the model</param>
+ /// <returns>path</returns>
+ public string GetPath(string name)
+ {
+ string path = null;
+ MySqlConnection connection = new
MySqlConnection(set.mnConnectionString);
+ try
+ {
+ connection.Open();
+
+ string queryString = "select path from model where name = '" +
name + "'";
+ MySqlCommand command = new MySqlCommand(queryString);
+ command.Connection = connection;
+ path = (string)command.ExecuteScalar();
+
+ }
+ catch (Exception ex)
+ {
+ throw ex;
+ }
+ finally
+ {
+ connection.Close();
+ }
+ return path;
+ }
+
+ /// <summary>
+ /// Get list of parameters for a particular model
+ /// </summary>
+ /// <param name="name">model</param>
+ /// <returns>comma seperated parameters</returns>
+ public string GetParaList(string name)
+ {
+ string paraList = null;
+ MySqlConnection connection = new
MySqlConnection(set.mnConnectionString);
+ try
+ {
+ connection.Open();
+
+ string queryString = "select parameters from model where name
= '" + name + "'";
+ MySqlCommand command = new MySqlCommand(queryString);
+ command.Connection = connection;
+ paraList = (string)command.ExecuteScalar();
+
+ }
+ catch (Exception)
+ {
+ }
+ finally
+ {
+ connection.Close();
+ }
+ return paraList;
+ }
+
+ /// <summary>
+ /// Get parameter format foe a partucular model
+ /// </summary>
+ /// <param name="name">model</param>
+ /// <returns>comma seperated prameter types</returns>
+ public string GetParaTypes(string name)
+ {
+ string paraList = null;
+ MySqlConnection connection = new
MySqlConnection(set.mnConnectionString);
+ try
+ {
+ connection.Open();
+
+ string queryString = "select paratype from model where name
= '" + name + "'";
+ MySqlCommand command = new MySqlCommand(queryString);
+ command.Connection = connection;
+ paraList = (string)command.ExecuteScalar();
+
+ }
+ catch (Exception)
+ {
+ }
+ finally
+ {
+ connection.Close();
+ }
+ return paraList;
+ }
+
+}
+
+
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/Properties/AssemblyInfo.cs Sun Jan 17
01:18:44 2010
@@ -0,0 +1,54 @@
+/*
+ Copyright (c) 2008 by contributors:
+
+ * Damitha Premadasa
+ * Nilendra Weerasinghe
+ * Thilina Dampahala
+ * Waruna Ranasinghe - (http://warunapw.blogspot.com)
+
+ Licensed under the Apache License, Version 2.0 (the "License");
+ you may not use this file except in compliance with the License.
+ You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+*/
+
+using System.Reflection;
+using System.Runtime.CompilerServices;
+using System.Runtime.InteropServices;
+
+// General Information about an assembly is controlled through the
following
+// set of attributes. Change these attribute values to modify the
information
+// associated with an assembly.
+[assembly: AssemblyTitle("XClient")]
+[assembly: AssemblyDescription("")]
+[assembly: AssemblyConfiguration("")]
+[assembly: AssemblyCompany("HPC4Finance")]
+[assembly: AssemblyProduct("XClient")]
+[assembly: AssemblyCopyright("Copyright © HPC4Finance Contributers 2008")]
+[assembly: AssemblyTrademark("")]
+[assembly: AssemblyCulture("")]
+
+// Setting ComVisible to false makes the types in this assembly not visible
+// to COM components. If you need to access a type in this assembly from
+// COM, set the ComVisible attribute to true on that type.
+[assembly: ComVisible(false)]
+
+// The following GUID is for the ID of the typelib if this project is
exposed to COM
+[assembly: Guid("3b6c4c88-dfad-4249-ac00-1d7b88df9da0")]
+
+// Version information for an assembly consists of the following four
values:
+//
+// Major Version
+// Minor Version
+// Build Number
+// Revision
+//
+[assembly: AssemblyVersion("1.0.0.0")]
+[assembly: AssemblyFileVersion("1.0.0.0")]
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/Properties/Resources.resx Sun Jan 17
01:18:44 2010
@@ -0,0 +1,142 @@
+
+
+<?xml version="1.0" encoding="utf-8"?>
+<root>
+ 
+ <xsd:schema id="root" xmlns=""
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
+ <xsd:import namespace="http://www.w3.org/XML/1998/namespace" />
+ <xsd:element name="root" msdata:IsDataSet="true">
+ <xsd:complexType>
+ <xsd:choice maxOccurs="unbounded">
+ <xsd:element name="metadata">
+ <xsd:complexType>
+ <xsd:sequence>
+ <xsd:element name="value" type="xsd:string" minOccurs="0"
/>
+ </xsd:sequence>
+ <xsd:attribute name="name" use="required" type="xsd:string"
/>
+ <xsd:attribute name="type" type="xsd:string" />
+ <xsd:attribute name="mimetype" type="xsd:string" />
+ <xsd:attribute ref="xml:space" />
+ </xsd:complexType>
+ </xsd:element>
+ <xsd:element name="assembly">
+ <xsd:complexType>
+ <xsd:attribute name="alias" type="xsd:string" />
+ <xsd:attribute name="name" type="xsd:string" />
+ </xsd:complexType>
+ </xsd:element>
+ <xsd:element name="data">
+ <xsd:complexType>
+ <xsd:sequence>
+ <xsd:element name="value" type="xsd:string" minOccurs="0"
msdata:Ordinal="1" />
+ <xsd:element name="comment" type="xsd:string"
minOccurs="0" msdata:Ordinal="2" />
+ </xsd:sequence>
+ <xsd:attribute name="name" type="xsd:string" use="required"
msdata:Ordinal="1" />
+ <xsd:attribute name="type" type="xsd:string"
msdata:Ordinal="3" />
+ <xsd:attribute name="mimetype" type="xsd:string"
msdata:Ordinal="4" />
+ <xsd:attribute ref="xml:space" />
+ </xsd:complexType>
+ </xsd:element>
+ <xsd:element name="resheader">
+ <xsd:complexType>
+ <xsd:sequence>
+ <xsd:element name="value" type="xsd:string" minOccurs="0"
msdata:Ordinal="1" />
+ </xsd:sequence>
+ <xsd:attribute name="name" type="xsd:string" use="required"
/>
+ </xsd:complexType>
+ </xsd:element>
+ </xsd:choice>
+ </xsd:complexType>
+ </xsd:element>
+ </xsd:schema>
+ <resheader name="resmimetype">
+ <value>text/microsoft-resx</value>
+ </resheader>
+ <resheader name="version">
+ <value>2.0</value>
+ </resheader>
+ <resheader name="reader">
+ <value>System.Resources.ResXResourceReader, System.Windows.Forms,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
+ </resheader>
+ <resheader name="writer">
+ <value>System.Resources.ResXResourceWriter, System.Windows.Forms,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
+ </resheader>
+ <assembly alias="System.Windows.Forms" name="System.Windows.Forms,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
+</root>
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/Properties/Settings.settings Sun Jan 17
01:18:44 2010
@@ -0,0 +1,60 @@
+
+
+<?xml version='1.0' encoding='utf-8'?>
+<SettingsFile
xmlns="http://schemas.microsoft.com/VisualStudio/2004/01/settings"
CurrentProfile="(Default)" GeneratedClassNamespace="XClient.Properties"
GeneratedClassName="Settings">
+ <Profiles />
+ <Settings>
+ <Setting Name="XClient_com_xignite_www_XigniteHistorical" Type="(Web
Service URL)" Scope="Application">
+ <Value
Profile="(Default)">http://www.xignite.com/xHistorical.asmx</Value>
+ </Setting>
+ <Setting Name="XClient_com_xignite_XigniteRates" Type="(Web Service
URL)" Scope="Application">
+ <Value Profile="(Default)">https://xignite.com/xRates.asmx</Value>
+ </Setting>
+ <Setting Name="mnConnectionString" Type="System.String" Scope="User">
+ <Value Profile="(Default)" />
+ </Setting>
+ <Setting Name="dataConnectionString" Type="System.String" Scope="User">
+ <Value Profile="(Default)" />
+ </Setting>
+ <Setting Name="mnIP" Type="System.String" Scope="User">
+ <Value Profile="(Default)" />
+ </Setting>
+ <Setting Name="mnServicePort" Type="System.String" Scope="User">
+ <Value Profile="(Default)" />
+ </Setting>
+ <Setting Name="username" Type="System.String" Scope="User">
+ <Value Profile="(Default)" />
+ </Setting>
+ <Setting Name="password" Type="System.String" Scope="User">
+ <Value Profile="(Default)" />
+ </Setting>
+ <Setting Name="nMC" Type="System.String" Scope="User">
+ <Value Profile="(Default)">50000</Value>
+ </Setting>
+ <Setting Name="nodes" Type="System.String" Scope="User">
+ <Value Profile="(Default)">1</Value>
+ </Setting>
+ <Setting Name="background" Type="System.String" Scope="User">
+ <Value Profile="(Default)">false</Value>
+ </Setting>
+ </Settings>
+</SettingsFile>
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/Ribbon.cs Sun Jan 17 01:18:44 2010
@@ -0,0 +1,125 @@
+/*
+ Copyright (c) 2008 by contributors:
+
+ * Damitha Premadasa
+ * Nilendra Weerasinghe
+ * Thilina Dampahala
+ * Waruna Ranasinghe - (http://warunapw.blogspot.com)
+
+ Licensed under the Apache License, Version 2.0 (the "License");
+ you may not use this file except in compliance with the License.
+ You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+*/
+
+using System;
+using System.Collections.Generic;
+using System.Diagnostics;
+using System.IO;
+using System.Text;
+using System.Reflection;
+using System.Runtime.InteropServices;
+using System.Windows.Forms;
+using Office = Microsoft.Office.Core;
+
+namespace XClient
+{
+ // This is an override of the RequestService method in the ThisAddIn
class.
+ public partial class ThisAddIn
+ {
+ private Ribbon ribbon;
+
+
+ protected override object RequestService(Guid serviceGuid)
+ {
+ if (serviceGuid == typeof(Office.IRibbonExtensibility).GUID)
+ {
+ if (ribbon == null)
+ ribbon = new Ribbon();
+ return ribbon;
+ }
+
+ return base.RequestService(serviceGuid);
+ }
+ }
+
+ [ComVisible(true)]
+ public class Ribbon : Office.IRibbonExtensibility
+ {
+ private Office.IRibbonUI ribbon;
+
+ public Ribbon()
+ {
+ }
+
+ #region IRibbonExtensibility Members
+
+ public string GetCustomUI(string ribbonID)
+ {
+ return GetResourceText("XClient.Ribbon.xml");
+ }
+
+ #endregion
+
+ #region Ribbon Callbacks
+
+ public void OnLoad(Office.IRibbonUI ribbonUI)
+ {
+ this.ribbon = ribbonUI;
+ }
+
+ public void OnButton1(Office.IRibbonControl control)
+ {
+ new DatabaseSettingsForm().ShowDialog();
+ }
+
+ public void OnButton2(Office.IRibbonControl control)
+ {
+ new ServerSetingsForm().ShowDialog();
+ }
+
+ public void OnButton3(Office.IRibbonControl control)
+ {
+ new WSSettingsForm().ShowDialog();
+ }
+
+ public void OnButton4(Office.IRibbonControl control)
+ {
+ new SimulationSettingsForm().ShowDialog();
+ }
+
+
+ #endregion
+
+ #region Helpers
+
+ private static string GetResourceText(string resourceName)
+ {
+ Assembly asm = Assembly.GetExecutingAssembly();
+ string[] resourceNames = asm.GetManifestResourceNames();
+ for (int i = 0; i < resourceNames.Length; ++i)
+ {
+ if (string.Compare(resourceName, resourceNames[i],
StringComparison.OrdinalIgnoreCase) == 0)
+ {
+ using (StreamReader resourceReader = new
StreamReader(asm.GetManifestResourceStream(resourceNames[i])))
+ {
+ if (resourceReader != null)
+ {
+ return resourceReader.ReadToEnd();
+ }
+ }
+ }
+ }
+ return null;
+ }
+
+ #endregion
+ }
+}
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/Ribbon.xml Sun Jan 17 01:18:44 2010
@@ -0,0 +1,65 @@
+
+
+<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"
onLoad="OnLoad">
+ <ribbon>
+ <tabs>
+ <tab idMso="TabAddIns" label="HPC4Finance">
+ <group id="DatabaseSettings"
+ label="Database Settings">
+ <button id="button1"
+ size="large"
+ label="Edit Database Settings"
+ screentip="Edit Database Settings"
+ onAction="OnButton1"
+ imageMso="DatabaseAccessBackEnd"/>
+ </group>
+ <group id="ServerSettings"
+ label="Server Settings">
+ <button id="button2"
+ size="large"
+ label="Edit Server Settings"
+ screentip="Edit Server Settings"
+ onAction="OnButton2"
+ imageMso="OrganizationChartLayoutStandard"/>
+ </group>
+ <group id="WSSettings"
+ label="WS Settings">
+ <button id="button3"
+ size="large"
+ label="Edit WS Settings"
+ screentip="Edit WS Settings"
+ onAction="OnButton3"
+ imageMso="XmlImport"/>
+ </group>
+ <group id="SilulationSettings"
+ label="Simulation Settings">
+ <button id="button4"
+ size="large"
+ label="Edit Simulation Settings"
+ screentip="Edit Simulation Settings"
+ onAction="OnButton4"
+ imageMso="ObjectsArrangeBottom"/>
+ </group>
+ </tab>
+ </tabs>
+ </ribbon>
+</customUI>
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/ServerSetingsForm.Designer.cs Sun Jan 17
01:18:44 2010
@@ -0,0 +1,130 @@
+/*
+ Copyright (c) 2008 by contributors:
+
+ * Damitha Premadasa
+ * Nilendra Weerasinghe
+ * Thilina Dampahala
+ * Waruna Ranasinghe - (http://warunapw.blogspot.com)
+
+ Licensed under the Apache License, Version 2.0 (the "License");
+ you may not use this file except in compliance with the License.
+ You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+*/
+
+namespace XClient
+{
+ partial class ServerSetingsForm
+ {
+ /// <summary>
+ /// Required designer variable.
+ /// </summary>
+ private System.ComponentModel.IContainer components = null;
+
+ /// <summary>
+ /// Clean up any resources being used.
+ /// </summary>
+ /// <param name="disposing">true if managed resources should be
disposed; otherwise, false.</param>
+ protected override void Dispose(bool disposing)
+ {
+ if (disposing && (components != null))
+ {
+ components.Dispose();
+ }
+ base.Dispose(disposing);
+ }
+
+ #region Windows Form Designer generated code
+
+ /// <summary>
+ /// Required method for Designer support - do not modify
+ /// the contents of this method with the code editor.
+ /// </summary>
+ private void InitializeComponent()
+ {
+ this.label1 = new System.Windows.Forms.Label();
+ this.label2 = new System.Windows.Forms.Label();
+ this.textBox1 = new System.Windows.Forms.TextBox();
+ this.textBox2 = new System.Windows.Forms.TextBox();
+ this.button1 = new System.Windows.Forms.Button();
+ this.SuspendLayout();
+ //
+ // label1
+ //
+ this.label1.AutoSize = true;
+ this.label1.Location = new System.Drawing.Point(12, 9);
+ this.label1.Name = "label1";
+ this.label1.Size = new System.Drawing.Size(79, 13);
+ this.label1.TabIndex = 0;
+ this.label1.Text = "Server Address";
+ //
+ // label2
+ //
+ this.label2.AutoSize = true;
+ this.label2.Location = new System.Drawing.Point(12, 60);
+ this.label2.Name = "label2";
+ this.label2.Size = new System.Drawing.Size(65, 13);
+ this.label2.TabIndex = 1;
+ this.label2.Text = "Service Port";
+ //
+ // textBox1
+ //
+ this.textBox1.Location = new System.Drawing.Point(15, 25);
+ this.textBox1.Name = "textBox1";
+ this.textBox1.Size = new System.Drawing.Size(257, 20);
+ this.textBox1.TabIndex = 2;
+ //
+ // textBox2
+ //
+ this.textBox2.Location = new System.Drawing.Point(15, 76);
+ this.textBox2.Name = "textBox2";
+ this.textBox2.Size = new System.Drawing.Size(257, 20);
+ this.textBox2.TabIndex = 3;
+ //
+ // button1
+ //
+ this.button1.Location = new System.Drawing.Point(197, 106);
+ this.button1.Name = "button1";
+ this.button1.Size = new System.Drawing.Size(75, 23);
+ this.button1.TabIndex = 4;
+ this.button1.Text = "Save";
+ this.button1.UseVisualStyleBackColor = true;
+ this.button1.Click += new
System.EventHandler(this.button1_Click);
+ //
+ // ServerSetingsForm
+ //
+ this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
+ this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
+ this.ClientSize = new System.Drawing.Size(284, 142);
+ this.Controls.Add(this.button1);
+ this.Controls.Add(this.textBox2);
+ this.Controls.Add(this.textBox1);
+ this.Controls.Add(this.label2);
+ this.Controls.Add(this.label1);
+ this.FormBorderStyle =
System.Windows.Forms.FormBorderStyle.FixedDialog;
+ this.Name = "ServerSetingsForm";
+ this.ShowInTaskbar = false;
+ this.StartPosition =
System.Windows.Forms.FormStartPosition.CenterScreen;
+ this.Text = "Service Settings";
+ this.Load += new
System.EventHandler(this.ServerSetingsForm_Load);
+ this.ResumeLayout(false);
+ this.PerformLayout();
+
+ }
+
+ #endregion
+
+ private System.Windows.Forms.Label label1;
+ private System.Windows.Forms.Label label2;
+ private System.Windows.Forms.TextBox textBox1;
+ private System.Windows.Forms.TextBox textBox2;
+ private System.Windows.Forms.Button button1;
+ }
+}
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/ServerSetingsForm.cs Sun Jan 17 01:18:44
2010
@@ -0,0 +1,85 @@
+/*
+ Copyright (c) 2008 by contributors:
+
+ * Damitha Premadasa
+ * Nilendra Weerasinghe
+ * Thilina Dampahala
+ * Waruna Ranasinghe - (http://warunapw.blogspot.com)
+
+ Licensed under the Apache License, Version 2.0 (the "License");
+ you may not use this file except in compliance with the License.
+ You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+*/
+
+using System;
+using System.Collections.Generic;
+using System.ComponentModel;
+using System.Data;
+using System.Drawing;
+using System.Text;
+using System.Windows.Forms;
+using System.Configuration;
+using XClient.Properties;
+
+namespace XClient
+{
+ public partial class ServerSetingsForm : Form
+ {
+ /// <summary>
+ /// COnstructor
+ /// </summary>
+ public ServerSetingsForm()
+ {
+ InitializeComponent();
+ }
+
+ /// <summary>
+ /// Event ServerSetingsForm_Load
+ /// </summary>
+ /// <param name="sender">sender</param>
+ /// <param name="e">event arguments</param>
+ private void ServerSetingsForm_Load(object sender, EventArgs e)
+ {
+ try
+ {
+ Settings set = Settings.Default;
+ textBox1.Text = set.mnIP;
+ textBox2.Text = set.mnServicePort;
+ }
+ catch (Exception)
+ {
+ }
+ }
+
+ /// <summary>
+ /// Event button1_Click
+ /// </summary>
+ /// <param name="sender">sender</param>
+ /// <param name="e">event arguments</param>
+ private void button1_Click(object sender, EventArgs e)
+ {
+ try
+ {
+ Settings set = Settings.Default;
+ set.mnIP = textBox1.Text;
+ set.mnServicePort =
Convert.ToInt32(textBox2.Text).ToString();
+ set.Save();
+
+ this.Close();
+ }
+ catch (Exception)
+ {
+ MessageBox.Show("Invalid Port Number!");
+ }
+ }
+
+ }
+}
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/ServerSetingsForm.resx Sun Jan 17 01:18:44
2010
@@ -0,0 +1,141 @@
+
+
+<?xml version="1.0" encoding="utf-8"?>
+<root>
+ 
+ <xsd:schema id="root" xmlns=""
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
+ <xsd:import namespace="http://www.w3.org/XML/1998/namespace" />
+ <xsd:element name="root" msdata:IsDataSet="true">
+ <xsd:complexType>
+ <xsd:choice maxOccurs="unbounded">
+ <xsd:element name="metadata">
+ <xsd:complexType>
+ <xsd:sequence>
+ <xsd:element name="value" type="xsd:string" minOccurs="0"
/>
+ </xsd:sequence>
+ <xsd:attribute name="name" use="required" type="xsd:string"
/>
+ <xsd:attribute name="type" type="xsd:string" />
+ <xsd:attribute name="mimetype" type="xsd:string" />
+ <xsd:attribute ref="xml:space" />
+ </xsd:complexType>
+ </xsd:element>
+ <xsd:element name="assembly">
+ <xsd:complexType>
+ <xsd:attribute name="alias" type="xsd:string" />
+ <xsd:attribute name="name" type="xsd:string" />
+ </xsd:complexType>
+ </xsd:element>
+ <xsd:element name="data">
+ <xsd:complexType>
+ <xsd:sequence>
+ <xsd:element name="value" type="xsd:string" minOccurs="0"
msdata:Ordinal="1" />
+ <xsd:element name="comment" type="xsd:string"
minOccurs="0" msdata:Ordinal="2" />
+ </xsd:sequence>
+ <xsd:attribute name="name" type="xsd:string" use="required"
msdata:Ordinal="1" />
+ <xsd:attribute name="type" type="xsd:string"
msdata:Ordinal="3" />
+ <xsd:attribute name="mimetype" type="xsd:string"
msdata:Ordinal="4" />
+ <xsd:attribute ref="xml:space" />
+ </xsd:complexType>
+ </xsd:element>
+ <xsd:element name="resheader">
+ <xsd:complexType>
+ <xsd:sequence>
+ <xsd:element name="value" type="xsd:string" minOccurs="0"
msdata:Ordinal="1" />
+ </xsd:sequence>
+ <xsd:attribute name="name" type="xsd:string" use="required"
/>
+ </xsd:complexType>
+ </xsd:element>
+ </xsd:choice>
+ </xsd:complexType>
+ </xsd:element>
+ </xsd:schema>
+ <resheader name="resmimetype">
+ <value>text/microsoft-resx</value>
+ </resheader>
+ <resheader name="version">
+ <value>2.0</value>
+ </resheader>
+ <resheader name="reader">
+ <value>System.Resources.ResXResourceReader, System.Windows.Forms,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
+ </resheader>
+ <resheader name="writer">
+ <value>System.Resources.ResXResourceWriter, System.Windows.Forms,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
+ </resheader>
+</root>
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/SimulationSettings.Designer.cs Sun Jan 17
01:18:44 2010
@@ -0,0 +1,132 @@
+/*
+ Copyright (c) 2008 by contributors:
+
+ * Damitha Premadasa
+ * Nilendra Weerasinghe
+ * Thilina Dampahala
+ * Waruna Ranasinghe - (http://warunapw.blogspot.com)
+
+ Licensed under the Apache License, Version 2.0 (the "License");
+ you may not use this file except in compliance with the License.
+ You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+*/
+
+namespace XClient
+{
+ partial class SimulationSettingsForm
+ {
+ /// <summary>
+ /// Required designer variable.
+ /// </summary>
+ private System.ComponentModel.IContainer components = null;
+
+ /// <summary>
+ /// Clean up any resources being used.
+ /// </summary>
+ /// <param name="disposing">true if managed resources should be
disposed; otherwise, false.</param>
+ protected override void Dispose(bool disposing)
+ {
+ if (disposing && (components != null))
+ {
+ components.Dispose();
+ }
+ base.Dispose(disposing);
+ }
+
+ #region Windows Form Designer generated code
+
+ /// <summary>
+ /// Required method for Designer support - do not modify
+ /// the contents of this method with the code editor.
+ /// </summary>
+ private void InitializeComponent()
+ {
+ this.button1 = new System.Windows.Forms.Button();
+ this.label1 = new System.Windows.Forms.Label();
+ this.textBox1 = new System.Windows.Forms.TextBox();
+ this.label2 = new System.Windows.Forms.Label();
+ this.textBox2 = new System.Windows.Forms.TextBox();
+ this.SuspendLayout();
+ //
+ // button1
+ //
+ this.button1.Location = new System.Drawing.Point(205, 112);
+ this.button1.Name = "button1";
+ this.button1.Size = new System.Drawing.Size(75, 23);
+ this.button1.TabIndex = 0;
+ this.button1.Text = "Save";
+ this.button1.UseVisualStyleBackColor = true;
+ this.button1.Click += new
System.EventHandler(this.button1_Click);
+ //
+ // label1
+ //
+ this.label1.AutoSize = true;
+ this.label1.Location = new System.Drawing.Point(12, 9);
+ this.label1.Name = "label1";
+ this.label1.Size = new System.Drawing.Size(172, 13);
+ this.label1.TabIndex = 1;
+ this.label1.Text = "Number of Monte Carlo Simulations";
+ //
+ // textBox1
+ //
+ this.textBox1.Location = new System.Drawing.Point(15, 25);
+ this.textBox1.Name = "textBox1";
+ this.textBox1.Size = new System.Drawing.Size(265, 20);
+ this.textBox1.TabIndex = 2;
+ //
+ // label2
+ //
+ this.label2.AutoSize = true;
+ this.label2.Location = new System.Drawing.Point(12, 57);
+ this.label2.Name = "label2";
+ this.label2.Size = new System.Drawing.Size(90, 13);
+ this.label2.TabIndex = 3;
+ this.label2.Text = "Number of Nodes";
+ //
+ // textBox2
+ //
+ this.textBox2.Location = new System.Drawing.Point(14, 77);
+ this.textBox2.Name = "textBox2";
+ this.textBox2.Size = new System.Drawing.Size(265, 20);
+ this.textBox2.TabIndex = 4;
+ //
+ // SimulationSettingsForm
+ //
+ this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
+ this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
+ this.ClientSize = new System.Drawing.Size(292, 146);
+ this.Controls.Add(this.textBox2);
+ this.Controls.Add(this.label2);
+ this.Controls.Add(this.textBox1);
+ this.Controls.Add(this.label1);
+ this.Controls.Add(this.button1);
+ this.FormBorderStyle =
System.Windows.Forms.FormBorderStyle.FixedDialog;
+ this.MaximizeBox = false;
+ this.MinimizeBox = false;
+ this.Name = "SimulationSettingsForm";
+ this.ShowInTaskbar = false;
+ this.StartPosition =
System.Windows.Forms.FormStartPosition.CenterScreen;
+ this.Text = "Simulation Settings";
+ this.Load += new
System.EventHandler(this.SimulationSettingsForm_Load);
+ this.ResumeLayout(false);
+ this.PerformLayout();
+
+ }
+
+ #endregion
+
+ private System.Windows.Forms.Button button1;
+ private System.Windows.Forms.Label label1;
+ private System.Windows.Forms.TextBox textBox1;
+ private System.Windows.Forms.Label label2;
+ private System.Windows.Forms.TextBox textBox2;
+ }
+}
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/SimulationSettings.cs Sun Jan 17 01:18:44
2010
@@ -0,0 +1,83 @@
+/*
+ Copyright (c) 2008 by contributors:
+
+ * Damitha Premadasa
+ * Nilendra Weerasinghe
+ * Thilina Dampahala
+ * Waruna Ranasinghe - (http://warunapw.blogspot.com)
+
+ Licensed under the Apache License, Version 2.0 (the "License");
+ you may not use this file except in compliance with the License.
+ You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+*/
+
+using System;
+using System.Collections.Generic;
+using System.ComponentModel;
+using System.Data;
+using System.Drawing;
+using System.Text;
+using System.Windows.Forms;
+using XClient.Properties;
+
+namespace XClient
+{
+ public partial class SimulationSettingsForm : Form
+ {
+ /// <summary>
+ /// Constructor
+ /// </summary>
+ public SimulationSettingsForm()
+ {
+ InitializeComponent();
+ }
+
+ /// <summary>
+ /// Event SimulationSettingsForm_Load
+ /// </summary>
+ /// <param name="sender">sender</param>
+ /// <param name="e">event arguments</param>
+ private void SimulationSettingsForm_Load(object sender, EventArgs
e)
+ {
+ try
+ {
+ Settings set = Settings.Default;
+ textBox1.Text = set.nMC;
+ textBox2.Text = set.nodes;
+ }
+ catch (Exception)
+ {
+ }
+ }
+
+ /// <summary>
+ /// Event button1_Click
+ /// </summary>
+ /// <param name="sender">sender</param>
+ /// <param name="e">event arguments</param>
+ private void button1_Click(object sender, EventArgs e)
+ {
+ try
+ {
+ Settings set = Settings.Default;
+ set.nMC = Convert.ToInt32(textBox1.Text).ToString();
+ set.nodes = Convert.ToInt32(textBox2.Text).ToString();
+ set.Save();
+
+ this.Close();
+ }
+ catch (Exception)
+ {
+ MessageBox.Show("Invalid Input Value!");
+ }
+ }
+ }
+}
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/SimulationSettings.resx Sun Jan 17 01:18:44
2010
@@ -0,0 +1,141 @@
+
+
+<?xml version="1.0" encoding="utf-8"?>
+<root>
+ 
+ <xsd:schema id="root" xmlns=""
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
+ <xsd:import namespace="http://www.w3.org/XML/1998/namespace" />
+ <xsd:element name="root" msdata:IsDataSet="true">
+ <xsd:complexType>
+ <xsd:choice maxOccurs="unbounded">
+ <xsd:element name="metadata">
+ <xsd:complexType>
+ <xsd:sequence>
+ <xsd:element name="value" type="xsd:string" minOccurs="0"
/>
+ </xsd:sequence>
+ <xsd:attribute name="name" use="required" type="xsd:string"
/>
+ <xsd:attribute name="type" type="xsd:string" />
+ <xsd:attribute name="mimetype" type="xsd:string" />
+ <xsd:attribute ref="xml:space" />
+ </xsd:complexType>
+ </xsd:element>
+ <xsd:element name="assembly">
+ <xsd:complexType>
+ <xsd:attribute name="alias" type="xsd:string" />
+ <xsd:attribute name="name" type="xsd:string" />
+ </xsd:complexType>
+ </xsd:element>
+ <xsd:element name="data">
+ <xsd:complexType>
+ <xsd:sequence>
+ <xsd:element name="value" type="xsd:string" minOccurs="0"
msdata:Ordinal="1" />
+ <xsd:element name="comment" type="xsd:string"
minOccurs="0" msdata:Ordinal="2" />
+ </xsd:sequence>
+ <xsd:attribute name="name" type="xsd:string" use="required"
msdata:Ordinal="1" />
+ <xsd:attribute name="type" type="xsd:string"
msdata:Ordinal="3" />
+ <xsd:attribute name="mimetype" type="xsd:string"
msdata:Ordinal="4" />
+ <xsd:attribute ref="xml:space" />
+ </xsd:complexType>
+ </xsd:element>
+ <xsd:element name="resheader">
+ <xsd:complexType>
+ <xsd:sequence>
+ <xsd:element name="value" type="xsd:string" minOccurs="0"
msdata:Ordinal="1" />
+ </xsd:sequence>
+ <xsd:attribute name="name" type="xsd:string" use="required"
/>
+ </xsd:complexType>
+ </xsd:element>
+ </xsd:choice>
+ </xsd:complexType>
+ </xsd:element>
+ </xsd:schema>
+ <resheader name="resmimetype">
+ <value>text/microsoft-resx</value>
+ </resheader>
+ <resheader name="version">
+ <value>2.0</value>
+ </resheader>
+ <resheader name="reader">
+ <value>System.Resources.ResXResourceReader, System.Windows.Forms,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
+ </resheader>
+ <resheader name="writer">
+ <value>System.Resources.ResXResourceWriter, System.Windows.Forms,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
+ </resheader>
+</root>
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/ThisAddIn.Designer.xml Sun Jan 17 01:18:44
2010
@@ -0,0 +1,25 @@
+
+
+<hostitem:hostItem hostitem:baseType="Microsoft.Office.Tools.AddIn"
hostitem:namespace="XClient" hostitem:className="ThisAddIn"
hostitem:identifier="ThisAddIn" hostitem:primaryCookie="AddIn"
hostitem:master="true" hostitem:startupIndex="0"
xmlns:hostitem="http://schemas.microsoft.com/2004/VisualStudio/Tools/Applications/HostItem.xsd">
+ <hostitem:hostObject hostitem:name="Application"
hostitem:identifier="Application"
hostitem:type="Microsoft.Office.Interop.Excel.Application"
hostitem:cookie="Application" hostitem:modifier="Internal" />
+ <hostitem:hostControl hostitem:name="CustomTaskPanes"
hostitem:identifier="CustomTaskPanes"
hostitem:type="Microsoft.Office.Tools.CustomTaskPaneCollection"
hostitem:primaryCookie="CustomTaskPanes" hostitem:modifier="Internal" />
+</hostitem:hostItem>
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/ThisAddIn.cs Sun Jan 17 01:18:44 2010
@@ -0,0 +1,70 @@
+/*
+ Copyright (c) 2008 by contributors:
+
+ * Damitha Premadasa
+ * Nilendra Weerasinghe
+ * Thilina Dampahala
+ * Waruna Ranasinghe - (http://warunapw.blogspot.com)
+
+ Licensed under the Apache License, Version 2.0 (the "License");
+ you may not use this file except in compliance with the License.
+ You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+*/
+
+using System;
+using System.Windows.Forms;
+using Microsoft.VisualStudio.Tools.Applications.Runtime;
+using Excel = Microsoft.Office.Interop.Excel;
+using Office = Microsoft.Office.Core;
+using Microsoft.Office.Tools;
+using Microsoft.Office.Core;
+
+namespace XClient
+{
+ public partial class ThisAddIn
+ {
+ Finance fControl;
+ Microsoft.Office.Tools.CustomTaskPane myPane;
+
+ private void ThisAddIn_Startup(object sender, System.EventArgs e)
+ {
+ #region VSTO generated code
+
+ this.Application =
(Excel.Application)Microsoft.Office.Tools.Excel.ExcelLocale1033Proxy.Wrap(typeof(Excel.Application),
this.Application);
+
+ #endregion
+ fControl = new Finance();
+ myPane = this.CustomTaskPanes.Add(fControl, "Finance");
+ myPane.Visible = true;
+
+ }
+
+ private void ThisAddIn_Shutdown(object sender, System.EventArgs e)
+ {
+ }
+
+ #region VSTO generated code
+
+ /// <summary>
+ /// Required method for Designer support - do not modify
+ /// the contents of this method with the code editor.
+ /// </summary>
+ private void InternalStartup()
+ {
+ this.Startup += new System.EventHandler(ThisAddIn_Startup);
+ this.Shutdown += new System.EventHandler(ThisAddIn_Shutdown);
+ }
+
+ #endregion
+
+
+ }
+}
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/WSIRFetcher.cs Sun Jan 17 01:18:44 2010
@@ -0,0 +1,97 @@
+/*
+ Copyright (c) 2008 by contributors:
+
+ * Damitha Premadasa
+ * Nilendra Weerasinghe
+ * Thilina Dampahala
+ * Waruna Ranasinghe - (http://warunapw.blogspot.com)
+
+ Licensed under the Apache License, Version 2.0 (the "License");
+ you may not use this file except in compliance with the License.
+ You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+*/
+
+using System;
+using System.Collections.Generic;
+using System.Text;
+using System.IO;
+using XClient.com.xignite;
+using System.Configuration;
+using XClient.Properties;
+
+class WSIRFetcher
+{
+ Settings set = Settings.Default;
+
+ /// <summary>
+ /// Get data entity list
+ /// </summary>
+ /// <param name="identifier">identufier</param>
+ /// <param name="startdate">start date</param>
+ /// <param name="enddate">end date</param>
+ /// <returns>HistoricalInterestRates</returns>
+ public HistoricalInterestRates GetDataEntityList(string identifier,
string startdate, string enddate)
+ {
+ XigniteRates historicalService = new XigniteRates();
+ Header header = new Header();
+ header.Username = set.username;
+ header.Password = set.password;
+
+ historicalService.HeaderValue = header;
+ HistoricalInterestRates historicalRates;
+
+ Type rateTypes = typeof(RateTypes);
+ try
+ {
+
+ historicalRates =
historicalService.GetHistoricalRates((RateTypes)Enum.Parse(rateTypes,
identifier), PeriodTypes.Monthly, startdate, enddate);
+ //if (historicalRates == null)
+ //{
+ // /// add error processing here
+ // /// this condition could be caused by an HTTP error
(404,500...)
+ // Console.Write("Service is unavailable at this time.");
+ //}
+ //else
+ //{
+ // switch (historicalRates.Outcome)
+ // {
+ // case OutcomeTypes.RegistrationError:
+ // /// add processing for handling subscription
problems, e.g.
+ // Console.Write("Our subscription to this service
has expired.");
+ // break;
+ // case OutcomeTypes.RequestError:
+ // /// add processing for hserviceandling request
problems, e.g.
+ // /// you could pass back the info message
received from the
+ // Console.Write(historicalRates.Message);
+ // break;
+ // case OutcomeTypes.SystemError:
+ // /// add processing for handling system problems,
e.g.
+ // Console.Write("Service is unavailable at this
time.");
+ // break;
+ // default:
+ // /// add processing for displaying the results,
e.g.
+ // /// since the return class contains an array
+ // /// we just display its count
+ // /// each instance and its values can be easily
accessed
+ // //Console.Write(objHistoricalQuotes.Length);
+ // break;
+ // }
+ //}
+ }
+ catch (Exception)
+ {
+
+ throw new Exception("Connection to Web Service failed!");
+ }
+ return historicalRates;
+ }
+}
+
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/WSIRWriter.cs Sun Jan 17 01:18:44 2010
@@ -0,0 +1,76 @@
+/*
+ Copyright (c) 2008 by contributors:
+
+ * Damitha Premadasa
+ * Nilendra Weerasinghe
+ * Thilina Dampahala
+ * Waruna Ranasinghe - (http://warunapw.blogspot.com)
+
+ Licensed under the Apache License, Version 2.0 (the "License");
+ you may not use this file except in compliance with the License.
+ You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+*/
+
+using System;
+using System.Collections.Generic;
+using System.Text;
+using System.Configuration;
+using MySql.Data.MySqlClient;
+using XClient.com.xignite;
+using XClient.Properties;
+
+class WSIRWriter
+{
+
+
+ /// <summary>
+ /// Write interest rate data in to a given data table
+ /// </summary>
+ /// <param name="interestRates">List of interest rates</param>
+ /// <param name="tableName">Table name</param>
+ public void WriteData(HistoricalInterestRates interestRates, string
tableName)
+ {
+ try
+ {
+ List<DataEntity> entityList = new List<DataEntity>();
+
+ foreach (Rate r in interestRates.Rates)
+ {
+ DataEntity i = new DataEntity();
+ i.Date = UStoBrithishDateFormat(r.Date);
+ i.Value = r.Value.ToString();
+ entityList.Add(i);
+ }
+
+ new DataWriter().WriteData(entityList, tableName);
+ }
+ catch (Exception ex)
+ {
+ throw new Exception("Web Service Credentials Invalid!");
+ }
+ }
+
+ /// <summary>
+ /// Convert date from US fromat to UK format
+ /// </summary>
+ /// <param name="p">Date in US format</param>
+ /// <returns>Date in UK format</returns>
+ private string UStoBrithishDateFormat(string p)
+ {
+ string[] array = p.Split(new Char[] { '/' });
+ string temp = array[2] + "-" + array[0] + "-" + array[1];
+ return temp.Trim();
+ }
+
+
+
+}
+
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/WSSPFetcher.cs Sun Jan 17 01:18:44 2010
@@ -0,0 +1,94 @@
+/*
+ Copyright (c) 2008 by contributors:
+
+ * Damitha Premadasa
+ * Nilendra Weerasinghe
+ * Thilina Dampahala
+ * Waruna Ranasinghe - (http://warunapw.blogspot.com)
+
+ Licensed under the Apache License, Version 2.0 (the "License");
+ you may not use this file except in compliance with the License.
+ You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+*/
+
+using System;
+using System.Collections.Generic;
+using System.Text;
+using System.IO;
+using XClient.com.xignite.www;
+using System.Configuration;
+using XClient.Properties;
+
+class WSSPFetcher
+{
+ Settings set = Settings.Default;
+
+ /// <summary>
+ /// Get historical quotes from Xignite web service
+ /// </summary>
+ /// <param name="identifier">Company identifier</param>
+ /// <param name="startdate">Start date [dd/mm/yyyy]</param>
+ /// <param name="enddate">End date [dd/mm/yyyy]</param>
+ /// <returns>HistoricalQuotes</returns>
+ public HistoricalQuotes GetDataEntityList(string identifier, string
startdate, string enddate)
+ {
+ XigniteHistorical historicalService = new XigniteHistorical();
+ Header header = new Header();
+ header.Username = set.username;
+ header.Password = set.password;
+
+ historicalService.HeaderValue = header;
+ HistoricalQuotes historicalQuotes;
+ try
+ {
+
+ historicalQuotes =
historicalService.GetHistoricalQuotesRange(identifier,
IdentifierTypes.Symbol, startdate, enddate);
+ //if (historicalQuotes == null)
+ //{
+ // /// add error processing here
+ // /// this condition could be caused by an HTTP error
(404,500...)
+ // Console.Write("Service is unavailable at this time.");
+ //}
+ //else
+ //{
+ // switch (historicalQuotes.Outcome)
+ // {
+ // case OutcomeTypes.RegistrationError:
+ // /// add processing for handling subscription
problems, e.g.
+ // Console.Write("Our subscription to this service
has expired.");
+ // break;
+ // case OutcomeTypes.RequestError:
+ // /// add processing for hserviceandling request
problems, e.g.
+ // /// you could pass back the info message
received from the
+ // Console.Write(historicalQuotes.Message);
+ // break;
+ // case OutcomeTypes.SystemError:
+ // /// add processing for handling system problems,
e.g.
+ // Console.Write("Service is unavailable at this
time.");
+ // break;
+ // default:
+ // /// add processing for displaying the results,
e.g.
+ // /// since the return class contains an array
+ // /// we just display its count
+ // /// each instance and its values can be easily
accessed
+ // //Console.Write(objHistoricalQuotes.Length);
+ // break;
+ // }
+ //}
+ }
+ catch (Exception ex)
+ {
+ throw new Exception("Connection to Web Service failed!");
+ }
+ return historicalQuotes;
+ }
+}
+
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/WSSPWriter.cs Sun Jan 17 01:18:44 2010
@@ -0,0 +1,74 @@
+/*
+ Copyright (c) 2008 by contributors:
+
+ * Damitha Premadasa
+ * Nilendra Weerasinghe
+ * Thilina Dampahala
+ * Waruna Ranasinghe - (http://warunapw.blogspot.com)
+
+ Licensed under the Apache License, Version 2.0 (the "License");
+ you may not use this file except in compliance with the License.
+ You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+*/
+
+using System;
+using System.Collections.Generic;
+using System.Text;
+using System.Configuration;
+using MySql.Data.MySqlClient;
+using XClient.com.xignite.www;
+using XClient.Properties;
+
+class WSSPWriter
+{
+
+ /// <summary>
+ /// Write date to the database when source is a webservice
+ /// </summary>
+ /// <param name="quotes">HistoricalQuotes</param>
+ /// <param name="tableName">Name of the table to insert data</param>
+ public void WriteData(HistoricalQuotes quotes, string tableName)
+ {
+ try
+ {
+ List<DataEntity> entityList = new List<DataEntity>();
+
+ foreach (HistoricalQuote q in quotes.Quotes)
+ {
+ DataEntity s = new DataEntity();
+ s.Date = UStoBrithishDateFormat(q.Date);
+ s.Value = q.LastClose.ToString();
+ entityList.Add(s);
+ }
+
+ new DataWriter().WriteData(entityList, tableName);
+ }
+ catch (Exception ex)
+ {
+ new Exception("Web Service Credentials Invalid!");
+ }
+ }
+
+ /// <summary>
+ /// Convert date from US fromat to UK format
+ /// </summary>
+ /// <param name="p">Date in US format</param>
+ /// <returns>Date in UK format</returns>
+ private string UStoBrithishDateFormat(string p)
+ {
+ string[] array = p.Split(new Char[] { '/' });
+ string temp = array[2] + "-" + array[0] + "-" + array[1];
+ return temp.Trim();
+ }
+
+
+}
+
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/WSSettingsForm.Designer.cs Sun Jan 17
01:18:44 2010
@@ -0,0 +1,131 @@
+/*
+ Copyright (c) 2008 by contributors:
+
+ * Damitha Premadasa
+ * Nilendra Weerasinghe
+ * Thilina Dampahala
+ * Waruna Ranasinghe - (http://warunapw.blogspot.com)
+
+ Licensed under the Apache License, Version 2.0 (the "License");
+ you may not use this file except in compliance with the License.
+ You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+*/
+
+namespace XClient
+{
+ partial class WSSettingsForm
+ {
+ /// <summary>
+ /// Required designer variable.
+ /// </summary>
+ private System.ComponentModel.IContainer components = null;
+
+ /// <summary>
+ /// Clean up any resources being used.
+ /// </summary>
+ /// <param name="disposing">true if managed resources should be
disposed; otherwise, false.</param>
+ protected override void Dispose(bool disposing)
+ {
+ if (disposing && (components != null))
+ {
+ components.Dispose();
+ }
+ base.Dispose(disposing);
+ }
+
+ #region Windows Form Designer generated code
+
+ /// <summary>
+ /// Required method for Designer support - do not modify
+ /// the contents of this method with the code editor.
+ /// </summary>
+ private void InitializeComponent()
+ {
+ this.label1 = new System.Windows.Forms.Label();
+ this.label2 = new System.Windows.Forms.Label();
+ this.textBox1 = new System.Windows.Forms.TextBox();
+ this.textBox2 = new System.Windows.Forms.TextBox();
+ this.button1 = new System.Windows.Forms.Button();
+ this.SuspendLayout();
+ //
+ // label1
+ //
+ this.label1.AutoSize = true;
+ this.label1.Location = new System.Drawing.Point(13, 13);
+ this.label1.Name = "label1";
+ this.label1.Size = new System.Drawing.Size(60, 13);
+ this.label1.TabIndex = 0;
+ this.label1.Text = "User Name";
+ //
+ // label2
+ //
+ this.label2.AutoSize = true;
+ this.label2.Location = new System.Drawing.Point(12, 62);
+ this.label2.Name = "label2";
+ this.label2.Size = new System.Drawing.Size(53, 13);
+ this.label2.TabIndex = 1;
+ this.label2.Text = "Password";
+ //
+ // textBox1
+ //
+ this.textBox1.Location = new System.Drawing.Point(16, 30);
+ this.textBox1.Name = "textBox1";
+ this.textBox1.Size = new System.Drawing.Size(256, 20);
+ this.textBox1.TabIndex = 2;
+ //
+ // textBox2
+ //
+ this.textBox2.Location = new System.Drawing.Point(16, 79);
+ this.textBox2.Name = "textBox2";
+ this.textBox2.PasswordChar = 'x';
+ this.textBox2.Size = new System.Drawing.Size(256, 20);
+ this.textBox2.TabIndex = 3;
+ //
+ // button1
+ //
+ this.button1.Location = new System.Drawing.Point(197, 110);
+ this.button1.Name = "button1";
+ this.button1.Size = new System.Drawing.Size(75, 23);
+ this.button1.TabIndex = 4;
+ this.button1.Text = "Save";
+ this.button1.UseVisualStyleBackColor = true;
+ this.button1.Click += new
System.EventHandler(this.button1_Click);
+ //
+ // WSSettingsForm
+ //
+ this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
+ this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
+ this.ClientSize = new System.Drawing.Size(284, 148);
+ this.Controls.Add(this.button1);
+ this.Controls.Add(this.textBox2);
+ this.Controls.Add(this.textBox1);
+ this.Controls.Add(this.label2);
+ this.Controls.Add(this.label1);
+ this.FormBorderStyle =
System.Windows.Forms.FormBorderStyle.FixedDialog;
+ this.Name = "WSSettingsForm";
+ this.ShowInTaskbar = false;
+ this.StartPosition =
System.Windows.Forms.FormStartPosition.CenterScreen;
+ this.Text = "WS Settings";
+ this.Load += new System.EventHandler(this.WSSettingsForm_Load);
+ this.ResumeLayout(false);
+ this.PerformLayout();
+
+ }
+
+ #endregion
+
+ private System.Windows.Forms.Label label1;
+ private System.Windows.Forms.Label label2;
+ private System.Windows.Forms.TextBox textBox1;
+ private System.Windows.Forms.TextBox textBox2;
+ private System.Windows.Forms.Button button1;
+ }
+}
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/WSSettingsForm.cs Sun Jan 17 01:18:44 2010
@@ -0,0 +1,84 @@
+/*
+ Copyright (c) 2008 by contributors:
+
+ * Damitha Premadasa
+ * Nilendra Weerasinghe
+ * Thilina Dampahala
+ * Waruna Ranasinghe - (http://warunapw.blogspot.com)
+
+ Licensed under the Apache License, Version 2.0 (the "License");
+ you may not use this file except in compliance with the License.
+ You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+*/
+
+using System;
+using System.Collections.Generic;
+using System.ComponentModel;
+using System.Data;
+using System.Drawing;
+using System.Text;
+using System.Windows.Forms;
+using System.Configuration;
+using XClient.Properties;
+
+namespace XClient
+{
+ public partial class WSSettingsForm : Form
+ {
+ /// <summary>
+ /// Constructor
+ /// </summary>
+ public WSSettingsForm()
+ {
+ InitializeComponent();
+ }
+
+ /// <summary>
+ /// Event WSSettingsForm_Load
+ /// </summary>
+ /// <param name="sender">sender</param>
+ /// <param name="e">event arguments</param>
+ private void WSSettingsForm_Load(object sender, EventArgs e)
+ {
+ try
+ {
+ Settings set = Settings.Default;
+ textBox1.Text = set.username;
+ textBox2.Text = set.password;
+ }
+ catch (Exception)
+ {
+ }
+ }
+
+ /// <summary>
+ /// Event button1_Click
+ /// </summary>
+ /// <param name="sender">sender</param>
+ /// <param name="e">event arguments</param>
+ private void button1_Click(object sender, EventArgs e)
+ {
+ try
+ {
+ Settings set = Settings.Default;
+ set.username = textBox1.Text;
+ set.password = textBox2.Text;
+ set.Save();
+
+ this.Close();
+ }
+ catch (Exception)
+ {
+ }
+ }
+
+ }
+}
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/WSSettingsForm.resx Sun Jan 17 01:18:44 2010
@@ -0,0 +1,142 @@
+
+
+
+<?xml version="1.0" encoding="utf-8"?>
+<root>
+ 
+ <xsd:schema id="root" xmlns=""
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
+ <xsd:import namespace="http://www.w3.org/XML/1998/namespace" />
+ <xsd:element name="root" msdata:IsDataSet="true">
+ <xsd:complexType>
+ <xsd:choice maxOccurs="unbounded">
+ <xsd:element name="metadata">
+ <xsd:complexType>
+ <xsd:sequence>
+ <xsd:element name="value" type="xsd:string" minOccurs="0"
/>
+ </xsd:sequence>
+ <xsd:attribute name="name" use="required" type="xsd:string"
/>
+ <xsd:attribute name="type" type="xsd:string" />
+ <xsd:attribute name="mimetype" type="xsd:string" />
+ <xsd:attribute ref="xml:space" />
+ </xsd:complexType>
+ </xsd:element>
+ <xsd:element name="assembly">
+ <xsd:complexType>
+ <xsd:attribute name="alias" type="xsd:string" />
+ <xsd:attribute name="name" type="xsd:string" />
+ </xsd:complexType>
+ </xsd:element>
+ <xsd:element name="data">
+ <xsd:complexType>
+ <xsd:sequence>
+ <xsd:element name="value" type="xsd:string" minOccurs="0"
msdata:Ordinal="1" />
+ <xsd:element name="comment" type="xsd:string"
minOccurs="0" msdata:Ordinal="2" />
+ </xsd:sequence>
+ <xsd:attribute name="name" type="xsd:string" use="required"
msdata:Ordinal="1" />
+ <xsd:attribute name="type" type="xsd:string"
msdata:Ordinal="3" />
+ <xsd:attribute name="mimetype" type="xsd:string"
msdata:Ordinal="4" />
+ <xsd:attribute ref="xml:space" />
+ </xsd:complexType>
+ </xsd:element>
+ <xsd:element name="resheader">
+ <xsd:complexType>
+ <xsd:sequence>
+ <xsd:element name="value" type="xsd:string" minOccurs="0"
msdata:Ordinal="1" />
+ </xsd:sequence>
+ <xsd:attribute name="name" type="xsd:string" use="required"
/>
+ </xsd:complexType>
+ </xsd:element>
+ </xsd:choice>
+ </xsd:complexType>
+ </xsd:element>
+ </xsd:schema>
+ <resheader name="resmimetype">
+ <value>text/microsoft-resx</value>
+ </resheader>
+ <resheader name="version">
+ <value>2.0</value>
+ </resheader>
+ <resheader name="reader">
+ <value>System.Resources.ResXResourceReader, System.Windows.Forms,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
+ </resheader>
+ <resheader name="writer">
+ <value>System.Resources.ResXResourceWriter, System.Windows.Forms,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
+ </resheader>
+</root>
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/Web_References/README.txt Sun Jan 17
01:18:44 2010
@@ -0,0 +1,2 @@
+To integrate Xignite web services to retrive Financial data from the
Xignite.
+You need a valid Xignite account in-order to complete this
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/Web_References/com.xignite/Reference.map
Sun Jan 17 01:18:44 2010
@@ -0,0 +1,6 @@
+<?xml version="1.0" encoding="utf-8"?>
+<DiscoveryClientResultsFile
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
+ <Results>
+ <DiscoveryClientResult
referenceType="System.Web.Services.Discovery.ContractReference"
url="https://xignite.com/xRates.asmx?WSDL" filename="xRates.wsdl" />
+ </Results>
+</DiscoveryClientResultsFile>
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/Web_References/com.xignite/xRates.wsdl Sun
Jan 17 01:18:44 2010
@@ -0,0 +1,7745 @@
+<?xml version="1.0" encoding="utf-8"?>
+<wsdl:definitions xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/"
xmlns:tm="http://microsoft.com/wsdl/mime/textMatching/"
xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/"
xmlns:tns="http://www.xignite.com/services/"
xmlns:s="http://www.w3.org/2001/XMLSchema"
xmlns:soap12="http://schemas.xmlsoap.org/wsdl/soap12/"
xmlns:http="http://schemas.xmlsoap.org/wsdl/http/"
targetNamespace="http://www.xignite.com/services/"
xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">
+ <wsdl:documentation
xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">Provide information about
interest rates.</wsdl:documentation>
+ <wsdl:types>
+ <s:schema elementFormDefault="qualified"
targetNamespace="http://www.xignite.com/services/">
+ <s:element name="GetLIBORSecure">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Username"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="Type"
type="tns:LIBORTypes" />
+ <s:element minOccurs="1" maxOccurs="1" name="Currency"
type="tns:LIBORCurrencyTypes" />
+ <s:element minOccurs="0" maxOccurs="1" name="AsOfDate"
type="s:string" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:simpleType name="LIBORTypes">
+ <s:restriction base="s:string">
+ <s:enumeration value="OneMonth" />
+ <s:enumeration value="TwoMonths" />
+ <s:enumeration value="ThreeMonths" />
+ <s:enumeration value="FourMonths" />
+ <s:enumeration value="FiveMonths" />
+ <s:enumeration value="SixMonths" />
+ <s:enumeration value="SevenMonths" />
+ <s:enumeration value="EightMonths" />
+ <s:enumeration value="NineMonths" />
+ <s:enumeration value="TenMonths" />
+ <s:enumeration value="ElevenMonths" />
+ <s:enumeration value="OneYear" />
+ <s:enumeration value="OneWeek" />
+ <s:enumeration value="TwoWeeks" />
+ <s:enumeration value="Overnite" />
+ </s:restriction>
+ </s:simpleType>
+ <s:simpleType name="LIBORCurrencyTypes">
+ <s:restriction base="s:string">
+ <s:enumeration value="USD" />
+ <s:enumeration value="EUR" />
+ <s:enumeration value="GBP" />
+ <s:enumeration value="CHF" />
+ <s:enumeration value="JPY" />
+ <s:enumeration value="AUD" />
+ <s:enumeration value="CAD" />
+ <s:enumeration value="DKK" />
+ <s:enumeration value="NZD" />
+ <s:enumeration value="NOK" />
+ <s:enumeration value="ISK" />
+ <s:enumeration value="SGD" />
+ <s:enumeration value="PLN" />
+ <s:enumeration value="SEK" />
+ <s:enumeration value="HKD" />
+ <s:enumeration value="BGN" />
+ <s:enumeration value="HUF" />
+ <s:enumeration value="CLP" />
+ <s:enumeration value="INR" />
+ <s:enumeration value="CZK" />
+ <s:enumeration value="KRW" />
+ <s:enumeration value="TRL" />
+ <s:enumeration value="MXN" />
+ <s:enumeration value="ILS" />
+ <s:enumeration value="CNY" />
+ <s:enumeration value="MYR" />
+ <s:enumeration value="PHP" />
+ <s:enumeration value="THB" />
+ <s:enumeration value="VND" />
+ <s:enumeration value="IDR" />
+ <s:enumeration value="TWD" />
+ <s:enumeration value="ZAR" />
+ <s:enumeration value="TRY" />
+ <s:enumeration value="KZT" />
+ <s:enumeration value="PKR" />
+ <s:enumeration value="RUB" />
+ <s:enumeration value="BRL" />
+ <s:enumeration value="SKK" />
+ </s:restriction>
+ </s:simpleType>
+ <s:element name="GetLIBORSecureResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetLIBORSecureResult" type="tns:LIBORRate" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:complexType name="LIBORRate">
+ <s:complexContent mixed="false">
+ <s:extension base="tns:Common">
+ <s:sequence>
+ <s:element minOccurs="1" maxOccurs="1" name="Type"
type="tns:LIBORTypes" />
+ <s:element minOccurs="1" maxOccurs="1" name="Currency"
type="tns:LIBORCurrencyTypes" />
+ <s:element minOccurs="0" maxOccurs="1" name="Date"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="Value"
type="s:double" />
+ <s:element minOccurs="0" maxOccurs="1" name="Text"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="Source"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="Description"
type="tns:RateDescription" />
+ </s:sequence>
+ </s:extension>
+ </s:complexContent>
+ </s:complexType>
+ <s:complexType name="Common">
+ <s:sequence>
+ <s:element minOccurs="1" maxOccurs="1" name="Outcome"
type="tns:OutcomeTypes" />
+ <s:element minOccurs="0" maxOccurs="1" name="Message"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="Identity"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="Delay"
type="s:double" />
+ </s:sequence>
+ </s:complexType>
+ <s:simpleType name="OutcomeTypes">
+ <s:restriction base="s:string">
+ <s:enumeration value="Success" />
+ <s:enumeration value="SystemError" />
+ <s:enumeration value="RequestError" />
+ <s:enumeration value="RegistrationError" />
+ </s:restriction>
+ </s:simpleType>
+ <s:complexType name="RateDescription">
+ <s:complexContent mixed="false">
+ <s:extension base="tns:Common">
+ <s:sequence>
+ <s:element minOccurs="1" maxOccurs="1" name="Type"
type="tns:RateTypes" />
+ <s:element minOccurs="0" maxOccurs="1" name="Description"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="Name"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="Maturity"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="MaturityUnit"
type="tns:MaturityUnitTypes" />
+ <s:element minOccurs="1" maxOccurs="1" name="MaturityCount"
type="s:int" />
+ <s:element minOccurs="1" maxOccurs="1"
name="SeasonallyAdjusted" type="s:boolean" />
+ <s:element minOccurs="0" maxOccurs="1" name="Availability"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="Source"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="Discontinued"
type="s:boolean" />
+ <s:element minOccurs="0" maxOccurs="1" name="Service"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="Suffix"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="Factor"
type="s:int" />
+ <s:element minOccurs="1" maxOccurs="1" name="Precision"
type="s:int" />
+ </s:sequence>
+ </s:extension>
+ </s:complexContent>
+ </s:complexType>
+ <s:simpleType name="RateTypes">
+ <s:restriction base="s:string">
+ <s:enumeration value="FederalFunds" />
+ <s:enumeration value="Libor1Month" />
+ <s:enumeration value="Libor2Month" />
+ <s:enumeration value="Libor3Month" />
+ <s:enumeration value="Libor4Month" />
+ <s:enumeration value="Libor5Month" />
+ <s:enumeration value="Libor6Month" />
+ <s:enumeration value="Libor7Month" />
+ <s:enumeration value="Libor8Month" />
+ <s:enumeration value="Libor9Month" />
+ <s:enumeration value="Libor10Month" />
+ <s:enumeration value="Libor11Month" />
+ <s:enumeration value="Libor1Year" />
+ <s:enumeration value="Libor1Week" />
+ <s:enumeration value="Libor2Week" />
+ <s:enumeration value="LiborOvernite" />
+ <s:enumeration value="CommercialPaperNonFinancial1Month" />
+ <s:enumeration value="CommercialPaperNonFinancial2Month" />
+ <s:enumeration value="CommercialPaperNonFinancial3Month" />
+ <s:enumeration
value="HistoricalCommercialPaperNonFinancial1Month" />
+ <s:enumeration
value="HistoricalCommercialPaperNonFinancial3Month" />
+ <s:enumeration
value="HistoricalCommercialPaperNonFinancial6Month" />
+ <s:enumeration value="BankersAcceptance3Month" />
+ <s:enumeration value="BankersAcceptance6Month" />
+ <s:enumeration value="CD1Month" />
+ <s:enumeration value="CD3Month" />
+ <s:enumeration value="CD6Month" />
+ <s:enumeration value="EuroDollarDeposits1Month" />
+ <s:enumeration value="EuroDollarDeposits3Month" />
+ <s:enumeration value="EuroDollarDeposits6Month" />
+ <s:enumeration value="Prime" />
+ <s:enumeration value="DiscountWindowBorrowing" />
+ <s:enumeration value="DiscountWindowPrimaryCredit" />
+ <s:enumeration value="TBillAuctionAverage3Month" />
+ <s:enumeration value="TBillAuctionAverage6Month" />
+ <s:enumeration value="TBillAuctionAverage1Year" />
+ <s:enumeration value="TBillSecondaryMarket3Month" />
+ <s:enumeration value="TBillSecondaryMarket6Month" />
+ <s:enumeration value="TBillSecondaryMarket1Year" />
+ <s:enumeration value="TBillSecondaryMarket4Week" />
+ <s:enumeration value="TreasuryConstant1Month" />
+ <s:enumeration value="TreasuryConstant3Month" />
+ <s:enumeration value="TreasuryConstant6Month" />
+ <s:enumeration value="TreasuryConstant1Year" />
+ <s:enumeration value="TreasuryConstant2Year" />
+ <s:enumeration value="TreasuryConstant3Year" />
+ <s:enumeration value="TreasuryConstant5Year" />
+ <s:enumeration value="TreasuryConstant7Year" />
+ <s:enumeration value="TreasuryConstant10Year" />
+ <s:enumeration value="TreasuryConstant20Year" />
+ <s:enumeration value="TreasuryConstant20YearHistorical" />
+ <s:enumeration value="TreasuryConstant30Year" />
+ <s:enumeration value="TreasuryConstant10YearComposite" />
+ <s:enumeration value="CommercialPaperFinancial1Month" />
+ <s:enumeration value="CommercialPaperFinancial2Month" />
+ <s:enumeration value="CommercialPaperFinancial3Month" />
+ <s:enumeration value="HistoricalCommercialPaperFinancial1Month"
/>
+ <s:enumeration value="HistoricalCommercialPaperFinancial3Month"
/>
+ <s:enumeration value="HistoricalCommercialPaperFinancial6Month"
/>
+ <s:enumeration value="CorporateBondsMoodysSeasonedAaa" />
+ <s:enumeration value="CorporateBondsMoodysSeasonedBaa" />
+ <s:enumeration value="CorporateBondsAUtility" />
+ <s:enumeration value="StateAndLocalBonds" />
+ <s:enumeration value="ConventionalMortgages" />
+ <s:enumeration value="TreasuryLongTermAverageAverage" />
+ <s:enumeration value="TreasuryLongTermAverageInflationIndexed" />
+ <s:enumeration value="TreasuryLongTermComposite" />
+ <s:enumeration value="InterestRateSwapsOvernight" />
+ <s:enumeration value="InterestRateSwaps1Week" />
+ <s:enumeration value="InterestRateSwaps2Week" />
+ <s:enumeration value="InterestRateSwaps1Month" />
+ <s:enumeration value="InterestRateSwaps2Month" />
+ <s:enumeration value="InterestRateSwaps3Month" />
+ <s:enumeration value="InterestRateSwaps4Month" />
+ <s:enumeration value="InterestRateSwaps5Month" />
+ <s:enumeration value="InterestRateSwaps6Month" />
+ <s:enumeration value="InterestRateSwaps7Month" />
+ <s:enumeration value="InterestRateSwaps8Month" />
+ <s:enumeration value="InterestRateSwaps9Month" />
+ <s:enumeration value="InterestRateSwaps10Month" />
+ <s:enumeration value="InterestRateSwaps11Month" />
+ <s:enumeration value="InterestRateSwaps1Year" />
+ <s:enumeration value="InterestRateSwaps2Year" />
+ <s:enumeration value="InterestRateSwaps3Year" />
+ <s:enumeration value="InterestRateSwaps4Year" />
+ <s:enumeration value="InterestRateSwaps5Year" />
+ <s:enumeration value="InterestRateSwaps6Year" />
+ <s:enumeration value="InterestRateSwaps7Year" />
+ <s:enumeration value="InterestRateSwaps10Year" />
+ <s:enumeration value="InterestRateSwaps20Year" />
+ <s:enumeration value="InterestRateSwaps30Year" />
+ <s:enumeration
value="TreasuryInflationProtectedSecuritiesYield5Year" />
+ <s:enumeration
value="TreasuryInflationProtectedSecuritiesYield7Year" />
+ <s:enumeration
value="TreasuryInflationProtectedSecuritiesYield10Year" />
+ <s:enumeration
value="TreasuryInflationProtectedSecuritiesYield20Year" />
+ <s:enumeration value="InterestRateSwapSpread1Year" />
+ <s:enumeration value="InterestRateSwapSpread2Year" />
+ <s:enumeration value="InterestRateSwapSpread3Year" />
+ <s:enumeration value="InterestRateSwapSpread5Year" />
+ <s:enumeration value="InterestRateSwapSpread7Year" />
+ <s:enumeration value="InterestRateSwapSpread10Year" />
+ <s:enumeration value="InterestRateSwapSpread30Year" />
+ <s:enumeration value="REIBOROvernight" />
+ <s:enumeration value="REIBOR1Week" />
+ <s:enumeration value="REIBOR2Week" />
+ <s:enumeration value="REIBOR1Month" />
+ <s:enumeration value="REIBOR2Month" />
+ <s:enumeration value="REIBOR3Month" />
+ <s:enumeration value="REIBOR6Month" />
+ <s:enumeration value="REIBOR9Month" />
+ <s:enumeration value="REIBOR1Year" />
+ <s:enumeration value="REIBIDOvernight" />
+ <s:enumeration value="REIBID1Week" />
+ <s:enumeration value="REIBID2Week" />
+ <s:enumeration value="REIBID1Month" />
+ <s:enumeration value="REIBID2Month" />
+ <s:enumeration value="REIBID3Month" />
+ <s:enumeration value="REIBID6Month" />
+ <s:enumeration value="REIBID9Month" />
+ <s:enumeration value="REIBID1Year" />
+ <s:enumeration value="OIBORTomorrowNext" />
+ <s:enumeration value="OIBORSpotNext" />
+ <s:enumeration value="OIBOR1Week" />
+ <s:enumeration value="OIBOR2Week" />
+ <s:enumeration value="OIBOR1Month" />
+ <s:enumeration value="OIBOR2Month" />
+ <s:enumeration value="OIBOR3Month" />
+ <s:enumeration value="OIBOR4Month" />
+ <s:enumeration value="OIBOR5Month" />
+ <s:enumeration value="OIBOR6Month" />
+ <s:enumeration value="OIBOR9Month" />
+ <s:enumeration value="OIBOR1Year" />
+ <s:enumeration value="STIBORTomorrowNext" />
+ <s:enumeration value="STIBOR1Week" />
+ <s:enumeration value="STIBOR1Month" />
+ <s:enumeration value="STIBOR2Month" />
+ <s:enumeration value="STIBOR3Month" />
+ <s:enumeration value="STIBOR6Month" />
+ <s:enumeration value="STIBOR9Month" />
+ <s:enumeration value="STIBOR1Year" />
+ <s:enumeration value="SIBOROvernight" />
+ <s:enumeration value="SIBORTomorrowNext" />
+ <s:enumeration value="SIBOR1Week" />
+ <s:enumeration value="SIBOR1Month" />
+ <s:enumeration value="SIBOR2Month" />
+ <s:enumeration value="SIBOR3Month" />
+ <s:enumeration value="SIBOR6Month" />
+ <s:enumeration value="SIBOR9Month" />
+ <s:enumeration value="SIBOR1Year" />
+ <s:enumeration value="SIBORSORA" />
+ <s:enumeration value="SIBOROvernightRepo" />
+ <s:enumeration value="WIBOROvernight" />
+ <s:enumeration value="WIBORTomorrowNext" />
+ <s:enumeration value="WIBOR1Week" />
+ <s:enumeration value="WIBOR2Week" />
+ <s:enumeration value="WIBOR1Month" />
+ <s:enumeration value="WIBOR3Month" />
+ <s:enumeration value="WIBOR4Month" />
+ <s:enumeration value="WIBOR6Month" />
+ <s:enumeration value="WIBOR9Month" />
+ <s:enumeration value="WIBOR1Year" />
+ <s:enumeration value="CIBOR1Week" />
+ <s:enumeration value="CIBOR2Week" />
+ <s:enumeration value="CIBOR1Month" />
+ <s:enumeration value="CIBOR2Month" />
+ <s:enumeration value="CIBOR3Month" />
+ <s:enumeration value="CIBOR4Month" />
+ <s:enumeration value="CIBOR5Month" />
+ <s:enumeration value="CIBOR6Month" />
+ <s:enumeration value="CIBOR7Month" />
+ <s:enumeration value="CIBOR8Month" />
+ <s:enumeration value="CIBOR9Month" />
+ <s:enumeration value="CIBOR10Month" />
+ <s:enumeration value="CIBOR11Month" />
+ <s:enumeration value="CIBOR1Year" />
+ <s:enumeration value="EURIBOR1Week" />
+ <s:enumeration value="EURIBOR2Week" />
+ <s:enumeration value="EURIBOR3Week" />
+ <s:enumeration value="EURIBOR1Month" />
+ <s:enumeration value="EURIBOR2Month" />
+ <s:enumeration value="EURIBOR3Month" />
+ <s:enumeration value="EURIBOR4Month" />
+ <s:enumeration value="EURIBOR5Month" />
+ <s:enumeration value="EURIBOR6Month" />
+ <s:enumeration value="EURIBOR7Month" />
+ <s:enumeration value="EURIBOR8Month" />
+ <s:enumeration value="EURIBOR9Month" />
+ <s:enumeration value="EURIBOR10Month" />
+ <s:enumeration value="EURIBOR11Month" />
+ <s:enumeration value="EURIBOR1Year" />
+ <s:enumeration value="HIBOROvernight" />
+ <s:enumeration value="HIBOR1Week" />
+ <s:enumeration value="HIBOR2Week" />
+ <s:enumeration value="HIBOR1Month" />
+ <s:enumeration value="HIBOR2Month" />
+ <s:enumeration value="HIBOR3Month" />
+ <s:enumeration value="HIBOR4Month" />
+ <s:enumeration value="HIBOR5Month" />
+ <s:enumeration value="HIBOR6Month" />
+ <s:enumeration value="HIBOR7Month" />
+ <s:enumeration value="HIBOR8Month" />
+ <s:enumeration value="HIBOR9Month" />
+ <s:enumeration value="HIBOR10Month" />
+ <s:enumeration value="HIBOR11Month" />
+ <s:enumeration value="HIBOR1Year" />
+ <s:enumeration value="BUBOROvernight" />
+ <s:enumeration value="BUBOR1Week" />
+ <s:enumeration value="BUBOR2Week" />
+ <s:enumeration value="BUBOR1Month" />
+ <s:enumeration value="BUBOR2Month" />
+ <s:enumeration value="BUBOR3Month" />
+ <s:enumeration value="BUBOR4Month" />
+ <s:enumeration value="BUBOR5Month" />
+ <s:enumeration value="BUBOR6Month" />
+ <s:enumeration value="BUBOR7Month" />
+ <s:enumeration value="BUBOR8Month" />
+ <s:enumeration value="BUBOR9Month" />
+ <s:enumeration value="BUBOR10Month" />
+ <s:enumeration value="BUBOR11Month" />
+ <s:enumeration value="BUBOR1Year" />
+ <s:enumeration value="SOFIBOROvernight" />
+ <s:enumeration value="SOFIBOR1Week" />
+ <s:enumeration value="SOFIBOR1Month" />
+ <s:enumeration value="SOFIBOR2Month" />
+ <s:enumeration value="SOFIBOR3Month" />
+ <s:enumeration value="MIBOROvernight" />
+ <s:enumeration value="MIBOR2Week" />
+ <s:enumeration value="MIBOR1Month" />
+ <s:enumeration value="MIBOR3Month" />
+ <s:enumeration value="MIBIDOvernight" />
+ <s:enumeration value="MIBID2Week" />
+ <s:enumeration value="MIBID1Month" />
+ <s:enumeration value="MIBID3Month" />
+ <s:enumeration value="KORIBOR1Week" />
+ <s:enumeration value="KORIBOR2Week" />
+ <s:enumeration value="KORIBOR1Month" />
+ <s:enumeration value="KORIBOR2Month" />
+ <s:enumeration value="KORIBOR3Month" />
+ <s:enumeration value="KORIBOR4Month" />
+ <s:enumeration value="KORIBOR5Month" />
+ <s:enumeration value="KORIBOR6Month" />
+ <s:enumeration value="KORIBOR9Month" />
+ <s:enumeration value="KORIBOR1Year" />
+ <s:enumeration value="PRIBOROvernight" />
+ <s:enumeration value="PRIBOR1Week" />
+ <s:enumeration value="PRIBOR2Week" />
+ <s:enumeration value="PRIBOR1Month" />
+ <s:enumeration value="PRIBOR2Month" />
+ <s:enumeration value="PRIBOR3Month" />
+ <s:enumeration value="PRIBOR6Month" />
+ <s:enumeration value="PRIBOR9Month" />
+ <s:enumeration value="PRIBOR1Year" />
+ <s:enumeration value="PRIBIDOvernight" />
+ <s:enumeration value="PRIBID1Week" />
+ <s:enumeration value="PRIBID2Week" />
+ <s:enumeration value="PRIBID1Month" />
+ <s:enumeration value="PRIBID2Month" />
+ <s:enumeration value="PRIBID3Month" />
+ <s:enumeration value="PRIBID6Month" />
+ <s:enumeration value="PRIBID9Month" />
+ <s:enumeration value="PRIBID1Year" />
+ <s:enumeration value="SABOROvernight" />
+ <s:enumeration value="TAIBOROvernight" />
+ <s:enumeration value="TURKIBOROvernight" />
+ <s:enumeration value="CHILIBOROvernight" />
+ <s:enumeration value="MEXIBOR1Month" />
+ <s:enumeration value="MEXIBOR3Month" />
+ <s:enumeration value="MEXIBOR6Month" />
+ <s:enumeration value="MEXIBOR9Month" />
+ <s:enumeration value="MEXIBOR1Year" />
+ <s:enumeration value="TELBOROvernight" />
+ <s:enumeration value="TELBOR1Week" />
+ <s:enumeration value="TELBOR1Month" />
+ <s:enumeration value="TELBOR2Month" />
+ <s:enumeration value="TELBOR3Month" />
+ <s:enumeration value="TELBOR6Month" />
+ <s:enumeration value="TELBOR9Month" />
+ <s:enumeration value="TELBOR1Year" />
+ <s:enumeration value="CHIBOROvernight" />
+ <s:enumeration value="CHIBOR1Week" />
+ <s:enumeration value="CHIBOR2Week" />
+ <s:enumeration value="CHIBOR3Week" />
+ <s:enumeration value="CHIBOR1Month" />
+ <s:enumeration value="CHIBOR2Month" />
+ <s:enumeration value="CHIBOR3Month" />
+ <s:enumeration value="CHIBOR4Month" />
+ <s:enumeration value="CHIBOR6Month" />
+ <s:enumeration value="CHIBOR9Month" />
+ <s:enumeration value="CHIBOR1Year" />
+ <s:enumeration value="SHIBOROvernight" />
+ <s:enumeration value="SHIBOR1Week" />
+ <s:enumeration value="SHIBOR2Week" />
+ <s:enumeration value="SHIBOR1Month" />
+ <s:enumeration value="SHIBOR3Month" />
+ <s:enumeration value="SHIBOR6Month" />
+ <s:enumeration value="SHIBOR9Month" />
+ <s:enumeration value="SHIBOR1Year" />
+ <s:enumeration value="JIBOR1Month" />
+ <s:enumeration value="JIBOR3Month" />
+ <s:enumeration value="JIBOR6Month" />
+ <s:enumeration value="JIBOROvernight" />
+ <s:enumeration value="JIBOR1Week" />
+ <s:enumeration value="JIBOR1Year" />
+ <s:enumeration value="KLIBOR1Month" />
+ <s:enumeration value="KLIBOR2Month" />
+ <s:enumeration value="KLIBOR3Month" />
+ <s:enumeration value="KLIBOR6Month" />
+ <s:enumeration value="KLIBOR9Month" />
+ <s:enumeration value="KLIBOR1Year" />
+ <s:enumeration value="TIBOR1Month" />
+ <s:enumeration value="TIBOR2Month" />
+ <s:enumeration value="TIBOR3Month" />
+ <s:enumeration value="TIBOR6Month" />
+ <s:enumeration value="TIBOR9Month" />
+ <s:enumeration value="TIBOR1Year" />
+ <s:enumeration value="PHIBOR1Month" />
+ <s:enumeration value="PHIBOR2Month" />
+ <s:enumeration value="PHIBOR3Month" />
+ <s:enumeration value="PHIBOR6Month" />
+ <s:enumeration value="PHIBOR1Year" />
+ <s:enumeration value="BKIBOR1Month" />
+ <s:enumeration value="BKIBOR2Month" />
+ <s:enumeration value="BKIBOR3Month" />
+ <s:enumeration value="BKIBOR6Month" />
+ <s:enumeration value="BKIBOR9Month" />
+ <s:enumeration value="BKIBOR1Year" />
+ <s:enumeration value="VNIBOR1Month" />
+ <s:enumeration value="VNIBOR1Week" />
+ <s:enumeration value="VNIBOR2Week" />
+ <s:enumeration value="VNIBOR2Month" />
+ <s:enumeration value="VNIBOR3Month" />
+ <s:enumeration value="VNIBOR6Month" />
+ <s:enumeration value="VNIBOR1Year" />
+ <s:enumeration value="KAIBOR1Week" />
+ <s:enumeration value="KAIBOR2Week" />
+ <s:enumeration value="KAIBOR1Month" />
+ <s:enumeration value="KAIBOR2Month" />
+ <s:enumeration value="KAIBOR3Month" />
+ <s:enumeration value="KAIBID1Week" />
+ <s:enumeration value="KAIBID2Week" />
+ <s:enumeration value="KAIBID1Month" />
+ <s:enumeration value="KAIBID2Month" />
+ <s:enumeration value="KAIBID3Month" />
+ <s:enumeration value="KIBOR1Week" />
+ <s:enumeration value="KIBOR2Week" />
+ <s:enumeration value="KIBOR1Month" />
+ <s:enumeration value="KIBOR3Month" />
+ <s:enumeration value="KIBOR6Month" />
+ <s:enumeration value="KIBOR9Month" />
+ <s:enumeration value="KIBOR1Year" />
+ <s:enumeration value="KIBOR2Year" />
+ <s:enumeration value="KIBOR3Year" />
+ <s:enumeration value="KIBID1Week" />
+ <s:enumeration value="KIBID2Week" />
+ <s:enumeration value="KIBID1Month" />
+ <s:enumeration value="KIBID3Month" />
+ <s:enumeration value="KIBID6Month" />
+ <s:enumeration value="KIBID9Month" />
+ <s:enumeration value="KIBID1Year" />
+ <s:enumeration value="KIBID2Year" />
+ <s:enumeration value="KIBID3Year" />
+ <s:enumeration value="MOSIBOROvernight" />
+ <s:enumeration value="MOSIBOR1Week" />
+ <s:enumeration value="MOSIBOR1Month" />
+ <s:enumeration value="MOSIBOR3Month" />
+ <s:enumeration value="MOSIBOR6Month" />
+ <s:enumeration value="MOSIBOR1Year" />
+ <s:enumeration value="MOSIBIDOvernight" />
+ <s:enumeration value="MOSIBID1Week" />
+ <s:enumeration value="MOSIBID1Month" />
+ <s:enumeration value="MOSIBID3Month" />
+ <s:enumeration value="MOSIBID6Month" />
+ <s:enumeration value="MOSIBID1Year" />
+ <s:enumeration value="BRAZIBOROvernight" />
+ <s:enumeration value="BRAZIBOR1Year" />
+ <s:enumeration value="TRLIBOROvernight" />
+ <s:enumeration value="TRLIBOR1Week" />
+ <s:enumeration value="TRLIBOR1Month" />
+ <s:enumeration value="TRLIBOR2Month" />
+ <s:enumeration value="TRLIBOR3Month" />
+ <s:enumeration value="TRLIBOR6Month" />
+ <s:enumeration value="TRLIBOR9Month" />
+ <s:enumeration value="TRLIBOR1Year" />
+ <s:enumeration value="TRLIBIDOvernight" />
+ <s:enumeration value="TRLIBID1Week" />
+ <s:enumeration value="TRLIBID1Month" />
+ <s:enumeration value="TRLIBID2Month" />
+ <s:enumeration value="TRLIBID3Month" />
+ <s:enumeration value="TRLIBID6Month" />
+ <s:enumeration value="TRLIBID9Month" />
+ <s:enumeration value="TRLIBID1Year" />
+ <s:enumeration value="JIBAR1Month" />
+ <s:enumeration value="JIBAR3Month" />
+ <s:enumeration value="JIBAR6Month" />
+ <s:enumeration value="JIBAR9Month" />
+ <s:enumeration value="JIBAR1Year" />
+ <s:enumeration value="TAIBOR1Week" />
+ <s:enumeration value="TAIBOR2Week" />
+ <s:enumeration value="TAIBOR1Month" />
+ <s:enumeration value="TAIBOR2Month" />
+ <s:enumeration value="TAIBOR3Month" />
+ <s:enumeration value="TAIBOR6Month" />
+ <s:enumeration value="TAIBOR9Month" />
+ <s:enumeration value="TAIBOR1Year" />
+ <s:enumeration value="BRIBOROvernight" />
+ <s:enumeration value="BRIBOR1Week" />
+ <s:enumeration value="BRIBOR2Week" />
+ <s:enumeration value="BRIBOR1Month" />
+ <s:enumeration value="BRIBOR2Month" />
+ <s:enumeration value="BRIBOR3Month" />
+ <s:enumeration value="BRIBOR6Month" />
+ <s:enumeration value="BRIBOR9Month" />
+ <s:enumeration value="BRIBOR1Year" />
+ <s:enumeration value="BRIBIDOvernight" />
+ <s:enumeration value="BRIBID1Week" />
+ <s:enumeration value="BRIBID2Week" />
+ <s:enumeration value="BRIBID1Month" />
+ <s:enumeration value="BRIBID2Month" />
+ <s:enumeration value="BRIBID3Month" />
+ <s:enumeration value="BRIBID6Month" />
+ <s:enumeration value="BRIBID9Month" />
+ <s:enumeration value="BRIBID1Year" />
+ <s:enumeration value="EleventhDistrictCOFI" />
+ <s:enumeration value="FNMA30YearRequiredNetYield10Days" />
+ <s:enumeration value="FNMA30YearRequiredNetYield30Days" />
+ <s:enumeration value="FNMA30YearRequiredNetYield60Days" />
+ <s:enumeration value="FNMA30YearRequiredNetYield90Days" />
+ <s:enumeration value="FNMA15YearRequiredNetYield10Days" />
+ <s:enumeration value="FNMA15YearRequiredNetYield30Days" />
+ <s:enumeration value="FNMA15YearRequiredNetYield60Days" />
+ <s:enumeration value="FNMA15YearRequiredNetYield90Days" />
+ <s:enumeration value="FNMA7YearRequiredNetYield10Days" />
+ <s:enumeration value="FNMA7YearRequiredNetYield30Days" />
+ <s:enumeration value="FNMA7YearRequiredNetYield60Days" />
+ <s:enumeration value="FNMA7YearRequiredNetYield90Days" />
+ <s:enumeration value="FHLMC1YearARM" />
+ <s:enumeration value="CETES28" />
+ <s:enumeration value="CETES91" />
+ <s:enumeration value="TIIE28" />
+ <s:enumeration value="TIIE91" />
+ <s:enumeration value="BPA" />
+ <s:enumeration value="WIFR" />
+ <s:enumeration value="CanadianOvernightTargetRate" />
+ <s:enumeration value="CanadianOvernightRate" />
+ <s:enumeration value="CanadianBankRate" />
+ <s:enumeration value="CanadianOvernightRepoRate" />
+ <s:enumeration value="CanadianOperatingBandHigh" />
+ <s:enumeration value="CanadianOperatingBandLow" />
+ <s:enumeration value="CanadianLVTSSettlementBalancesTarget" />
+ <s:enumeration value="CanadianLVTSSettlementBalancesActual" />
+ <s:enumeration value="CanadianBankersAcceptances1Month" />
+ <s:enumeration value="CanadianBankersAcceptances3Month" />
+ <s:enumeration value="CanadianPrimeCorporatePaperRate1Month" />
+ <s:enumeration value="CanadianPrimeCorporatePaperRate2Month" />
+ <s:enumeration value="CanadianPrimeCorporatePaperRate3Month" />
+ <s:enumeration value="CanadianPrimeBusiness" />
+ <s:enumeration value="CanadianConventionalMortgage1Year" />
+ <s:enumeration value="CanadianConventionalMortgage3Year" />
+ <s:enumeration value="CanadianConventionalMortgage5Year" />
+ <s:enumeration
value="CanadianGuaranteedInvestmentCertificates1Year" />
+ <s:enumeration
value="CanadianGuaranteedInvestmentCertificates3Year" />
+ <s:enumeration
value="CanadianGuaranteedInvestmentCertificates5Year" />
+ <s:enumeration value="Canadian5YearPersonalFixedTerm" />
+ <s:enumeration value="Canadian1MonthTreasuryBill" />
+ <s:enumeration value="Canadian3MonthTreasuryBill" />
+ <s:enumeration value="Canadian6MonthTreasuryBill" />
+ <s:enumeration value="Canadian1YearTreasuryBill" />
+ <s:enumeration value="Canadian2YearBenchmarkBondYield" />
+ <s:enumeration value="Canadian3YearBenchmarkBondYield" />
+ <s:enumeration value="Canadian5YearBenchmarkBondYield" />
+ <s:enumeration value="Canadian7YearBenchmarkBondYield" />
+ <s:enumeration value="Canadian10YearBenchmarkBondYield" />
+ <s:enumeration value="Canadian30YearBenchmarkBondYield" />
+ <s:enumeration value="TennesseeFormulaRate" />
+ <s:enumeration value="TennesseeEffectiveRate" />
+ <s:enumeration value="KansasUsuryRate" />
+ <s:enumeration value="KansasCodeMortgageRate" />
+ <s:enumeration value="MissouriMarketRate" />
+ <s:enumeration value="FederalDiscountPrimaryBoston" />
+ <s:enumeration value="FederalDiscountPrimaryNewYork" />
+ <s:enumeration value="FederalDiscountPrimaryPhiladelphia" />
+ <s:enumeration value="FederalDiscountPrimaryCleveland" />
+ <s:enumeration value="FederalDiscountPrimaryRichmond" />
+ <s:enumeration value="FederalDiscountPrimaryAtlanta" />
+ <s:enumeration value="FederalDiscountPrimaryChicago" />
+ <s:enumeration value="FederalDiscountPrimaryStLouis" />
+ <s:enumeration value="FederalDiscountPrimaryMinneapolis" />
+ <s:enumeration value="FederalDiscountPrimaryKansasCity" />
+ <s:enumeration value="FederalDiscountPrimaryDallas" />
+ <s:enumeration value="FederalDiscountPrimarySanFrancisco" />
+ <s:enumeration value="FederalDiscountSecondaryBoston" />
+ <s:enumeration value="FederalDiscountSecondaryNewYork" />
+ <s:enumeration value="FederalDiscountSecondaryPhiladelphia" />
+ <s:enumeration value="FederalDiscountSecondaryCleveland" />
+ <s:enumeration value="FederalDiscountSecondaryRichmond" />
+ <s:enumeration value="FederalDiscountSecondaryAtlanta" />
+ <s:enumeration value="FederalDiscountSecondaryChicago" />
+ <s:enumeration value="FederalDiscountSecondaryStLouis" />
+ <s:enumeration value="FederalDiscountSecondaryMinneapolis" />
+ <s:enumeration value="FederalDiscountSecondaryKansasCity" />
+ <s:enumeration value="FederalDiscountSecondaryDallas" />
+ <s:enumeration value="FederalDiscountSecondarySanFrancisco" />
+ <s:enumeration value="MuniComposite2YearA" />
+ <s:enumeration value="MuniComposite2YearAA" />
+ <s:enumeration value="MuniComposite2YearAAA" />
+ <s:enumeration value="MuniComposite5YearA" />
+ <s:enumeration value="MuniComposite5YearAA" />
+ <s:enumeration value="MuniComposite5YearAAA" />
+ <s:enumeration value="MuniComposite10YearA" />
+ <s:enumeration value="MuniComposite10YearAA" />
+ <s:enumeration value="MuniComposite10YearAAA" />
+ <s:enumeration value="MuniComposite20YearA" />
+ <s:enumeration value="MuniComposite20YearAA" />
+ <s:enumeration value="MuniComposite20YearAAA" />
+ <s:enumeration value="TreasuryComposite3Month" />
+ <s:enumeration value="TreasuryComposite6Month" />
+ <s:enumeration value="TreasuryComposite2Year" />
+ <s:enumeration value="TreasuryComposite3Year" />
+ <s:enumeration value="TreasuryComposite5Year" />
+ <s:enumeration value="TreasuryComposite10Year" />
+ <s:enumeration value="TreasuryComposite30Year" />
+ <s:enumeration value="NationalAverageContractMortgageRate" />
+ <s:enumeration value="FreddieMacSurvey30YearFixed" />
+ <s:enumeration value="FreddieMacSurvey15YearFixed" />
+ <s:enumeration value="FreddieMacSurvey5YearARM" />
+ <s:enumeration value="FreddieMacSurvey1YearARM" />
+ <s:enumeration value="FreddieMacSurvey30YearFixedPoints" />
+ <s:enumeration value="FreddieMacSurvey15YearFixedPoints" />
+ <s:enumeration value="FreddieMacSurvey5YearARMPoints" />
+ <s:enumeration value="FreddieMacSurvey1YearARMPoints" />
+ <s:enumeration value="BankOfEnglandBaseRate" />
+ <s:enumeration value="EuropeanCentralBankLending" />
+ <s:enumeration value="EuropeanCentralBankRefinancing" />
+ <s:enumeration value="EuropeanCentralBankDeposit" />
+ <s:enumeration value="Invalid" />
+ <s:enumeration value="Dummy" />
+ <s:enumeration value="TreasuryConstant1YearAverage" />
+ <s:enumeration value="TreasuryConstant2YearAverage" />
+ <s:enumeration value="TreasuryConstant3YearAverage" />
+ <s:enumeration value="TreasuryConstant5YearAverage" />
+ <s:enumeration value="TBillSecondaryMarket3MonthAverage" />
+ <s:enumeration value="CommercialPaperFinancial1MonthAverage" />
+ <s:enumeration value="CommercialPaperNonFinancial1MonthAverage"
/>
+ </s:restriction>
+ </s:simpleType>
+ <s:simpleType name="MaturityUnitTypes">
+ <s:restriction base="s:string">
+ <s:enumeration value="Week" />
+ <s:enumeration value="Month" />
+ <s:enumeration value="Year" />
+ <s:enumeration value="Day" />
+ </s:restriction>
+ </s:simpleType>
+ <s:element name="Header" type="tns:Header" />
+ <s:complexType name="Header">
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Username"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="Password"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="Tracer"
type="s:string" />
+ </s:sequence>
+ <s:anyAttribute />
+ </s:complexType>
+ <s:element name="GetLIBOR">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="1" maxOccurs="1" name="Type"
type="tns:LIBORTypes" />
+ <s:element minOccurs="1" maxOccurs="1" name="Currency"
type="tns:LIBORCurrencyTypes" />
+ <s:element minOccurs="0" maxOccurs="1" name="AsOfDate"
type="s:string" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetLIBORResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="GetLIBORResult"
type="tns:LIBORRate" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetStateRate">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="1" maxOccurs="1" name="Type"
type="tns:StateRateTypes" />
+ <s:element minOccurs="0" maxOccurs="1" name="AsOfDate"
type="s:string" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:simpleType name="StateRateTypes">
+ <s:restriction base="s:string">
+ <s:enumeration value="TennesseeFormulaRate" />
+ <s:enumeration value="TennesseeEffectiveRate" />
+ <s:enumeration value="KansasUsuryRate" />
+ <s:enumeration value="KansasCodeMortgageRate" />
+ <s:enumeration value="MissouriMarketRate" />
+ </s:restriction>
+ </s:simpleType>
+ <s:element name="GetStateRateResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetStateRateResult" type="tns:InterestRate" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:complexType name="InterestRate">
+ <s:complexContent mixed="false">
+ <s:extension base="tns:Common">
+ <s:sequence>
+ <s:element minOccurs="1" maxOccurs="1" name="Type"
type="tns:RateTypes" />
+ <s:element minOccurs="0" maxOccurs="1" name="Date"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="Value"
type="s:double" />
+ <s:element minOccurs="0" maxOccurs="1" name="Price"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="Spread"
type="s:double" />
+ <s:element minOccurs="1" maxOccurs="1" name="Change"
type="s:double" />
+ <s:element minOccurs="0" maxOccurs="1" name="Text"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="Description"
type="tns:RateDescription" />
+ </s:sequence>
+ </s:extension>
+ </s:complexContent>
+ </s:complexType>
+ <s:element name="GetStateRates">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="1" maxOccurs="1" name="Type"
type="tns:StateRateTypes" />
+ <s:element minOccurs="0" maxOccurs="1" name="FromDate"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="ToDate"
type="s:string" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetStateRatesResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetStateRatesResult" type="tns:ArrayOfInterestRate" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:complexType name="ArrayOfInterestRate">
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="unbounded"
name="InterestRate" nillable="true" type="tns:InterestRate" />
+ </s:sequence>
+ </s:complexType>
+ <s:element name="GetFederalRate">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="1" maxOccurs="1" name="Type"
type="tns:FederalRateTypes" />
+ <s:element minOccurs="0" maxOccurs="1" name="AsOfDate"
type="s:string" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:simpleType name="FederalRateTypes">
+ <s:restriction base="s:string">
+ <s:enumeration value="PrimaryBoston" />
+ <s:enumeration value="PrimaryNewYork" />
+ <s:enumeration value="PrimaryPhiladelphia" />
+ <s:enumeration value="PrimaryCleveland" />
+ <s:enumeration value="PrimaryRichmond" />
+ <s:enumeration value="PrimaryAtlanta" />
+ <s:enumeration value="PrimaryChicago" />
+ <s:enumeration value="PrimaryStLouis" />
+ <s:enumeration value="PrimaryMinneapolis" />
+ <s:enumeration value="PrimaryKansasCity" />
+ <s:enumeration value="PrimaryDallas" />
+ <s:enumeration value="PrimarySanFrancisco" />
+ <s:enumeration value="SecondaryBoston" />
+ <s:enumeration value="SecondaryNewYork" />
+ <s:enumeration value="SecondaryPhiladelphia" />
+ <s:enumeration value="SecondaryCleveland" />
+ <s:enumeration value="SecondaryRichmond" />
+ <s:enumeration value="SecondaryAtlanta" />
+ <s:enumeration value="SecondaryChicago" />
+ <s:enumeration value="SecondaryStLouis" />
+ <s:enumeration value="SecondaryMinneapolis" />
+ <s:enumeration value="SecondaryKansasCity" />
+ <s:enumeration value="SecondaryDallas" />
+ <s:enumeration value="SecondarySanFrancisco" />
+ </s:restriction>
+ </s:simpleType>
+ <s:element name="GetFederalRateResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetFederalRateResult" type="tns:InterestRate" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetFederalRates">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="1" maxOccurs="1" name="Type"
type="tns:FederalRateTypes" />
+ <s:element minOccurs="0" maxOccurs="1" name="FromDate"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="ToDate"
type="s:string" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetFederalRatesResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetFederalRatesResult" type="tns:ArrayOfInterestRate" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetForwardRateAgreement">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="1" maxOccurs="1" name="FirstType"
type="tns:LIBORTypes" />
+ <s:element minOccurs="1" maxOccurs="1" name="SecondType"
type="tns:LIBORTypes" />
+ <s:element minOccurs="1" maxOccurs="1" name="Currency"
type="tns:LIBORCurrencyTypes" />
+ <s:element minOccurs="0" maxOccurs="1" name="AsOfDate"
type="s:string" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetForwardRateAgreementResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetForwardRateAgreementResult" type="tns:ForwardRateAgreement" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:complexType name="ForwardRateAgreement">
+ <s:complexContent mixed="false">
+ <s:extension base="tns:Common">
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="FirstRate"
type="tns:LIBORRate" />
+ <s:element minOccurs="0" maxOccurs="1" name="SecondRate"
type="tns:LIBORRate" />
+ <s:element minOccurs="0" maxOccurs="1" name="Date"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="SpotDate"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1"
name="FirstFixingDate" type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1"
name="SecondFixingDate" type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="Value"
type="s:double" />
+ <s:element minOccurs="0" maxOccurs="1" name="Text"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="Source"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="Description"
type="tns:RateDescription" />
+ </s:sequence>
+ </s:extension>
+ </s:complexContent>
+ </s:complexType>
+ <s:element name="GetEuroDollarFRAStrip">
+ <s:complexType />
+ </s:element>
+ <s:element name="GetEuroDollarFRAStripResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetEuroDollarFRAStripResult" type="tns:ArrayOfEuroDollarFRA" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:complexType name="ArrayOfEuroDollarFRA">
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="unbounded"
name="EuroDollarFRA" nillable="true" type="tns:EuroDollarFRA" />
+ </s:sequence>
+ </s:complexType>
+ <s:complexType name="EuroDollarFRA">
+ <s:complexContent mixed="false">
+ <s:extension base="tns:Common">
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Date"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="Symbol"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="Last"
type="s:double" />
+ <s:element minOccurs="1" maxOccurs="1" name="Rate"
type="s:double" />
+ </s:sequence>
+ </s:extension>
+ </s:complexContent>
+ </s:complexType>
+ <s:element name="GetSwapRate">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="1" maxOccurs="1" name="Type"
type="tns:SwapRateTypes" />
+ <s:element minOccurs="1" maxOccurs="1" name="Currency"
type="tns:SwapCurrencyTypes" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:simpleType name="SwapRateTypes">
+ <s:restriction base="s:string">
+ <s:enumeration value="Overnight" />
+ <s:enumeration value="OneWeek" />
+ <s:enumeration value="TwoWeek" />
+ <s:enumeration value="OneMonth" />
+ <s:enumeration value="TwoMonth" />
+ <s:enumeration value="ThreeMonth" />
+ <s:enumeration value="FourMonth" />
+ <s:enumeration value="FiveMonth" />
+ <s:enumeration value="SixMonth" />
+ <s:enumeration value="SevenMonth" />
+ <s:enumeration value="EightMonth" />
+ <s:enumeration value="NineMonth" />
+ <s:enumeration value="TenMonth" />
+ <s:enumeration value="ElevenMonth" />
+ <s:enumeration value="OneYear" />
+ <s:enumeration value="FifteenMonth" />
+ <s:enumeration value="EighteenMonth" />
+ <s:enumeration value="TwentyOneMonth" />
+ <s:enumeration value="TwoYear" />
+ <s:enumeration value="ThreeYear" />
+ <s:enumeration value="FourYear" />
+ <s:enumeration value="FiveYear" />
+ <s:enumeration value="SixYear" />
+ <s:enumeration value="SevenYear" />
+ <s:enumeration value="EightYear" />
+ <s:enumeration value="NineYear" />
+ <s:enumeration value="TenYear" />
+ <s:enumeration value="ElevenYear" />
+ <s:enumeration value="TwelveYear" />
+ <s:enumeration value="ThirteenYear" />
+ <s:enumeration value="FourteenYear" />
+ <s:enumeration value="FifteenYear" />
+ <s:enumeration value="TwentyYear" />
+ <s:enumeration value="TwentyFiveYear" />
+ <s:enumeration value="ThirtyYear" />
+ <s:enumeration value="ThirtyFiveYear" />
+ <s:enumeration value="FortyYear" />
+ <s:enumeration value="FortyFiveYear" />
+ <s:enumeration value="FiftyYear" />
+ </s:restriction>
+ </s:simpleType>
+ <s:simpleType name="SwapCurrencyTypes">
+ <s:restriction base="s:string">
+ <s:enumeration value="USD" />
+ <s:enumeration value="EUR" />
+ <s:enumeration value="GBP" />
+ <s:enumeration value="CHF" />
+ <s:enumeration value="JPY" />
+ <s:enumeration value="AUD" />
+ <s:enumeration value="CAD" />
+ <s:enumeration value="DKK" />
+ <s:enumeration value="NZD" />
+ <s:enumeration value="NOK" />
+ <s:enumeration value="ISK" />
+ <s:enumeration value="SGD" />
+ <s:enumeration value="PLN" />
+ <s:enumeration value="SEK" />
+ <s:enumeration value="CZK" />
+ <s:enumeration value="HUF" />
+ <s:enumeration value="SAR" />
+ <s:enumeration value="THB" />
+ <s:enumeration value="TWD" />
+ <s:enumeration value="ZAR" />
+ <s:enumeration value="MXN" />
+ <s:enumeration value="KRW" />
+ <s:enumeration value="SKK" />
+ <s:enumeration value="TRY" />
+ <s:enumeration value="HKD" />
+ <s:enumeration value="IDR" />
+ <s:enumeration value="INR" />
+ <s:enumeration value="MYR" />
+ <s:enumeration value="PHP" />
+ <s:enumeration value="CNY" />
+ </s:restriction>
+ </s:simpleType>
+ <s:element name="GetSwapRateResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetSwapRateResult" type="tns:SwapRate" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:complexType name="SwapRate">
+ <s:complexContent mixed="false">
+ <s:extension base="tns:Common">
+ <s:sequence>
+ <s:element minOccurs="1" maxOccurs="1" name="Type"
type="tns:SwapRateTypes" />
+ <s:element minOccurs="0" maxOccurs="1" name="Date"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="Currency"
type="tns:SwapCurrencyTypes" />
+ <s:element minOccurs="1" maxOccurs="1" name="Bid"
type="s:double" />
***The diff for this file has been truncated for email.***
=======================================
--- /dev/null
+++
/trunk/Excel_Plugin/XClient/Web_References/com.xignite.www/Reference.map
Sun Jan 17 01:18:44 2010
@@ -0,0 +1,6 @@
+<?xml version="1.0" encoding="utf-8"?>
+<DiscoveryClientResultsFile
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
+ <Results>
+ <DiscoveryClientResult
referenceType="System.Web.Services.Discovery.ContractReference"
url="http://www.xignite.com/xHistorical.asmx?WSDL"
filename="xHistorical.wsdl" />
+ </Results>
+</DiscoveryClientResultsFile>
=======================================
--- /dev/null
+++
/trunk/Excel_Plugin/XClient/Web_References/com.xignite.www/xHistorical.wsdl
Sun Jan 17 01:18:44 2010
@@ -0,0 +1,2360 @@
+<?xml version="1.0" encoding="utf-8"?>
+<wsdl:definitions xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/"
xmlns:tm="http://microsoft.com/wsdl/mime/textMatching/"
xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/"
xmlns:tns="http://www.xignite.com/services/"
xmlns:s="http://www.w3.org/2001/XMLSchema"
xmlns:soap12="http://schemas.xmlsoap.org/wsdl/soap12/"
xmlns:http="http://schemas.xmlsoap.org/wsdl/http/"
targetNamespace="http://www.xignite.com/services/"
xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">
+ <wsdl:documentation xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">This
web service provides historical security pricing for US
equities.</wsdl:documentation>
+ <wsdl:types>
+ <s:schema elementFormDefault="qualified"
targetNamespace="http://www.xignite.com/services/">
+ <s:element name="GetLastClosingPrice">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Identifier"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="IdentifierType"
type="tns:IdentifierTypes" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:simpleType name="IdentifierTypes">
+ <s:restriction base="s:string">
+ <s:enumeration value="Symbol" />
+ <s:enumeration value="CIK" />
+ <s:enumeration value="CUSIP" />
+ <s:enumeration value="ISIN" />
+ <s:enumeration value="Valoren" />
+ </s:restriction>
+ </s:simpleType>
+ <s:element name="GetLastClosingPriceResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetLastClosingPriceResult" type="tns:HistoricalQuote" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:complexType name="HistoricalQuote">
+ <s:complexContent mixed="false">
+ <s:extension base="tns:Common">
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Security"
type="tns:Security" />
+ <s:element minOccurs="0" maxOccurs="1" name="Date"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="Last"
type="s:double" />
+ <s:element minOccurs="1" maxOccurs="1" name="Open"
type="s:double" />
+ <s:element minOccurs="1" maxOccurs="1" name="LastClose"
type="s:double" />
+ <s:element minOccurs="1" maxOccurs="1" name="High"
type="s:double" />
+ <s:element minOccurs="1" maxOccurs="1" name="Low"
type="s:double" />
+ <s:element minOccurs="1" maxOccurs="1" name="ChangeFromOpen"
type="s:double" />
+ <s:element minOccurs="1" maxOccurs="1"
name="PercentChangeFromOpen" type="s:double" />
+ <s:element minOccurs="1" maxOccurs="1"
name="ChangeFromLastClose" type="s:double" />
+ <s:element minOccurs="1" maxOccurs="1"
name="PercentChangeFromLastClose" type="s:double" />
+ <s:element minOccurs="1" maxOccurs="1" name="Volume"
type="s:double" />
+ <s:element minOccurs="1" maxOccurs="1" name="SplitRatio"
type="s:double" />
+ <s:element minOccurs="1" maxOccurs="1" name="LastAdjusted"
type="s:double" />
+ <s:element minOccurs="1" maxOccurs="1" name="OpenAdjusted"
type="s:double" />
+ <s:element minOccurs="1" maxOccurs="1"
name="LastCloseAdjusted" type="s:double" />
+ <s:element minOccurs="1" maxOccurs="1" name="HighAdjusted"
type="s:double" />
+ <s:element minOccurs="1" maxOccurs="1" name="LowAdjusted"
type="s:double" />
+ <s:element minOccurs="1" maxOccurs="1"
name="ChangeFromOpenAdjusted" type="s:double" />
+ <s:element minOccurs="1" maxOccurs="1"
name="ChangeFromLastCloseAdjusted" type="s:double" />
+ <s:element minOccurs="1" maxOccurs="1" name="VolumeAdjusted"
type="s:double" />
+ <s:element minOccurs="1" maxOccurs="1" name="NotTraded"
type="s:boolean" />
+ </s:sequence>
+ </s:extension>
+ </s:complexContent>
+ </s:complexType>
+ <s:complexType name="Common">
+ <s:sequence>
+ <s:element minOccurs="1" maxOccurs="1" name="Outcome"
type="tns:OutcomeTypes" />
+ <s:element minOccurs="0" maxOccurs="1" name="Message"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="Identity"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="Delay"
type="s:double" />
+ </s:sequence>
+ </s:complexType>
+ <s:simpleType name="OutcomeTypes">
+ <s:restriction base="s:string">
+ <s:enumeration value="Success" />
+ <s:enumeration value="SystemError" />
+ <s:enumeration value="RequestError" />
+ <s:enumeration value="RegistrationError" />
+ </s:restriction>
+ </s:simpleType>
+ <s:complexType name="Security">
+ <s:complexContent mixed="false">
+ <s:extension base="tns:Common">
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="CIK"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="Cusip"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="Symbol"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="ISIN"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="Valoren"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="Name"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="Market"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1"
name="CategoryOrIndustry" type="s:string" />
+ </s:sequence>
+ </s:extension>
+ </s:complexContent>
+ </s:complexType>
+ <s:element name="Header" type="tns:Header" />
+ <s:complexType name="Header">
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Username"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="Password"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="Tracer"
type="s:string" />
+ </s:sequence>
+ <s:anyAttribute />
+ </s:complexType>
+ <s:element name="GetLastClosingPrices">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Identifiers"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="IdentifierType"
type="tns:IdentifierTypes" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetLastClosingPricesResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetLastClosingPricesResult" type="tns:ArrayOfHistoricalQuote" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:complexType name="ArrayOfHistoricalQuote">
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="unbounded"
name="HistoricalQuote" nillable="true" type="tns:HistoricalQuote" />
+ </s:sequence>
+ </s:complexType>
+ <s:element name="GetLastClosingPricesOrdered">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Identifiers"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="IdentifierType"
type="tns:IdentifierTypes" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetLastClosingPricesOrderedResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetLastClosingPricesOrderedResult" type="tns:ArrayOfHistoricalQuote"
/>
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetHistoricalHighLow">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Identifier"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="IdentifierType"
type="tns:IdentifierTypes" />
+ <s:element minOccurs="0" maxOccurs="1" name="StartDate"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="EndDate"
type="s:string" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetHistoricalHighLowResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetHistoricalHighLowResult" type="tns:HistoricalHighLow" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:complexType name="HistoricalHighLow">
+ <s:complexContent mixed="false">
+ <s:extension base="tns:Common">
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Security"
type="tns:Security" />
+ <s:element minOccurs="0" maxOccurs="1" name="FromDate"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="ToDate"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="High"
type="s:double" />
+ <s:element minOccurs="1" maxOccurs="1" name="Low"
type="s:double" />
+ </s:sequence>
+ </s:extension>
+ </s:complexContent>
+ </s:complexType>
+ <s:element name="GetHistoricalQuote">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Identifier"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="IdentifierType"
type="tns:IdentifierTypes" />
+ <s:element minOccurs="0" maxOccurs="1" name="AsOfDate"
type="s:string" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetHistoricalQuoteResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetHistoricalQuoteResult" type="tns:HistoricalQuote" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetHistoricalQuotes">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Identifiers"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="IdentifierType"
type="tns:IdentifierTypes" />
+ <s:element minOccurs="0" maxOccurs="1" name="AsOfDate"
type="s:string" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetHistoricalQuotesResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetHistoricalQuotesResult" type="tns:ArrayOfHistoricalQuote" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetHistoricalQuotesAsOf">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Identifier"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="IdentifierType"
type="tns:IdentifierTypes" />
+ <s:element minOccurs="0" maxOccurs="1" name="EndDate"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="PeriodType"
type="tns:PeriodTypes" />
+ <s:element minOccurs="1" maxOccurs="1" name="Periods"
type="s:int" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:simpleType name="PeriodTypes">
+ <s:restriction base="s:string">
+ <s:enumeration value="Day" />
+ <s:enumeration value="Week" />
+ <s:enumeration value="Month" />
+ <s:enumeration value="Quarter" />
+ <s:enumeration value="Year" />
+ </s:restriction>
+ </s:simpleType>
+ <s:element name="GetHistoricalQuotesAsOfResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetHistoricalQuotesAsOfResult" type="tns:HistoricalQuotes" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:complexType name="HistoricalQuotes">
+ <s:complexContent mixed="false">
+ <s:extension base="tns:Common">
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Security"
type="tns:Security" />
+ <s:element minOccurs="0" maxOccurs="1" name="StartDate"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="EndDate"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="Quotes"
type="tns:ArrayOfHistoricalQuote" />
+ </s:sequence>
+ </s:extension>
+ </s:complexContent>
+ </s:complexType>
+ <s:element name="GetHistoricalQuotesRange">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Identifier"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="IdentifierType"
type="tns:IdentifierTypes" />
+ <s:element minOccurs="0" maxOccurs="1" name="StartDate"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="EndDate"
type="s:string" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetHistoricalQuotesRangeResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetHistoricalQuotesRangeResult" type="tns:HistoricalQuotes" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetHistoricalMonthlyQuotesRange">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Identifier"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="IdentifierType"
type="tns:IdentifierTypes" />
+ <s:element minOccurs="0" maxOccurs="1" name="StartDate"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="EndDate"
type="s:string" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetHistoricalMonthlyQuotesRangeResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetHistoricalMonthlyQuotesRangeResult" type="tns:HistoricalQuotes" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetTopMovers">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="AsOfDate"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="Count"
type="s:int" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetTopMoversResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetTopMoversResult" type="tns:ArrayOfTop" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:complexType name="ArrayOfTop">
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="unbounded" name="Top"
nillable="true" type="tns:Top" />
+ </s:sequence>
+ </s:complexType>
+ <s:complexType name="Top">
+ <s:complexContent mixed="false">
+ <s:extension base="tns:Common">
+ <s:sequence>
+ <s:element minOccurs="1" maxOccurs="1" name="Rank"
type="s:int" />
+ <s:element minOccurs="1" maxOccurs="1" name="Type"
type="tns:TopTypes" />
+ <s:element minOccurs="0" maxOccurs="1" name="Quote"
type="tns:HistoricalQuote" />
+ </s:sequence>
+ </s:extension>
+ </s:complexContent>
+ </s:complexType>
+ <s:simpleType name="TopTypes">
+ <s:restriction base="s:string">
+ <s:enumeration value="Gainers" />
+ <s:enumeration value="Losers" />
+ <s:enumeration value="Movers" />
+ </s:restriction>
+ </s:simpleType>
+ <s:element name="GetTopGainers">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="AsOfDate"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="Count"
type="s:int" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetTopGainersResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetTopGainersResult" type="tns:ArrayOfTop" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetTopLosers">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="AsOfDate"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="Count"
type="s:int" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetTopLosersResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetTopLosersResult" type="tns:ArrayOfTop" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetDividendHistory">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Identifier"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="IdentifierType"
type="tns:IdentifierTypes" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetDividendHistoryResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetDividendHistoryResult" type="tns:DividendHistory" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:complexType name="DividendHistory">
+ <s:complexContent mixed="false">
+ <s:extension base="tns:Common">
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Symbol"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="Dividends"
type="tns:ArrayOfDividend" />
+ </s:sequence>
+ </s:extension>
+ </s:complexContent>
+ </s:complexType>
+ <s:complexType name="ArrayOfDividend">
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="unbounded" name="Dividend"
nillable="true" type="tns:Dividend" />
+ </s:sequence>
+ </s:complexType>
+ <s:complexType name="Dividend">
+ <s:complexContent mixed="false">
+ <s:extension base="tns:Common">
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Date"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="Amount"
type="s:double" />
+ </s:sequence>
+ </s:extension>
+ </s:complexContent>
+ </s:complexType>
+ <s:element name="GetDividendHistoryRange">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Identifier"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="IdentifierType"
type="tns:IdentifierTypes" />
+ <s:element minOccurs="0" maxOccurs="1" name="StartDate"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="EndDate"
type="s:string" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetDividendHistoryRangeResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetDividendHistoryRangeResult" type="tns:DividendHistory" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetExtendedDividendHistory">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Identifier"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="IdentifierType"
type="tns:IdentifierTypes" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetExtendedDividendHistoryResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetExtendedDividendHistoryResult" type="tns:ExtendedDividendHistory"
/>
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:complexType name="ExtendedDividendHistory">
+ <s:complexContent mixed="false">
+ <s:extension base="tns:Common">
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Symbol"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="Dividends"
type="tns:ArrayOfExtendedDividend" />
+ </s:sequence>
+ </s:extension>
+ </s:complexContent>
+ </s:complexType>
+ <s:complexType name="ArrayOfExtendedDividend">
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="unbounded"
name="ExtendedDividend" nillable="true" type="tns:ExtendedDividend" />
+ </s:sequence>
+ </s:complexType>
+ <s:complexType name="ExtendedDividend">
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Symbol"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="ExDate"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="RecordDate"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="PayDate"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="Amount"
type="s:double" />
+ <s:element minOccurs="1" maxOccurs="1" name="Yield"
type="s:double" />
+ </s:sequence>
+ </s:complexType>
+ <s:element name="GetSplitHistory">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Identifier"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="IdentifierType"
type="tns:IdentifierTypes" />
+ <s:element minOccurs="0" maxOccurs="1" name="StartDate"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="EndDate"
type="s:string" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetSplitHistoryResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetSplitHistoryResult" type="tns:SplitHistory" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:complexType name="SplitHistory">
+ <s:complexContent mixed="false">
+ <s:extension base="tns:Common">
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Security"
type="tns:Security" />
+ <s:element minOccurs="0" maxOccurs="1" name="Splits"
type="tns:ArrayOfSplit" />
+ </s:sequence>
+ </s:extension>
+ </s:complexContent>
+ </s:complexType>
+ <s:complexType name="ArrayOfSplit">
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="unbounded" name="Split"
nillable="true" type="tns:Split" />
+ </s:sequence>
+ </s:complexType>
+ <s:complexType name="Split">
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Date"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="Ratio"
type="s:double" />
+ <s:element minOccurs="1" maxOccurs="1" name="CumulatedRatio"
type="s:double" />
+ <s:element minOccurs="0" maxOccurs="1" name="Text"
type="s:string" />
+ </s:sequence>
+ </s:complexType>
+ <s:element name="GetAllSplits">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="StartDate"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="EndDate"
type="s:string" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetAllSplitsResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetAllSplitsResult" type="tns:ArrayOfSplitHistory" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:complexType name="ArrayOfSplitHistory">
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="unbounded"
name="SplitHistory" nillable="true" type="tns:SplitHistory" />
+ </s:sequence>
+ </s:complexType>
+ <s:element name="GetAllExtendedDividends">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="StartDate"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="EndDate"
type="s:string" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetAllExtendedDividendsResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetAllExtendedDividendsResult" type="tns:ExtendedDividendHistory" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetAllDividends">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="StartDate"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="EndDate"
type="s:string" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetAllDividendsResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetAllDividendsResult" type="tns:ArrayOfSplitHistory" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetSplitRatio">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Identifier"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="IdentifierType"
type="tns:IdentifierTypes" />
+ <s:element minOccurs="0" maxOccurs="1" name="StartDate"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="EndDate"
type="s:string" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetSplitRatioResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetSplitRatioResult" type="tns:SplitRatio" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:complexType name="SplitRatio">
+ <s:complexContent mixed="false">
+ <s:extension base="tns:Common">
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Security"
type="tns:Security" />
+ <s:element minOccurs="1" maxOccurs="1" name="Ratio"
type="s:double" />
+ <s:element minOccurs="0" maxOccurs="1" name="FromDate"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="ToDate"
type="s:string" />
+ </s:sequence>
+ </s:extension>
+ </s:complexContent>
+ </s:complexType>
+ <s:element name="GetSymbols">
+ <s:complexType />
+ </s:element>
+ <s:element name="GetSymbolsResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="GetSymbolsResult"
type="tns:SymbolList" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:complexType name="SymbolList">
+ <s:complexContent mixed="false">
+ <s:extension base="tns:Common">
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Symbol"
type="tns:ArrayOfString" />
+ </s:sequence>
+ </s:extension>
+ </s:complexContent>
+ </s:complexType>
+ <s:complexType name="ArrayOfString">
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="unbounded" name="string"
nillable="true" type="s:string" />
+ </s:sequence>
+ </s:complexType>
+ <s:element name="GetAdvancesAndDeclines">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="AsOfDate"
type="s:string" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:element name="GetAdvancesAndDeclinesResponse">
+ <s:complexType>
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1"
name="GetAdvancesAndDeclinesResult" type="tns:AdvancesAndDeclines" />
+ </s:sequence>
+ </s:complexType>
+ </s:element>
+ <s:complexType name="AdvancesAndDeclines">
+ <s:complexContent mixed="false">
+ <s:extension base="tns:Common">
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="AsOfDate"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="MarketChanges"
type="tns:ArrayOfMarketChange" />
+ </s:sequence>
+ </s:extension>
+ </s:complexContent>
+ </s:complexType>
+ <s:complexType name="ArrayOfMarketChange">
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="unbounded"
name="MarketChange" nillable="true" type="tns:MarketChange" />
+ </s:sequence>
+ </s:complexType>
+ <s:complexType name="MarketChange">
+ <s:sequence>
+ <s:element minOccurs="0" maxOccurs="1" name="Exchange"
type="s:string" />
+ <s:element minOccurs="0" maxOccurs="1" name="Type"
type="s:string" />
+ <s:element minOccurs="1" maxOccurs="1" name="Count" type="s:int"
/>
+ </s:sequence>
+ </s:complexType>
+ <s:element name="HistoricalQuote" nillable="true"
type="tns:HistoricalQuote" />
+ <s:element name="ArrayOfHistoricalQuote" nillable="true"
type="tns:ArrayOfHistoricalQuote" />
+ <s:element name="HistoricalHighLow" nillable="true"
type="tns:HistoricalHighLow" />
+ <s:element name="HistoricalQuotes" nillable="true"
type="tns:HistoricalQuotes" />
+ <s:element name="ArrayOfTop" nillable="true" type="tns:ArrayOfTop" />
+ <s:element name="DividendHistory" nillable="true"
type="tns:DividendHistory" />
+ <s:element name="ExtendedDividendHistory" nillable="true"
type="tns:ExtendedDividendHistory" />
+ <s:element name="SplitHistory" nillable="true"
type="tns:SplitHistory" />
+ <s:element name="ArrayOfSplitHistory" nillable="true"
type="tns:ArrayOfSplitHistory" />
+ <s:element name="SplitRatio" nillable="true" type="tns:SplitRatio" />
+ <s:element name="SymbolList" nillable="true" type="tns:SymbolList" />
+ <s:element name="AdvancesAndDeclines" nillable="true"
type="tns:AdvancesAndDeclines" />
+ </s:schema>
+ </wsdl:types>
+ <wsdl:message name="GetLastClosingPriceSoapIn">
+ <wsdl:part name="parameters" element="tns:GetLastClosingPrice" />
+ </wsdl:message>
+ <wsdl:message name="GetLastClosingPriceSoapOut">
+ <wsdl:part name="parameters" element="tns:GetLastClosingPriceResponse"
/>
+ </wsdl:message>
+ <wsdl:message name="GetLastClosingPriceHeader">
+ <wsdl:part name="Header" element="tns:Header" />
+ </wsdl:message>
+ <wsdl:message name="GetLastClosingPricesSoapIn">
+ <wsdl:part name="parameters" element="tns:GetLastClosingPrices" />
+ </wsdl:message>
+ <wsdl:message name="GetLastClosingPricesSoapOut">
+ <wsdl:part name="parameters"
element="tns:GetLastClosingPricesResponse" />
+ </wsdl:message>
+ <wsdl:message name="GetLastClosingPricesHeader">
+ <wsdl:part name="Header" element="tns:Header" />
+ </wsdl:message>
+ <wsdl:message name="GetLastClosingPricesOrderedSoapIn">
+ <wsdl:part name="parameters" element="tns:GetLastClosingPricesOrdered"
/>
+ </wsdl:message>
+ <wsdl:message name="GetLastClosingPricesOrderedSoapOut">
+ <wsdl:part name="parameters"
element="tns:GetLastClosingPricesOrderedResponse" />
+ </wsdl:message>
+ <wsdl:message name="GetLastClosingPricesOrderedHeader">
+ <wsdl:part name="Header" element="tns:Header" />
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalHighLowSoapIn">
+ <wsdl:part name="parameters" element="tns:GetHistoricalHighLow" />
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalHighLowSoapOut">
+ <wsdl:part name="parameters"
element="tns:GetHistoricalHighLowResponse" />
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalHighLowHeader">
+ <wsdl:part name="Header" element="tns:Header" />
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalQuoteSoapIn">
+ <wsdl:part name="parameters" element="tns:GetHistoricalQuote" />
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalQuoteSoapOut">
+ <wsdl:part name="parameters" element="tns:GetHistoricalQuoteResponse"
/>
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalQuoteHeader">
+ <wsdl:part name="Header" element="tns:Header" />
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalQuotesSoapIn">
+ <wsdl:part name="parameters" element="tns:GetHistoricalQuotes" />
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalQuotesSoapOut">
+ <wsdl:part name="parameters" element="tns:GetHistoricalQuotesResponse"
/>
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalQuotesHeader">
+ <wsdl:part name="Header" element="tns:Header" />
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalQuotesAsOfSoapIn">
+ <wsdl:part name="parameters" element="tns:GetHistoricalQuotesAsOf" />
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalQuotesAsOfSoapOut">
+ <wsdl:part name="parameters"
element="tns:GetHistoricalQuotesAsOfResponse" />
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalQuotesAsOfHeader">
+ <wsdl:part name="Header" element="tns:Header" />
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalQuotesRangeSoapIn">
+ <wsdl:part name="parameters" element="tns:GetHistoricalQuotesRange" />
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalQuotesRangeSoapOut">
+ <wsdl:part name="parameters"
element="tns:GetHistoricalQuotesRangeResponse" />
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalQuotesRangeHeader">
+ <wsdl:part name="Header" element="tns:Header" />
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalMonthlyQuotesRangeSoapIn">
+ <wsdl:part name="parameters"
element="tns:GetHistoricalMonthlyQuotesRange" />
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalMonthlyQuotesRangeSoapOut">
+ <wsdl:part name="parameters"
element="tns:GetHistoricalMonthlyQuotesRangeResponse" />
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalMonthlyQuotesRangeHeader">
+ <wsdl:part name="Header" element="tns:Header" />
+ </wsdl:message>
+ <wsdl:message name="GetTopMoversSoapIn">
+ <wsdl:part name="parameters" element="tns:GetTopMovers" />
+ </wsdl:message>
+ <wsdl:message name="GetTopMoversSoapOut">
+ <wsdl:part name="parameters" element="tns:GetTopMoversResponse" />
+ </wsdl:message>
+ <wsdl:message name="GetTopMoversHeader">
+ <wsdl:part name="Header" element="tns:Header" />
+ </wsdl:message>
+ <wsdl:message name="GetTopGainersSoapIn">
+ <wsdl:part name="parameters" element="tns:GetTopGainers" />
+ </wsdl:message>
+ <wsdl:message name="GetTopGainersSoapOut">
+ <wsdl:part name="parameters" element="tns:GetTopGainersResponse" />
+ </wsdl:message>
+ <wsdl:message name="GetTopGainersHeader">
+ <wsdl:part name="Header" element="tns:Header" />
+ </wsdl:message>
+ <wsdl:message name="GetTopLosersSoapIn">
+ <wsdl:part name="parameters" element="tns:GetTopLosers" />
+ </wsdl:message>
+ <wsdl:message name="GetTopLosersSoapOut">
+ <wsdl:part name="parameters" element="tns:GetTopLosersResponse" />
+ </wsdl:message>
+ <wsdl:message name="GetTopLosersHeader">
+ <wsdl:part name="Header" element="tns:Header" />
+ </wsdl:message>
+ <wsdl:message name="GetDividendHistorySoapIn">
+ <wsdl:part name="parameters" element="tns:GetDividendHistory" />
+ </wsdl:message>
+ <wsdl:message name="GetDividendHistorySoapOut">
+ <wsdl:part name="parameters" element="tns:GetDividendHistoryResponse"
/>
+ </wsdl:message>
+ <wsdl:message name="GetDividendHistoryHeader">
+ <wsdl:part name="Header" element="tns:Header" />
+ </wsdl:message>
+ <wsdl:message name="GetDividendHistoryRangeSoapIn">
+ <wsdl:part name="parameters" element="tns:GetDividendHistoryRange" />
+ </wsdl:message>
+ <wsdl:message name="GetDividendHistoryRangeSoapOut">
+ <wsdl:part name="parameters"
element="tns:GetDividendHistoryRangeResponse" />
+ </wsdl:message>
+ <wsdl:message name="GetDividendHistoryRangeHeader">
+ <wsdl:part name="Header" element="tns:Header" />
+ </wsdl:message>
+ <wsdl:message name="GetExtendedDividendHistorySoapIn">
+ <wsdl:part name="parameters" element="tns:GetExtendedDividendHistory"
/>
+ </wsdl:message>
+ <wsdl:message name="GetExtendedDividendHistorySoapOut">
+ <wsdl:part name="parameters"
element="tns:GetExtendedDividendHistoryResponse" />
+ </wsdl:message>
+ <wsdl:message name="GetExtendedDividendHistoryHeader">
+ <wsdl:part name="Header" element="tns:Header" />
+ </wsdl:message>
+ <wsdl:message name="GetSplitHistorySoapIn">
+ <wsdl:part name="parameters" element="tns:GetSplitHistory" />
+ </wsdl:message>
+ <wsdl:message name="GetSplitHistorySoapOut">
+ <wsdl:part name="parameters" element="tns:GetSplitHistoryResponse" />
+ </wsdl:message>
+ <wsdl:message name="GetSplitHistoryHeader">
+ <wsdl:part name="Header" element="tns:Header" />
+ </wsdl:message>
+ <wsdl:message name="GetAllSplitsSoapIn">
+ <wsdl:part name="parameters" element="tns:GetAllSplits" />
+ </wsdl:message>
+ <wsdl:message name="GetAllSplitsSoapOut">
+ <wsdl:part name="parameters" element="tns:GetAllSplitsResponse" />
+ </wsdl:message>
+ <wsdl:message name="GetAllSplitsHeader">
+ <wsdl:part name="Header" element="tns:Header" />
+ </wsdl:message>
+ <wsdl:message name="GetAllExtendedDividendsSoapIn">
+ <wsdl:part name="parameters" element="tns:GetAllExtendedDividends" />
+ </wsdl:message>
+ <wsdl:message name="GetAllExtendedDividendsSoapOut">
+ <wsdl:part name="parameters"
element="tns:GetAllExtendedDividendsResponse" />
+ </wsdl:message>
+ <wsdl:message name="GetAllExtendedDividendsHeader">
+ <wsdl:part name="Header" element="tns:Header" />
+ </wsdl:message>
+ <wsdl:message name="GetAllDividendsSoapIn">
+ <wsdl:part name="parameters" element="tns:GetAllDividends" />
+ </wsdl:message>
+ <wsdl:message name="GetAllDividendsSoapOut">
+ <wsdl:part name="parameters" element="tns:GetAllDividendsResponse" />
+ </wsdl:message>
+ <wsdl:message name="GetAllDividendsHeader">
+ <wsdl:part name="Header" element="tns:Header" />
+ </wsdl:message>
+ <wsdl:message name="GetSplitRatioSoapIn">
+ <wsdl:part name="parameters" element="tns:GetSplitRatio" />
+ </wsdl:message>
+ <wsdl:message name="GetSplitRatioSoapOut">
+ <wsdl:part name="parameters" element="tns:GetSplitRatioResponse" />
+ </wsdl:message>
+ <wsdl:message name="GetSplitRatioHeader">
+ <wsdl:part name="Header" element="tns:Header" />
+ </wsdl:message>
+ <wsdl:message name="GetSymbolsSoapIn">
+ <wsdl:part name="parameters" element="tns:GetSymbols" />
+ </wsdl:message>
+ <wsdl:message name="GetSymbolsSoapOut">
+ <wsdl:part name="parameters" element="tns:GetSymbolsResponse" />
+ </wsdl:message>
+ <wsdl:message name="GetSymbolsHeader">
+ <wsdl:part name="Header" element="tns:Header" />
+ </wsdl:message>
+ <wsdl:message name="GetAdvancesAndDeclinesSoapIn">
+ <wsdl:part name="parameters" element="tns:GetAdvancesAndDeclines" />
+ </wsdl:message>
+ <wsdl:message name="GetAdvancesAndDeclinesSoapOut">
+ <wsdl:part name="parameters"
element="tns:GetAdvancesAndDeclinesResponse" />
+ </wsdl:message>
+ <wsdl:message name="GetAdvancesAndDeclinesHeader">
+ <wsdl:part name="Header" element="tns:Header" />
+ </wsdl:message>
+ <wsdl:message name="GetLastClosingPriceHttpGetIn">
+ <wsdl:part name="Identifier" type="s:string" />
+ <wsdl:part name="IdentifierType" type="s:string" />
+ </wsdl:message>
+ <wsdl:message name="GetLastClosingPriceHttpGetOut">
+ <wsdl:part name="Body" element="tns:HistoricalQuote" />
+ </wsdl:message>
+ <wsdl:message name="GetLastClosingPricesHttpGetIn">
+ <wsdl:part name="Identifiers" type="s:string" />
+ <wsdl:part name="IdentifierType" type="s:string" />
+ </wsdl:message>
+ <wsdl:message name="GetLastClosingPricesHttpGetOut">
+ <wsdl:part name="Body" element="tns:ArrayOfHistoricalQuote" />
+ </wsdl:message>
+ <wsdl:message name="GetLastClosingPricesOrderedHttpGetIn">
+ <wsdl:part name="Identifiers" type="s:string" />
+ <wsdl:part name="IdentifierType" type="s:string" />
+ </wsdl:message>
+ <wsdl:message name="GetLastClosingPricesOrderedHttpGetOut">
+ <wsdl:part name="Body" element="tns:ArrayOfHistoricalQuote" />
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalHighLowHttpGetIn">
+ <wsdl:part name="Identifier" type="s:string" />
+ <wsdl:part name="IdentifierType" type="s:string" />
+ <wsdl:part name="StartDate" type="s:string" />
+ <wsdl:part name="EndDate" type="s:string" />
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalHighLowHttpGetOut">
+ <wsdl:part name="Body" element="tns:HistoricalHighLow" />
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalQuoteHttpGetIn">
+ <wsdl:part name="Identifier" type="s:string" />
+ <wsdl:part name="IdentifierType" type="s:string" />
+ <wsdl:part name="AsOfDate" type="s:string" />
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalQuoteHttpGetOut">
+ <wsdl:part name="Body" element="tns:HistoricalQuote" />
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalQuotesHttpGetIn">
+ <wsdl:part name="Identifiers" type="s:string" />
+ <wsdl:part name="IdentifierType" type="s:string" />
+ <wsdl:part name="AsOfDate" type="s:string" />
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalQuotesHttpGetOut">
+ <wsdl:part name="Body" element="tns:ArrayOfHistoricalQuote" />
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalQuotesAsOfHttpGetIn">
+ <wsdl:part name="Identifier" type="s:string" />
+ <wsdl:part name="IdentifierType" type="s:string" />
+ <wsdl:part name="EndDate" type="s:string" />
+ <wsdl:part name="PeriodType" type="s:string" />
+ <wsdl:part name="Periods" type="s:string" />
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalQuotesAsOfHttpGetOut">
+ <wsdl:part name="Body" element="tns:HistoricalQuotes" />
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalQuotesRangeHttpGetIn">
+ <wsdl:part name="Identifier" type="s:string" />
+ <wsdl:part name="IdentifierType" type="s:string" />
+ <wsdl:part name="StartDate" type="s:string" />
+ <wsdl:part name="EndDate" type="s:string" />
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalQuotesRangeHttpGetOut">
+ <wsdl:part name="Body" element="tns:HistoricalQuotes" />
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalMonthlyQuotesRangeHttpGetIn">
+ <wsdl:part name="Identifier" type="s:string" />
+ <wsdl:part name="IdentifierType" type="s:string" />
+ <wsdl:part name="StartDate" type="s:string" />
+ <wsdl:part name="EndDate" type="s:string" />
+ </wsdl:message>
+ <wsdl:message name="GetHistoricalMonthlyQuotesRangeHttpGetOut">
+ <wsdl:part name="Body" element="tns:HistoricalQuotes" />
+ </wsdl:message>
+ <wsdl:message name="GetTopMoversHttpGetIn">
+ <wsdl:part name="AsOfDate" type="s:string" />
+ <wsdl:part name="Count" type="s:string" />
+ </wsdl:message>
+ <wsdl:message name="GetTopMoversHttpGetOut">
+ <wsdl:part name="Body" element="tns:ArrayOfTop" />
+ </wsdl:message>
+ <wsdl:message name="GetTopGainersHttpGetIn">
+ <wsdl:part name="AsOfDate" type="s:string" />
+ <wsdl:part name="Count" type="s:string" />
+ </wsdl:message>
+ <wsdl:message name="GetTopGainersHttpGetOut">
+ <wsdl:part name="Body" element="tns:ArrayOfTop" />
+ </wsdl:message>
+ <wsdl:message name="GetTopLosersHttpGetIn">
+ <wsdl:part name="AsOfDate" type="s:string" />
+ <wsdl:part name="Count" type="s:string" />
+ </wsdl:message>
+ <wsdl:message name="GetTopLosersHttpGetOut">
+ <wsdl:part name="Body" element="tns:ArrayOfTop" />
+ </wsdl:message>
+ <wsdl:message name="GetDividendHistoryHttpGetIn">
+ <wsdl:part name="Identifier" type="s:string" />
+ <wsdl:part name="IdentifierType" type="s:string" />
+ </wsdl:message>
+ <wsdl:message name="GetDividendHistoryHttpGetOut">
+ <wsdl:part name="Body" element="tns:DividendHistory" />
+ </wsdl:message>
+ <wsdl:message name="GetDividendHistoryRangeHttpGetIn">
+ <wsdl:part name="Identifier" type="s:string" />
+ <wsdl:part name="IdentifierType" type="s:string" />
+ <wsdl:part name="StartDate" type="s:string" />
+ <wsdl:part name="EndDate" type="s:string" />
+ </wsdl:message>
+ <wsdl:message name="GetDividendHistoryRangeHttpGetOut">
+ <wsdl:part name="Body" element="tns:DividendHistory" />
+ </wsdl:message>
+ <wsdl:message name="GetExtendedDividendHistoryHttpGetIn">
+ <wsdl:part name="Identifier" type="s:string" />
+ <wsdl:part name="IdentifierType" type="s:string" />
+ </wsdl:message>
+ <wsdl:message name="GetExtendedDividendHistoryHttpGetOut">
+ <wsdl:part name="Body" element="tns:ExtendedDividendHistory" />
+ </wsdl:message>
+ <wsdl:message name="GetSplitHistoryHttpGetIn">
+ <wsdl:part name="Identifier" type="s:string" />
+ <wsdl:part name="IdentifierType" type="s:string" />
+ <wsdl:part name="StartDate" type="s:string" />
+ <wsdl:part name="EndDate" type="s:string" />
+ </wsdl:message>
+ <wsdl:message name="GetSplitHistoryHttpGetOut">
+ <wsdl:part name="Body" element="tns:SplitHistory" />
+ </wsdl:message>
+ <wsdl:message name="GetAllSplitsHttpGetIn">
+ <wsdl:part name="StartDate" type="s:string" />
+ <wsdl:part name="EndDate" type="s:string" />
+ </wsdl:message>
+ <wsdl:message name="GetAllSplitsHttpGetOut">
+ <wsdl:part name="Body" element="tns:ArrayOfSplitHistory" />
+ </wsdl:message>
+ <wsdl:message name="GetAllExtendedDividendsHttpGetIn">
+ <wsdl:part name="StartDate" type="s:string" />
+ <wsdl:part name="EndDate" type="s:string" />
+ </wsdl:message>
+ <wsdl:message name="GetAllExtendedDividendsHttpGetOut">
+ <wsdl:part name="Body" element="tns:ExtendedDividendHistory" />
+ </wsdl:message>
+ <wsdl:message name="GetAllDividendsHttpGetIn">
+ <wsdl:part name="StartDate" type="s:string" />
+ <wsdl:part name="EndDate" type="s:string" />
+ </wsdl:message>
+ <wsdl:message name="GetAllDividendsHttpGetOut">
+ <wsdl:part name="Body" element="tns:ArrayOfSplitHistory" />
+ </wsdl:message>
+ <wsdl:message name="GetSplitRatioHttpGetIn">
+ <wsdl:part name="Identifier" type="s:string" />
+ <wsdl:part name="IdentifierType" type="s:string" />
+ <wsdl:part name="StartDate" type="s:string" />
+ <wsdl:part name="EndDate" type="s:string" />
+ </wsdl:message>
+ <wsdl:message name="GetSplitRatioHttpGetOut">
+ <wsdl:part name="Body" element="tns:SplitRatio" />
+ </wsdl:message>
+ <wsdl:message name="GetSymbolsHttpGetIn" />
+ <wsdl:message name="GetSymbolsHttpGetOut">
+ <wsdl:part name="Body" element="tns:SymbolList" />
+ </wsdl:message>
+ <wsdl:message name="GetAdvancesAndDeclinesHttpGetIn">
+ <wsdl:part name="AsOfDate" type="s:string" />
+ </wsdl:message>
+ <wsdl:message name="GetAdvancesAndDeclinesHttpGetOut">
+ <wsdl:part name="Body" element="tns:AdvancesAndDeclines" />
+ </wsdl:message>
+ <wsdl:message name="GetLastClosingPriceHttpPostIn">
+ <wsdl:part name="Identifier" type="s:string" />
+ <wsdl:part name="IdentifierType" type="s:string" />
+ </wsdl:message>
+ <wsdl:message name="GetLastClosingPriceHttpPostOut">
***The diff for this file has been truncated for email.***
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/XClient.csproj Sun Jan 17 01:18:44 2010
@@ -0,0 +1,448 @@
+
+
+<Project DefaultTargets="Build"
xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
+ 
+ <PropertyGroup>
+
<ProjectTypeGuids>{BAA0C2D2-18E2-41B9-852F-F413020CAA33};{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}</ProjectTypeGuids>
+ <Configuration Condition=" '$(Configuration)'
== '' ">Debug</Configuration>
+ <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
+ <ProjectGuid>{A368E25F-E778-45C6-B946-1BA336609689}</ProjectGuid>
+ <OutputType>Library</OutputType>
+ <NoStandardLibraries>false</NoStandardLibraries>
+ <RootNamespace>XClient</RootNamespace>
+ <AssemblyName>XClient</AssemblyName>
+ </PropertyGroup>
+ <PropertyGroup>
+ 
+ <VSTO_TrustAssembliesLocation>true</VSTO_TrustAssembliesLocation>
+ </PropertyGroup>
+ <PropertyGroup>
+ 
+ <AddinRegistryHive>CurrentUser</AddinRegistryHive>
+
<AddinRegistryKey>Software\Microsoft\Office\Excel\Addins</AddinRegistryKey>
+ </PropertyGroup>
+ 
+ <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|
AnyCPU' ">
+ <DebugSymbols>true</DebugSymbols>
+ <DebugType>full</DebugType>
+ <Optimize>false</Optimize>
+ <OutputPath>.\bin\Debug\</OutputPath>
+ <EnableUnmanagedDebugging>false</EnableUnmanagedDebugging>
+ <DefineConstants>DEBUG;TRACE</DefineConstants>
+ <WarningLevel>4</WarningLevel>
+ </PropertyGroup>
+ 
+ <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|
AnyCPU' ">
+ <DebugType>pdbonly</DebugType>
+ <Optimize>true</Optimize>
+ <OutputPath>.\bin\Release\</OutputPath>
+ <EnableUnmanagedDebugging>false</EnableUnmanagedDebugging>
+ <DefineConstants>TRACE</DefineConstants>
+ <WarningLevel>4</WarningLevel>
+ </PropertyGroup>
+ 
+ <PropertyGroup>
+ <PreBuildEvent>
+ </PreBuildEvent>
+ <PostBuildEvent>
+ </PostBuildEvent>
+ </PropertyGroup>
+ 
+ <ItemGroup>
+ <Reference Include="MySql.Data, Version=5.2.3.0, Culture=neutral,
PublicKeyToken=c5687fc88969c44d, processorArchitecture=MSIL" />
+ <Reference Include="System" />
+ <Reference Include="System.Data" />
+ <Reference Include="System.EnterpriseServices" />
+ <Reference Include="System.Web.Services" />
+ <Reference Include="System.XML" />
+ <Reference Include="System.Windows.Forms" />
+ <Reference Include="System.Drawing" />
+ <Reference Include="Accessibility" />
+ <Reference Include="Microsoft.VisualStudio.Tools.Applications.Runtime"
/>
+ <Reference Include="Microsoft.Office.Tools.Excel" />
+ <Reference Include="Microsoft.Office.Tools.Common" />
+ <Reference Include="Microsoft.Office.Tools.Common2007" />
+ </ItemGroup>
+ 
+ <ItemGroup>
+ <COMReference Include="Microsoft.Office.Core">
+ <Guid>{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}</Guid>
+ <VersionMajor>2</VersionMajor>
+ <VersionMinor>4</VersionMinor>
+ <WrapperTool>primary</WrapperTool>
+ </COMReference>
+ <COMReference Include="Excel">
+ <Guid>{00020813-0000-0000-C000-000000000046}</Guid>
+ <VersionMajor>1</VersionMajor>
+ <VersionMinor>6</VersionMinor>
+ <WrapperTool>primary</WrapperTool>
+ </COMReference>
+ <COMReference Include="stdole">
+ <Guid>{00020430-0000-0000-C000-000000000046}</Guid>
+ <VersionMajor>2</VersionMajor>
+ <VersionMinor>0</VersionMinor>
+ <Lcid>0</Lcid>
+ <WrapperTool>primary</WrapperTool>
+ <Isolated>False</Isolated>
+ </COMReference>
+ </ItemGroup>
+ 
+ <ItemGroup>
+ <Compile Include="ClientEngine.cs" />
+ <Compile Include="DatabaseSettingsForm.cs">
+ <SubType>Form</SubType>
+ </Compile>
+ <Compile Include="DatabaseSettingsForm.Designer.cs">
+ <DependentUpon>DatabaseSettingsForm.cs</DependentUpon>
+ </Compile>
+ <Compile Include="DataFetcher.cs" />
+ <Compile Include="DataWriter.cs" />
+ <Compile Include="HPC4FinanceDBManager.cs" />
+ <Compile Include="WSIRWriter.cs" />
+ <Compile Include="WSIRFetcher.cs" />
+ <Compile Include="DataDBTableManager.cs" />
+ <Compile Include="Ribbon.cs" />
+ <Compile Include="ServerSetingsForm.cs">
+ <SubType>Form</SubType>
+ </Compile>
+ <Compile Include="ServerSetingsForm.Designer.cs">
+ <DependentUpon>ServerSetingsForm.cs</DependentUpon>
+ </Compile>
+ <Compile Include="SimulationSettings.cs">
+ <SubType>Form</SubType>
+ </Compile>
+ <Compile Include="SimulationSettings.Designer.cs">
+ <DependentUpon>SimulationSettings.cs</DependentUpon>
+ </Compile>
+ <Compile Include="DataEntity.cs" />
+ <Compile Include="WSSPFetcher.cs" />
+ <Compile Include="WSSPWriter.cs" />
+ <Compile Include="Finance.cs">
+ <SubType>UserControl</SubType>
+ </Compile>
+ <Compile Include="Finance.Designer.cs">
+ <DependentUpon>Finance.cs</DependentUpon>
+ </Compile>
+ <Compile Include="Properties\AssemblyInfo.cs">
+ <SubType>Code</SubType>
+ </Compile>
+ <EmbeddedResource Include="Finance.resx">
+ <SubType>Designer</SubType>
+ <DependentUpon>Finance.cs</DependentUpon>
+ </EmbeddedResource>
+ <EmbeddedResource Include="Properties\Resources.resx">
+ <Generator>ResXFileCodeGenerator</Generator>
+ <LastGenOutput>Resources.Designer.cs</LastGenOutput>
+ <SubType>Designer</SubType>
+ </EmbeddedResource>
+ <Compile Include="Properties\Resources.Designer.cs">
+ <AutoGen>True</AutoGen>
+ <DependentUpon>Resources.resx</DependentUpon>
+ <DesignTime>True</DesignTime>
+ </Compile>
+ <None Include="app.config" />
+ <None Include="Properties\Settings.settings">
+ <Generator>SettingsSingleFileGenerator</Generator>
+ <LastGenOutput>Settings.Designer.cs</LastGenOutput>
+ </None>
+ <Compile Include="Properties\Settings.Designer.cs">
+ <AutoGen>True</AutoGen>
+ <DependentUpon>Settings.settings</DependentUpon>
+ <DesignTimeSharedInput>True</DesignTimeSharedInput>
+ </Compile>
+ <Compile Include="ThisAddIn.cs">
+ <SubType>Code</SubType>
+ </Compile>
+ <None Include="ThisAddIn.Designer.xml">
+ <DependentUpon>ThisAddIn.cs</DependentUpon>
+ </None>
+ <None
Include="Web_References\com.xignite.www\AdvancesAndDeclines.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None
Include="Web_References\com.xignite.www\DividendHistory.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None
Include="Web_References\com.xignite.www\ExtendedDividendHistory.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None
Include="Web_References\com.xignite.www\HistoricalHighLow.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None
Include="Web_References\com.xignite.www\HistoricalQuote.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None
Include="Web_References\com.xignite.www\HistoricalQuotes.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite.www\Reference.map">
+ <Generator>MSDiscoCodeGenerator</Generator>
+ <LastGenOutput>Reference.cs</LastGenOutput>
+ </None>
+ <None Include="Web_References\com.xignite.www\SplitHistory.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite.www\SplitRatio.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite.www\SymbolList.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite.www\Top.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite.www\xHistorical.wsdl" />
+ <None Include="Web_References\com.xignite\AuctionResult.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite\ChartDesign.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite\CIBORRate.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite\EURIBORRate.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite\EuroDollarFRA.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite\FamilyRates.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite\FHLBankRate.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None
Include="Web_References\com.xignite\ForwardRateAgreement.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite\HIBORRate.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None
Include="Web_References\com.xignite\HistoricalInterestRates.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None
Include="Web_References\com.xignite\HistoricalLIBORRates.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite\InterestRate.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite\Interpolation.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite\LIBORRate.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite\LondonFixing.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite\OIBORRate.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite\RateChart.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite\RateDescription.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite\RateStatistics.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite\RateSymbol.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite\RateTable.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite\Reference.map">
+ <Generator>MSDiscoCodeGenerator</Generator>
+ <LastGenOutput>Reference.cs</LastGenOutput>
+ </None>
+ <None Include="Web_References\com.xignite\REIBIDRate.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite\REIBORRate.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite\SIBORRate.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite\SOFIBORRate.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite\STIBORRate.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite\SwapRate.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite\Telerate3750.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite\WIBORRate.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite\WSJInterestRate.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <None Include="Web_References\com.xignite\xRates.wsdl" />
+ <None Include="Web_References\com.xignite\YieldCurveChart.datasource">
+ <DependentUpon>Reference.map</DependentUpon>
+ </None>
+ <Compile Include="ThisAddIn.Designer.cs">
+ <DependentUpon>ThisAddIn.Designer.xml</DependentUpon>
+ </Compile>
+ <Compile Include="Web_References\com.xignite.www\Reference.cs">
+ <AutoGen>True</AutoGen>
+ <DesignTime>True</DesignTime>
+ <DependentUpon>Reference.map</DependentUpon>
+ </Compile>
+ <Compile Include="Web_References\com.xignite\Reference.cs">
+ <AutoGen>True</AutoGen>
+ <DesignTime>True</DesignTime>
+ <DependentUpon>Reference.map</DependentUpon>
+ </Compile>
+ <Compile Include="WSSettingsForm.cs">
+ <SubType>Form</SubType>
+ </Compile>
+ <Compile Include="WSSettingsForm.Designer.cs">
+ <DependentUpon>WSSettingsForm.cs</DependentUpon>
+ </Compile>
+ <AppDesigner Include="Properties\" />
+ </ItemGroup>
+ <ItemGroup>
+ <WebReferences Include="Web_References\" />
+ </ItemGroup>
+ <ItemGroup>
+ <WebReferenceUrl
Include="http://www.xignite.com/xHistorical.asmx%3fWSDL">
+ <UrlBehavior>Dynamic</UrlBehavior>
+ <RelPath>Web_References\com.xignite.www\</RelPath>
+
<UpdateFromURL>http://www.xignite.com/xHistorical.asmx%3fWSDL</UpdateFromURL>
+ <ServiceLocationURL>
+ </ServiceLocationURL>
+ <CachedDynamicPropName>
+ </CachedDynamicPropName>
+ <CachedAppSettingsObjectName>Settings</CachedAppSettingsObjectName>
+
<CachedSettingsPropName>XClient_com_xignite_www_XigniteHistorical</CachedSettingsPropName>
+ </WebReferenceUrl>
+ <WebReferenceUrl Include="https://xignite.com/xRates.asmx%3fWSDL">
+ <UrlBehavior>Dynamic</UrlBehavior>
+ <RelPath>Web_References\com.xignite\</RelPath>
+ <UpdateFromURL>https://xignite.com/xRates.asmx%3fWSDL</UpdateFromURL>
+ <ServiceLocationURL>
+ </ServiceLocationURL>
+ <CachedDynamicPropName>
+ </CachedDynamicPropName>
+ <CachedAppSettingsObjectName>Settings</CachedAppSettingsObjectName>
+
<CachedSettingsPropName>XClient_com_xignite_XigniteRates</CachedSettingsPropName>
+ </WebReferenceUrl>
+ </ItemGroup>
+ <ItemGroup>
+ <EmbeddedResource Include="DatabaseSettingsForm.resx">
+ <SubType>Designer</SubType>
+ <DependentUpon>DatabaseSettingsForm.cs</DependentUpon>
+ </EmbeddedResource>
+ <EmbeddedResource Include="Ribbon.xml" />
+ <EmbeddedResource Include="ServerSetingsForm.resx">
+ <SubType>Designer</SubType>
+ <DependentUpon>ServerSetingsForm.cs</DependentUpon>
+ </EmbeddedResource>
+ <EmbeddedResource Include="SimulationSettings.resx">
+ <SubType>Designer</SubType>
+ <DependentUpon>SimulationSettings.cs</DependentUpon>
+ </EmbeddedResource>
+ <EmbeddedResource Include="WSSettingsForm.resx">
+ <SubType>Designer</SubType>
+ <DependentUpon>WSSettingsForm.cs</DependentUpon>
+ </EmbeddedResource>
+ </ItemGroup>
+ 
+ <Import Project="$(MSBuildBinPath)\Microsoft.CSharp.targets" />
+ 
+ <Import
Project="$(MSBuildExtensionsPath)\Microsoft.VisualStudio.OfficeTools2.targets"
/>
+ 
+ <ProjectExtensions>
+ <VisualStudio>
+ <FlavorProperties GUID="{BAA0C2D2-18E2-41B9-852F-F413020CAA33}">
+ <ProjectProperties HostName="Excel"
HostPackage="{D53BAEDE-5B63-42BE-8267-3DED11EDC582}"
ApplicationType="Excel" Language="cs" TemplatesPath=""
DebugInfoExeName="#Software\Microsoft\Office\12.0\Excel\InstallRoot\Path#EXCEL.exe"
AddItemTemplatesGuid="{147FB6A7-F239-4523-AE65-B6A4E49B361F}" />
+ <Host Name="Excel" GeneratedCodeNamespace="XClient" IconIndex="0">
+ <HostItem Name="ThisAddIn" Code="ThisAddIn.cs"
CanonicalName="AddIn" CanActivate="false" IconIndex="1"
Blueprint="ThisAddIn.Designer.xml" GeneratedCode="ThisAddIn.Designer.cs" />
+ </Host>
+ <ProjectClient>
+ <VSTO_CompatibleProducts ErrorProduct="This project requires
Microsoft Office Excel 2007, but this application is not installed."
ErrorPIA="This project references the primary interop assembly for
Microsoft Office Excel 2007, but this primary interop assembly is not
installed.">
+ <Product Code="{XX12XXXX-XXXX-XXXX-X000-X000000FF1CE}"
Feature="EXCELFiles" PIAFeature="EXCEL_PIA" />
+ </VSTO_CompatibleProducts>
+ </ProjectClient>
+ </FlavorProperties>
+ </VisualStudio>
+ </ProjectExtensions>
+</Project>
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/XClient.csproj.user Sun Jan 17 01:18:44 2010
@@ -0,0 +1,34 @@
+
+
+<Project xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
+ <ProjectExtensions>
+ <VisualStudio>
+ <FlavorProperties GUID="{BAA0C2D2-18E2-41B9-852F-F413020CAA33}">
+ <ProjectClient>
+ <VSTO_CompatibleProducts ErrorProduct="This project requires
Microsoft Office Excel 2007, but this application is not installed."
ErrorPIA="This project references the primary interop assembly for
Microsoft Office Excel 2007, but this primary interop assembly is not
installed.">
+ <Product Code="{XX12XXXX-XXXX-XXXX-X000-X000000FF1CE}"
Feature="EXCELFiles" PIAFeature="EXCEL_PIA" />
+ </VSTO_CompatibleProducts>
+ </ProjectClient>
+ </FlavorProperties>
+ </VisualStudio>
+ </ProjectExtensions>
+</Project>
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/app.config Sun Jan 17 01:18:44 2010
@@ -0,0 +1,84 @@
+/*
+ Copyright (c) 2008 by contributors:
+
+ * Damitha Premadasa
+ * Nilendra Weerasinghe
+ * Thilina Dampahala
+ * Waruna Ranasinghe - (http://warunapw.blogspot.com)
+
+ Licensed under the Apache License, Version 2.0 (the "License");
+ you may not use this file except in compliance with the License.
+ You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+*/
+
+<?xml version="1.0" encoding="utf-8" ?>
+<configuration>
+ <configSections>
+ <sectionGroup name="applicationSettings"
type="System.Configuration.ApplicationSettingsGroup, System,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" >
+ <section name="XClient.Properties.Settings"
type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false"
/>
+ </sectionGroup>
+ <sectionGroup name="userSettings"
type="System.Configuration.UserSettingsGroup, System, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089" >
+ <section name="XClient.Properties.Settings"
type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089"
allowExeDefinition="MachineToLocalUser" requirePermission="false" />
+ </sectionGroup>
+ </configSections>
+ <applicationSettings>
+ <XClient.Properties.Settings>
+ <setting name="XClient_com_xignite_www_XigniteHistorical"
serializeAs="String">
+ <value>http://www.xignite.com/xHistorical.asmx</value>
+ </setting>
+ <setting name="XClient_com_xignite_XigniteRates"
serializeAs="String">
+ <value>https://xignite.com/xRates.asmx</value>
+ </setting>
+ </XClient.Properties.Settings>
+ </applicationSettings>
+
+ <appSettings>
+ <add key="mnConnectionString" value="server=10.8.102.26;user
id=root;Password=cig4123;database=hpc4finance;persist security info=True"/>
+ <add key="spConnectionString" value="server=10.8.102.26;user
id=root;Password=cig4123;database=stockprices;persist security info=True"/>
+ <add key="irConnectionString" value="server=10.8.102.26;user
id=root;Password=cig4123;database=interestrates;persist security
info=True"/>
+ <add key="mnIP" value="10.8.102.27"/>
+ <add key="mnServicePort" value="8080"/>
+ <add key="username" value="thd...@gmail.com"/>
+ <add key="password" value="dama123"/>
+ </appSettings>
+
+ <userSettings>
+ <XClient.Properties.Settings>
+ <setting name="mnConnectionString" serializeAs="String">
+ <value />
+ </setting>
+ <setting name="dataConnectionString" serializeAs="String">
+ <value />
+ </setting>
+ <setting name="mnIP" serializeAs="String">
+ <value />
+ </setting>
+ <setting name="mnServicePort" serializeAs="String">
+ <value />
+ </setting>
+ <setting name="username" serializeAs="String">
+ <value />
+ </setting>
+ <setting name="password" serializeAs="String">
+ <value />
+ </setting>
+ <setting name="nMC" serializeAs="String">
+ <value>50000</value>
+ </setting>
+ <setting name="nodes" serializeAs="String">
+ <value>1</value>
+ </setting>
+ <setting name="background" serializeAs="String">
+ <value>false</value>
+ </setting>
+ </XClient.Properties.Settings>
+ </userSettings>
+</configuration>
=======================================
--- /dev/null
+++ /trunk/Excel_Plugin/XClient/uytuyu.cd Sun Jan 17 01:18:44 2010
@@ -0,0 +1,86 @@
+
+
+<?xml version="1.0" encoding="utf-8"?>
+<ClassDiagram MajorVersion="1" MinorVersion="1">
+ <Font Name="Tahoma" Size="8.25" />
+ <Class Name="DataEntity">
+ <Position X="0.5" Y="0.5" Width="1.5" />
+ <TypeIdentifier>
+ <FileName>DataEntity.cs</FileName>
+ <HashCode>AAAAABAAAAAAIAAAAiAACAIAAAgAAAABAIIAAQCCAAA=</HashCode>
+ </TypeIdentifier>
+ </Class>
+ <Class Name="DataFetcher">
+ <Position X="2.25" Y="0.5" Width="1.5" />
+ <TypeIdentifier>
+ <FileName>DataFetcher.cs</FileName>
+ <HashCode>AAAAAAAAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=</HashCode>
+ </TypeIdentifier>
+ </Class>
+ <Class Name="DataWriter">
+ <Position X="5.75" Y="0.5" Width="1.5" />
+ <TypeIdentifier>
+ <FileName>DataWriter.cs</FileName>
+ <HashCode>AAAAAAAAAAAAAAAAAAAAAAAAAAAgAAAAAAAAAAAAAAA=</HashCode>
+ </TypeIdentifier>
+ </Class>
+ <Class Name="TableManager">
+ <Position X="2.25" Y="3.5" Width="1.5" />
+ <TypeIdentifier>
+ <FileName>TableManager.cs</FileName>
+ <HashCode>AAAAAAAAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=</HashCode>
+ </TypeIdentifier>
+ </Class>
+ <Class Name="XClient.Finance">
+ <Position X="5.75" Y="1.75" Width="1.5" />
+ <TypeIdentifier>
+ <FileName>Finance.cs</FileName>
+ <HashCode>AAAAAEAABCAAEBAQAACAQAgCAAAIAAEAAEAAAYAIgAI=</HashCode>
+ </TypeIdentifier>
+ </Class>
+ <Class Name="XClient.ThisAddIn" BaseTypeListCollapsed="true">
+ <Position X="4" Y="2.75" Width="1.5" />
+ <TypeIdentifier>
+ <FileName>ThisAddIn.cs</FileName>
+ <HashCode>QAAwAACQGBAAEQAgAQAAgFgAADAAABAQAAkAIAAAACg=</HashCode>
+ </TypeIdentifier>
+ <Lollipop Position="0.2" Collapsed="true" />
+ </Class>
+ <Class Name="XClient.Globals">
+ <Position X="2.25" Y="1.75" Width="1.5" />
+ <TypeIdentifier>
+ <HashCode>AAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAgAA=</HashCode>
+ </TypeIdentifier>
+ </Class>
+ <Class Name="XClient.Properties.Resources">
+ <Position X="4" Y="0.5" Width="1.5" />
+ <TypeIdentifier>
+ <HashCode>AAAAAAAAAAAAAAAAAAABEAAAAQAAAAAAAAAAAAAAAIA=</HashCode>
+ </TypeIdentifier>
+ </Class>
+ <Class Name="XClient.Properties.Settings">
+ <Position X="0.5" Y="4" Width="1.5" />
+ <TypeIdentifier>
+ <HashCode>AAAAAAAAAAAAAAAAAAAAIAAAAAABAAAAAAAAAAAAQAA=</HashCode>
+ </TypeIdentifier>
+ </Class>
+</ClassDiagram>

Reply all

Reply to author

Forward

0 new messages