| 1/22/2025 10:15:31 AM |
PASSED |
CreateContractFromBillingPlan |
**** AssemblyInitialize
**** BillingTestInitialize
Created CustomerID: 61879
Created ContractID: 64353
Debug Trace:
ExecuteScalar - /* GetInsertSql(wd_Customer) */ INSERT INTO [dbo].[wd_Customer]([GUID],[CustomerName],[Status],[Address1],[Address2],[City],[State],[Zip],[Country],[NumUsers],[CreationDate],[LeadDate],[LeadSource],[PrimaryContact],[PrimaryContactTitle],[PrimaryPhone],[PrimaryEmail],[ReferalChannelID],[ReferalAgentID],[SalesChannelID],[SalesAgentID],[FollowUpDate],[DomainID],[Email_DomainName],[Email_ServerTypeID],[Email_ServerIP],[Email_ServerISP],[Email_SecuritySolutionID],[NumUsers_txt],[dash_InitialLeadFollowupTime],[BrandingID],[BillingMethodID],[ReferringURL],[LeadTag],[ParentCustomerID],[ChildCustomerCount],[MarginTier],[OutstandingFollowups],[ActiveEmailServiceContractID],[OrgType],[AccountManagerID],[XID],[LastNoteDate],[LastNoteText],[TouchCount],[PostiniSiteID],[IsTaxExempt],[LastCustomerOutreach],[OldPostiniSiteID],[PostiniStatus],[LastContractReminder],[OriginLeadTag],[EmailServiceProvider],[VisitorUid],[GeoIP_Address],[GeoIP_State],[GeoIP_Country],[GeoIP_Lat],[GeoIP_Long],[Industry],[IsNotable],[LogoUrl]) VALUES(@GUID,@CustomerName,@Status,@Address1,@Address2,@City,@State,@Zip,@Country,@NumUsers,@CreationDate,@LeadDate,@LeadSource,@PrimaryContact,@PrimaryContactTitle,@PrimaryPhone,@PrimaryEmail,@ReferalChannelID,@ReferalAgentID,@SalesChannelID,@SalesAgentID,@FollowUpDate,@DomainID,@Email_DomainName,@Email_ServerTypeID,@Email_ServerIP,@Email_ServerISP,@Email_SecuritySolutionID,@NumUsers_txt,@dash_InitialLeadFollowupTime,@BrandingID,@BillingMethodID,@ReferringURL,@LeadTag,@ParentCustomerID,@ChildCustomerCount,@MarginTier,@OutstandingFollowups,@ActiveEmailServiceContractID,@OrgType,@AccountManagerID,@XID,@LastNoteDate,@LastNoteText,@TouchCount,@PostiniSiteID,@IsTaxExempt,@LastCustomerOutreach,@OldPostiniSiteID,@PostiniStatus,@LastContractReminder,@OriginLeadTag,@EmailServiceProvider,@VisitorUid,@GeoIP_Address,@GeoIP_State,@GeoIP_Country,@GeoIP_Lat,@GeoIP_Long,@Industry,@IsNotable,@LogoUrl);SELECT SCOPE_IDENTITY() AS newID;
GetReader - /* GetSelectSql(wd_Customer) */ SELECT TOP 100 PERCENT [dbo].[wd_Customer].[ID], [dbo].[wd_Customer].[GUID], [dbo].[wd_Customer].[CustomerName], [dbo].[wd_Customer].[Status], [dbo].[wd_Customer].[Address1], [dbo].[wd_Customer].[Address2], [dbo].[wd_Customer].[City], [dbo].[wd_Customer].[State], [dbo].[wd_Customer].[Zip], [dbo].[wd_Customer].[Country], [dbo].[wd_Customer].[NumUsers], [dbo].[wd_Customer].[CreationDate], [dbo].[wd_Customer].[LeadDate], [dbo].[wd_Customer].[LeadSource], [dbo].[wd_Customer].[PrimaryContact], [dbo].[wd_Customer].[PrimaryContactTitle], [dbo].[wd_Customer].[PrimaryPhone], [dbo].[wd_Customer].[PrimaryEmail], [dbo].[wd_Customer].[ReferalChannelID], [dbo].[wd_Customer].[ReferalAgentID], [dbo].[wd_Customer].[SalesChannelID], [dbo].[wd_Customer].[SalesAgentID], [dbo].[wd_Customer].[FollowUpDate], [dbo].[wd_Customer].[DomainID], [dbo].[wd_Customer].[Email_DomainName], [dbo].[wd_Customer].[Email_ServerTypeID], [dbo].[wd_Customer].[Email_ServerIP], [dbo].[wd_Customer].[Email_ServerISP], [dbo].[wd_Customer].[Email_SecuritySolutionID], [dbo].[wd_Customer].[NumUsers_txt], [dbo].[wd_Customer].[dash_InitialLeadFollowupTime], [dbo].[wd_Customer].[BrandingID], [dbo].[wd_Customer].[BillingMethodID], [dbo].[wd_Customer].[ReferringURL], [dbo].[wd_Customer].[LeadTag], [dbo].[wd_Customer].[ParentCustomerID], [dbo].[wd_Customer].[ChildCustomerCount], [dbo].[wd_Customer].[MarginTier], [dbo].[wd_Customer].[OutstandingFollowups], [dbo].[wd_Customer].[ActiveEmailServiceContractID], [dbo].[wd_Customer].[OrgType], [dbo].[wd_Customer].[AccountManagerID], [dbo].[wd_Customer].[XID], [dbo].[wd_Customer].[LastNoteDate], [dbo].[wd_Customer].[LastNoteText], [dbo].[wd_Customer].[TouchCount], [dbo].[wd_Customer].[PostiniSiteID], [dbo].[wd_Customer].[IsTaxExempt], [dbo].[wd_Customer].[LastCustomerOutreach], [dbo].[wd_Customer].[OldPostiniSiteID], [dbo].[wd_Customer].[PostiniStatus], [dbo].[wd_Customer].[LastContractReminder], [dbo].[wd_Customer].[OriginLeadTag], [dbo].[wd_Customer].[EmailServiceProvider], [dbo].[wd_Customer].[VisitorUid], [dbo].[wd_Customer].[GeoIP_Address], [dbo].[wd_Customer].[GeoIP_State], [dbo].[wd_Customer].[GeoIP_Country], [dbo].[wd_Customer].[GeoIP_Lat], [dbo].[wd_Customer].[GeoIP_Long], [dbo].[wd_Customer].[Industry], [dbo].[wd_Customer].[IsNotable], [dbo].[wd_Customer].[LogoUrl] FROM [dbo].[wd_Customer] WHERE [dbo].[wd_Customer].[ID] = @ID0 ORDER BY [ID] ASC;
ExecuteScalar - UPDATE [dbo].[wd_Customer] SET [PrimaryContact] = @PrimaryContact, [PrimaryEmail] = @PrimaryEmail WHERE [ID] = @ID; SELECT @ID AS id
GetReader - /* GetSelectSql(wd_Customer) */ SELECT TOP 100 PERCENT [dbo].[wd_Customer].[ID], [dbo].[wd_Customer].[GUID], [dbo].[wd_Customer].[CustomerName], [dbo].[wd_Customer].[Status], [dbo].[wd_Customer].[Address1], [dbo].[wd_Customer].[Address2], [dbo].[wd_Customer].[City], [dbo].[wd_Customer].[State], [dbo].[wd_Customer].[Zip], [dbo].[wd_Customer].[Country], [dbo].[wd_Customer].[NumUsers], [dbo].[wd_Customer].[CreationDate], [dbo].[wd_Customer].[LeadDate], [dbo].[wd_Customer].[LeadSource], [dbo].[wd_Customer].[PrimaryContact], [dbo].[wd_Customer].[PrimaryContactTitle], [dbo].[wd_Customer].[PrimaryPhone], [dbo].[wd_Customer].[PrimaryEmail], [dbo].[wd_Customer].[ReferalChannelID], [dbo].[wd_Customer].[ReferalAgentID], [dbo].[wd_Customer].[SalesChannelID], [dbo].[wd_Customer].[SalesAgentID], [dbo].[wd_Customer].[FollowUpDate], [dbo].[wd_Customer].[DomainID], [dbo].[wd_Customer].[Email_DomainName], [dbo].[wd_Customer].[Email_ServerTypeID], [dbo].[wd_Customer].[Email_ServerIP], [dbo].[wd_Customer].[Email_ServerISP], [dbo].[wd_Customer].[Email_SecuritySolutionID], [dbo].[wd_Customer].[NumUsers_txt], [dbo].[wd_Customer].[dash_InitialLeadFollowupTime], [dbo].[wd_Customer].[BrandingID], [dbo].[wd_Customer].[BillingMethodID], [dbo].[wd_Customer].[ReferringURL], [dbo].[wd_Customer].[LeadTag], [dbo].[wd_Customer].[ParentCustomerID], [dbo].[wd_Customer].[ChildCustomerCount], [dbo].[wd_Customer].[MarginTier], [dbo].[wd_Customer].[OutstandingFollowups], [dbo].[wd_Customer].[ActiveEmailServiceContractID], [dbo].[wd_Customer].[OrgType], [dbo].[wd_Customer].[AccountManagerID], [dbo].[wd_Customer].[XID], [dbo].[wd_Customer].[LastNoteDate], [dbo].[wd_Customer].[LastNoteText], [dbo].[wd_Customer].[TouchCount], [dbo].[wd_Customer].[PostiniSiteID], [dbo].[wd_Customer].[IsTaxExempt], [dbo].[wd_Customer].[LastCustomerOutreach], [dbo].[wd_Customer].[OldPostiniSiteID], [dbo].[wd_Customer].[PostiniStatus], [dbo].[wd_Customer].[LastContractReminder], [dbo].[wd_Customer].[OriginLeadTag], [dbo].[wd_Customer].[EmailServiceProvider], [dbo].[wd_Customer].[VisitorUid], [dbo].[wd_Customer].[GeoIP_Address], [dbo].[wd_Customer].[GeoIP_State], [dbo].[wd_Customer].[GeoIP_Country], [dbo].[wd_Customer].[GeoIP_Lat], [dbo].[wd_Customer].[GeoIP_Long], [dbo].[wd_Customer].[Industry], [dbo].[wd_Customer].[IsNotable], [dbo].[wd_Customer].[LogoUrl] FROM [dbo].[wd_Customer] WHERE [dbo].[wd_Customer].[ID] = @ID0 ORDER BY [ID] ASC;
GetReader - /* GetSelectSql(mxt_AlertGroups) */ SELECT TOP 100 PERCENT [dbo].[mxt_AlertGroups].[ID], [dbo].[mxt_AlertGroups].[UID], [dbo].[mxt_AlertGroups].[Name], [dbo].[mxt_AlertGroups].[ModifiedOn], [dbo].[mxt_AlertGroups].[IsActive], [dbo].[mxt_AlertGroups].[MonthlyPrice], [dbo].[mxt_AlertGroups].[ServiceContractID], [dbo].[mxt_AlertGroups].[FreeAlerts], [dbo].[mxt_AlertGroups].[SummaryDelay], [dbo].[mxt_AlertGroups].[NextSummaryEmail], [dbo].[mxt_AlertGroups].[SnoozedUntil], [dbo].[mxt_AlertGroups].[SnoozedBy], [dbo].[mxt_AlertGroups].[SummaryEmailWorkerBeeID], [dbo].[mxt_AlertGroups].[CreatedByUserID], [dbo].[mxt_AlertGroups].[Feature_MxBatch], [dbo].[mxt_AlertGroups].[ApiKey], [dbo].[mxt_AlertGroups].[ApiNumDailySimple], [dbo].[mxt_AlertGroups].[ApiNumDaily], [dbo].[mxt_AlertGroups].[UseNope], [dbo].[mxt_AlertGroups].[NopeTrace], [dbo].[mxt_AlertGroups].[IgnoreMigration], [dbo].[mxt_AlertGroups].[BlacklistFrequency], [dbo].[mxt_AlertGroups].[EnableServiceProviderAccess], [dbo].[mxt_AlertGroups].[MaxNumberOfUsers], [dbo].[mxt_AlertGroups].[CanQuerySP], [dbo].[mxt_AlertGroups].[BulkLookupMax], [dbo].[mxt_AlertGroups].[BulkLookupLeft], [dbo].[mxt_AlertGroups].[BulkLookupMaxResults], [dbo].[mxt_AlertGroups].[DefaultFreePlanCode], [dbo].[mxt_AlertGroups].[TrialPlanCode], [dbo].[mxt_AlertGroups].[TrialExpirationDate], [dbo].[mxt_AlertGroups].[HasBetaAccess] FROM [dbo].[mxt_AlertGroups] WHERE [dbo].[mxt_AlertGroups].[ServiceContractID] = @ServiceContractID0 ORDER BY [ID] ASC;
ExecuteScalar - /* GetDatabaseVersion */ SELECT @@version
GetReader - SELECT [dbo].[mxtv_AlertGroupByCommand].[NumSubscriptions], [dbo].[mxtv_AlertGroupByCommand].[NumActive], [dbo].[mxtv_AlertGroupByCommand].[AlertGroupID], [dbo].[mxtv_AlertGroupByCommand].[SB_MailBoxClass], [dbo].[mxtv_AlertGroupByCommand].[Command], [dbo].[mxtv_AlertGroupByCommand].[MonthlyRate], [dbo].[mxtv_AlertGroupByCommand].[ExtendedRate]
FROM [dbo].[mxtv_AlertGroupByCommand]
WHERE [dbo].[mxtv_AlertGroupByCommand].[AlertGroupID] = @AlertGroupID0
GetReader - /* GetSelectSql(fb_ServiceContractItem) */ SELECT TOP 100 PERCENT [dbo].[fb_ServiceContractItem].[ID], [dbo].[fb_ServiceContractItem].[ServiceContractID], [dbo].[fb_ServiceContractItem].[ServiceContractItemTypeID], [dbo].[fb_ServiceContractItem].[MonthlyRate], [dbo].[fb_ServiceContractItem].[MinimumUnits], [dbo].[fb_ServiceContractItem].[LastInvoiceUnitCount], [dbo].[fb_ServiceContractItem].[LastInvoiceMBCount], [dbo].[fb_ServiceContractItem].[LastReportedUnitCount], [dbo].[fb_ServiceContractItem].[LastReportedMBCount], [dbo].[fb_ServiceContractItem].[LastReportedDate], [dbo].[fb_ServiceContractItem].[AllotedMBPerUnit] FROM [dbo].[fb_ServiceContractItem] WHERE [dbo].[fb_ServiceContractItem].[ID] = @ID0 ORDER BY [ID] ASC;
ExecuteScalar - UPDATE [dbo].[fb_ServiceContractItem] SET [LastReportedUnitCount] = @LastReportedUnitCount, [LastReportedDate] = @LastReportedDate WHERE [ID] = @ID; SELECT @ID AS id
GetReader - /* GetSelectSql(fb_ServiceContractItem) */ SELECT TOP 100 PERCENT [dbo].[fb_ServiceContractItem].[ID], [dbo].[fb_ServiceContractItem].[ServiceContractID], [dbo].[fb_ServiceContractItem].[ServiceContractItemTypeID], [dbo].[fb_ServiceContractItem].[MonthlyRate], [dbo].[fb_ServiceContractItem].[MinimumUnits], [dbo].[fb_ServiceContractItem].[LastInvoiceUnitCount], [dbo].[fb_ServiceContractItem].[LastInvoiceMBCount], [dbo].[fb_ServiceContractItem].[LastReportedUnitCount], [dbo].[fb_ServiceContractItem].[LastReportedMBCount], [dbo].[fb_ServiceContractItem].[LastReportedDate], [dbo].[fb_ServiceContractItem].[AllotedMBPerUnit] FROM [dbo].[fb_ServiceContractItem] WHERE [dbo].[fb_ServiceContractItem].[ID] = @ID0 ORDER BY [ID] ASC;
ExecuteScalar - UPDATE [dbo].[fb_ServiceContractItem] SET [LastReportedUnitCount] = @LastReportedUnitCount, [LastReportedDate] = @LastReportedDate WHERE [ID] = @ID; SELECT @ID AS id
GetReader - /* GetSelectSql(fb_ServiceContractItem) */ SELECT TOP 100 PERCENT [dbo].[fb_ServiceContractItem].[ID], [dbo].[fb_ServiceContractItem].[ServiceContractID], [dbo].[fb_ServiceContractItem].[ServiceContractItemTypeID], [dbo].[fb_ServiceContractItem].[MonthlyRate], [dbo].[fb_ServiceContractItem].[MinimumUnits], [dbo].[fb_ServiceContractItem].[LastInvoiceUnitCount], [dbo].[fb_ServiceContractItem].[LastInvoiceMBCount], [dbo].[fb_ServiceContractItem].[LastReportedUnitCount], [dbo].[fb_ServiceContractItem].[LastReportedMBCount], [dbo].[fb_ServiceContractItem].[LastReportedDate], [dbo].[fb_ServiceContractItem].[AllotedMBPerUnit] FROM [dbo].[fb_ServiceContractItem] WHERE [dbo].[fb_ServiceContractItem].[ID] = @ID0 ORDER BY [ID] ASC;
ExecuteScalar - UPDATE [dbo].[fb_ServiceContractItem] SET [LastReportedUnitCount] = @LastReportedUnitCount, [LastReportedDate] = @LastReportedDate WHERE [ID] = @ID; SELECT @ID AS id
GetReader - /* GetSelectSql(fb_ServiceContractItem) */ SELECT TOP 100 PERCENT [dbo].[fb_ServiceContractItem].[ID], [dbo].[fb_ServiceContractItem].[ServiceContractID], [dbo].[fb_ServiceContractItem].[ServiceContractItemTypeID], [dbo].[fb_ServiceContractItem].[MonthlyRate], [dbo].[fb_ServiceContractItem].[MinimumUnits], [dbo].[fb_ServiceContractItem].[LastInvoiceUnitCount], [dbo].[fb_ServiceContractItem].[LastInvoiceMBCount], [dbo].[fb_ServiceContractItem].[LastReportedUnitCount], [dbo].[fb_ServiceContractItem].[LastReportedMBCount], [dbo].[fb_ServiceContractItem].[LastReportedDate], [dbo].[fb_ServiceContractItem].[AllotedMBPerUnit] FROM [dbo].[fb_ServiceContractItem] WHERE [dbo].[fb_ServiceContractItem].[ID] = @ID0 ORDER BY [ID] ASC;
GetReader - /* GetSelectSql(fb_ServiceContractItem) */ SELECT TOP 100 PERCENT [dbo].[fb_ServiceContractItem].[ID], [dbo].[fb_ServiceContractItem].[ServiceContractID], [dbo].[fb_ServiceContractItem].[ServiceContractItemTypeID], [dbo].[fb_ServiceContractItem].[MonthlyRate], [dbo].[fb_ServiceContractItem].[MinimumUnits], [dbo].[fb_ServiceContractItem].[LastInvoiceUnitCount], [dbo].[fb_ServiceContractItem].[LastInvoiceMBCount], [dbo].[fb_ServiceContractItem].[LastReportedUnitCount], [dbo].[fb_ServiceContractItem].[LastReportedMBCount], [dbo].[fb_ServiceContractItem].[LastReportedDate], [dbo].[fb_ServiceContractItem].[AllotedMBPerUnit] FROM [dbo].[fb_ServiceContractItem] WHERE [dbo].[fb_ServiceContractItem].[ID] = @ID0 ORDER BY [ID] ASC;
ExecuteScalar - UPDATE [dbo].[fb_ServiceContractItem] SET [LastReportedUnitCount] = @LastReportedUnitCount, [LastReportedDate] = @LastReportedDate WHERE [ID] = @ID; SELECT @ID AS id
GetReader - /* GetSelectSql(mxt_AlertGroups) */ SELECT TOP 100 PERCENT [dbo].[mxt_AlertGroups].[ID], [dbo].[mxt_AlertGroups].[UID], [dbo].[mxt_AlertGroups].[Name], [dbo].[mxt_AlertGroups].[ModifiedOn], [dbo].[mxt_AlertGroups].[IsActive], [dbo].[mxt_AlertGroups].[MonthlyPrice], [dbo].[mxt_AlertGroups].[ServiceContractID], [dbo].[mxt_AlertGroups].[FreeAlerts], [dbo].[mxt_AlertGroups].[SummaryDelay], [dbo].[mxt_AlertGroups].[NextSummaryEmail], [dbo].[mxt_AlertGroups].[SnoozedUntil], [dbo].[mxt_AlertGroups].[SnoozedBy], [dbo].[mxt_AlertGroups].[SummaryEmailWorkerBeeID], [dbo].[mxt_AlertGroups].[CreatedByUserID], [dbo].[mxt_AlertGroups].[Feature_MxBatch], [dbo].[mxt_AlertGroups].[ApiKey], [dbo].[mxt_AlertGroups].[ApiNumDailySimple], [dbo].[mxt_AlertGroups].[ApiNumDaily], [dbo].[mxt_AlertGroups].[UseNope], [dbo].[mxt_AlertGroups].[NopeTrace], [dbo].[mxt_AlertGroups].[IgnoreMigration], [dbo].[mxt_AlertGroups].[BlacklistFrequency], [dbo].[mxt_AlertGroups].[EnableServiceProviderAccess], [dbo].[mxt_AlertGroups].[MaxNumberOfUsers], [dbo].[mxt_AlertGroups].[CanQuerySP], [dbo].[mxt_AlertGroups].[BulkLookupMax], [dbo].[mxt_AlertGroups].[BulkLookupLeft], [dbo].[mxt_AlertGroups].[BulkLookupMaxResults], [dbo].[mxt_AlertGroups].[DefaultFreePlanCode], [dbo].[mxt_AlertGroups].[TrialPlanCode], [dbo].[mxt_AlertGroups].[TrialExpirationDate], [dbo].[mxt_AlertGroups].[HasBetaAccess] FROM [dbo].[mxt_AlertGroups] WHERE [dbo].[mxt_AlertGroups].[ServiceContractID] = @ServiceContractID0 ORDER BY [ID] ASC;
GetReader - SELECT [dbo].[mxtv_AlertGroupByCommand].[NumSubscriptions], [dbo].[mxtv_AlertGroupByCommand].[NumActive], [dbo].[mxtv_AlertGroupByCommand].[AlertGroupID], [dbo].[mxtv_AlertGroupByCommand].[SB_MailBoxClass], [dbo].[mxtv_AlertGroupByCommand].[Command], [dbo].[mxtv_AlertGroupByCommand].[MonthlyRate], [dbo].[mxtv_AlertGroupByCommand].[ExtendedRate]
FROM [dbo].[mxtv_AlertGroupByCommand]
WHERE [dbo].[mxtv_AlertGroupByCommand].[AlertGroupID] = @AlertGroupID0
GetReader - /* GetSelectSql(fb_ServiceContractItem) */ SELECT TOP 100 PERCENT [dbo].[fb_ServiceContractItem].[ID], [dbo].[fb_ServiceContractItem].[ServiceContractID], [dbo].[fb_ServiceContractItem].[ServiceContractItemTypeID], [dbo].[fb_ServiceContractItem].[MonthlyRate], [dbo].[fb_ServiceContractItem].[MinimumUnits], [dbo].[fb_ServiceContractItem].[LastInvoiceUnitCount], [dbo].[fb_ServiceContractItem].[LastInvoiceMBCount], [dbo].[fb_ServiceContractItem].[LastReportedUnitCount], [dbo].[fb_ServiceContractItem].[LastReportedMBCount], [dbo].[fb_ServiceContractItem].[LastReportedDate], [dbo].[fb_ServiceContractItem].[AllotedMBPerUnit] FROM [dbo].[fb_ServiceContractItem] WHERE [dbo].[fb_ServiceContractItem].[ID] = @ID0 ORDER BY [ID] ASC;
ExecuteScalar - UPDATE [dbo].[fb_ServiceContractItem] SET [LastReportedDate] = @LastReportedDate WHERE [ID] = @ID; SELECT @ID AS id
GetReader - /* GetSelectSql(fb_ServiceContractItem) */ SELECT TOP 100 PERCENT [dbo].[fb_ServiceContractItem].[ID], [dbo].[fb_ServiceContractItem].[ServiceContractID], [dbo].[fb_ServiceContractItem].[ServiceContractItemTypeID], [dbo].[fb_ServiceContractItem].[MonthlyRate], [dbo].[fb_ServiceContractItem].[MinimumUnits], [dbo].[fb_ServiceContractItem].[LastInvoiceUnitCount], [dbo].[fb_ServiceContractItem].[LastInvoiceMBCount], [dbo].[fb_ServiceContractItem].[LastReportedUnitCount], [dbo].[fb_ServiceContractItem].[LastReportedMBCount], [dbo].[fb_ServiceContractItem].[LastReportedDate], [dbo].[fb_ServiceContractItem].[AllotedMBPerUnit] FROM [dbo].[fb_ServiceContractItem] WHERE [dbo].[fb_ServiceContractItem].[ID] = @ID0 ORDER BY [ID] ASC;
ExecuteScalar - UPDATE [dbo].[fb_ServiceContractItem] SET [LastReportedDate] = @LastReportedDate WHERE [ID] = @ID; SELECT @ID AS id
GetReader - /* GetSelectSql(fb_ServiceContractItem) */ SELECT TOP 100 PERCENT [dbo].[fb_ServiceContractItem].[ID], [dbo].[fb_ServiceContractItem].[ServiceContractID], [dbo].[fb_ServiceContractItem].[ServiceContractItemTypeID], [dbo].[fb_ServiceContractItem].[MonthlyRate], [dbo].[fb_ServiceContractItem].[MinimumUnits], [dbo].[fb_ServiceContractItem].[LastInvoiceUnitCount], [dbo].[fb_ServiceContractItem].[LastInvoiceMBCount], [dbo].[fb_ServiceContractItem].[LastReportedUnitCount], [dbo].[fb_ServiceContractItem].[LastReportedMBCount], [dbo].[fb_ServiceContractItem].[LastReportedDate], [dbo].[fb_ServiceContractItem].[AllotedMBPerUnit] FROM [dbo].[fb_ServiceContractItem] WHERE [dbo].[fb_ServiceContractItem].[ID] = @ID0 ORDER BY [ID] ASC;
ExecuteScalar - UPDATE [dbo].[fb_ServiceContractItem] SET [LastReportedDate] = @LastReportedDate WHERE [ID] = @ID; SELECT @ID AS id
GetReader - /* GetSelectSql(fb_ServiceContractItem) */ SELECT TOP 100 PERCENT [dbo].[fb_ServiceContractItem].[ID], [dbo].[fb_ServiceContractItem].[ServiceContractID], [dbo].[fb_ServiceContractItem].[ServiceContractItemTypeID], [dbo].[fb_ServiceContractItem].[MonthlyRate], [dbo].[fb_ServiceContractItem].[MinimumUnits], [dbo].[fb_ServiceContractItem].[LastInvoiceUnitCount], [dbo].[fb_ServiceContractItem].[LastInvoiceMBCount], [dbo].[fb_ServiceContractItem].[LastReportedUnitCount], [dbo].[fb_ServiceContractItem].[LastReportedMBCount], [dbo].[fb_ServiceContractItem].[LastReportedDate], [dbo].[fb_ServiceContractItem].[AllotedMBPerUnit] FROM [dbo].[fb_ServiceContractItem] WHERE [dbo].[fb_ServiceContractItem].[ID] = @ID0 ORDER BY [ID] ASC;
GetReader - /* GetSelectSql(fb_ServiceContractItem) */ SELECT TOP 100 PERCENT [dbo].[fb_ServiceContractItem].[ID], [dbo].[fb_ServiceContractItem].[ServiceContractID], [dbo].[fb_ServiceContractItem].[ServiceContractItemTypeID], [dbo].[fb_ServiceContractItem].[MonthlyRate], [dbo].[fb_ServiceContractItem].[MinimumUnits], [dbo].[fb_ServiceContractItem].[LastInvoiceUnitCount], [dbo].[fb_ServiceContractItem].[LastInvoiceMBCount], [dbo].[fb_ServiceContractItem].[LastReportedUnitCount], [dbo].[fb_ServiceContractItem].[LastReportedMBCount], [dbo].[fb_ServiceContractItem].[LastReportedDate], [dbo].[fb_ServiceContractItem].[AllotedMBPerUnit] FROM [dbo].[fb_ServiceContractItem] WHERE [dbo].[fb_ServiceContractItem].[ID] = @ID0 ORDER BY [ID] ASC;
ExecuteScalar - UPDATE [dbo].[fb_ServiceContractItem] SET [LastReportedDate] = @LastReportedDate WHERE [ID] = @ID; SELECT @ID AS id
|
|
7.36 seconds |