// ________________________________________________________________________ private void BtOk_Click(object sender, RoutedEventArgs e) { string selectQuery = "SELECT * FROM `tb_employee` WHERE employee_login = '******' and employee_password = '******'"; //Clipboard.SetDataObject(selectQuery); //MessageBox.Show("Ok"); lbMessages.Visibility = Visibility.Hidden; //TxBoxLogin.IsEnabled = false; MyData data = new MyData(); DataTable dt = data.fillMyAdapter(selectQuery); if (data.Error != "0") { lbMessages.Background = new SolidColorBrush(Colors.Red); lbMessages.Visibility = Visibility.Visible; lbMessages.Content = data.Error; //GridTest.IsEnabled = true; } else { try { //Clipboard.SetDataObject(dt.Rows[0][1].ToString()); data.Id_employee = dt.Rows[0][0].ToString(); data.FirstName_employee = dt.Rows[0][1].ToString(); //data.Dismissed_employee = dt.Rows[0][4].ToString(); data.Login_employee = dt.Rows[0][5].ToString(); data.Password_employee = dt.Rows[0][6].ToString(); data.Privilege_employee = dt.Rows[0][7].ToString(); string s = data.Privilege_employee.ToString(); data.Administrator = s[0].ToString(); data.Dismissed = s[1].ToString(); data.PreClean = s[2].ToString(); data.Testing = s[3].ToString(); data.Repaire = s[4].ToString(); data.Debug = s[5].ToString(); data.FinalQC = s[6].ToString(); data.Report = s[7].ToString(); //GridTest.IsEnabled = true; } catch { lbMessages.Background = new SolidColorBrush(Colors.Red); lbMessages.Visibility = Visibility.Visible; lbMessages.Content = "Wrong login or password!!"; //GridTest.IsEnabled = true; } if (data.Dismissed == "0") //if (data.Dismissed_employee == "1") { if (!CheckBoxRememberMe.IsChecked ?? true) { DailyUpdate_v3._1.Properties.Settings.Default.TxBoxLogin = string.Empty; Properties.Settings.Default.Save(); } else { DailyUpdate_v3._1.Properties.Settings.Default.TxBoxLogin = TxBoxLogin.Text; Properties.Settings.Default.Save(); } FireEvent(); this.Close(); } else { lbMessages.Background = new SolidColorBrush(Colors.Red); lbMessages.Visibility = Visibility.Visible; lbMessages.Content = "Wrong login or password!!"; } //MessageBox.Show(data.Login_employee); //MessageBox.Show(data.Privilege_employee); //this.Close(); } //lbMessages.Visibility = Visibility.Hidden; //lbMessages.Visibility = Visibility.Collapsed; /* * MyData data = new MyData(); * DataTable dt = new DataTable(); * data.connectionOpen(); * if (data.Connection.State == ConnectionState.Open) * { * MySqlDataAdapter da = new MySqlDataAdapter(selectQuery, data.Connection); * da.Fill(dt); * data.connectionClose(); * } * * try * { * MessageBox.Show(dt.Rows[0][3].ToString()); * } * catch * { * MessageBox.Show("Wrong password!!"); * } */ // DataTable dt = da.fillMyAdapter(selectQuery); //MessageBox.Show(dt.Rows[0][3].ToString()); /* works!! * { * try * { * MyData da = new MyData(); * DataTable dt = da.fillMyAdapter(selectQuery); * MessageBox.Show(dt.Rows[0][3].ToString()); * } * catch * { * MessageBox.Show("Wrong password!!"); * } * } */ //this.Close(); //connection.connectionOpenClose(); //MessageBox.Show("Connection pass"); }
private void addDeleteUpdateEmployee(string query) { MyData data = new MyData(); data.addDeleteUpdateData(query); }
private void BtSave_Click(object sender, RoutedEventArgs e) { //DateTime dateValue = DateTime.Parse(datePickerFrom.ToString()); //dataGridViewSubTbMain.Items.Clear(); //dataGridViewSubTbMain.Items.Refresh(); //dataGridViewSubTbMain.ItemsSource = null; MyData error = new MyData(); if (cmbox_Stage.SelectedValue == null) { MessageBox.Show("Fill in field stage"); } else { MyData data = new MyData(); string dateMysql = Convert.ToDateTime(datePickerFrom.Text).ToString("yyyy-MM-dd"); string idStage = cmbox_Stage.SelectedValue.ToString(); string query = "insert INTO tb_main(`main_date_create`, `main_wo`, `main_sku`, `main_sn`, `main_ref`, `id_tb_stage`, `id_tb_employee`) VALUES('" + dateMysql + "','" + textBox_WO.Text + "', '" + textBox_SKU.Text + "', '" + textBox_SN.Text + "', '" + textBox_REF.Text + "', '" + idStage + "','" + data.Id_employee + "')"; //Clipboard.SetDataObject(query); data.fillMyAdapter(query); string selectQuery = "SELECT id_main FROM tb_main WHERE main_wo ='" + textBox_WO.Text + "'"; //Id for SUB DataGridWiev if (error.Error.Contains("Duplicate entry")) { MessageBox.Show("The WO already exists"); DataTable dt = data.fillMyAdapter(selectQuery); string id_main = dt.Rows[0][0].ToString(); //for Updete SUB DataGridView selectQuery = "SELECT tb_main.*, tb_stage.stage_type, tb_employee.employee_first_name " + "FROM tb_main " + "left Join tb_stage ON tb_main.id_tb_stage = tb_stage.id_stage " + "left Join tb_employee ON id_tb_employee = tb_employee.id_employee " + "WHERE main_wo ='" + textBox_WO.Text + "'" + " order by id_main desc"; populateDataGridViewMain(selectQuery); //queryForMainDataGridView(dateMysql, dateMysql); populateDataGridViewSubTbMain(id_main); } else { DataTable dt = data.fillMyAdapter(selectQuery); string id_main = dt.Rows[0][0].ToString(); //for Updete SUB DataGridView DateTime dateValue = DateTime.Now; string dateTimeMysql = dateMysql + dateValue.ToString(" HH:mm:ss"); string idFailureCode = cmbox_FailureCode.SelectedValue.ToString(); query = "insert INTO tb_worksheet(`worksheet_date`, `worksheet_notes`, `id_tb_main`, `id_tb_employee" + "`, `id_tb_failure_code`) VALUES('" + dateTimeMysql + "','" + textBoxNotes.Text + "','" + dt.Rows[0][0].ToString() + "', '" + data.Id_employee + "', '" + idFailureCode + "')"; //Clipboard.SetDataObject(query); data.fillMyAdapter(query); selectQuery = "SELECT tb_main.*, tb_stage.stage_type, tb_employee.employee_first_name " + "FROM tb_main " + "left Join tb_stage ON tb_main.id_tb_stage = tb_stage.id_stage " + "left Join tb_employee ON id_tb_employee = tb_employee.id_employee " + "WHERE main_wo ='" + textBox_WO.Text + "'" + " order by id_main desc"; populateDataGridViewMain(selectQuery); //queryForMainDataGridView(dateMysql, dateMysql); populateDataGridViewSubTbMain(id_main); clearControls(); } /* * selectQuery = "SELECT tb_main.*, tb_stage.stage_type, tb_employee.employee_first_name " + * "FROM tb_main " + * "left Join tb_stage ON tb_main.id_tb_stage = tb_stage.id_stage " + * "left Join tb_employee ON id_tb_employee = tb_employee.id_employee " + * "WHERE main_wo ='" + textBox_WO.Text + "'" + * " order by id_main desc"; * * populateDataGridViewMain(selectQuery); * //queryForMainDataGridView(dateMysql, dateMysql); * populateDataGridViewSubTbMain(id_main); * clearControls(); */ } }