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