void UploadStyleImage(int tblStyle, string galaryLink, byte[] styleImage) { using (var context = new WorkFlowManagerDBEntities()) { var styleImageQuery = context.TblStyleImages.FirstOrDefault(x => x.TblStyle == tblStyle && x.DefaultImage == true); if (styleImageQuery == null) { try { //Resize Image To Get Thumbnail System.Drawing.Image img = byteArrayToImage(styleImage); //Resize Image To Get Thumbnail System.Drawing.Image newImage = new Bitmap(100, 100); using (Graphics g = Graphics.FromImage(newImage)) { g.InterpolationMode = InterpolationMode.HighQualityBicubic; g.DrawImage(img, 0, 0, 100, 100); } byte[] results; using (MemoryStream ms = new MemoryStream()) { ImageCodecInfo codec = ImageCodecInfo.GetImageEncoders().FirstOrDefault(c => c.FormatID == ImageFormat.Jpeg.Guid); EncoderParameters jpegParms = new EncoderParameters(1); jpegParms.Param[0] = new EncoderParameter(Encoder.Quality, 95L); newImage.Save(ms, codec, jpegParms); results = ms.ToArray(); } TblStyleImage tblStyleImage = new TblStyleImage(); tblStyleImage.TblStyle = tblStyle; tblStyleImage.IsPrintable = false; tblStyleImage.IsActive = true; tblStyleImage.ImagePath = @"Uploads/Imagessss/StylePicture/" + galaryLink; tblStyleImage.CreationDate = System.DateTime.Now; tblStyleImage.ImagePathThumbnail = results; tblStyleImage.DefaultImage = true; tblStyleImage.OrginalFileName = galaryLink; context.TblStyleImages.AddObject(tblStyleImage); int Saved = context.SaveChanges(); if (Saved > 0) { File.WriteAllBytes(@"D:\StylePicture\" + galaryLink, styleImage); } } catch { } } } }
private int DeleteTblStyleImage(TblStyleImage row) { using (var context = new WorkFlowManagerDBEntities()) { var oldRow = (from e in context.TblStyleImages where e.Iserial == row.Iserial select e).SingleOrDefault(); if (oldRow != null) { context.DeleteObject(oldRow); } context.SaveChanges(); } return(row.Iserial); }
public bool InsertStyleImageFromFolder(int tblStyle, string styleCode) { using (var context = new WorkFlowManagerDBEntities()) { var styleImageQuery = context.TblStyleImages.FirstOrDefault(x => x.TblStyle == tblStyle && x.DefaultImage == true); if (styleImageQuery == null) { try { // string imagePath = string.Format(@"D:\StylePicture\{0}.jpg", styleCode); // string imagePath = string.Format(@"\\192.168.1.14\Share\All\D and P\StylePicture\{0}.jpg", styleCode); string imgExtension = ""; string imagePath = GetImagePath(styleCode, out imgExtension); Image img = Image.FromFile(imagePath); //Resize Image To Get Thumbnail Image newImage = new Bitmap(100, 100); using (Graphics g = Graphics.FromImage(newImage)) { g.InterpolationMode = InterpolationMode.HighQualityBicubic; g.DrawImage(img, 0, 0, 100, 100); } byte[] results; using (MemoryStream ms = new MemoryStream()) { ImageCodecInfo codec = ImageCodecInfo.GetImageEncoders().FirstOrDefault(c => c.FormatID == ImageFormat.Jpeg.Guid); EncoderParameters jpegParms = new EncoderParameters(1); jpegParms.Param[0] = new EncoderParameter(Encoder.Quality, 95L); newImage.Save(ms, codec, jpegParms); results = ms.ToArray(); } if (results != null) { //Insert TblStyleImage tblStyleImage = new TblStyleImage(); tblStyleImage.TblStyle = tblStyle; tblStyleImage.IsPrintable = false; tblStyleImage.IsActive = true; tblStyleImage.ImagePath = @"Uploads/Imagessss/StylePicture/" + styleCode + imgExtension; tblStyleImage.CreationDate = System.DateTime.Now; tblStyleImage.ImagePathThumbnail = results; tblStyleImage.DefaultImage = true; tblStyleImage.OrginalFileName = styleCode + imgExtension; context.TblStyleImages.AddObject(tblStyleImage); int Saved = context.SaveChanges(); if (Saved > 0) { //Copy Image To Local Path // File.Copy(imagePath, @"D:\CCWFM\CCWFM.Web\Uploads\Imagessss\StylePicture\" + styleCode+ imgExtension); File.Copy(imagePath, @"D:\StylePicture\" + styleCode + imgExtension); } return(true); } else { return(false); } } catch { return(false); } } else { return(false); } } }