Questions on UI for ASP.NET AJAX Forum

110,713 questions

4 answers

505 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

161 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>