public static List<Sms> LoadData() { const string sConn = "Data Source=isostore:/HRDatabase.sdf"; using (var db = new HrContext(sConn)) { if (db.DatabaseExists() == false) { db.CreateDatabase(); db.SubmitChanges(); } Table<Sms> sms = db.GetTable<Sms>(); try { IEnumerator<Sms> enumEntity = sms.GetEnumerator(); } catch (Exception) { Debug.WriteLine("Got exception while asking for table enumerator. Table probably doesn't exist..."); db.DeleteDatabase(); db.CreateDatabase(); db.SubmitChanges(); Debug.WriteLine("Recreated database."); } IOrderedQueryable<Sms> listSms = (from s in db.Sms select s).OrderBy(s => s.Date); return listSms.ToList(); } }
public static void SaveData(Sms sms) { const string sConn = "Data Source=isostore:/HRDatabase.sdf"; using (var db = new HrContext(sConn)) { db.Sms.InsertOnSubmit(sms); db.SubmitChanges(); } }
public static void Update(Sms sms) { const string sConn = "Data Source=isostore:/HRDatabase.sdf"; using (var db = new HrContext(sConn)) { Sms updateSms = db.Sms.FirstOrDefault(s => s.Id == sms.Id); ScheduledActionService.Remove(updateSms.AlarmName); updateSms.AlarmName = sms.AlarmName; updateSms.Body = sms.Body; updateSms.Date = sms.Date; updateSms.Name = sms.Name; updateSms.Number = sms.Number; db.SubmitChanges(); } }
public static void Delete(int id) { const string sConn = "Data Source=isostore:/HRDatabase.sdf"; using (var db = new HrContext(sConn)) { Sms sms = db.Sms.FirstOrDefault(s => s.Id == id); ScheduledActionService.Remove(sms.AlarmName); db.Sms.DeleteOnSubmit(sms); db.SubmitChanges(); } }
public static void DeleteAll() { const string sConn = "Data Source=isostore:/HRDatabase.sdf"; using (var db = new HrContext(sConn)) { IQueryable<Sms> sms = from s in db.Sms select s; foreach (Sms alarm in sms) ScheduledActionService.Remove(alarm.AlarmName); db.Sms.DeleteAllOnSubmit(sms); db.SubmitChanges(); } }
public static Sms LoadSms(int id) { const string sConn = "Data Source=isostore:/HRDatabase.sdf"; using (var db = new HrContext(sConn)) { Sms sms = db.Sms.FirstOrDefault(s => s.Id == id); return sms; } }