/* insert only when entry not existed */
public static void InsertEntry(int wordSourceId, int wordId)
{
if (IsWordStarred(wordSourceId, wordId)) return;
using (StarredWordDataContext db = new StarredWordDataContext(StarredWordDataContext.DBConnectionString))
{
StarredWordItem newItem = new StarredWordItem
{
WordSourceId = wordSourceId,
WordIdOfWordSource = wordId,
AddTime = DateTime.Now
};
db.StarredWordItems.InsertOnSubmit(newItem);
db.SubmitChanges();
}
}
public static void DeleteEntry(int wordSourceId, int wordId)
{
try
{
using (StarredWordDataContext db = new StarredWordDataContext(StarredWordDataContext.DBConnectionString))
{
var itemsInDB = from StarredWordItem starredWordItem in db.StarredWordItems
where starredWordItem.WordSourceId == wordSourceId && starredWordItem.WordIdOfWordSource == wordId
select starredWordItem;
db.StarredWordItems.DeleteAllOnSubmit(itemsInDB);
db.SubmitChanges();
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
}
