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