/// <summary>
/// Adds a properly formatted <see cref="WildcardToken"/> to the <see cref="WhereParameter"/> value
/// </summary>
/// <param name="wItem">The <see cref="WhereParameter"/> that needs the <see cref="WildcardToken"/></param>
protected void BuildWildcardValue(WhereParameter wItem)
{
switch (wItem.Operator)
{
case WhereParameter.Operand.StartsWith:
case WhereParameter.Operand.NotStartsWith:
wItem.Value = string.Format("{1}{0}", WildcardToken, wItem.Value);
break;
case WhereParameter.Operand.EndsWith:
case WhereParameter.Operand.NotEndsWith:
wItem.Value = string.Format("{0}{1}", WildcardToken, wItem.Value);
break;
case WhereParameter.Operand.Contains:
case WhereParameter.Operand.NotContains:
wItem.Value = string.Format("{0}{1}{0}", WildcardToken, wItem.Value);
break;
default:
break;
}
}
public void BetweenClauseWithTearoffs()
{
obj.Where.HIREDATE.BetweenBeginValue = "01/01/1999";
obj.Where.HIREDATE.BetweenEndValue = "12/31/1999";
obj.Where.HIREDATE.Operator = WhereParameter.Operand.Between;
// Create tearoff
WhereParameter wp = obj.Where.TearOff.HIREDATE;
wp.BetweenBeginValue = "01/01/2001";
wp.BetweenEndValue = "12/31/2001";
wp.Operator = WhereParameter.Operand.Between;
// Create tearoff
wp = obj.Where.TearOff.HIREDATE;
wp.BetweenBeginValue = "01/01/2003";
wp.BetweenEndValue = "12/31/2003";
wp.Operator = WhereParameter.Operand.Between;
Assert.IsTrue(obj.Query.Load("OR"));
Console.WriteLine("BetweenClauseWithTearoffs: {0}", obj.Query.LastQuery);
Assert.AreEqual(12, obj.RowCount);
}
public void WhereClauseReset()
{
_EmployeeID_W = null;
_LastName_W = null;
_FirstName_W = null;
_Title_W = null;
_TitleOfCourtesy_W = null;
_BirthDate_W = null;
_HireDate_W = null;
_Address_W = null;
_City_W = null;
_Region_W = null;
_PostalCode_W = null;
_Country_W = null;
_HomePhone_W = null;
_Extension_W = null;
_Photo_W = null;
_Notes_W = null;
_ReportsTo_W = null;
_PhotoPath_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
_ID_W = null;
_FullName_W = null;
_Address_W = null;
_Mobile_W = null;
_UserName_W = null;
_Password_W = null;
_UserType_W = null;
_Active_W = null;
_FirstName_W = null;
_LastName_W = null;
_DepartmentID_W = null;
_JobTitleID_W = null;
_CreatedByID_W = null;
_LastLogin_W = null;
_CreatedDate_W = null;
_ModifiedDate_W = null;
_PasswordExpires_W = null;
_ExpirationDate_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
_Id_W = null;
_Company_id_W = null;
_Name_W = null;
_LastResortTechId_W = null;
_ConfigDistributedRouting_W = null;
_TintClassType_W = null;
_BitRestrictToTechs_W = null;
_TxtDesc_W = null;
_BitAllowEmailParsing_W = null;
_IntPriorityId_W = null;
_TintLevelOverride_W = null;
_BtInactive_W = null;
_ParentId_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
PreferredId_W = null;
_LocationId_W = null;
_SubstituteId_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
_ProductID_W = null;
_ProductCategoryID_W = null;
_ProductFileID_W = null;
_ProductName_W = null;
_Price_W = null;
_InitContent_W = null;
_MainContent_W = null;
_Status_W = null;
_Images_W = null;
_Priority_W = null;
_ViewCount_W = null;
_InitContent2_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
_Id_W = null;
_Login_id_W = null;
_Company_id_W = null;
_Location_id_W = null;
_UserType_Id_W = null;
_Room_W = null;
_CheckinStatus_W = null;
_Notes_W = null;
_QueEmailAddress_W = null;
_DtLastLogin_W = null;
_ConfigHourlyRate_W = null;
_ConfigPartialSetup_W = null;
_ConfigEmailNewTicket_W = null;
_ConfigEmailTicketResponse_W = null;
_ConfigEmailUserTicketResponse_W = null;
_ConfigEmailUserNewTicket_W = null;
_BitAllowQueEmailParsing_W = null;
_Token_W = null;
_TintLevel_W = null;
_SupGroupId_W = null;
_IntAccountId_W = null;
_IntAcctLocationId_W = null;
_BtCfgCCRep_W = null;
_VchOrganization_W = null;
_BtGlobalFilterEnabled_W = null;
_BtLimitToAssignedTkts_W = null;
_BtDisabledReports_W = null;
_BtUserInactive_W = null;
_PrintFontSize_W = null;
_AccountLocationId_W = null;
_CreationCatId_W = null;
_LocationId_W = null;
_TintTicketTimer_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
_TestimonialID_W = null;
_ClientName_W = null;
_ClientInfo_W = null;
_MainContent_W = null;
_Status_W = null;
_Priority_W = null;
this._entity.Query.FlushWhereParameters();
}
//*** This is where you consruct Query 2
void SetupQuery2()
{
// This is what we are going for:
// The top 5 distinct employees where
// (LastNames have "A" anywhere in them
// or begin with "P")
// and the HireDate is not NULL
// (and the BirthDate is between 1/1/1990 and today
// or BirthDate is NULL.)
// In SQL syntax:
// SELECT DISTINCT TOP 5 [EmployeeID], [LastName], [FirstName], [BirthDate]
// FROM [Employees]
// WHERE ([LastName] LIKE @LastName1 OR [LastName] LIKE @LastName2 )
// OR [HireDate] IS NOT NULL
// AND ([BirthDate] BETWEEN @BirthDate4 AND @BirthDate5 OR [BirthDate] IS NULL )
// ORDER BY [LastName] ASC, [FirstName] ASC
// 'LastNames that have "A" anywhere in them
// or begin with "P".'
// Use a TearOff to use LastName in 2 Where clauses.
// Notice:
// The conjunction will precede the Where clause.
// The wp.Conjuction mis-spelling.
tmpEnt2.Query.OpenParenthesis();
tmpEnt2.Where.LastName.Value = "%A%";
tmpEnt2.Where.LastName.Operator = WhereParameter.Operand.Like;
WhereParameter wp = tmpEnt2.Where.TearOff.LastName;
wp.Value = "P%";
wp.Operator = WhereParameter.Operand.Like;
wp.Conjuction = WhereParameter.Conj.Or;
tmpEnt2.Query.CloseParenthesis();
// 'And the HireDate is not NULL.'
// The default conjunction is "AND".
// To change the default conjuction use
// tmpEnt2.Query.Load("OR");
tmpEnt2.Where.HireDate.Operator = WhereParameter.Operand.IsNotNull;
// 'And the BirthDate is between 1/1/1990 and today
// or BirthDate is NULL.'
// We'll need another TearOff for the second use
// of BirthDate.
// We need this before OpenParenthesis().
tmpEnt2.Query.AddConjunction(WhereParameter.Conj.And);
tmpEnt2.Query.OpenParenthesis();
tmpEnt2.Where.BirthDate.Operator = WhereParameter.Operand.Between;
tmpEnt2.Where.BirthDate.BetweenBeginValue = "1900/01/01 00:00:00";
tmpEnt2.Where.BirthDate.BetweenEndValue = DateTime.Today.ToString();
wp = tmpEnt2.Where.TearOff.BirthDate;
wp.Operator = WhereParameter.Operand.IsNull;
wp.Conjuction = WhereParameter.Conj.Or;
tmpEnt2.Query.CloseParenthesis();
// Only return the EmployeeID, LastName, FirstName, and BirthDate
// If you have no AddResultColumns,
// then the query defaults to 'SELECT *'.
// Once we limit columns, we cannot call Save().
tmpEnt2.Query.AddResultColumn(Employees.ColumnNames.EmployeeID);
tmpEnt2.Query.AddResultColumn(Employees.ColumnNames.LastName);
tmpEnt2.Query.AddResultColumn(Employees.ColumnNames.FirstName);
tmpEnt2.Query.AddResultColumn(Employees.ColumnNames.BirthDate);
// Order by LastName, FirstName
// You can add as many order by columns as you like
// by repeatedly calling this.
tmpEnt2.Query.AddOrderBy(Employees.ColumnNames.LastName, WhereParameter.Dir.ASC);
tmpEnt2.Query.AddOrderBy(Employees.ColumnNames.FirstName, WhereParameter.Dir.ASC);
// Bring back only distinct rows
tmpEnt2.Query.Distinct = true;
// Bring back the top 5 rows
tmpEnt2.Query.Top = 5;
}
public void WhereClauseReset()
{
_NewsID_W = null;
_Title_W = null;
_NewsCategoryID_W = null;
_Image_W = null;
_PostedDate_W = null;
_Status_W = null;
_Priority_W = null;
_MainContent_W = null;
_InitContent_W = null;
_Image2_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
_ID_W = null;
_SiteName_W = null;
_Name_W = null;
_Content_W = null;
_Description_W = null;
_IsActive_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
_MaTB_W = null;
_ThoiGian_W = null;
_SoTruyCap_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
_DId_W = null;
_Id_W = null;
_TintPriority_W = null;
_Name_W = null;
_Description_W = null;
_SLAPercentage_W = null;
_SLADays_W = null;
_SLAHours_W = null;
_SLAMinutes_W = null;
_BitDefault_W = null;
_BtSkipSaturday_W = null;
_BtSkipSunday_W = null;
_BtSkipHolidays_W = null;
_BtUseBusHours_W = null;
_SLAResponsePercentage_W = null;
_SLAResponseDays_W = null;
_SLAResponseHours_W = null;
_SLAResponseMinutes_W = null;
_BtResponseSkipSaturday_W = null;
_BtResponseSkipSunday_W = null;
_BtResponseSkipHolidays_W = null;
_BtResponseUseBusHours_W = null;
_BtRstrctUsr_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
_Id_W = null;
_DId_W = null;
_BtInactive_W = null;
_IntCreated_W = null;
_DtCreated_W = null;
_IntUpdatedBy_W = null;
_DtUpdated_W = null;
_VchName_W = null;
_ParentId_W = null;
_BtResolved_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
_ProductFileID_W = null;
_FileName_W = null;
_Url_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
_MailLogId_W = null;
_LocationId_W = null;
_SendDate_W = null;
_MailTo_W = null;
_MailFrom_W = null;
_Subject_W = null;
_Message_W = null;
_MailType_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
_Id_W = null;
_DId_W = null;
_LocationId_W = null;
_TicketLevel_W = null;
_TechPoolType_W = null;
_RoutingMethod_W = null;
_LastResortTechId_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
_TemplateId_W = null;
_Name_W = null;
_Header_W = null;
_Description_W = null;
_Text_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
_DId_W = null;
_TintOrder_W = null;
_TintRoute_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
_LocationId_W = null;
_Name_W = null;
_NameShort_W = null;
_Street_W = null;
_City_W = null;
_ZipCode_W = null;
_PhoneNumOffice_W = null;
_RegionId_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
_SubstituteId_W = null;
_Active_W = null;
_AvailabilityTimeStart_W = null;
_AvailabilityTimeEnd_W = null;
_AvailabilityWeekDays_W = null;
_GradeId_W = null;
_UserId_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
_ProductFileUploadID_W = null;
_ProductFileID_W = null;
_ProductID_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
_SettingID_W = null;
_MetaKeyword1_W = null;
_MetaDescription1_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
TeacherId_W = null;
_Active_W = null;
UserProfileId_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
_BannerID_W = null;
_Images_W = null;
_ImageThumb_W = null;
_Link_W = null;
_Title_W = null;
_InitContent_W = null;
_Priority_W = null;
_Status_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
_Id_W = null;
_Class_id_W = null;
_LoginCompanyJunc_id_W = null;
_Locations_id_W = null;
_LocationId_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
_StaticPageID_W = null;
_PageCode_W = null;
_PageName_W = null;
_MenuName_W = null;
_Parent_W = null;
_PageContent_W = null;
_DateCreated_W = null;
_Images_W = null;
_Priority_W = null;
_Status_W = null;
_InitContent_W = null;
_GroupID_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
_StaticPageGroupID_W = null;
_Description_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
_Company_id_W = null;
_Company_name_W = null;
_DtAccountCreated_W = null;
_DtExpiration_W = null;
_IntLicensedUsers_W = null;
_ActiveStatus_W = null;
_ConfigNewUserWizard_W = null;
_LogoName_W = null;
_ConfigClassTracking_W = null;
_ConfigPartstracking_W = null;
_ConfigTechCheckin_W = null;
_ConfigSerialNumber_W = null;
_SerialNumberName_W = null;
_ConfigFolders_W = null;
_ConfigUAQ_W = null;
_BtCfgSchedTkt_W = null;
_ConfigChooseTechnician_W = null;
_ConfigAssetTracking_W = null;
_ConfigPasswordStorage_W = null;
_ConfigOnHoldStatus_W = null;
_ConfigTimeTracking_W = null;
_ConfigCalenderDate_W = null;
_ConfigLocationTracking_W = null;
_ConfigPriorities_W = null;
_ConfigUserPriorities_W = null;
_ConfigRoomNumber_W = null;
_ConfigChooseTechLimitQues_W = null;
_ConfigCategoryTracking_W = null;
_LastTicketNumber_W = null;
_ConfigHourlyRate_W = null;
_ConfigCustomFields_W = null;
_DtCancelled_W = null;
_TktExportdtStart_W = null;
_TktExportdtEnd_W = null;
_ConfigMiscCost_W = null;
_ConfigTrvlCost_W = null;
_ConfigViewTktCost_W = null;
_ConfigAllowEmailNewAcct_W = null;
_ConfigDirectory_W = null;
_ConfigNTP_W = null;
_IntLicensedAssets_W = null;
_ConfigExpectDueDateUser_W = null;
_TinyBusHourStart_W = null;
_TinyBusMinStart_W = null;
_TinyBusHourStop_W = null;
_TinyBusMinStop_W = null;
_SintHourOffset_W = null;
_ConfigUpdtLctnPrfl_W = null;
_ConfigUCP_W = null;
_ConfigRCD_W = null;
_ConfigLVL_W = null;
_TintRoutingOrder_W = null;
_BtConfigLVLUser_W = null;
_TintDateFormat_W = null;
_IntBWAId_W = null;
_TintGraceDays_W = null;
_BtCfgAcctMngr_W = null;
_BtAcctRtOvr_W = null;
_TintAcctRtOvrLevel_W = null;
_TintAcctRtOvrOption_W = null;
_TintAcctRtOvrRouteType_W = null;
_IntUTROL_W = null;
_IntTTROL_W = null;
_BtReqClosureNote_W = null;
_BtCfgACDC_W = null;
_BtCfgRES_W = null;
_BtCfgCON_W = null;
_BtCfgAFTE_W = null;
_BtCfgAECT_W = null;
_BtCfgEAHA_W = null;
_CharWDays_W = null;
_BtCfgSuppressBWALogos_W = null;
_BtCfgESG_W = null;
_BtCfgIDM_W = null;
_BtCfgCCS_W = null;
_BtCfgESC_W = null;
_BtCfgEMTE_W = null;
_BtCfgSBTP_W = null;
_BtCfgCUSN_W = null;
_BtCfgACCT_W = null;
_RemoteAssistanceSessions_W = null;
_BtCfgRAST_W = null;
_BtCfgASTT_W = null;
_PrintFontSize_W = null;
_BtCfgATCL_W = null;
_BtCfgCFTO_W = null;
_CharCurrency_W = null;
_ReportStartDate_W = null;
_ReportEndDate_W = null;
_ReportDateRange_W = null;
_CreationCatId_W = null;
_TintTicketTimer_W = null;
_BtCfgTEDO_W = null;
_BtCfgTROL_W = null;
_BtCfgMSAL_W = null;
_CompanyStatus_W = null;
_BWAAccountId_W = null;
_BWADepartmentId_W = null;
_BtGeneralLdap_W = null;
_BtLdap_W = null;
_LdapLocalURL_W = null;
_BtCfgLimTechAsts_W = null;
_BtCfgNRAdmin_W = null;
_BtGlobalSSL_W = null;
_BtGlobalLDAP_W = null;
_BtCfgDTTCOT_W = null;
_Company_guid_W = null;
_DefaultDistanceRate_W = null;
_BtCfgAllowSelectAnyLocation_W = null;
_BtAllowSUserToChooseAnyLogin_W = null;
_BtAllowSUserToChooseAnyLocation_W = null;
_BtDisallowTechsToCreateLocations_W = null;
_BtMailHyperLinksStatus_W = null;
_EmailSuffixes_W = null;
_BtCfgFLCN_W = null;
_BtCfgATTU_W = null;
_BtDisplayAddUserLink_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
GradeId_W = null;
_Name_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
_UserProfileId_W = null;
_UserId_W = null;
_Phone_W = null;
_Email_W = null;
_Address_W = null;
_Address2_W = null;
_APPENDAGE_W = null;
_BirthDate_W = null;
_JobPosition_W = null;
_JobAssignmentDescription_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
_ID_W = null;
_CompanyID_W = null;
_DLOrganizationID_W = null;
_DLDepartmentID_W = null;
_Enabled_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
_UserID_W = null;
_Username_W = null;
_Password_W = null;
_Email_W = null;
_Status_W = null;
_RoleID_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
_AdvTypeID_W = null;
_Description_W = null;
this._entity.Query.FlushWhereParameters();
}
public void WhereClauseReset()
{
_ID_W = null;
this._entity.Query.FlushWhereParameters();
}
