public static void InsertEntry(DateTime date, double durationMinutes, string contentTitle)
{
StudyHistoryDataContext studyHistoryDB = new StudyHistoryDataContext(StudyHistoryDataContext.DBConnectionString);
StudyHistoryItem itemToFind = null;
var itemsInDB = from StudyHistoryItem studyHistory in studyHistoryDB.StudyHistoryItems
select studyHistory;
IEnumerator<StudyHistoryItem> enumerator = studyHistoryDB.StudyHistoryItems.GetEnumerator();
while (enumerator.MoveNext())
{
StudyHistoryItem item = enumerator.Current;
if (item.ContentTitle.Equals(contentTitle)
&& date.CompareTo(item.Date) == 0)
{
itemToFind = item;
break;
}
}
if (itemToFind == null)
{
itemToFind = new StudyHistoryItem
{
Date = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day),
DurationMinute = durationMinutes,
ContentTitle = contentTitle
};
studyHistoryDB.StudyHistoryItems.InsertOnSubmit(itemToFind);
}
else
{
itemToFind.DurationMinute += durationMinutes;
}
studyHistoryDB.SubmitChanges();
}
public static void DeleteAllEntries()
{
StudyHistoryDataContext studyHistoryDB = new StudyHistoryDataContext(StudyHistoryDataContext.DBConnectionString);
studyHistoryDB.StudyHistoryItems.DeleteAllOnSubmit(studyHistoryDB.StudyHistoryItems);
studyHistoryDB.SubmitChanges();
}
