protected void Page_Load(object sender, EventArgs e)
    {
        entities = new PropertyDbEntities();

        int ID = Convert.ToInt32(Request.QueryString["PropertyID"]);


        PropertyDetail obj = entities.PropertyDetails.Where(x => x.PropertyID == ID).FirstOrDefault();

        //lblPrice.Text = obj.Price.ToString();
        PropertyLocation propertyLoc = entities.PropertyLocations.Where(x => x.PropertyID == obj.PropertyID).FirstOrDefault();

        lblAddress.Text   = propertyLoc.Address + propertyLoc.City + propertyLoc.Region;
        lblType.Text      = entities.PropertyTypes.Where(x => x.TypeID == obj.TypeID).Select(y => y.Type).FirstOrDefault().ToString();
        lblSubType.Text   = entities.PropertySubtypes.Where(x => x.TypeID == obj.TypeID).Select(y => y.Subtype).FirstOrDefault().ToString();
        lblSize.Text      = obj.Size.ToString();
        lblFloorLvl.Text  = obj.FloorLevel.ToString();
        lblTenure.Text    = entities.PropertyTenures.Where(x => x.TenureID == obj.TenureID).Select(y => y.TenureType).FirstOrDefault().ToString();
        lblDev.Text       = obj.Developer.ToString();
        lblListDate.Text  = obj.ListedDate.ToString();
        lblMRT.Text       = obj.MRT.ToString();
        lblSchool.Text    = obj.School.ToString();
        lblChildcare.Text = obj.ChildCare.ToString();
        lblDesc.Text      = obj.Description.ToString();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        entities = new PropertyDbEntities();

        PropertyImage propertyImg = new PropertyImage();

        propertyImg.PropertyID = 1;


        entities.PropertyImages.Add(propertyImg);
        entities.SaveChanges();
    }