Ejemplo n.º 1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            string        properType;
            List <string> imageFiles = new List <string>();

            try
            {
                if (!String.IsNullOrEmpty(Request.QueryString["propID"]))
                {
                    DataAccessLayer dao = new DataAccessLayer();
                    SqlDataReader   reader;
                    int             loggedinUser;
                    // Query string value is there so now use it
                    param = Convert.ToInt32(Request.QueryString["propID"]);

                    if (Session["userEmail"] != null)
                    {
                        sessionUser  = Session["userEmail"].ToString();
                        loggedinUser = dao.getUserID(sessionUser);

                        //if session and propID match
                        if (dao.checkSessionandLoggedinUser(param, loggedinUser) == true)
                        {
                            reader = dao.SelectPropertyByID(param);
                        }
                        else
                        {
                            reader = dao.NotSessionSelectPropertyByID(param, Constants.isApproved);
                        }
                    }
                    else
                    {
                        reader = dao.NotSessionSelectPropertyByID(param, Constants.isApproved);
                    }

                    if (!reader.HasRows)
                    {
                        Response.Redirect("Error-404.aspx");
                    }

                    while (reader.Read())
                    {
                        int    propertyID          = reader.GetInt32(0);
                        int    propertyType        = reader.GetByte(1);
                        string propertyName        = reader.GetString(2);
                        string propertyLocation    = reader.GetString(3);
                        string propertyAddress     = reader.GetString(4);
                        int    propertySquareFeet  = reader.GetInt32(5);
                        int    propertyBedroom     = reader.GetByte(6);
                        int    propertyBathroom    = reader.GetByte(7);
                        string propertyDescription = reader.GetString(8);
                        int    propertyFeatured    = reader.GetByte(9);
                        int    propertyApproved    = reader.GetByte(10);
                        int    propertyStatus      = reader.GetByte(12);
                        int    propertyPrice       = reader.GetInt32(13);
                        int    propertyUser        = reader.GetInt32(14);

                        string agentID = dao.GetUserEmail(propertyUser);
                        hiddenAgent.Value = agentID;

                        hiddenPropertyID.Value = "" + reader.GetInt32(0);
                        hiddenUserID.Value     = "" + reader.GetInt32(14);


                        SqlDataReader reader1 = dao.GetImagesByID(reader.GetInt32(0));

                        while (reader1.Read())
                        {
                            imageFiles.Add((string)reader1.GetString(0));
                        }

                        Repeater1.DataSource = imageFiles;
                        Repeater1.DataBind();

                        if (reader.GetByte(1) == 1)
                        {
                            properType = "For Sale";
                        }
                        else
                        {
                            properType = "For Rent";
                        }

                        SqlDataReader reader2 = dao.FetchUser(agentID);

                        while (reader2.Read())
                        {
                            string userName     = reader2.GetString(2);
                            string userPhone    = reader2.GetString(3);
                            string userEmail    = reader2.GetString(5);
                            string userFB       = reader2.GetString(6);
                            string userLinkedin = reader2.GetString(7);
                            string userTwitter  = reader2.GetString(8);
                            string userDesc     = reader2.GetString(9);
                            string userSkype    = reader2.GetString(11);
                            string userImage    = reader2.GetString(12);

                            if (!IsPostBack)
                            {
                                propName.InnerText      = propertyName;
                                propAddress.InnerText   = propertyAddress;
                                propDesc.InnerText      = propertyDescription;
                                propSQFT.InnerText      = propertySquareFeet + " Sq Ft";
                                propBeds.InnerText      = propertyBedroom + " Bedrooms";
                                propBaths.InnerText     = propertyBathroom + " Bathrooms";
                                propUniqueID.InnerText  = "" + propertyID;
                                propPrice.InnerText     = "$" + propertyPrice;
                                propSize.InnerText      = propertySquareFeet + " Sq Ft";
                                propBedrooms.InnerText  = propertyBedroom + " Bedrooms";
                                propBathrooms.InnerText = propertyBathroom + " Bathrooms";
                                houseName.InnerText     = propertyName;
                                houseAddress.InnerText  = propertyAddress;
                                houseLocation.InnerText = propertyLocation;
                                houseStatus.InnerText   = properType;
                                houseAgent.InnerText    = agentID;
                                agentName.InnerText     = userName;
                                agentDesc.InnerText     = userDesc;
                                angentPhone.InnerText   = userPhone;
                                agentEmail.InnerText    = userEmail;
                                agentSkype.InnerText    = userSkype;
                                agentFBUrl.HRef         = userFB;
                                agentLinkedinUrl.HRef   = userLinkedin;
                                agentTwitterUrl.HRef    = userTwitter;
                                agentProfile.ImageUrl   = "userassets/" + userEmail + "/" + userImage;
                            }
                        }
                    }
                }
                else
                {
                    Response.Redirect("Error-404.aspx");
                }
            }
            catch (System.NullReferenceException r)
            {
                //exception handling
            }
        }