protected void btn_uplinkimage_Click(object sender, EventArgs e)
{
if (IsValid)
{
PS.OnlineImageOptimizer.ImageOptimizer op = new PS.OnlineImageOptimizer.ImageOptimizer();
op.ImgQuality = 80;
op.MaxHeight = 150;
op.MaxWidth = 200;
Bitmap bmp = ResizeImage(upl_linkimage.PostedFile.InputStream, 200, 150);
bmp.Save(Server.MapPath("~/Images/Users/" + FetchUser.UserName() + "/temp.jpg"), ImageFormat.Jpeg);
op.Optimize(Server.MapPath("~/Images/Users/" + FetchUser.UserName() + "/temp.jpg"));
img_add_newlink.ImageUrl = "~/Images/Users/" + FetchUser.UserName() + "/temp.jpg";
}
}
// Fetch Screenshot
public void GetImage()
{
PS.OnlineImageOptimizer.ImageOptimizer op = new PS.OnlineImageOptimizer.ImageOptimizer();
op.ImgQuality = 80;
op.MaxHeight = 150;
op.MaxWidth = 150;
Bitmap bmp = FetchImage.GetWebSiteThumbnail(tb_LinkUrl.Text, 1024, 1024, 150, 150);
// Save Image as JPG
bmp.Save(Server.MapPath("~/Images/Users/" + FetchUser.UserName() + "/temp.jpg"), ImageFormat.Jpeg);
// Optimize Image
op.Optimize(Server.MapPath("~/Images/Users/" + FetchUser.UserName() + "/temp.jpg"));
// Set Image Control
img_add_newlink.ImageUrl = "~/Images/Users/" + FetchUser.UserName() + "/temp.jpg";
}
protected void Link_Datalist_Update(object source, DataListCommandEventArgs e)
{
TextBox tb_EditLinkTitle = (TextBox)e.Item.FindControl("tb_EditLinkTitle");
TextBox tb_EditLinkDescription = (TextBox)e.Item.FindControl("tb_EditLinkDescription");
CheckBox cb_editprivate = (CheckBox)e.Item.FindControl("cb_editprivate");
FileUpload upl_linkimage = (FileUpload)e.Item.FindControl("upl_linkimage");
string sLinkName = tb_EditLinkTitle.Text;
string sLinkDescription = tb_EditLinkDescription.Text;
string sLinkId = e.CommandArgument.ToString();
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString);
SqlCommand cmd = new SqlCommand("UPDATE tbl_LinksMaster SET [LinkName] = @LinkName, [LinkDescription] = @LinkDescription, [LinkPrivate] = @LinkPrivate WHERE [LinkId] = @LinkId", sqlConn);
cmd.Parameters.Add("@LinkName", SqlDbType.VarChar).Value = sLinkName;
cmd.Parameters.Add("@LinkDescription", SqlDbType.VarChar).Value = sLinkDescription;
cmd.Parameters.Add("@LinkId", SqlDbType.VarChar).Value = sLinkId;
cmd.Parameters.Add("@LinkPrivate", SqlDbType.Bit, 1).Value = cb_editprivate.Checked;
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
cmd.Connection.Dispose();
if (upl_linkimage.HasFile)
{
PS.OnlineImageOptimizer.ImageOptimizer op = new PS.OnlineImageOptimizer.ImageOptimizer();
op.ImgQuality = 80;
op.MaxHeight = 200;
op.MaxWidth = 200;
Bitmap bmp = ResizeImage(upl_linkimage.PostedFile.InputStream, 200, 200);
bmp.Save(Server.MapPath("~/Images/Users/" + FetchUser.UserName() + "/temp.jpg"), ImageFormat.Jpeg);
op.Optimize(Server.MapPath("~/Images/Users/" + FetchUser.UserName() + "/temp.jpg"));
//img_link_edit.ImageUrl = "~/Images/Users/" + FetchUser.UserName() + "/temp.jpg";
}
else
{
}
Link_Datalist.EditItemIndex = -1;
BindLinkList();
}
protected void btn_uplistimage_Click(object sender, EventArgs e)
{
if (IsValid)
{
FileUpload upl_listimage = (FileUpload)Head_Datalist.Items[Head_Datalist.EditItemIndex].FindControl("upl_listimage");
System.Web.UI.WebControls.Image ListImage_Placeholder = (System.Web.UI.WebControls.Image)Head_Datalist.Items[Head_Datalist.EditItemIndex].FindControl("ListImage_Placeholder");
if (upl_listimage.HasFile)
{
PS.OnlineImageOptimizer.ImageOptimizer op = new PS.OnlineImageOptimizer.ImageOptimizer();
op.ImgQuality = 80;
op.MaxHeight = 200;
op.MaxWidth = 200;
Bitmap bmp = ResizeImage(upl_listimage.PostedFile.InputStream, 200, 200);
bmp.Save(Server.MapPath("~/Images/Users/" + FetchUser.UserName() + "/temp.jpg"), ImageFormat.Jpeg);
op.Optimize(Server.MapPath("~/Images/Users/" + FetchUser.UserName() + "/temp.jpg"));
ListImage_Placeholder.ImageUrl = "~/Images/Users/" + FetchUser.UserName() + "/temp.jpg";
}
else
{
}
}
}
protected void Head_Datalist_Update(object source, DataListCommandEventArgs e)
{
DropDownList ddl_folderMove = (DropDownList)e.Item.FindControl("ddl_folderMove");
TextBox tb_EditListTitle = (TextBox)e.Item.FindControl("tb_EditListTitle");
TextBox tb_EditListDescription = (TextBox)e.Item.FindControl("tb_EditListDescription");
FileUpload upl_listimage = (FileUpload)e.Item.FindControl("upl_listimage");
System.Web.UI.WebControls.Image ListImage_Placeholder = (System.Web.UI.WebControls.Image)e.Item.FindControl("ListImage_Placeholder");
//CheckBox cb_editprivate = (CheckBox)e.Item.FindControl("cb_editprivate");
string sListName = tb_EditListTitle.Text;
string sListDescription = tb_EditListDescription.Text;
string sListId = grabListId();
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString);
// Check Dropdown for Selection
if (ddl_folderMove.SelectedIndex != 0)
{
// Delete and Create New Folder Association
SqlCommand mov = new SqlCommand("usp_list_move", sqlConn);
string sFolderId = ddl_folderMove.SelectedValue.ToString();
int FolderId = Int32.Parse(sFolderId);
int ListId = Int32.Parse(sListId);
mov.CommandType = CommandType.StoredProcedure;
mov.Parameters.Add("@FolderId", SqlDbType.Int).Value = FolderId;
mov.Parameters.Add("@ListId", SqlDbType.Int).Value = ListId;
mov.Connection.Open();
mov.ExecuteNonQuery();
mov.Connection.Close();
mov.Connection.Dispose();
SqlConnection sqlConn2 = new SqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString);
// Update List Name and Description
SqlCommand cmd = new SqlCommand("UPDATE tbl_ListsMaster SET [ListName] = @ListName, [ListDescription] = @ListDescription WHERE [ListId] = @ListId", sqlConn2);
cmd.Parameters.Add("@ListName", SqlDbType.VarChar).Value = sListName;
cmd.Parameters.Add("@ListDescription", SqlDbType.VarChar).Value = sListDescription;
cmd.Parameters.Add("@ListId", SqlDbType.VarChar).Value = sListId;
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
cmd.Connection.Dispose();
}
else
{
SqlCommand cmd = new SqlCommand("UPDATE tbl_ListsMaster SET [ListName] = @ListName, [ListDescription] = @ListDescription WHERE [ListId] = @ListId", sqlConn);
cmd.Parameters.Add("@ListName", SqlDbType.VarChar).Value = sListName;
cmd.Parameters.Add("@ListDescription", SqlDbType.VarChar).Value = sListDescription;
cmd.Parameters.Add("@ListId", SqlDbType.VarChar).Value = sListId;
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
cmd.Connection.Dispose();
}
if (upl_listimage.HasFile)
{
PS.OnlineImageOptimizer.ImageOptimizer op = new PS.OnlineImageOptimizer.ImageOptimizer();
op.ImgQuality = 80;
op.MaxHeight = 200;
op.MaxWidth = 200;
Bitmap bmp = ResizeImage(upl_listimage.PostedFile.InputStream, 200, 200);
bmp.Save(Server.MapPath("~/Images/Users/" + FetchUser.UserName() + "/temp.jpg"), ImageFormat.Jpeg);
op.Optimize(Server.MapPath("~/Images/Users/" + FetchUser.UserName() + "/temp.jpg"));
//img_list_edit.ImageUrl = "~/Images/Users/" + FetchUser.UserName() + "/temp.jpg";
}
else
{
}
Head_Datalist.EditItemIndex = -1;
BindLinkHead();
}
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();
}
}
}
