protected void btn_rename_Click(object sender, EventArgs e) { if (Page.IsValid == true) { string sgroupName = txt_rename.Text.Trim(); string sgroupDescription = txt_renameDescription.Text.Trim(); int groupId = Int32.Parse(lit_groupId.Text.Trim()); SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "Group_Update"; cmd.Parameters.Add("@Groupname", SqlDbType.VarChar, 255).Value = sgroupName; cmd.Parameters.Add("@Groupdescription", SqlDbType.VarChar, 420).Value = sgroupDescription; cmd.Parameters.Add("@GroupId", SqlDbType.Int).Value = groupId; cmd.Connection = con; try { con.Open(); cmd.ExecuteNonQuery(); } //catch (SqlException ex) //{ // ErrorMessage.Text = ex.Message; //} finally { cmd.Dispose(); if (con != null) { con.Close(); } PopulateLabels(); // this.commands-boxedit.Visible = false; ListView_PageItems.DataBind(); Masonry(); } } }
protected void imb_addComment_Click(object sender, ImageClickEventArgs e) { if (Page.IsValid == true) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "Group_Comment"; cmd.Parameters.Add("@GroupId", SqlDbType.Int).Value = Int32.Parse(this.lit_groupId.Text); cmd.Parameters.Add("@UserId", SqlDbType.Int).Value = Int32.Parse(Session["UserID"].ToString()); cmd.Parameters.Add("@CommentText", SqlDbType.VarChar, 420).Value = this.txt_comment.Text; cmd.Connection = con; try { con.Open(); cmd.ExecuteNonQuery(); this.txt_comment.Text = ""; Rep_Comments.DataBind(); ListView_PageItems.DataBind(); Masonry(); } //catch (SqlException ex) //{ // ErrorMessage.Text = ex.Message; //} finally { cmd.Dispose(); if (con != null) { con.Close(); } } } }
protected void btn_add_Click(object sender, EventArgs e) { if (Page.IsValid == true) { string sItemUrl = txt_itemUrl.Text.Trim(); string sTitle = txt_itemTitle.Text.Trim(); string sDescription = txt_itemDescription.Text.Trim(); int GroupId = Int32.Parse(lit_groupId.Text.Trim()); int UserId = Int32.Parse(Session["UserID"].ToString()); SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "Item_Create"; cmd.Parameters.Add("@UserId", SqlDbType.Int).Value = UserId; cmd.Parameters.Add("@GroupId", SqlDbType.Int).Value = GroupId; cmd.Parameters.Add("@ItemUrl", SqlDbType.VarChar, 255).Value = sItemUrl; cmd.Parameters.Add("@ItemTypeId", SqlDbType.Int).Value = 1; cmd.Parameters.Add("@ItemName", SqlDbType.VarChar, 100).Value = sTitle; cmd.Parameters.Add("@ItemDescription", SqlDbType.VarChar, 255).Value = sDescription; cmd.Parameters.Add("@ItemPrivate", SqlDbType.Bit).Value = false; cmd.Parameters.Add("@ItemLayout", SqlDbType.Int).Value = 1; cmd.Connection = con; try { con.Open(); Int32 newItemId = Convert.ToInt32(cmd.ExecuteScalar()); if (this.rbn_grabSnapshot.Checked == true) { PS.OnlineImageOptimizer.ImageOptimizer op = new PS.OnlineImageOptimizer.ImageOptimizer(); op.ImgQuality = 100; op.MaxHeight = 640; op.MaxWidth = 640; Bitmap bmp = GetImage.GetWebSiteThumbnail(sItemUrl, 1024, 1024, 640, 640); bmp.Save(Server.MapPath("~/images/items/" + newItemId + ".jpg"), ImageFormat.Jpeg); op.Optimize(Server.MapPath("~/images/items/" + newItemId + ".jpg")); PS.OnlineImageOptimizer.ImageOptimizer tb = new PS.OnlineImageOptimizer.ImageOptimizer(); tb.ImgQuality = 100; tb.MaxHeight = 300; tb.MaxWidth = 170; Bitmap thb = GetImage.GetWebSiteThumbnail(sItemUrl, 1024, 1024, 200, 200); thb.Save(Server.MapPath("~/images/items/" + newItemId + "_s.jpg"), ImageFormat.Jpeg); tb.Optimize(Server.MapPath("~/images/items/" + newItemId + "_s.jpg")); } if (this.rbn_uploadImage.Checked == true) { if (upl_itemImage.HasFile) { Bitmap bmp = ResizeImage(upl_itemImage.PostedFile.InputStream, 600, 600); bmp.Save(Server.MapPath("~/images/items/" + newItemId + ".jpg"), ImageFormat.Jpeg); Bitmap thb = ResizeImage(upl_itemImage.PostedFile.InputStream, 170, 600); thb.Save(Server.MapPath("~/images/upload/items/" + newItemId + "_s.jpg"), ImageFormat.Jpeg); } } if (this.rbn_grabPicture.Checked == true) { var webClient = new WebClient(); using (var fileStream = webClient.OpenRead(this.txt_imageUrl.Text)) { Bitmap bmp = ResizeImage(fileStream, 640, 3000); bmp.Save(Server.MapPath("~/images/items/" + newItemId + ".jpg"), ImageFormat.Jpeg); } var webClientthb = new WebClient(); using (var fileStream = webClientthb.OpenRead(this.txt_imageUrl.Text)) { Bitmap thb = ResizeImage(fileStream, 170, 1000); thb.Save(Server.MapPath("~/images/items/" + newItemId + "_s.jpg"), ImageFormat.Jpeg); } } } //catch (SqlException ex) //{ // ErrorMessage.Text = ex.Message; //} finally { cmd.Dispose(); if (con != null) { con.Close(); } txt_itemUrl.Text = ""; txt_itemTitle.Text = ""; txt_itemDescription.Text = ""; //box_add.Visible = false; ListView_PageItems.DataBind(); Masonry(); } } }