public User Edit(User user) { var currentUser = _getUserData.GetDataWithoutArtworks(user.Id); if (currentUser == null) { throw new NonExistingUserException(_path, "Edit()"); } if (currentUser.Username == user.Username && currentUser.Password == user.Password && currentUser.ProfileImgUrl == user.ProfileImgUrl) { return(user); } var query = _sqlBuilder.GenerateUpdateStatement(user); _sqlQuery.ExecuteVoid(query); return(user); }
public void CreateUser(string username, string password) { var existingUser = _getUserData.Get(username); if (existingUser != null) { throw new ExistingUserException(_path, "Add()"); } var user = new User { Username = username, Password = BCrypt.Net.BCrypt.HashPassword(password), CreatedAt = DateTime.Now, }; var query = $"INSERT INTO user_table (username, password, date_created) " + $"VALUES ('{user.Username}', '{user.Password}', '{user.CreatedAt}');"; _sqlQuery.ExecuteVoid(query); }
public void Edit(ArtWork artwork) { var query = _sqlBuilder.GenerateUpdateStatement(artwork); _sqlQuery.ExecuteVoid(query); }
public void Add(ArtWork artWork) { var query = _sqlBuilder.GenerateInsertStatement(artWork); _sqlQuery.ExecuteVoid(query); }
public void Delete(int?id) { var query = $"DELETE FROM artwork_table WHERE id = {id}"; _sqlQuery.ExecuteVoid(query); }