/// <summary>
/// Same, but only one parameter
/// </summary>
/// <param name="query"></param>
/// <param name="parameter"></param>
public void Query(string query, MySqlParameter parameter)
{
MySqlParameters parameters = new MySqlParameters();
parameters.AddParameter(parameter);
Query(query, parameters);
}
public void UpdateFavor()
{
using (DBClient client = new DBClient())
{
string myStringIsBigIsVeryVeryBig = "";
for (int i = 0; i < favoritSources.Count; ++i)
{
myStringIsBigIsVeryVeryBig += favoritSources[i] + ";";
}
MySqlParameters mysql_params = new MySqlParameters();
mysql_params.AddParameter("favor", myStringIsBigIsVeryVeryBig);
mysql_params.AddParameter("login", User.Name);
client.Query("UPDATE users SET favorites_source = @favor WHERE login=@login", mysql_params);
}
}
/// <summary>
/// Same, but only one parameter
/// </summary>
public List <string> SelectQuery(string query, MySqlParameter parameter)
{
MySqlParameters parameters = new MySqlParameters();
parameters.AddParameter(parameter);
return(SelectQuery(query, parameters));
}
public static bool Registration(string login, string password, string email)
{
using (DBClient mysql_client = new DBClient())
{
string query = @"SELECT login FROM users WHERE login = @login;";
if (mysql_client.SelectQuery(query, new MySqlParameter("login", login.ToLower())).Count > 0)
{
return(false);
}
else
{
MySqlParameters mysql_params = new MySqlParameters();
mysql_params.AddParameter(new MySqlParameter("login", login.ToLower()));
mysql_params.AddParameter(new MySqlParameter("password", MD5Hashing.GetMd5Hash(password)));
mysql_params.AddParameter(new MySqlParameter("email", email));
mysql_client.Query("INSERT INTO users (login, password, email) VALUES (@login, @password, @email)", mysql_params);
return(true);
}
}
}
