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); }