public void UpdateUser(CredentialsDto credential)
{
using IDbConnection db = new MySqlConnection("Server=127.0.0.1;Database=simplewebapp;Uid=root;Pwd=my-secret-pw;");
string sqlQuery = "UPDATE users SET Login = @Login, Password = @Password, Email = @Email, Roles = @Roles WHERE Id = @Id";
int rowsAffected = db.Execute(sqlQuery, credential);
}
public void AddUser(CredentialsDto credential)
{
using IDbConnection db = new MySqlConnection("Server=127.0.0.1;Database=simplewebapp;Uid=root;Pwd=my-secret-pw;");
string sqlQuery = "INSERT INTO users (Login, Password, Email, Roles) VALUES (@Login, @Password, @Email, @Roles)";
int rowsAffected = db.Execute(sqlQuery, credential);
}
public bool GetExist(CredentialsDto credential)
{
using IDbConnection db = new MySqlConnection("Server=127.0.0.1;Database=simplewebapp;Uid=root;Pwd=my-secret-pw;");
string sqlQuery = "SELECT * FROM users WHERE Login = @Login OR Email = @Email";
var result = db.QuerySingleOrDefault <CredentialsDto>(sqlQuery, credential);
return(result != null && result?.Login != null && result?.Password != null ? true : false);
}
