/// <summary> /// Returns the contact view and lists all agents /// </summary> /// <returns></returns> public ActionResult Contact() { ViewBag.Message = "Contact us"; List<Agent> agents = new List<Agent>(); MySqlConnection connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString); connection.Open(); MySqlCommand command = connection.CreateCommand(); command.CommandText = "Select Agent_Id, Agent_Name, Agent_Surname, Agent_Phone, Agent_Email, Agent_Description from Agent"; MySqlDataReader reader = command.ExecuteReader(); while(reader.Read()) { Agent agent = new Agent() { Agent_Email = reader.GetString("Agent_Email"), Agent_Id = reader.GetInt32("Agent_Id"), Agent_Name = reader.GetString("Agent_Name"), Agent_Phone = reader.GetString("Agent_Phone"), Agent_Surname = reader.GetString("Agent_Surname"), Agent_Description = reader.GetString("Agent_Description") }; agents.Add(agent); } ViewBag.Agents = agents.ToArray(); return View(); }
/// <summary> /// Lists a residence for a specific id /// </summary> /// <returns></returns> public ActionResult Residence() { string id = Request.QueryString["id"]; if (id != null) { } else return View(); MySqlConnection connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString); connection.Open(); MySqlCommand command = connection.CreateCommand(); command.CommandText = "Select List_ID, List_Price, Property_Description, Property_Bedroom_Count, Property_Bathroom_Count, Property_Garage_Count," + " Property_Value, Address_Streetname, Address_Streetno, Area_Name, City_Name, Province_Name, List_Description, Property_hasPool, Property_Plot_Size," + " Address_Longitude, Address_Latitude, Property.Property_ID, City_Id, City_Name, Property_House_Size, Agent_ID" + " from Listing, Property, Address, Area, City, Province where " + "Listing.Property_ID = Property.Property_ID and Property.Address_ID = Address.Address_ID and Address.Area_ID = Area.Area_Id and Area.Area_City_Id = City.City_Id" + " and Province.Province_ID= City.City_Province_ID and Listing.List_ID = @listing_id"; command.Parameters.Add("@listing_id", id); MySqlDataReader reader = command.ExecuteReader(); reader.Read(); int property_id = reader.GetInt32("Property_ID"); string street_address = reader.GetString("Address_Streetname") + " " + reader.GetString("Address_streetno"); int agent_id = reader.GetInt32("Agent_ID"); ViewBag.ListID = reader.GetInt32("List_ID"); ViewBag.id = id; // ViewBag.name = reader.GetString("name"); ViewBag.street_address = street_address; ViewBag.no_bathrooms = reader.GetInt32("Property_Bathroom_Count"); ViewBag.no_bedrooms = reader.GetInt32("Property_Bedroom_Count"); ViewBag.no_garages = reader.GetInt32("Property_Garage_Count"); ViewBag.swimmingpool = reader.GetInt32("Property_hasPool") == 1 ? "True" : "False"; ViewBag.area = reader.GetInt32("Property_Plot_Size"); ViewBag.city_id = reader.GetInt32("City_Id"); ViewBag.city = reader.GetString("City_Name"); ViewBag.province = reader.GetString("Province_Name");// reader.GetString("province"); // ViewBag.postal_code = reader.GetString("postal_code"); ViewBag.property_description = reader.GetString("Property_Description"); ViewBag.listing_description = reader.GetString("List_Description"); ViewBag.lattitude = reader.GetFloat("Address_Latitude"); ViewBag.longitude = reader.GetFloat("Address_Longitude"); //ViewBag.ImagePreview = reader.GetString("preview_image"); float price = reader.GetFloat("List_Price"); var nfi = (NumberFormatInfo)CultureInfo.InvariantCulture.NumberFormat.Clone(); nfi.NumberGroupSeparator = " "; string formatted = price.ToString("#,#", nfi); // "1 234 897.11" ViewBag.price = string.Format("R {0}", formatted); //ViewBag.StreetView = string.Format("https://www.google.com/maps/embed/v1/streetview?location={0}&key={1}", street_address, "AIzaSyDlnvQdhrcHR6dv2UyyVmzWT_pzaPcmwTo"); ViewBag.StreetView = string.Format("https://www.google.com/maps/embed/v1/streetview?location={0}%2C{1}&key={2}", ViewBag.lattitude, ViewBag.longitude, "AIzaSyDlnvQdhrcHR6dv2UyyVmzWT_pzaPcmwTo"); ViewBag.Map = string.Format("https://www.google.com/maps/embed/v1/place?&q={0}&key=AIzaSyDlnvQdhrcHR6dv2UyyVmzWT_pzaPcmwTo", street_address); ViewBag.name = ViewBag.street_address; connection.Close(); List<string> images = new List<string>(); connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString); connection.Open(); command = connection.CreateCommand(); command.CommandText = "Select Image_URL, Image_Caption from Image where Property_ID = @property_id"; command.Parameters.Add("@property_id", property_id); reader = command.ExecuteReader(); while (reader.Read()) { string image_url = reader.GetString("Image_URL"); // string image_caption = reader.GetString("Image_Caption"); images.Add(image_url); } ViewBag.Images = images; connection.Close(); connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString); connection.Open(); command = connection.CreateCommand(); command.CommandText = "Select Agent_Id, Agent_Name, Agent_Surname, Agent_Phone, Agent_Email, Agent_Image_URL, Agent_Description from Agent where Agent_ID = @agent_id"; command.Parameters.AddWithValue("@agent_id", agent_id); reader = command.ExecuteReader(); reader.Read(); string agent_image_url = "/Assets/Images/default-profile.png"; try { agent_image_url = reader.GetString("Agent_Image_URL"); } catch { } Agent agent = new Agent() { Agent_Email = reader.GetString("Agent_Email"), Agent_Id = reader.GetInt32("Agent_Id"), Agent_Name = reader.GetString("Agent_Name"), Agent_Phone = reader.GetString("Agent_Phone"), Agent_Surname = reader.GetString("Agent_Surname"), Agent_Description = reader.GetString("Agent_Description"), Image_URL = agent_image_url }; ViewBag.Agent = agent; connection.Close(); ViewBag.User = DataController.GetCurrentUser(); return View(); }