public static IEnumerable <RecordModel> GetRecords() { TimeTrackerDataContext dc = new TimeTrackerDataContext(); var data = from r in dc.Records select new RecordModel(r.AppName, r.StartTime, r.EndTime, r.ID); return(data.AsEnumerable()); }
public static void UpdateRecord(RecordModel record) { TimeTrackerDataContext dc = new TimeTrackerDataContext(); var dane = from r in dc.Records where (r.ID == record.Id) select r; var dbRecord = dane.First(); dbRecord.EndTime = record.EndTime; dc.SubmitChanges(); }
public static void AddRecord(ref RecordModel record) { TimeTrackerDataContext dc = new TimeTrackerDataContext(); Record dbRecord = new Record { AppName = record.AppName, StartTime = record.StartTime, EndTime = record.EndTime }; int lastId = (from r in dc.Records orderby r.ID descending select r.ID).SingleOrDefault(); dbRecord.ID = lastId + 1; record.Id = dbRecord.ID; dc.Records.InsertOnSubmit(dbRecord); dc.SubmitChanges(); }