// Method of check available user
public static void CheckUser(string userLogin, string userPassword)
{
login = "******";
password = "******";
DataBaseModel.OpenConnection();
MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT * FROM users;", DataBaseModel.GetConnection());
DataTable table = new DataTable();
adapter.Fill(table);
for (int i = 0; i < table.Rows.Count; i++)
{
if (userLogin == table.Rows[i].Field <string>("login") && userPassword == table.Rows[i].Field <string>("password"))
{
state = true;
login = userLogin;
password = userPassword;
break;
}
else
{
state = false;
}
}
DataBaseModel.CloseConnection();
}
// Method of log in user
public static void LogInUser(string userLogin, string userPassword)
{
state = true;
if (userLogin == "admin" || userLogin == "sanya")
{
login = "******";
password = "******";
DataBaseModel.OpenConnection();
}
else
{
login = "******";
password = "******";
DataBaseModel.OpenConnection();
}
}
// Method of cretae new user (new user save to 'users' table in DB)
public static void CreateUser(string userLogin, string userPassword)
{
login = "******";
password = "******";
DataBaseModel.OpenConnection();
string request = "INSERT INTO users (login, password) VALUES (@login, @password)";
MySqlCommand cmd = DataBaseModel.GetConnection().CreateCommand();
cmd.CommandText = request;
MySqlParameter uLogin = cmd.Parameters.Add("@login", MySqlDbType.VarChar, 16);
uLogin.Value = userLogin;
MySqlParameter uPassword = cmd.Parameters.Add("@password", MySqlDbType.VarChar, 16);
uPassword.Value = userPassword;
cmd.ExecuteNonQuery();
DataBaseModel.CloseConnection();
}