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