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; ";
}
