private void buttonRegister_Click(object sender, EventArgs e)
{
if (userNameField.Text.Contains(' ') || userSurnameField.Text.Contains(' ') ||
textBox_login.Text.Contains(' ') || textBox_pass.Text.Contains(' ') ||
textBox1_otch.Text.Contains(' ') || textBox1_pol.Text.Contains(' ') ||
textBox1_pas.Text.Contains(' ') ||
textBox1_tel.Text.Contains(' ') || textBox1_cat.Text.Contains(' '))
{
MessageBox.Show("Введите корректные значения");
return;
}
else
if (userNameField.Text == "Введите имя" || userSurnameField.Text == "Введите фамилию" ||
textBox_login.Text == "Введите логин" || textBox_pass.Text == "Введите пароль" ||
textBox1_otch.Text == "Введите отчество" || textBox1_pol.Text == "Введите подразделение" ||
textBox1_pas.Text == "Электронная почта" ||
textBox1_tel.Text == "Номер телефона" || textBox1_cat.Text == "Введите должность")
{
MessageBox.Show("Введите данные");
return;
}
if (isUserExists())
{
return;
}
DB db = new DB();
MySqlDataReader reader;
MySqlCommand command = new MySqlCommand("INSERT INTO `oborot`.`sotrudnik` (`Фамилия`, `Имя`, `Отчество`," +
" `Телефон`, `Электронная почта`, `DOLZNOST_id`, `PODRAZDELENIE_id`)" +
" VALUES (@surname, @name, @otch, @tel, @mail, @dol_id, @pod_id)", db.getConnection());
command.Parameters.Add("@name", MySqlDbType.VarChar).Value = userNameField.Text;
command.Parameters.Add("@surname", MySqlDbType.VarChar).Value = userSurnameField.Text;
command.Parameters.Add("@otch", MySqlDbType.VarChar).Value = textBox1_otch.Text;
command.Parameters.Add("@tel", MySqlDbType.VarChar).Value = textBox1_tel.Text;
command.Parameters.Add("@mail", MySqlDbType.VarChar).Value = textBox1_pas.Text;
command.Parameters.Add("@dol_id", MySqlDbType.VarChar).Value = textBox1_cat.Text;
command.Parameters.Add("@pod_id", MySqlDbType.VarChar).Value = textBox1_pol.Text;
db.openConnection();
if (command.ExecuteNonQuery() == 1)
{
MessageBox.Show("Аккаунт создан");
}
else
{
MessageBox.Show("Аккаунт не создан");
}
db.closeConnection();
MySqlCommand command_vxod_id = new MySqlCommand("select id from `sotrudnik` where Имя = @name AND Фамилия = @surname AND Отчество = @otch AND Телефон = @tel AND `Электронная почта` = @mail AND DOLZNOST_id = @dol_id AND PODRAZDELENIE_id = @pod_id", db.getConnection());
command_vxod_id.Parameters.Add("@name", MySqlDbType.VarChar).Value = userNameField.Text;
command_vxod_id.Parameters.Add("@surname", MySqlDbType.VarChar).Value = userSurnameField.Text;
command_vxod_id.Parameters.Add("@otch", MySqlDbType.VarChar).Value = textBox1_otch.Text;
command_vxod_id.Parameters.Add("@tel", MySqlDbType.VarChar).Value = textBox1_tel.Text;
command_vxod_id.Parameters.Add("@mail", MySqlDbType.VarChar).Value = textBox1_pas.Text;
command_vxod_id.Parameters.Add("@dol_id", MySqlDbType.VarChar).Value = textBox1_cat.Text;
command_vxod_id.Parameters.Add("@pod_id", MySqlDbType.VarChar).Value = textBox1_pol.Text;
db.openConnection();
reader = command_vxod_id.ExecuteReader();
while (reader.Read())
{
vxod_id = reader["id"].ToString();
}
db.closeConnection();
MySqlCommand command_vxod = new MySqlCommand("INSERT INTO `oborot`.`vxod` (`login`, `password`, `SOTRUDNIK_id`)" +
" VALUES (@login, @pas, @sotr_id)", db.getConnection());
command_vxod.Parameters.Add("@login", MySqlDbType.VarChar).Value = textBox_login.Text;
command_vxod.Parameters.Add("@pas", MySqlDbType.VarChar).Value = textBox_pass.Text;
command_vxod.Parameters.Add("@sotr_id", MySqlDbType.VarChar).Value = vxod_id;
db.openConnection();
command_vxod.ExecuteNonQuery();
db.closeConnection();
}
private void button1_Click(object sender, EventArgs e)
{
login.Value = textBox_login.Text;
DB db = new DB();
DataTable table = new DataTable();
MySqlDataAdapter adapter = new MySqlDataAdapter();
MySqlDataReader reader;
MySqlDataReader reader1;
MySqlDataReader reader2;
MySqlCommand command = new MySqlCommand("select * from `vxod` where login = @uL AND password = @uP", db.getConnection());
MySqlCommand command_category = new MySqlCommand("select наименование_должности from sotrudnik join dolznost on DOLZNOST_id = dolznost.id join VXOD on SOTRUDNIK_id = SOTRUDNIK.id where login = @uL", db.getConnection());
MySqlCommand command_name = new MySqlCommand("select имя from `SOTRUDNIK` join VXOD on SOTRUDNIK_id = SOTRUDNIK.id where login = @uL", db.getConnection());
MySqlCommand command_podrazdelenie = new MySqlCommand("select PODRAZDELENIE.id from `PODRAZDELENIE` " +
"join SOTRUDNIK on PODRAZDELENIE_id = PODRAZDELENIE.id join VXOD on SOTRUDNIK_id = SOTRUDNIK.id " +
"where login = @uL;", db.getConnection());
command.Parameters.Add("@uL", MySqlDbType.VarChar).Value = textBox_login.Text;
command.Parameters.Add("@uP", MySqlDbType.VarChar).Value = textBox_pass.Text;
command_category.Parameters.Add("@uL", MySqlDbType.VarChar).Value = textBox_login.Text;
command_name.Parameters.Add("@uL", MySqlDbType.VarChar).Value = textBox_login.Text;
command_podrazdelenie.Parameters.Add("@uL", MySqlDbType.VarChar).Value = textBox_login.Text;
db.openConnection();
adapter.SelectCommand = command;
adapter.Fill(table);
reader = command_category.ExecuteReader();
while (reader.Read())
{
categoryUser.Value = reader["наименование_должности"].ToString();
}
db.closeConnection();
db.openConnection();
reader2 = command_podrazdelenie.ExecuteReader();
while (reader2.Read())
{
podrazdelenie.Value = reader2["id"].ToString();
}
db.closeConnection();
db.openConnection();
reader1 = command_name.ExecuteReader();
while (reader1.Read())
{
logos.Value = reader1["имя"].ToString();
}
if (table.Rows.Count > 0 && categoryUser.Value == "admin")
{
this.Hide();
MainForm mainForm = new MainForm();
mainForm.Show();
}
else
if (table.Rows.Count > 0 && categoryUser.Value == "rukovoditel")
{
this.Hide();
RukovosShow RukovosShow = new RukovosShow();
RukovosShow.Show();
}
else
if (table.Rows.Count > 0 && categoryUser.Value == "sotrudnik")
{
this.Hide();
UserMain UserMain = new UserMain();
UserMain.Show();
}
else
{
MessageBox.Show("Неверный логин или пароль");
}
db.closeConnection();
}
private void button2_Click(object sender, EventArgs e)
{
obnovTbl = "2";
if (logos.Value == "office")
{
button5.Visible = false;
flagTblcomp = "1";
}
else
if (logos.Value == "company")
{
button5.Visible = true;
}
if (logos.Value == "company")
{
flagTbl = "1";
ds.Reset();
MySqlDataAdapter adapter = new MySqlDataAdapter();
DB db = new DB();
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView1.AllowUserToAddRows = false;
MySqlCommand command = new MySqlCommand("select * from work_user_doc where users_id = (select id from users where логин = @uL)", db.getConnection());
command.Parameters.Add("@uL", MySqlDbType.VarChar).Value = login.Value;
db.openConnection();
adapter.SelectCommand = command;
adapter.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
db.closeConnection();
}
else
if (logos.Value == "office")
{
flagTbl = "2";
ds.Reset();
MySqlDataAdapter adapter = new MySqlDataAdapter();
DB db = new DB();
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView1.AllowUserToAddRows = false;
MySqlCommand command = new MySqlCommand("select * from work_user_doc", db.getConnection());
command.Parameters.Add("@uL", MySqlDbType.VarChar).Value = login.Value;
db.openConnection();
adapter.SelectCommand = command;
adapter.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
db.closeConnection();
}
}
private void button3_Click(object sender, EventArgs e)
{
if (flagTbl == "SOTRUDNIK")
{
flagTable = 1;
flagTbl = "SOTRUDNIK";
ds.Reset();
MySqlDataAdapter adapter = new MySqlDataAdapter();
DB db = new DB();
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView1.AllowUserToAddRows = false;
MySqlCommand command = new MySqlCommand("select * from SOTRUDNIK", db.getConnection());
db.openConnection();
adapter.SelectCommand = command;
adapter.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
db.closeConnection();
}
else
if (flagTbl == "VXOD")
{
flagTable = 2;
flagTbl = "VXOD";
ds.Reset();
MySqlDataAdapter adapter = new MySqlDataAdapter();
DB db = new DB();
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView1.AllowUserToAddRows = false;
MySqlCommand command = new MySqlCommand("select * from VXOD", db.getConnection());
db.openConnection();
adapter.SelectCommand = command;
adapter.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
db.closeConnection();
}
else
if (flagTbl == "PODRAZDELENIE")
{
flagTable = 3;
flagTbl = "PODRAZDELENIE";
ds.Reset();
MySqlDataAdapter adapter = new MySqlDataAdapter();
DB db = new DB();
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView1.AllowUserToAddRows = false;
MySqlCommand command = new MySqlCommand("select * from PODRAZDELENIE", db.getConnection());
db.openConnection();
adapter.SelectCommand = command;
adapter.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
db.closeConnection();
}
//else
//if (flagTbl == "sessions")
//{
// flagTable = 5;
// flagTbl = "sessions";
// ds.Reset();
// MySqlDataAdapter adapter = new MySqlDataAdapter();
// DB db = new DB();
// dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
// dataGridView1.AllowUserToAddRows = false;
// MySqlCommand command = new MySqlCommand("select * from session", db.getConnection());
// db.openConnection();
// adapter.SelectCommand = command;
// adapter.Fill(ds);
// dataGridView1.DataSource = ds.Tables[0];
// db.closeConnection();
//}
else
if (flagTbl == "DOLZNOST")
{
flagTable = 4;
flagTbl = "DOLZNOST";
ds.Reset();
MySqlDataAdapter adapter = new MySqlDataAdapter();
DB db = new DB();
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView1.AllowUserToAddRows = false;
MySqlCommand command = new MySqlCommand("select * from DOLZNOST", db.getConnection());
db.openConnection();
adapter.SelectCommand = command;
adapter.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
db.closeConnection();
}
else
if (flagTbl == "HISTORY")
{
flagTable = 6;
flagTbl = "HISTORY";
ds.Reset();
MySqlDataAdapter adapter = new MySqlDataAdapter();
DB db = new DB();
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView1.AllowUserToAddRows = false;
MySqlCommand command = new MySqlCommand("select * from HISTORY", db.getConnection());
db.openConnection();
adapter.SelectCommand = command;
adapter.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
db.closeConnection();
}
else
if (flagTbl == "DOKUMENT")
{
flagTable = 7;
flagTbl = "DOKUMENT";
ds.Reset();
MySqlDataAdapter adapter = new MySqlDataAdapter();
DB db = new DB();
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView1.AllowUserToAddRows = false;
MySqlCommand command = new MySqlCommand("select * from DOKUMENT", db.getConnection());
db.openConnection();
adapter.SelectCommand = command;
adapter.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
db.closeConnection();
}
else
if (flagTbl == "TIP_DOKUMENTA")
{
flagTable = 8;
flagTbl = "TIP_DOKUMENTA";
ds.Reset();
MySqlDataAdapter adapter = new MySqlDataAdapter();
DB db = new DB();
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView1.AllowUserToAddRows = false;
MySqlCommand command = new MySqlCommand("select * from TIP_DOKUMENTA", db.getConnection());
db.openConnection();
adapter.SelectCommand = command;
adapter.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
db.closeConnection();
}
//else
//if (flagTbl == "gotov_doc")
//{
// flagTable = 9;
// flagTbl = "gotov_doc";
// ds.Reset();
// MySqlDataAdapter adapter = new MySqlDataAdapter();
// DB db = new DB();
// dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
// dataGridView1.AllowUserToAddRows = false;
// MySqlCommand command = new MySqlCommand("select * from gotov_doc", db.getConnection());
// db.openConnection();
// adapter.SelectCommand = command;
// adapter.Fill(ds);
// dataGridView1.DataSource = ds.Tables[0];
// db.closeConnection();
//}
else
if (flagTbl == "")
{
MessageBox.Show("Выберите таблицу");
}
}
public void noneid_PODRAZDELENIE()
{
string ids = dataGridView1[0, dataGridView1.CurrentRow.Index].Value.ToString();
DB db = new DB();
MySqlCommand command = new MySqlCommand("DELETE FROM PODRAZDELENIE " +
" WHERE `id` = @idx", db.getConnection());
command.Parameters.Add("@idx", MySqlDbType.Int32).Value = ids;
db.openConnection();
if (command.ExecuteNonQuery() == 1)
{
MessageBox.Show("Запись удалена");
}
else
{
MessageBox.Show("Запись не удалена");
}
db.closeConnection();
//Это было до изменения программы может пригодится
//DB db = new DB();
//MySqlCommand command = new MySqlCommand("DELETE FROM company " +
// " WHERE `id` = @idx", db.getConnection());
//MySqlCommand command1 = new MySqlCommand("DELETE FROM adres " +
// " WHERE `company_id` = @idx", db.getConnection());
//MySqlCommand command2 = new MySqlCommand("DELETE FROM doc " +
// " WHERE `company_id` = @idx", db.getConnection());
//MySqlCommand command3 = new MySqlCommand("DELETE FROM work_user_doc " +
// " WHERE `doc_id` IN (select id from doc where company_id = @idx)", db.getConnection());
//MySqlCommand command4 = new MySqlCommand("DELETE FROM gotov_doc " +
// " WHERE `doc_id` IN (select id from doc where company_id = @idx)", db.getConnection());
//command.Parameters.Add("@idx", MySqlDbType.Int32).Value = ids;
//command1.Parameters.Add("@idx", MySqlDbType.Int32).Value = ids;
//command2.Parameters.Add("@idx", MySqlDbType.Int32).Value = ids;
//command3.Parameters.Add("@idx", MySqlDbType.Int32).Value = ids;
//command4.Parameters.Add("@idx", MySqlDbType.Int32).Value = ids;
//db.openConnection();
//command4.ExecuteNonQuery();
//command3.ExecuteNonQuery();
//command1.ExecuteNonQuery();
//command2.ExecuteNonQuery();
//if (command.ExecuteNonQuery() == 1)
//{
// MessageBox.Show("Запись удалена");
//}
//else
// MessageBox.Show("Запись не удалена");
//db.closeConnection();
}
private void button1_Click(object sender, EventArgs e)
{
if (flagTable == 0)
{
MessageBox.Show("Выберите таблицу");
return;
}
if (flagTable == 1)
{
noneid_SOTRUDNIK();
return;
}
if (flagTable == 2)
{
noneidVXOD();
return;
}
if (flagTable == 3)
{
noneid_PODRAZDELENIE();
return;
}
if (flagTable == 4)
{
noneid_DOLZNOST();
return;
}
if (flagTable == 6)
{
noneid_HISTORY();
return;
}
if (flagTable == 7)
{
noneid_DOKUMENT();
return;
}
if (flagTable == 8)
{
noneidWork();
return;
}
if (flagTable == 9)
{
noneidWork();
return;
}
string ids = dataGridView1[0, dataGridView1.CurrentRow.Index].Value.ToString();
int id = int.Parse(ids);
DB db = new DB();
MySqlCommand command = new MySqlCommand("DELETE FROM " + flagTbl +
" WHERE `id` = @idx", db.getConnection());
command.Parameters.Add("@idx", MySqlDbType.Int32).Value = id;
db.openConnection();
if (command.ExecuteNonQuery() == 1)
{
MessageBox.Show("Запись удалена");
}
else
{
MessageBox.Show("Запись не удалена");
}
db.closeConnection();
}
private void buttonRegister_Click(object sender, EventArgs e)
{
DB db = new DB();
MySqlDataReader reader;
MySqlCommand command_log = new MySqlCommand("select sotrudnik.id from `sotrudnik` join vxod on SOTRUDNIK.id = SOTRUDNIK_id WHERE login = @login", db.getConnection());
command_log.Parameters.Add("@login", MySqlDbType.VarChar).Value = userNameField.Text;
db.openConnection();
reader = command_log.ExecuteReader();
while (reader.Read())
{
log_id = reader["id"].ToString();
}
db.closeConnection();
MySqlCommand command_vxod_id = new MySqlCommand("select vxod.id from `sotrudnik` join vxod on SOTRUDNIK.id = SOTRUDNIK_id WHERE login = @login", db.getConnection());
command_vxod_id.Parameters.Add("@login", MySqlDbType.VarChar).Value = userNameField.Text;
db.openConnection();
reader = command_vxod_id.ExecuteReader();
while (reader.Read())
{
vxod_id = reader["id"].ToString();
}
db.closeConnection();
MySqlCommand command_del_vxod = new MySqlCommand("DELETE FROM `oborot`.`vxod` WHERE (`id` = @vxod_id);", db.getConnection());
command_del_vxod.Parameters.Add("@vxod_id", MySqlDbType.VarChar).Value = vxod_id;
db.openConnection();
command_del_vxod.ExecuteNonQuery();
db.closeConnection();
MySqlCommand command = new MySqlCommand("DELETE FROM `oborot`.`sotrudnik` WHERE (`id` = @log_id);", db.getConnection());
command.Parameters.Add("@log_id", MySqlDbType.VarChar).Value = log_id;
db.openConnection();
if (command.ExecuteNonQuery() == 1)
{
MessageBox.Show("Аккаунт удален");
}
else
{
MessageBox.Show("Аккаунт не удален");
}
db.closeConnection();
}