public IList<DictionaryTable> GetAllDictionary()
{
IList<DictionaryTable> list = null;
using (DataBaseContext context = new DataBaseContext(DataBaseContext.DBConnectionString))
{
IQueryable<DictionaryTable> query = from c in context.dnary select c;
list = query.ToList();
}
return list;
}
public IList<Data_Entries> GetAllDataEntries()
{
IList<Data_Entries> list = null;
using (DataBaseContext context = new DataBaseContext(DataBaseContext.DBConnectionString))
{
IQueryable<Data_Entries> query = from c in context.dataEntry select c;
list = query.ToList();
}
return list;
}
public void saveDictionary(Dnary dnary)
{
using (DataBaseContext context = new DataBaseContext(DataBaseContext.DBConnectionString))
{
DictionaryTable dT = new DictionaryTable();
dT.DataKey = dnary.DataKey;
//Debug.WriteLine("Dnary in DataBaseAdd.saveDictionary :"+ dnary.DataKey+","+ dnary.DataValue);
dT.value = dnary.DataValue;
dT.dataEntrydate = dnary.datetimeDataEntry;
dT.activity = dnary.activity;
//Debug.WriteLine("before insert on sumbit saveDictionary ");
context.dnary.InsertOnSubmit(dT);
//Debug.WriteLine("after insert on sumbit saveDictionary");
context.SubmitChanges();
}
}
/// <summary>
/// Constructor for the Application object.
/// </summary>
public App()
{
// Global handler for uncaught exceptions.
UnhandledException += Application_UnhandledException;
// Standard XAML initialization
InitializeComponent();
// Phone-specific initialization
InitializePhoneApplication();
// Language display initialization
InitializeLanguage();
using (DataBaseContext context = new DataBaseContext(DataBaseContext.DBConnectionString))
{
Debug.WriteLine("didn t entered context.create" );
if (!context.DatabaseExists())
{
Debug.WriteLine(" entered context.create ");
context.CreateDatabase();
}
}
// Show graphics profiling information while debugging.
if (Debugger.IsAttached)
{
// Display the current frame rate counters.
Application.Current.Host.Settings.EnableFrameRateCounter = true;
// Show the areas of the app that are being redrawn in each frame.
//Application.Current.Host.Settings.EnableRedrawRegions = true;
// Enable non-production analysis visualization mode,
// which shows areas of a page that are handed off to GPU with a colored overlay.
//Application.Current.Host.Settings.EnableCacheVisualization = true;
// Prevent the screen from turning off while under the debugger by disabling
// the application's idle detection.
// Caution:- Use this under debug mode only. Application that disables user idle detection will continue to run
// and consume battery power when the user is not using the phone.
PhoneApplicationService.Current.UserIdleDetectionMode = IdleDetectionMode.Disabled;
}
}
public void saveDataEntry(DataEntry dataE)
{
using (DataBaseContext context = new DataBaseContext(DataBaseContext.DBConnectionString))
{
Data_Entries de = new Data_Entries();
for(int i = 0; i < DataEntry.dictionaryList.Count; i++) {
//de.Data_entriesID = dataE.DataEntryID;
de.date_Time = dataE.dateTime;
de.activity = dataE.activity;
de.DataKey = DataEntry.dictionaryList.ElementAt<Dnary>(i).DataKey;
de.DataValue = DataEntry.dictionaryList.ElementAt<Dnary>(i).DataValue;
//Debug.WriteLine("before insert on sumbit saveDataEntr");
context.dataEntry.InsertOnSubmit(de);
}
//Debug.WriteLine("after insert on sumbit saveDataEntr");
context.SubmitChanges();
//dataE.DataEntryID++;
}
}