private void Data_Shown(object sender, EventArgs e)
{
HeaderOfTheTable();
List <RowOfData> _data = new List <RowOfData>();
DatabaseManager _manager = new DatabaseManager();
MySqlCommand _command = new MySqlCommand("SELECT * FROM `customer`", _manager.GetConnection);
MySqlDataReader _reader;
try
{
_manager.OpenConnection();
_reader = _command.ExecuteReader();
while (_reader.Read())
{
RowOfData row = new RowOfData(_reader["id"], _reader["full_name"], _reader["age"], _reader["sex"], _reader["experience"], _reader["education"], _reader["medical_card"], _reader["car"]);
_data.Add(row);
}
for (int i = 0; i < _data.Count; i++)
{
AddDataGrid(_data[i]);
}
}
catch
{
MessageBox.Show("Произошла ошибка при работе с БД!", "Варнинг");
}
finally
{
_manager.CloseConnection();
}
}
private void обновитьToolStripMenuItem_Click(object sender, EventArgs e)
{
_data.Clear();
DatabaseManager _manager = new DatabaseManager();
MySqlCommand _command = new MySqlCommand("SELECT * FROM `customer`", _manager.GetConnection);
MySqlDataReader _reader;
dataGrid.DataSource = null;
dataGrid.Rows.Clear();
try
{
_manager.OpenConnection();
_reader = _command.ExecuteReader();
while (_reader.Read())
{
RowOfData row = new RowOfData(
_reader["id"],
_reader["full_name"],
_reader["age"],
_reader["sex"],
_reader["experience"],
_reader["education"],
_reader["medical_card"],
_reader["car"]);
_data.Add(row);
}
if (checkBox1.Checked)
{
dataGrid.ReadOnly = false;
}
else
{
dataGrid.ReadOnly = true;
}
//dobavim v tablicu epta
for (int i = 0; i < _data.Count; i++)
{
AddDataGrid(_data[i]);
dataGrid.Rows[i].Cells[0].ReadOnly = true; // id ne trogat suka
}
}
catch
{
MessageBox.Show("Произошла ошибка при работе с БД!", "Варнинг");
}
finally
{
_manager.CloseConnection();
}
}
private void AddDataGrid(RowOfData row)
{
dataGrid.Rows.Add(
row.id,
row.full_name,
row.age,
row.sex,
row.experience,
row.education,
row.medical_card,
row.car); // dobavlenie strok v tablicu
}
private void обновитьToolStripMenuItem_Click(object sender, EventArgs e)
{
List <RowOfData> _data = new List <RowOfData>();
DatabaseManager _manager = new DatabaseManager();
MySqlCommand _command = new MySqlCommand("SELECT * FROM `customer`", _manager.GetConnection);
MySqlDataReader _reader;
//udalyaem tekushie stroki, chtob obnovit
dataGrid.DataSource = null;
dataGrid.Rows.Clear();
try
{
_manager.OpenConnection();
_reader = _command.ExecuteReader();
while (_reader.Read())
{
RowOfData row = new RowOfData(
_reader["id"],
_reader["full_name"],
_reader["age"],
_reader["sex"],
_reader["experience"],
_reader["education"],
_reader["medical_card"],
_reader["car"]);
_data.Add(row);
}
for (int i = 0; i < _data.Count; i++)
{
AddDataGrid(_data[i]);
}
MessageBox.Show("Данные обновлены!", "Успех");
}
catch
{
MessageBox.Show("Произошла ошибка при работе с БД!", "Варнинг");
}
finally
{
_manager.CloseConnection();
}
}
private void Choose_Click(object sender, EventArgs e)
{
dataGrid.DataSource = null;
dataGrid.Rows.Clear();
_data.Clear();
DatabaseManager _manager = new DatabaseManager();
MySqlCommand _command = new MySqlCommand("SELECT * FROM `customer`", _manager.GetConnection);
MySqlDataReader _reader;
try
{
_manager.OpenConnection();
_reader = _command.ExecuteReader();
while (_reader.Read())
{
RowOfData row = new RowOfData(_reader["id"], _reader["full_name"], _reader["age"], _reader["sex"], _reader["experience"], _reader["education"], _reader["medical_card"], _reader["car"]);
_data.Add(row);
}
int i = Convert.ToInt32(numericChoose.Value) - 1;
if (i >= 0 && i < _data.Count)
{
dataGrid.ReadOnly = false; // razreshaem redaktirovac!
AddDataGrid(_data[i]);
dataGrid.Columns[0].ReadOnly = true;
}
else
{
MessageBox.Show("Выбран неправильный элемент!", "Что-то пошло не так!");
}
}
catch
{
MessageBox.Show("Произошла ошибка при работе с БД!", "Варнинг");
}
finally
{
_manager.CloseConnection();
}
}
