private Dictionary<string, RTDVField> CreateRTDVFieldDictionary()
{
Dictionary<string, RTDVField> dictionary;
RTDVField field;
// create a new dictionary
dictionary = new Dictionary<string, RTDVField>();
//OrderID
field = new RTDVField("OrderID", TypeCode.Int32);
field.DisplayName = "OrderID";
field.Size = 4;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("OrderID", field);
//ProductID
field = new RTDVField("ProductID", TypeCode.Int32);
field.DisplayName = "ProductID";
field.Size = 4;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("ProductID", field);
//UnitPrice
field = new RTDVField("UnitPrice", TypeCode.Decimal);
field.DisplayName = "UnitPrice";
field.Size = 8;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("UnitPrice", field);
//Discount
field = new RTDVField("Discount", TypeCode.Decimal);
field.DisplayName = "Discount";
field.Size = 4;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("Discount", field);
//Quantity
field = new RTDVField("Quantity", TypeCode.Int16);
field.DisplayName = "Quantity";
field.Size = 2;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("Quantity", field);
return dictionary;
}
private Dictionary<string, RTDVField> CreateRTDVFieldDictionary()
{
Dictionary<string, RTDVField> dictionary;
RTDVField field;
// create a new dictionary
dictionary = new Dictionary<string, RTDVField>();
//ID
field = new RTDVField("ID", TypeCode.String);
field.DisplayName = "ID";
field.Size = 1024;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("ID", field);
//AccountID
field = new RTDVField("AccountID", TypeCode.String);
field.DisplayName = "Account ID";
field.Size = 1024;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("AccountID", field);
//ItemCode
field = new RTDVField("ItemCode", TypeCode.Int32);
field.DisplayName = "Item Code";
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("ItemCode", field);
//ItemName
field = new RTDVField("ItemName", TypeCode.String);
field.DisplayName = "Item Name";
field.Size = 40;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("ItemName", field);
//Quantity
field = new RTDVField("Quantity", TypeCode.Decimal);
field.DisplayName = "Quantity";
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("Quantity", field);
//UnitPrice
field = new RTDVField("UnitPrice", TypeCode.Decimal);
field.DisplayName = "Unit Price";
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("UnitPrice", field);
//Value
field = new RTDVField("Value", TypeCode.Decimal);
field.DisplayName = "Value";
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("Value", field);
//LastPurchaseDate
field = new RTDVField("LastPurchaseDate", TypeCode.DateTime);
field.DisplayName = "Last Purchase Date";
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("LastPurchaseDate", field);
//Description
field = new RTDVField("Description", TypeCode.String);
field.DisplayName = "Description";
field.Size = 1024;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("Description", field);
//Discount
field = new RTDVField("Discount", TypeCode.Decimal);
field.DisplayName = "Discount";
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("Discount", field);
return dictionary;
}
private Dictionary<string, RTDVField> CreateRTDVFieldDictionary()
{
Dictionary<string, RTDVField> dictionary;
RTDVField field;
// create a new dictionary
dictionary = new Dictionary<string, RTDVField>();
//BirthDate
field = new RTDVField("BirthDate", TypeCode.DateTime);
field.DisplayName = "BirthDate";
field.Size = 8;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("BirthDate", field);
//HireDate
field = new RTDVField("HireDate", TypeCode.DateTime);
field.DisplayName = "HireDate";
field.Size = 8;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("HireDate", field);
//EmployeeID
field = new RTDVField("EmployeeID", TypeCode.Int16);
field.DisplayName = "EmployeeID";
field.Size = 4;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("EmployeeID", field);
//ReportsTo
field = new RTDVField("ReportsTo", TypeCode.Int16);
field.DisplayName = "ReportsTo";
field.Size = 4;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("ReportsTo", field);
//Notes
field = new RTDVField("Notes", TypeCode.String); //ntext
field.DisplayName = "Notes";
field.Size = 2000;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("Notes", field);
//HomePhone
field = new RTDVField("HomePhone", TypeCode.String);
field.DisplayName = "HomePhone";
field.Size = 48;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("HomePhone", field);
//Extension
field = new RTDVField("Extension", TypeCode.String);
field.DisplayName = "Extension";
field.Size = 8;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("Extension", field);
//Region
field = new RTDVField("Region", TypeCode.String);
field.DisplayName = "Region";
field.Size = 30;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("Region", field);
//PostalCode
field = new RTDVField("PostalCode", TypeCode.String);
field.DisplayName = "PostalCode";
field.Size = 20;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("PostalCode", field);
//Country
field = new RTDVField("Country", TypeCode.String);
field.DisplayName = "Country";
field.Size = 30;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("Country", field);
//TitleOfCourtesy
field = new RTDVField("TitleOfCourtesy", TypeCode.String);
field.DisplayName = "TitleOfCourtesy";
field.Size = 50;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("TitleOfCourtesy", field);
//Address
field = new RTDVField("Address", TypeCode.String);
field.DisplayName = "Address";
field.Size = 120;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("Address", field);
//City
field = new RTDVField("City", TypeCode.String);
field.DisplayName = "City";
field.Size = 30;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("City", field);
//LastName
field = new RTDVField("LastName", TypeCode.String);
field.DisplayName = "LastName";
field.Size = 40;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("LastName", field);
//FirstName
field = new RTDVField("FirstName", TypeCode.String);
field.DisplayName = "FirstName";
field.Size = 20;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("FirstName", field);
//Title
field = new RTDVField("Title", TypeCode.String);
field.DisplayName = "Title";
field.Size = 60;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("Title", field);
//ReportsToName
field = new RTDVField("ReportsToName", TypeCode.String);
field.DisplayName = "ReportsToName";
field.Size = 40;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("ReportsToName", field);
return dictionary;
}
private Dictionary<string, RTDVField> CreateRTDVFieldDictionary()
{
Dictionary<string, RTDVField> dictionary;
RTDVField field;
// create a new dictionary
dictionary = new Dictionary<string, RTDVField>();
//ProductID
field = new RTDVField("ProductID", TypeCode.Int32);
field.DisplayName = "Product ID";
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("ProductID", field);
//ProductName
field = new RTDVField("ProductName", TypeCode.String);
field.DisplayName = "Product Name";
field.Size = 40;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("ProductName", field);
//UnitsInStock
field = new RTDVField("UnitsInStock", TypeCode.Int16);
field.DisplayName = "Units In Stock";
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("UnitsInStock", field);
//UnitsOnStockAfterOrder
field = new RTDVField("UnitsOnStockAfterOrder", TypeCode.Int32);
field.DisplayName = "Units On Stock After Order";
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("UnitsOnStockAfterOrder", field);
//ReorderLevel
field = new RTDVField("ReorderLevel", TypeCode.Int16);
field.DisplayName = "Reorder Level";
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("ReorderLevel", field);
//CompanyName
field = new RTDVField("CompanyName", TypeCode.String);
field.DisplayName = "Company Name";
field.Size = 40;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("CompanyName", field);
//CompanyName
field = new RTDVField("ContactName", TypeCode.String);
field.DisplayName = "Contact Name";
field.Size = 30;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("ContactName", field);
//CompanyName
field = new RTDVField("Address", TypeCode.String);
field.DisplayName = "Address";
field.Size = 60;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("Address", field);
//City
field = new RTDVField("City", TypeCode.String);
field.DisplayName = "City";
field.Size = 15;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("City", field);
//City
field = new RTDVField("Region", TypeCode.String);
field.DisplayName = "Region";
field.Size = 15;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("Region", field);
//PostalCode
field = new RTDVField("PostalCode", TypeCode.String);
field.DisplayName = "Postal Code";
field.Size = 10;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("PostalCode", field);
//Country
field = new RTDVField("Country", TypeCode.String);
field.DisplayName = "Country";
field.Size = 15;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("Country", field);
//Phone
field = new RTDVField("Phone", TypeCode.String);
field.DisplayName = "Phone";
field.Size = 24;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("Phone", field);
//Fax
field = new RTDVField("Fax", TypeCode.String);
field.DisplayName = "Fax";
field.Size = 24;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("Fax", field);
return dictionary;
}
private Dictionary<string, RTDVField> CreateRTDVFieldDictionary()
{
Dictionary<string, RTDVField> dictionary;
RTDVField field;
// create a new dictionary
dictionary = new Dictionary<string, RTDVField>();
//AccountID
field = new RTDVField("AccountID", TypeCode.String);
field.DisplayName = "Account ID";
field.Size = 1024;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("AccountID", field);
//Type
field = new RTDVField("Type", TypeCode.String);
field.DisplayName = "Type";
field.Size = 1024;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("Type", field);
//CreatedBy
field = new RTDVField("CreatedBy", TypeCode.String);
field.DisplayName = "Created By";
field.Size = 1024;
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("CreatedBy", field);
//DatePaymentDue
field = new RTDVField("DatePaymentDue", TypeCode.Int32);
field.DisplayName = "Date Payment Due";
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("DatePaymentDue", field);
//OrderID
field = new RTDVField("OrderID", TypeCode.Int32);
field.DisplayName = "Order ID";
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("OrderID", field);
//Value
field = new RTDVField("Value", TypeCode.Decimal);
field.DisplayName = "Value";
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("Value", field);
//Value
field = new RTDVField("OrderDate", TypeCode.DateTime);
field.DisplayName = "Order Date";
field.MinOccurs = 0;
field.MaxOccurs = 1;
dictionary.Add("OrderDate", field);
return dictionary;
}