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
}
}