public int PricePhoto(PhotosOrdered photo) { var connect = Connect(); int price = connect.QuerySingleOrDefault <int>(sql: "SELECT price FROM pictures WHERE picture_id = @picture_id", photo); return(price); }
public int PhotoOrder(PhotosOrdered photo) { var connect = Connect(); int PhotoAdded = connect.Execute("INSERT INTO pictures_orders(order_id, picture_id) VALUES(@order_id ,@picture_id)", photo); return(PhotoAdded); }