//hien thi dialog ve nhan xet luon kalo da an
        private async void XongBtn_Click(object sender, RoutedEventArgs e)
        {
            if (kaloSum == 0)
            {
                var ms = new MessageDialog("Bạn nên chọn lượng Kcal nhập vào \nđể thống kê chính xác nhất");
                await ms.ShowAsync();

                return;
            }

            var msKalo = new MessageDialog("Tổng lượng Kcal bạn đã ăn là: " + kaloSum);
            await msKalo.ShowAsync();

            if (muctieu != null && thongkengay != null)
            {
                connection.Execute("DELETE FROM ThucDon WHERE IdThongKeNgay =?", thongkengay.IdThongKeNgay);
                //add cac thuc an da chon vao database
                foreach (var item in monanChonList)
                {
                    connection.Insert(item);
                }

                thongkengay.LuongKaloDuaVao = connection.ExecuteScalar <double>("SELECT SUM(LuongKalo) FROM THUCDON WHERE IdThongKeNgay =?", thongkengay.IdThongKeNgay);
                connection.Update(thongkengay);
            }


            Frame.Navigate(typeof(TrangChu), nguoidung);
        }
Exemple #2
0
        private int GetCount()
        {
            string dbFile = "Properties.db";

            try
            {
                var conn  = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.XamarinAndroid.SQLitePlatformAndroid(), dbPath + dbFile);
                var count = conn.ExecuteScalar <int>("SELECT Count(*) FROM Property");
                return(count);
            }
            catch (Exception ex) { return(-1); }
        }
Exemple #3
0
        private bool IsDuplicateName(string name)
        {
            string dbFile = "Properties.db";

            try
            {
                var conn  = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.XamarinAndroid.SQLitePlatformAndroid(), dbPath + dbFile);
                var count = conn.ExecuteScalar <int>("SELECT Count(*) FROM Property where name = '" + name + "'");
                if (count > 0)
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
            catch (Exception ex) { return(true); }
        }
        private void DelBtn_Click(object sender, EventArgs e)
        {
            AlertDialog.Builder alert = new AlertDialog.Builder(this.Context);
            alert.SetMessage("Do you want to remove this property?");
            alert.SetCancelable(false);
            alert.SetPositiveButton("Yes", delegate
            {
                string name = ((ImageView)sender).GetTag(Resource.Id.deleteProperty).ToString();

                try
                {
                    string dbPath = System.Environment.GetFolderPath(System.Environment.SpecialFolder.ApplicationData) + "//";
                    string dbFile = "Properties.db";
                    var conn      = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.XamarinAndroid.SQLitePlatformAndroid(), dbPath + dbFile);
                    int count     = conn.ExecuteScalar <int>("DELETE FROM Property where name='" + name + "'");
                    Toast.MakeText(this.Context, "Property " + name + " is deleted.", ToastLength.Short).Show();

                    DataList.Remove(DataList.Find(d => d.Name == name));
                    alert.Dispose();
                    NotifyDataSetChanged();

                    if (DataList == null || DataList.Count == 0)
                    {
                        var textView        = Context.FindViewById <TextView>(Resource.Id.NoPropSaved);
                        textView.Visibility = ViewStates.Visible;

                        var elv        = Context.FindViewById <ExpandableListView>(Resource.Id.elvSavedProperties);
                        elv.Visibility = ViewStates.Invisible;
                    }
                }
                catch (Exception ex)
                {
                    Toast.MakeText(this.Context, "Could not delete the property. Please try again.", ToastLength.Short).Show();
                }
            });

            alert.SetNegativeButton("No", delegate
            {
                alert.Dispose();
            });

            alert.Create().Show();
        }
        public void Migrate()
        {
            var database = DependencyService.Get <ISQLite> ();

            SQLite.Net.SQLiteConnection connection = null;

            if (!database.Exists())
            {
                connection = database.GetConnection();

                connection.BeginTransaction();
                connection.Execute(@"CREATE TABLE DBVersion (Version INT NOT NULL,
										ExecutionTime TEXT NOT NULL)"                                        );
                connection.Execute("INSERT INTO DBVersion (Version, ExecutionTime) VALUES (?,?)", new object[] { 0, DateTime.Now });
                connection.Commit();
            }

            if (connection == null)
            {
                connection = database.GetConnection();
            }

            foreach (var migration in Migrations)
            {
                int currentVersion = connection.ExecuteScalar <int> ("SELECT Version FROM DBVersion ORDER BY Version DESC LIMIT 1");

                if (migration.Key == (currentVersion + 1))
                {
                    connection.BeginTransaction();

                    foreach (var step in migration.Value)
                    {
                        connection.Execute(step);
                    }

                    connection.Execute("INSERT INTO DBVersion (Version, ExecutionTime) VALUES (?,?)", new object[] { migration.Key, DateTime.Now });
                    connection.Commit();
                }
            }
        }
        /// <summary>
        /// Khi người dùng tap vào một ngày, sẽ hiện ra thống kê cho ngày hôm đó
        /// </summary>
        private void Grid_Tapped(object sender, TappedRoutedEventArgs e)
        {
            thongkengayFlipView.Visibility = Visibility.Visible;
            btdetailStackPanel.Visibility  = Visibility.Collapsed;
            Initialize_Calendar(calendarDate);

            // change background of the grid that is tapped
            (sender as Grid).Background = new SolidColorBrush(Colors.LightSeaGreen);

            TextBlock textblock = (sender as Grid).Children[0] as TextBlock;

            // nếu ô trống thì bỏ qua
            if (textblock.Text == null || textblock.Text == "")
            {
                return;
            }

            string date = Int32.Parse(textblock.Text).ToString("00") + "/" + CalendarHeader.Tag.ToString(); /* dd/MM/yyyy */

            ngayTextBlock.Text = date;

            //DateTime date = DateTime.ParseExact(str, "dd/MM/yyyy", new CultureInfo("vi-vn"));
            ThongKeNgay tkn = connection.Table <ThongKeNgay>().Where(r => r.IdMucTieu == muctieu.IdMucTieu && r.Ngay == date).FirstOrDefault();

            if (tkn != null)
            {
                thongkeFlipView.Visibility = Visibility.Visible;
                muctieuTextBlock.Text      = tkn.IdMucTieu.ToString();
                kaloduavaoTextBlock.Text   = tkn.LuongKaloDuaVao.ToString();
                kalotieuhaoTextBlock.Text  = tkn.LuongKaloTieuHao.ToString();

                int soluongbaitap = connection.ExecuteScalar <int>("SELECT COUNT(*) FROM ThongKeBaiTap WHERE IdThongKeNgay =?", tkn.IdThongKeNgay);
                soluongbtTextBlock.Text = soluongbaitap.ToString();

                int tongthoigiantap = connection.ExecuteScalar <int>("SELECT SUM(ThoiGianTap) FROM THONGKEBAITAP WHERE IdThongKeNgay =?", tkn.IdThongKeNgay);
                thoigiantapTextBlock.Text = tongthoigiantap.ToString();

                var q = connection.Table <ThongKeBaiTap>().Where(r => r.IdThongKeNgay == tkn.IdThongKeNgay);
                List <BaiTapDaTap> baidatapList = new List <BaiTapDaTap>();
                foreach (var item in q)
                {
                    var tenbaitap = connection.Table <BaiTap>().Where(r => r.IdBaiTap == item.IdBaiTap).FirstOrDefault().TenBaiTap;
                    baidatapList.Add(new BaiTapDaTap()
                    {
                        IdThongKeBaiTap  = item.IdThongKeNgay,
                        IdThongKeNgay    = item.IdThongKeNgay,
                        IdBaiTap         = item.IdBaiTap,
                        TenBaiTap        = tenbaitap,
                        LuongKaloTieuHao = item.LuongKaloTieuHao,
                        QuangDuong       = item.QuangDuong,
                        ThoiGianTap      = item.ThoiGianTap
                    });
                }
                (PieChart.Series[0] as PieSeries).ItemsSource = baidatapList;
            }
            else
            {
                thongkengayFlipView.Visibility = Visibility.Collapsed;
                //kaloduavaoTextBlock.Text = "0";
                //kalotieuhaoTextBlock.Text = "0";
                //soluongbtTextBlock.Text = "0";
                //thoigiantapTextBlock.Text = "0";
            }
        }
Exemple #7
0
 private static int RowCount <T>(this SQLite.Net.SQLiteConnection connection)
 {
     //this could potentially create a new mapping if it doesn't exist in the connection already, alternative is to search
     //the TableMappings enumerable for an existing mapping but that would be slower
     return(connection.ExecuteScalar <int>(string.Format("select count(*) from {0}", connection.GetMapping <T>().TableName)));
 }
        /// <summary>
        /// Checks if the database exists, if not create one
        /// </summary>
        private void ChechIfDbExist()
        {
            var sqlpath = System.IO.Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "GameHistoryDB.sqlite"); //Path for the DB

            using (SQLite.Net.SQLiteConnection conn =
                new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), sqlpath))//The connection
            {
                var tableExistsQuery = "SELECT name FROM sqlite_master WHERE type='table' AND name='GameHistory'"; //SQL-Query
                var result = conn.ExecuteScalar<string>(tableExistsQuery);
                if (result == null)
                {
                    conn.CreateTable<GameHistory>();
                }
                connection = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), sqlpath);
            }
        }