public static void DeleteDatabase()
{
using (StarredWordDataContext db = new StarredWordDataContext(StarredWordDataContext.DBConnectionString))
{
db.DeleteDatabase();
}
}
public static void CreateDatabase()
{
using (StarredWordDataContext db = new StarredWordDataContext(StarredWordDataContext.DBConnectionString))
{
if (db.DatabaseExists() == false)
db.CreateDatabase();
}
}
public static bool IsWordStarred(int wordSourceId, int wordId)
{
using (StarredWordDataContext db = new StarredWordDataContext(StarredWordDataContext.DBConnectionString))
{
var itemsInDB = from StarredWordItem starredWordItem in db.StarredWordItems
where starredWordItem.WordSourceId == wordSourceId && starredWordItem.WordIdOfWordSource == wordId
select starredWordItem;
if (itemsInDB.Count() != 0)
return true;
else
return false;
}
}
/* 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);
}
}
public static List<StarredWordItem> GetListDescByAddTime()
{
using (StarredWordDataContext db = new StarredWordDataContext(StarredWordDataContext.DBConnectionString))
{
var itemsInDB = from StarredWordItem starredWordItem in db.StarredWordItems
orderby starredWordItem.AddTime descending
select starredWordItem;
return new List<StarredWordItem>(itemsInDB);
}
}
