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