/// <summary>
/// Returns a string from either the TextArea or TextField custom metadata. If none is find a null string
/// is returned
/// </summary>
/// <param name="groupNum">The custom metadata group number</param>
/// <returns></returns>
public string GetStringValForGroup(int groupNum)
{
var allSettings = BrandMetadataSetting.FindMany(new BrandMetadataSettingFinder()
{
});
var setting = allSettings.FirstOrDefault(s => s.GroupNumber == groupNum);
//if this metadata is either not found or is of type selectable i.e. there is no textual field then return null
if (setting == null)
{
return(null);
}
if (setting.UiControlType == (int)BrandMetadataUiControlType.TextArea ||
setting.UiControlType == (int)BrandMetadataUiControlType.Select)
{
var aa = MetadataTextAreasList.FirstOrDefault(a => a.GroupNumber == groupNum);
return(aa != null ? aa.TextAreaValue : null);
}
if (setting.UiControlType == (int)BrandMetadataUiControlType.TextField)
{
var aa = MetadataTextFieldsList.FirstOrDefault(a => a.GroupNumber == groupNum);
return(aa != null ? aa.TextFieldValue : null);
}
return(null);
}
public virtual BrandMetadataSetting Update(BrandMetadataSetting brandMetadataSetting)
{
if (!brandMetadataSetting.IsDirty || brandMetadataSetting.IsNull)
{
// Nothing to do - no point hammering the database unnecessarily
return(brandMetadataSetting);
}
IDbCommand command = CreateCommand();
if (brandMetadataSetting.IsNew)
{
// Adding
command.CommandText = "INSERT INTO [BrandMetadataSetting] ([BrandId], [FieldId], [FieldName], [IsRequired], [OnAssetForm], [OnAssetDetail], [AdditionalCopy], [ToolTip],[UiControlType],[IsCustom],[CatalogueOrderNum],[AssetDetailOrderNum] ) VALUES (@brandId, @fieldId, @fieldName, @isRequired, @onAssetForm, @onAssetDetail, @additionalCopy, @toolTip, @uiControlType, @isCustom, @catalogueOrderNum, @assetDetailOrderNum) ; SELECT @@identity AS NewId;";
}
else
{
// Updating
command.CommandText = "UPDATE [BrandMetadataSetting] SET [BrandId] = @brandId, [FieldId] = @fieldId, [FieldName] = @fieldName, [IsRequired] = @isRequired, [OnAssetForm] = @onAssetForm, [OnAssetDetail] = @onAssetDetail, [AdditionalCopy] = @additionalCopy, [ToolTip] = @toolTip, [UiControlType] = @uiControlType, [IsCustom] = @isCustom, [CatalogueOrderNum] = @catalogueOrderNum, [AssetDetailOrderNum] = @assetDetailOrderNum WHERE BrandMetadataSettingId = @brandMetadataSettingId";
}
command.Parameters.Add(CreateParameter("@brandId", brandMetadataSetting.BrandId));
command.Parameters.Add(CreateParameter("@fieldId", brandMetadataSetting.FieldId));
command.Parameters.Add(CreateParameter("@fieldName", brandMetadataSetting.FieldName));
command.Parameters.Add(CreateParameter("@isRequired", brandMetadataSetting.IsRequired));
command.Parameters.Add(CreateParameter("@onAssetForm", brandMetadataSetting.OnAssetForm));
command.Parameters.Add(CreateParameter("@onAssetDetail", brandMetadataSetting.OnAssetDetail));
command.Parameters.Add(CreateParameter("@additionalCopy", brandMetadataSetting.AdditionalCopy));
command.Parameters.Add(CreateParameter("@toolTip", brandMetadataSetting.ToolTip));
// command.Parameters.Add (CreateParameter("@allowMultiple", brandMetadataSetting.AllowMultiple));
command.Parameters.Add(CreateParameter("@uiControlType", brandMetadataSetting.UiControlType));
command.Parameters.Add(CreateParameter("@isCustom", brandMetadataSetting.IsCustom));
command.Parameters.Add(CreateParameter("@catalogueOrderNum", brandMetadataSetting.CatalogueOrderNum));
command.Parameters.Add(CreateParameter("@assetDetailOrderNum", brandMetadataSetting.AssetDetailOrderNum));
if (brandMetadataSetting.IsNew)
{
brandMetadataSetting.BrandMetadataSettingId = Convert.ToInt32(ExecScalar(command));
}
else
{
command.Parameters.Add(CreateParameter("@brandMetadataSettingId", brandMetadataSetting.BrandMetadataSettingId));
ExecuteCommand(command);
}
brandMetadataSetting.IsDirty = false;
brandMetadataSetting.ChangedProperties.Clear();
return(brandMetadataSetting);
}
protected override object ReadRow(IRowReader reader)
{
BrandMetadataSetting brandMetadataSetting = BrandMetadataSetting.New();
// Table Fields
brandMetadataSetting.BrandMetadataSettingId = reader.GetInt32("BrandMetadataSettingId");
brandMetadataSetting.BrandId = reader.GetInt32("BrandId");
brandMetadataSetting.FieldId = reader.GetString("FieldId");
brandMetadataSetting.FieldName = reader.GetString("FieldName");
brandMetadataSetting.IsRequired = reader.GetBoolean("IsRequired");
brandMetadataSetting.OnAssetForm = reader.GetBoolean("OnAssetForm");
brandMetadataSetting.OnAssetDetail = reader.GetBoolean("OnAssetDetail");
brandMetadataSetting.AdditionalCopy = reader.GetString("AdditionalCopy");
brandMetadataSetting.ToolTip = reader.GetString("ToolTip");
brandMetadataSetting.UiControlType = reader.GetInt32("UiControlType");
brandMetadataSetting.IsCustom = reader.GetBoolean("IsCustom");
brandMetadataSetting.CatalogueOrderNum = reader.GetInt32("CatalogueOrderNum");
brandMetadataSetting.AssetDetailOrderNum = reader.GetInt32("AssetDetailOrderNum");
brandMetadataSetting.IsDirty = false;
brandMetadataSetting.ChangedProperties.Clear();
return(brandMetadataSetting);
}
public static BrandMetadataSetting FindOne(BrandMetadataSettingFinder finder)
{
BrandMetadataSetting BrandMetadataSetting = BrandMetadataSettingMapper.Instance.FindOne(finder);
return(BrandMetadataSetting ?? Empty);
}
public static BrandMetadataSetting Update(BrandMetadataSetting metadataSetting)
{
return(BrandMetadataSettingMapper.Instance.Update(metadataSetting));
}
public static BrandMetadataSetting Get(Nullable <Int32> BrandMetadataSettingId)
{
BrandMetadataSetting BrandMetadataSetting = BrandMetadataSettingMapper.Instance.Get(BrandMetadataSettingId);
return(BrandMetadataSetting ?? Empty);
}
