Exemple #1
0
        private void DeleteCardBtn_Click(object sender, EventArgs e)
        {
            if (CountFlashcards() == 1)
            {
                MessageForm errorForm = new MessageForm("You cannot have an empty set.");
                errorForm.Show();
            }
            else
            {
                Querey querey = new Querey();
                using (querey.connection = querey.NewConn)
                {
                    using (querey.command = querey.NewComm)
                    {
                        querey.command.CommandText = "DELETE FROM Flashcards WHERE Flashcards.Id = @flashId;";
                        querey.AddParameter("@flashId", currentCard.id);

                        querey.command.ExecuteNonQuery();
                    }
                }

                SaveChanges();
                queue.Dequeue();
                ChangeSetArray();
                PointerVal.Text = queue.Backwards().ToString();
                currentCard     = queue.Load();
                new MessageForm("deleted").Show();
            }
        }
Exemple #2
0
 private void BackwardsBtn_Click(object sender, EventArgs e)
 {
     currentCard.text1 = Text1.Text; // temporarily saves changes till user goes off set or goes onto the main menu
     currentCard.text2 = Text2.Text;
     PointerVal.Text   = queue.Backwards().ToString();
     currentCard       = queue.Load(); // updating card displayed
 }
Exemple #3
0
        private void NewCardBtn_Click(object sender, EventArgs e)
        {
            Querey querey = new Querey();

            if (CountFlashcards() == 64)
            {
                MessageForm errorForm = new MessageForm("You already have the maximum numbers of cards in this set.");
                errorForm.Show();
            }
            else
            {
                int flashId = 0;
                using (querey.connection = querey.NewConn)
                {
                    using (querey.command = querey.NewComm)
                    {
                        querey.command.CommandText = "INSERT INTO Flashcards (SetId, Text1, Text2) VALUES (@setId, @text1, @text2);";
                        querey.AddParameter("@setId", currentCard.setId);
                        querey.AddParameter("@text1", Text1.Text);
                        querey.AddParameter("@text2", Text2.Text);

                        querey.command.ExecuteNonQuery();
                    }

                    using (querey.command = querey.NewComm)
                    {
                        querey.command.CommandText = "SELECT Flashcards.Id FROM Flashcards WHERE SetId = @setId AND Text1 = @text1 AND Text2 = @text2;";
                        querey.AddParameter("@setId", currentCard.setId);
                        querey.AddParameter("@text1", Text1.Text);
                        querey.AddParameter("@text2", Text2.Text);

                        using (querey.reader = querey.command.ExecuteReader())
                        {
                            while (querey.reader.Read())
                            {
                                flashId = querey.reader.GetInt32(0);
                            }
                        }
                    }
                }
                SaveChanges();
                new MessageForm("insertion successful").Show();
                queue.Enqueue(new Flashcard(flashId, currentCard.setId, Text1.Text, Text2.Text));
                PointerVal.Text = queue.Forwards().ToString();
                currentCard     = queue.Load();
                ChangeSetArray();
            }
        }
Exemple #4
0
        public Set(int id, int ownerId, string setName, string title1, string title2)
        {
            _id        = id;
            _ownerId   = ownerId;
            _setName   = setName;
            _title1    = title1;
            _title2    = title2;
            _querey    = new Querey();
            _strengths = new double[] { 2.10, 3.48, 13.63, 59.16, 104.30, 153.92, 209.57, 313.04, 417.10, 521.39, 625.55 };

            using (_querey.connection = _querey.NewConn)
            {
                using (_querey.command = _querey.NewComm)
                {
                    _querey.command.CommandText = "SELECT count(SetId) FROM Flashcards WHERE SetId = @setid;";
                    _querey.AddParameter("@setid", _id);
                    int length = Convert.ToInt32(_querey.command.ExecuteScalar());
                    _flashcards = new Flashcard[length];
                }

                using (_querey.command = _querey.NewComm)
                {
                    _querey.command.CommandText = "SELECT Flashcards.Id, Flashcards.Text1, Flashcards.Text2 FROM Flashcards, Sets WHERE Flashcards.SetId = Sets.Id AND Flashcards.SetId = @id;";
                    _querey.AddParameter("@id", id);
                    using (_querey.reader = _querey.command.ExecuteReader())
                    {
                        int i = 0;
                        while (_querey.reader.Read())
                        {
                            _flashcards[i] = new Flashcard(_querey.reader.GetInt32(0), id, _querey.reader.GetString(1), _querey.reader.GetString(2));
                            i++;
                        }
                    }
                }
            }
        }
Exemple #5
0
 private void SelectSetBtn_Click(object sender, EventArgs e)
 {
     if (ChooseSet.Text == "")
     {
         MessageForm errorForm = new MessageForm("Please choose a set to edit");
     }
     else
     {
         for (int i = 0; i < _sets.Length; i++) // linear search
         {
             if (_sets[i].SetName == ChooseSet.Text)
             {
                 currentSet  = _sets[i];
                 queue       = new PartialQueue(_sets[i], Text1, Text2);
                 Title1.Text = _sets[i].Title1;
                 Title2.Text = _sets[i].Title2;
                 currentCard = queue.Load();
                 break;
             }
         }
         ChangeEdit(true);
         PointerVal.Text = "1";
     }
 }
Exemple #6
0
        private void JumpBtn_Click(object sender, EventArgs e)
        {
            if (PointerInput.Text == "")
            {
                MessageForm errorForm = new MessageForm("Please enter which card you want to go to");
                errorForm.Show();
            }
            else if (int.Parse(PointerInput.Text) < 0 || int.Parse(PointerInput.Text) > queue.GetQueue.Length)
            {
                MessageForm errorForm = new MessageForm("Please enter a value within the range of your flashcards");
                errorForm.Show();
            }
            else if (queue.GetQueue[int.Parse(PointerInput.Text) - 1] == null)
            {
                MessageForm errorForm = new MessageForm("Your set does not have that many flashcards");
                errorForm.Show();
            }
            else
            {
                int  difference = int.Parse(PointerVal.Text) - int.Parse(PointerInput.Text);
                bool back       = false;
                if (difference < 0)
                {
                    difference = -difference;
                    back       = true;
                }

                for (int i = 0; i < difference; i++)
                {
                    PointerVal.Text = (back ? queue.Forwards() : queue.Backwards()).ToString();
                }

                currentCard = queue.Load();
            }
            PointerInput.Clear();
        }
Exemple #7
0
 public void Enqueue(Flashcard flashcard) // error handling occurs earlier on in add procedure
 {
     _queue[_back] = flashcard;
     _back++;
 }