protected void Page_Load(object sender, EventArgs e) { string sessionUser; int userID; try { DataAccessLayer dao = new DataAccessLayer(); if (Session["userEmail"] != null) { sessionUser = Session["userEmail"].ToString(); hiddenUser.Text = sessionUser; userID = dao.getUserID(sessionUser); SqlDataReader reader = dao.GetUserProperties(userID, Constants.propertyEnabled); Repeater1.DataSource = reader; Repeater1.DataBind(); } else { Response.Redirect("Login.aspx"); } } catch (Exception) { Console.Write("error"); } }
protected void markFav_Click(object sender, EventArgs e) { if (Session["userEmail"] != null) { DataAccessLayer dao = new DataAccessLayer(); sessionUser = Session["userEmail"].ToString(); int propertyID = int.Parse(hiddenPropertyID.Value); int loggedUserID = dao.getUserID(sessionUser); dao.AddtoFavourites(propertyID, loggedUserID); } }
protected void removeFavourites_Click(object sender, EventArgs e) { int propertyID = int.Parse(propID.Value); string userEmail = hiddenUser.Value; DataAccessLayer dao = new DataAccessLayer(); int emailID = dao.getUserID(userEmail); dao.DeleteFavourites(propertyID, emailID); Response.Redirect("Favourites.aspx"); }
protected void confirmMarkAsFav_Click(object sender, EventArgs e) { string sessionUser; if (Session["userEmail"] != null) { DataAccessLayer dao = new DataAccessLayer(); sessionUser = Session["userEmail"].ToString(); int propertyID = int.Parse(propID.Value); int loggedUserID = dao.getUserID(sessionUser); dao.AddtoFavourites(propertyID, loggedUserID); Response.Redirect("Favourites.aspx"); } else { Response.Redirect("Login.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { string sessionUser; int userID; try { DataAccessLayer dao = new DataAccessLayer(); if (Session["userEmail"] != null) { sessionUser = Session["userEmail"].ToString(); hiddenUser.Value = sessionUser; userID = dao.getUserID(sessionUser); SqlDataReader reader = dao.GetFavouritePropertiesID(userID); DataTable favList = new DataTable(); string _propertyIds = string.Empty; while (reader.Read()) { int propertyID = reader.GetInt32(0); _propertyIds += string.Concat(propertyID, ","); } _propertyIds = _propertyIds.TrimEnd(','); favList = dao.GetUserFavouriteProperties(userID, _propertyIds, Constants.propertyEnabled); Repeater1.DataSource = favList; Repeater1.DataBind(); } else { Response.Redirect("Login.aspx"); } } catch (Exception) { Console.Write("error"); } }
protected void btnSubmitProperty_Click(object sender, EventArgs e) { DataAccessLayer dao = new DataAccessLayer(); sessionUser = Session["userEmail"].ToString(); string propertyName; string propertyLocation; string propertyDescription; string propertyAddress; string responseMessage; int propertyType; int propertyPrice; int propertyBedroom; int propertyBathroom; int propertySquarefeet; int isFeatured; int userID; int lastInsertedPropertyID; propertyName = txtPropertyName.Text; propertyLocation = txtPropertyLocation.Text; propertyDescription = txtPropertyDescription.InnerText; propertyAddress = txtPropertyAddress.Text; propertyType = int.Parse(ddlPropertyType.SelectedItem.Value); propertyPrice = int.Parse(txtPropertyPrice.Text); propertyBedroom = int.Parse(txtBedRoom.Text); propertyBathroom = int.Parse(txtBathRoom.Text); propertySquarefeet = int.Parse(txtSquareFeet.Text); if (cbFeatured.Checked == true) { isFeatured = Constants.isFeatured; } else { isFeatured = Constants.isNotFeatured; } userID = dao.getUserID(sessionUser); if (dao.InsertProperty(propertyType, propertyName, propertyLocation, propertyAddress, propertySquarefeet, propertyBedroom, propertyBathroom, propertyDescription, isFeatured, Constants.isNotApproved, Constants.propertyEnabled, propertyPrice, userID) == true) { List <string> imageFiles = new List <string>(); lastInsertedPropertyID = dao.getLastInsertedPropertyID(); string applicationPath = Constants.path; foreach (var postedFile in uploadwidget.PostedFiles) { string imageName = System.IO.Path.GetFileName(postedFile.FileName); string location = applicationPath + "userassets" + @"\" + sessionUser + @"\propertyImages\" + lastInsertedPropertyID; imageFiles.Add((string)imageName); if (!Directory.Exists(location)) { Directory.CreateDirectory(location); } string SaveLocation = location + "\\" + imageName; try { postedFile.SaveAs(SaveLocation); dao.InsertPropertyImages(lastInsertedPropertyID, userID, imageName); } catch (Exception ex) { Response.Write(ex.Message); } } dao.UpdateImagetoPropertyTable(lastInsertedPropertyID, imageFiles[0]); responseMessage = "Property Submitted"; respMessage.Text = responseMessage; } else { Console.WriteLine("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 } }