public bool IsUserExists()
{
DataTable dataTable = new DataTable();
MySqlDataAdapter mySqlDataAdapter = new MySqlDataAdapter();
MySqlConnection _connection = DataBaseUtils.GetMySqlConnection();
MySqlCommand sqlCommand = new MySqlCommand("SELECT * FROM `users` WHERE `login` = @uL", _connection);
sqlCommand.Parameters.Add("@uL", MySqlDbType.VarChar).Value = loginField.Text;
mySqlDataAdapter.SelectCommand = sqlCommand;
mySqlDataAdapter.Fill(dataTable);
if (dataTable.Rows.Count == 0)
{
Debug_text.Text += "\r\n нет таких пользователей ";
return(true);
}
else
{
Debug_text.Text += "\r\n записано";
return(false);
}
}
private void button_Register_Click(object sender, EventArgs e)
{
string loginUser = loginField.Text;
string passUser = PassField.Text;
string nameUser = NameField.Text;
string surnameUser = SurnameField.Text;
DataTable dataTable = new DataTable();
MySqlDataAdapter mySqlDataAdapter = new MySqlDataAdapter();
MySqlConnection _connection = DataBaseUtils.GetMySqlConnection();
//OPEN CONNECTION
try
{
Debug_text.Text = "Connection Getting...";
_connection.Open();
Debug_text.Text += "\r\nConnection Open...";
}
catch
{
Debug_text.Text += "\r\nConnection Close";
}
if (NameField.Text == "Enter name" || SurnameField.Text == "Enter surname" || loginField.Text == "Enter login" || PassField.Text == "Enter password")
{
Debug_text.Text += "\r\nAccount was not created(Fill in all the fields)...";
return;
}
else
{
Debug_text.Text += "\r\nAccount has been created.";
}
if (IsUserExists())
{
return;
}
Debug_text.Text += "\r\nRegistration completed.";
MySqlCommand sqlCommand = new MySqlCommand("INSERT INTO `users` (`id`, `login`, `pass`, `name`, `surname`) VALUES (NULL, @uLogin, @uPassword, @uName, @uSurname);", _connection);
sqlCommand.Parameters.Add("@uLogin", MySqlDbType.VarChar).Value = loginUser;
sqlCommand.Parameters.Add("@uPassword", MySqlDbType.VarChar).Value = passUser;
sqlCommand.Parameters.Add("@uName", MySqlDbType.VarChar).Value = nameUser;
sqlCommand.Parameters.Add("@uSurname", MySqlDbType.VarChar).Value = surnameUser;
mySqlDataAdapter.SelectCommand = sqlCommand;
mySqlDataAdapter.Fill(dataTable);
//CLOSE CONNECTION
_connection.Close();
Debug_text.Text += "\r\nConnection Close";
}
private void button1_Click(object sender, EventArgs e)
{
string nameSUser = NameS.Text;
string loginUser = loginField.Text;
string surnameSUser = SurnameS.Text;
string numberSUser = NumberS.Text;
DataTable dataTable = new DataTable();
MySqlDataAdapter mySqlDataAdapter = new MySqlDataAdapter();
MySqlConnection _connection = DataBaseUtils.GetMySqlConnection();
try
{
Debug_text.Text = "Connection Getting...";
_connection.Open();
Debug_text.Text += "\r\nConnection Open...";
}
catch
{
Debug_text.Text += "\r\nConnection Close";
}
if (IsUserExists())
{
return;
}
//СЛОЖНО
using (MySqlCommand sqlCommand = new MySqlCommand(" INSERT INTO `books` (`name`, `surname`, `number`,`id_book`,`login`) VALUES ( @nameS, @surnameS, @numberS,NULL,@loginUser)", _connection))
{
//СЛОЖНО
sqlCommand.Parameters.Add("@loginUser", MySqlDbType.VarChar).Value = loginUser;
sqlCommand.Parameters.Add("@nameS", MySqlDbType.VarChar).Value = nameSUser;
sqlCommand.Parameters.Add("@surnameS", MySqlDbType.VarChar).Value = surnameSUser;
sqlCommand.Parameters.Add("@numberS", MySqlDbType.VarChar).Value = numberSUser;
try
{
mySqlDataAdapter.SelectCommand = sqlCommand;
mySqlDataAdapter.Fill(dataTable);
}
catch (Exception)
{
Debug_text.Text += "\r\nERROR FOR ID ROW 1";
}
}
Debug_text.Text += "\r\n" + nameSUser + " = name\r\n" + surnameSUser + " = surname\r\n" + numberSUser + " = number";
}
private void button_Enter_Click(object sender, EventArgs e)
{
string loginUser = loginField.Text;
string passUser = PassField.Text;
DataTable dataTable = new DataTable();
MySqlDataAdapter mySqlDataAdapter = new MySqlDataAdapter();
MySqlConnection _connection = DataBaseUtils.GetMySqlConnection();
try
{
Debug_text.Text = "Openning Connection ...";
_connection.Open();
Debug_text.Text += "\r\nConnection successful!\r\n...";
}
catch
{
Debug_text.Text += "\r\nError";
}
MySqlCommand sqlCommand = new MySqlCommand("SELECT * FROM `users` WHERE `login` = @uL AND `pass` = @uP", _connection);
sqlCommand.Parameters.Add("@uL", MySqlDbType.VarChar).Value = loginUser;
sqlCommand.Parameters.Add("@uP", MySqlDbType.VarChar).Value = passUser;
mySqlDataAdapter.SelectCommand = sqlCommand;
mySqlDataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0)
{
Hide();
MainForm mainForm = new MainForm();
mainForm.Show();
}
else
{
Debug_text.Text += "\r\nuser is NOT registered";
}
}
private void Show_Bill_Click(object sender, EventArgs e)
{
string loginUser = get_bill_login.Text;
List <string[]> data = new List <string[]>();
DataTable dataTable = new DataTable();
MySqlDataAdapter mySqlDataAdapter = new MySqlDataAdapter();
MySqlConnection _connection = DataBaseUtils.GetMySqlConnection();
//if (IsUserExists())
// return;
MySqlCommand sqlCommand = new MySqlCommand("SELECT * FROM books WHERE login = @loginUser", _connection);
sqlCommand.Parameters.Add("@loginUser", MySqlDbType.VarChar).Value = loginUser;
MySqlDataReader dataReader = sqlCommand.ExecuteReader();
DataTable schemaTable = dataReader.GetSchemaTable();
while (dataReader.Read())
{
for (int i = 0; i < dataReader.FieldCount; i++)
{
Debug_text.Text += dataReader.GetString(i);
}
}
dataReader.Close();
Debug_text.Text += "\r\n" + data;
mySqlDataAdapter.SelectCommand = sqlCommand;
mySqlDataAdapter.Fill(dataTable);
}