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;
        }
Exemplo n.º 3
0
        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();
            }
        }
Exemplo n.º 4
0
        /// <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;
            }
        }
Exemplo n.º 5
0
        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++;
            }
        }