protected void Page_Load(object sender, EventArgs e) { int uID; string sessionUser; string name; string phone; string email; string fbURL; string linkedinURL; string twitterURL; string description; string skypeURL; string profilePic; string applicationPath = Constants.path; try { DataAccessLayer dao = new DataAccessLayer(); if (Session["userEmail"] != null) { sessionUser = Session["userEmail"].ToString(); SqlDataReader reader = dao.FetchUser(sessionUser); while (reader.Read()) { uID = reader.GetInt32(0); name = reader.GetString(2); phone = Constants.SafeGetString(reader, 3); email = reader.GetString(5); fbURL = Constants.SafeGetString(reader, 6); linkedinURL = Constants.SafeGetString(reader, 7); twitterURL = Constants.SafeGetString(reader, 8); description = Constants.SafeGetString(reader, 9); skypeURL = Constants.SafeGetString(reader, 11); profilePic = Constants.SafeGetString(reader, 12); if (!IsPostBack) { txtName.Text = name; txtEmail.Text = email; txtPhone.Text = phone; userFB.NavigateUrl = fbURL; userLinkedin.NavigateUrl = linkedinURL; userTwitter.NavigateUrl = twitterURL; userFBlink.Text = fbURL; userLinkedinLink.Text = linkedinURL; userTwitterLink.Text = twitterURL; userSkypeLink.Text = skypeURL; txtDescription.InnerText = description; userPicture.Attributes["src"] = @"userassets\" + email + @"\" + profilePic; } } } else { Response.Redirect("Login.aspx"); } } catch (Exception) { Console.Write("error"); } }
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 } }