// public List<user_controller> GetUsernames()
// {
// var connect = Connect();
// List<user_controller> usernames = connect.Query<user_controller>("SELECT username FROM users").ToList();
// return usernames;
// }
public bool AddPhoto(ValuePhoto photo)
{
var connect = Connect();
int PhotoAdded = connect.Execute(
@"INSERT INTO pictures(title, description, price, path, category_id) VALUES (@title, @description, @price, @path, @category_id)"
, photo);
return(PhotoAdded == 1);
}
public ValuePhoto Update(ValuePhoto photo)
{
var connect = Connect();
ValuePhoto UpdatedPhoto = connect.QuerySingle <ValuePhoto>(sql: @"UPDATE pictures SET title = @title, description = @description,
price = @price, path = @path, category_id = @category_id
WHERE picture_id = @picture_id;
SELECT * FROM pictures WHERE picture_id = @picture_id", photo);
return(UpdatedPhoto);
}