PageRenderTime 47ms CodeModel.GetById 20ms RepoModel.GetById 0ms app.codeStats 0ms

/SocialBook/AddBookmark.aspx.cs

http://webmarker.googlecode.com/
C# | 109 lines | 104 code | 2 blank | 3 comment | 4 complexity | 14b40007380ca54310004a763f5ce523 MD5 | raw file
Possible License(s): LGPL-2.1
  1. using System;
  2. using System.Collections;
  3. using System.Configuration;
  4. using System.Data;
  5. using System.Linq;
  6. using System.Web;
  7. using System.Web.Security;
  8. using System.Web.UI;
  9. using System.Web.UI.HtmlControls;
  10. using System.Web.UI.WebControls;
  11. using System.Web.UI.WebControls.WebParts;
  12. using System.Xml.Linq;
  13. using System.Collections.Generic;
  14. using System.Data.Sql;
  15. using System.Data.SqlClient;
  16. using System.Data.Linq;
  17. using System.Data.Linq.Mapping;
  18. public class Customceva
  19. {
  20. //din aspnet_User
  21. public string UserName { get; set; }
  22. //din Bookmark
  23. public decimal Index { get; set; }
  24. public string Titlu { get; set; }
  25. public string Link { get; set; }
  26. public string Owner { get; set; }
  27. public string Descriere { get; set; }
  28. public string Taguri { get; set; }
  29. public System.Nullable<int> Voturi { get; set; }
  30. //din Comments
  31. public string Message { get; set; }
  32. }
  33. public partial class AddBookmark : System.Web.UI.Page
  34. {
  35. protected void Generate(String titlu, String link) {
  36. WebsitesScreenshot.WebsitesScreenshot _WebsitesScreenshot = new WebsitesScreenshot.WebsitesScreenshot();
  37. WebsitesScreenshot.WebsitesScreenshot.Result _Result;
  38. string path = null;
  39. path = Server.MapPath(".");
  40. _WebsitesScreenshot.ImageHeight = 160;
  41. _WebsitesScreenshot.ImageWidth = 160;
  42. if(link.Contains("http"))
  43. _Result = _WebsitesScreenshot.CaptureWebpage(link);
  44. else
  45. _Result = _WebsitesScreenshot.CaptureWebpage("http://" + link);
  46. if (_Result == WebsitesScreenshot.WebsitesScreenshot.Result.Captured)
  47. {
  48. _WebsitesScreenshot.SaveImage(path + "\\screens\\" + titlu.Replace('/', '_') + ".jpg");
  49. Response.Write("");
  50. Response.Write("<img src="+titlu+">");
  51. }
  52. else if (_Result == WebsitesScreenshot.WebsitesScreenshot.Result.Failed)
  53. {
  54. Response.Write("");
  55. Response.Write("Failed");
  56. }
  57. else if (_Result == WebsitesScreenshot.WebsitesScreenshot.Result.Timeout)
  58. {
  59. Response.Write("");
  60. Response.Write("Timeout");
  61. }
  62. _WebsitesScreenshot.Dispose();
  63. }
  64. protected void Page_Load(object sender, EventArgs e)
  65. {
  66. TextBoxOwner.Text = Page.User.Identity.Name;
  67. }
  68. protected void Button1_Click(object sender, EventArgs e)
  69. {
  70. Generate(Convert.ToString(TextBoxTitlu.Text), Convert.ToString(TextBoxLink.Text));
  71. SqlConnection connection = new SqlConnection(
  72. @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True"
  73. );
  74. connection.Open();
  75. SqlCommand query = new SqlCommand("INSERT INTO Bookmark (Titlu, Owner, Descriere, Taguri, Link) VALUES (@Titlu, @Owner, @Descriere, @Taguri, @Link)", connection);
  76. SqlParameter param1 = new SqlParameter("@Titlu", Convert.ToString(TextBoxTitlu.Text));
  77. SqlParameter param5 = new SqlParameter("@Link", Convert.ToString(TextBoxLink.Text));
  78. SqlParameter param2 = new SqlParameter("@Owner", null );
  79. DataContext db = new DataContext("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\ASPNETDB.MDF;Integrated Security=True;User Instance=True;");
  80. Table<aspnet_User> aspnet_Users = db.GetTable<aspnet_User>();
  81. Decimal URIvar = System.Convert.ToDecimal(Request["id"]);
  82. IQueryable<Customceva> BookmarkQuery = from s in aspnet_Users
  83. where s.UserName == Convert.ToString(TextBoxOwner.Text)
  84. select new Customceva { Owner = s.UserId };
  85. foreach (Customceva i in BookmarkQuery)
  86. {
  87. param2 = new SqlParameter("@Owner", i.Owner );
  88. }
  89. SqlParameter param3 = new SqlParameter("@Descriere", Convert.ToString(TextBoxDescriere.Text));
  90. SqlParameter param4 = new SqlParameter("@Taguri", Convert.ToString(TextBoxTaguri.Text));
  91. query.Parameters.Add(param1);
  92. query.Parameters.Add(param2);
  93. query.Parameters.Add(param3);
  94. query.Parameters.Add(param4);
  95. query.Parameters.Add(param5);
  96. query.ExecuteNonQuery();
  97. connection.Close();
  98. Response.Redirect("~/MyBookmarks.aspx");
  99. }
  100. }