Exemplo n.º 1
0
        private void listBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            var driver = listBox.SelectedItem;

            selectedQueTxtBx.Text = driver.ToString();
            DriverName            = selectedQueTxtBx.Text;

            var query1 = conn.Table <TransactionsTable>().Where(t => t.UserName == usr);
            int k      = 0;

            foreach (var item1 in query1)
            {
                k = item1.ID;
            }

            // var query3 = conn.Table<CarTable>().Where(t => t.Availability == "A" && t.RegistrationNumber == j);

            var    query2 = conn.Table <DriverTable>().Where(t => t.DUserName == DriverName);
            string j      = "";

            foreach (var item4 in query2)
            {
                j = item4.DFirstName;
            }

            // Debug.WriteLine("tRANSACTIONStABLEcOUNT = " + k);
            conn.Execute("UPDATE TransactionsTable SET DriverID = ? Where ID = ?", DriverName.ToString(), k);
            conn.Execute("UPDATE TransactionsTable SET DriverName = ? Where ID = ?", j, k);
            //  conn.Execute("UPDATE TransactionsTable SET CabID = ? Where ID = ?", j, k);
            //edit2
            conn.Execute("UPDATE DriverTable SET DAvailabilityFlag= ? Where DUserName = ?", "Bb", DriverName.ToString());

            this.Frame.Navigate(typeof(PaymentPage), k);
        }
Exemplo n.º 2
0
 private void SaveButtonExecute()
 {
     update();
     Database.Execute(string.Format("UPDATE WorkerScheduleTable SET BeginHour='{0}' WHERE Id = {1};", SelectedWorkerSchedule.Start_hour, SelectedWorkerSchedule.Id));
     Database.Execute(string.Format("UPDATE WorkerScheduleTable SET EndHour='{0}' WHERE Id = {1};", SelectedWorkerSchedule.End_hour, SelectedWorkerSchedule.Id));
     Database.Execute(string.Format("UPDATE WorkerScheduleTable SET Color='{0}' WHERE Id = {1};", SelectedWorkerSchedule.Color, SelectedWorkerSchedule.Id));
     Database.Execute(string.Format("UPDATE WorkerScheduleTable SET Output='{0}' WHERE Id = {1};", SelectedWorkerSchedule.Output, SelectedWorkerSchedule.Id));
 }
        private async void buttonAvailable_Click(object sender, RoutedEventArgs e)
        {
            //var query2 = conn.Table<DriverTable>().Where(t => t.DUserName == dristr);
            var query3 = conn.Table <TransactionsTable>().Where(t => t.DriverId == dristr);

            foreach (var ite in query3)
            {
                cab = ite.CabID;
                conn.Execute("UPDATE CarTable SET Availability= ? Where RegistrationNumber = ?", "A", cab);
            }
            conn.Execute("UPDATE DriverTable SET DAvailabilityFlag= ? Where DUserName = ?", "Aa", dristr);
            MessageDialog md1 = new MessageDialog("Made Available!");
            await md1.ShowAsync();
        }
Exemplo n.º 4
0
 private void SubmitButton_Click(object sender, RoutedEventArgs e)
 {
     /*
      *  IDS will contain category id, item id and 1/0. IDS[0] = category Id. IDS[1] = item id. IDS[2] = 1/0.
      */
     conn.Execute("UPDATE Item SET Available = 0");
     string[] IDS;
     foreach (var item in AvailableItem)
     {
         IDS = item.Split('_');
         conn.Execute("UPDATE Item SET Available = 1 WHERE CategoryId = " + IDS[0] + " AND Id = " + IDS[1]);
         Debug.WriteLine(IDS[0] + " " + IDS[1]);
     }
 }
Exemplo n.º 5
0
        public void Salvar()
        {
            using (var db = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.XamarinAndroid.SQLitePlatformAndroid(), _caminhoBanco, storeDateTimeAsTicks: false))
            {
                db.Execute("DELETE FROM Estabelecimento");
                db.InsertAll(Estabelecimentos);

                db.Execute("DELETE FROM Gasto");
                foreach (var gasto in Gastos)
                {
                    gasto.EstabelecimentoId = gasto.Estabelecimento.Id;
                }
                db.InsertAll(Gastos);
            }
        }
Exemplo n.º 6
0
        //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);
        }
Exemplo n.º 7
0
        private async void deleteDriverAdminBtn_Click(object sender, RoutedEventArgs e)
        {
            if (dristr == "")
            {
                MessageDialog showDialog = new MessageDialog("");
                showDialog.Content = "Please Select the User to Delete.";
                await showDialog.ShowAsync();
            }

            var query = conn.Execute("DELETE From UserTable  Where UserName = ?", dristr);

            if (query != 0)
            {
                //Debug.WriteLine(query.ToString());
                MessageDialog showDialog1 = new MessageDialog("");
                showDialog1.Content = "User Details Deleted";
                await showDialog1.ShowAsync();
            }
            if (query == 0 && dristr != "")
            {
                MessageDialog showDialog2 = new MessageDialog("");
                showDialog2.Content = "User Not Existed";
                await showDialog2.ShowAsync();
            }
        }
Exemplo n.º 8
0
        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();
                }
            }
        }
Exemplo n.º 9
0
        private async void CropperDialogPrimaryButton_Click(object sender, RoutedEventArgs e)
        {
            var imageSource = EditPicture.ProfilePicture;

            byte[] imageBuffer;
            var    localFolder = Windows.Storage.ApplicationData.Current.LocalFolder;
            var    file        = await localFolder.CreateFileAsync("temp.jpg", CreationCollisionOption.ReplaceExisting);

            try
            {
                using (var ras = await file.OpenAsync(FileAccessMode.ReadWrite, StorageOpenOptions.None))
                {
                    WriteableBitmap bitmap = imageSource as WriteableBitmap;
                    var             stream = bitmap.PixelBuffer.AsStream();
                    byte[]          buffer = new byte[stream.Length];
                    await stream.ReadAsync(buffer, 0, buffer.Length);

                    BitmapEncoder encoder = await BitmapEncoder.CreateAsync(BitmapEncoder.JpegEncoderId, ras);

                    encoder.SetPixelData(BitmapPixelFormat.Bgra8, BitmapAlphaMode.Ignore, (uint)bitmap.PixelWidth, (uint)bitmap.PixelHeight, 96.0, 96.0, buffer);
                    await encoder.FlushAsync();

                    var imageStream = ras.AsStream();
                    imageStream.Seek(0, SeekOrigin.Begin);
                    imageBuffer = new byte[imageStream.Length];
                    var re = await imageStream.ReadAsync(imageBuffer, 0, imageBuffer.Length);
                }
                await file.DeleteAsync(StorageDeleteOption.Default);

                List <PersonPictures> datalist = conn.Query <PersonPictures>("select * from PersonPictures where pictureName = ?", "picture");
                if (datalist != null)
                {
                    conn.Execute("delete from PersonPictures where pictureName = ?", "picture");
                }
                conn.Insert(new PersonPictures()
                {
                    pictureName = "picture", picture = imageBuffer
                });
                SetPersonPicture();
                PopupNotice popupNotice = new PopupNotice("头像已更新");
                popupNotice.ShowAPopup();
            }
            catch
            {
                TempPicture.Visibility = Visibility.Visible;
                EditPicture.Visibility = Visibility.Collapsed;
            };
            CropperDialog.Hide();
        }
Exemplo n.º 10
0
 protected override void OnNavigatedTo(NavigationEventArgs e)
 {
     base.OnNavigatedTo(e);
     if (e.GetType().ToString() == "int")
     {
         var query2 = conn.Table <TransactionsTable>().Where(t => ((t.ID == Convert.ToInt16(usrnm.ToString()))));
         foreach (var item in query2)
         {
             usrnm = item.UserName;
         }
         Debug.WriteLine(usrnm);
         Debug.WriteLine(query2);
         conn.Execute("UPDATE TransactionsTable SET UserName = ? Where ID= ?", usrnm, Convert.ToInt32(e.Parameter.ToString()));
     }
     else
     {
         usrnm = e.Parameter.ToString();
     }
 }
Exemplo n.º 11
0
 private static void ExcluirDeputadoFrenquencia(string IdParlamentar)
 {
     using (SQLite.Net.SQLiteConnection conexao = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), App.DB_PATH))
     {
         for (int i = 0; i <= 10; i++)
         {
             try
             {
                 conexao.Execute("delete from DeputadoFrenquencia where IdParlamentar =" + "\"" + IdParlamentar + "\"");
                 break;
             }
             catch
             {
                 Task.Delay(5000);
                 continue;
             }
         }
     }
 }
Exemplo n.º 12
0
 private static void ExcluirDeputadoPorEstado(string uf)
 {
     using (SQLite.Net.SQLiteConnection conexao = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), App.DB_PATH))
     {
         for (int i = 0; i <= 10; i++)
         {
             try
             {
                 conexao.Execute("delete from Deputado where Uf =" + "\"" + uf + "\"");
                 break;
             }
             catch
             {
                 Task.Delay(10000);
                 break;
             }
         }
     }
 }
Exemplo n.º 13
0
 private static void ExcluirGastoTipoPorDeputado(string idDeputado)
 {
     using (SQLite.Net.SQLiteConnection conexao = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), App.DB_PATH))
     {
         for (int i = 0; i <= 10; i++)
         {
             try
             {
                 conexao.Execute("delete from GastoTipo where idDeputado =" + "\"" + idDeputado + "\"");
                 break;
             }
             catch
             {
                 Task.Delay(5000);
                 continue;
             }
         }
     }
 }
Exemplo n.º 14
0
 private static void ExcluirGastoAnoPorDeputado(string idDeputado, string ano)
 {
     using (SQLite.Net.SQLiteConnection conexao = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), App.DB_PATH))
     {
         for (int i = 0; i <= 10; i++)
         {
             try
             {
                 conexao.Execute(
                     String.Format("delete from GastosAno where idDeputado = {0} and Ano = {1}", "\"" + idDeputado + "\"", "\"" + ano + "\""));
                 break;
             }
             catch
             {
                 Task.Delay(15000);
                 continue;
             }
         }
     }
 }
Exemplo n.º 15
0
 private void AddTaskButton_Click(object sender, RoutedEventArgs e)
 {
     if (TaskNameTextBox.Text.Equals(""))
     {
         PopupNotice popupNotice = new PopupNotice("计划名称不能为空~");
         popupNotice.ShowAPopup();
     }
     else
     {
         List <ToDoTasks> tempList = conn.Query <ToDoTasks>("select * from ToDoTasks where Name = ?", TaskNameTextBox.Text);
         if (tempList.Count != 0)
         {
             if (tempList[0].IsDelete.Equals("1"))
             {
                 conn.Execute("update ToDoTasks set Name = ?, Date = ?, Star = ?, Remark = ?, Done = ?, UpdateTime = ?, IsDelete = ?  where TaskId = ?",
                              TaskNameTextBox.Text, "", "0", "", "0", DateTime.Now.ToString(), "0", tempList[0].TaskId);
                 ToDoTaskViewModel1.ToDoDatas.Add(new ToDoTasks()
                 {
                     TaskId = tempList[0].TaskId, Name = TaskNameTextBox.Text, Date = "", Remark = "", UpdateTime = DateTime.Now.ToString(), StarVisibility = Visibility.Collapsed, DateVisibility = Visibility.Collapsed, RemarkVisibility = Visibility.Collapsed
                 });
             }
             else
             {
                 PopupNotice popupNotice0 = new PopupNotice("请勿重复添加计划");
                 popupNotice0.ShowAPopup();
             }
         }
         else
         {
             string uuid = Guid.NewGuid().ToString();
             conn.Insert(new ToDoTasks()
             {
                 TaskId = uuid, Name = TaskNameTextBox.Text, Date = "", Star = "0", Remark = "", Done = "0", UpdateTime = DateTime.Now.ToString(), IsDelete = "0"
             });
             ToDoTaskViewModel1.ToDoDatas.Add(new ToDoTasks()
             {
                 TaskId = uuid, Name = TaskNameTextBox.Text, Date = "", Remark = "", UpdateTime = DateTime.Now.ToString(), StarVisibility = Visibility.Collapsed, DateVisibility = Visibility.Collapsed, RemarkVisibility = Visibility.Collapsed
             });
         }
         PopupNotice popupNotice = new PopupNotice("添加成功");
         popupNotice.ShowAPopup();
         TaskNameTextBox.Text = "";
     }
 }
 private void DeleteContact(object sender, RoutedEventArgs e)
 {
     connect.Execute("DELETE FROM Contact");
 }
Exemplo n.º 17
0
        private async void radioButton_Checked(object sender, RoutedEventArgs e)
        {
            int rating = 1;

            if (radioButton.IsChecked == true)
            {
                rating = 1;
            }
            var    query1 = conn.Table <TransactionsTable>().Where(t => t.ID == k1);
            int    k      = 0;
            string st     = "";
            string st2    = "";

            foreach (var item1 in query1)
            {
                k   = item1.ID;
                st  = item1.DriverId;
                st2 = item1.CabID;
            }

            conn.Execute("UPDATE TransactionsTable SET DriverRating = ? Where ID = ?", rating, k);
            conn.Execute("UPDATE DriverTable SET DRating = ? Where DUserName = ?", 1, st);
            conn.Execute("UPDATE DriverTable SET DAvailabilityFlag = ? Where DUserName = ?", "Aa", st);
            conn.Execute("UPDATE CarTable SET Availability = ? Where RegistrationNumber = ?", "A", st2);
            var message = new MessageDialog("Driver Rated!");
            await message.ShowAsync();

            this.Frame.Navigate(typeof(MainPage1), k);
        }
Exemplo n.º 18
0
        //private void element_PointerExited(object sender, PointerRoutedEventArgs e)
        //{
        //    // Scale back down to 1.0
        //    CreateOrUpdateSpringAnimation(1.0f);

        //    (sender as UIElement).StartAnimation(_springAnimation);
        //}


        private async void MyPersonPicture_Tapped(object sender, TappedRoutedEventArgs e)
        {
            var            srcImage   = new BitmapImage();
            FileOpenPicker openPicker = new FileOpenPicker();

            openPicker.ViewMode = PickerViewMode.Thumbnail;
            openPicker.SuggestedStartLocation = PickerLocationId.PicturesLibrary;
            openPicker.FileTypeFilter.Add(".jpg");
            openPicker.FileTypeFilter.Add(".jpeg");
            openPicker.FileTypeFilter.Add(".png");
            StorageFile file = await openPicker.PickSingleFileAsync();

            Picture_file = file;
            if (file != null)
            {
                using (IRandomAccessStream stream = await file.OpenAsync(FileAccessMode.Read))
                {
                    await srcImage.SetSourceAsync(stream);

                    await BitmapEncoder.CreateAsync(BitmapEncoder.JpegEncoderId, stream);
                }
            }
            if (file != null)
            {
                var inputFile   = SharedStorageAccessManager.AddFile(file);
                var destination = await ApplicationData.Current.LocalFolder.CreateFileAsync("Cropped.jpg", CreationCollisionOption.ReplaceExisting);

                var destinationFile = SharedStorageAccessManager.AddFile(destination);
                var options         = new LauncherOptions();
                options.TargetApplicationPackageFamilyName = "Microsoft.Windows.Photos_8wekyb3d8bbwe";
                var parameters = new ValueSet();
                parameters.Add("InputToken", inputFile);
                parameters.Add("DestinationToken", destinationFile);
                parameters.Add("ShowCamera", false);
                parameters.Add("EllipticalCrop", true);
                parameters.Add("CropWidthPixals", 300);
                parameters.Add("CropHeightPixals", 300);
                var result = await Launcher.LaunchUriForResultsAsync(new Uri("microsoft.windows.photos.crop:"), options, parameters);

                if (result.Status.Equals(LaunchUriStatus.Success) && result.Result != null)
                {
                    try
                    {
                        var stream = await destination.OpenReadAsync();

                        var bitmap = new BitmapImage();
                        using (var dataRender = new DataReader(stream))
                        {
                            if (stream.Size == 0)
                            {
                                return;
                            }
                            var imgBytes = new byte[stream.Size];
                            await dataRender.LoadAsync((uint)stream.Size);

                            dataRender.ReadBytes(imgBytes);
                            List <PersonPictures> datalist = conn.Query <PersonPictures>("select * from PersonPictures where pictureName = ?", "picture");
                            if (datalist != null)
                            {
                                conn.Execute("delete from PersonPictures where pictureName = ?", "picture");
                            }
                            conn.Insert(new PersonPictures()
                            {
                                pictureName = "picture", picture = imgBytes
                            });
                            SetPersonPicture();
                        }
                        await localFolder.CreateFileAsync("PersonPicture", CreationCollisionOption.ReplaceExisting);
                    }
                    catch (Exception ex)
                    {
                        Debug.WriteLine(ex.Message + ex.StackTrace);
                    }
                }
            }
        }
Exemplo n.º 19
0
        private void SaveButtonExecute()
        {
            update();
            Database.Execute(string.Format("UPDATE ShiftTable SET Start_hour='{0}' WHERE ID = {1};", SelectedShift.Start_hour.ToString("c"), SelectedShift.Id));
            Database.Execute(string.Format("UPDATE ShiftTable SET End_hour='{0}' WHERE ID = {1};", SelectedShift.End_hour.ToString("c"), SelectedShift.Id));
            Database.Execute(string.Format("UPDATE ShiftTable SET Minwo='{0}' WHERE ID = {1};", SelectedShift.Min_workers, SelectedShift.Id));
            Database.Execute(string.Format("UPDATE ShiftTable SET Optwo='{0}' WHERE ID = {1};", SelectedShift.Opt_workers, SelectedShift.Id));
            if (SelectedShift.Opening_Day[0].IsOpen == true)
            {
                Database.Execute(string.Format("UPDATE ShiftTable SET mon = 1 WHERE ID = {0};", SelectedShift.Id));
            }
            else
            {
                Database.Execute(string.Format("UPDATE ShiftTable SET mon = 0 WHERE ID = {0};", SelectedShift.Id));
            }

            if (SelectedShift.Opening_Day[1].IsOpen == true)
            {
                Database.Execute(string.Format("UPDATE ShiftTable SET tue = 1 WHERE ID = {0};", SelectedShift.Id));
            }
            else
            {
                Database.Execute(string.Format("UPDATE ShiftTable SET tue = 0 WHERE ID = {0};", SelectedShift.Id));
            }
            if (SelectedShift.Opening_Day[2].IsOpen == true)
            {
                Database.Execute(string.Format("UPDATE ShiftTable SET wed = 1 WHERE ID = {0};", SelectedShift.Id));
            }
            else
            {
                Database.Execute(string.Format("UPDATE ShiftTable SET wed = 0 WHERE ID = {0};", SelectedShift.Id));
            }
            if (SelectedShift.Opening_Day[3].IsOpen == true)
            {
                Database.Execute(string.Format("UPDATE ShiftTable SET thu = 1 WHERE ID = {0};", SelectedShift.Id));
            }
            else
            {
                Database.Execute(string.Format("UPDATE ShiftTable SET thu = 0 WHERE ID = {0};", SelectedShift.Id));
            }
            if (SelectedShift.Opening_Day[4].IsOpen == true)
            {
                Database.Execute(string.Format("UPDATE ShiftTable SET fri = 1 WHERE ID = {0};", SelectedShift.Id));
            }
            else
            {
                Database.Execute(string.Format("UPDATE ShiftTable SET fri = 0 WHERE ID = {0};", SelectedShift.Id));
            }
            if (SelectedShift.Opening_Day[5].IsOpen == true)
            {
                Database.Execute(string.Format("UPDATE ShiftTable SET sat = 1 WHERE ID = {0};", SelectedShift.Id));
            }
            else
            {
                Database.Execute(string.Format("UPDATE ShiftTable SET sat = 0 WHERE ID = {0};", SelectedShift.Id));
            }
            if (SelectedShift.Opening_Day[6].IsOpen == true)
            {
                Database.Execute(string.Format("UPDATE ShiftTable SET sun = 1 WHERE ID = {0};", SelectedShift.Id));
            }
            else
            {
                Database.Execute(string.Format("UPDATE ShiftTable SET sun = 0 WHERE ID = {0};", SelectedShift.Id));
            }
        }
Exemplo n.º 20
0
 private void SaveButtonExecute()
 {
     update();
     Database.Execute(string.Format("UPDATE WorkerTable SET Firstname='{0}' WHERE ID = {1};", SelectedWorker.First_name, SelectedWorker.Id));
     Database.Execute(string.Format("UPDATE WorkerTable SET Lastname='{0}' WHERE ID = {1};", SelectedWorker.Last_name, SelectedWorker.Id));
 }
Exemplo n.º 21
0
 private void DeleteContact(object sender, RoutedEventArgs e)
 {
     connect.Execute("DELETE FROM Contact");
     Comment.Text = "Đã xóa tất cả contact";
 }