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("Ошибка паролей", "Введенные пароли не совпадают. " +
"Пожалуйста, проверьте правильность введённых паролей.");
}
}
}