public void Delete(int?id)
{
var existingUser = _getUserData.GetDataWithoutArtworks(id);
if (existingUser == null)
{
throw new NonExistingUserException(_path, "Delete()");
}
var deleteUserArtworksQuery = $"DELETE FROM artwork_table WHERE user_id = {id};";
var deleteUserQuery = $"DELETE FROM user_table WHERE id = {id};";
_sqlQuery.ExecuteDoubleVoid(deleteUserArtworksQuery, deleteUserQuery);
}
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);
}
