}//Button New User(GroupBox) //Создание нового пользователя private void metroButton_new_user_login_Click(object sender, EventArgs e) { string date_of_registration = DateTime.Now.ToString("dd MMMM yyyy | HH:mm:ss");//Формат записи даты в БД if (metroTextBox_new_user_login.Text == "" || metroTextBox_new_user_password.Text == "") { MessageBox.Show("One field is not filled", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { conn.Open(); int new_us = 0; string query = "select count(*) from polzovatel where login = '******'"; MySqlCommand msc = new MySqlCommand(query, conn); new_us = Convert.ToInt32(msc.ExecuteScalar()); if (new_us > 0) { MessageBox.Show("User exist"); } else { string query_new_user = "******" + "`date_registration`, `id_time_in_program`,`id_passing`) values ('" + metroTextBox_new_user_login.Text + "','" + metroTextBox_new_user_password.Text + "'," + "'null', 'null', 'null', 'null', '01.01.1900', '" + date_of_registration + "', '" + Function.Add_time_in_program() + "','" + Function.Add_passing() + "')"; MySqlCommand MSCom = new MySqlCommand(query_new_user, conn); MSCom.ExecuteNonQuery(); conn.Close(); } } }//Create new user