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();
}
}
}
