//Delete an auction
        internal bool DeleteAuctionById(int id)
        {
            bool successful = false;
            var  options    = new TransactionOptions
            {
                IsolationLevel = IsolationLevel.RepeatableRead
            };

            ImageHandler imageHandler = new ImageHandler();

            bool deleted = false;
            //queries statements
            string deleteAuction = "DELETE FROM Auction WHERE id = @Id";
            string deleteImage   = "DELETE FROM Image WHERE Auction_Id = @Id";
            string deleteBid     = "DELETE FROM Bid WHERE Auction_Id = @Id";
            string getUser       = "******";

            using (var scope = new TransactionScope(TransactionScopeOption.Required, options)) {
                using (var conn = new SqlConnection(_connectionString))
                {
                    try
                    {
                        conn.Open();
                        using (var scopeGetAndCalc = new TransactionScope(TransactionScopeOption.Required, options))
                        {
                            using (var DBAuction = new SqlCommand(getUser, conn))
                            {
                                int user_id = 0;
                                DBAuction.Parameters.AddWithValue("@Id", id);
                                SqlDataReader reader = DBAuction.ExecuteReader();

                                while (reader.Read())
                                {
                                    user_id = reader.GetInt32(0);
                                }
                                reader.Close();
                                imageHandler.DeleteAuctionFolder(id, user_id);   //delete auctionfolder with images
                            }

                            using (var DBAuction = new SqlCommand(deleteImage, conn))
                            {
                                DBAuction.Parameters.AddWithValue("@Id", id);
                                DBAuction.ExecuteNonQuery();
                            }

                            using (var DBAuction = new SqlCommand(deleteBid, conn))
                            {
                                DBAuction.Parameters.AddWithValue("@Id", id);
                                DBAuction.ExecuteNonQuery();
                            }
                            using (var DBAuctions = new SqlCommand(deleteAuction, conn))
                            {   //add the @Id and the id value from the parameters
                                DBAuctions.Parameters.AddWithValue("@Id", id);

                                DBAuctions.ExecuteNonQuery();
                            }

                            scopeGetAndCalc.Complete(); //close nested transaction
                            successful = true;
                        }
                    }
                    catch (Exception e)
                    {
                        throw e;
                    }
                    finally
                    {
                        conn.Close();
                    }
                }
                scope.Complete();//close whole transaction
            }

            return(successful);
        }
        /// <summary>
        /// Inserts pictures into database and folders.
        /// </summary>
        /// <param name="images"></param>
        /// <returns></returns>
        public bool InsertPictures(List <ImageData> images)
        {
            bool successful = false;

            //Set isolation level
            var options = new TransactionOptions
            {
                IsolationLevel = IsolationLevel.ReadCommitted
            };

            string insertImage = "INSERT INTO Image (Auction_Id, Img_URL, DateAdded, Description, Name) " +
                                 "VALUES(@auctionId,@imgUrl,@dateAdded, @description, @name)";

            //Transaction
            using (var scope = new TransactionScope(TransactionScopeOption.Required, options))
            {
                using (var conn = new SqlConnection(_connectionString))
                {
                    try
                    {
                        //Open connection to database.
                        conn.Open();

                        foreach (ImageData image in images)
                        {
                            using (var cmdIImage = new SqlCommand(insertImage, conn))
                            {
                                cmdIImage.Parameters.AddWithValue("auctionId", image.AuctionId);
                                cmdIImage.Parameters.AddWithValue("imgUrl", image.ImgUrl);
                                cmdIImage.Parameters.AddWithValue("dateAdded", image.DateAdded);
                                cmdIImage.Parameters.AddWithValue("description", image.Description);
                                cmdIImage.Parameters.AddWithValue("name", image.FileName);

                                cmdIImage.ExecuteScalar();
                            }
                        }

                        ImageHandler iHandler   = new ImageHandler();
                        bool         succsesful = iHandler.InsertPicturesToFolder(images);
                        if (!succsesful)
                        {
                            scope.Dispose();
                            return(successful = false);
                        }


                        //If everything went well, will commit.
                        scope.Complete();
                    }
                    catch (TransactionAbortedException e)
                    {
                        successful = false;
                        throw e;
                    }
                    finally
                    {
                        scope.Dispose();
                    }
                }
            }
            return(successful);
        }