private void GenerateLatestClassifieds(string _Country)
    {
        string strHtml              = string.Empty;
        string strURL               = string.Empty;
        string strFilePath          = string.Empty;
        string strEncrypt           = string.Empty;
        string strDecrypt           = string.Empty;
        string strAdvertisementType = string.Empty;
        string AdvertisementType    = string.Empty;

        //DataTable dtLatestProduct = null;

        try
        {
            using (HomePageHandler homePageHandler = new HomePageHandler())
            {
                EOC_PropertyBean eocPropertyBean = new EOC_PropertyBean();
                eocPropertyBean.Country_CountryID = Convert.ToInt32(_Country);
                //eocPropertyBean.AdvertisementType = "Want";

                DataTable dtLatestProduct = homePageHandler.LoadRecord_02_LatestClassifieds(eocPropertyBean);

                if (dtLatestProduct.Rows.Count > 0)
                {
                    repWant.DataSource = dtLatestProduct;
                    repWant.DataBind();
                }
                else
                {
                    repWant.DataSource = null;
                    repWant.DataBind();
                }

                //eocPropertyBean.AdvertisementType = "Offer";
                //DataTable dtLatestOfferedProduct = homePageHandler.LoadRecord_02_LatestClassifieds(eocPropertyBean);
                //if (dtLatestOfferedProduct.Rows.Count > 0)
                //{
                //    repOffer.DataSource = dtLatestOfferedProduct;
                //    repOffer.DataBind();
                //}
            }
        }
        catch (Exception ex)
        {
            lblSystemMessage.Text = ex.Message;
        }
    }
        public void HomePageHandler_CanMapFromContent()
        {
            // Arrange
            var mapper  = new UmbracoMapper();
            var handler = new HomePageHandler(mapper);
            var content = MockHomePageContent();
            var model   = new HomePageViewModel();

            // Act
            handler.Handle(content.Object, model);

            // Assert
            Assert.AreEqual("My site", model.SiteName);
            Assert.AreEqual("My site byline", model.ByLine);
            Assert.AreEqual("My company", model.Copyright);
            Assert.AreEqual("About us", model.AboutTitle);
            Assert.AreEqual("<p>About</p>", model.AboutText.ToString());
            Assert.IsFalse(model.HideBanner);
            Assert.AreEqual("Banner header", model.BannerHeader);
            Assert.AreEqual("Banner sub-header", model.BannerSubheader);
            Assert.AreEqual("Banner link text", model.BannerLinkText);
            Assert.AreEqual("/media/1.jpg", model.BannerBackgroundImageUrl);
            Assert.AreEqual("/news/", model.BannerLinkUrl);
        }