Esempio n. 1
0
        private LiveEntry GetEntry()
        {
            LiveEntry query = (from row in livedb.entry where row.key == "mainkey" select row).SingleOrDefault();
            if (query == null)
            {
                LiveEntry first = new LiveEntry();
                first.date = "00.00.1234";
                first.timein = "00:00";
                first.timeout = "00:00";
                first.lunchin = "00:00";
                first.lunchout = "00:00";
                first.state = 0;
                first.key = "mainkey";

                livedb.entry.InsertOnSubmit(first);
                livedb.SubmitChanges();

                query = (from row in livedb.entry where row.key == "mainkey" select row).SingleOrDefault();
            }

            return query;
        }
Esempio n. 2
0
 private void UpdateLiveDB(LiveEntry entry)
 {
     LiveEntry query = (from row in livedb.entry where row.key == "mainkey" select row).SingleOrDefault();
     query = entry;
     livedb.SubmitChanges();
 }