protected void btnReplyAd_ServerClick(object sender, EventArgs e) { AdService.AdCRUDClient adService = new AdService.AdCRUDClient(); adService.Open(); String[] userdetails = adService.getUserEmail(adnum); adService.Close(); if (txtName.Value == "" || txtemail.Value == "" || txtMessage.Value == "") { replysentdiv.InnerHtml = "<p class='red-text'>Please fill in all the appropriate fields</p>"; } else { NetworkCredential netCred = new NetworkCredential("*****@*****.**", "IFMTYP2016"); SmtpClient smtpobj = new SmtpClient("smtp.gmail.com", 587); smtpobj.EnableSsl = true; smtpobj.Credentials = netCred; //smtpobj.DeliveryMethod = SmtpDeliveryMethod.Network; MailMessage mailMessage = new MailMessage(); mailMessage.From = new MailAddress("*****@*****.**", "twoGames"); mailMessage.To.Add(new MailAddress(userdetails[0])); mailMessage.Subject = "You have a reply to your ad \"" + (string)adDetails[1] + "\""; mailMessage.IsBodyHtml = true; mailMessage.Body = "<h1>Hi " + userdetails[1] + ",</h1><br/>"; mailMessage.Body += "<b>" + txtName.Value + "</b> has replied to your advert <b>\"" + (string)adDetails[1] + "\"</b>"; mailMessage.Body += "<br/><br/>"; mailMessage.Body += "Their message: <br/>"; mailMessage.Body += "\"<i>" + txtMessage.Value + "</i>\""; mailMessage.Body += "<br/><br/><a href='mailto:" + txtemail.Value + "?subject=[twoGames] \"" + (string)adDetails[1] + "\" Advert'><button>Click here to reply</button></a>"; mailMessage.Body += "<br/><br/>Kind Regards<br/>twoGames"; try { smtpobj.Send(mailMessage); btnReplyAd.Visible = false; replysentdiv.InnerHtml = "<p>Your message has been sent successfully.</p>"; } catch (SmtpException ex) { replysentdiv.InnerHtml = "<p class='red-text'>Failed to send your message. Please try again.</p>"; } } }
protected void flagAd_ServerClick(object sender, EventArgs e) { if (Session["User"] != null) { if (((UserData)Session["User"]).isAdmin() == 1 || ((UserData)Session["User"]).isMod() == 1) { AdService.AdCRUDClient adService = new AdService.AdCRUDClient(); adService.Open(); int flagAdResult = adService.flagAd(Convert.ToInt32((string)this.adDetails[0])); adService.Close(); if (flagAdResult == 1) { detailedAdActionResutView.InnerHtml = "<div class='col s12 m6 l4 push-l4 push-m3'>"; detailedAdActionResutView.InnerHtml += "<div class='card'>"; detailedAdActionResutView.InnerHtml += "<div class='card-content black-text'>"; detailedAdActionResutView.InnerHtml += "<span class='card-title bold'>Ad Flagged Successfully</span>"; detailedAdActionResutView.InnerHtml += "<p>You have successfully flagged this ad. Our proficient team of Moderators and Administrators will review the ad and decide its fate.<br/><br/>We personally thank you for making twoGames even better!</p><br/>"; detailedAdActionResutView.InnerHtml += "<div class='card-action'>"; detailedAdActionResutView.InnerHtml += "<a href='Index.aspx' runat='server' class='btn waves-effect waves-light'>Continue</a>"; detailedAdActionResutView.InnerHtml += " <a href='AdManagement.aspx' runat='server' class='btn waves-effect waves-light orange lighten-2'>Manage Ads</a>"; detailedAdActionResutView.InnerHtml += "</div></div></div></div>"; } else { detailedAdActionResutView.InnerHtml = "<div class='col s12 m6 l4 push-l4 push-m3'>"; detailedAdActionResutView.InnerHtml += "<div class='card'>"; detailedAdActionResutView.InnerHtml += "<div class='card-content black-text'>"; detailedAdActionResutView.InnerHtml += "<span class='card-title bold'>Ad Flagged Unsuccessfully</span>"; detailedAdActionResutView.InnerHtml += "<p>An error occured trying to flag this ad. You can go back and try again.</p><br/>"; detailedAdActionResutView.InnerHtml += "<div class='card-action'>"; detailedAdActionResutView.InnerHtml += "<a href='DetailedAd.aspx?" + (string)adDetails[0] + "' runat='server' class='btn waves-effect waves-light'>Go Back</a>"; detailedAdActionResutView.InnerHtml += " <a href='AdManagement.aspx' runat='server' class='btn waves-effect waves-light orange lighten-2'>Manage Ads</a>"; detailedAdActionResutView.InnerHtml += "</div></div></div></div>"; } } else { Response.Redirect("Index.aspx"); } } else { Response.Redirect("Index.aspx"); } }
protected void unflagAd_ServerClick(object sender, EventArgs e) { if (Session["User"] != null) { if (((UserData)Session["User"]).isAdmin() == 1 || ((UserData)Session["User"]).isMod() == 1) { AdService.AdCRUDClient adService = new AdService.AdCRUDClient(); adService.Open(); int unflagAdResult = adService.unflagAd(Convert.ToInt32((string)this.adDetails[0])); adService.Close(); if (unflagAdResult == 1) { detailedAdActionResutView.InnerHtml = "<div class='col s12 m6 l4 push-l4 push-m3'>"; detailedAdActionResutView.InnerHtml += "<div class='card'>"; detailedAdActionResutView.InnerHtml += "<div class='card-content black-text'>"; detailedAdActionResutView.InnerHtml += "<span class='card-title bold'>Ad Unflagged Successfully</span>"; detailedAdActionResutView.InnerHtml += "<p>You have successfully unflagged this ad.</p><br/>"; detailedAdActionResutView.InnerHtml += "<div class='card-action'>"; detailedAdActionResutView.InnerHtml += " <a href='AdManagement.aspx' runat='server' class='btn waves-effect waves-light orange lighten-2'>Manage Ads</a>"; detailedAdActionResutView.InnerHtml += "</div></div></div></div>"; } else { detailedAdActionResutView.InnerHtml = "<div class='col s12 m6 l4 push-l4 push-m3'>"; detailedAdActionResutView.InnerHtml += "<div class='card'>"; detailedAdActionResutView.InnerHtml += "<div class='card-content black-text'>"; detailedAdActionResutView.InnerHtml += "<span class='card-title bold'>Ad Unflagged Unsuccessfully</span>"; detailedAdActionResutView.InnerHtml += "<p>An error occured trying to unflag this ad. You can go back and try again.</p><br/>"; detailedAdActionResutView.InnerHtml += "<div class='card-action'>"; detailedAdActionResutView.InnerHtml += "<a href='DetailedAd.aspx?" + (string)adDetails[0] + "' runat='server' class='btn waves-effect waves-light'>Go Back</a>"; detailedAdActionResutView.InnerHtml += " <a href='AdManagement.aspx' runat='server' class='btn waves-effect waves-light orange lighten-2'>Manage Ads</a>"; detailedAdActionResutView.InnerHtml += "</div></div></div></div>"; } } else { Response.Redirect("Index.aspx"); } } else { Response.Redirect("Index.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Title = "twoGAMES: Search"; //string searchTerm = Request.QueryString.Get("search"); searchedAdsDisplay.InnerHtml = ""; //txtSearch.Value = ""; ----------breaks search when button clicked //Retrieve and populate platforms list AdService.AdCRUDClient service = new AdService.AdCRUDClient(); service.Open(); Object[] platforms = service.getPlatforms(); if (!(platforms == null)) { //PlatformDrop.Items.Add(new ListItem("Platform","")); //InnerHtml = "<option value='' disabled selected>Platform</option>"; PlatformDrop.Items.Clear(); PlatformDrop.Items.Add(new ListItem("All", "default")); for (int i = 0; i <= platforms.Length - 1; i++) { PlatformDrop.Items.Add(new ListItem(Convert.ToString(platforms[i]), Convert.ToString(platforms[i]))); //PlatformDrop.InnerHtml += "<option value='"+ Convert.ToString(platforms[i]) + "' disabled selected>" + Convert.ToString(platforms[i]) + "</option>"; } } else { PlatformDrop.Items.Add(new ListItem("XBOX ONE", "XBOX ONE")); PlatformDrop.Items.Add(new ListItem("PS4", "PS4")); PlatformDrop.Items.Add(new ListItem("XBOX 360", "XBOX 360")); PlatformDrop.Items.Add(new ListItem("PS3", "PS3")); PlatformDrop.Items.Add(new ListItem("3DS", "3DS")); PlatformDrop.Items.Add(new ListItem("WII U", "WII U")); PlatformDrop.Items.Add(new ListItem("GAMECUBE", "GAMECUBE")); } service.Close(); txtSearch.Focus(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["User"] == null) { Response.Redirect("Login.aspx"); } else { Title = "twoGAMES: Post Ad"; //Retrieve and populate platforms list AdService.AdCRUDClient service = new AdService.AdCRUDClient(); service.Open(); Object[] platforms = service.getPlatforms(); if (!(platforms == null)) { //PlatformDrop.Items.Add(new ListItem("Platform","")); //InnerHtml = "<option value='' disabled selected>Platform</option>"; for (int i = 0; i <= platforms.Length - 1; i++) { PlatformDrop.Items.Add(new ListItem(Convert.ToString(platforms[i]), Convert.ToString(platforms[i]))); //PlatformDrop.InnerHtml += "<option value='"+ Convert.ToString(platforms[i]) + "' disabled selected>" + Convert.ToString(platforms[i]) + "</option>"; } } else { PlatformDrop.Items.Add(new ListItem("XBOX ONE", "XBOX ONE")); PlatformDrop.Items.Add(new ListItem("PS4", "PS4")); PlatformDrop.Items.Add(new ListItem("XBOX 360", "XBOX 360")); PlatformDrop.Items.Add(new ListItem("PS3", "PS3")); PlatformDrop.Items.Add(new ListItem("3DS", "3DS")); PlatformDrop.Items.Add(new ListItem("WII U", "WII U")); PlatformDrop.Items.Add(new ListItem("GAMECUBE", "GAMECUBE")); } service.Close(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["User"] == null) { Response.Redirect("Login.aspx"); } else if (((UserData)Session["User"]).isAdmin() == 0) { Response.Redirect("Index.aspx"); } else { Title = "twoGAMES: Users Ads"; //Populate with table of users ads AdService.AdCRUDClient adCRUDService = new AdService.AdCRUDClient(); adCRUDService.Open(); Object[][] ads = adCRUDService.getUsersAdsManagement(Convert.ToInt32(Request.QueryString.Get("id"))); adCRUDService.Close(); usersAdsView.InnerHtml = createUsersAdsView(ads, "There are no ads for user \"" + Request.QueryString.Get("user") + "\".", "Viewing " + Request.QueryString.Get("user") + "'s Ads"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["User"] != null) //Logged in { indexTitle.InnerHtml = "Welcome " + ((UserData)Session["User"]).getFirstName() + ", here are the latest ads"; } Title = "twoGAMES: Home"; AdService.AdCRUDClient adCRUDService = new AdService.AdCRUDClient(); adCRUDService.Open(); Object[][] ads = adCRUDService.getRecentlyAdded(); adCRUDService.Close(); if (ads != null) { string recentAds = "<div class='row'>"; for (int k = 0; k < ads.Length; k++) { if ((k % 2) != 0) { recentAds += AdCard.createAdCard((string)ads[k][0], (string)ads[k][1], (string)ads[k][2], (string)ads[k][3], (string)ads[k][4], (string)ads[k][5], Convert.ToBoolean(ads[k][6]), "DetailedAd.aspx", false); recentAds += "</div>"; recentAds += "<div class=\"row\">"; } else { recentAds += AdCard.createAdCard((string)ads[k][0], (string)ads[k][1], (string)ads[k][2], (string)ads[k][3], (string)ads[k][4], (string)ads[k][5], Convert.ToBoolean(ads[k][6]), "DetailedAd.aspx", false); } } recentAds += "</div>"; recentlyAddedView.InnerHtml = recentAds; } }
//private string pic1server = ""; //private string pic2server = ""; //private string pic3server = ""; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["User"] != null) { string adID = Request.QueryString.Get("ad"); AdService.AdCRUDClient adService = new AdService.AdCRUDClient(); adService.Open(); Object[] platforms = adService.getPlatforms(); if (!(platforms == null)) { //PlatformDrop.Items.Add(new ListItem("Platform","")); //InnerHtml = "<option value='' disabled selected>Platform</option>"; for (int i = 0; i <= platforms.Length - 1; i++) { drpGamePlatform.Items.Add(new ListItem(Convert.ToString(platforms[i]), Convert.ToString(platforms[i]))); //PlatformDrop.InnerHtml += "<option value='"+ Convert.ToString(platforms[i]) + "' disabled selected>" + Convert.ToString(platforms[i]) + "</option>"; } } else { drpGamePlatform.Items.Add(new ListItem("XBOX ONE", "XBOX ONE")); drpGamePlatform.Items.Add(new ListItem("PS4", "PS4")); drpGamePlatform.Items.Add(new ListItem("XBOX 360", "XBOX 360")); drpGamePlatform.Items.Add(new ListItem("PS3", "PS3")); drpGamePlatform.Items.Add(new ListItem("3DS", "3DS")); drpGamePlatform.Items.Add(new ListItem("WII U", "WII U")); drpGamePlatform.Items.Add(new ListItem("GAMECUBE", "GAMECUBE")); } Object[] adDetails = adService.getAdDetails(adID); adService.Close(); //----------------TITLE txtGameTile.Value = (string)adDetails[1]; Title = "twoGAMES: " + (string)adDetails[1]; txtGamePrice.Value = (string)adDetails[6]; if (!((string)adDetails[9]).Equals("NOPIC")) { pic1Thumb.InnerHtml = "<img class='thumb' src='data:image/jpeg;base64," + (string)adDetails[9] + "'/>"; } if (!((string)adDetails[10]).Equals("NOPIC")) { pic2Thumb.InnerHtml = "<img class='thumb' src='data:image/jpeg;base64," + (string)adDetails[10] + "'/>"; } if (!((string)adDetails[11]).Equals("NOPIC")) { pic3Thumb.InnerHtml = "<img class='thumb' src='data:image/jpeg;base64," + (string)adDetails[11] + "'/>"; } drpGamePlatform.Items.FindByText((string)adDetails[2]).Selected = true; txtGameDescription.Value = (string)adDetails[4]; txtGameLocation.Value = (string)adDetails[5]; //pic1server = (string)adDetails[9]; //pic2server = (string)adDetails[10]; //pic3server = (string)adDetails[11]; Session["pic1"] = (string)adDetails[9]; Session["pic2"] = (string)adDetails[10]; Session["pic3"] = (string)adDetails[11]; if (Convert.ToBoolean(adDetails[8])) { ShowPhone.Checked = true; } else { ShowPhone.Checked = false; } if (Convert.ToBoolean(adDetails[7])) { NegotiableCheck.Checked = true; } else { NegotiableCheck.Checked = false; } } else { Response.Redirect("Login.aspx"); } } }
protected void btnUpdateAd_ServerClick(object sender, EventArgs e) { Boolean postad = true; if (txtGameTile.Value.Equals("") || txtGamePrice.Value == null || drpGamePlatform.Items[drpGamePlatform.SelectedIndex].Text.Equals("Platform") || txtGameDescription.Value.Equals("")) { InvlaidPostAd.InnerHtml = "<p>Please fill in all the fields</p>"; postad = false; } else { try { int temp = Int32.Parse(txtGamePrice.Value); } catch (FormatException ex) { txtGamePrice.Value = ""; InvlaidPostAd.InnerHtml = "<p>Please fill in a price</p>"; postad = false; } } if (postad) { int negChecked = 0; int ShowPhoneChecked = 0; if (NegotiableCheck.Checked) { negChecked = 1; } if (ShowPhone.Checked) { ShowPhoneChecked = 1; } //**************Check files exist******************** //string base64String1 = ""; //string base64String2 = ""; //string base64String3 = ""; //Check if there is a file 1 if (pic1files.PostedFile.ContentLength != 0) { string base64String1 = ImageFunctions.validateImage(new BinaryReader(pic1files.PostedFile.InputStream).ReadBytes(pic1files.PostedFile.ContentLength)); if (base64String1.Equals("NOPIC")) { InvlaidPostAd.InnerHtml = "<p>Picture 1 is an invalid image. Please attach only the pictures you took of your game.</p>"; return; } Session["pic1"] = base64String1; /* * //convert pic 1 to byte[] * byte[] pic1Data = null; * using (var binaryReader = new BinaryReader(pic1files.PostedFile.InputStream)) * { * pic1Data = CompressImage(binaryReader.ReadBytes(pic1files.PostedFile.ContentLength)); * } * * /*base64String1 this.pic1server Session["pic1"] = Convert.ToBase64String(pic1Data);*/ } /*else * base64String1 = "NOPIC";*/ //Check if there is a file 2 if (pic2files.PostedFile.ContentLength != 0) { string base64String2 = ImageFunctions.validateImage(new BinaryReader(pic2files.PostedFile.InputStream).ReadBytes(pic2files.PostedFile.ContentLength)); if (base64String2.Equals("NOPIC")) { InvlaidPostAd.InnerHtml = "<p>Picture 2 is an invalid image. Please attach only the pictures you took of your game.</p>"; return; } Session["pic2"] = base64String2; /* * //convert pic 2 to byte[] * byte[] pic2Data = null; * using (var binaryReader = new BinaryReader(pic2files.PostedFile.InputStream)) * { * pic2Data = CompressImage(binaryReader.ReadBytes(pic2files.PostedFile.ContentLength)); * } * base64String2 this.pic2server Session["pic2"] = Convert.ToBase64String(pic2Data);*/ } /*else * base64String2 = "NOPIC";*/ //Check if there is a file 3 if (pic3files.PostedFile.ContentLength != 0) { string base64String3 = ImageFunctions.validateImage(new BinaryReader(pic3files.PostedFile.InputStream).ReadBytes(pic3files.PostedFile.ContentLength)); if (base64String3.Equals("NOPIC")) { InvlaidPostAd.InnerHtml = "<p>Picture 3 is an invalid image. Please attach only the pictures you took of your game.</p>"; return; } Session["pic3"] = base64String3; /* * //convert pic 3 to byte[] * byte[] pic3Data = null; * using (var binaryReader = new BinaryReader(pic3files.PostedFile.InputStream)) * { * pic3Data = CompressImage(binaryReader.ReadBytes(pic3files.PostedFile.ContentLength)); * } * base64String3 this.pic3server * Session["pic3"] = Convert.ToBase64String(pic3Data);*/ } /*else * base64String3 = "NOPIC";*/ /*if (base64String1.Equals("NOPIC")) * { * if (!pic1server.Equals("NOPIC")) * base64String1 = pic1server; * } * if (base64String2.Equals("NOPIC")) * { * if (!pic2server.Equals("NOPIC")) * base64String2 = pic2server; * } * if (base64String3.Equals("NOPIC")) * { * if (!pic3server.Equals("NOPIC")) * base64String3 = pic3server; * }*/ //byte[][] sendPics = new byte[3][]; // sendPics[0] = pic1Data; // sendPics[1] = pic2Data; //sendPics[2] = pic3Data; //-------------------------------------------------------------------------- UserData user = (UserData)Session["User"]; AdService.AdCRUDClient service = new AdService.AdCRUDClient(); service.Open(); string adID = Request.QueryString.Get("ad"); int success = service.updateAd(Convert.ToInt32(adID), txtGameTile.Value, drpGamePlatform.Items[drpGamePlatform.SelectedIndex].Text, txtGameDescription.Value, txtGameLocation.Value, Convert.ToDouble(txtGamePrice.Value), negChecked, ShowPhoneChecked, /*base64String1 this.pic1server*/ (string)Session["pic1"], /*base64String2 this.pic2server*/ (string)Session["pic2"], /*base64String3 this.pic3server*/ (string)Session["pic3"], user.isPrem()); if (success == 1) { editAdDiv.InnerHtml = "<div class='col s12 m6 push-m3'>"; editAdDiv.InnerHtml += "<div class='card white'>"; editAdDiv.InnerHtml += "<div class='card-content Black-text'>"; editAdDiv.InnerHtml += "<span class='card-title bold'>Ad Updated Successfully</span>"; editAdDiv.InnerHtml += "<p>You have successfully Updated your ad. To view your ad, proceeed to the My Ads page.</p>"; editAdDiv.InnerHtml += "</div>"; editAdDiv.InnerHtml += "<div class='card-action'>"; editAdDiv.InnerHtml += "<a href='MyAds.aspx' runat='server' class='btn waves-effect waves-light'>My Ads</a>"; editAdDiv.InnerHtml += "</div>"; editAdDiv.InnerHtml += "</div>"; editAdDiv.InnerHtml += "</div>"; } else { editAdDiv.InnerHtml = "<div class='col s12 m6 push-m3'>"; editAdDiv.InnerHtml += "<div class='card white'>"; editAdDiv.InnerHtml += "<div class='card-content Black-text'>"; editAdDiv.InnerHtml += "<span class='card-title bold'>Ad Update Unsuccessfully</span>"; editAdDiv.InnerHtml += "<p>We where unable to update your add. Please try again and if the problem persists pleas contact us <a href='ContactUs.aspx'>here</a>.</p>"; editAdDiv.InnerHtml += "</div>"; editAdDiv.InnerHtml += "<div class='card-action'>"; editAdDiv.InnerHtml += "<a href='MyAds.aspx' runat='server' class='btn waves-effect waves-light'>Continue</a>"; editAdDiv.InnerHtml += "</div>"; editAdDiv.InnerHtml += "</div>"; editAdDiv.InnerHtml += "</div>"; } service.Close(); Session["pic1"] = null; Session["pic2"] = null; Session["pic3"] = null; } }
protected void btnSearch_ServerClick(object sender, EventArgs e) { searchedAdsDisplay.InnerHtml = ""; if (txtSearch.Value.Equals("")) { searchedAdsDisplay.InnerHtml = "<div class='col s12 m10 l8 push-m1 push-l2'>"; searchedAdsDisplay.InnerHtml += "<div class='card white'>"; searchedAdsDisplay.InnerHtml += "<div class='card-content Black-text'>"; searchedAdsDisplay.InnerHtml += "<span class='card-title bold'>Ah Ha...Gotcha!</span>"; searchedAdsDisplay.InnerHtml += "<div class='row'>"; searchedAdsDisplay.InnerHtml += "<p>See what you did there. Try entering a search term now...who knows what will happen?</p>"; searchedAdsDisplay.InnerHtml += "</div>"; searchedAdsDisplay.InnerHtml += "</div>"; searchedAdsDisplay.InnerHtml += "</div>"; searchedAdsDisplay.InnerHtml += "</div>"; txtSearch.Value = ""; txtSearch.Focus(); return; } AdService.AdCRUDClient adCRUDService = new AdService.AdCRUDClient(); adCRUDService.Open(); Object[][] ads = null; //-------FILTERS string strSQLFilters = ""; string strSQLOrderBys = ""; //-------SORT DROP if (SortDrop.Items[SortDrop.SelectedIndex].Value.Equals("titleAZ")) { strSQLOrderBys = "aTitle ASC, "; } else if (SortDrop.Items[SortDrop.SelectedIndex].Value.Equals("titleZA")) { strSQLOrderBys = "aTitle DESC, "; } else if (SortDrop.Items[SortDrop.SelectedIndex].Value.Equals("platformAZ")) { strSQLOrderBys = "aPlatform ASC, "; } else if (SortDrop.Items[SortDrop.SelectedIndex].Value.Equals("platformZA")) { strSQLOrderBys = "aPlatform DESC, "; } else if (SortDrop.Items[SortDrop.SelectedIndex].Value.Equals("priceHighLow")) { strSQLOrderBys = "aPrice DESC, "; } else if (SortDrop.Items[SortDrop.SelectedIndex].Value.Equals("priceLowHigh")) { strSQLOrderBys = "aPrice ASC, "; } //-------PLATFORM DROP if (!PlatformDrop.Items[PlatformDrop.SelectedIndex].Value.Equals("default")) { strSQLFilters += "AND (aPlatform='" + PlatformDrop.Items[PlatformDrop.SelectedIndex].Value + "') "; } //-------LOCATION DROP if (!LocationDrop.Items[LocationDrop.SelectedIndex].Value.Equals("default")) { strSQLFilters += "AND (aLocation LIKE '%" + LocationDrop.Items[LocationDrop.SelectedIndex].Value + "%') "; } //-------PRICE DROP if (PriceDrop.Items[PriceDrop.SelectedIndex].Value.Equals("0-100")) { strSQLFilters += "AND (aPrice <= 100) "; } else if (PriceDrop.Items[PriceDrop.SelectedIndex].Value.Equals("100-200")) { strSQLFilters += "AND (aPrice > 100) AND (aPrice <= 200) "; } else if (PriceDrop.Items[PriceDrop.SelectedIndex].Value.Equals("200-300")) { strSQLFilters += "AND (aPrice > 200) AND (aPrice <= 300) "; } else if (PriceDrop.Items[PriceDrop.SelectedIndex].Value.Equals("300-400")) { strSQLFilters += "AND (aPrice > 300) AND (aPrice <= 400) "; } else if (PriceDrop.Items[PriceDrop.SelectedIndex].Value.Equals("400+")) { strSQLFilters += "AND (aPrice > 400) "; } /*if (((UserData)Session["User"]).isAdmin() == 0 && ((UserData)Session["User"]).isMod() == 0) * {*/ ads = adCRUDService.searchAds(txtSearch.Value, strSQLFilters, strSQLOrderBys); /*} * else * { * ads = adCRUDService.searchAdsManagement(txtSearch.Value, ""); * }*/ adCRUDService.Close(); if (ads != null) { string recentAds = "<div class='row'>"; for (int k = 0; k < ads.Length; k++) { if ((k % 2) != 0) { recentAds += AdCard.createAdCard((string)ads[k][0], (string)ads[k][1], (string)ads[k][2], (string)ads[k][3], (string)ads[k][4], (string)ads[k][5], Convert.ToBoolean(ads[k][6]), "DetailedAd.aspx", false); recentAds += "</div>"; recentAds += "<div class=\"row\">"; } else { recentAds += AdCard.createAdCard((string)ads[k][0], (string)ads[k][1], (string)ads[k][2], (string)ads[k][3], (string)ads[k][4], (string)ads[k][5], Convert.ToBoolean(ads[k][6]), "DetailedAd.aspx", false); } } recentAds += "</div>"; searchedAdsDisplay.InnerHtml = recentAds; txtSearch.Focus(); } else { searchedAdsDisplay.InnerHtml = "<div class='col s12 m10 l8 push-m1 push-l2'>"; searchedAdsDisplay.InnerHtml += "<div class='card white'>"; searchedAdsDisplay.InnerHtml += "<div class='card-content Black-text'>"; searchedAdsDisplay.InnerHtml += "<span class='card-title bold'>Oh No...Where Did They Go?</span>"; searchedAdsDisplay.InnerHtml += "<div class='row'>"; searchedAdsDisplay.InnerHtml += "<p>It looks like you've searched for ads which haven't been posted yet<br/><br/>You can help with that by clicking the \"Register\" button bellow to register your account</p>"; searchedAdsDisplay.InnerHtml += "</div>"; searchedAdsDisplay.InnerHtml += "<div class='row'>"; searchedAdsDisplay.InnerHtml += "<a href=\"Registration.aspx\" runat=\"server\" class=\"btn waves-effect waves-light\">Register</a> "; //searchedAdsDisplay.InnerHtml += "<a href=\"Index.aspx\" runat=\"server\" class=\"btn waves-effect waves-light red\">Cancel</a>"; searchedAdsDisplay.InnerHtml += "</div>"; searchedAdsDisplay.InnerHtml += "</div>"; searchedAdsDisplay.InnerHtml += "</div>"; searchedAdsDisplay.InnerHtml += "</div>"; } }
protected void Page_Load(object sender, EventArgs e) { string adID = Request.QueryString.Get("ad"); bool isnumber = int.TryParse(adID, out adnum); if (isnumber) { AdService.AdCRUDClient adService = new AdService.AdCRUDClient(); adService.Open(); this.adDetails = adService.getAdDetails(adID); adService.incViewCount(Convert.ToInt32(adID)); adService.Close(); if (this.adDetails != null) { //--------------TITLE lblGameTitle.InnerHtml = (string)adDetails[1]; Title = "twoGAMES: " + (string)adDetails[1]; //--------------PRICE lblGamePrice.InnerHtml = "Price: R" + (string)adDetails[6]; //--------------NEGOTIABLE if (Convert.ToBoolean(adDetails[7])) { lblGamePrice.InnerHtml += " Negotiable"; } //--------------USERNAME + PREMIUM ICON UserService.UserCRUDClient userService = new UserService.UserCRUDClient(); userService.Open(); string username = userService.getUsername(Convert.ToInt32((string)adDetails[13])); Boolean premiumUser = Convert.ToBoolean(userService.isUserPrem(Convert.ToInt32((string)adDetails[13]))); userService.Close(); editButtonSpan.InnerHtml = "Posted By: " + username; if (premiumUser) { editButtonSpan.InnerHtml += " <i class='material-icons tooltipped' data-position='right' data-tooltip='Premium Member'>star</i>"; } //--------------ADMIN MOD BUTTONS //editButtonSpan.InnerHtml = ""; if (Session["User"] != null) { if (((UserData)Session["User"]).isAdmin() == 1 || ((UserData)Session["User"]).isMod() == 1) { btnReportAd.Visible = false; if (Convert.ToBoolean((string)adDetails[14])) { btnUnflagAdAdminMod.Visible = true; } else { btnFlagAdAdminMod.Visible = true; } editButtonSpan.InnerHtml += " <a class='btn right waves-effect waves-light orange lighten-2' href='EditAdPage.aspx?ad=" + Request.QueryString.Get("ad") + "'>Edit</a> "; } } //--------------IMAGES if (!((string)adDetails[9]).Equals("NOPIC")) { imgPic1.Src = "data:image/jpeg;base64," + (string)adDetails[9]; } else { imgPic1.Visible = false; } if (!((string)adDetails[10]).Equals("NOPIC")) { imgPic2.Src = "data:image/jpeg;base64," + (string)adDetails[10]; } else { imgPic2.Visible = false; } if (!((string)adDetails[11]).Equals("NOPIC")) { imgPic3.Src = "data:image/jpeg;base64," + (string)adDetails[11]; } else { imgPic3.Visible = false; } //--------------PLATFORM lblGamePlatform.InnerHtml = "Platform: " + (string)adDetails[2]; //--------------DESCRIPTION txtGameDescription.Value = (string)adDetails[4]; //--------------LOCATION txtGameLocation.Value = (string)adDetails[5]; String mapString = (string)adDetails[5]; mapString = mapString.Replace(" ", "+"); adMap.Src = "https://www.google.com/maps/embed/v1/place?key=AIzaSyB7eq5IZFtbXZitO0yI53upIROFqC5RBcY&q=" + mapString; //--------------YOUTUBE SOURCE adYoutubeFrame.Src = "https://www.youtube.com/embed?listType=search&list=" + (string)adDetails[1] + " ign review?theme=light&color=white"; //--------------CELL NUMBER if (Convert.ToBoolean(adDetails[8])) { txtCellNumber.Value = (string)adDetails[16]; } else { sellerCellNumberDiv.InnerHtml = ""; } } } else { Response.Redirect("Index.aspx"); } }
protected void btnPostAd_ServerClick(object sender, EventArgs e) { Boolean postad = true; //string adultResponse = "NOINFO"; //string spoofResponse = "NOINFO"; if (txtGameTitle.Value.Equals("") || txtPrice.Value == null || PlatformDrop.Items[PlatformDrop.SelectedIndex].Text.Equals("Platform") || txtGameDesc.Value.Equals("")) { InvlaidPostAd.InnerHtml = "<p>Please fill in all the fields</p>"; postad = false; return; } else { try { int temp = Int32.Parse(txtPrice.Value); } catch (FormatException ex) { txtPrice.Value = ""; InvlaidPostAd.InnerHtml = "<p>Please fill in a price</p>"; postad = false; return; } catch (OverflowException ex) { txtPrice.Value = ""; InvlaidPostAd.InnerHtml = "<p>It seems the price you entered is two high.</p>"; postad = false; return; } } if (pic1files.PostedFile.ContentLength == 0 && pic2files.PostedFile.ContentLength == 0 && pic3files.PostedFile.ContentLength == 0) { InvlaidPostAd.InnerHtml = "<p>Please add at least one picture</p>"; postad = false; return; } if (postad) { int negChecked = 0; int ShowPhoneChecked = 0; if (NegotiableCheck.Checked) { negChecked = 1; } if (ShowPhone.Checked) { ShowPhoneChecked = 1; } //--------------------------------------------------------------------IMAGES //create service //var visionCredentails = CreateCredentials("C:\\Users\\James McGuire\\Desktop\\IMF third year project-46cd5c28569b.json"); //var visionService = CreateService("twoGames", visionCredentails); //**************Check files exist******************** string base64String1 = ""; string base64String2 = ""; string base64String3 = ""; //----------------Check if there is PIC 1 if (pic1files.PostedFile.ContentLength != 0) { base64String1 = ImageFunctions.validateImage(new BinaryReader(pic1files.PostedFile.InputStream).ReadBytes(pic1files.PostedFile.ContentLength)); if (base64String1.Equals("NOPIC")) { InvlaidPostAd.InnerHtml = "<p>Picture 1 is an invalid image. Please attach only the pictures you took of your game.</p>"; return; } } else { base64String1 = "NOPIC"; } //Check if there is a file 2 if (pic2files.PostedFile.ContentLength != 0) { base64String2 = ImageFunctions.validateImage(new BinaryReader(pic2files.PostedFile.InputStream).ReadBytes(pic2files.PostedFile.ContentLength)); if (base64String2.Equals("NOPIC")) { InvlaidPostAd.InnerHtml = "<p>Picture 2 is an invalid image. Please attach only the pictures you took of your game.</p>"; return; } /* * //convert pic 2 to byte[] * byte[] pic2Data = null; * using (var binaryReader = new BinaryReader(pic2files.PostedFile.InputStream)) * { * pic2Data = binaryReader.ReadBytes(pic2files.PostedFile.ContentLength); * byte[] temp = pic2Data; * * if (IsValidImage(pic2Data) && checkVision(pic2Data)) * { * pic2Data = CompressImage(temp); * base64String2 = Convert.ToBase64String(pic2Data); * } * else * { * InvlaidPostAd.InnerHtml = "<p>Picture 2 is invalid</p>"; * return; * } * }*/ } else { base64String2 = "NOPIC"; } //Check if there is a file 3 if (pic3files.PostedFile.ContentLength != 0) { base64String3 = ImageFunctions.validateImage(new BinaryReader(pic3files.PostedFile.InputStream).ReadBytes(pic3files.PostedFile.ContentLength)); if (base64String3.Equals("NOPIC")) { InvlaidPostAd.InnerHtml = "<p>Picture 3 is an invalid image. Please attach only the pictures you took of your game.</p>"; return; } /* * //convert pic 3 to byte[] * byte[] pic3Data = null; * using (var binaryReader = new BinaryReader(pic3files.PostedFile.InputStream)) * { * pic3Data = binaryReader.ReadBytes(pic3files.PostedFile.ContentLength); * byte[] temp = pic3Data; * * if (IsValidImage(pic3Data) && checkVision(pic3Data)) * { * pic3Data = CompressImage(temp); * base64String3 = Convert.ToBase64String(pic3Data); * } * else * { * InvlaidPostAd.InnerHtml = "<p>Picture 3 is invalid</p>"; * return; * } * }*/ } else { base64String3 = "NOPIC"; } //byte[][] sendPics = new byte[3][]; // sendPics[0] = pic1Data; // sendPics[1] = pic2Data; //sendPics[2] = pic3Data; //-------------------------------------------------------------------------- UserData user = (UserData)Session["User"]; AdService.AdCRUDClient service = new AdService.AdCRUDClient(); service.Open(); //Inserting ad int success = 0; success = service.insertAd(txtGameTitle.Value, PlatformDrop.Items[PlatformDrop.SelectedIndex].Text, DateTime.Today, txtGameDesc.Value, txtLocation.Value, Convert.ToDouble(txtPrice.Value), negChecked, ShowPhoneChecked, base64String1, base64String2, base64String3, user.isPrem(), user.getID()); service.Close(); //string Title, string Platform, DateTime CreatedDate, string Description, string Location, Double Price, int Negotiable, int ShowNumber, String Pic1Path, String Pic2Path, String Pic3Path, int PremiumAd, int UserID if (success == 1) { //remember variable in code bellow postAdDiv.InnerHtml = "<div class='col s12 m6 push-m3'>"; postAdDiv.InnerHtml += "<div class='card white'>"; postAdDiv.InnerHtml += "<div class='card-content Black-text'>"; postAdDiv.InnerHtml += "<span class='card-title bold'>Ad Created Successfully</span>"; postAdDiv.InnerHtml += "<p>You have successfully created your ad. To view your ad, proceeed to the My Ads page.</p>"; postAdDiv.InnerHtml += "</div>"; postAdDiv.InnerHtml += "<div class='card-action'> "; postAdDiv.InnerHtml += "<a href='Index.aspx' class='btn waves-effect waves-light'>Continue</a> "; postAdDiv.InnerHtml += "<a href='MyAds.aspx' class='btn waves-effect waves-light orange lighten-2'>My Ads</a> "; postAdDiv.InnerHtml += "</div>"; postAdDiv.InnerHtml += "</div>"; postAdDiv.InnerHtml += "</div>"; //Object[] temp = service.getAdDetails("25"); //byte[][] temp = service.getPictures(1); //string base64String1 = Convert.ToBase64String(temp[0], 0, temp[0].Length); //temp1.Attributes["src"] = "data:image/jpeg;base64," + temp[9]; //string base64String2 = Convert.ToBase64String(temp[1], 0, temp[1].Length); //temp2.Attributes["src"] = "data:image/jpeg;base64," + temp[10]; //string base64String3 = Convert.ToBase64String(temp[2], 0, temp[2].Length); //temp3.Attributes["src"] = "data:image/jpeg;base64," + temp[11]; } else { postAdDiv.InnerHtml = "<div class='col s12 m6 push-m3'>"; postAdDiv.InnerHtml += "<div class='card white'>"; postAdDiv.InnerHtml += "<div class='card-content Black-text'>"; postAdDiv.InnerHtml += "<span class='card-title bold'>Oh No...An Error Occured</span>"; postAdDiv.InnerHtml += "<p>Unfortunately we were unable to create your ad. Please try again or come back later.<br/>To view your current ads, proceeed to the My Ads page.</p>"; postAdDiv.InnerHtml += "</div>"; postAdDiv.InnerHtml += "<div class='card-action'> "; postAdDiv.InnerHtml += "<a href='Index.aspx' class='btn waves-effect waves-light'>Continue</a> "; postAdDiv.InnerHtml += "<a href='MyAds.aspx' runat='server' class='btn waves-effect waves-light'>My Ads</a> "; postAdDiv.InnerHtml += "</div>"; postAdDiv.InnerHtml += "</div>"; postAdDiv.InnerHtml += "</div>"; } } }