private void UsingSql(object sender, RoutedEventArgs e) { if (SQLQuery.Text.StartsWith("SELECT")) { MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData(); result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(SQLQuery.Text, connectStrWithDb); querySelected = true; if (result.HasError == false) { sqlSelectGrid.ItemsSource = result.ResultData.DefaultView; tabControl.SelectedIndex = 5; } else { MessageBox.Show(result.ErrorText); } } else { MySqlLib.MySqlDataC.MySqlExecute.MyResult result = new MySqlLib.MySqlDataC.MySqlExecute.MyResult(); result = MySqlLib.MySqlDataC.MySqlExecute.SqlNoneQuery(SQLQuery.Text, connectStrWithDb); if (result.HasError == false) { MessageBox.Show(result.ResultText); } else { MessageBox.Show(result.ErrorText); } } }
private void Table_Open(object sender, RoutedEventArgs e) { if (table.SelectedItem == null) { somethingAintSelected("Таблица не выбрана", "Выберите таблицу, которую хотите открыть"); } else { currentTable = ((DataRowView)table.SelectedItems[0]).Row[0].ToString(); MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData(); result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset("SELECT * FROM " + currentTable, connectStrWithDb); if (result.HasError == false) { tableSelected = true; tabControl.SelectedIndex = 2; tabControl.SelectedItem = openedTable; openedTable.IsSelected = true; RemovePunctiatonFromColumns(result, openedTableGrid); DescribeTableFoo(); } else { MessageBox.Show(result.ErrorText); } } }
private void SearchEmployee() { string SQLQuery = "SELECT * FROM employees WHERE "; TextBox[] textBoxes = { ID, FullName, Passport, Organization }; string[] attributesHeaders = { "ID", "Full_Name", "Serial_And_Passport_Number", "Organization" }; for (int i = 0; i < textBoxes.Length; i++) { if (textBoxes[i].Text != null && textBoxes[i].Text != "") { SQLQuery += "`" + attributesHeaders[i] + "` = '" + textBoxes[i].Text + "' AND "; } } if (ConfirmedByTheOrganization.SelectedIndex != -1) { SQLQuery += "`Confirmed_By_The_Organization` = '" + ConfirmedByTheOrganization.SelectedIndex + "'"; } SQLQuery += "end"; SQLQuery = SQLQuery.Replace(" AND end", ""); MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData(); result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(SQLQuery, connectStr); if (result.HasError == false) { grid.ItemsSource = result.ResultData.DefaultView; Close(); } else { MessageBox.Show(result.ErrorText); MessageBox.Show(SQLQuery); } }
private void SearchInDB(object sender, RoutedEventArgs e) { string SQLQuery = "SELECT * FROM `literature` WHERE "; string connStr = @"Database = listofsources; Data Source = localhost; User Id = root; Password ="******"") { SQLQuery += "`" + win.TableGrid.Columns[i].Header + "` = " + "'" + tb.Text + "' AND "; } } SQLQuery += "replaceme"; SQLQuery = SQLQuery.Replace("AND replaceme", ""); MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData(); result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(SQLQuery, connStr); if (result.HasError == false) { win.TableGrid.ItemsSource = result.ResultData.DefaultView; win.Activate(); Close(); } else { MessageBox.Show(result.ErrorText); } }
private void UpdateGrid(string TableName) { MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData(); DataGrid temp; if (TableName.Equals("employees")) { result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset("SELECT * FROM employees", connectStr); temp = employeesGrid; } else { string SQLQuery = @"SELECT report_IN.*, report_out.DateTime_OUT FROM `report_in`, `report_out` " + "WHERE `report_out`.`Session_ID` = `report_in`.`Session_ID`"; result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(SQLQuery, connectStr); temp = allReportsGrid; } if (result.HasError == false) { temp.ItemsSource = result.ResultData.DefaultView; // Fill DataGrid with [updated] SQL Query return data } else { MessageBox.Show(result.ErrorText); } }
private void DataBase_Open(object sender, RoutedEventArgs e) { if (dataBases.SelectedItem == null) { somethingAintSelected("База данных не выбрана", "Выберите базу данных, которую хотите открыть"); } else { currentDataBase = ((DataRowView)dataBases.SelectedItems[0]).Row["DATABASE"].ToString(); connectStrWithDb = @"Database = " + currentDataBase + "; " + connectStr; MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData(); result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset("SHOW TABLES", connectStrWithDb); if (result.HasError == false) { dataBaseSelected = true; tabControl.SelectedIndex = 1; tabControl.SelectedItem = tablesTab; tablesTab.IsSelected = true; RemovePunctiatonFromColumns(result, table); } else { MessageBox.Show(result.ErrorText); } } }
public void updateCurrentTable() { MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData(); result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset("SHOW TABLES", connectStrWithDb); if (result.HasError == false) { table.ItemsSource = result.ResultData.DefaultView; } else { MessageBox.Show(result.ErrorText); } }
public void updateTable(object sender, RoutedEventArgs e) { MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData(); result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset("SELECT * FROM " + currentTable, connectStrWithDb); if (result.HasError == false) { RemovePunctiatonFromColumns(result, openedTableGrid); } else { MessageBox.Show(result.ErrorText); } }
private void SensorsGridUpdate() { MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData(); result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset("SELECT * FROM sensors_data", connectStr); if (result.HasError == false) { sensors_data_grid.ItemsSource = result.ResultData.DefaultView; } else { MessageBox.Show(result.ErrorText); } }
public void SelectDataBases() { MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData(); result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset("SHOW DATABASES", connectStr); if (result.HasError == false) { dataBases.ItemsSource = result.ResultData.DefaultView; dataBases.UpdateLayout(); dataBases.Columns[0].Width = dataBases.Width - 1; } else { MessageBox.Show(result.ErrorText); } }
private void Report_Input(bool enterInput) { DataGrid temp = new DataGrid(); MySqlLib.MySqlData.MySqlExecuteData.MyResultData maxResult = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData(); string queryMaxInSession_ID = "SELECT MAX(Session_ID) FROM report_IN WHERE report_IN.ID = " + currentEmployeeID; string queryMaxOutSession_ID = "SELECT MAX(Session_ID) FROM report_OUT WHERE report_OUT.ID = " + currentEmployeeID; maxResult = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(queryMaxInSession_ID, connectStr); temp.ItemsSource = maxResult.ResultData.DefaultView; int maxInSession_ID; int.TryParse(((DataRowView)temp.Items[0]).Row["MAX(Session_ID)"].ToString(), out maxInSession_ID); maxResult = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(queryMaxOutSession_ID, connectStr); temp.ItemsSource = maxResult.ResultData.DefaultView; int maxOutSession_ID; int.TryParse(((DataRowView)temp.Items[0]).Row["MAX(Session_ID)"].ToString(), out maxOutSession_ID); if (enterInput) { if (maxInSession_ID == maxOutSession_ID) { Report_Input_SQL("IN", -1); } else // if maxInSession_ID > maxOutSession_ID then the entry is already committed { MessageBox.Show("Вход работника уже зафиксирован"); } } else { if (maxInSession_ID > maxOutSession_ID) { Report_Input_SQL("OUT", maxInSession_ID); } else // if maxInSession_ID <= maxOutSession_ID then the entry isn't committed // so they can't commit the exit { MessageBox.Show("Вход работника не зафиксирован, поэтому нельзя зафиксировать выход"); } } }
private void UpdateTable(object sender, RoutedEventArgs e) { string SQLQuery = "SELECT * FROM literature"; string connStr = @"Database = listofsources; Data Source = localhost; User Id = root; Password ="******"Что-то не так с базой данных", "", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void Search_Click(object sender, System.Windows.RoutedEventArgs e) { string SQLQuery = "SELECT report_IN.*, report_out.DateTime_OUT FROM `report_in`, `report_out` WHERE " + "`report_out`.`Session_ID` = `report_in`.`Session_ID` AND "; TextBox[] textBoxes = { ID, Session_ID }; string[] attributesHeaders = { "report_in.ID", "report_in.Session_ID" }; for (int i = 0; i < 2; i++) { if (textBoxes[i].Text != null && textBoxes[i].Text != "") { SQLQuery += attributesHeaders[i] + " = '" + textBoxes[i].Text + "' AND "; } } if (Date_In.SelectedDate != null) { string dateTime = getDateTime(Date_In); SQLQuery += "`DateTime_In` = '" + dateTime + "' AND "; } if (Date_Out.SelectedDate != null) { string dateTime = getDateTime(Date_Out); SQLQuery += "`DateTime_Out` = '" + dateTime + "' AND "; } SQLQuery += "end"; SQLQuery = SQLQuery.Replace(" AND end", ""); if (!SQLQuery.Contains("end")) { MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData(); result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(SQLQuery, connectStr); if (result.HasError == false) { grid.ItemsSource = result.ResultData.DefaultView; Close(); } else { MessageBox.Show(result.ErrorText); } } else { Close(); } }
private void button1_Click(object sender, EventArgs e) { MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData(); result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset("select * from market_cards", "Database=inventar_alleya;Data Source=localhost;User Id=root;Password=240580"); if (result.HasError == false) { dataGridView1.Columns.Clear(); dataGridView1.DataSource = result.ResultData.DefaultView; MessageBox.Show(result.ResultData.Rows.Count.ToString()); } else { MessageBox.Show(result.ErrorText); } }
private void SelectDataFromDB() { String sSQL = GetSQLString(); String sConnectionString = "Database=TestDB;Data Source=localhost;User Id=root;Password=qwerty789"; MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData(); result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(sSQL, sConnectionString); if (result.HasError == false) { dataGridView1.Columns.Clear(); dataGridView1.DataSource = result.ResultData.DefaultView; } else { MessageBox.Show(result.ErrorText); } }
private void From_DB(object sender, RoutedEventArgs e) { string SQLQuery = "SELECT * FROM literature"; MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData(); result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(SQLQuery, connStr); if (result.HasError == false) { SourcesTable win = new SourcesTable(); win.Show(); win.Owner = this; win.TableGrid.ItemsSource = result.ResultData.DefaultView; win.TableGrid.Columns[6].Width = 183; } else { MessageBox.Show("Что-то не так с базой данных", "", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void UpdateGrid(int ID) { string SQLQuery = @"SELECT report_IN.*, report_out.DateTime_OUT FROM `report_in`, `report_out` " + "WHERE `report_out`.`Session_ID` = `report_in`.`Session_ID` " + "AND `report_in`.`ID` = " + ID; MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData(); result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(SQLQuery, connectStr); if (result.HasError == false) { reportsGrid.ItemsSource = result.ResultData.DefaultView; } else { MessageBox.Show(result.ErrorText); } }
private void DescribeTableFoo() { if (tableSelected == false) { showChooseDialog(2); } else { MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData(); result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset("DESCRIBE `" + currentTable + "`", connectStrWithDb); if (result.HasError == false) { describeTable.ItemsSource = result.ResultData.DefaultView; } else { MessageBox.Show(result.ErrorText); } } }
/// <summary> /// Checks if there are incorrect numbers among the sensor numbers /// </summary> private bool AreThereIncorrectNumbers() { int.TryParse(NumberOfSensors.Text, out int numberOfSensors); MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData(); for (int i = 0; i < numberOfSensors; i++) { result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset( "SELECT number_of_sensor FROM sensors_data WHERE number_of_sensor = '" + sensorsNumbersBoxes[i].Text + "'", connectStr); try { bool isResultEmpty = result.ResultData.Rows[0] == null; } catch (System.IndexOutOfRangeException) { return(true); } } return(false); }
private void RemovePunctiatonFromColumns(MySqlLib.MySqlData.MySqlExecuteData.MyResultData result, DataGrid grid) { temp = new DataColumn[result.ResultData.Columns.Count]; for (int i = 0; i < temp.Length; i++) { temp[i] = new DataColumn(); temp[i].ColumnName = result.ResultData.Columns[i].ToString(); } string pattern = @"[\p{P}]"; for (int i = 0; i < result.ResultData.Columns.Count; i++) { result.ResultData.Columns[i].ColumnName = Regex.Replace(result.ResultData.Columns[i].ColumnName, pattern, ""); } grid.ItemsSource = result.ResultData.DefaultView; grid.UpdateLayout(); for (int i = 0; i < temp.Length - 1; i++) { grid.Columns[i].Header = temp[i].ColumnName; } }
private void listblagoorg_Load(object sender, EventArgs e) { String sSQL1 = "SELECT CharityId,CharityName,CharityDescription FROM charity"; String sConnectionString = "Database=prakt;Data Source=127.0.0.1;User Id=root"; MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData(); result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(sSQL1, sConnectionString); if (result.HasError == false) { metroGrid1.Columns.Clear(); metroGrid1.DataSource = result.ResultData.DefaultView; } else { MessageBox.Show(result.ErrorText); } for (int i = 1; i < 14; i++) { metroGrid1.Rows[i].Cells[3].Value = Properties.Resources.arise_logo; } daytime.Start(); date = new DateTime(2020, 11, 24, 6, 00, 00); }
private Table CustomTable_2() { Table table = new Table(); const int CELLS_IN_A_ROW = 6; table.Append(StandardTableProperties()); int.TryParse(NumberOfSensors.Text, out int numberOfSensors); TableRow[] tableRows = new TableRow[numberOfSensors]; TableCell[,] tableCells = new TableCell[numberOfSensors, CELLS_IN_A_ROW]; // 6 cells in a row Paragraph[,] paragraphs = new Paragraph[numberOfSensors, CELLS_IN_A_ROW]; Run[,] runs = new Run[numberOfSensors, CELLS_IN_A_ROW]; string[] headers = { "№", "Номер датчика", "Имя датчика", "Тип датчика", "Срок годности", "F0" }; table.Append(Table_Headers(ref headers)); // set headers (1st row) to the table string[] columnsNames = { "number_of_sensor", "name_of_sensor", "type_of_sensor", "expiration_date", "zero_value" }; for (int i = 0; i < numberOfSensors; i++) { MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData(); result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset( "SELECT number_of_sensor, name_of_sensor, type_of_sensor, expiration_date, zero_value " + "FROM sensors_data WHERE number_of_sensor = '" + sensorsNumbersBoxes[i].Text + "'", connectStr); if (result.HasError == false) { tableRows[i] = new TableRow(); string[] values = { result.ResultData.Rows[0].Field <string>(0), result.ResultData.Rows[0].Field <string>(1), result.ResultData.Rows[0].Field <string>(2) }; DateTime dateTime = result.ResultData.Rows[0].Field <DateTime>(3); double zero_value = result.ResultData.Rows[0].Field <double>(4); for (int k = 0; k < CELLS_IN_A_ROW; k++) { runs[i, k] = new Run(); paragraphs[i, k] = new Paragraph(); tableCells[i, k] = new TableCell(); if (k == 0) { runs[i, k].Append(new Text((k + 1).ToString())); } else if (k == 4) { runs[i, k].Append(new Text(dateTime.ToString().Substring(0, 10))); } else if (k == 5) { runs[i, k].Append(new Text(zero_value.ToString())); } else { runs[i, k].Append(new Text(values[k - 1])); } paragraphs[i, k].Append(runs[i, k]); tableCells[i, k].Append(paragraphs[i, k]); tableRows[i].Append(tableCells[i, k]); } table.Append(tableRows[i]); } else { MessageBox.Show(result.ErrorText); } } return(table); }
private Table CustomTable_3() { Table table = new Table(); const int CELLS_IN_A_ROW = 5; table.Append(StandardTableProperties()); int.TryParse(NumberOfSensors.Text, out int numberOfSensors); TableRow[] tableRows = new TableRow[numberOfSensors]; TableCell[,] tableCells = new TableCell[numberOfSensors, CELLS_IN_A_ROW]; // 5 cells in a row Paragraph[,] paragraphs = new Paragraph[numberOfSensors, CELLS_IN_A_ROW]; Run[,] runs = new Run[numberOfSensors, CELLS_IN_A_ROW]; string[] headers = { "№", "Значение A", "Значение B", "Значение C", "Значение D" }; table.Append(Table_Headers(ref headers)); // set headers (1st row) to the table string[] columnsNames = { "value_a", "value_b", "value_c", "value_d" }; for (int i = 0; i < numberOfSensors; i++) { MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData(); result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset( "SELECT value_a, value_b, value_c, value_d FROM " + "sensors_data WHERE number_of_sensor = '" + sensorsNumbersBoxes[i].Text + "'", connectStr); if (result.HasError == false) { tableRows[i] = new TableRow(); double[] values = { result.ResultData.Rows[0].Field <double>(0), result.ResultData.Rows[0].Field <double>(1), result.ResultData.Rows[0].Field <double>(2), result.ResultData.Rows[0].Field <double>(3) }; for (int k = 0; k < CELLS_IN_A_ROW; k++) { runs[i, k] = new Run(); paragraphs[i, k] = new Paragraph(); tableCells[i, k] = new TableCell(); if (k == 0) { runs[i, k].Append(new Text((k + 1).ToString())); } else { runs[i, k].Append(new Text(values[k - 1].ToString())); } paragraphs[i, k].Append(runs[i, k]); tableCells[i, k].Append(paragraphs[i, k]); tableRows[i].Append(tableCells[i, k]); } table.Append(tableRows[i]); } else { MessageBox.Show(result.ErrorText); } } return(table); }
private void AcceptChanges(object sender, EventArgs e) { string SQLQuery; if (isWindowForSearch == false) { SQLQuery = "INSERT INTO `" + dataBase + "`.`" + table + "`" + " ("; for (int i = 0; i < columns.Length; i++) { SQLQuery += "`" + columns[i] + "`, "; } SQLQuery += "replaceme"; SQLQuery = SQLQuery.Replace(", replaceme", ") "); SQLQuery += "VALUES("; int index = 5; for (int i = 0; i < columns.Length; i++) { TextBox tb = (TextBox)MainGrid.Children[index]; SQLQuery += "'" + tb.Text + "', "; index += 3; } SQLQuery += "replaceme"; SQLQuery = SQLQuery.Replace(", replaceme", ")"); MySqlLib.MySqlData.MySqlExecute.MyResult result = MySqlLib.MySqlData.MySqlExecute.SqlNoneQuery(SQLQuery, connectString); if (result.HasError == false) { this.Close(); } else { MessageBox.Show(result.ErrorText); } } else { SQLQuery = "SELECT * FROM `" + table + "`" + " WHERE "; int index = 5; for (int i = 0; i < columns.Length; i++) { TextBox tb = (TextBox)MainGrid.Children[index]; if (tb.Text != null && tb.Text != "") { SQLQuery += "`" + columns[i] + "` = " + "'" + tb.Text + "' AND "; index += 3; } } SQLQuery += "replaceme"; SQLQuery = SQLQuery.Replace("AND replaceme", " LIMIT 0, 30"); MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData(); result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(SQLQuery, connectStringWithDb); if (result.HasError == false) { openedGrid.ItemsSource = result.ResultData.DefaultView; this.Close(); } else { MessageBox.Show(result.ErrorText); } } }