private void InsFinOperation() { string query_FinOper = "INSERT INTO Операция VALUES('" + metroTextBoxNamFinOperation.Text + "')"; manipulationDB.Insert(query_FinOper); metroTextBoxNamFinOperation.Text = null; }
private void InsMoney() { string query_Money = "INSERT INTO Валюта VALUES('" + metroTextBoxNamMoney.Text + "','" + metroTextBoxNamMoneyL.Text + "')"; manipulationDB.Insert(query_Money); metroTextBoxNamMoney.Text = null; metroTextBoxNamMoneyL.Text = null; }
private void InsPass() { string insPass = "******" + metroTextBoxFio.Text + "', '" + metroTextBoxSin.Text + "'," + "'" + shifr_PBKDF2.Encrypt(Convert.ToString(metroTextBoxIdentifity.Text), "204503") + "')"; manipulationDB.Insert(insPass); metroTextBoxFio.Text = null; metroTextBoxSin.Text = null; metroTextBoxIdentifity.Text = null; }
private void InsNewBank() { string queryInsBank = "INSERT INTO Банк " + "VALUES('" + metroComboBoxBank.SelectedValue + "','" + metroComboBoxOrg.SelectedValue + "'," + "'" + metroTextBoxRank.Text + "','" + metroTextBoxDateReg.Text + "','" + metroTextBoxSum.Text + "','" + metroComboBoxVal.SelectedValue + "')"; manipulationDB.Insert(queryInsBank); metroTextBoxRank.Text = null; metroTextBoxDateReg.Text = null; metroTextBoxSum.Text = null; }
private void InsOrganization() { string query_Organiz = "INSERT INTO Организация " + "VALUES('" + metroTextBoxNamOrg.Text + "', '" + metroTextBoxDateReg.Text + "', " + "'" + metroTextBoxUrAddress.Text + "', '" + metroTextBoxFactAddress.Text + "')"; manipulationDB.Insert(query_Organiz); metroTextBoxNamOrg.Text = null; metroTextBoxDateReg.Text = null; metroTextBoxUrAddress.Text = null; metroTextBoxFactAddress.Text = null; }
private void RegUser() { bool validationUser = false; string queryUser = "******" + tbUser.Text + "'"; connect.Open(); SqlCommand comm = new SqlCommand(queryUser, connect); if (comm.ExecuteScalar() == null) { validationUser = false; } else { validationUser = true; } connect.Close(); if (validationUser == true) { MessageBox.Show("Пожалуйста, придумайте другое имя пользователю!", "Ошибка регистрации"); } else { int admin = 0; admin = chbAdmin.Checked == true ? 1 : 0; if (tbPassword.Text == tbPasswordRepeat.Text) { string queryRegistrUser = "******" + tbUser.Text + "', " + "'" + shifr_PBKDF2.Encrypt(Convert.ToString(tbPassword.Text), "204503") + "'," + "'" + admin + "' )"; manipulationDB.Insert(queryRegistrUser); tbUser.Text = null; tbPassword.Text = null; tbPasswordRepeat.Text = null; chbAdmin.Checked = false; MessageBox.Show("Успешно", "Регистрация пользователя прошла успешно!"); } else { MessageBox.Show("Ошибка паролей", "Введенные пароли не совпадают. " + "Пожалуйста, проверьте правильность введённых паролей."); } } }