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(); }
private void Insert_Click(object sender, EventArgs e) // inserts set into database and then updates cloud { Querey getSetId = new Querey(); bool used; using (getSetId.connection = getSetId.NewConn) { using (getSetId.command = getSetId.NewComm) { SetIdCommand(getSetId); using (getSetId.reader = getSetId.command.ExecuteReader()) { used = getSetId.reader.Read(); } } } if (SetName.Text == "") { MessageForm errorForm = new MessageForm("Please enter a set name."); errorForm.Show(); } else if (!used) { if (Title1.Text == "" || Title2.Text == "") { MessageForm errorForm = new MessageForm("Please enter titles for your sets."); errorForm.Show(); } else { Querey insert = new Querey(); using (insert.connection = insert.NewConn) { using (insert.command = insert.NewComm) { insert.command.CommandText = "INSERT INTO Sets (OwnerId, SetName, Title1, Title2) VALUES (@owner, @name, @title1, @title2);"; insert.AddParameter("@owner", _userId); insert.AddParameter("@name", SetName.Text); insert.AddParameter("@title1", Title1.Text); insert.AddParameter("@title2", Title2.Text); if (insert.connection.State != ConnectionState.Open) { insert.connection.Open(); } insert.command.ExecuteNonQuery(); insert.Close(); } } getSetId = new Querey(); int setId; using (getSetId.connection = getSetId.NewConn) { using (getSetId.command = getSetId.NewComm) { SetIdCommand(getSetId); using (getSetId.reader = getSetId.command.ExecuteReader()) { getSetId.reader.Read(); setId = getSetId.reader.GetInt32(0); } } } insert = new Querey(); using (insert.connection = insert.NewConn) { int count = 0; while (count < 64 && _data[count, 0] != null) { using (insert.command = insert.NewComm) { insert.command.CommandText = "INSERT INTO Flashcards (SetId, Text1, Text2) VALUES (@setId, @text1, @text2);"; insert.AddParameter("@setId", setId); insert.AddParameter("@text1", _data[count, 0]); insert.AddParameter("@text2", _data[count, 1]); insert.command.ExecuteNonQuery(); count++; } } string[] tables = { "Permissions", "SetProgress" }; // done this way to allow easier error checking and make queries more readable for (int i = 0; i < tables.Length; i++) { using (insert.command = insert.NewComm) { if (_student != null) { insert.command.CommandText = "INSERT INTO " + tables[i] + " (UserId, SetId) SELECT Users.Id, Sets.Id FROM Users, Sets, Friends WHERE Student1 = @id AND Sets.Id = @setId AND Sets.OwnerId = Student1 AND Users.Id = Student2 OR Student2 = @id AND Sets.Id = @setId AND Sets.OwnerId = Student2 AND Users.Id = Student1;"; } else { insert.command.CommandText = "INSERT INTO " + tables[i] + " (UserId, SetId) SELECT Users.Id, Sets.Id FROM Users, Sets, TeacherStudent WHERE TeacherId = @id AND Sets.Id = @setId AND Sets.OwnerId = TeacherId AND Users.Id = StudentId;"; } insert.AddParameter("@id", _userId); insert.AddParameter("@setId", setId); insert.command.ExecuteNonQuery(); new MessageForm("inserted").Show(); } } using (insert.command = insert.NewComm) { insert.command.CommandText = "INSERT INTO SetProgress (UserId, SetId) SELECT OwnerId, Id FROM Sets WHERE id = @setId;"; insert.AddParameter("setId", setId); insert.command.ExecuteNonQuery(); } using (insert.command = insert.NewComm) { double initialStrength = 2.10; insert.command.CommandText = "UPDATE SetProgress SET LastReview = @now, Strength = @strength WHERE SetId = @set;"; insert.AddParameter("@now", DateTime.Now.ToString()); insert.AddParameter("@strength", initialStrength); insert.AddParameter("@set", setId); insert.command.ExecuteNonQuery(); } } GDrive drive = new GDrive(); drive.UploadDatabase(); ConfirmMsg.Enabled = false; OpenFile.Reset(); SetName.Clear(); Title1.Clear(); Title2.Clear(); OpenFile.Reset(); FileName.Text = ""; } } else { MessageForm errorForm = new MessageForm("This set name has already been used. Please choose a different one."); errorForm.Show(); } }
private void Fail(string errorMsg) { MessageForm errorForm = new MessageForm(errorMsg); errorForm.Show(); }
private void button1_Click(object sender, EventArgs e) { bool success = false; Querey getUserDetails = new Querey(); using (getUserDetails.connection = getUserDetails.NewConn) { using (getUserDetails.command = getUserDetails.NewComm) { getUserDetails.command.CommandText = "SELECT Id, Email, Firstname, Secondname, Password, Teacher FROM Users WHERE Email LIKE @email AND Password = @pass;"; Encrypt encrypt = new Encrypt(Password.Text); getUserDetails.AddParameter("@email", Email.Text); getUserDetails.AddParameter("@pass", encrypt.Hashed); getUserDetails.reader = getUserDetails.command.ExecuteReader(); using (getUserDetails.reader) { if (getUserDetails.reader.Read()) // getting user details { id = getUserDetails.reader.GetInt32(0); email = getUserDetails.reader.GetString(1); firstName = getUserDetails.reader.GetString(2); lastName = getUserDetails.reader.GetString(3); password = getUserDetails.reader.GetString(4); teacher = (getUserDetails.reader.GetString(5) == "1"); // if the value stored is 1 then teacher will be set to true success = true; } } } } if (!success) { MessageForm errorForm = new MessageForm("Username or password is incorrect"); errorForm.Show(); } else { List <int> ids = new List <int> { }; Querey getIds = new Querey(); using (getIds.connection = getIds.NewConn) { using (getIds.command = getIds.NewComm) { if (teacher) { getIds.command.CommandText = "SELECT StudentId FROM TeacherStudent, Users WHERE TeacherId = Users.Id AND TeacherId = @id"; getIds.AddParameter("@id", id); getIds.reader = getIds.command.ExecuteReader(); using (getIds.reader) { while (getIds.reader.Read()) { ids.Add(getIds.reader.GetInt32(0)); MessageForm errorForm = new MessageForm(getIds.reader.GetInt32(0).ToString()); errorForm.Show(); } } Teacher teacherAcc = new Teacher(id, email, firstName, lastName, ids); new TeacherMainMenu(teacherAcc).Show(); this.Close(); } else { getIds.command.CommandText = "SELECT Student1 FROM Friends WHERE Student2 = @id;"; getIds.AddParameter("@id", id); getIds.reader = getIds.command.ExecuteReader(); using (getIds.reader) { while (getIds.reader.Read()) { ids.Add(getIds.reader.GetInt32(0)); } } getIds.command.CommandText = "SELECT Student2 FROM Friends WHERE Student1 = @id;"; getIds.AddParameter("@id", id); getIds.reader = getIds.command.ExecuteReader(); using (getIds.reader) { while (getIds.reader.Read()) { ids.Add(getIds.reader.GetInt32(0)); } } Student studentAcc = new Student(id, email, firstName, lastName, ids); StudentMainMenu studentMainMenu = new StudentMainMenu(studentAcc); studentMainMenu.Show(); this.Close(); } } } } }