public void User_acc() { ToConnection str_config = new ToConnection(); SqlConnection acc = new SqlConnection(str_config.read_conf()); string tab_sql= @"Select me.id_access, me.Login, me.NameInfoUser, me2.Name_R, me.Date_iz From Role me2, Access_User me Where me.id_Role=me2.id_Role and me._delete = 'True'"; try { acc.Open(); SqlDataAdapter dataAdapter = new SqlDataAdapter(tab_sql, acc); DataTable dt = new DataTable(); dataAdapter.Fill(dt); DatGridUser.DataSource = dt; _size(); } catch (SqlException ex) { MessageBox.Show(ex.ToString(), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc.Close(); } }
//Вставка данных в таблицу public void User_acc() { t_filter.SelectedIndex = 0; ToConnection str_config = new ToConnection(); SqlConnection acc = new SqlConnection(str_config.read_conf()); string tab_sql = @"Select me.id_client, me.Number_card, me.Name, me4.Name, me.Date_reg, me.Block, me.Sum_money, me3.NameInfoUser, me.Inform From Client me, Access_user me3, Bonus me4 Where me.id_access = me3.id_access and me.id_bonus=me4.id_bonus and me._delete='False'"; try { acc.Open(); SqlDataAdapter dataAdapter = new SqlDataAdapter(tab_sql, acc); DataTable dt = new DataTable(); dataAdapter.Fill(dt); DatGridUser.DataSource = dt; _size(); l_count.Text = Convert.ToString(DatGridUser.RowCount); } catch (SqlException ex) { MessageBox.Show(ex.ToString(), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc.Close(); } }
//метод блокировки клиента public void _block(string star_del) { ToConnection str_config = new ToConnection(); SqlConnection acc = new SqlConnection(str_config.read_conf()); string tab_sql = @"BEGIN TRANSACTION; UPDATE Client SET Client.Block = 'True' Where Client.id_client='" + star_del + "' COMMIT TRANSACTION;"; try { acc.Open(); SqlCommand s_User = new SqlCommand(tab_sql, acc); s_User.ExecuteNonQuery(); l_count.Text = Convert.ToString(DatGridUser.RowCount); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc.Close(); } }
//Вставка данных в таблицу public void User_acc() { ToConnection str_config = new ToConnection(); SqlConnection acc = new SqlConnection(str_config.read_conf()); string tab_sql = @"Select me.id_level, me.Name, me2.Name, me.level_min, me.level_max From Level_bns me, Bonus me2 Where me.id_bonus=me2.id_bonus"; try { acc.Open(); SqlDataAdapter dataAdapter = new SqlDataAdapter(tab_sql, acc); DataTable dt = new DataTable(); dataAdapter.Fill(dt); DatGridUser.DataSource = dt; _size(); } catch (SqlException ex) { MessageBox.Show(ex.ToString(), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc.Close(); } }
private void add_bt_Click(object sender, EventArgs e) { if (t_name.Text != "") { l_error.Text = ""; string into = @" BEGIN TRANSACTION; INSERT INTO Service (Service.Name, Service.Price, Service._delete) VALUES ('" + t_name.Text + "', '" + t_money.Text.Replace(",", ".") + "', 'False') COMMIT TRANSACTION;"; ToConnection str_add = new ToConnection(); SqlConnection acc_add = new SqlConnection(str_add.read_conf()); try { StreamPro _use = new StreamPro(); acc_add.Open(); SqlCommand comm_insert = new SqlCommand(into, acc_add); comm_insert.ExecuteNonQuery(); User_acc(); } catch (SqlException ex) { MessageBox.Show(ex.ToString(), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc_add.Close(); } } else l_error.Text = "Не все поля заполнены."; }
//Вставка данных в таблицу public void User_acc() { ToConnection str_config = new ToConnection(); SqlConnection acc = new SqlConnection(str_config.read_conf()); string tab_sql = @"Select me.id_service, me.Name, me.Price From Service me Where me._delete='False'"; try { acc.Open(); SqlDataAdapter dataAdapter = new SqlDataAdapter(tab_sql, acc); DataTable dt = new DataTable(); dataAdapter.Fill(dt); DatGridUser.DataSource = dt; _size(); } catch (SqlException ex) { MessageBox.Show(ex.ToString(), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc.Close(); } }
private void bt_add_sql(string FIO, string login, string password, int role, string _inform) { string s = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString(); ToConnection str_config = new ToConnection(); SqlConnection acc = new SqlConnection(str_config.read_conf()); string s1 = @"BEGIN TRANSACTION; INSERT INTO Access_User (Login, Pass, id_Role, NameInfoUser, Info_dop, Date, Date_iz, _delete) VALUES ('" + login + "', '" + password + "','" + role + "', '" + FIO + "', '" + _inform + "', '" + s + "','" + s + "','False') COMMIT TRANSACTION;"; try { acc.Open(); SqlCommand comm_insert = new SqlCommand(s1, acc); comm_insert.ExecuteNonQuery(); } catch (SqlException ex) { MessageBox.Show(ex.ToString(), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc.Close(); } }
//Вставка данных в таблицу public void User_acc() { ToConnection str_config = new ToConnection(); SqlConnection acc = new SqlConnection(str_config.read_conf()); string tab_sql = @"Select me.id_client, me.Number_card, me.Name, me.Date_reg, me.Sum_money, me3.NameInfoUser, me._inform_delete From Client me, Access_user me3 Where me.id_access = me3.id_access and me._delete='True'"; try { acc.Open(); SqlDataAdapter dataAdapter = new SqlDataAdapter(tab_sql, acc); DataTable dt = new DataTable(); dataAdapter.Fill(dt); DatGridUser.DataSource = dt; _size(); } catch (SqlException ex) { MessageBox.Show(ex.ToString(), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc.Close(); } }
private void b_add_Click(object sender, EventArgs e) { int role = cBox_role.SelectedIndex + 1; bool otv1 = false; string us_login = txt_login.Text; ToConnection str_config = new ToConnection(); SqlConnection acc = new SqlConnection(str_config.read_conf()); string tab_sql = @"Select me.Login From Access_User me Where me.Login='******';"; int count = 0; try { acc.Open(); SqlCommand s_User = new SqlCommand(tab_sql, acc); SqlDataReader read_sql = s_User.ExecuteReader(); while (read_sql.Read()) { count += 1; } if (count == 1) { otv1 = false; } else if (count == 0) { otv1 = true; } } catch (Exception ex) { MessageBox.Show(Convert.ToString(ex), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc.Close(); } if (otv1 == true) { if ((txt_login.Text != "") & (txt_FIO.Text != "") & (txt_pass.Text != "") & (role != 0)) { string login = txt_login.Text; string FIO = txt_FIO.Text; string password = txt_pass.Text; string _inform = t_info.Text; bt_add_sql(FIO, login, password, role, _inform); } else MessageBox.Show("Не все поля заполнены."); } else MessageBox.Show("Такой пользователь уже сущестует."); }
//Заполняем имена бонусов в c_bonus автоматически public void _select2() { ToConnection str_config = new ToConnection(); SqlConnection acc = new SqlConnection(str_config.read_conf()); string queryString1 = @"Select me.id_bonus, me.Name From Bonus me"; try { acc.Open(); SqlCommand cmd1 = new SqlCommand(queryString1, acc); SqlDataReader dr = cmd1.ExecuteReader(); while (dr.Read()) { c_Bonus.Items.Add(dr["Name"]); } } catch (Exception ex) { MessageBox.Show(Convert.ToString(ex), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc.Close(); } }
public void _select2() { ToConnection str_config = new ToConnection(); SqlConnection acc = new SqlConnection(str_config.read_conf()); string queryString1 = @"Select me.Name, me.id_currency From Currency me Where me._delete = 'False'"; try { acc.Open(); SqlCommand cmd1 = new SqlCommand(queryString1, acc); SqlDataReader dr1 = cmd1.ExecuteReader(); while (dr1.Read()) { c_money.Items.Add(dr1["Name"]); c_money.SelectedIndex = 0; id_currency = dr1["id_currency"].ToString(); } } catch (Exception ex) { MessageBox.Show(Convert.ToString(ex), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc.Close(); } }
//функция вписания в БД таблица Level_bns public void str(string _bonus) { ToConnection str_add = new ToConnection(); SqlConnection acc_add = new SqlConnection(str_add.read_conf()); string s = @"BEGIN TRANSACTION; INSERT INTO Level_bns (id_bonus, Name, level_min, level_max) VALUES ('" + _bonus + "','" + t_name.Text + "', '" + t_min.Text + "', '" + t_max.Text + "') COMMIT TRANSACTION;"; try { StreamPro _use = new StreamPro(); acc_add.Open(); SqlCommand comm_insert = new SqlCommand(s, acc_add); comm_insert.ExecuteNonQuery(); } catch (SqlException ex) { MessageBox.Show(ex.ToString(), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc_add.Close(); } User_acc(); }
private void button2_Click(object sender, EventArgs e) { string s = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString(); int ind_sql = Convert.ToInt32(DatGridUser.CurrentRow.Index.ToString()); string sim = DatGridUser[0, ind_sql].Value.ToString(); ToConnection str_add = new ToConnection(); SqlConnection acc_add = new SqlConnection(str_add.read_conf()); string s1 = @"BEGIN TRANSACTION; UPDATE Access_user SET Access_user._delete='False', Access_user.Date_iz='" + s + "'WHERE Access_user.id_access ='" + sim + "' COMMIT TRANSACTION;"; try { StreamPro _use = new StreamPro(); acc_add.Open(); SqlCommand comm_insert = new SqlCommand(s1, acc_add); comm_insert.ExecuteNonQuery(); User_acc(); } catch (SqlException ex) { MessageBox.Show(ex.ToString(), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc_add.Close(); } }
private void button1_Click(object sender, EventArgs e) { if (t_card.Text != "") { ToConnection st = new ToConnection(); this.DataTable3TableAdapter.Connection.ConnectionString = st.read_conf(); this.DataTable3TableAdapter.Fill(this.UsersSSQl.DataTable3, Convert.ToInt32(t_card.Text)); this.reportViewer1.RefreshReport(); } else MessageBox.Show("Введите номер карты"); }
private void button1_Click(object sender, EventArgs e) { if (date_1.Value <= date_2.Value) { DateTime date1 = new DateTime(date_1.Value.Year, date_1.Value.Month, date_1.Value.Day, 00, 00, 00); DateTime date2 = new DateTime(date_2.Value.Year, date_2.Value.Month, date_2.Value.Day, 23, 59, 00); ToConnection st = new ToConnection(); this.DataTable7TableAdapter.Connection.ConnectionString = st.read_conf(); this.DataTable7TableAdapter.Fill(this.UsersSSQl.DataTable7, date1, date2); this.reportViewer1.RefreshReport(); } else MessageBox.Show("Начальная дата не может быть больше даты окончания."); }
private void button1_Click(object sender, EventArgs e) { try { int ind_sql = Convert.ToInt32(DatGridUser.CurrentRow.Index.ToString()); string sim = DatGridUser[0, ind_sql].Value.ToString(); ToConnection str = new ToConnection(); string ac_commandText = @"select me.id_currency from Flow me where me.id_currency = '" + sim + "'"; SqlConnection connection = new SqlConnection(str.read_conf()); try { connection.Open(); SqlCommand accessUser = new SqlCommand(ac_commandText, connection); SqlDataReader read_sql = accessUser.ExecuteReader(); int count = 0; while (read_sql.Read()) { count += 1; } if (count == 0) { _delete(sim); } else if (count >= 1) { MessageBox.Show("Данный метод оплаты не может быть удален по скольку использовался ранее в пополнении денежных средст на счет.", "Внимание!", MessageBoxButtons.OK,MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { connection.Close(); } } catch { MessageBox.Show("Не выбран вид валюты.", "Внимание!", MessageBoxButtons.OK,MessageBoxIcon.Information); } }
//Проверка по данному удалению - если услуга используеться то ее нельзя удалить private void button1_Click(object sender, EventArgs e) { try { int ind_sql = Convert.ToInt32(DatGridUser.CurrentRow.Index.ToString()); string sim = DatGridUser[0, ind_sql].Value.ToString(); ToConnection str = new ToConnection(); string ac_commandText = @"select me.id_service from Expenses me where me.id_service = '" + sim + "'"; SqlConnection connection = new SqlConnection(str.read_conf()); try { connection.Open(); SqlCommand accessUser = new SqlCommand(ac_commandText, connection); SqlDataReader read_sql = accessUser.ExecuteReader(); int count = 0; while (read_sql.Read()) { count += 1; } if (count == 0) { _delete(sim); } else MessageBox.Show("Данная услуга использовалась в транзакциях. Удаление услуги невозможно.", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { connection.Close(); } } catch { MessageBox.Show("Услуга не выбрана.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
//кнопка редактирования private void b_edit_Click(object sender, EventArgs e) { string _bonus3 = ""; ToConnection str_id_bonus2 = new ToConnection(); SqlConnection acc_id_bonus2 = new SqlConnection(str_id_bonus2.read_conf()); string queryString3 = @"Select me.id_bonus From Bonus me where me.bonus = '0'"; try { acc_id_bonus2.Open(); SqlCommand cmd2 = new SqlCommand(queryString3, acc_id_bonus2); SqlDataReader dr2 = cmd2.ExecuteReader(); while (dr2.Read()) { _bonus3 = dr2["id_bonus"].ToString(); } } catch (Exception ex) { MessageBox.Show(Convert.ToString(ex), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc_id_bonus2.Close(); } bool mil = false; string _level = c_Bonus.Enabled.ToString(); bool sim = false; if (_level == "True") { if (c_Bonus.SelectedIndex != -1) { sim = true; mil = true; } else sim = false; } else sim = true; if (sim == true) { string _bonus = ""; if (mil == true) { //Поиск выбранных бонусов ToConnection str_id_bonus = new ToConnection(); SqlConnection acc_id_bonus = new SqlConnection(str_id_bonus.read_conf()); string queryString2 = @"Select me.id_bonus From Bonus me where me.Name = '" + c_Bonus.SelectedItem.ToString() + "'"; try { acc_id_bonus.Open(); SqlCommand cmd2 = new SqlCommand(queryString2, acc_id_bonus); SqlDataReader dr2 = cmd2.ExecuteReader(); while (dr2.Read()) { _bonus = dr2["id_bonus"].ToString(); } } catch (Exception ex) { MessageBox.Show(Convert.ToString(ex), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc_id_bonus.Close(); } } //поиск схожих номеров bool otv1 = false; int count = 0; ToConnection str_number = new ToConnection(); SqlConnection acc_number = new SqlConnection(str_number.read_conf()); string tab_sql = @"Select me.Number_card From Client me Where me.Number_card='" + t_num.Text + "';"; try { acc_number.Open(); SqlCommand s_User = new SqlCommand(tab_sql, acc_number); SqlDataReader read_sql = s_User.ExecuteReader(); while (read_sql.Read()) { count += 1; } if (count == 1) { otv1 = false; } else if (count == 0) { otv1 = true; } } catch (Exception ex) { MessageBox.Show(Convert.ToString(ex), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc_number.Close(); } if (otv1 == true) { l_error.Text = ""; if ((t_num.Text != "") & (t_fio.Text != "")) { _add_stream(_bonus, _level, _bonus3); l_error.Text = ""; } else l_error.Text = "Не заполнены поля:Номер карты или ФИО"; } else l_error.Text = "Такой номер карты уже существует."; } else l_error.Text = "Не выбрана скидка."; }
private void b_edit_Click(object sender, EventArgs e) { if (c_role.SelectedIndex != -1) { //Поиск выбранных бонусов string _role = ""; ToConnection str_id_bonus = new ToConnection(); SqlConnection acc_id_bonus = new SqlConnection(str_id_bonus.read_conf()); string queryString2 = @"Select me.id_role From Role me where me.Name_R = '" + c_role.SelectedItem.ToString() + "'"; try { acc_id_bonus.Open(); SqlCommand cmd2 = new SqlCommand(queryString2, acc_id_bonus); SqlDataReader dr2 = cmd2.ExecuteReader(); while (dr2.Read()) { _role = dr2["id_role"].ToString(); } } catch (Exception ex) { MessageBox.Show(Convert.ToString(ex), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc_id_bonus.Close(); } //поиск схожих логинов bool otv1 = false; int count = 0; ToConnection str_number = new ToConnection(); SqlConnection acc_number = new SqlConnection(str_number.read_conf()); string tab_sql = @"Select me.Login From Access_user me Where me.Login='******';"; try { acc_number.Open(); SqlCommand s_User = new SqlCommand(tab_sql, acc_number); SqlDataReader read_sql = s_User.ExecuteReader(); while (read_sql.Read()) { count += 1; } if (count == 1) { otv1 = false; } else if (count == 0) { otv1 = true; } } catch (Exception ex) { MessageBox.Show(Convert.ToString(ex), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc_number.Close(); } if (otv1 == true) { if ((t_login.Text != "") & (t_fio.Text != "") & (t_pass.Text != "") & (c_role.SelectedIndex != -1)) { l_error.Text = ""; up_ts(_role); } else l_error.Text = "Не все поля заполнены."; } else l_error.Text = "Такой логин существует."; } else l_error.Text = "Не выбраны права доступа."; }
//метод редактирования клиента private void _add_stream(string _bonus, string _level, string _bonus3) { string steam = Ustr._id; string s1 = ""; string s = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString(); ToConnection str_add = new ToConnection(); SqlConnection acc_add = new SqlConnection(str_add.read_conf()); if (_level == "False") { s1 = @"BEGIN TRANSACTION; UPDATE Client SET _level = 'True',Client.Number_card='" + t_num.Text + "' ,Client.Name='" + t_fio.Text + "' ,Client.Inform='" + r_info.Text + "' ,Client.id_bonus ='" + _bonus3 + "' WHERE Client.id_client ='" + Edit_cl._idser + "' COMMIT TRANSACTION;"; } else if (_level == "True") { s1 = @" BEGIN TRANSACTION; UPDATE Client SET _level='False', Client.Number_card='" + t_num.Text + "' ,Client.Name='" + t_fio.Text + "' ,Client.Inform='" + r_info.Text + "' ,Client.id_bonus ='" + _bonus + "' WHERE Client.id_client ='" + Edit_cl._idser + "' COMMIT TRANSACTION;"; } try { StreamPro _use = new StreamPro(); acc_add.Open(); SqlCommand comm_insert = new SqlCommand(s1, acc_add); comm_insert.ExecuteNonQuery(); } catch (SqlException ex) { MessageBox.Show(ex.ToString(), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc_add.Close(); } }
private void limb() { string _bonus3 = ""; ToConnection str_id_bonus2 = new ToConnection(); SqlConnection acc_id_bonus2 = new SqlConnection(str_id_bonus2.read_conf()); string queryString3 = @"Select me.id_bonus From Bonus me where me.bonus = '0'"; try { acc_id_bonus2.Open(); SqlCommand cmd2 = new SqlCommand(queryString3, acc_id_bonus2); SqlDataReader dr2 = cmd2.ExecuteReader(); while (dr2.Read()) { _bonus3 = dr2["id_bonus"].ToString(); } if (_bonus3 != "") { checkedListBox1.Enabled = true; } else { checkedListBox1.Enabled = false; MessageBox.Show("Для использования уровней бонусной системы необходимо создать Нулевой бонус!", "Предупреждение!", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(Convert.ToString(ex), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc_id_bonus2.Close(); } }
private void b_ConnetTo_BD_Click(object sender, EventArgs e) { ToConnection str=new ToConnection(); string _user = b_login.Text; int s = 0; string _use = ""; string _name=""; string ac_commandText = @"select * from Access_User where LTRIM(RTRIM(Access_User.Login)) collate Cyrillic_General_CS_AS like '" + b_login .Text + "'and LTRIM(RTRIM(Access_User.Pass)) collate Cyrillic_General_CS_AS like '" + b_pass.Text + "'"; SqlConnection connection = new SqlConnection(str.read_conf()); try { connection.Open(); string steamkread=""; SqlCommand accessUser = new SqlCommand(ac_commandText, connection); SqlDataReader read_sql = accessUser.ExecuteReader(); int count = 0; /*Цикл с условием: Пока читаю строки - счетчик +1(если счетчик 1 значит есть такая запись+открытие формы) * иначе необходимо проверить логин и пароль * */ while (read_sql.Read()) { _use = read_sql["id_access"].ToString(); s = Convert.ToInt16(read_sql["id_role"].ToString()); _name = read_sql["NameInfoUser"].ToString();; count += 1; Ustr._id = _use; Ustr._user = _name; steamkread = read_sql["_delete"].ToString(); } if (steamkread != "True") { if (count == 1) { if (s == 1) { StreamPro connect_SreamPro = new StreamPro(); connect_SreamPro.Text = "Касса"; connect_SreamPro._load(); connect_SreamPro.ShowDialog(); } if (s == 2) { StreamPro connect_SreamPro = new StreamPro(); connect_SreamPro.Text = "Бухгалтерия"; connect_SreamPro._load(); connect_SreamPro.ShowDialog(); } if (s == 3) { Adm_User connect_SreamPro = new Adm_User(); connect_SreamPro.ShowDialog(); } } else if (count == 0) { MessageBox.Show("Вы неправильно ввели логин или пароль", "Внимание!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } else MessageBox.Show("Данный пользователь удален администратором", "Внимание!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } catch(Exception ex) { MessageBox.Show(ex.Message.ToString()); } finally { connection.Close(); } }
//метод снятия private void _remove(string star_del) { ToConnection str_config = new ToConnection(); SqlConnection acc = new SqlConnection(str_config.read_conf()); string tab_sql = @" BEGIN TRANSACTION; UPDATE Client SET Client._delete = 'False' Where Client.id_client='" + star_del + "' COMMIT TRANSACTION;"; try { acc.Open(); SqlCommand s_User = new SqlCommand(tab_sql, acc); s_User.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc.Close(); } }
private void button1_Click(object sender, EventArgs e) { try { int ind_sql = Convert.ToInt32(DatGridUser.CurrentRow.Index.ToString()); string sim = DatGridUser[0, ind_sql].Value.ToString(); ToConnection str_add = new ToConnection(); SqlConnection acc_add = new SqlConnection(str_add.read_conf()); string s1 = @" BEGIN TRANSACTION; UPDATE Service SET Service._delete='True' WHERE Service.id_service ='" + sim + "' COMMIT TRANSACTION;"; try { StreamPro _use = new StreamPro(); acc_add.Open(); SqlCommand comm_insert = new SqlCommand(s1, acc_add); comm_insert.ExecuteNonQuery(); User_acc(); } catch (SqlException ex) { MessageBox.Show(ex.ToString(), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc_add.Close(); } } catch { l_error.Text = "Не выбрана услуга."; } }
private void edit_bt_Click(object sender, EventArgs e) { if ((t_Name.Text != "") & (textBox2.Text != "")) { int ind_sql = Convert.ToInt32(DatGridUser.CurrentRow.Index.ToString()); string sim = DatGridUser[0, ind_sql].Value.ToString(); ToConnection str_add = new ToConnection(); SqlConnection acc_add = new SqlConnection(str_add.read_conf()); string s1 = @"BEGIN TRANSACTION; UPDATE Bonus SET Bonus.Name='" + t_Name.Text + "' ,Bonus.bonus='" + textBox2.Text + "'WHERE Bonus.id_bonus ='" + sim + "' COMMIT TRANSACTION;"; try { StreamPro _use = new StreamPro(); acc_add.Open(); SqlCommand comm_insert = new SqlCommand(s1, acc_add); comm_insert.ExecuteNonQuery(); User_acc(); } catch (SqlException ex) { MessageBox.Show(ex.ToString(), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc_add.Close(); } } else l_error.Text = "Заполните все поля справочника услуги."; }
private void delete_bt_Click(object sender, EventArgs e) { try { int ind_sql = Convert.ToInt32(DatGridUser.CurrentRow.Index.ToString()); string sim = DatGridUser[0, ind_sql].Value.ToString(); ToConnection str = new ToConnection(); string ac_commandText = @"select me.id_bonus from Client me where me.id_bonus = '" + sim + "'"; SqlConnection connection = new SqlConnection(str.read_conf()); try { l_error.Text = ""; connection.Open(); SqlCommand accessUser = new SqlCommand(ac_commandText, connection); SqlDataReader read_sql = accessUser.ExecuteReader(); int count = 0; while (read_sql.Read()) { count += 1; } if (count == 0) { _delete(sim); } else if (count >= 1) { l_error.Text = "Данный бонус уже используеться. Удалить нельзя."; } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { connection.Close(); } } catch { l_error.Text = "Не выбран бонус."; } }
private void edit_bt_Click(object sender, EventArgs e) { if (t_name.Text != "") { int ind_sql = Convert.ToInt32(DatGridUser.CurrentRow.Index.ToString()); string sim = DatGridUser[0, ind_sql].Value.ToString(); ToConnection str_add = new ToConnection(); SqlConnection acc_add = new SqlConnection(str_add.read_conf()); string s1 = @" BEGIN TRANSACTION; UPDATE Service SET Service.Name='" + t_name.Text + "' ,Service.Price='" + t_money.Text.Replace(",", ".") + "'WHERE Service.id_service ='" + sim + "' COMMIT TRANSACTION;"; try { StreamPro _use = new StreamPro(); acc_add.Open(); SqlCommand comm_insert = new SqlCommand(s1, acc_add); comm_insert.ExecuteNonQuery(); User_acc(); } catch (SqlException ex) { MessageBox.Show(ex.ToString(), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc_add.Close(); } } else l_error.Text = "Не все поля заполнены."; }
private void _delete(string sim) { ToConnection str_config = new ToConnection(); SqlConnection acc = new SqlConnection(str_config.read_conf()); string tab_sql = @"BEGIN TRANSACTION; DELETE From Service Where Service.id_service='" + sim + "'; COMMIT TRANSACTION;"; try { acc.Open(); SqlCommand s_User = new SqlCommand(tab_sql, acc); s_User.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc.Close(); } }
//кнопка добавить с условиями private void add_bt_Click(object sender, EventArgs e) { //Поиск максимального числа в МАХ для сравнения с предыдущем string _sill = ""; ToConnection str_id_bonus2 = new ToConnection(); SqlConnection acc_id_bonus2 = new SqlConnection(str_id_bonus2.read_conf()); string queryString3 = @"Select Max(me.level_max) as Simm From Level_bns me"; try { acc_id_bonus2.Open(); SqlCommand cmd2 = new SqlCommand(queryString3, acc_id_bonus2); SqlDataReader dr2 = cmd2.ExecuteReader(); while (dr2.Read()) { if (dr2["Simm"].ToString() != "") { _sill = dr2["Simm"].ToString(); } else _sill = "0"; } } catch (Exception ex) { MessageBox.Show(Convert.ToString(ex), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc_id_bonus2.Close(); } //Проверка если он залезет в диапозон в других уровней if (Convert.ToDouble(t_min.Text) > Convert.ToDouble(_sill)) { //Проверка правильность МАХ и МIN if (Convert.ToInt32(t_min.Text) < Convert.ToInt32(t_max.Text)) { //Выбран ли бонус if (c_Bonus.SelectedIndex != -1) { string _bonus = ""; //Поиск выбранных бонусов ToConnection str_id_bonus = new ToConnection(); SqlConnection acc_id_bonus = new SqlConnection(str_id_bonus.read_conf()); string queryString2 = @"Select me.id_bonus From Bonus me where me.Name = '" + c_Bonus.SelectedItem.ToString() + "'"; try { acc_id_bonus.Open(); SqlCommand cmd2 = new SqlCommand(queryString2, acc_id_bonus); SqlDataReader dr2 = cmd2.ExecuteReader(); while (dr2.Read()) { _bonus = dr2["id_bonus"].ToString(); } } catch (Exception ex) { MessageBox.Show(Convert.ToString(ex), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc_id_bonus.Close(); } //Поиск идентичного бонуса bool otv1 = false; int count = 0; ToConnection str_number = new ToConnection(); SqlConnection acc_number = new SqlConnection(str_number.read_conf()); string tab_sql = @"Select me.id_bonus From Level_bns me Where me.id_bonus='" + _bonus + "';"; try { acc_number.Open(); SqlCommand s_User = new SqlCommand(tab_sql, acc_number); SqlDataReader read_sql = s_User.ExecuteReader(); while (read_sql.Read()) { count += 1; } if (count == 1) { otv1 = false; } else if (count == 0) { otv1 = true; } } catch (Exception ex) { MessageBox.Show(Convert.ToString(ex), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc_number.Close(); } if (otv1 == true) { l_error.Text = ""; if ((t_min.Text != "") & (t_max.Text != "")) { str(_bonus); l_error.Text = ""; } else l_error.Text = "Не все поля заполнены."; } else l_error.Text = "Такой бонус в уровне уже существует."; } else l_error.Text = "Не выбран бонус для уровня."; } else l_error.Text = "Min не может быть больше MAX."; } else l_error.Text = "Такой уровень уже есть."; }
//удаление бонусов private void delete_bt_Click(object sender, EventArgs e) { int ind_sql = Convert.ToInt32(DatGridUser.CurrentRow.Index.ToString()); string sim = DatGridUser[0, ind_sql].Value.ToString(); ToConnection str_config = new ToConnection(); SqlConnection acc = new SqlConnection(str_config.read_conf()); string tab_sql = @"BEGIN TRANSACTION; DELETE From Level_bns COMMIT TRANSACTION;"; try { acc.Open(); SqlCommand s_User = new SqlCommand(tab_sql, acc); s_User.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc.Close(); } User_acc(); }