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