/// <summary>
/// Methode zum hinzufügen eines neuen Eintrags in der Datenbank
/// </summary>
/// <param name="filterID">Die ID des Filters</param>
/// <param name="name">Name des Filters</param>
/// <param name="linking">Linking</param>
/// <returns>Die ID des Eintrags in der Datenbank</returns>
public static int Add(string name, string linking, int? formletterPatternID = null)
{
using (TafelModelContainer db = new TafelModelContainer())
{
var filterSet = new FilterSet()
{
FormletterPattern = (formletterPatternID.HasValue) ? db.FormletterPatterns.Single(fp => fp.FormletterPatternID == formletterPatternID) : null,
Name = name,
Linking = linking
};
db.FilterSets.AddObject(filterSet);
db.SaveChanges();
return filterSet.FilterSetID;
}
}
/// <summary>
/// Methode zum hinzufügen eines neuen Eintrags in der Datenbank
/// </summary>
/// <param name="filterID">Die ID des Filters</param>
/// <param name="name">Name des Filters</param>
/// <param name="linking">Linking</param>
/// <returns>Die ID des Eintrags in der Datenbank</returns>
public static int Add(string name, string linking, int?formletterPatternID = null)
{
using (TafelModelContainer db = new TafelModelContainer())
{
var filterSet = new FilterSet()
{
FormletterPattern = (formletterPatternID.HasValue) ? db.FormletterPatterns.Single(fp => fp.FormletterPatternID == formletterPatternID) : null,
Name = name,
Linking = linking
};
db.FilterSets.AddObject(filterSet);
db.SaveChanges();
return(filterSet.FilterSetID);
}
}
/// <summary>
/// Wandelt ein FilterSet der Datenbank in eine Instanz von FilterSetModel um
/// </summary>
/// <param name="filterSet">DataModel.FilterSet</param>
/// <returns>FilterSetModel</returns>
public static FilterSetModel getFilterSetModelFromFilterSet(FilterSet filterSet)
{
if (filterSet == null)
return null;
IEnumerable<Filter> filters = Filter.GetFilters(null, filterSet.FilterSetID);
// Name des FilterSets
FilterSetModel filterSetModel = new FilterSetModel(filterSet.Linking);
filterSetModel.name = filterSet.Name;
// füge diesem filterSet alle filter hinzu
foreach (var filter in filters)
{
FilterModel filterModel = new FilterModel();
// konvertiere die strings aus der datenbank in enums
filterModel.group = (FilterModel.Groups)Enum.Parse(typeof(FilterModel.Groups), filter.Table);
filterModel.criterion = (FilterModel.Criterions)Enum.Parse(typeof(FilterModel.Criterions), filter.Type);
filterModel.operation = (FilterModel.Operations)Enum.Parse(typeof(FilterModel.Operations), filter.Operation);
filterModel.value = SafeStringParser.safeParseToStr(filter.Value);
filterSetModel.filterList.Add(filterModel);
}
return filterSetModel;
}
/// <summary>
/// Veraltete Methode zum Hinzufügen eines neuen Objekts zum EntitySet 'FilterSets'. Verwenden Sie stattdessen die Methode '.Add' der zugeordneten Eigenschaft 'ObjectSet<T>'.
/// </summary>
public void AddToFilterSets(FilterSet filterSet)
{
base.AddObject("FilterSets", filterSet);
}
/// <summary>
/// Erstellt ein neues FilterSet-Objekt.
/// </summary>
/// <param name="filterSetID">Anfangswert der Eigenschaft FilterSetID.</param>
/// <param name="name">Anfangswert der Eigenschaft Name.</param>
/// <param name="linking">Anfangswert der Eigenschaft Linking.</param>
public static FilterSet CreateFilterSet(global::System.Int32 filterSetID, global::System.String name, global::System.String linking)
{
FilterSet filterSet = new FilterSet();
filterSet.FilterSetID = filterSetID;
filterSet.Name = name;
filterSet.Linking = linking;
return filterSet;
}