public Property()
        {
            this.Bookings = new List<Booking>();
            this.Comments = new List<Comment>();
            this.Packages = new List<Package>();
            this.PropertyEntities = new List<PropertyEntity>();
            this.PropertyPricingSeasonalInstances = new List<PropertyPricingSeasonalInstance>();
            this.PropertySecurityItems = new List<PropertySecurityItem>();
            this.PropertyStaffTaskAssignments = new List<PropertyStaffTaskAssignment>();

            //set up datasets
            using (var _db = new PortugalVillasContext())
            {
                var pricesForThisProp = _db.PropertyPricingSeasonalInstances.Where(x => x.PropertyID == this.PropertyID).ToList();
                if (pricesForThisProp.Count() > 0)
                { this.PropertyPricingSeasonalInstances = _db.PropertyPricingSeasonalInstances.Where(x => x.PropertyID == this.PropertyID).ToList(); }
            }
            

            switch (this.Active)
            {
                case true:
                    CreatePriceRange();
                    break;
            }
        }

        private static List<BookingAndRelatedTransactions> ReturnAllBookingsAndTransactions(long AccountID, PortugalVillasContext db)
        {
            var owner = db.PropertyOwnerAccounts.Where(x => x.AccountID == AccountID).First();
            var props = db.Properties.Where(x => x.PropertyOwnerID == owner.PropertyOwnerID).ToList();

            var bookings = new List<Booking>();

            foreach (var property in props)
            {
                bookings.AddRange(db.Bookings.Where(booking => booking.PropertyID == property.PropertyID).Include(x=>x.Property).ToList());
            }

    
            var transactions = db.AccountTransactions.Where(x => x.AccountID == AccountID).Where(x=>x.Voided != true);

            List<BookingAndRelatedTransactions> bookingAndTrans = new List<BookingAndRelatedTransactions>();

            foreach (var booking in bookings)
            {
                bookingAndTrans.Add(new BookingAndRelatedTransactions
                {
                    booking = booking,
                    transactions = transactions.Where(x=>x.BookingID == booking.BookingID).ToList()
                });
            }




            return bookingAndTrans;
        }

        public static int CreateAccountsForOwnersWithoutAccount(PortugalVillasContext db)
        {
            //get all ownersIDs
            var owners = db.PropertyOwners.ToList();
            //checks they all have an account is accounts
            var accounts = db.PropertyOwnerAccounts.ToList();

            List<PropertyOwnerAccount> accountsToCreate = new List<PropertyOwnerAccount>();

            foreach (var propertyOwner in owners)
            {
                var account = accounts.Where(x => x.PropertyOwnerID == propertyOwner.PropertyOwnerID).FirstOrDefault();
                if (account == null)
                {
                    db.PropertyOwnerAccounts.Add(new PropertyOwnerAccount
                    {
                        AccountBalance = 0.00M,
                        PropertyOwnerID = propertyOwner.PropertyOwnerID
                    });


                }
            }

            

            return db.SaveChanges();

        }

        public static List<Comment> GetRandomTopRatedComments()
        {
            try
            {
                PortugalVillasContext _db = new PortugalVillasContext();

                List<Comment> theCommentsList = new List<Comment>();

                return theCommentsList = _db.Comments.Where(x => x.StarRating > 2)
               .Where(x => x.Approved == true).Take(10)
               .ToList();

                
            }
            catch (Exception ex)
            {
                
                throw ex;
            }



            throw new Exception();

        }

        public static List<BookingExtraAttribute> GetBookingExtraAttributesByBookingExtraID(long? bookingExtraID)
        {
            List<BookingExtraAttribute> theListOfAttributes = new List<BookingExtraAttribute>();
            PortugalVillasContext _db = new PortugalVillasContext();

            return theListOfAttributes = _db.BookingExtraAttributes.Where(x => x.BookingExtraID == bookingExtraID).ToList();
        }

        /// <summary>
        /// Gets 
        /// </summary>
        public static CustomerBankDetail GetCustomerBankDetailFromCustomer(Customer aCustomer)
        {
            PortugalVillasContext db = new PortugalVillasContext();
            CustomerBankDetail theBankDetailsToReturn = db.CustomerBankDetails.Where(x => x.CustomerID == aCustomer.CustomerID).FirstOrDefault();
            return theBankDetailsToReturn;

        }

        //
        // GET: /DocumentMangementService/

    

        public ActionResult CreateDocumentAndSaveToLocation()
        {
            var db = new PortugalVillasContext();
            var parentContainer = new BookingParentContainer();

            //dependenceies
            var dc = new DocumentGenerationController();
            var customer = db.Customers.Find(1);
            var booking = db.Bookings.Find(4);
            var type = PRCDocument.PRCDocumentType.UK_WineTasting;

            //create a document with all parsed variables
            var document = dc.CreateDocumentToFileSystem(customer, type, booking);

      /*      db.Documents.Add(new Document
            {
                CustomerID = customer.CustomerID,
                DocumentBLOB = document,
                EventID = 2
                
            });

            db.SaveChanges();*/

            //save it to the DB or the FileSystem
            return RedirectToAction("Dashboard", "Admin");
        }

        //get all the booking extra types
        public static List<BookingExtraType> GetBookingExtraTypes()
        {
            List<BookingExtraType> theList = new List<BookingExtraType>();
            PortugalVillasContext _db = new PortugalVillasContext();

            return theList = _db.BookingExtraTypes.ToList();
        }

        //get individual booking by ID -- NEED TO TEST FOR EMPTY RESULT
        public static Booking GetBookingByID(int bookingID)
        {
            PortugalVillasContext _db = new PortugalVillasContext();

            var aBooking = _db.Bookings.Include(x => x.Property).FirstOrDefault(x => x.BookingID == bookingID);

            return aBooking;
        }

        /////////////////////////////
        //// STATIC METHODS
        /////////////////////////////
        //INT or STRING methods to get a list of properties- all return List<Property>
        //////////////////////////////////////////////////////////
        ////These methods pull back Properties based on given criteria
        //////////////////////////////////////////////////////////
        public static List<Property> GetAllProperties()
        {
            PortugalVillasContext _db = new PortugalVillasContext();

               var allProperties = _db.Properties.ToList();

               return allProperties;
        }

        public static List<CommentSection> GetAllCommentSectionsForComment(Comment aComment)
        {
            PortugalVillasContext _db = new PortugalVillasContext();
            List<CommentSection> theCommentSections = new List<CommentSection>();

            theCommentSections = _db.CommentSections.Where(x => x.CommentID == aComment.CommentID).ToList();

            return theCommentSections;
        }

        //get all the booking extras - return list
        public static List<BookingExtra> GetBookingExtras()
        {
            List<BookingExtra> theList = new List<BookingExtra>();
            PortugalVillasContext _db = new PortugalVillasContext();

            return theList = _db.BookingExtras
                .Where(x => x.TopLevelItem == true)
                .ToList();
        }

    protected DateTime? GetMaxBooking()
    {
        PortugalVillasContext _db = new PortugalVillasContext();
        DateTime? maxBooking = _db.Bookings
            .Max(x => x.StartDate);
 
  
        return maxBooking;
    }

        //////////TITLES//////////////////
        //////////////////////////////////
        //GET the title
        public static List<Title> GetTitles()
        {
            using(PortugalVillasContext _db = new PortugalVillasContext()){

             List<Title> TitleList = _db.Titles.ToList();

             return TitleList;
            }
        }

        public static Customer GetSingleCustomer(long? CustomerID)
        {
            PortugalVillasContext _db = new PortugalVillasContext();

            var aCustomer = (_db.Customers
                                     .Where(x => x.CustomerID == CustomerID).First());

            return (Customer) aCustomer;
        }

        public static List<BookingExtra> GetBookingExtrasFromBookingExtraSelection(BookingExtraSelection aBookingExtraSelection)
        {
            List<BookingExtra> aBookingExtra = new List<BookingExtra>();

            PortugalVillasContext _db = new PortugalVillasContext();

            aBookingExtra = _db.BookingExtras.Where(x => x.BookingExtraID == aBookingExtraSelection.BookingExtraID).ToList();

            return aBookingExtra;
        }

        //
        // GET: /Document/

        public FileContentResult ReturnPDFDocument(long id)
        {
            using (var db = new PortugalVillasContext())
            {
                var doc = db.Documents.First(c => c.DocumentID == id); //.DocumentTable.First(p => p.DocumentUID == id);
                byte[] data = doc.DocumentBLOB;
                return File(data, "application/pdf", doc.DocumentName);
            }

        }

        public static PRCInformation GetPRCInformation()
        {
            using (var db = new PortugalVillasContext())
            {
                return db.PRCInformations.FirstOrDefault();
            }
            


        }

        public static List<CommentReply> GetCommentReplies()
        {
            PortugalVillasContext _db = new PortugalVillasContext();

            List<CommentReply> theCommentReplies = new List<CommentReply>();

            theCommentReplies = _db.CommentReplies.Where(x => x.Approved == true).ToList();
            
            return theCommentReplies;
        }

        public static long GetBookingExtraIDByPRCReference(string prcRef)
        {
            PortugalVillasContext _db = new PortugalVillasContext();

            long theID = _db.BookingExtras
                .Where(x => x.LegacyReference == prcRef.Trim())
                .Select(x => x.BookingExtraID).First();

            return theID;
        }