コード例 #1
0
 private void ContentDialog_PrimaryButtonClick(ContentDialog sender, ContentDialogButtonClickEventArgs args)
 {
     //UPDATE
     updatedQuan = int.Parse(quantityTextBlock.Text);
     using (SqlConnection myConnection = new SqlConnection(Globals.SQL_DATA_CONNECTION))
     {
         SqlCommand cmd = new SqlCommand("updateQuan", myConnection)
         {
             CommandType = CommandType.StoredProcedure
         };
         cmd.Parameters.Add(new SqlParameter("@upcInput", ean));
         cmd.Parameters.Add(new SqlParameter("@userID", Globals.uid));
         cmd.Parameters.Add(new SqlParameter("@theQuan", updatedQuan));
         myConnection.Open();
         int rowAffected = cmd.ExecuteNonQuery();
         if (rowAffected == 1)
         {
             myConnection.Close();
         }
         else
         {
             myConnection.Close();
         }
     }
     Globals.SHOPPING_LIST_ITEM_COUNT    = GenerateDashboard.GetShoppingListCount(Globals.uid);
     Globals.UNIQUE_INVENTORY_ITEM_COUNT = GenerateDashboard.GetUniqueItemCount(Globals.uid);
     Globals.INVENTORY_ITEM_COUNT        = GenerateDashboard.GetInventoryListCount(Globals.uid);
 }
コード例 #2
0
 private void ContentDialog_SecondaryButtonClick(ContentDialog sender, ContentDialogButtonClickEventArgs args)
 {
     //DELETE
     if (Globals.MOVE_TO_SHOPPING_LIST_ON_DELETE)
     {
         using (SqlConnection myConnection = new SqlConnection(Globals.SQL_DATA_CONNECTION))
         {
             SqlCommand cmd = new SqlCommand("sendToShoppingList", myConnection)
             {
                 CommandType = CommandType.StoredProcedure
             };
             cmd.Parameters.Add(new SqlParameter("@userID", Globals.uid));
             cmd.Parameters.Add(new SqlParameter("@ean", itemCopy.ean));
             cmd.Parameters.Add(new SqlParameter("@title", itemCopy.title));
             cmd.Parameters.Add(new SqlParameter("@upc", itemCopy.upc));
             cmd.Parameters.Add(new SqlParameter("@brand", itemCopy.brand));
             cmd.Parameters.Add(new SqlParameter("@model", itemCopy.model));
             cmd.Parameters.Add(new SqlParameter("@category", itemCopy.category));
             cmd.Parameters.Add(new SqlParameter("@imageurl", itemCopy.imageurl));
             myConnection.Open();
             int rowAffected = cmd.ExecuteNonQuery();
             if (rowAffected == 1)
             {
                 myConnection.Close();
             }
             else
             {
                 myConnection.Close();
             }
         }
         Globals.SHOPPING_LIST_ITEM_COUNT    = GenerateDashboard.GetShoppingListCount(Globals.uid);
         Globals.UNIQUE_INVENTORY_ITEM_COUNT = GenerateDashboard.GetUniqueItemCount(Globals.uid);
         Globals.INVENTORY_ITEM_COUNT        = GenerateDashboard.GetInventoryListCount(Globals.uid);
     }
     else
     {
         using (SqlConnection myConnection = new SqlConnection(Globals.SQL_DATA_CONNECTION))
         {
             SqlCommand cmd = new SqlCommand("deleteItem", myConnection)
             {
                 CommandType = CommandType.StoredProcedure
             };
             cmd.Parameters.Add(new SqlParameter("@upcInput", ean));
             cmd.Parameters.Add(new SqlParameter("@userID", Globals.uid));
             myConnection.Open();
             int rowAffected = cmd.ExecuteNonQuery();
             if (rowAffected == 1)
             {
                 myConnection.Close();
             }
             else
             {
                 myConnection.Close();
             }
         }
         Globals.UNIQUE_INVENTORY_ITEM_COUNT = GenerateDashboard.GetUniqueItemCount(Globals.uid);
         Globals.SHOPPING_LIST_ITEM_COUNT    = GenerateDashboard.GetShoppingListCount(Globals.uid);
         Globals.INVENTORY_ITEM_COUNT        = GenerateDashboard.GetInventoryListCount(Globals.uid);
     }
 }
コード例 #3
0
        private void SignInButton_Click(object sender, RoutedEventArgs e)
        {
            if (emailTextField.Text == "" || passwordTextField.Password == "")
            {
                Msgbox.Show("Please enter email, and password");
            }
            else
            {
                using (SqlConnection myConnection = new SqlConnection(Globals.SQL_DATA_CONNECTION))
                {
                    string     oString = $"SELECT (SELECT UserID FROM Users WHERE email = '{emailTextField.Text}' AND password='******')";
                    SqlCommand oCmd    = new SqlCommand(oString, myConnection);
                    myConnection.Open();
                    using (SqlDataReader oReader = oCmd.ExecuteReader())
                    {
                        while (oReader.Read())
                        {
                            try
                            {
                                Globals.uid = (string)oReader.GetValue(0);

                                //emailTextField.Text = Globals.uid;
                                emailTextField.Text        = "";
                                passwordTextField.Password = "";

                                Globals.UNIQUE_INVENTORY_ITEM_COUNT = GenerateDashboard.GetUniqueItemCount(Globals.uid);
                                Globals.SHOPPING_LIST_ITEM_COUNT    = GenerateDashboard.GetShoppingListCount(Globals.uid);
                                Globals.INVENTORY_ITEM_COUNT        = GenerateDashboard.GetInventoryListCount(Globals.uid);

                                Frame.Navigate(typeof(WelcomePage));
                            }
                            catch (InvalidCastException)
                            {
                                Msgbox.Show("Login credentials invalid. Please try again.");
                                emailTextField.Text        = string.Empty;
                                passwordTextField.Password = string.Empty;
                                //throw theException;
                            }
                        }
                    }
                }
            }
        }