/// <summary>
/// Gets the entity keyword corresponding to the specified keyword.
/// </summary>
/// <param name="keyword">The keyword or null.</param>
/// <param name="context">The context.</param>
/// <returns>The entity or null.</returns>
/// <exception cref="ArgumentNullException">context</exception>
public static EfKeyword GetEfKeyword(Keyword keyword, BiblioDbContext context)
{
if (context == null)
{
throw new ArgumentNullException(nameof(context));
}
if (keyword == null)
{
return(null);
}
EfKeyword ef = context.Keywords.FirstOrDefault(
k => k.Language == keyword.Language &&
k.Value == keyword.Value);
if (ef == null)
{
ef = new EfKeyword
{
Language = keyword.Language,
Value = keyword.Value,
Valuex = StandardFilter.Apply(keyword.Value, true)
};
context.Keywords.Add(ef);
}
return(ef);
}
/// <summary>
/// Gets the keyword with the specified ID.
/// </summary>
/// <param name="id">The identifier.</param>
/// <returns>The keyword or null if not found.</returns>
public Keyword GetKeyword(int id)
{
using (var db = GetContext())
{
EfKeyword ef = db.Keywords.Find(id);
return(ef != null?EfHelper.GetKeyword(ef) : null);
}
}
private static void AddKeywords(IList <Keyword> keywords, EfWork work,
BiblioDbContext context)
{
// collect the keywords to be assigned, adding the missing ones
List <EfKeywordWork> requested = new List <EfKeywordWork>();
foreach (Keyword keyword in keywords)
{
// find the keyword by its content, as we have no ID
EfKeyword efk = context.Keywords.FirstOrDefault(k =>
k.Value == keyword.Value && k.Language == keyword.Language);
// if not found, add it
if (efk == null)
{
efk = new EfKeyword
{
Language = keyword.Language,
Value = keyword.Value,
Valuex = StandardFilter.Apply(keyword.Value, true)
};
context.Keywords.Add(efk);
}
requested.Add(new EfKeywordWork
{
Keyword = efk,
Work = work
});
}
// remove all the keywords which are no more requested
if (work.KeywordWorks != null)
{
foreach (EfKeywordWork kw in work.KeywordWorks)
{
if (requested.All(r => r.KeywordId != kw.KeywordId))
{
context.KeywordWorks.Remove(kw);
}
}
}
else
{
work.KeywordWorks = new List <EfKeywordWork>();
}
// add all those which are not yet present
foreach (EfKeywordWork kw in requested)
{
if (work.KeywordWorks.All(
r => r.KeywordId != kw.KeywordId))
{
work.KeywordWorks.Add(kw);
}
}
}
/// <summary>
/// Gets the keyword corresponding to the specified keyword entity.
/// </summary>
/// <param name="ef">The keyword or null.</param>
/// <returns>The keyword or null.</returns>
public static Keyword GetKeyword(EfKeyword ef)
{
if (ef == null)
{
return(null);
}
return(new Keyword
{
Language = ef.Language,
Value = ef.Value
});
}
/// <summary>
/// Deletes the keyword with the specified ID.
/// </summary>
/// <param name="id">The identifier.</param>
public void DeleteKeyword(int id)
{
using (var db = GetContext())
{
EfKeyword ef = db.Keywords.Find(id);
if (ef != null)
{
db.Keywords.Remove(ef);
db.SaveChanges();
}
}
}
/// <summary>
/// Adds or updates the specified keyword.
/// </summary>
/// <param name="keyword">The keyword.</param>
/// <returns>The keyword's ID.</returns>
/// <exception cref="ArgumentNullException">keyword</exception>
public int AddKeyword(Keyword keyword)
{
if (keyword == null)
{
throw new ArgumentNullException(nameof(keyword));
}
using (var db = GetContext())
{
EfKeyword ef = EfHelper.GetEfKeyword(keyword, db);
db.SaveChanges();
return(ef.Id);
}
}