private void addQuestionButton_Click(object sender, EventArgs e) { if (questionTbox.Text != null && questionTbox.Text != "" && replyTBox.Text != "" && replyTBox.Text != null && categoryTypeCombo.SelectedItem != null && replyTBox1.Text != "" && replyTBox1.Text != null && replyTBox2.Text != "" && replyTBox2.Text != null && replyTBox3.Text != "" && replyTBox3.Text != null && replyTBox4.Text != "" && replyTBox4.Text != null && validationReturn()) { questionName = DateTime.Now.ToString().Trim().Replace(" ", string.Empty).Trim().Replace(":", string.Empty).Trim().Replace("/", string.Empty); Classes.questionClass ques = new Classes.questionClass(); if (oldFileLoc != "") { File.Copy(oldFileLoc, @"images\\" + questionName + ".jpg"); } questionTbox.SaveFile(@"question\\" + questionName + ".rtf"); //soru oluşturma question newQuest = new question(); newQuest.questionText = questionTbox.Text; newQuest.questionName = questionName; newQuest.reply = replyTBox.Text; newQuest.reply1 = replyTBox1.Text; newQuest.reply2 = replyTBox2.Text; newQuest.reply3 = replyTBox3.Text; newQuest.reply4 = replyTBox4.Text; newQuest.categoryID = (int)categoryTypeCombo.SelectedValue; bool ret = quizOP.addQuestion(newQuest); if (ret) { MessageBox.Show("Sorunuz başarılı bir şekilde eklendi."); qListe(); clearForms(); } } else { MessageBox.Show("Lütfen bilgileri doğru ve eksiksiz giriniz."); } }
public List <questionClass> getQuestion(string searchType, int catID, int questRate) { List <questionClass> questions = new List <questionClass>(); try { mainConnect(); MySqlCommand qSearchCommand = new MySqlCommand(); if (searchType != null) { qSearchCommand = new MySqlCommand("Select * from question WHERE categoryID='" + catID + "'" + " ORDER BY RAND() LIMIT " + (questRate * 2).ToString(), mainDatabeseConn); } else { qSearchCommand = new MySqlCommand("Select * from question", mainDatabeseConn); } MySqlDataReader reader = qSearchCommand.ExecuteReader(); while (reader.Read()) { questionClass quest = new questionClass(); quest.id = reader.GetInt32("id"); quest.quesText = reader.GetString("questionText").Trim().Replace("\n", " "); quest.quesName = reader.GetString("questionName"); quest.reply = reader.GetString("reply"); quest.reply1 = reader.GetString("reply1"); quest.reply2 = reader.GetString("reply2"); quest.reply3 = reader.GetString("reply3"); quest.reply4 = reader.GetString("reply4"); quest.cat = reader.GetInt32("categoryID"); questions.Add(quest); } mainConnect(); } catch (Exception e) { MessageBox.Show("İşlem sırasında bir hata meydana geldi." + e); mainConnect(); } return(questions); }