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(); }