/// <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); }