/// <summary>
/// Gets the <see cref="ConfigItem"/> entity where the ID matches the given specification.
/// </summary>
public static ConfigItem GetById(int configId, BootFX.Common.Data.SqlOperator configIdOperator, BootFX.Common.OnNotFound onNotFound)
{
BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(ConfigItem));
filter.Constraints.Add("ConfigId", configIdOperator, configId);
ConfigItem results = ((ConfigItem)(filter.ExecuteEntity()));
return(results);
}
/// <summary>
/// Gets the <see cref="LookupValue"/> entity where the ID matches the given specification.
/// </summary>
public static LookupValue GetById(int lookupId, BootFX.Common.Data.SqlOperator lookupIdOperator, BootFX.Common.OnNotFound onNotFound)
{
BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(LookupValue));
filter.Constraints.Add("LookupId", lookupIdOperator, lookupId);
LookupValue results = ((LookupValue)(filter.ExecuteEntity()));
return(results);
}
/// <summary>
/// Gets an entity where Username and ApiKeyId are equal to the given values.
/// </summary>
/// <remarks>
/// Created for index <c>Users_Username</c>.
/// </remarks>
public static UserItem GetByUsernameAndApiKeyId(string username, int apiKeyId, BootFX.Common.OnNotFound onNotFound)
{
BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(UserItem));
filter.Constraints.Add("Username", BootFX.Common.Data.SqlOperator.EqualTo, username);
filter.Constraints.Add("ApiKeyId", BootFX.Common.Data.SqlOperator.EqualTo, apiKeyId);
UserItem results = ((UserItem)(filter.ExecuteEntity()));
return results;
}
/// <summary>
/// Gets the <see cref="UserItem"/> entity where the ID matches the given specification.
/// </summary>
public static UserItem GetById(int userId, BootFX.Common.Data.SqlOperator userIdOperator, BootFX.Common.OnNotFound onNotFound)
{
BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(UserItem));
filter.Constraints.Add("UserId", userIdOperator, userId);
UserItem results = ((UserItem)(filter.ExecuteEntity()));
return results;
}
/// <summary>
/// Gets entities where Name matches the given specification.
/// </summary>
/// <remarks>
/// Created for column <c>Name</c>
/// </remarks>
public static ConfigItem GetByName(string name, BootFX.Common.Data.SqlOperator nameOperator)
{
BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(ConfigItem));
filter.Constraints.Add("Name", nameOperator, name);
return((ConfigItem)(filter.ExecuteEntity()));
}
/// <summary>
/// Gets the <see cref="Country"/> entity where the ID matches the given specification.
/// </summary>
public static Country GetById(int countryId, BootFX.Common.Data.SqlOperator countryIdOperator, BootFX.Common.OnNotFound onNotFound)
{
BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(Country));
filter.Constraints.Add("CountryId", countryIdOperator, countryId);
Country results = ((Country)(filter.ExecuteEntity()));
return results;
}
/// <summary>
/// Gets an entity where Username is equal to the given value.
/// </summary>
/// <remarks>
/// Created for index <c>ApiKeys_Username</c>.
/// </remarks>
public static ApiKey GetByUsername(string username, BootFX.Common.OnNotFound onNotFound)
{
BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(ApiKey));
filter.Constraints.Add("Username", BootFX.Common.Data.SqlOperator.EqualTo, username);
ApiKey results = ((ApiKey)(filter.ExecuteEntity()));
return results;
}
/// <summary>
/// Gets an entity where CustomerId and ExternalId are equal to the given values.
/// </summary>
/// <remarks>
/// Created for index <c>IX_ShmResources</c>.
/// </remarks>
public static Resource GetByCustomerIdAndExternalId(int customerId, string externalId, BootFX.Common.OnNotFound onNotFound)
{
BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(Resource));
filter.Constraints.Add("CustomerId", BootFX.Common.Data.SqlOperator.EqualTo, customerId);
filter.Constraints.Add("ExternalId", BootFX.Common.Data.SqlOperator.EqualTo, externalId);
Resource results = ((Resource)(filter.ExecuteEntity()));
return results;
}
/// <summary>
/// Gets the <see cref="TableCatalogItem"/> entity where the ID matches the given specification.
/// </summary>
public static TableCatalogItem GetById(int tableCatalogId, BootFX.Common.Data.SqlOperator tableCatalogIdOperator, BootFX.Common.OnNotFound onNotFound)
{
BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(TableCatalogItem));
filter.Constraints.Add("TableCatalogId", tableCatalogIdOperator, tableCatalogId);
TableCatalogItem results = ((TableCatalogItem)(filter.ExecuteEntity()));
return results;
}
/// <summary>
/// Gets an entity where Token is equal to the given value.
/// </summary>
/// <remarks>
/// Created for index <c>LogonTokens_Token</c>.
/// </remarks>
public static LogonToken GetByToken(string token, BootFX.Common.OnNotFound onNotFound)
{
BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(LogonToken));
filter.Constraints.Add("Token", BootFX.Common.Data.SqlOperator.EqualTo, token);
LogonToken results = ((LogonToken)(filter.ExecuteEntity()));
return results;
}
/// <summary>
/// Gets the <see cref="LogonToken"/> entity where the ID matches the given specification.
/// </summary>
public static LogonToken GetById(int logonTokenId, BootFX.Common.Data.SqlOperator logonTokenIdOperator, BootFX.Common.OnNotFound onNotFound)
{
BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(LogonToken));
filter.Constraints.Add("LogonTokenId", logonTokenIdOperator, logonTokenId);
LogonToken results = ((LogonToken)(filter.ExecuteEntity()));
return results;
}
/// <summary>
/// Gets an entity where ShmCustomerId, Name and TableCatalogId are equal to the given values.
/// </summary>
/// <remarks>
/// Created for index <c>CustomFields_CustomerIdTableCatalogIdName</c>.
/// </remarks>
public static CustomField GetByShmCustomerIdAndNameAndTableCatalogId(int shmCustomerId, string name, int tableCatalogId, BootFX.Common.OnNotFound onNotFound)
{
BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(CustomField));
filter.Constraints.Add("ShmCustomerId", BootFX.Common.Data.SqlOperator.EqualTo, shmCustomerId);
filter.Constraints.Add("Name", BootFX.Common.Data.SqlOperator.EqualTo, name);
filter.Constraints.Add("TableCatalogId", BootFX.Common.Data.SqlOperator.EqualTo, tableCatalogId);
CustomField results = ((CustomField)(filter.ExecuteEntity()));
return results;
}
/// <summary>
/// Gets the <see cref="CustomField"/> entity where the ID matches the given specification.
/// </summary>
public static CustomField GetById(int customFieldId, BootFX.Common.Data.SqlOperator customFieldIdOperator)
{
BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(CustomField));
filter.Constraints.Add("CustomFieldId", customFieldIdOperator, customFieldId);
return ((CustomField)(filter.ExecuteEntity()));
}
/// <summary>
/// Gets the <see cref="ShmResource"/> entity where the ID matches the given specification.
/// </summary>
public static ShmResource GetById(int resourceId, BootFX.Common.Data.SqlOperator resourceIdOperator)
{
BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(ShmResource));
filter.Constraints.Add("ResourceId", resourceIdOperator, resourceId);
return ((ShmResource)(filter.ExecuteEntity()));
}
/// <summary>
/// Gets an entity where ApiKeyId and Email are equal to the given values.
/// </summary>
/// <remarks>
/// Created for index <c>Users_ApiEmail</c>.
/// </remarks>
public static UserItem GetByApiKeyIdAndEmail(int apiKeyId, string email, BootFX.Common.OnNotFound onNotFound)
{
BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(UserItem));
filter.Constraints.Add("ApiKeyId", BootFX.Common.Data.SqlOperator.EqualTo, apiKeyId);
filter.Constraints.Add("Email", BootFX.Common.Data.SqlOperator.EqualTo, email);
UserItem results = ((UserItem)(filter.ExecuteEntity()));
return results;
}
/// <summary>
/// Gets the <see cref="Resource"/> entity where the ID matches the given specification.
/// </summary>
public static Resource GetById(int resourceId, BootFX.Common.Data.SqlOperator resourceIdOperator, BootFX.Common.OnNotFound onNotFound)
{
BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(Resource));
filter.Constraints.Add("ResourceId", resourceIdOperator, resourceId);
Resource results = ((Resource)(filter.ExecuteEntity()));
return results;
}
/// <summary>
/// Gets an entity where TargetTypeName is equal to the given value.
/// </summary>
/// <remarks>
/// Created for index <c>TableCatalogItems_TargetTypeName</c>.
/// </remarks>
public static TableCatalogItem GetByTargetTypeName(string targetTypeName, BootFX.Common.OnNotFound onNotFound)
{
BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(TableCatalogItem));
filter.Constraints.Add("TargetTypeName", BootFX.Common.Data.SqlOperator.EqualTo, targetTypeName);
TableCatalogItem results = ((TableCatalogItem)(filter.ExecuteEntity()));
return results;
}
/// <summary>
/// Gets the <see cref="ApiKey"/> entity where the ID matches the given specification.
/// </summary>
public static ApiKey GetById(int apiKeyId, BootFX.Common.Data.SqlOperator apiKeyIdOperator, BootFX.Common.OnNotFound onNotFound)
{
BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(ApiKey));
filter.Constraints.Add("ApiKeyId", apiKeyIdOperator, apiKeyId);
ApiKey results = ((ApiKey)(filter.ExecuteEntity()));
return results;
}
/// <summary>
/// Gets the <see cref="CustomData"/> entity where the ID matches the given specification.
/// </summary>
public static CustomData GetById(int customDataId, BootFX.Common.Data.SqlOperator customDataIdOperator, BootFX.Common.OnNotFound onNotFound)
{
BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(CustomData));
filter.Constraints.Add("CustomDataId", customDataIdOperator, customDataId);
CustomData results = ((CustomData)(filter.ExecuteEntity()));
return results;
}
/// <summary>
/// Gets an entity where Email is equal to the given value.
/// </summary>
/// <remarks>
/// Created for index <c>ApiKeys_Email</c>.
/// </remarks>
public static ApiKey GetByEmail(string email, BootFX.Common.OnNotFound onNotFound)
{
BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(ApiKey));
filter.Constraints.Add("Email", BootFX.Common.Data.SqlOperator.EqualTo, email);
ApiKey results = ((ApiKey)(filter.ExecuteEntity()));
return results;
}
/// <summary>
/// Gets an entity where CustomFieldId and ObjectId are equal to the given values.
/// </summary>
/// <remarks>
/// Created for index <c>CustomData_CustomFieldIdObjectId</c>.
/// </remarks>
public static CustomData GetByCustomFieldIdAndObjectId(int customFieldId, long objectId, BootFX.Common.OnNotFound onNotFound)
{
BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(CustomData));
filter.Constraints.Add("CustomFieldId", BootFX.Common.Data.SqlOperator.EqualTo, customFieldId);
filter.Constraints.Add("ObjectId", BootFX.Common.Data.SqlOperator.EqualTo, objectId);
CustomData results = ((CustomData)(filter.ExecuteEntity()));
return results;
}
/// <summary>
/// Gets an entity where Name is equal to the given value.
/// </summary>
/// <remarks>
/// Created for index <c>Countries_Name</c>.
/// </remarks>
public static Country GetByName(string name, BootFX.Common.OnNotFound onNotFound)
{
BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(Country));
filter.Constraints.Add("Name", BootFX.Common.Data.SqlOperator.EqualTo, name);
Country results = ((Country)(filter.ExecuteEntity()));
return results;
}
/// <summary>
/// Gets the <see cref="Bookmark"/> entity where the ID matches the given specification.
/// </summary>
public static Bookmark GetById(int bookmarkId, BootFX.Common.Data.SqlOperator bookmarkIdOperator, BootFX.Common.OnNotFound onNotFound)
{
BootFX.Common.Data.SqlFilter filter = new BootFX.Common.Data.SqlFilter(typeof(Bookmark));
filter.Constraints.Add("BookmarkId", bookmarkIdOperator, bookmarkId);
Bookmark results = ((Bookmark)(filter.ExecuteEntity()));
return results;
}