Questions on UI for ASP.NET AJAX Forum

110,763 questions

3 answers

111 views

I'm not really sure if it's my fault (am I overlooking something?), but when I move an appointment that's part of a recurrence the advanced popup shows asking me if I want to replace the entire recurrence or just this one.

After that an error is thrown telling me that 'this' does not contain a method called 'get_owner'.
The Telerik.Web.UI dll's are on version 2014.2.724.40 and the project is an ASP.NET project.

The error occurs in a dynamic blank script and looks like this:

_onAppointmentMoveCallback:function(j,h)
{
h.Scheduler._raiseRecurrenceActionDialogClosedEvent(h,false,b.RecurrenceAction.Move);
var k={
appointment: h.Appointment,
newStartTime: h.NewStart,
editingRecurringSeries:j,
targetSlot:h.TargetSlot,
isAbortedByUser:false
};
var i=a.raiseCancellableControlEvent(h.Scheduler,"appointmentMoveEnd",k);
if((this.get_owner().get_groupBy()!==g) &&
this.get_owner()._webServiceSettings.get_isEmpty() &&
h.Appointment.get_resources().indexOf(h.SourceSlot.get_resource())==-1)
{ i=true; }
if(!i) {
h.Scheduler.moveAppointment(h.Appointment,j,h.SourceSlot,h.TargetSlot);
} else {
h.Appointment._abortDrag();
}
}

The debugger stops and tells me that this.get_owner() does not exist.
If there's any more information you need, please let me know.

General Discussions

answered on 11 Mar 2015

4 answers

409 views

FilterExpression Linq

I'm trying to get the filterExpressions working on my Linq query using the Dynamic Linq Library but am getting this error

LINQ to Entities does not recognize the method 'System.String ToString()' method, and this method cannot be translated into a store expression.

It looks like the filterExpression uses ToString() which is causing the error

(iif(LogType.Name == null, "", LogType.Name).ToString().Contains("Error"))

My code is

string filterExpression = (sender as RadGrid).MasterTableView.FilterExpression;

logs = db.Logs

.Where(x => x.SystemId.Equals(this.SystemId.Value))

.Where(filterExpression)

.OrderByDescending(x => x.OccurredOn)

.Skip(skip)

.Take(pageSize)

.ToList();

Grid

answered on 11 Mar 2015

4 answers

512 views

Datagrid filtering on Date Field with Entity Framework

I'm having lots of difficulty implementing date filtering in a radgrid with entity framework. When reading the gridActions.MasterTableView.FilterExpression value for a date field on my page I get the following filter back : (ActionDate = DateTime.Parse("8/10/2011 12:00:00 AM")). However entity framework is giving me an error for that type of syntax. It doesn't like the DateTime.Parse. It's a LINQ to Entity limitation. I'm trying to manually setup the filter, and I've had some success doing it, but I can't seem to figure out how to properly do it. Right now what I have is working to limit by date if it is the same date. But if the user picks greater then or less then (etc;) I don't know how to handle that correctly. Can you give me some advice on either a better approach, or how to fully correctly implement it. Again I'm using Entity Framework 4.0 on the backend, and I'm calling a DAL layer for information.

The error I'm getting if trying to use the direct filter expression is:
"LINQ to Entities does not recognize the method 'System.DateTime ToDateTime(System.String)' method, and this method cannot be translated into a store expression."

I'll include the code that I'm using below as well.

Thanks so much,
Kevin

Dashboard.aspx page:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="dashboard.aspx.cs" Inherits="SearchDesk.billing.Dashboard" %>

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

    <telerik:RadGrid Width="700px" runat="server" ID="gridActions" OnItemDataBound="GridActionsItemDataBound"
               OnNeedDataSource="GridActionsNeedDataSource" AutoGenerateColumns="False" OnItemCommand="getitem"
               AllowPaging="True" GridLines="None" Skin="Windows7" OnSortCommand="gridActionSort"
            AllowFilteringByColumn="True" AllowSorting="True" CellSpacing="0">

                  <telerik:GridTemplateColumn AllowFiltering="false" UniqueName="buttons" HeaderText="Actions" ItemStyle-Width="200">
                  <ItemTemplate>
                     <asp:Panel runat="server" ID="CreateInvoice" Visible="false">
                     <asp:ImageButton runat="server" ID="button1" Height="16" Width="16" ImageUrl="~/Images/newIcon.jpg" title="Create New Invoice" AlternateText="Create New Invoice" PostBackUrl='<%# "~/CreateNew.aspx?AID=" + DataBinder.Eval(Container.DataItem,"ActionID") %>'     />

                    </asp:Panel>
                  </ItemTemplate>
                  </telerik:GridTemplateColumn>
                </Columns>

Backend aspx.cs page:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using SearchDeskEntityFrameworkDAL;
using SearchDeskEntityFrameworkDAL.Repositories;
using Telerik.Web.UI;
using System.Linq.Dynamic;

namespace SearchDesk.billing
{
public partial class Dashboard : SearchDesk.BasePage
{
      private string sortActions;
      private DateTime filterDateTime;
    protected void Page_Load(object sender, EventArgs e)
    {

}

      protected void GridActionsItemDataBound(object sender, GridItemEventArgs e)
      {
          if (e.Item is GridDataItem)
          {
              var item = (GridDataItem)e.Item;
              int actionTypeID = Convert.ToInt16(item["ActionTypeID"].Text);
              if (actionTypeID == (int)ActionTypes.CreateInvoice)
              {
                  item["buttons"].Controls[1].Visible = true;
              }
          }
      }

      protected void GridActionsNeedDataSource(object sender, GridNeedDataSourceEventArgs e)
      {
         var searchDeskBillingRepository = new SearchDeskBillingRepository();
          var filter = gridActions.MasterTableView.FilterExpression;

          if (string.IsNullOrEmpty(sortActions))
          {
              sortActions = "ActionDate";
          }
          if (string.IsNullOrEmpty(filter))
          {
              gridActions.DataSource =
                  searchDeskBillingRepository.GetActionsAssignedToUser(CurrentUser.ObjectID).OrderBy(sortActions);
          }
          else
          {
              filter = filter.Replace(".ToString()", "");
              if (filter.Contains("DateTime.Parse"))
              {
                  gridActions.DataSource =
                      searchDeskBillingRepository.GetActionsAssignedToUser(CurrentUser.ObjectID).Where(
                          s => s.ActionDate == filterDateTime);
              }
              else
              {
                  gridActions.DataSource =
                      searchDeskBillingRepository.GetActionsAssignedToUser(CurrentUser.ObjectID).Where(filter);

              }

          }

}

      public override string PageName
      {
          get { return "DashBoard.aspx"; }
      }

      protected void gridActionSort(object sender, GridSortCommandEventArgs e)
      {
          if (e.NewSortOrder == GridSortOrder.None)
          {
              sortActions = e.SortExpression;
          }
          else
          {
              sortActions = e.SortExpression + " " + e.NewSortOrder;
          }
      }

      protected void getitem(object sender, GridCommandEventArgs e)
      {
         if (e.Item is GridFilteringItem){
              GridFilteringItem filteringItem = e.Item as GridFilteringItem;
              filterDateTime = Convert.ToDateTime(((RadDatePicker)filteringItem["ActionDate"].Controls[0]).DbSelectedDate);

          }
      }
}
}

Grid

answered on 11 Mar 2015

1 answer

170 views

RadGrid -Server Side Conditional Setting the GridClientSelectColumn

I'm having the worst time trying to get this simple page working right. I have a page that has two controls one is a ASP Form and another is a RadGrid. I have a suspicious feeling that having these one the same page are the root of the problem, because no mater what I put on the VB code behind page for the RadGrid, nothing behaves. Ultimately I am trying to pull data from a Datasource query and based on the condition/value of the RadGrid field/column to either make a check box checked or not. I have left all my attempts and code just for reference on everything I have tried. I don't get any errors, but I can not get the RadGrid to behave.

The Code Behind and ASPX pages below:

Imports Telerik.Web.UI

Public Class ContactEdit

Inherits System.Web.UI.Page

Protected Sub ToggleRowSelection(ByVal sender As Object, ByVal e As EventArgs)

TryCast(TryCast(sender, CheckBox).NamingContainer, GridItem).Selected = TryCast(sender, CheckBox).Checked

Dim checkHeader As Boolean = True

For Each dataItem As GridDataItem In RadGrid1.MasterTableView.Items

If Not TryCast(dataItem.FindControl("CATSELECTION"), CheckBox).Checked Then

checkHeader = False

Exit For

End If

Next

Dim headerItem As GridHeaderItem = TryCast(RadGrid1.MasterTableView.GetItems(GridItemType.Header)(0), GridHeaderItem)

TryCast(headerItem.FindControl("headerChkbox"), CheckBox).Checked = checkHeader

End Sub

Protected Sub ToggleSelectedState(ByVal sender As Object, ByVal e As EventArgs)

Dim headerCheckBox As CheckBox = TryCast(sender, CheckBox)

For Each dataItem As GridDataItem In RadGrid1.MasterTableView.Items

TryCast(dataItem.FindControl("CATSELECTION"), CheckBox).Checked = headerCheckBox.Checked

dataItem.Selected = headerCheckBox.Checked

Next

End Sub

Protected Sub RadGrid1_PreRender(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs)

Dim headerCheckBox As CheckBox = TryCast(sender, CheckBox)

For Each dataItem As GridDataItem In RadGrid1.MasterTableView.Items

TryCast(dataItem.FindControl("CATSELECTION"), CheckBox).Checked = True

' dataItem.Selected = headerCheckBox.Checked

dataItem.FindControl("CategoryName").Visible = False

Next

End Sub

Protected Sub RadGrid1_ItemDataBound(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs)

Dim item As GridDataItem = TryCast(e.Item, GridDataItem)

item.Selected = True

Dim CategoryName As String = item("CategoryName").Text

CategoryName = "test"

If TypeOf e.Item Is GridDataItem Then

'CATSELECTION

'CategoryName

'ContactServiceID

' Dim CategoryName As String = item("CategoryName").Text

'Dim CATSELECTION As CheckBox = item("CATSELECTION")

Dim contactServiceID As String = item("ContactServiceID").Text

'TryCast(TryCast(sender, CheckBox).NamingContainer, GridItem).Selected = TryCast(sender, CheckBox).Checked

Dim catselection As CheckBox = CType(item.FindControl("CATSELECTION"), CheckBox)

Dim headerCheckBox As CheckBox = TryCast(sender, CheckBox)

For Each dataItem As GridDataItem In RadGrid1.MasterTableView.Items

TryCast(dataItem.FindControl("CATSELECTION"), CheckBox).Checked = headerCheckBox.Checked

dataItem.Selected = headerCheckBox.Checked

Next

If contactServiceID <> 0 Then

catselection.Checked = True

item.Selected = True

Else

catselection.Checked = False

item.Selected = False

End If

catselection.Checked = True

End If

End Sub

End Class

<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="ContactEdit.aspx.vb" Inherits="MCDContacts.ContactEdit" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

<title></title>

<style type="text/css">

.auto-style1 {

width: 100%;

border-collapse: collapse;

height: 395px;

}

.auto-style2 {

height: 21px;

}

.auto-style5 {

width: 257px;

}

.auto-style6 {

height: 21px;

width: 257px;

}

.auto-style7 {

width: 76px;

}

.auto-style8 {

height: 21px;

width: 76px;

}

.auto-style9 {

width: 257px;

height: 22px;

}

.auto-style10 {

width: 76px;

height: 22px;

}

.auto-style11 {

height: 22px;

}

#form1 {

margin-right: 698px;

width: 816px;

}

.auto-style12 {

width: 100%;

}

.auto-style13 {

width: 198px;

}

.auto-style14 {

width: 504px;

}

</style>

</head>

<body>

<form id="form1" runat="server">

<asp:ScriptManager ID="ScriptManager1" runat="server">

</asp:ScriptManager>

<div>

</div>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues" ConnectionString="<%$ ConnectionStrings:MCD_Contacts_2010ConnectionString %>"

DeleteCommand="DELETE FROM [ContactDetailsTable] WHERE [ContactServiceID] = @original_ContactServiceID AND (([FirstName] = @original_FirstName) OR ([FirstName] IS NULL AND @original_FirstName IS NULL)) AND (([MiddleName] = @original_MiddleName) OR ([MiddleName] IS NULL AND @original_MiddleName IS NULL)) AND (([LastName] = @original_LastName) OR ([LastName] IS NULL AND @original_LastName IS NULL)) AND (([Prefix] = @original_Prefix) OR ([Prefix] IS NULL AND @original_Prefix IS NULL)) AND (([Suffix] = @original_Suffix) OR ([Suffix] IS NULL AND @original_Suffix IS NULL)) AND (([WorkAddressCity] = @original_WorkAddressCity) OR ([WorkAddressCity] IS NULL AND @original_WorkAddressCity IS NULL)) AND (([WorkAddressCountry] = @original_WorkAddressCountry) OR ([WorkAddressCountry] IS NULL AND @original_WorkAddressCountry IS NULL)) AND (([WorkAddressPOB] = @original_WorkAddressPOB) OR ([WorkAddressPOB] IS NULL AND @original_WorkAddressPOB IS NULL)) AND (([WorkAddressZip] = @original_WorkAddressZip) OR ([WorkAddressZip] IS NULL AND @original_WorkAddressZip IS NULL)) AND (([WorkAddressState] = @original_WorkAddressState) OR ([WorkAddressState] IS NULL AND @original_WorkAddressState IS NULL)) AND (([WorkAddressStreet] = @original_WorkAddressStreet) OR ([WorkAddressStreet] IS NULL AND @original_WorkAddressStreet IS NULL)) AND (([HomeAddressCity] = @original_HomeAddressCity) OR ([HomeAddressCity] IS NULL AND @original_HomeAddressCity IS NULL)) AND (([HomeAddressCountry] = @original_HomeAddressCountry) OR ([HomeAddressCountry] IS NULL AND @original_HomeAddressCountry IS NULL)) AND (([HomeAddressPOB] = @original_HomeAddressPOB) OR ([HomeAddressPOB] IS NULL AND @original_HomeAddressPOB IS NULL)) AND (([HomeAddressZip] = @original_HomeAddressZip) OR ([HomeAddressZip] IS NULL AND @original_HomeAddressZip IS NULL)) AND (([HomeAddressState] = @original_HomeAddressState) OR ([HomeAddressState] IS NULL AND @original_HomeAddressState IS NULL)) AND (([HomeAddressStreet] = @original_HomeAddressStreet) OR ([HomeAddressStreet] IS NULL AND @original_HomeAddressStreet IS NULL)) AND (([OtherAddressCity] = @original_OtherAddressCity) OR ([OtherAddressCity] IS NULL AND @original_OtherAddressCity IS NULL)) AND (([OtherAddressCountry] = @original_OtherAddressCountry) OR ([OtherAddressCountry] IS NULL AND @original_OtherAddressCountry IS NULL)) AND (([OtherAddressPOB] = @original_OtherAddressPOB) OR ([OtherAddressPOB] IS NULL AND @original_OtherAddressPOB IS NULL)) AND (([OtherAddressZip] = @original_OtherAddressZip) OR ([OtherAddressZip] IS NULL AND @original_OtherAddressZip IS NULL)) AND (([OtherAddressState] = @original_OtherAddressState) OR ([OtherAddressState] IS NULL AND @original_OtherAddressState IS NULL)) AND (([OtherAddressStreet] = @original_OtherAddressStreet) OR ([OtherAddressStreet] IS NULL AND @original_OtherAddressStreet IS NULL)) AND (([PhoneNum1] = @original_PhoneNum1) OR ([PhoneNum1] IS NULL AND @original_PhoneNum1 IS NULL)) AND (([BusinessPhone2] = @original_BusinessPhone2) OR ([BusinessPhone2] IS NULL AND @original_BusinessPhone2 IS NULL)) AND (([CallbackNum] = @original_CallbackNum) OR ([CallbackNum] IS NULL AND @original_CallbackNum IS NULL)) AND (([PhoneNum4] = @original_PhoneNum4) OR ([PhoneNum4] IS NULL AND @original_PhoneNum4 IS NULL)) AND (([ISDNNum] = @original_ISDNNum) OR ([ISDNNum] IS NULL AND @original_ISDNNum IS NULL)) AND (([PhoneNum5] = @original_PhoneNum5) OR ([PhoneNum5] IS NULL AND @original_PhoneNum5 IS NULL)) AND (([PrimaryPhoneNum] = @original_PrimaryPhoneNum) OR ([PrimaryPhoneNum] IS NULL AND @original_PrimaryPhoneNum IS NULL)) AND (([RadioPhoneNum] = @original_RadioPhoneNum) OR ([RadioPhoneNum] IS NULL AND @original_RadioPhoneNum IS NULL)) AND (([TelexNum] = @original_TelexNum) OR ([TelexNum] IS NULL AND @original_TelexNum IS NULL)) AND (([PhoneNum6] = @original_PhoneNum6) OR ([PhoneNum6] IS NULL AND @original_PhoneNum6 IS NULL)) AND (([DisplaySelectors] = @original_DisplaySelectors) OR ([DisplaySelectors] IS NULL AND @original_DisplaySelectors IS NULL)) AND (([EmailDisplayAs1] = @original_EmailDisplayAs1) OR ([EmailDisplayAs1] IS NULL AND @original_EmailDisplayAs1 IS NULL)) AND (([EmailDisplayAs2] = @original_EmailDisplayAs2) OR ([EmailDisplayAs2] IS NULL AND @original_EmailDisplayAs2 IS NULL)) AND (([EmailDisplayAs3] = @original_EmailDisplayAs3) OR ([EmailDisplayAs3] IS NULL AND @original_EmailDisplayAs3 IS NULL)) AND (([ContactNotes] = @original_ContactNotes) OR ([ContactNotes] IS NULL AND @original_ContactNotes IS NULL)) AND (([ReferredBy] = @original_ReferredBy) OR ([ReferredBy] IS NULL AND @original_ReferredBy IS NULL)) AND (([LeadSource] = @original_LeadSource) OR ([LeadSource] IS NULL AND @original_LeadSource IS NULL)) AND (([PrefContactMethod] = @original_PrefContactMethod) OR ([PrefContactMethod] IS NULL AND @original_PrefContactMethod IS NULL)) AND [DoNotCall] = @original_DoNotCall AND [DoNotEmail] = @original_DoNotEmail AND [DoNotFax] = @original_DoNotFax AND [DoNotSendLetter] = @original_DoNotSendLetter AND (([AreaOfInterest] = @original_AreaOfInterest) OR ([AreaOfInterest] IS NULL AND @original_AreaOfInterest IS NULL)) AND (([Profession] = @original_Profession) OR ([Profession] IS NULL AND @original_Profession IS NULL)) AND (([ManagerName] = @original_ManagerName) OR ([ManagerName] IS NULL AND @original_ManagerName IS NULL)) AND (([AssistantName] = @original_AssistantName) OR ([AssistantName] IS NULL AND @original_AssistantName IS NULL)) AND (([Birthday] = @original_Birthday) OR ([Birthday] IS NULL AND @original_Birthday IS NULL)) AND (([WeddingAnniversary] = @original_WeddingAnniversary) OR ([WeddingAnniversary] IS NULL AND @original_WeddingAnniversary IS NULL)) AND (([HomeAddress] = @original_HomeAddress) OR ([HomeAddress] IS NULL AND @original_HomeAddress IS NULL)) AND (([OtherAddress] = @original_OtherAddress) OR ([OtherAddress] IS NULL AND @original_OtherAddress IS NULL)) AND (([EmailListType] = @original_EmailListType) OR ([EmailListType] IS NULL AND @original_EmailListType IS NULL)) AND (([AddressBookEmailAddress1] = @original_AddressBookEmailAddress1) OR ([AddressBookEmailAddress1] IS NULL AND @original_AddressBookEmailAddress1 IS NULL)) AND (([AddressBookEmailAddress2] = @original_AddressBookEmailAddress2) OR ([AddressBookEmailAddress2] IS NULL AND @original_AddressBookEmailAddress2 IS NULL)) AND (([AddressBookEmailAddress3] = @original_AddressBookEmailAddress3) OR ([AddressBookEmailAddress3] IS NULL AND @original_AddressBookEmailAddress3 IS NULL)) AND (([AddressBookEmailAddress4] = @original_AddressBookEmailAddress4) OR ([AddressBookEmailAddress4] IS NULL AND @original_AddressBookEmailAddress4 IS NULL)) AND (([AddressBookEmailAddress5] = @original_AddressBookEmailAddress5) OR ([AddressBookEmailAddress5] IS NULL AND @original_AddressBookEmailAddress5 IS NULL)) AND (([AddressBookEmailAddress6] = @original_AddressBookEmailAddress6) OR ([AddressBookEmailAddress6] IS NULL AND @original_AddressBookEmailAddress6 IS NULL)) AND (([EmailAddressType1] = @original_EmailAddressType1) OR ([EmailAddressType1] IS NULL AND @original_EmailAddressType1 IS NULL)) AND (([EmailAddressType2] = @original_EmailAddressType2) OR ([EmailAddressType2] IS NULL AND @original_EmailAddressType2 IS NULL)) AND (([EmailAddressType3] = @original_EmailAddressType3) OR ([EmailAddressType3] IS NULL AND @original_EmailAddressType3 IS NULL)) AND (([EmailAddressType4] = @original_EmailAddressType4) OR ([EmailAddressType4] IS NULL AND @original_EmailAddressType4 IS NULL)) AND (([EmailAddressType5] = @original_EmailAddressType5) OR ([EmailAddressType5] IS NULL AND @original_EmailAddressType5 IS NULL)) AND (([EmailAddressType6] = @original_EmailAddressType6) OR ([EmailAddressType6] IS NULL AND @original_EmailAddressType6 IS NULL)) AND (([AddressBookEntryId1] = @original_AddressBookEntryId1) OR ([AddressBookEntryId1] IS NULL AND @original_AddressBookEntryId1 IS NULL)) AND (([AddressBookEntryId2] = @original_AddressBookEntryId2) OR ([AddressBookEntryId2] IS NULL AND @original_AddressBookEntryId2 IS NULL)) AND (([AddressBookEntryId3] = @original_AddressBookEntryId3) OR ([AddressBookEntryId3] IS NULL AND @original_AddressBookEntryId3 IS NULL)) AND (([AddressBookEntryId4] = @original_AddressBookEntryId4) OR ([AddressBookEntryId4] IS NULL AND @original_AddressBookEntryId4 IS NULL)) AND (([AddressBookEntryId5] = @original_AddressBookEntryId5) OR ([AddressBookEntryId5] IS NULL AND @original_AddressBookEntryId5 IS NULL)) AND (([AddressBookEntryId6] = @original_AddressBookEntryId6) OR ([AddressBookEntryId6] IS NULL AND @original_AddressBookEntryId6 IS NULL)) AND (([MessageDeliveryTime] = @original_MessageDeliveryTime) OR ([MessageDeliveryTime] IS NULL AND @original_MessageDeliveryTime IS NULL)) AND (([CustomerID] = @original_CustomerID) OR ([CustomerID] IS NULL AND @original_CustomerID IS NULL)) AND (([PostalAddressStreet] = @original_PostalAddressStreet) OR ([PostalAddressStreet] IS NULL AND @original_PostalAddressStreet IS NULL)) AND (([PostalAddressCity] = @original_PostalAddressCity) OR ([PostalAddressCity] IS NULL AND @original_PostalAddressCity IS NULL)) AND (([PostalAddressState] = @original_PostalAddressState) OR ([PostalAddressState] IS NULL AND @original_PostalAddressState IS NULL)) AND (([PostalAddressCountry] = @original_PostalAddressCountry) OR ([PostalAddressCountry] IS NULL AND @original_PostalAddressCountry IS NULL)) AND (([PostalAddressPOB] = @original_PostalAddressPOB) OR ([PostalAddressPOB] IS NULL AND @original_PostalAddressPOB IS NULL)) AND (([AssignedTo] = @original_AssignedTo) OR ([AssignedTo] IS NULL AND @original_AssignedTo IS NULL)) AND (([IMAddress] = @original_IMAddress) OR ([IMAddress] IS NULL AND @original_IMAddress IS NULL)) AND (([OfficeLocation] = @original_OfficeLocation) OR ([OfficeLocation] IS NULL AND @original_OfficeLocation IS NULL)) AND (([Nickname] = @original_Nickname) OR ([Nickname] IS NULL AND @original_Nickname IS NULL)) AND (([Children] = @original_Children) OR ([Children] IS NULL AND @original_Children IS NULL)) AND (([Hobby] = @original_Hobby) OR ([Hobby] IS NULL AND @original_Hobby IS NULL)) AND (([Spouse] = @original_Spouse) OR ([Spouse] IS NULL AND @original_Spouse IS NULL)) AND (([ReferredEntryId] = @original_ReferredEntryId) OR ([ReferredEntryId] IS NULL AND @original_ReferredEntryId IS NULL)) AND (([CompressedRichText] = @original_CompressedRichText) OR ([CompressedRichText] IS NULL AND @original_CompressedRichText IS NULL)) AND (([User1] = @original_User1) OR ([User1] IS NULL AND @original_User1 IS NULL)) AND (([User2] = @original_User2) OR ([User2] IS NULL AND @original_User2 IS NULL)) AND (([User3] = @original_User3) OR ([User3] IS NULL AND @original_User3 IS NULL)) AND (([User4] = @original_User4) OR ([User4] IS NULL AND @original_User4 IS NULL)) AND (([PercentComplete] = @original_PercentComplete) OR ([PercentComplete] IS NULL AND @original_PercentComplete IS NULL)) AND (([YomiFirstName] = @original_YomiFirstName) OR ([YomiFirstName] IS NULL AND @original_YomiFirstName IS NULL)) AND (([YomiLastName] = @original_YomiLastName) OR ([YomiLastName] IS NULL AND @original_YomiLastName IS NULL)) AND (([YomiCompanyName] = @original_YomiCompanyName) OR ([YomiCompanyName] IS NULL AND @original_YomiCompanyName IS NULL)) AND (([Territory] = @original_Territory) OR ([Territory] IS NULL AND @original_Territory IS NULL)) AND (([TypeOfEntity] = @original_TypeOfEntity) OR ([TypeOfEntity] IS NULL AND @original_TypeOfEntity IS NULL)) AND (([AccountNumber] = @original_AccountNumber) OR ([AccountNumber] IS NULL AND @original_AccountNumber IS NULL)) AND (([Revenue] = @original_Revenue) OR ([Revenue] IS NULL AND @original_Revenue IS NULL)) AND (([TickerSymbol] = @original_TickerSymbol) OR ([TickerSymbol] IS NULL AND @original_TickerSymbol IS NULL)) AND (([Employees] = @original_Employees) OR ([Employees] IS NULL AND @original_Employees IS NULL)) AND (([YomiAccountName] = @original_YomiAccountName) OR ([YomiAccountName] IS NULL AND @original_YomiAccountName IS NULL)) AND (([OpportunityType] = @original_OpportunityType) OR ([OpportunityType] IS NULL AND @original_OpportunityType IS NULL)) AND (([Probability] = @original_Probability) OR ([Probability] IS NULL AND @original_Probability IS NULL)) AND (([OpportunityStage] = @original_OpportunityStage) OR ([OpportunityStage] IS NULL AND @original_OpportunityStage IS NULL)) AND (([OpportunityStatus] = @original_OpportunityStatus) OR ([OpportunityStatus] IS NULL AND @original_OpportunityStatus IS NULL)) AND (([OpportunityCloseDate] = @original_OpportunityCloseDate) OR ([OpportunityCloseDate] IS NULL AND @original_OpportunityCloseDate IS NULL)) AND (([Competition] = @original_Competition) OR ([Competition] IS NULL AND @original_Competition IS NULL)) AND (([PaymentTerms] = @original_PaymentTerms) OR ([PaymentTerms] IS NULL AND @original_PaymentTerms IS NULL)) AND (([ExpirationDate] = @original_ExpirationDate) OR ([ExpirationDate] IS NULL AND @original_ExpirationDate IS NULL)) AND (([DeliveryDate] = @original_DeliveryDate) OR ([DeliveryDate] IS NULL AND @original_DeliveryDate IS NULL)) AND (([ProjectStartDate] = @original_ProjectStartDate) OR ([ProjectStartDate] IS NULL AND @original_ProjectStartDate IS NULL)) AND (([ProjectDueDate] = @original_ProjectDueDate) OR ([ProjectDueDate] IS NULL AND @original_ProjectDueDate IS NULL)) AND (([Priority] = @original_Priority) OR ([Priority] IS NULL AND @original_Priority IS NULL)) AND (([ProjectStatus] = @original_ProjectStatus) OR ([ProjectStatus] IS NULL AND @original_ProjectStatus IS NULL)) AND (([ProjectType] = @original_ProjectType) OR ([ProjectType] IS NULL AND @original_ProjectType IS NULL))" InsertCommand="INSERT INTO [ContactDetailsTable] ([ContactServiceID], [FirstName], [MiddleName], [LastName], [Prefix], [Suffix], [WorkAddressCity], [WorkAddressCountry], [WorkAddressPOB], [WorkAddressZip], [WorkAddressState], [WorkAddressStreet], [HomeAddressCity], [HomeAddressCountry], [HomeAddressPOB], [HomeAddressZip], [HomeAddressState], [HomeAddressStreet], [OtherAddressCity], [OtherAddressCountry], [OtherAddressPOB], [OtherAddressZip], [OtherAddressState], [OtherAddressStreet], [PhoneNum1], [BusinessPhone2], [CallbackNum], [PhoneNum4], [ISDNNum], [PhoneNum5], [PrimaryPhoneNum], [RadioPhoneNum], [TelexNum], [PhoneNum6], [DisplaySelectors], [EmailDisplayAs1], [EmailDisplayAs2], [EmailDisplayAs3], [ContactNotes], [ReferredBy], [LeadSource], [PrefContactMethod], [DoNotCall], [DoNotEmail], [DoNotFax], [DoNotSendLetter], [AreaOfInterest], [Profession], [ManagerName], [AssistantName], [Birthday], [WeddingAnniversary], [HomeAddress], [OtherAddress], [EmailListType], [AddressBookEmailAddress1], [AddressBookEmailAddress2], [AddressBookEmailAddress3], [AddressBookEmailAddress4], [AddressBookEmailAddress5], [AddressBookEmailAddress6], [EmailAddressType1], [EmailAddressType2], [EmailAddressType3], [EmailAddressType4], [EmailAddressType5], [EmailAddressType6], [AddressBookEntryId1], [AddressBookEntryId2], [AddressBookEntryId3], [AddressBookEntryId4], [AddressBookEntryId5], [AddressBookEntryId6], [MessageDeliveryTime], [CustomerID], [PostalAddressStreet], [PostalAddressCity], [PostalAddressState], [PostalAddressCountry], [PostalAddressPOB], [AssignedTo], [IMAddress], [OfficeLocation], [Nickname], [Children], [Hobby], [Spouse], [ReferredEntryId], [CompressedRichText], [User1], [User2], [User3], [User4], [PercentComplete], [YomiFirstName], [YomiLastName], [YomiCompanyName], [Territory], [TypeOfEntity], [AccountNumber], [Revenue], [TickerSymbol], [Employees], [YomiAccountName], [OpportunityType], [Probability], [OpportunityStage], [OpportunityStatus], [OpportunityCloseDate], [Competition], [PaymentTerms], [ExpirationDate], [DeliveryDate], [ProjectStartDate], [ProjectDueDate], [Priority], [ProjectStatus], [ProjectType]) VALUES (@ContactServiceID, @FirstName, @MiddleName, @LastName, @Prefix, @Suffix, @WorkAddressCity, @WorkAddressCountry, @WorkAddressPOB, @WorkAddressZip, @WorkAddressState, @WorkAddressStreet, @HomeAddressCity, @HomeAddressCountry, @HomeAddressPOB, @HomeAddressZip, @HomeAddressState, @HomeAddressStreet, @OtherAddressCity, @OtherAddressCountry, @OtherAddressPOB, @OtherAddressZip, @OtherAddressState, @OtherAddressStreet, @PhoneNum1, @BusinessPhone2, @CallbackNum, @PhoneNum4, @ISDNNum, @PhoneNum5, @PrimaryPhoneNum, @RadioPhoneNum, @TelexNum, @PhoneNum6, @DisplaySelectors, @EmailDisplayAs1, @EmailDisplayAs2, @EmailDisplayAs3, @ContactNotes, @ReferredBy, @LeadSource, @PrefContactMethod, @DoNotCall, @DoNotEmail, @DoNotFax, @DoNotSendLetter, @AreaOfInterest, @Profession, @ManagerName, @AssistantName, @Birthday, @WeddingAnniversary, @HomeAddress, @OtherAddress, @EmailListType, @AddressBookEmailAddress1, @AddressBookEmailAddress2, @AddressBookEmailAddress3, @AddressBookEmailAddress4, @AddressBookEmailAddress5, @AddressBookEmailAddress6, @EmailAddressType1, @EmailAddressType2, @EmailAddressType3, @EmailAddressType4, @EmailAddressType5, @EmailAddressType6, @AddressBookEntryId1, @AddressBookEntryId2, @AddressBookEntryId3, @AddressBookEntryId4, @AddressBookEntryId5, @AddressBookEntryId6, @MessageDeliveryTime, @CustomerID, @PostalAddressStreet, @PostalAddressCity, @PostalAddressState, @PostalAddressCountry, @PostalAddressPOB, @AssignedTo, @IMAddress, @OfficeLocation, @Nickname, @Children, @Hobby, @Spouse, @ReferredEntryId, @CompressedRichText, @User1, @User2, @User3, @User4, @PercentComplete, @YomiFirstName, @YomiLastName, @YomiCompanyName, @Territory, @TypeOfEntity, @AccountNumber, @Revenue, @TickerSymbol, @Employees, @YomiAccountName, @OpportunityType, @Probability, @OpportunityStage, @OpportunityStatus, @OpportunityCloseDate, @Competition, @PaymentTerms, @ExpirationDate, @DeliveryDate, @ProjectStartDate, @ProjectDueDate, @Priority, @ProjectStatus, @ProjectType)" OldValuesParameterFormatString="original_{0}"

SelectCommand="SELECT * FROM [ContactDetailsTable] WHERE ([ContactServiceID] = @ContactServiceID)"

UpdateCommand="UPDATE [ContactDetailsTable] SET

[FirstName] = @FirstName,

[MiddleName] = @MiddleName,

[LastName] = @LastName,

[Prefix] = @Prefix,

[Suffix] = @Suffix,

[WorkAddressCity] = @WorkAddressCity,

[WorkAddressCountry] = @WorkAddressCountry,

[WorkAddressPOB] = @WorkAddressPOB,

[WorkAddressZip] = @WorkAddressZip,

[WorkAddressState] = @WorkAddressState,

[WorkAddressStreet] = @WorkAddressStreet,

[PhoneNum1] = @PhoneNum1,

[BusinessPhone2] = @BusinessPhone2,

[EmailDisplayAs1] = @EmailDisplayAs1,

[EmailDisplayAs2] = @EmailDisplayAs2,

[ContactNotes] = @ContactNotes,

[AddressBookEmailAddress1] = @AddressBookEmailAddress1,

[AddressBookEmailAddress2] = @AddressBookEmailAddress2,

[CustomerID] = @CustomerID,

[PostalAddressStreet] = @PostalAddressStreet,

[PostalAddressCity] = @PostalAddressCity,

[PostalAddressState] = @PostalAddressState,

[PostalAddressCountry] = @PostalAddressCountry,

[PostalAddressPOB] = @PostalAddressPOB

WHERE [ContactServiceID] = @original_ContactServiceID ">

<DeleteParameters>

<asp:Parameter Name="original_ContactServiceID" Type="Int32" />

<asp:Parameter Name="original_FirstName" Type="String" />

<asp:Parameter Name="original_MiddleName" Type="String" />

<asp:Parameter Name="original_LastName" Type="String" />

<asp:Parameter Name="original_Prefix" Type="String" />

<asp:Parameter Name="original_Suffix" Type="String" />

<asp:Parameter Name="original_WorkAddressCity" Type="String" />

<asp:Parameter Name="original_WorkAddressCountry" Type="String" />

<asp:Parameter Name="original_WorkAddressPOB" Type="String" />

<asp:Parameter Name="original_WorkAddressZip" Type="String" />

<asp:Parameter Name="original_WorkAddressState" Type="String" />

<asp:Parameter Name="original_WorkAddressStreet" Type="String" />

<asp:Parameter Name="original_HomeAddressCity" Type="String" />

<asp:Parameter Name="original_HomeAddressCountry" Type="String" />

<asp:Parameter Name="original_HomeAddressPOB" Type="String" />

<asp:Parameter Name="original_HomeAddressZip" Type="String" />

<asp:Parameter Name="original_HomeAddressState" Type="String" />

<asp:Parameter Name="original_HomeAddressStreet" Type="String" />

<asp:Parameter Name="original_OtherAddressCity" Type="String" />

<asp:Parameter Name="original_OtherAddressCountry" Type="String" />

<asp:Parameter Name="original_OtherAddressPOB" Type="String" />

<asp:Parameter Name="original_OtherAddressZip" Type="String" />

<asp:Parameter Name="original_OtherAddressState" Type="String" />

<asp:Parameter Name="original_OtherAddressStreet" Type="String" />

<asp:Parameter Name="original_PhoneNum1" Type="String" />

<asp:Parameter Name="original_BusinessPhone2" Type="String" />

<asp:Parameter Name="original_CallbackNum" Type="String" />

<asp:Parameter Name="original_PhoneNum4" Type="String" />

<asp:Parameter Name="original_ISDNNum" Type="String" />

<asp:Parameter Name="original_PhoneNum5" Type="String" />

<asp:Parameter Name="original_PrimaryPhoneNum" Type="String" />

<asp:Parameter Name="original_RadioPhoneNum" Type="String" />

<asp:Parameter Name="original_TelexNum" Type="String" />

<asp:Parameter Name="original_PhoneNum6" Type="String" />

<asp:Parameter Name="original_DisplaySelectors" Type="Object" />

<asp:Parameter Name="original_EmailDisplayAs1" Type="String" />

<asp:Parameter Name="original_EmailDisplayAs2" Type="String" />

<asp:Parameter Name="original_EmailDisplayAs3" Type="String" />

<asp:Parameter Name="original_ContactNotes" Type="String" />

<asp:Parameter Name="original_ReferredBy" Type="String" />

<asp:Parameter Name="original_LeadSource" Type="String" />

<asp:Parameter Name="original_PrefContactMethod" Type="String" />

<asp:Parameter Name="original_DoNotCall" Type="Boolean" />

<asp:Parameter Name="original_DoNotEmail" Type="Boolean" />

<asp:Parameter Name="original_DoNotFax" Type="Boolean" />

<asp:Parameter Name="original_DoNotSendLetter" Type="Boolean" />

<asp:Parameter Name="original_AreaOfInterest" Type="String" />

<asp:Parameter Name="original_Profession" Type="String" />

<asp:Parameter Name="original_ManagerName" Type="String" />

<asp:Parameter Name="original_AssistantName" Type="String" />

<asp:Parameter Name="original_Birthday" Type="DateTime" />

<asp:Parameter Name="original_WeddingAnniversary" Type="DateTime" />

<asp:Parameter Name="original_HomeAddress" Type="String" />

<asp:Parameter Name="original_OtherAddress" Type="String" />

<asp:Parameter Name="original_EmailListType" Type="Int32" />

<asp:Parameter Name="original_AddressBookEmailAddress1" Type="String" />

<asp:Parameter Name="original_AddressBookEmailAddress2" Type="String" />

<asp:Parameter Name="original_AddressBookEmailAddress3" Type="String" />

<asp:Parameter Name="original_AddressBookEmailAddress4" Type="String" />

<asp:Parameter Name="original_AddressBookEmailAddress5" Type="String" />

<asp:Parameter Name="original_AddressBookEmailAddress6" Type="String" />

<asp:Parameter Name="original_EmailAddressType1" Type="String" />

<asp:Parameter Name="original_EmailAddressType2" Type="String" />

<asp:Parameter Name="original_EmailAddressType3" Type="String" />

<asp:Parameter Name="original_EmailAddressType4" Type="String" />

<asp:Parameter Name="original_EmailAddressType5" Type="String" />

<asp:Parameter Name="original_EmailAddressType6" Type="String" />

<asp:Parameter Name="original_AddressBookEntryId1" Type="Object" />

<asp:Parameter Name="original_AddressBookEntryId2" Type="Object" />

<asp:Parameter Name="original_AddressBookEntryId3" Type="Object" />

<asp:Parameter Name="original_AddressBookEntryId4" Type="Object" />

<asp:Parameter Name="original_AddressBookEntryId5" Type="Object" />

<asp:Parameter Name="original_AddressBookEntryId6" Type="Object" />

<asp:Parameter Name="original_MessageDeliveryTime" Type="DateTime" />

<asp:Parameter Name="original_CustomerID" Type="String" />

<asp:Parameter Name="original_PostalAddressStreet" Type="String" />

<asp:Parameter Name="original_PostalAddressCity" Type="String" />

<asp:Parameter Name="original_PostalAddressState" Type="String" />

<asp:Parameter Name="original_PostalAddressCountry" Type="String" />

<asp:Parameter Name="original_PostalAddressPOB" Type="String" />

<asp:Parameter Name="original_AssignedTo" Type="String" />

<asp:Parameter Name="original_IMAddress" Type="String" />

<asp:Parameter Name="original_OfficeLocation" Type="String" />

<asp:Parameter Name="original_Nickname" Type="String" />

<asp:Parameter Name="original_Children" Type="String" />

<asp:Parameter Name="original_Hobby" Type="String" />

<asp:Parameter Name="original_Spouse" Type="String" />

<asp:Parameter Name="original_ReferredEntryId" Type="Object" />

<asp:Parameter Name="original_CompressedRichText" Type="Object" />

<asp:Parameter Name="original_User1" Type="String" />

<asp:Parameter Name="original_User2" Type="String" />

<asp:Parameter Name="original_User3" Type="String" />

<asp:Parameter Name="original_User4" Type="String" />

<asp:Parameter Name="original_PercentComplete" Type="Double" />

<asp:Parameter Name="original_YomiFirstName" Type="String" />

<asp:Parameter Name="original_YomiLastName" Type="String" />

<asp:Parameter Name="original_YomiCompanyName" Type="String" />

<asp:Parameter Name="original_Territory" Type="String" />

<asp:Parameter Name="original_TypeOfEntity" Type="String" />

<asp:Parameter Name="original_AccountNumber" Type="String" />

<asp:Parameter Name="original_Revenue" Type="String" />

<asp:Parameter Name="original_TickerSymbol" Type="String" />

<asp:Parameter Name="original_Employees" Type="String" />

<asp:Parameter Name="original_YomiAccountName" Type="String" />

<asp:Parameter Name="original_OpportunityType" Type="String" />

<asp:Parameter Name="original_Probability" Type="Double" />

<asp:Parameter Name="original_OpportunityStage" Type="String" />

<asp:Parameter Name="original_OpportunityStatus" Type="Byte" />

<asp:Parameter Name="original_OpportunityCloseDate" Type="DateTime" />

<asp:Parameter Name="original_Competition" Type="String" />

<asp:Parameter Name="original_PaymentTerms" Type="String" />

<asp:Parameter Name="original_ExpirationDate" Type="DateTime" />

<asp:Parameter Name="original_DeliveryDate" Type="DateTime" />

<asp:Parameter Name="original_ProjectStartDate" Type="DateTime" />

<asp:Parameter Name="original_ProjectDueDate" Type="DateTime" />

<asp:Parameter Name="original_Priority" Type="String" />

<asp:Parameter Name="original_ProjectStatus" Type="String" />

<asp:Parameter Name="original_ProjectType" Type="String" />

</DeleteParameters>

<InsertParameters>

<asp:Parameter Name="ContactServiceID" Type="Int32" />

<asp:Parameter Name="FirstName" Type="String" />

<asp:Parameter Name="MiddleName" Type="String" />

<asp:Parameter Name="LastName" Type="String" />

<asp:Parameter Name="Prefix" Type="String" />

<asp:Parameter Name="Suffix" Type="String" />

<asp:Parameter Name="WorkAddressCity" Type="String" />

<asp:Parameter Name="WorkAddressCountry" Type="String" />

<asp:Parameter Name="WorkAddressPOB" Type="String" />

<asp:Parameter Name="WorkAddressZip" Type="String" />

<asp:Parameter Name="WorkAddressState" Type="String" />

<asp:Parameter Name="WorkAddressStreet" Type="String" />

<asp:Parameter Name="HomeAddressCity" Type="String" />

<asp:Parameter Name="HomeAddressCountry" Type="String" />

<asp:Parameter Name="HomeAddressPOB" Type="String" />

<asp:Parameter Name="HomeAddressZip" Type="String" />

<asp:Parameter Name="HomeAddressState" Type="String" />

<asp:Parameter Name="HomeAddressStreet" Type="String" />

<asp:Parameter Name="OtherAddressCity" Type="String" />

<asp:Parameter Name="OtherAddressCountry" Type="String" />

<asp:Parameter Name="OtherAddressPOB" Type="String" />

<asp:Parameter Name="OtherAddressZip" Type="String" />

<asp:Parameter Name="OtherAddressState" Type="String" />

<asp:Parameter Name="OtherAddressStreet" Type="String" />

<asp:Parameter Name="PhoneNum1" Type="String" />

<asp:Parameter Name="BusinessPhone2" Type="String" />

<asp:Parameter Name="CallbackNum" Type="String" />

<asp:Parameter Name="PhoneNum4" Type="String" />

<asp:Parameter Name="ISDNNum" Type="String" />

<asp:Parameter Name="PhoneNum5" Type="String" />

<asp:Parameter Name="PrimaryPhoneNum" Type="String" />

<asp:Parameter Name="RadioPhoneNum" Type="String" />

<asp:Parameter Name="TelexNum" Type="String" />

<asp:Parameter Name="PhoneNum6" Type="String" />

<asp:Parameter Name="DisplaySelectors" Type="Object" />

<asp:Parameter Name="EmailDisplayAs1" Type="String" />

<asp:Parameter Name="EmailDisplayAs2" Type="String" />

<asp:Parameter Name="EmailDisplayAs3" Type="String" />

<asp:Parameter Name="ContactNotes" Type="String" />

<asp:Parameter Name="ReferredBy" Type="String" />

<asp:Parameter Name="LeadSource" Type="String" />

<asp:Parameter Name="PrefContactMethod" Type="String" />

<asp:Parameter Name="DoNotCall" Type="Boolean" />

<asp:Parameter Name="DoNotEmail" Type="Boolean" />

<asp:Parameter Name="DoNotFax" Type="Boolean" />

<asp:Parameter Name="DoNotSendLetter" Type="Boolean" />

<asp:Parameter Name="AreaOfInterest" Type="String" />

<asp:Parameter Name="Profession" Type="String" />

<asp:Parameter Name="ManagerName" Type="String" />

<asp:Parameter Name="AssistantName" Type="String" />

<asp:Parameter Name="Birthday" Type="DateTime" />

<asp:Parameter Name="WeddingAnniversary" Type="DateTime" />

<asp:Parameter Name="HomeAddress" Type="String" />

<asp:Parameter Name="OtherAddress" Type="String" />

<asp:Parameter Name="EmailListType" Type="Int32" />

<asp:Parameter Name="AddressBookEmailAddress1" Type="String" />

<asp:Parameter Name="AddressBookEmailAddress2" Type="String" />

<asp:Parameter Name="AddressBookEmailAddress3" Type="String" />

<asp:Parameter Name="AddressBookEmailAddress4" Type="String" />

<asp:Parameter Name="AddressBookEmailAddress5" Type="String" />

<asp:Parameter Name="AddressBookEmailAddress6" Type="String" />

<asp:Parameter Name="EmailAddressType1" Type="String" />

<asp:Parameter Name="EmailAddressType2" Type="String" />

<asp:Parameter Name="EmailAddressType3" Type="String" />

<asp:Parameter Name="EmailAddressType4" Type="String" />

<asp:Parameter Name="EmailAddressType5" Type="String" />

<asp:Parameter Name="EmailAddressType6" Type="String" />

<asp:Parameter Name="AddressBookEntryId1" Type="Object" />

<asp:Parameter Name="AddressBookEntryId2" Type="Object" />

<asp:Parameter Name="AddressBookEntryId3" Type="Object" />

<asp:Parameter Name="AddressBookEntryId4" Type="Object" />

<asp:Parameter Name="AddressBookEntryId5" Type="Object" />

<asp:Parameter Name="AddressBookEntryId6" Type="Object" />

<asp:Parameter Name="MessageDeliveryTime" Type="DateTime" />

<asp:Parameter Name="CustomerID" Type="String" />

<asp:Parameter Name="PostalAddressStreet" Type="String" />

<asp:Parameter Name="PostalAddressCity" Type="String" />

<asp:Parameter Name="PostalAddressState" Type="String" />

<asp:Parameter Name="PostalAddressCountry" Type="String" />

<asp:Parameter Name="PostalAddressPOB" Type="String" />

<asp:Parameter Name="AssignedTo" Type="String" />

<asp:Parameter Name="IMAddress" Type="String" />

<asp:Parameter Name="OfficeLocation" Type="String" />

<asp:Parameter Name="Nickname" Type="String" />

<asp:Parameter Name="Children" Type="String" />

<asp:Parameter Name="Hobby" Type="String" />

<asp:Parameter Name="Spouse" Type="String" />

<asp:Parameter Name="ReferredEntryId" Type="Object" />

<asp:Parameter Name="CompressedRichText" Type="Object" />

<asp:Parameter Name="User1" Type="String" />

<asp:Parameter Name="User2" Type="String" />

<asp:Parameter Name="User3" Type="String" />

<asp:Parameter Name="User4" Type="String" />

<asp:Parameter Name="PercentComplete" Type="Double" />

<asp:Parameter Name="YomiFirstName" Type="String" />

<asp:Parameter Name="YomiLastName" Type="String" />

<asp:Parameter Name="YomiCompanyName" Type="String" />

<asp:Parameter Name="Territory" Type="String" />

<asp:Parameter Name="TypeOfEntity" Type="String" />

<asp:Parameter Name="AccountNumber" Type="String" />

<asp:Parameter Name="Revenue" Type="String" />

<asp:Parameter Name="TickerSymbol" Type="String" />

<asp:Parameter Name="Employees" Type="String" />

<asp:Parameter Name="YomiAccountName" Type="String" />

<asp:Parameter Name="OpportunityType" Type="String" />

<asp:Parameter Name="Probability" Type="Double" />

<asp:Parameter Name="OpportunityStage" Type="String" />

<asp:Parameter Name="OpportunityStatus" Type="Byte" />

<asp:Parameter Name="OpportunityCloseDate" Type="DateTime" />

<asp:Parameter Name="Competition" Type="String" />

<asp:Parameter Name="PaymentTerms" Type="String" />

<asp:Parameter Name="ExpirationDate" Type="DateTime" />

<asp:Parameter Name="DeliveryDate" Type="DateTime" />

<asp:Parameter Name="ProjectStartDate" Type="DateTime" />

<asp:Parameter Name="ProjectDueDate" Type="DateTime" />

<asp:Parameter Name="Priority" Type="String" />

<asp:Parameter Name="ProjectStatus" Type="String" />

<asp:Parameter Name="ProjectType" Type="String" />

</InsertParameters>

<SelectParameters>

<asp:QueryStringParameter Name="ContactServiceID" QueryStringField="ContactServiceID" Type="Int32" />

</SelectParameters>

<UpdateParameters>