protected void Button_Opret_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = @"INSERT INTO Users (user_email, user_name, user_password, user_picture) VALUES (@email, @name, @password, @picture)"; cmd.Parameters.AddWithValue("@email", TextBox_Email.Text); cmd.Parameters.AddWithValue("@name", TextBox_Name.Text); cmd.Parameters.AddWithValue("@password", TextBox_Password.Text); #region image1 string bill_sti = "intetbillede.jpg"; if (FileUpload_ProfilePicture.HasFile) { //NewGuid danner uniq navn for billeder bill_sti = Guid.NewGuid() + Path.GetExtension(FileUpload_ProfilePicture.FileName); // Opret String UploadeMappe = Server.MapPath("~/images/Original/"); String CroppedMappe = Server.MapPath("~/images/Resized/"); String Filnavn = DateTime.Now.ToFileTime() + FileUpload_ProfilePicture.FileName; bill_sti = Filnavn; //Gem det orginale Billede FileUpload_ProfilePicture.SaveAs(UploadeMappe + Filnavn); // Definer hvordan ImageResizer.ResizeSettings BilledeSkalering = new ImageResizer.ResizeSettings(); //Lav nogle nye skalerings instillinger BilledeSkalering = new ImageResizer.ResizeSettings(); BilledeSkalering.Width = 50; BilledeSkalering.Height = 50; BilledeSkalering.Mode = ImageResizer.FitMode.Crop; //Udfør selve skaleringen ImageResizer.ImageBuilder.Current.Build(UploadeMappe + Filnavn, CroppedMappe + Filnavn, BilledeSkalering); } // Tildel parameter-værdierne, fra input felterne. cmd.Parameters.AddWithValue("@picture", bill_sti); #endregion conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); Response.Redirect("Login.aspx"); }
public static void Run([BlobTrigger("image/{name}", Connection = "ImageStorageAccountConnection")] Stream imageBlob, string name, [Blob("thumbnail/{name}", FileAccess.Write)] Stream imagethumbnail, TraceWriter log) { log.Info($"C# Blob trigger function Processed blob\n Name:{name} \n Size: {imageBlob.Length} Bytes"); if (imageBlob.Length >= 4000000) { //for large image, create thumbnail using ImageResizer var imageResizersettings = new ImageResizer.ResizeSettings { MaxHeight = 320, MaxWidth = 320 }; ImageResizer.ImageBuilder.Current.Build(imageBlob, imagethumbnail, imageResizersettings); } else { // for small image, using cognative service to create thumbnail int width = 320; int height = 320; bool smartCropping = true; using (var httpClient = new HttpClient()) { httpClient.BaseAddress = new Uri(_apiUrlBase); httpClient.DefaultRequestHeaders.Add("Ocp-Apim-Subscription-Key", _apiKey); using (HttpContent content = new StreamContent(imageBlob)) { //get response content.Headers.ContentType = new MediaTypeWithQualityHeaderValue("application/octet-stream"); var uri = $"{_apiUrlBase}?width={width}&height={height}&smartCropping={smartCropping.ToString()}"; var response = httpClient.PostAsync(uri, content).Result; var responseBytes = response.Content.ReadAsByteArrayAsync().Result; //write to output thumb imagethumbnail.Write(responseBytes, 0, responseBytes.Length); } } } }
public ImageJob(string sourcePath, string destPath, ResizeSettings settings) : this((object)sourcePath, (object)destPath, new Instructions(settings)) { }
/// <summary> /// Generates the resized image to disk (if needed), then rewrites the request to that location. /// Perform 404 checking before calling this method. Assumes file exists. /// Called during PostAuthorizeRequest /// </summary> /// <param name="context"></param> /// <param name="ra"></param> /// <param name="vf"></param> protected virtual void HandleRequest(HttpContext context, HttpModuleRequestAssistant ra, IVirtualFile vf) { if (!ra.CachingIndicated && !ra.ProcessingIndicated) { ra.ApplyRewrittenPath(); //This is needed for both physical and virtual files; only makes changes if needed. if (vf != null) { ra.AssignSFH(); //Virtual files are not served in .NET 4. } return; } context.Items[conf.ResponseArgsKey] = ""; //We are handling the request //Communicate to the MVC plugin this request should not be affected by the UrlRoutingModule. context.Items[conf.StopRoutingKey] = true; ra.EstimateResponseInfo(); //Build CacheEventArgs ResponseArgs e = new ResponseArgs(); //Add the modified date to the request key, if present. var modDate = (vf == null) ? System.IO.File.GetLastWriteTimeUtc(ra.RewrittenMappedPath) : (vf is IVirtualFileWithModifiedDate ? ((IVirtualFileWithModifiedDate)vf).ModifiedDateUTC : DateTime.MinValue); e.RequestKey = ra.GenerateRequestCachingKey(modDate); var settings = new ResizeSettings(ra.RewrittenInstructions); e.RewrittenQuerystring = settings; e.ResponseHeaders.ContentType = ra.EstimatedContentType; e.SuggestedExtension = ra.EstimatedFileExtension; //A delegate for accessing the source file e.GetSourceImage = new GetSourceImageDelegate(delegate() { return((vf != null) ? vf.Open() : File.Open(ra.RewrittenMappedPath, FileMode.Open, FileAccess.Read, FileShare.Read)); }); //Add delegate for writing the data stream e.ResizeImageToStream = new ResizeImageDelegate(delegate(System.IO.Stream stream) { //This runs on a cache miss or cache invalid. This delegate is preventing from running in more //than one thread at a time for the specified cache key try { if (!ra.ProcessingIndicated) { //Just duplicate the data using (Stream source = e.GetSourceImage()) source.CopyToStream(stream); //4KiB buffer } else { ImageJob j; //Process the image if (vf != null) { j = new ImageJob(vf, stream, settings); } else { j = new ImageJob(ra.RewrittenMappedPath, stream, settings); //Use a physical path to bypass virtual file system } conf.GetImageBuilder().Build(j); } ra.FireJobSuccess(); //Catch not found exceptions } catch (System.IO.FileNotFoundException notFound) { if (notFound.Message.Contains(" assembly ")) { throw; //If an assembly is missing, it should be a 500, not a 404 } //This will be called later, if at all. ra.FireMissing(); throw new ImageMissingException("The specified resource could not be located", "File not found", notFound); } catch (System.IO.DirectoryNotFoundException notFound) { ra.FireMissing(); throw new ImageMissingException("The specified resource could not be located", "File not found", notFound); } catch (Exception ex) { ra.FireJobException(ex); throw; } }); context.Items[conf.ResponseArgsKey] = e; //store in context items //Fire events (for client-side caching plugins) conf.FirePreHandleImage(this, context, e); //Pass the rest of the work off to the caching module. It will handle rewriting/redirecting and everything. //We handle request headers based on what is found in context.Items ICache cache = conf.GetCacheProvider().GetCachingSystem(context, e); //Verify we have a caching system if (cache == null) { throw new ImageProcessingException("Image Resizer: No caching plugin was found for the request"); } cache.Process(context, e); //TODO: Verify that caching systems serves request or transfers to StaticFileHandler }
/// <summary> /// Generates the resized image to disk (if needed), then rewrites the request to that location. /// Perform 404 checking before calling this method. Assumes file exists. /// Called during PostAuthorizeRequest /// </summary> /// <param name="context"></param> /// <param name="virtualPath"></param> /// <param name="queryString"></param> /// <param name="vf"></param> protected virtual void HandleRequest(HttpContext context, string virtualPath, NameValueCollection queryString, IVirtualFile vf) { Stopwatch s = new Stopwatch(); s.Start(); ResizeSettings settings = new ResizeSettings(queryString); bool isCaching = settings.Cache == ServerCacheMode.Always; bool isProcessing = settings.Process == ProcessWhen.Always; //By default, we process it if is both (a) a recognized image extension, and (b) has a resizing directive (not just 'cache'). if (settings.Process == ProcessWhen.Default) { //Check for resize directive by removing ('non-resizing' items from the current querystring) NameValueCollection copy = new NameValueCollection(queryString); copy.Remove("cache"); copy.Remove("process"); copy.Remove("useresizingpipeline"); copy.Remove("404"); copy.Remove("404.filterMode"); copy.Remove("404.except"); //If the 'copy' still has directives, and it's an image request, then let's process it. isProcessing = conf.IsAcceptedImageType(virtualPath) && conf.HasPipelineDirective(copy); } //By default, we only cache it if we're processing it. if (settings.Cache == ServerCacheMode.Default && isProcessing) { isCaching = true; } //Resolve the 'cache' setting to 'no' unless we want it cache. if (!isCaching) { settings.Cache = ServerCacheMode.No; } //If we are neither processing nor caching, don't do anything more with the request if (!isProcessing && !isCaching) { return; } context.Items[conf.ResponseArgsKey] = ""; //We are handling the requests //Communicate to the MVC plugin this request should not be affected by the UrlRoutingModule. context.Items[conf.StopRoutingKey] = true; //Find out if we have a modified date that we can work with bool hasModifiedDate = (vf == null) || vf is IVirtualFileWithModifiedDate; DateTime modDate = DateTime.MinValue; if (hasModifiedDate && vf != null) { modDate = ((IVirtualFileWithModifiedDate)vf).ModifiedDateUTC; if (modDate == DateTime.MinValue || modDate == DateTime.MaxValue) { hasModifiedDate = false; //Skip modified date checking if the file has no modified date } } IEncoder guessedEncoder = null; //Only use an encoder to determine extension/mime-type when it's an image extension or when we've set process = always. if (isProcessing) { guessedEncoder = conf.GetImageBuilder().EncoderProvider.GetEncoder(settings, virtualPath); if (guessedEncoder == null) { throw new ImageProcessingException("Image Resizer: No image encoder was found for the request."); } } //Determine the file extenson for the caching system to use if we aren't processing the image //Use the exsiting one if is an image extension. If not, use "unknown". // We don't want to suggest writing .exe or .aspx files to the cache! string fallbackExtension = PathUtils.GetFullExtension(virtualPath).TrimStart('.'); if (!conf.IsAcceptedImageType(virtualPath)) { fallbackExtension = "unknown"; } //Determine the mime-type if we aren't processing the image. string fallbackContentType = "application/octet-stream"; //Support jpeg, png, gif, bmp, tiff mime-types. Otherwise use "application/octet-stream". //We can't set it to null - it will default to text/html System.Drawing.Imaging.ImageFormat recognizedExtension = DefaultEncoder.GetImageFormatFromExtension(fallbackExtension); if (recognizedExtension != null) { fallbackContentType = DefaultEncoder.GetContentTypeFromImageFormat(recognizedExtension); } //Build CacheEventArgs ResponseArgs e = new ResponseArgs(); e.RequestKey = virtualPath + PathUtils.BuildQueryString(queryString); e.RewrittenQuerystring = settings; e.ResponseHeaders.ContentType = isProcessing ? guessedEncoder.MimeType : fallbackContentType; e.SuggestedExtension = isProcessing ? guessedEncoder.Extension : fallbackExtension; e.HasModifiedDate = hasModifiedDate; //Add delegate for retrieving the modified date of the source file. e.GetModifiedDateUTC = new ModifiedDateDelegate(delegate() { if (vf == null) { return(System.IO.File.GetLastWriteTimeUtc(HostingEnvironment.MapPath(virtualPath))); } else if (hasModifiedDate) { return(modDate); } else { return(DateTime.MinValue); //Won't be called, no modified date available. } }); //A delegate for accessing the source file e.GetSourceImage = new GetSourceImageDelegate(delegate() { return((vf != null) ? vf.Open() : File.Open(HostingEnvironment.MapPath(virtualPath), FileMode.Open, FileAccess.Read, FileShare.Read)); }); //Add delegate for writing the data stream e.ResizeImageToStream = new ResizeImageDelegate(delegate(System.IO.Stream stream) { //This runs on a cache miss or cache invalid. This delegate is preventing from running in more //than one thread at a time for the specified cache key try { if (!isProcessing) { //Just duplicate the data using (Stream source = e.GetSourceImage()) StreamExtensions.CopyToStream(source, stream); //4KiB buffer } else { //Process the image if (vf != null) { conf.GetImageBuilder().Build(vf, stream, settings); } else { conf.GetImageBuilder().Build(HostingEnvironment.MapPath(virtualPath), stream, settings); //Use a physical path to bypass virtual file system } } //Catch not found exceptions } catch (System.IO.FileNotFoundException notFound) { //This will be called later, if at all. FileMissing(context, virtualPath, queryString); throw new ImageMissingException("The specified resource could not be located", "File not found", notFound); } catch (System.IO.DirectoryNotFoundException notFound) { FileMissing(context, virtualPath, queryString); throw new ImageMissingException("The specified resource could not be located", "File not found", notFound); } }); context.Items[conf.ResponseArgsKey] = e; //store in context items //Fire events (for client-side caching plugins) conf.FirePreHandleImage(this, context, e); //Pass the rest of the work off to the caching module. It will handle rewriting/redirecting and everything. //We handle request headers based on what is found in context.Items ICache cache = conf.GetCacheProvider().GetCachingSystem(context, e); //Verify we have a caching system if (cache == null) { throw new ImageProcessingException("Image Resizer: No caching plugin was found for the request"); } cache.Process(context, e); s.Stop(); context.Items["ResizingTime"] = s.ElapsedMilliseconds; }
protected void btn_opret_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = @"INSERT INTO users (userName, userDescription, userImg, userEmail, userPassword) VALUES (@name, @descri, @img, @email, @pass)"; cmd.Parameters.AddWithValue("@name", tb_OPname.Text); cmd.Parameters.AddWithValue("@descri", tb_OPbeskri.Text); cmd.Parameters.AddWithValue("@email", tb_OPemail.Text); cmd.Parameters.AddWithValue("@pass", tb_OPpass.Text); string img_path = "intetbillede.jpg"; //Hvis der er en fil i FilUploaden if (fu_billede.HasFile) { //NewGuid danner uniq navn for billeder img_path = Guid.NewGuid() + Path.GetExtension(fu_billede.FileName); // Opret String UploadeMappe = Server.MapPath("~/Images/Users/"); //string Kategori = dd_type.SelectedItem.Text; String Lille = "Scaled"; //String Stor = "Large"; String Filnavn = DateTime.Now.ToFileTime() + fu_billede.FileName; img_path = Filnavn; //Gem det orginale Billede fu_billede.SaveAs(UploadeMappe + Filnavn); // Definer hvordan ImageResizer.ResizeSettings BilledeSkalering = new ImageResizer.ResizeSettings(); BilledeSkalering.Width = 200; //Udfør skalleringen ImageResizer.ImageBuilder.Current.Build(UploadeMappe + Filnavn, UploadeMappe + "/" + Lille + "/" + Filnavn, BilledeSkalering); //Lav nogle nye skalerings instillinger BilledeSkalering = new ImageResizer.ResizeSettings(); BilledeSkalering.Width = 65; //Udfør selve skaleringen //ImageResizer.ImageBuilder.Current.Build(UploadeMappe + Filnavn, CroppedMappe + Filnavn, BilledeSkalering); } // Tildel parameter-værdierne, fra input felterne. cmd.Parameters.AddWithValue("@img", img_path); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); Response.Redirect("Login.aspx"); }
protected void Button_Opret_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(); conn.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = @"INSERT INTO Albums (Album_name, Album_price, Album_artist, Album_img, fk_genre_id, Album_postdate) VALUES (@name, @price, @artist, @img, @Genre_id, GETDATE());"; cmd.Parameters.AddWithValue("@name", TextBox_Name.Text); cmd.Parameters.AddWithValue("@price", TextBox_Price.Text); cmd.Parameters.AddWithValue("@Artist", TextBox_Artist.Text); cmd.Parameters.AddWithValue("@Genre_id", DropDownList_Genres.SelectedValue); //database sti til billede string bill_sti = "intetbillede.jpg"; //Hvis der er en fil i FilUploaden #region image1 if (FileUpload_Img1.HasFile) { //NewGuid danner uniq navn for billeder bill_sti = Guid.NewGuid() + Path.GetExtension(FileUpload_Img1.FileName); // Opret String UploadeMappe = Server.MapPath("~/Images/Original/"); String CroppedMappe1 = Server.MapPath("~/Images/200x200/"); String CroppedMappe2 = Server.MapPath("~/Images/50x50/"); String Filnavn = DateTime.Now.ToFileTime() + FileUpload_Img1.FileName; bill_sti = Filnavn; //Gem det orginale Billede FileUpload_Img1.SaveAs(UploadeMappe + Filnavn); // Definer hvordan ImageResizer.ResizeSettings BilledeSkalering = new ImageResizer.ResizeSettings(); //Lav nogle nye skalerings instillinger BilledeSkalering = new ImageResizer.ResizeSettings(); BilledeSkalering.Width = 200; BilledeSkalering.Height = 200; BilledeSkalering.Mode = ImageResizer.FitMode.Crop; //Udfør selve skaleringen ImageResizer.ImageBuilder.Current.Build(UploadeMappe + Filnavn, CroppedMappe1 + Filnavn, BilledeSkalering); //Lav nogle nye skalerings instillinger BilledeSkalering = new ImageResizer.ResizeSettings(); BilledeSkalering.Width = 50; BilledeSkalering.Height = 50; BilledeSkalering.Mode = ImageResizer.FitMode.Crop; //Udfør selve skaleringen ImageResizer.ImageBuilder.Current.Build(UploadeMappe + Filnavn, CroppedMappe2 + Filnavn, BilledeSkalering); } // Tildel parameter-værdierne, fra input felterne. cmd.Parameters.AddWithValue("@img", bill_sti); #endregion conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); Response.Redirect("AdminAlbums.aspx"); }
public ImageJob(object source, object dest, ResizeSettings settings, bool disposeSource, bool addFileExtension) : this(source, dest, new Instructions(settings), disposeSource, addFileExtension) { }
protected void Button_Gem_Ret_Click(object sender, EventArgs e) { string pris = TextBox_Price.Text; SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = @"UPDATE products SET product_name = @name, FK_category_id = @fk_category, product_price = @price, product_storage = @storage, product_min_storage = @min_storage, product_max_storage = @max_storage, product_recomended_dirt = @dirt, product_growthtime = @growthtime, product_image_1 = @image1, product_image_2 = @image2, product_image_3 = @image3, product_description = @description, product_number = @number WHERE product_id = @product_id"; cmd.Parameters.AddWithValue("@product_id", ViewState["product_id"]); cmd.Parameters.AddWithValue("@name", TextBox_Name.Text); cmd.Parameters.AddWithValue("@number", TextBox_Productnumber.Text); cmd.Parameters.AddWithValue("@price", Convert.ToDecimal(pris)); cmd.Parameters.AddWithValue("@storage", TextBox_Storage.Text); cmd.Parameters.AddWithValue("@min_storage", TextBox_Min_Storage.Text); cmd.Parameters.AddWithValue("@max_storage", TextBox_Max_Storage.Text); cmd.Parameters.AddWithValue("@dirt", TextBox_Dirt.Text); cmd.Parameters.AddWithValue("@growthtime", TextBox_Time.Text); cmd.Parameters.AddWithValue("@description", TextBox_Description.Text); cmd.Parameters.AddWithValue("@fk_category", DropDownList_Categorys.SelectedValue); #region Image 1 string product_image1 = HiddenField_oldImage1.Value; if (FileUpload_Img1.HasFile) { //NewGuid danner uniq navn for billeder product_image1 = Guid.NewGuid() + Path.GetExtension(FileUpload_Img1.FileName); // Opret String UploadeMappe = Server.MapPath("~/images/resizer/Original_Images/"); String CroppedMappe = Server.MapPath("~/images/resizer/Croppede/"); String Filnavn = DateTime.Now.ToFileTime() + FileUpload_Img1.FileName; product_image1 = Filnavn; //Gem det orginale Billede FileUpload_Img1.SaveAs(UploadeMappe + Filnavn); // Definer hvordan ImageResizer.ResizeSettings BilledeSkalering = new ImageResizer.ResizeSettings(); //Lav nogle nye skalerings instillinger BilledeSkalering = new ImageResizer.ResizeSettings(); BilledeSkalering.Width = 120; BilledeSkalering.Height = 90; //Udfør selve skaleringen ImageResizer.ImageBuilder.Current.Build(UploadeMappe + Filnavn, CroppedMappe + Filnavn, BilledeSkalering); string old_img = HiddenField_oldImage1.Value; if (File.Exists(Server.MapPath("~/images/resizer/Croppede/") + old_img)) { File.Delete(Server.MapPath("~/images/resizer/Croppede/") + old_img); } if (File.Exists(Server.MapPath("~/images/resizer/Original_Images/") + old_img)) { File.Delete(Server.MapPath("~/images/resizer/Original_Images/") + old_img); } } cmd.Parameters.AddWithValue("@image1", product_image1); #endregion #region image 2 string product_image2 = HiddenField_oldImage2.Value; if (FileUpload_Img2.HasFile) { //NewGuid danner uniq navn for billeder product_image2 = Guid.NewGuid() + Path.GetExtension(FileUpload_Img2.FileName); // Opret String UploadeMappe = Server.MapPath("~/images/resizer/Original_Images/"); String CroppedMappe = Server.MapPath("~/images/resizer/Croppede/"); String Filnavn = DateTime.Now.ToFileTime() + FileUpload_Img2.FileName; product_image2 = Filnavn; //Gem det orginale Billede FileUpload_Img2.SaveAs(UploadeMappe + Filnavn); // Definer hvordan ImageResizer.ResizeSettings BilledeSkalering = new ImageResizer.ResizeSettings(); //Lav nogle nye skalerings instillinger BilledeSkalering = new ImageResizer.ResizeSettings(); BilledeSkalering.Width = 120; BilledeSkalering.Height = 90; //Udfør selve skaleringen ImageResizer.ImageBuilder.Current.Build(UploadeMappe + Filnavn, CroppedMappe + Filnavn, BilledeSkalering); string old_img = HiddenField_oldImage2.Value; if (File.Exists(Server.MapPath("~/images/resizer/Croppede/") + old_img)) { File.Delete(Server.MapPath("~/images/resizer/Croppede/") + old_img); } if (File.Exists(Server.MapPath("~/images/resizer/Original_Images/") + old_img)) { File.Delete(Server.MapPath("~/images/resizer/Original_Images/") + old_img); } } cmd.Parameters.AddWithValue("@image2", product_image2); #endregion #region Image 3 string product_image3 = HiddenField_oldImage3.Value; if (FileUpload_Img3.HasFile) { //NewGuid danner uniq navn for billeder product_image3 = Guid.NewGuid() + Path.GetExtension(FileUpload_Img3.FileName); // Opret String UploadeMappe = Server.MapPath("~/images/resizer/Original_Images/"); String CroppedMappe = Server.MapPath("~/images/resizer/Croppede/"); String Filnavn = DateTime.Now.ToFileTime() + FileUpload_Img3.FileName; product_image3 = Filnavn; //Gem det orginale Billede FileUpload_Img3.SaveAs(UploadeMappe + Filnavn); // Definer hvordan ImageResizer.ResizeSettings BilledeSkalering = new ImageResizer.ResizeSettings(); //Lav nogle nye skalerings instillinger BilledeSkalering = new ImageResizer.ResizeSettings(); BilledeSkalering.Width = 120; BilledeSkalering.Height = 90; //Udfør selve skaleringen ImageResizer.ImageBuilder.Current.Build(UploadeMappe + Filnavn, CroppedMappe + Filnavn, BilledeSkalering); string old_img = HiddenField_oldImage3.Value; if (File.Exists(Server.MapPath("~/images/resizer/Croppede/") + old_img)) { File.Delete(Server.MapPath("~/images/resizer/Croppede/") + old_img); } if (File.Exists(Server.MapPath("~/images/resizer/Original_Images/") + old_img)) { File.Delete(Server.MapPath("~/images/resizer/Original_Images/") + old_img); } } cmd.Parameters.AddWithValue("@image3", product_image3); #endregion conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); Response.Redirect("Produkter.aspx"); }
public static Size CalculateNewSize(Image source, ResizeSettings settings) { Size newSize = new Size(); int originalWidth = source.Width; int originalHeight = source.Height; float resizedImageScaleFactor = 0; int bigSide = 0, smallSide = 0; switch (settings.ResizeMode) { case ResizeMode.MaxSides: settings.CompareSides(ref smallSide, ref bigSide); if (settings.StretchMode == StretchMode.Proportionally) { resizedImageScaleFactor = GetScaleFactor(originalHeight, originalWidth, smallSide, bigSide); ApplyResizeRule(originalHeight, originalWidth, resizedImageScaleFactor, settings.ScaleMode, ref newSize); } else { if (originalHeight > originalWidth) { newSize.Height = bigSide; newSize.Width = smallSide; } else { newSize.Height = smallSide; newSize.Width = bigSide; } } break; case ResizeMode.OneSide: if (settings.Height > 0 && settings.Width > 0) { throw new Exception($"width: {settings.Width}, height: {settings.Height}. Только одна из сторон должна быть больше ноля"); } if (settings.Height > 0) { resizedImageScaleFactor = settings.Height / Convert.ToSingle(originalHeight); } else if (settings.Width > 0) { resizedImageScaleFactor = settings.Width / Convert.ToSingle(originalWidth); } else { throw new Exception($"width: { settings.Width }, height: { settings.Height}. Одна из сторон должна быть больше ноля"); } newSize.Width = Convert.ToInt32(originalWidth * resizedImageScaleFactor); newSize.Height = Convert.ToInt32(originalHeight * resizedImageScaleFactor); break; case ResizeMode.Rectangle: if (settings.StretchMode == StretchMode.Proportionally) { if (originalHeight > originalWidth) { bigSide = settings.Height; smallSide = settings.Width; } else { bigSide = settings.Width; smallSide = settings.Height; } resizedImageScaleFactor = GetScaleFactor(originalHeight, originalWidth, smallSide, bigSide); ApplyResizeRule(originalHeight, originalWidth, resizedImageScaleFactor, settings.ScaleMode, ref newSize); } else { newSize.Height = settings.Height; newSize.Width = settings.Width; } break; default: break; } return(newSize); }
private void gem() { if (tb_name.Text == "" || tb_email.Text == "" || tb_beskri.Text == "") { lbl_fejl2.Text = "Du skal udfylde alle felterne!"; } else { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; string img_path = hf_billede.Value; if (fu_billede.HasFile) { //NewGuid danner uniq navn for billeder img_path = Guid.NewGuid() + Path.GetExtension(fu_billede.FileName); // Opret String UploadeMappe = Server.MapPath("~/Images/Users/"); //string Kategori = dd_type.SelectedItem.Text; String Lille = "Scaled"; //String Stor = "Large"; String Filnavn = DateTime.Now.ToFileTime() + fu_billede.FileName; img_path = Filnavn; //Gem det orginale Billede fu_billede.SaveAs(UploadeMappe + Filnavn); // Definer hvordan ImageResizer.ResizeSettings BilledeSkalering = new ImageResizer.ResizeSettings(); BilledeSkalering.Width = 200; //Udfør skalleringen ImageResizer.ImageBuilder.Current.Build(UploadeMappe + Filnavn, UploadeMappe + "/" + Lille + "/" + Filnavn, BilledeSkalering); //Lav nogle nye skalerings instillinger BilledeSkalering = new ImageResizer.ResizeSettings(); BilledeSkalering.Width = 65; // Tildel parameter-værdierne, fra input felterne. //cmd.Parameters.AddWithValue("@b_sti", user_img); //int x = Convert.ToInt32("@p_id"); //cmd.Parameters.Add("@pk_film_id", SqlDbType.Int).Value = x; string old_img = hf_billede.Value; if (File.Exists(Server.MapPath("~/Images/Users/") + old_img)) { File.Delete(Server.MapPath("~/Images/Users/") + old_img); } if (File.Exists(Server.MapPath("~/Images/Users/Scaled/") + old_img)) { File.Delete(Server.MapPath("~/Images/Users/Scaled/") + old_img); } //if (File.Exists(Server.MapPath("~/billeder/plakater/large/") + old_img)) //{ // File.Delete(Server.MapPath("~//billeder/plakater/large/") + old_img); //} } else { lbl_fejl.Text = "Du skal vælge et billede!"; } cmd.CommandText = @" UPDATE users SET userName = @name, userDescription = @descri, userImg = @img, userEmail = @email WHERE userId = @userId"; cmd.Parameters.AddWithValue("@userid", Session["userId"]); cmd.Parameters.AddWithValue("@name", tb_name.Text); cmd.Parameters.AddWithValue("@descri", tb_beskri.Text); cmd.Parameters.AddWithValue("@email", tb_email.Text); cmd.Parameters.AddWithValue("@img", img_path); if (tb_pass.Text != "") { cmd.CommandText = @"UPDATE users SET userName = @name, userDescription = @descri, userImg = @img, userEmail = @email, userPassword = @password WHERE userId = @userId"; cmd.Parameters.AddWithValue("@password", tb_pass.Text); } conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); Response.Redirect(Request.RawUrl); } }
private void gem() { if (tb_artist.Text == "" || tb_date.Text == "" || tb_title.Text == "" || dd_genre.SelectedValue == "" || dd_price.SelectedValue == "") { lbl_fejl.Text = "Du skal udfylde alle felterne!"; } else { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand(@"UPDATE albums SET albumTitle = @title, albumCover = @cover, albumArtist = @artist, albumDate = @date, fk_priceId = @price, fk_genreId = @genre WHERE albumId = @albumId", conn); cmd.Parameters.AddWithValue("@albumId", ViewState["albumId"]); cmd.Parameters.AddWithValue("@title", tb_title.Text); cmd.Parameters.AddWithValue("@artist", tb_artist.Text); cmd.Parameters.AddWithValue("@date", tb_date.Text); cmd.Parameters.AddWithValue("@price", dd_price.SelectedValue); cmd.Parameters.AddWithValue("@genre", dd_genre.SelectedValue); string img_path = hf_billede.Value; if (fu_billede.HasFile) { //NewGuid danner uniq navn for billeder img_path = Guid.NewGuid() + Path.GetExtension(fu_billede.FileName); // Opret String UploadeMappe = Server.MapPath("~/Images/Albums/"); //string Kategori = dd_type.SelectedItem.Text; String Lille = "Small"; String Stor = "Large"; String Filnavn = DateTime.Now.ToFileTime() + fu_billede.FileName; img_path = Filnavn; //Gem det orginale Billede fu_billede.SaveAs(UploadeMappe + Filnavn); // Definer hvordan ImageResizer.ResizeSettings BilledeSkalering = new ImageResizer.ResizeSettings(); BilledeSkalering.Width = 50; BilledeSkalering.Height = 50; //Udfør skalleringen ImageResizer.ImageBuilder.Current.Build(UploadeMappe + Filnavn, UploadeMappe + "/" + Lille + "/" + Filnavn, BilledeSkalering); //Lav nogle nye skalerings instillinger BilledeSkalering = new ImageResizer.ResizeSettings(); BilledeSkalering.Width = 200; BilledeSkalering.Height = 200; //Udfør selve skaleringen ImageResizer.ImageBuilder.Current.Build(UploadeMappe + Filnavn, UploadeMappe + "/" + Stor + "/" + Filnavn, BilledeSkalering); // Tildel parameter-værdierne, fra input felterne. //cmd.Parameters.AddWithValue("@b_sti", user_img); //int x = Convert.ToInt32("@p_id"); //cmd.Parameters.Add("@pk_film_id", SqlDbType.Int).Value = x; string old_img = hf_billede.Value; if (File.Exists(Server.MapPath("../Images/Albums/") + old_img)) { File.Delete(Server.MapPath("../Images/Albums/") + old_img); } if (File.Exists(Server.MapPath("../Images/Albums/Small/") + old_img)) { File.Delete(Server.MapPath("../Images/Albums/Small/") + old_img); } if (File.Exists(Server.MapPath("../Images/Albums/Large/") + old_img)) { File.Delete(Server.MapPath("../Images/Albums/Large/") + old_img); } //if (File.Exists(Server.MapPath("~/billeder/plakater/large/") + old_img)) //{ // File.Delete(Server.MapPath("~//billeder/plakater/large/") + old_img); //} } else { lbl_fejl.Text = "Du skal vælge et billede!"; } cmd.Parameters.AddWithValue("@cover", img_path); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); Response.Redirect(Request.RawUrl); } }
private void opret() { if (tb_artist.Text == "" || tb_date.Text == "" || tb_title.Text == "" || dd_genre.SelectedValue == "" || dd_price.SelectedValue == "") { lbl_fejl.Text = "Du skal udfylde alle felterne!"; } else { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = @"INSERT INTO albums (albumTitle, albumCover, albumArtist, albumDate, fk_priceId, fk_genreId) VALUES (@title, @cover, @artist, @date, @price, @genre)"; cmd.Parameters.AddWithValue("@title", tb_title.Text); cmd.Parameters.AddWithValue("@artist", tb_artist.Text); cmd.Parameters.AddWithValue("@date", tb_date.Text); cmd.Parameters.AddWithValue("@price", dd_price.SelectedValue); cmd.Parameters.AddWithValue("@genre", dd_genre.SelectedValue); string img_path = "intetbillede.jpg"; //Hvis der er en fil i FilUploaden if (fu_billede.HasFile) { //NewGuid danner uniq navn for billeder img_path = Guid.NewGuid() + Path.GetExtension(fu_billede.FileName); // Opret String UploadeMappe = Server.MapPath("~/Images/Albums/"); //string Kategori = dd_type.SelectedItem.Text; String Lille = "Small"; String Stor = "Large"; String Filnavn = DateTime.Now.ToFileTime() + fu_billede.FileName; img_path = Filnavn; //Gem det orginale Billede fu_billede.SaveAs(UploadeMappe + Filnavn); // Definer hvordan ImageResizer.ResizeSettings BilledeSkalering = new ImageResizer.ResizeSettings(); BilledeSkalering.Width = 50; BilledeSkalering.Height = 50; //Udfør skalleringen ImageResizer.ImageBuilder.Current.Build(UploadeMappe + Filnavn, UploadeMappe + "/" + Lille + "/" + Filnavn, BilledeSkalering); //Lav nogle nye skalerings instillinger BilledeSkalering = new ImageResizer.ResizeSettings(); BilledeSkalering.Width = 200; BilledeSkalering.Height = 200; //Udfør selve skaleringen ImageResizer.ImageBuilder.Current.Build(UploadeMappe + Filnavn, UploadeMappe + "/" + Stor + "/" + Filnavn, BilledeSkalering); } else { lbl_fejl.Text = "Du skal vælge et billede!"; } // Tildel parameter-værdierne, fra input felterne. cmd.Parameters.AddWithValue("@cover", img_path); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); Response.Redirect(Request.RawUrl); } }
public Bitmap ResizeImage(ResizeSettings settings) { destinationBitmap = Resizer.Resize(SourceBitmap, settings); return(this.DestinationBitmap); }
public ImageJob(Stream sourceStream, Stream destStream, ResizeSettings settings) : this((object)sourceStream, (object)destStream, new Instructions(settings)) { }
public ImageJob(object source, object dest, ResizeSettings settings) : this(source, dest, new Instructions(settings)) { }
protected void Button_Opret_Click(object sender, EventArgs e) { string pris = TextBox_Price.Text; SqlConnection conn = new SqlConnection(); conn.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = @"INSERT INTO products(product_name, FK_category_id, product_price, product_storage, product_min_storage, product_max_storage, product_recomended_dirt, product_growthtime, product_image_1, product_image_2, product_image_3, product_description, product_number) VALUES (@name, @fk_category, @price, @storage, @min_storage, @max_storage, @recomended_dirt, @growthtime, @image1, @image2, @image3, @description, @number);"; cmd.Parameters.AddWithValue("@name", TextBox_Name.Text); cmd.Parameters.AddWithValue("@price", Convert.ToDecimal(pris)); cmd.Parameters.AddWithValue("@storage", TextBox_Storage.Text); cmd.Parameters.AddWithValue("@min_storage", TextBox_Min_Storage.Text); cmd.Parameters.AddWithValue("@max_storage", TextBox_Max_Storage.Text); cmd.Parameters.AddWithValue("@recomended_dirt", TextBox_Dirt.Text); cmd.Parameters.AddWithValue("@growthtime", TextBox_Time.Text); cmd.Parameters.AddWithValue("@description", TextBox_Description.Text); cmd.Parameters.AddWithValue("@number", TextBox_Productnumber.Text); cmd.Parameters.AddWithValue("@fk_category", DropDownList_Categorys.SelectedValue); //database sti til billede string bill_sti = "intetbillede.jpg"; //Hvis der er en fil i FilUploaden #region image1 if (FileUpload_Img1.HasFile) { //NewGuid danner uniq navn for billeder bill_sti = Guid.NewGuid() + Path.GetExtension(FileUpload_Img1.FileName); // Opret String UploadeMappe = Server.MapPath("~/images/resizer/Original_Images/"); String CroppedMappe = Server.MapPath("~/images/resizer/Croppede/"); String Filnavn = DateTime.Now.ToFileTime() + FileUpload_Img1.FileName; bill_sti = Filnavn; //Gem det orginale Billede FileUpload_Img1.SaveAs(UploadeMappe + Filnavn); // Definer hvordan ImageResizer.ResizeSettings BilledeSkalering = new ImageResizer.ResizeSettings(); //Lav nogle nye skalerings instillinger BilledeSkalering = new ImageResizer.ResizeSettings(); BilledeSkalering.Width = 120; BilledeSkalering.Height = 90; BilledeSkalering.Mode = ImageResizer.FitMode.Crop; //Udfør selve skaleringen ImageResizer.ImageBuilder.Current.Build(UploadeMappe + Filnavn, CroppedMappe + Filnavn, BilledeSkalering); } // Tildel parameter-værdierne, fra input felterne. cmd.Parameters.AddWithValue("@image1", bill_sti); #endregion #region image2 if (FileUpload_Img2.HasFile) { //NewGuid danner uniq navn for billeder bill_sti = Guid.NewGuid() + Path.GetExtension(FileUpload_Img2.FileName); // Opret String UploadeMappe = Server.MapPath("~/images/resizer/Original_Images/"); String CroppedMappe = Server.MapPath("~/images/resizer/Croppede/"); String Filnavn = DateTime.Now.ToFileTime() + FileUpload_Img2.FileName; bill_sti = Filnavn; //Gem det orginale Billede FileUpload_Img2.SaveAs(UploadeMappe + Filnavn); // Definer hvordan ImageResizer.ResizeSettings BilledeSkalering = new ImageResizer.ResizeSettings(); //Lav nogle nye skalerings instillinger BilledeSkalering = new ImageResizer.ResizeSettings(); BilledeSkalering.Width = 90; BilledeSkalering.Height = 120; BilledeSkalering.Mode = ImageResizer.FitMode.Crop; //Udfør selve skaleringen ImageResizer.ImageBuilder.Current.Build(UploadeMappe + Filnavn, CroppedMappe + Filnavn, BilledeSkalering); } // Tildel parameter-værdierne, fra input felterne. cmd.Parameters.AddWithValue("@image2", bill_sti); #endregion #region image3 if (FileUpload_Img3.HasFile) { //NewGuid danner uniq navn for billeder bill_sti = Guid.NewGuid() + Path.GetExtension(FileUpload_Img3.FileName); // Opret String UploadeMappe = Server.MapPath("~/images/resizer/Original_Images/"); String CroppedMappe = Server.MapPath("~/images/resizer/Croppede/"); String Filnavn = DateTime.Now.ToFileTime() + FileUpload_Img3.FileName; bill_sti = Filnavn; //Gem det orginale Billede FileUpload_Img3.SaveAs(UploadeMappe + Filnavn); // Definer hvordan ImageResizer.ResizeSettings BilledeSkalering = new ImageResizer.ResizeSettings(); //Lav nogle nye skalerings instillinger BilledeSkalering = new ImageResizer.ResizeSettings(); BilledeSkalering.Width = 90; BilledeSkalering.Height = 120; BilledeSkalering.Mode = ImageResizer.FitMode.Crop; //Udfør selve skaleringen ImageResizer.ImageBuilder.Current.Build(UploadeMappe + Filnavn, CroppedMappe + Filnavn, BilledeSkalering); } // Tildel parameter-værdierne, fra input felterne. cmd.Parameters.AddWithValue("@image3", bill_sti); #endregion conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); Response.Redirect("Produkter.aspx"); }
/// <summary> /// Generates the resized image to disk (if needed), then rewrites the request to that location. /// Perform 404 checking before calling this method. Assumes file exists. /// Called during PostAuthorizeRequest /// </summary> /// <param name="context"></param> /// <param name="ra"></param> /// <param name="vf"></param> protected virtual async Task HandleRequest(HttpContext context, HttpModuleRequestAssistant ra, IVirtualFileAsync vf) { if (!ra.CachingIndicated && !ra.ProcessingIndicated) { ra.ApplyRewrittenPath(); //This is needed for both physical and virtual files; only makes changes if needed. if (vf != null) { ra.AssignSFH(); //Virtual files are not served in .NET 4. } return; } //Communicate to the MVC plugin this request should not be affected by the UrlRoutingModule. context.Items[conf.StopRoutingKey] = true; context.Items[conf.ResponseArgsKey] = ""; //We are handling the request ra.EstimateResponseInfo(); //Build CacheEventArgs var e = new AsyncResponsePlan(); var modDate = (vf == null) ? System.IO.File.GetLastWriteTimeUtc(ra.RewrittenMappedPath) : (vf is IVirtualFileWithModifiedDateAsync ? await((IVirtualFileWithModifiedDateAsync)vf).GetModifiedDateUTCAsync() : DateTime.MinValue); e.RequestCachingKey = ra.GenerateRequestCachingKey(modDate); var settings = new ResizeSettings(ra.RewrittenInstructions); e.RewrittenQuerystring = settings; e.EstimatedContentType = ra.EstimatedContentType; e.EstimatedFileExtension = ra.EstimatedFileExtension; //A delegate for accessing the source file e.OpenSourceStreamAsync = async delegate() { return((vf != null) ? await vf.OpenAsync() : File.Open(ra.RewrittenMappedPath, FileMode.Open, FileAccess.Read, FileShare.Read)); }; //Add delegate for writing the data stream e.CreateAndWriteResultAsync = async delegate(System.IO.Stream stream, IAsyncResponsePlan plan) { //This runs on a cache miss or cache invalid. This delegate is preventing from running in more //than one thread at a time for the specified cache key try { if (!ra.ProcessingIndicated) { //Just duplicate the data using (Stream source = await e.OpenSourceStreamAsync()) await source.CopyToAsync(stream); //4KiB buffer } else { MemoryStream inBuffer = null; using (var sourceStream = vf != null ? await vf.OpenAsync() : File.Open(ra.RewrittenMappedPath, FileMode.Open, FileAccess.Read, FileShare.Read)) { inBuffer = new MemoryStream(sourceStream.CanSeek ? (int)sourceStream.Length : 128 * 1024); await sourceStream.CopyToAsync(inBuffer); } inBuffer.Seek(0, SeekOrigin.Begin); var outBuffer = new MemoryStream(32 * 1024); //Handle I/O portions of work asynchronously. var j = new ImageJob { Instructions = new Instructions(settings), SourcePathData = vf != null ? vf.VirtualPath : ra.RewrittenVirtualPath, Dest = outBuffer, Source = inBuffer }; await conf.GetImageBuilder().BuildAsync(j, int.MaxValue, CancellationToken.None); outBuffer.Seek(0, SeekOrigin.Begin); await outBuffer.CopyToAsync(stream); } ra.FireJobSuccess(); //Catch not found exceptions } catch (System.IO.FileNotFoundException notFound) { if (notFound.Message.Contains(" assembly ")) { throw; //If an assembly is missing, it should be a 500, not a 404 } //This will be called later, if at all. ra.FireMissing(); throw new ImageMissingException("The specified resource could not be located", "File not found", notFound); } catch (System.IO.DirectoryNotFoundException notFound) { ra.FireMissing(); throw new ImageMissingException("The specified resource could not be located", "File not found", notFound); } catch (Exception ex) { ra.FireJobException(ex); throw; } }; //All bad from here down.... context.Items[conf.ResponseArgsKey] = e; //store in context items //Fire events (for client-side caching plugins) conf.FirePreHandleImageAsync(this, context, e); //Pass the rest of the work off to the caching module. It will handle rewriting/redirecting and everything. //We handle request headers based on what is found in context.Items IAsyncTyrantCache cache = conf.GetAsyncCacheFor(context, e); //Verify we have a caching system if (cache == null) { throw new ImageProcessingException("Image Resizer: No async caching plugin was found for the request"); } await cache.ProcessAsync(context, e); }
protected void Button_Gem_Ret_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = @"UPDATE Albums SET Album_name = @name, Album_price = @price, Album_artist = @artist, Album_img = @img, fk_genre_id = @genre_id WHERE Album_id = @Album_id"; cmd.Parameters.AddWithValue("@Album_id", ViewState["Album_id"]); cmd.Parameters.AddWithValue("@name", TextBox_Name.Text); cmd.Parameters.AddWithValue("@price", TextBox_Price.Text); cmd.Parameters.AddWithValue("@artist", TextBox_Artist.Text); cmd.Parameters.AddWithValue("@genre_id", DropDownList_Genres.SelectedValue); #region Image 1 string product_image1 = HiddenField_oldImage1.Value; if (FileUpload_Img1.HasFile) { //NewGuid danner uniq navn for billeder product_image1 = Guid.NewGuid() + Path.GetExtension(FileUpload_Img1.FileName); // Opret String UploadeMappe = Server.MapPath("~/Images/Original/"); String CroppedMappe1 = Server.MapPath("~/Images/200x200/"); String CroppedMappe2 = Server.MapPath("~/Images/50x50/"); String Filnavn = DateTime.Now.ToFileTime() + FileUpload_Img1.FileName; product_image1 = Filnavn; //Gem det orginale Billede FileUpload_Img1.SaveAs(UploadeMappe + Filnavn); // Definer hvordan ImageResizer.ResizeSettings BilledeSkalering = new ImageResizer.ResizeSettings(); //Lav nogle nye skalerings instillinger BilledeSkalering = new ImageResizer.ResizeSettings(); BilledeSkalering.Width = 200; BilledeSkalering.Height = 200; BilledeSkalering.Mode = ImageResizer.FitMode.Crop; //Udfør selve skaleringen ImageResizer.ImageBuilder.Current.Build(UploadeMappe + Filnavn, CroppedMappe1 + Filnavn, BilledeSkalering); //Lav nogle nye skalerings instillinger BilledeSkalering = new ImageResizer.ResizeSettings(); BilledeSkalering.Width = 50; BilledeSkalering.Height = 50; BilledeSkalering.Mode = ImageResizer.FitMode.Crop; //Udfør selve skaleringen ImageResizer.ImageBuilder.Current.Build(UploadeMappe + Filnavn, CroppedMappe2 + Filnavn, BilledeSkalering); string old_img = HiddenField_oldImage1.Value; if (File.Exists(Server.MapPath("~/Images/Original") + old_img)) { File.Delete(Server.MapPath("~/Images/Original") + old_img); } if (File.Exists(Server.MapPath("~/Images/200x200") + old_img)) { File.Delete(Server.MapPath("~/Images/200x200") + old_img); } if (File.Exists(Server.MapPath("~/Images/50x50/") + old_img)) { File.Delete(Server.MapPath("~/Images/50x50/") + old_img); } } cmd.Parameters.AddWithValue("@img", product_image1); #endregion conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); Response.Redirect("AdminAlbums.aspx"); }