/// <summary>
/// Creates a MySQL command selecting a collection of <see cref="FoodItemGroupProxy"/>.
/// </summary>
/// <param name="whereClause">The WHERE clause which the MySQL command should use.</param>
/// <param name="parameterAdder">The callback to add MySQL parameters to the MySQL command.</param>
/// <returns>MySQL command selecting a collection of <see cref="FoodItemGroupProxy"/>.</returns>
private static MySqlCommand BuildSystemDataCommandForSelecting(string whereClause = null, Action <SystemDataCommandBuilder> parameterAdder = null)
{
StringBuilder selectStatementBuilder = new StringBuilder("SELECT fig.FoodItemGroupIdentifier,fig.FoodItemIdentifier,fig.FoodGroupIdentifier,fig.IsPrimary,fi.IsActive AS FoodItemIsActive,fg.ParentIdentifier AS FoodGroupParentIdentifier,fg.IsActive AS FoodGroupIsActive,pfg.ParentIdentifier AS FoodGroupParentsParentIdentifier,pfg.IsActive AS FoodGroupParentsParentIsActive FROM FoodItemGroups AS fig INNER JOIN FoodItems AS fi ON fi.FoodItemIdentifier=fig.FoodItemIdentifier INNER JOIN FoodGroups AS fg ON fg.FoodGroupIdentifier=fig.FoodGroupIdentifier LEFT JOIN FoodGroups AS pfg ON pfg.FoodGroupIdentifier=fg.ParentIdentifier");
if (string.IsNullOrWhiteSpace(whereClause) == false)
{
selectStatementBuilder.Append($" {whereClause}");
}
SystemDataCommandBuilder systemDataCommandBuilder = new SystemDataCommandBuilder(selectStatementBuilder.ToString());
if (parameterAdder == null)
{
return(systemDataCommandBuilder.Build());
}
parameterAdder(systemDataCommandBuilder);
return(systemDataCommandBuilder.Build());
}
/// <summary>
/// Creates a MySQL command selecting a collection of <see cref="FoodItemProxy"/>.
/// </summary>
/// <param name="whereClause">The WHERE clause which the MySQL command should use.</param>
/// <param name="parameterAdder">The callback to add MySQL parameters to the MySQL command.</param>
/// <returns>MySQL command selecting a collection of <see cref="FoodItemProxy"/>.</returns>
internal static MySqlCommand BuildSystemDataCommandForSelecting(string whereClause = null, Action <SystemDataCommandBuilder> parameterAdder = null)
{
StringBuilder selectStatementBuilder = new StringBuilder("SELECT fi.FoodItemIdentifier,fi.IsActive FROM FoodItems AS fi");
if (string.IsNullOrWhiteSpace(whereClause) == false)
{
selectStatementBuilder.Append($" {whereClause}");
}
SystemDataCommandBuilder systemDataCommandBuilder = new SystemDataCommandBuilder(selectStatementBuilder.ToString());
if (parameterAdder == null)
{
return(systemDataCommandBuilder.Build());
}
parameterAdder(systemDataCommandBuilder);
return(systemDataCommandBuilder.Build());
}
/// <summary>
/// Creates a MySQL command selecting a collection of <see cref="ForeignKeyProxy"/>.
/// </summary>
/// <param name="whereClause">The WHERE clause which the MySQL command should use.</param>
/// <param name="parameterAdder">The callback to add MySQL parameters to the MySQL command.</param>
/// <returns>MySQL command selecting a collection of <see cref="ForeignKeyProxy"/>.</returns>
internal static MySqlCommand BuildSystemDataCommandForSelecting(string whereClause = null, Action <SystemDataCommandBuilder> parameterAdder = null)
{
StringBuilder selectStatementBuilder = new StringBuilder("SELECT fk.ForeignKeyIdentifier,fk.DataProviderIdentifier,dp.Name AS DataProviderName,dp.HandlesPayments,dp.DataSourceStatementIdentifier,fk.ForeignKeyForIdentifier,fk.ForeignKeyForTypes,fk.ForeignKeyValue FROM ForeignKeys AS fk INNER JOIN DataProviders AS dp ON dp.DataProviderIdentifier=fk.DataProviderIdentifier");
if (string.IsNullOrWhiteSpace(whereClause) == false)
{
selectStatementBuilder.Append($" {whereClause}");
}
SystemDataCommandBuilder systemDataCommandBuilder = new SystemDataCommandBuilder(selectStatementBuilder.ToString());
if (parameterAdder == null)
{
return(systemDataCommandBuilder.Build());
}
parameterAdder(systemDataCommandBuilder);
return(systemDataCommandBuilder.Build());
}
/// <summary>
/// Creates a MySQL command selecting a collection of <see cref="TranslationProxy"/>.
/// </summary>
/// <param name="whereClause">The WHERE clause which the MySQL command should use.</param>
/// <param name="parameterAdder">The callback to add MySQL parameters to the MySQL command.</param>
/// <returns>MySQL command selecting a collection of <see cref="TranslationProxy"/>.</returns>
internal static MySqlCommand BuildSystemDataCommandForSelecting(string whereClause = null, Action <SystemDataCommandBuilder> parameterAdder = null)
{
StringBuilder selectStatementBuilder = new StringBuilder("SELECT t.TranslationIdentifier AS TranslationIdentifier,t.OfIdentifier AS OfIdentifier,ti.TranslationInfoIdentifier AS InfoIdentifier,ti.CultureName AS CultureName,t.Value AS Value FROM Translations AS t INNER JOIN TranslationInfos AS ti ON ti.TranslationInfoIdentifier=t.InfoIdentifier");
if (string.IsNullOrWhiteSpace(whereClause) == false)
{
selectStatementBuilder.Append($" {whereClause}");
}
SystemDataCommandBuilder systemDataCommandBuilder = new SystemDataCommandBuilder(selectStatementBuilder.ToString());
if (parameterAdder == null)
{
return(systemDataCommandBuilder.Build());
}
parameterAdder(systemDataCommandBuilder);
return(systemDataCommandBuilder.Build());
}
