private void CheckBox_Checked(object sender, RoutedEventArgs e)
{
//MessageBox.Show("Eureka, it's checked!");
CheckBox checkBox = (CheckBox)e.OriginalSource;
DataGridRow dataGridRow = VisualTreeHelpers.FindAncestor <DataGridRow>(checkBox) as DataGridRow;
if (dataGridRow != null)
{
dataGridRow.Background = new SolidColorBrush(Colors.LightCyan);
DataRowView row = (DataRowView)dataGridRow.Item;
var id_archived_no = row["id_archived_no"]; int id_manual_messages_num = Convert.ToInt32(id_archived_no);
var is_about_delivery = row["is_about_delivery"]; bool bool_Value = Convert.ToBoolean(is_about_delivery);
//MessageBox.Show(id_all_num.ToString()+" "+ bool_Value.ToString());
/*
* DataRowView row = (DataRowView)dataGridRow.Item;
*
* // Set the background color of the DataGrid row based on whatever data you like from
* // the row.
* var colValue = row["bool"];
* if (Convert.ToString(colValue) == "True")
* {
* dataGridRow.Background = new SolidColorBrush(Colors.LightCyan);
* }
* else
* {
* dataGridRow.Background = new SolidColorBrush(Colors.WhiteSmoke);
* }
*/
e.Handled = true;
string myConnection = "SERVER=localhost;DATABASE=mixed_initiative_exp1_practice;UID=Christine;PASSWORD=20150330;";
MySqlConnection myConn = new MySqlConnection(myConnection);
myConn.Open();
// MessageBox.Show("Connected");
MySqlCommand cmd = new MySqlCommand("UPDATE archived_no_messages SET is_about_delivery='1', is_manually_tagged='1' WHERE id_archived_no='" + id_manual_messages_num.ToString() + "'", myConn);
cmd.ExecuteNonQuery();
//MySqlDataAdapter adp = new MySqlDataAdapter(cmd);
myConn.Close();
}
}
private void wrong_btn_Click(object sender, RoutedEventArgs e)
{
var main = App.Current.MainWindow as MainWindow;
main.count_user_click++;
if (main.current_task_type == "Aligned")
{
if (main.count_user_click < 30)
{
main.user_respond[main.count_user_click] = System.DateTime.Now;
write_subtasktime(main.user_respond[main.count_user_click], main.current_task_type, main.count_user_click, "User", "Deny_system", DG1.Items.Count);
if (main.count_user_click == main.count_trigger)
{
main.push_respond_interval[main.count_trigger] = main.user_respond[main.count_user_click] - main.system_push[main.count_trigger];
main.interval_ms[main.count_trigger] = Convert.ToInt32(main.push_respond_interval[main.count_trigger].TotalMilliseconds) + main.t0;
}
else
{
main.push_respond_interval[main.count_user_click] = main.user_respond[main.count_user_click] - main.system_push[main.count_user_click];
main.interval_ms[main.count_user_click] = Convert.ToInt32(main.push_respond_interval[main.count_user_click].TotalMilliseconds) + main.t0;
}
if (main.count_trigger == 1)
{
main.uiTimer_aligned.Interval = main.t0;
main.uiTimer_aligned.Tick += main.Aligned_Timer_PushMessages;
main.uiTimer_aligned.Start();
main.Aligned_timer_flag = 1;
//main.update_count_trigger_and_messages();
}
}
else
{
main.user_respond[main.count_user_click] = System.DateTime.Now;
write_subtasktime(main.user_respond[main.count_user_click], main.current_task_type, main.count_user_click, "User", "Deny_system", DG1.Items.Count);
//end of task
main.Unsure_Messages.Visibility = main.Status_Bar.Visibility = System.Windows.Visibility.Hidden;
main.Start_Aligned_Timer.Visibility = main.Start_Random_Timer.Visibility = main.Start_Rhythmic_Timer.Visibility = main.Start_Manual.Visibility = main.Stop_Aligned_Timer.Visibility = main.Stop_Random_Timer.Visibility = main.Stop_Rhythmic_Timer.Visibility = main.Next_btn.Visibility = System.Windows.Visibility.Hidden;
main.Task_Ratings.Visibility = System.Windows.Visibility.Visible;
}
}
else
{
write_subtasktime(System.DateTime.Now, main.current_task_type, main.count_user_click, "User", "Deny_system", DG1.Items.Count);
if (main.count_user_click == 30)
{
main.Unsure_Messages.Visibility = main.Status_Bar.Visibility = System.Windows.Visibility.Hidden;
main.Start_Aligned_Timer.Visibility = main.Start_Random_Timer.Visibility = main.Start_Rhythmic_Timer.Visibility = main.Start_Manual.Visibility = main.Stop_Aligned_Timer.Visibility = main.Stop_Random_Timer.Visibility = main.Stop_Rhythmic_Timer.Visibility = main.Next_btn.Visibility = System.Windows.Visibility.Hidden;
main.Task_Ratings.Visibility = System.Windows.Visibility.Visible;
}
}
Button button = (Button)e.OriginalSource;
DataGridRow dataGridRow = VisualTreeHelpers.FindAncestor <DataGridRow>(button) as DataGridRow;
if (dataGridRow != null)
{
DataRowView row = (DataRowView)dataGridRow.Item;
var id_unsure_messages = row["id_unsure_messages"]; int id_unsure_messages_num = Convert.ToInt32(id_unsure_messages);
var is_about_delivery = row["is_about_delivery"]; bool bool_Value = Convert.ToBoolean(is_about_delivery);
e.Handled = true;
string myConnection = "SERVER=localhost;DATABASE=mixed_initiative_exp1;UID=Christine;PASSWORD=20150330;";
MySqlConnection myConn = new MySqlConnection(myConnection);
myConn.Open();
if (bool_Value == true)
{
MySqlCommand cmd = new MySqlCommand("UPDATE unsure_messages SET is_about_delivery='0' WHERE id_unsure_messages='" + id_unsure_messages_num.ToString() + "'", myConn);
cmd.ExecuteNonQuery();
//add NO messages in unsure_messages table to archived_no_messages table, is_manually_tagged = 1, from_table = unsure_messages, update new_confidence = 100
string cmd_archive_no_string = "INSERT INTO archived_no_messages (from_table_id, from_table, time, content, old_confidence, is_about_delivery) SELECT id_unsure_messages, table_name, time, content, confidence, is_about_delivery FROM unsure_messages WHERE is_about_delivery = 0 and id_unsure_messages = " + id_unsure_messages_num.ToString();
MySqlCommand cmd_archive_no = new MySqlCommand(cmd_archive_no_string, myConn);
cmd_archive_no.ExecuteNonQuery();
//set values (from_table='unsure_messages', is_manually_tagged='1') for the messages that were from unsure_messages table in archived_no_messages table
MySqlCommand cmd_update_archive_no = new MySqlCommand("UPDATE archived_no_messages SET is_manually_tagged='1', new_confidence='100' WHERE old_confidence<=90 and old_confidence>40 and from_table='unsure_messages'", myConn);
cmd_update_archive_no.ExecuteNonQuery();
}
else
{
MySqlCommand cmd = new MySqlCommand("UPDATE unsure_messages SET is_about_delivery='1' WHERE id_unsure_messages='" + id_unsure_messages_num.ToString() + "'", myConn);
cmd.ExecuteNonQuery();
//add yes messages in unsure_messages table to archived_yes_messages table, is_manually_tagged = 1, from_table = unsure_messages, update new_confidence = 100
string cmd_archive_yes_string = "INSERT INTO archived_yes_messages (from_table_id, from_table, time, content, old_confidence, is_about_delivery) SELECT id_unsure_messages, table_name, time, content, confidence, is_about_delivery FROM unsure_messages WHERE is_about_delivery = 1 and id_unsure_messages = " + id_unsure_messages_num.ToString();
MySqlCommand cmd_archive_yes = new MySqlCommand(cmd_archive_yes_string, myConn);
cmd_archive_yes.ExecuteNonQuery();
//set values (from_table='unsure_messages', is_manually_tagged='1') for the messages that were from unsure_messages table in archived_yes_messages table
MySqlCommand cmd_update_archive_yes = new MySqlCommand("UPDATE archived_yes_messages SET is_manually_tagged='1', new_confidence='100' WHERE old_confidence<=90 and old_confidence>40 and from_table='unsure_messages'", myConn);
cmd_update_archive_yes.ExecuteNonQuery();
}
//archive yes/no, refresh unsure
//MySqlCommand cmd5 = new MySqlCommand("TRUNCATE TABLE unsure_messages ", myConn);
string cmd5_string = "DELETE FROM unsure_messages WHERE id_unsure_messages = " + id_unsure_messages_num.ToString();
MySqlCommand cmd5 = new MySqlCommand(cmd5_string, myConn);
cmd5.ExecuteNonQuery();
MySqlCommand cmd_refresh_unsure = new MySqlCommand("SELECT id_unsure_messages, time, content, note, confidence, is_about_delivery FROM unsure_messages", myConn);
MySqlDataAdapter adp3 = new MySqlDataAdapter(cmd_refresh_unsure);
DataSet ds = new DataSet();
adp3.Fill(ds, "LoadDataBinding_Unsure");
main.Unsure_Messages.DG1.Items.Refresh();
main.Unsure_Messages.DG1.DataContext = ds;
myConn.Close();
}
if (main.count_user_click == 30)
{
uiTimer1.Tick -= HideUpdatingLabel;
uiTimer1.Stop();
main.updating_label.Visibility = System.Windows.Visibility.Hidden;
}
else
{
if (uiTimer1.Enabled)
{
uiTimer1.Tick -= HideUpdatingLabel;
uiTimer1.Stop();
//Random rnd = new Random();
//interval = rnd.Next(500, 1001);
main.updating_label.Visibility = System.Windows.Visibility.Visible;
uiTimer1.Interval = interval;
uiTimer1.Tick += HideUpdatingLabel;
uiTimer1.Start();
}
else
{
//Random rnd = new Random();
//interval = rnd.Next(500, 1001);
main.updating_label.Visibility = System.Windows.Visibility.Visible;
uiTimer1.Interval = interval;
uiTimer1.Tick += HideUpdatingLabel;
uiTimer1.Start();
}
}
}
