private void SelectedItemFormStatistic(object sender, EventArgs e) { text020.Text = "" + 0; text2140.Text = "" + 0; text4160.Text = "" + 0; text6180.Text = "" + 0; text81100.Text = "" + 0; text100must.Text = "" + 0; MySqlConnection connection = MyMySQLConnection.ConnectionSingleton(); connection.Open(); Form form = StatisticFormList.SelectedItem as Form; List <Result> resultList = resultdata.GetListForForm(connection, form); StatisticResultList.ItemsSource = resultList; int number020 = 0; int number2140 = 0; int number4160 = 0; int number6180 = 0; int number81100 = 0; int number100m = 0; foreach (Result result in resultList) { int resultPoint = result.Point; if (resultPoint <= 20) { number020++; } else if (resultPoint <= 40) { number2140++; } else if (resultPoint <= 60) { number4160++; } else if (resultPoint <= 80) { number6180++; } else if (resultPoint <= 100) { number81100++; } else if (number100m <= 1000) { number100m++; } text020.Text = "" + number020; text2140.Text = "" + number2140; text4160.Text = "" + number4160; text6180.Text = "" + number6180; text81100.Text = "" + number81100; text100must.Text = "" + number100m; } connection.Close(); }
private void SearchDelete(object sender, EventArgs e) { MySqlConnection connection = MyMySQLConnection.ConnectionSingleton(); connection.Open(); string searchString = DeleteSearchBox.Text; string selectedColumnName = DeleteComboColumnBox.SelectedItem as string; string selectedTableData = DeleteTableData.SelectedItem as string; if (selectedColumnName == null || selectedTableData == null || string.IsNullOrEmpty(searchString)) { DeleteErrorSearchText.Text = "Please select column or form "; } else { if (selectedTableData.Contains("form")) { FormListDelete.ItemsSource = formdata.GetListForSearch(connection, selectedColumnName, searchString); } else if (selectedTableData.Contains("option")) { QuestionOptionListDelete.ItemsSource = questionOptiondata.GetListForSearch(connection, selectedColumnName, searchString); } else if (selectedTableData.Contains("question")) { QuestionListDelete.ItemsSource = questiondata.GetListForSearch(connection, selectedColumnName, searchString); } DeleteErrorSearchText.Text = ""; } connection.Close(); }
public MainWindow() { InitializeComponent(); tableDatas = new List <string>(); tableDatas.Add("form"); tableDatas.Add("question"); tableDatas.Add("question_option"); UpdateTableData.ItemsSource = tableDatas; DeleteTableData.ItemsSource = tableDatas; formdata = new FormDAO(); questiondata = new QuestionDAO(); questionOptiondata = new QuestionOptionDAO(); resultdata = new ResultDAO(); usersdata = new UsersDAO(); MySqlConnection connection = MyMySQLConnection.ConnectionSingleton(); connection.Open(); formColumnNames = formdata.FindColumnNamesOnlyString(connection); questionColumnNames = questiondata.FindColumnNamesOnlyString(connection); questionOptionColumnNames = questionOptiondata.FindColumnNamesOnlyString(connection); resultColumnNames = resultdata.FindColumnNamesOnlyString(connection); connection.Close(); }
//delete private void FindForm(object sender, EventArgs e) { MySqlConnection connection = MyMySQLConnection.ConnectionSingleton(); connection.Open(); List <Form> formList = formdata.GetList(connection); FormListDelete.ItemsSource = formList; connection.Close(); }
private void FindQuestionOption(object sender, EventArgs e) { MySqlConnection connection = MyMySQLConnection.ConnectionSingleton(); connection.Open(); List <QuestionOption> optionList = questionOptiondata.GetList(connection); QuestionOptionListDelete.ItemsSource = optionList; connection.Close(); }
private void SearchResultForStatistic(object sender, EventArgs e) { MySqlConnection connection = MyMySQLConnection.ConnectionSingleton(); connection.Open(); List <Form> formlist = formdata.GetList(connection); StatisticFormList.ItemsSource = formlist; connection.Close(); }
private void Button_Find(object sender, EventArgs e) { FormListUpdate.UnselectAll(); QuestionListUpdate.UnselectAll(); MySqlConnection connection = MyMySQLConnection.ConnectionSingleton(); connection.Open(); List <Form> formList = formdata.GetList(connection); connection.Close(); FormListUpdate.ItemsSource = formList; }
private void SelectedQuestionItem(object sender, EventArgs e) { Question question = QuestionListUpdate.SelectedItem as Question; if (question != null) { QuestionStringBox.Text = question.Question_string; MySqlConnection connection = MyMySQLConnection.ConnectionSingleton(); connection.Open(); List <QuestionOption> questionOptionList = questionOptiondata.GetListForQuestion(connection, question); connection.Close(); QuestionOptionListUpdate.ItemsSource = questionOptionList; } }
/**Update Form, Question, Question_Option*/ private void SelectedItem(object sender, EventArgs e) { ClearAll(); Form form = FormListUpdate.SelectedItem as Form; if (form != null) { FormNameBox.Text = form.Name; FormTagBox.Text = form.Tag; FormInformationBox.Text = form.Information; FormIsActive.IsChecked = form.IsActive; MySqlConnection connection = MyMySQLConnection.ConnectionSingleton(); connection.Open(); List <Question> questionList = questiondata.GetListForForm(connection, form); connection.Close(); QuestionListUpdate.ItemsSource = questionList; } }
private void UsersControl(object sender, EventArgs e) { MySqlConnection connection = MyMySQLConnection.ConnectionSingleton(); connection.Open(); Users users = new Users(); users.Nickname = Nickname.Text; users.Password = Password.Text; bool isUser = usersdata.ControlUser(connection, users); if (isUser) { UsersConnection.Visibility = Visibility.Hidden; DatabaseTab.Visibility = Visibility.Visible; } else { ErrorUserTextBlock.Visibility = Visibility.Visible; ErrorUserTextBlock.Text = "Wrong nickname or password!"; } connection.Close(); }
private void Delete() { MySqlConnection connection = MyMySQLConnection.ConnectionSingleton(); connection.Open(); Form form = FormListDelete.SelectedItem as Form; Question question = QuestionListDelete.SelectedItem as Question; QuestionOption option = QuestionOptionListDelete.SelectedItem as QuestionOption; if (form != null) { formdata.Delete(connection, form); } if (question != null) { questiondata.Delete(connection, question); } if (option != null) { questionOptiondata.Delete(connection, option); } connection.Close(); }
private void CreateQuestionOption(object sender, EventArgs e) { Question question = QuestionListCreate.SelectedItem as Question; int point; if (string.IsNullOrEmpty(OptionBoxCreate.Text) || question == null || !int.TryParse(PointBoxCreate.Text, out point)) { ErrorBoxCreate.Text = "Please fill all Question Option area or select question list from question or Point value must be number..."; } else { MySqlConnection connection = MyMySQLConnection.ConnectionSingleton(); connection.Open(); QuestionOption option = new QuestionOption(); option.Option_string = OptionBoxCreate.Text; option.Point = point; option.Question_id = question.Id; Console.WriteLine(option.ToString() + " " + point); questionOptiondata.Insert(connection, option); connection.Close(); ErrorBoxCreate.Text = ""; } }
private void CreateQuestion(object sender, EventArgs e) { Form form = FormListCreate.SelectedItem as Form; if (string.IsNullOrEmpty(QuestionStringBoxCreate.Text) || form == null) { ErrorBoxCreate.Text = "Please fill all Question area or select form list from form "; } else { MySqlConnection connection = MyMySQLConnection.ConnectionSingleton(); connection.Open(); Question question = new Question(); question.Question_string = QuestionStringBoxCreate.Text; question.Form_id = form.Id; Console.WriteLine(question.ToString()); questiondata.Insert(connection, question); connection.Close(); ErrorBoxCreate.Text = ""; } }
/*Create Form, Question, Question_Option*/ private void CreateForm(object sender, EventArgs e) { if (string.IsNullOrEmpty(FormNameBoxCreate.Text) || string.IsNullOrEmpty(FormTagBoxCreate.Text) || string.IsNullOrEmpty(FormInformationBoxCreate.Text)) { ErrorBoxCreate.Text = "Please fill all Form area"; } else { MySqlConnection connection = MyMySQLConnection.ConnectionSingleton(); connection.Open(); Form form = new Form(); form.Name = FormNameBoxCreate.Text; form.Tag = FormTagBoxCreate.Text; form.Information = FormInformationBoxCreate.Text; form.IsActive = FormIsActiveCreate.IsEnabled; Console.WriteLine(form.ToString()); formdata.Insert(connection, form); connection.Close(); ErrorBoxCreate.Text = ""; } }
private void Update(object sender, EventArgs e) { Form form = FormListUpdate.SelectedItem as Form; Question question = QuestionListUpdate.SelectedItem as Question; QuestionOption questionOption = QuestionOptionListUpdate.SelectedItem as QuestionOption; MySqlConnection connection = MyMySQLConnection.ConnectionSingleton(); connection.Open(); if (form != null) { form.Name = FormNameBox.Text; form.Tag = FormTagBox.Text; form.Information = FormInformationBox.Text; form.IsActive = Boolean.Parse("" + FormIsActive.IsChecked); formdata.Update(connection, form); } if (question != null) { question.Question_string = QuestionStringBox.Text; questiondata.Update(connection, question); } if (questionOption != null) { questionOption.Option_string = OptionBox.Text; questionOption.Point = Int16.Parse(PointBox.Text); questionOptiondata.Update(connection, questionOption); } connection.Close(); ClearAll(); FormListUpdate.ItemsSource = new List <Form>(); //string query = "update form inner join question on form.id = question.form_id inner join question_option on question.id = question_option.question_id set question.question_string = " + a + ", question_option.option_string = " + b + " where form.id = 1 and question.id = 1 and question_option.id = 1; "; }