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 = "Не все поля заполнены."; }
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(); } }
//функция вписания в БД таблица 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 _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 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 != "") { 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 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 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 _add_stream(string _bonus, string _level, string _bonus3) { string s=""; string steam = Ustr._id; string s1 = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString(); ToConnection str_add = new ToConnection(); SqlConnection acc_add = new SqlConnection(str_add.read_conf()); if (_level == "False") { s = @"BEGIN TRANSACTION; INSERT INTO Client (id_access, id_bonus, Number_card, Name, Inform, Date_reg, _delete, Block, Sum_Expenses, Sum_Flow, _level) VALUES ('" + steam + "', '" + _bonus3 + "','" + t_number.Text + "', '" + t_FIO.Text + "', '" + r_info.Text + "','" + s1 + "','False','False','0','0', 'True') COMMIT TRANSACTION;"; } else if (_level == "True") { s = @"BEGIN TRANSACTION; INSERT INTO Client (id_access, id_bonus, Number_card, Name, Inform, Date_reg, _delete, Block, Sum_Expenses, Sum_Flow, _level) VALUES ('" + steam + "','" + _bonus + "', '" + t_number.Text + "', '" + t_FIO.Text + "', '" + r_info.Text + "','" + s1 + "','False','False','0','0', 'False') 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(); } }
private void _add_stream() { double dim = (Convert.ToDouble(tex_money.Text)*Convert.ToDouble(Ustr._sim))*0.01; string s = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString(); ToConnection str_add = new ToConnection(); SqlConnection acc_add = new SqlConnection(str_add.read_conf()); string s2 = @"BEGIN TRANSACTION; INSERT INTO Flow (id_access, id_currency, id_client, Date, Sum, Sum_bonus) VALUES ('" + Ustr._id + "','" + id_currency + "', '" + Ustr._id_clients + "', '" + s + "', '" + tex_money.Text.Replace(",", ".") + "', '" + Convert.ToString(dim).Replace(",", ".") + "'); COMMIT TRANSACTION;"; try { StreamPro _use = new StreamPro(); acc_add.Open(); SqlCommand comm_insert = new SqlCommand(s2, acc_add); comm_insert.ExecuteNonQuery(); t_time_m = s; sum_bns_m = Convert.ToString(dim); } catch (SqlException ex) { MessageBox.Show(ex.ToString(), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc_add.Close(); } }
private void _add_money() { double sum = Convert.ToDouble(tex_money.Text) +((Convert.ToDouble(tex_money.Text)*Convert.ToDouble(Ustr._sim))*0.01); ToConnection str_add = new ToConnection(); SqlConnection acc_add = new SqlConnection(str_add.read_conf()); string s1 = @"BEGIN TRANSACTION; UPDATE Client SET Sum_Flow +='" + Convert.ToString(sum).Replace(",",".") + "' WHERE Client.Number_card = '" + t_moneys.Text + "'; COMMIT TRANSACTION;"; try { StreamPro _use = new StreamPro(); acc_add.Open(); SqlCommand comm_update = new SqlCommand(s1, acc_add); comm_update.ExecuteNonQuery(); sum_m = Convert.ToString(sum); } catch (SqlException ex) { MessageBox.Show(ex.ToString(), "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { acc_add.Close(); } }
private void button2_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 Currency SET Currency._delete='False' WHERE Currency.id_currency ='" + 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 { MessageBox.Show("Не выбран вид валюты.", "Внимание!", MessageBoxButtons.OK,MessageBoxIcon.Information); } }