private void loadRowData(string index)
{
packages.mysql.mysqlSettings mySqlSettings = new packages.mysql.mysqlSettings();
string query = String.Format("SELECT employees.id, firstname, surname, patronymic FROM {0}.{1} WHERE employees.id = {2}",
packages.mysql.mysqlSettings.dbSchema,
databaseTable,
index);
mySqlSettings.createConnection();
using (mySqlSettings.initSqlCommand(query))
{
mySqlSettings.openConnection();
using (MySqlDataReader reader = mySqlSettings.initSqlCommand(query).ExecuteReader())
{
while (reader.Read())
{
inputFirstName.Text = (reader["firstname"].ToString());
inputSurName.Text = (reader["surname"].ToString());
inputPatronymic.Text = (reader["patronymic"].ToString());
}
}
populateComboBox();
}
mySqlSettings.closeConnection();
}
private void loadRowData(string index)
{
packages.mysql.mysqlSettings mySqlSettings = new packages.mysql.mysqlSettings();
string query = String.Format("SELECT id, name, description, technical_data FROM {0}.{1} WHERE id = {2}",
packages.mysql.mysqlSettings.dbSchema,
databaseTable,
index);
mySqlSettings.createConnection();
using (mySqlSettings.initSqlCommand(query))
{
mySqlSettings.openConnection();
using (MySqlDataReader reader = mySqlSettings.initSqlCommand(query).ExecuteReader())
{
while (reader.Read())
{
inputName.Text = (reader["name"].ToString());
}
}
populateComboBox();
}
mySqlSettings.closeConnection();
}
private void loadRowData(string index)
{
packages.mysql.mysqlSettings mySqlSettings = new packages.mysql.mysqlSettings();
string query = String.Format("SELECT name, price_per_unit FROM {0}.{1} WHERE id = {2}",
packages.mysql.mysqlSettings.dbSchema,
databaseTable,
index);
mySqlSettings.createConnection();
using (mySqlSettings.initSqlCommand(query))
{
mySqlSettings.openConnection();
using (MySqlDataReader reader = mySqlSettings.initSqlCommand(query).ExecuteReader())
{
while (reader.Read())
{
inputName.Text = (reader["name"].ToString());
inputPrice.Text = (reader["price_per_unit"].ToString());
}
}
}
mySqlSettings.closeConnection();
}
public void deleteMethod()
{
try
{
packages.mysql.mysqlSettings mySqlSettings = new packages.mysql.mysqlSettings();
string query = String.Format("DELETE FROM {0}.{1} WHERE {2} = {3}",
packages.mysql.mysqlSettings.dbSchema,
table,
"id",
index);
using (MySqlConnection mySqlConnection = new MySqlConnection(packages.mysql.mysqlSettings.connectionString))
{
using (MySqlCommand mySqlCommand = new MySqlCommand(query, mySqlConnection))
{
mySqlConnection.Open();
dataGrid.ItemsSource = mySqlSettings.getData(query).DefaultView;
}
mySqlConnection.Close();
}
}
catch (MySqlException ex)
{
if (ex.Number == 1451)
{
MessageBox.Show("Успадковані дані неможливо видалити.", "Помилка при видаленні", MessageBoxButton.OK, MessageBoxImage.Error);
}
else
{
MessageBox.Show(ex.Message, ex.Source);
}
}
}
private void buttonEdit_Click(object sender, RoutedEventArgs e)
{
packages.mysql.mysqlSettings mySqlSettings = new packages.mysql.mysqlSettings();
string query = String.Format("UPDATE {0} SET name = @name, price_per_unit = @price WHERE id = {1}",
databaseTable,
tmpIndex);
try
{
using (MySqlConnection mySqlConnection = new MySqlConnection(packages.mysql.mysqlSettings.connectionString))
{
using (MySqlCommand mySqlCommand = new MySqlCommand(query, mySqlConnection))
{
mySqlConnection.Open();
mySqlCommand.Parameters.AddWithValue("@name", inputName.Text);
mySqlCommand.Parameters.AddWithValue("@price", inputPrice.Text);
mySqlCommand.ExecuteNonQuery();
mySqlConnection.Close();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
loadTable();
}
private void loadRowData(string index)
{
packages.mysql.mysqlSettings mySqlSettings = new packages.mysql.mysqlSettings();
string query = String.Format("SELECT id, quantity, client_name, completion_date, description, SERVICES_id FROM {0}.{1} WHERE id = {2}",
packages.mysql.mysqlSettings.dbSchema,
databaseTable,
index);
mySqlSettings.createConnection();
using (mySqlSettings.initSqlCommand(query))
{
mySqlSettings.openConnection();
using (MySqlDataReader reader = mySqlSettings.initSqlCommand(query).ExecuteReader())
{
while (reader.Read())
{
inputQuantity.Text = (reader["quantity"].ToString());
inputName.Text = (reader["client_name"].ToString());
inputDesc.Text = (reader["description"].ToString());
inputDate.Text = (reader["completion_date"].ToString());
listServices.SelectedValue = (reader["SERVICES_id"]);
}
}
}
mySqlSettings.closeConnection();
}
private void buttonEdit_Click(object sender, RoutedEventArgs e)
{
packages.mysql.mysqlSettings mySqlSettings = new packages.mysql.mysqlSettings();
string query = String.Format("UPDATE {0} SET client_name = @client, description = @desc, SERVICES_id = @service, completion_date = @date_end, quantity = @quantity WHERE id = {1}",
databaseTable,
tmpIndex);
try
{
using (MySqlConnection mySqlConnection = new MySqlConnection(packages.mysql.mysqlSettings.connectionString))
{
using (MySqlCommand mySqlCommand = new MySqlCommand(query, mySqlConnection))
{
mySqlConnection.Open();
mySqlCommand.Parameters.AddWithValue("@client", inputName.Text);
mySqlCommand.Parameters.AddWithValue("@desc", inputDesc.Text);
mySqlCommand.Parameters.AddWithValue("@date_end", inputDate.Text);
mySqlCommand.Parameters.AddWithValue("@service", listServices.SelectedValue);
mySqlCommand.Parameters.AddWithValue("@quantity", inputQuantity.Text);
mySqlCommand.ExecuteNonQuery();
mySqlConnection.Close();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
loadTable();
}
private void dataGrid_DoubleClick(object sender, MouseButtonEventArgs e)
{
var description = (dataGrid.SelectedCells[0].Column.GetCellContent(dataGrid.SelectedCells[0].Item) as TextBlock).Text;
var id = (dataGrid.SelectedCells[1].Column.GetCellContent(dataGrid.SelectedCells[1].Item) as TextBlock).Text;
var quantity = (dataGrid.SelectedCells[2].Column.GetCellContent(dataGrid.SelectedCells[2].Item) as TextBlock).Text;
var clientName = (dataGrid.SelectedCells[3].Column.GetCellContent(dataGrid.SelectedCells[3].Item) as TextBlock).Text;
var service = (dataGrid.SelectedCells[6].Column.GetCellContent(dataGrid.SelectedCells[6].Item) as TextBlock).Text;
windows.orderPage window = new windows.orderPage();
#region serviceParser
packages.mysql.mysqlSettings mySqlSettings = new packages.mysql.mysqlSettings();
string query = String.Format("SELECT name, price_per_unit FROM {0}.{1} WHERE id = {2}",
packages.mysql.mysqlSettings.dbSchema,
"services",
Convert.ToInt32(service)
);
mySqlSettings.createConnection();
using (mySqlSettings.initSqlCommand(query))
{
mySqlSettings.openConnection();
using (MySqlDataReader reader = mySqlSettings.initSqlCommand(query).ExecuteReader())
{
while (reader.Read())
{
window.tbService.Text = (reader["name"].ToString());
window.tbServicePrice.Text = (reader["price_per_unit"].ToString());
}
}
}
mySqlSettings.closeConnection();
#endregion
int servicePrice = Convert.ToInt32(window.tbServicePrice.Text);
int total = servicePrice * Convert.ToInt32(quantity);
window.Title = "Замовлення №" + id;
window.tbTitle.Text = "Замовлення №" + id.ToString();
window.tbClient.Text = clientName;
window.tbQuantity.Text = quantity;
window.tbDesc.Text = description;
window.tbTotalPrice.Text = total.ToString();
window.ShowDialog();
}
private void buttonEdit_Click(object sender, RoutedEventArgs e)
{
packages.mysql.mysqlSettings mySqlSettings = new packages.mysql.mysqlSettings();
string query = String.Format("UPDATE {0} SET divisions_id = @division, firstname = @firstname, surname = @surname, patronymic = @patronymic WHERE {0}.id = {1}",
databaseTable,
tmpIndex);
try
{
using (MySqlConnection mySqlConnection = new MySqlConnection(packages.mysql.mysqlSettings.connectionString))
{
using (MySqlCommand mySqlCommand = new MySqlCommand(query, mySqlConnection))
{
mySqlConnection.Open();
if (inputDivision.SelectedValue == null)
{
mySqlCommand.Parameters.AddWithValue("@division", null);
mySqlCommand.Parameters.AddWithValue("@firstname", inputFirstName.Text);
mySqlCommand.Parameters.AddWithValue("@surname", inputSurName.Text);
mySqlCommand.Parameters.AddWithValue("@patronymic", inputPatronymic.Text);
}
else
{
mySqlCommand.Parameters.AddWithValue("@division", Convert.ToInt32(inputDivision.SelectedValue));
mySqlCommand.Parameters.AddWithValue("@firstname", inputFirstName.Text);
mySqlCommand.Parameters.AddWithValue("@surname", inputSurName.Text);
mySqlCommand.Parameters.AddWithValue("@patronymic", inputPatronymic.Text);
}
mySqlCommand.ExecuteNonQuery();
mySqlConnection.Close();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
loadTable();
}
private void populateComboBox()
{
packages.mysql.mysqlSettings database = new packages.mysql.mysqlSettings();
string query = String.Format("SELECT id, name FROM {0}.{1}",
packages.mysql.mysqlSettings.dbSchema,
foreignTable
);
database.createConnection();
using (database.initSqlCommand(query))
{
database.openConnection();
inputDivision.DisplayMemberPath = "name";
inputDivision.SelectedValuePath = "id";
inputDivision.ItemsSource = database.getData(query).DefaultView;
}
database.closeConnection();
}
private void loadServices()
{
packages.mysql.mysqlSettings database = new packages.mysql.mysqlSettings();
string query = String.Format("SELECT id, name, price_per_unit FROM {0}.{1}",
packages.mysql.mysqlSettings.dbSchema,
"services"
);
database.createConnection();
using (database.initSqlCommand(query))
{
database.openConnection();
listServices.SelectedValuePath = "id";
listServices.DisplayMemberPath = "name";
listServices.ItemsSource = database.getData(query).DefaultView;
}
database.closeConnection();
}