private void TextBoxLogin_TextChanged(object sender, EventArgs e) { Class.HashMD5 HMD5 = new Class.HashMD5(); string LoginMD5 = HMD5.GetHashString(textBoxLogin.Text); //хеширование логина string checkLogin = "******" + LoginMD5 + "'"; MySqlCommand cmdCheckLogin = new MySqlCommand(checkLogin, connect); connect.Open(); cmdCheckLogin.Prepare(); int countLogin = Convert.ToInt32(cmdCheckLogin.ExecuteScalar()); if (countLogin == 0 && textBoxLogin.Text != "") { labelErrorLogin.Show(); labelErrorLogin.ForeColor = Color.FromArgb(12, 165, 47); labelErrorLogin.Text = "Ок"; buttonRegistration.Enabled = true; connect.Close(); } else { buttonRegistration.Enabled = false; labelErrorLogin.Text = "Логин занят"; labelErrorLogin.ForeColor = Color.FromArgb(128, 0, 0); connect.Close(); } }
private void Form1_Load(object sender, EventArgs e) { connect.Open(); Class.HashMD5 HMD5 = new Class.HashMD5(); string LoginMD5 = HMD5.GetHashString(Settings.Default["Login"].ToString()); string Dday = "SELECT Day FROM ditetimepicker"; string Mmonth = "SELECT Month FROM ditetimepicker"; MySqlCommand cmdDday = new MySqlCommand(Dday, connect); MySqlCommand cmdMmonth = new MySqlCommand(Mmonth, connect); int DdayInt = Convert.ToInt32(cmdDday.ExecuteScalar()); int MmonthInt = Convert.ToInt32(cmdMmonth.ExecuteScalar()); DateTime Now = DateTime.Now; int Year = Now.Year; DateTime dt = new DateTime(Year, MmonthInt, DdayInt); TimeSpan TimeRemaining = dt - DateTime.Now; label11.Text = TimeRemaining.Days + " дней"; connect.Close(); }
private void Hello_Load(object sender, EventArgs e) { Class.HashMD5 HMD5 = new Class.HashMD5(); string LoginMD5 = HMD5.GetHashString(Settings.Default["Login"].ToString()); string checkUser = "******" + LoginMD5 + "';"; string checkAdmin = "SELECT count(*) FROM admin WHERE Login = '******';"; connect.Open(); MySqlCommand cmdCheckUser = new MySqlCommand(checkUser, connect); MySqlCommand cmdCheckAdmin = new MySqlCommand(checkAdmin, connect); cmdCheckUser.Prepare(); cmdCheckAdmin.Prepare(); int countUser = Convert.ToInt32(cmdCheckUser.ExecuteScalar()); int countAdmin = Convert.ToInt32(cmdCheckAdmin.ExecuteScalar()); if (countUser == 1) { string FIOuser = "******" + LoginMD5 + "';"; MySqlCommand cmdFIOuser = new MySqlCommand(FIOuser, connect); //юзер cmdFIOuser.Parameters.AddWithValue("@Login", labelname.Text); MySqlDataReader reader = cmdFIOuser.ExecuteReader(); while (reader.Read()) { labelname.Text = reader["Surname"].ToString() + " " + reader["Name"].ToString() + " " + reader["Middlename"].ToString(); Settings.Default["Surname"] = reader["Surname"].ToString(); Settings.Default["Name"] = reader["Name"].ToString(); Settings.Default["Middlename"] = reader["Middlename"].ToString(); Settings.Default.Save(); } reader.Close(); } if (countAdmin == 1) { string FIOadmin = "SELECT Surname, Name, Middlename FROM admin WHERE Login = '******';"; MySqlCommand cmdFIOadmin = new MySqlCommand(FIOadmin, connect); cmdFIOadmin.Parameters.AddWithValue("@Login", labelname.Text); MySqlDataReader reader = cmdFIOadmin.ExecuteReader(); while (reader.Read()) { labelname.Text = reader["Surname"].ToString() + " " + reader["Name"].ToString() + " " + reader["Middlename"].ToString(); Settings.Default["Surname"] = reader["Surname"].ToString(); Settings.Default["Name"] = reader["Name"].ToString(); Settings.Default["Middlename"] = reader["Middlename"].ToString(); Settings.Default.Save(); } reader.Close(); } connect.Close(); }
private void Button2_Click(object sender, EventArgs e) { if (textBox1.Text != "") { connect.Open(); string checkAdmin = "SELECT count(*) FROM Admin WHERE Login = '******';"; //юзер MySqlCommand cmdcheckAdmin = new MySqlCommand(checkAdmin, connect); int countAdmin = Convert.ToInt32(cmdcheckAdmin.ExecuteScalar()); if (countAdmin == 1) { if (textBox1.Text != Settings.Default["Password"].ToString()) { string updatePassword = "******" + textBox1.Text + "' WHERE Login = '******'"; MySqlCommand cmdupdatePassword = new MySqlCommand(updatePassword, connect); cmdupdatePassword.ExecuteNonQuery(); labelPassword.Text = textBox1.Text; connect.Close(); } else { MessageBox.Show("Пароли совпадают, введите новый пароль"); connect.Close(); } } else { Class.HashMD5 HMD5 = new Class.HashMD5(); string LoginMD5 = HMD5.GetHashString(Settings.Default["Login"].ToString()); string PasswordMD5 = HMD5.GetHashString(textBox1.Text); if (textBox1.Text != PasswordMD5) { string updatePassword = "******" + PasswordMD5 + "' WHERE Login = '******'"; MySqlCommand cmdupdatePassword = new MySqlCommand(updatePassword, connect); cmdupdatePassword.ExecuteNonQuery(); labelPassword.Text = textBox1.Text; connect.Close(); } else { MessageBox.Show("Пароли совпадают, введите новый пароль"); connect.Close(); } } } }
private void ButtonToComeIn_Click(object sender, EventArgs e) { counter++; Class.HashMD5 HMD5 = new Class.HashMD5(); string LoginMD5 = HMD5.GetHashString(textBox1.Text); string PasswordMD5 = HMD5.GetHashString(textBox2.Text); if (radioButtonUser.Checked == true) //юзер { connect.Open(); string checkUser = "******" + LoginMD5 + "' AND Password='******'"; //юзер MySqlCommand cmdcheckUser = new MySqlCommand(checkUser, connect); //юзер int countUser = Convert.ToInt32(cmdcheckUser.ExecuteScalar()); //string checkUser = "******" + LoginMD5 + "' AND Password='******'"; //юзер //MySqlCommand cmdcheckUser = new MySqlCommand(checkUser, connect); //юзер //int countUser = Convert.ToInt32(cmdcheckUser.ExecuteScalar()); if (text1 == textBoxCap.Text) { if (textBox1.Text != "" && textBox2.Text != "") { if (countUser == 1) { Settings.Default["Login"] = textBox1.Text; Settings.Default["Password"] = textBox2.Text; Settings.Default.Save(); Hello hello = new Hello(); this.Hide(); hello.ShowDialog(); } else if (counter >= 3) // лимит превышен { textBox1.Enabled = false; textBox2.Enabled = false; buttonToComeIn.Enabled = false; } else { MessageBox.Show("Неверно введён логин/пароль", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("Не все поля введены", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("Введите капчу"); } connect.Close(); } if (radioButtonAdmin.Checked == true) //админ { connect.Open(); string checkAdmin = "SELECT count(*) FROM Admin WHERE Login='******'"; //админ MySqlCommand cmdcheckAdmin = new MySqlCommand(checkAdmin, connect); //админ int countAdmin = Convert.ToInt32(cmdcheckAdmin.ExecuteScalar()); if (textBox1.Text != "" && textBox2.Text != "") { if (countAdmin == 1) { Settings.Default["Login"] = textBox1.Text; Settings.Default["Password"] = textBox2.Text; Settings.Default.Save(); Hello hello = new Hello(); this.Hide(); hello.ShowDialog(); } else if (counter >= 3) // лимит превышен { textBox1.Enabled = false; textBox2.Enabled = false; buttonToComeIn.Enabled = false; } else { MessageBox.Show("Неверно введён логин/пароль", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("Не все поля введены", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Information); } connect.Close(); } }
private void Buttoncapt_Click(object sender, EventArgs e) { var name = Settings.Default["Name"].ToString(); var surname = Settings.Default["Surname"].ToString(); Class.HashMD5 HMD5 = new Class.HashMD5(); string LoginMD5 = HMD5.GetHashString(Settings.Default["Login"].ToString()); connect.Open(); string numberPassUser = "******" + LoginMD5 + "';"; MySqlCommand cmdNumberPassUser = new MySqlCommand(numberPassUser, connect); object numberPassUserObj = cmdNumberPassUser.ExecuteScalar(); var doc = Convert.ToString(numberPassUserObj); var chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789"; var stringChars = new char[5]; for (int i = 0; i < stringChars.Length; i++) { stringChars[i] = chars[rnd.Next(chars.Length)]; } var numberBooking = new String(stringChars); var dateNow = DateTime.Now; var h = rnd.Next(0, 23); var m = rnd.Next(0, 59); var dateDeparture = dateTimePicker1.Value.ToString("dd.MM.yyyy"); var dateArrival = dateTimePicker2.Value.ToString("dd.MM.yyyy");; var dateClockDeparture = dateTimePicker1.Value.ToString("hh:mm"); var dateClockArrival = $"{h}:{m}"; var countrydepart = comboBox1.SelectedItem.ToString().TrimStart(); var countryArrival = comboBox2.SelectedItem.ToString().TrimStart(); string rndAirplane = "SELECT NameAircraft FROM Aircraft WHERE IDAircraft = " + rnd.Next(1, 8) + ";"; MySqlCommand cmdRndAirplane = new MySqlCommand(rndAirplane, connect); object rndAirplaneObj = cmdRndAirplane.ExecuteScalar(); connect.Close(); var Aircraft = Convert.ToString(rndAirplaneObj); var priceT = rnd.Next(7000, 10000); var priceTF = rnd.Next(4000, 5000); var priceMain = priceT + priceTF; this.TopMost = false; var wordApp = new Word.Application(); wordApp.Visible = false; try { var wordDocument = wordApp.Documents.Open(TemplateFileName); ReplaceWordStub("{name}", name, wordDocument); ReplaceWordStub("{surname}", surname, wordDocument); ReplaceWordStub("{doc}", doc, wordDocument); ReplaceWordStub("{numberBooking}", numberBooking, wordDocument); ReplaceWordStub("{numberBooking}", numberBooking, wordDocument); ReplaceWordStub("{dateNow}", dateNow.ToString(), wordDocument); int iT = Convert.ToInt32(Settings.Default["iTicket"]); ++iT; Settings.Default["iTicket"] = iT.ToString(); Settings.Default.Save(); ReplaceWordStub("{dateDeparture}", dateDeparture, wordDocument); ReplaceWordStub("{countrydepart}", countrydepart, wordDocument); ReplaceWordStub("{dateClockDeparture}", dateClockDeparture, wordDocument); ReplaceWordStub("{dateArrival}", Convert.ToString(dateArrival), wordDocument); ReplaceWordStub("{countryArrival}", countryArrival, wordDocument); ReplaceWordStub("{dateClockArrival}", dateClockArrival, wordDocument); ReplaceWordStub("{Aircraft}", Aircraft, wordDocument); ReplaceWordStub("{priceT}", Convert.ToString(priceT), wordDocument); ReplaceWordStub("{priceTF}", Convert.ToString(priceTF), wordDocument); ReplaceWordStub("{priceMain}", Convert.ToString(priceMain), wordDocument); if (Convert.ToInt32(Settings.Default["iTicket"]) <= 9) { Settings.Default["numTicket"] = "00000" + Settings.Default["iTicket"].ToString(); var numTicket = Settings.Default["numTicket"].ToString(); connect.Open(); string addUser = "******" + "VALUES('" + numTicket + "', '" + numberBooking + "', '" + dateNow + "', '" + name + "', '" + surname + "', '" + Aircraft + "', '" + dateDeparture + "', '" + dateArrival + "', '" + countrydepart + "', '" + countryArrival + "', '" + priceMain + "');"; MySqlCommand cmdAddUser = new MySqlCommand(addUser, connect); cmdAddUser.ExecuteNonQuery(); connect.Close(); ReplaceWordStub("{numTicket}", numTicket, wordDocument); } if (Convert.ToInt32(Settings.Default["iTicket"]) >= 10 && Convert.ToInt32(Settings.Default["iTicket"]) <= 99) { Settings.Default["numTicket"] = "0000" + Settings.Default["iTicket"].ToString(); var numTicket = Settings.Default["numTicket"].ToString(); connect.Open(); string addUser = "******" + "VALUES('" + numTicket + "', '" + numberBooking + "', '" + dateNow + "', '" + name + "', '" + surname + "', '" + Aircraft + "', '" + dateDeparture + "', '" + dateArrival + "', '" + countrydepart + "', '" + countryArrival + "', '" + priceMain + "');"; MySqlCommand cmdAddUser = new MySqlCommand(addUser, connect); cmdAddUser.ExecuteNonQuery(); connect.Close(); ReplaceWordStub("{numTicket}", numTicket, wordDocument); } if (Convert.ToInt32(Settings.Default["iTicket"]) >= 100 && Convert.ToInt32(Settings.Default["iTicket"]) <= 999) { Settings.Default["numTicket"] = "000" + Settings.Default["iTicket"].ToString(); var numTicket = Settings.Default["numTicket"].ToString(); connect.Open(); string addUser = "******" + "VALUES('" + numTicket + "', '" + numberBooking + "', '" + dateNow + "', '" + name + "', '" + surname + "', '" + Aircraft + "', '" + dateDeparture + "', '" + dateArrival + "', '" + countrydepart + "', '" + countryArrival + "', '" + priceMain + "');"; MySqlCommand cmdAddUser = new MySqlCommand(addUser, connect); cmdAddUser.ExecuteNonQuery(); connect.Close(); ReplaceWordStub("{numTicket}", numTicket, wordDocument); } if (Convert.ToInt32(Settings.Default["iTicket"]) >= 1000 && Convert.ToInt32(Settings.Default["iTicket"]) <= 9999) { Settings.Default["numTicket"] = "00" + Settings.Default["iTicket"].ToString(); var numTicket = Settings.Default["numTicket"].ToString(); connect.Open(); string addUser = "******" + "VALUES('" + numTicket + "', '" + numberBooking + "', '" + dateNow + "', '" + name + "', '" + surname + "', '" + Aircraft + "', '" + dateDeparture + "', '" + dateArrival + "', '" + countrydepart + "', '" + countryArrival + "', '" + priceMain + "');"; MySqlCommand cmdAddUser = new MySqlCommand(addUser, connect); cmdAddUser.ExecuteNonQuery(); connect.Close(); ReplaceWordStub("{numTicket}", numTicket, wordDocument); } if (Convert.ToInt32(Settings.Default["iTicket"]) >= 10000 && Convert.ToInt32(Settings.Default["iTicket"]) <= 99999) { Settings.Default["numTicket"] = "0" + Settings.Default["iTicket"].ToString(); var numTicket = Settings.Default["numTicket"].ToString(); connect.Open(); string addUser = "******" + "VALUES('" + numTicket + "', '" + numberBooking + "', '" + dateNow + "', '" + name + "', '" + surname + "', '" + Aircraft + "', '" + dateDeparture + "', '" + dateArrival + "', '" + countrydepart + "', '" + countryArrival + "', '" + priceMain + "');"; MySqlCommand cmdAddUser = new MySqlCommand(addUser, connect); cmdAddUser.ExecuteNonQuery(); connect.Close(); ReplaceWordStub("{numTicket}", numTicket, wordDocument); } if (Convert.ToInt32(Settings.Default["iTicket"]) >= 100000 && Convert.ToInt32(Settings.Default["iTicket"]) <= 999999) { Settings.Default["numTicket"] = Settings.Default["iTicket"].ToString(); var numTicket = Settings.Default["numTicket"].ToString(); connect.Open(); string addUser = "******" + "VALUES('" + numTicket + "', '" + numberBooking + "', '" + dateNow + "', '" + name + "', '" + surname + "', '" + Aircraft + "', '" + dateDeparture + "', '" + dateArrival + "', '" + countrydepart + "', '" + countryArrival + "', '" + priceMain + "');"; MySqlCommand cmdAddUser = new MySqlCommand(addUser, connect); cmdAddUser.ExecuteNonQuery(); connect.Close(); ReplaceWordStub("{numTicket}", numTicket, wordDocument); } SaveFileDialog sfd = new SaveFileDialog(); sfd.Filter = "Word Documents (*.docx)|*.docx|All files (*.*)|*.*"; sfd.FileName = surname + name + "AirTicket.docx"; if (sfd.ShowDialog() == DialogResult.OK) { wordDocument.SaveAs(sfd.FileName); MessageBox.Show("Успешно!"); PrintDialog printDialog = new PrintDialog(); if (printDialog.ShowDialog() == DialogResult.OK) { wordDocument.PrintPreview(); } } wordDocument.Close(); } catch (Exception ex) { MessageBox.Show("Произошла ошибка: " + ex.Message); connect.Close(); } finally { wordApp.Quit(); connect.Close(); } }
private void ProfileF() { textBoxSurname.Hide(); textBoxName.Hide(); textBoxMiddlename.Hide(); textBoxPhone.Hide(); textBoxEmail.Hide(); buttonSave.Hide(); panel5.Hide(); string myConnectionString = "Database = AirTO; Data Source = localhost; User Id=root; charset= utf8; Password ="******"Login"].ToString()); string checkUser = "******" + LoginMD5 + "';"; MySqlCommand cmdcheckUser = new MySqlCommand(checkUser, connect); int countUser = Convert.ToInt32(cmdcheckUser.ExecuteScalar()); if (countUser == 1) { string query = "SELECT * FROM User ORDER BY IDUser"; string countryNumUser = "******" + LoginMD5 + "';"; MySqlCommand cmdcountryNum = new MySqlCommand(countryNumUser, connect); object countryObjUser = cmdcountryNum.ExecuteScalar(); int country = Convert.ToInt32(countryObjUser); string countryNumCountrys = "SELECT Namecountry FROM Countrys WHERE IDCountry = " + country + ";"; MySqlCommand cmdcountryNumCountrys = new MySqlCommand(countryNumCountrys, connect); object countryObj = cmdcountryNumCountrys.ExecuteScalar(); string countryString = Convert.ToString(countryObj); string MWNumUser = "******" + LoginMD5 + "';"; MySqlCommand cmdMWNumUser = new MySqlCommand(MWNumUser, connect); object MWObjUser = cmdMWNumUser.ExecuteScalar(); int MWInt = Convert.ToInt32(MWObjUser); string MWNumGender = "SELECT Gendername FROM Gender WHERE IDGender = " + MWInt + ";"; MySqlCommand cmdMWNumGender = new MySqlCommand(MWNumGender, connect); object GenderObj = cmdMWNumGender.ExecuteScalar(); string GenderString = Convert.ToString(GenderObj); MySqlCommand command = new MySqlCommand(query, connect); MySqlDataReader reader = command.ExecuteReader(); List <string[]> data = new List <string[]>(); while (reader.Read()) { data.Add(new string[12]); data[data.Count - 1][1] = reader[3].ToString(); //фамилия data[data.Count - 1][2] = reader[4].ToString(); //имя data[data.Count - 1][3] = reader[5].ToString(); //отчество data[data.Count - 1][4] = reader[6].ToString(); //телефон data[data.Count - 1][5] = reader[7].ToString(); //почта data[data.Count - 1][7] = reader[9].ToString(); //дата рождения data[data.Count - 1][10] = reader[12].ToString(); //страна } reader.Close(); connect.Close(); // где 1 и 1 - это номер столбца и строки foreach (string[] s in data) { dataGridView1.Rows.Add(s); } dataGridView1[0, 0].Value = Settings.Default["Login"].ToString(); dataGridView1[6, 0].Value = GenderString; dataGridView1[8, 0].Value = countryString; labelPassword.Text = "Пароль: " + Settings.Default["Password"].ToString(); } else { string checkAdmin = "SELECT count(*) FROM Admin WHERE Login = '******';"; //юзер MySqlCommand cmdcheckAdmin = new MySqlCommand(checkAdmin, connect); int countAdmin = Convert.ToInt32(cmdcheckAdmin.ExecuteScalar()); if (countAdmin == 1) { string query = "SELECT * FROM Admin ORDER BY IDAdmin"; string countryNumAdmin = "SELECT IDCountry FROM Admin WHERE Login ='******';"; MySqlCommand cmdcountryNum = new MySqlCommand(countryNumAdmin, connect); object countryObjAdmin = cmdcountryNum.ExecuteScalar(); int country = Convert.ToInt32(countryObjAdmin); string countryNumCountrys = "SELECT Namecountry FROM Countrys WHERE IDCountry = " + country + ";"; MySqlCommand cmdcountryNumCountrys = new MySqlCommand(countryNumCountrys, connect); object countryObj = cmdcountryNumCountrys.ExecuteScalar(); string countryString = Convert.ToString(countryObj); string MWNumAdmin = "SELECT IDGender FROM Admin WHERE Login ='******';"; MySqlCommand cmdMWNumAdmin = new MySqlCommand(MWNumAdmin, connect); object MWObjAdmin = cmdMWNumAdmin.ExecuteScalar(); int MWInt = Convert.ToInt32(MWObjAdmin); string MWNumGender = "SELECT Gendername FROM Gender WHERE IDGender = " + MWInt + ";"; MySqlCommand cmdMWNumGender = new MySqlCommand(MWNumGender, connect); object GenderObj = cmdMWNumGender.ExecuteScalar(); string GenderString = Convert.ToString(GenderObj); MySqlCommand command = new MySqlCommand(query, connect); MySqlDataReader reader = command.ExecuteReader(); List <string[]> data = new List <string[]>(); while (reader.Read()) { data.Add(new string[9]); data[data.Count - 1][0] = reader[1].ToString(); //логин data[data.Count - 1][1] = reader[3].ToString(); //фамилия data[data.Count - 1][2] = reader[4].ToString(); //имя data[data.Count - 1][3] = reader[5].ToString(); //отчество data[data.Count - 1][4] = reader[6].ToString(); //телефон data[data.Count - 1][5] = reader[7].ToString(); //почта data[data.Count - 1][7] = reader[9].ToString(); //дата рождения } reader.Close(); connect.Close(); // где 1 и 1 - это номер столбца и строки foreach (string[] s in data) { dataGridView1.Rows.Add(s); } dataGridView1[6, 0].Value = GenderString; dataGridView1[8, 0].Value = countryString; labelPassword.Text = "Пароль: " + Settings.Default["Password"].ToString(); } } }
private void ButtonSave_Click(object sender, EventArgs e) { connect.Open(); string checkAdmin = "SELECT count(*) FROM Admin WHERE Login = '******';"; MySqlCommand cmdcheckAdmin = new MySqlCommand(checkAdmin, connect); int countAdmin = Convert.ToInt32(cmdcheckAdmin.ExecuteScalar()); if (countAdmin == 1) { if (textBoxSurname.Text != "") { dataGridView1[1, 0].Value = textBoxSurname.Text; string updateSurname = "UPDATE Admin SET Surname = '" + textBoxSurname.Text + "' WHERE Login = '******'"; MySqlCommand cmdupdateSurname = new MySqlCommand(updateSurname, connect); cmdupdateSurname.ExecuteNonQuery(); } if (textBoxName.Text != "") { dataGridView1[2, 0].Value = textBoxName.Text; string updateName = "UPDATE Admin SET Name = '" + textBoxName.Text + "' WHERE Login = '******'"; MySqlCommand cmdupdateName = new MySqlCommand(updateName, connect); cmdupdateName.ExecuteNonQuery(); } if (textBoxMiddlename.Text != "") { dataGridView1[3, 0].Value = textBoxMiddlename.Text; string updateMiddleame = "UPDATE Admin SET Middlename = '" + textBoxMiddlename.Text + "' WHERE Login = '******'"; MySqlCommand cmdupdateMiddleame = new MySqlCommand(updateMiddleame, connect); cmdupdateMiddleame.ExecuteNonQuery(); } if (textBoxPhone.Text != "") { dataGridView1[4, 0].Value = textBoxPhone.Text; string updatePhone = "UPDATE Admin SET Phone = '" + textBoxPhone.Text + "' WHERE Login = '******'"; MySqlCommand cmdupdatePhone = new MySqlCommand(updatePhone, connect); cmdupdatePhone.ExecuteNonQuery(); } if (textBoxEmail.Text != "") { dataGridView1[5, 0].Value = textBoxEmail.Text; string updateEmail = "UPDATE Admin SET Email = '" + textBoxEmail.Text + "' WHERE Login = '******'"; MySqlCommand cmdupdateEmail = new MySqlCommand(updateEmail, connect); cmdupdateEmail.ExecuteNonQuery(); } } else { Class.HashMD5 HMD5 = new Class.HashMD5(); string LoginMD5 = HMD5.GetHashString(Settings.Default["Login"].ToString()); string checkUser = "******" + LoginMD5 + "';"; //юзер MySqlCommand cmdcheckUser = new MySqlCommand(checkUser, connect); //юзер int countUser = Convert.ToInt32(cmdcheckUser.ExecuteScalar()); if (countUser == 1) { if (textBoxSurname.Text != "") { dataGridView1[1, 0].Value = textBoxSurname.Text; string updateSurname = "UPDATE User SET Surname = '" + textBoxSurname.Text + "' WHERE Login = '******'"; MySqlCommand cmdupdateSurname = new MySqlCommand(updateSurname, connect); cmdupdateSurname.ExecuteNonQuery(); } if (textBoxName.Text != "") { dataGridView1[2, 0].Value = textBoxName.Text; string updateName = "UPDATE User SET Name = '" + textBoxName.Text + "' WHERE Login = '******'"; MySqlCommand cmdupdateName = new MySqlCommand(updateName, connect); cmdupdateName.ExecuteNonQuery(); } if (textBoxMiddlename.Text != "") { dataGridView1[3, 0].Value = textBoxMiddlename.Text; string updateMiddleame = "UPDATE User SET Middlename = '" + textBoxMiddlename.Text + "' WHERE Login = '******'"; MySqlCommand cmdupdateMiddleame = new MySqlCommand(updateMiddleame, connect); cmdupdateMiddleame.ExecuteNonQuery(); } if (textBoxPhone.Text != "") { dataGridView1[4, 0].Value = textBoxPhone.Text; string updatePhone = "UPDATE User SET Phone = '" + textBoxPhone.Text + "' WHERE Login = '******'"; MySqlCommand cmdupdatePhone = new MySqlCommand(updatePhone, connect); cmdupdatePhone.ExecuteNonQuery(); } if (textBoxEmail.Text != "") { dataGridView1[5, 0].Value = textBoxEmail.Text; string updateEmail = "UPDATE User SET Email = '" + textBoxEmail.Text + "' WHERE Login = '******'"; MySqlCommand cmdupdateEmail = new MySqlCommand(updateEmail, connect); cmdupdateEmail.ExecuteNonQuery(); } } } connect.Close(); }
private void ButtonRegistration_Click(object sender, EventArgs e) { if (radioButton1.Checked == false && radioButton2.Checked == false) { MessageBox.Show("Не выбран пол, выберите свой пол", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Warning); buttonRegistration.Enabled = false; } maskedPhone.TextMaskFormat = MaskFormat.ExcludePromptAndLiterals; maskedPassportSeria.TextMaskFormat = MaskFormat.ExcludePromptAndLiterals; maskedTextBoxPassportNumber.TextMaskFormat = MaskFormat.ExcludePromptAndLiterals; if (textBoxPassword.Text == textBoxRepeatPassword.Text && textBoxname.Text != "" && textBoxSurname.Text != "" && textBoxMiddlename.Text != "" && textBoxEmail.Text != "" && textBoxLogin.Text != "" && comboBox1.Text != "Не выбрано" && (!String.IsNullOrEmpty(maskedTextBoxPassportNumber.Text) || !String.IsNullOrWhiteSpace(maskedTextBoxPassportNumber.Text) && (!String.IsNullOrEmpty(maskedPassportSeria.Text) || !String.IsNullOrWhiteSpace(maskedPassportSeria.Text)) && (!String.IsNullOrEmpty(maskedPhone.Text) || !String.IsNullOrWhiteSpace(maskedPhone.Text)) && labelErrorEmail.Text == "Ок")) { if (checkBox1.Checked == true) { Class.HashMD5 HMD5 = new Class.HashMD5(); string PasswordMD5 = HMD5.GetHashString(textBoxPassword.Text); //хеширование пароля string LoginMD5 = HMD5.GetHashString(textBoxLogin.Text); //хеширование логина connect.Open(); if (radioButton1.Checked == true) { string addUser = "******" + "VALUES('" + LoginMD5 + "', '" + PasswordMD5 + "', '" + textBoxSurname.Text + "', '" + textBoxname.Text + "', '" + textBoxMiddlename.Text + "', '+7" + maskedPhone.Text + "', '" + textBoxEmail.Text + "', " + 1 + ", '" + this.dateTimePickerBirthday.Text + "', '" + maskedPassportSeria.Text + "', '" + maskedTextBoxPassportNumber.Text + "', '" + comboBox1.SelectedIndex + "');"; MySqlCommand cmdAddUser = new MySqlCommand(addUser, connect); cmdAddUser.ExecuteNonQuery(); connect.Close(); Authorization auth = new Authorization(); this.Hide(); auth.ShowDialog(); } if (radioButton2.Checked == true) { string addUser = "******" + "VALUES('" + LoginMD5 + "', '" + PasswordMD5 + "', '" + textBoxSurname.Text + "', '" + textBoxname.Text + "', '" + textBoxMiddlename.Text + "', '+7" + maskedPhone.Text + "', '" + textBoxEmail.Text + "', " + 2 + ", '" + this.dateTimePickerBirthday.Text + "', '" + maskedPassportSeria.Text + "', '" + maskedTextBoxPassportNumber.Text + "', '" + comboBox1.SelectedIndex + "');"; MySqlCommand cmdAddUser = new MySqlCommand(addUser, connect); cmdAddUser.ExecuteNonQuery(); connect.Close(); Authorization auth = new Authorization(); this.Hide(); auth.ShowDialog(); } } else { if (MessageBox.Show("Подтвердите согласие на обработку данных", "Важно", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { checkBox1.Checked = true; } } } else { MessageBox.Show("Введены не все поля", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Information); } }