}//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
