public ActionResult AddImage(ArticleImage model, HttpPostedFileBase file) { if (file != null) { using (var db = new BlogDbContext()) { //var lastImage = new ArticleImage(); var lastImage = db.ArticleImages.Count(); int nextId = db.ArticleImages.Max(i => i.Id) + 1; //if (lastImage.Id > 0) //{ // nextId = lastImage.Id + 1; //} var image = new ArticleImage(); image.ArticleId = model.ArticleId; string pic = System.IO.Path.GetFileName(file.FileName); pic = nextId.ToString() + pic; image.FileName = pic; db.ArticleImages.Add(image); db.SaveChanges(); string path = System.IO.Path.Combine( Server.MapPath("~/images"), pic); // file is uploaded file.SaveAs(path); } } return(RedirectToAction("Details", "Article", new { id = model.ArticleId })); }
public ActionResult ListArticlesOfCategory(int?id) { using (var db = new BlogDbContext()) { var articles = db.Categories .Include(c => c.Articles.Select(a => a.Author)) .Include(c => c.Articles.Select(a => a.Tags)) .FirstOrDefault(c => c.Id == id) .Articles .ToList(); Dictionary <int, string> Articalpicture = new Dictionary <int, string>(); var images = db.ArticleImages.ToList(); foreach (var article in articles) { var image = new ArticleImage(); string Name = "noimage.png"; try { Name = images.FirstOrDefault(i => i.ArticleId == article.Id).FileName; Articalpicture.Add(article.Id, Name); } catch (Exception) { Articalpicture.Add(article.Id, Name); //throw; } } ViewBag.Pictures = Articalpicture; return(View(articles)); } }
public int Insert(ArticleImage entity) { entity.CreateDate = DateTime.Now; db.ArticleImages.Add(entity); db.SaveChanges(); return(entity.ArticleImageID); }
public void SetArticleImage(WWWForm form) { var name = ArticleImage.name; var data = ArticleImage.EncodeToJPG(); form.AddBinaryData("image", data, name); }
public void Update(DbContext DbContext,ArticleImage entity) { EntityState state = DbContext.Entry(entity).State; if (state == EntityState.Detached) { DbContext.Entry(entity).State = EntityState.Modified; } }
public ActionResult DeleteConfirmed(int id) { ArticleImage articleimage = db.ArticleImages.Find(id); db.ArticleImages.Remove(articleimage); db.SaveChanges(); return(RedirectToAction("Index")); }
/// <summary> /// Creates a new image /// </summary> /// <param name="image">The image defintion to add</param> /// <returns>The added image object.</returns> public ApiResult <ArticleImage> AddArticleImage(ArticleImage image) { if (image.Id != 0) { throw new InvalidValueException("To add a new image, only 0 as Id is allowed."); } return(put <ApiResult <ArticleImage> >($"/products/{image.ArticleId}/images/{image.Id}", image)); }
void HeadlinesLV_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (HeadlinesLV.SelectedIndex >= 0) { ArticleTitleTB.Text = LastSelectedArticle = CurrentData[HeadlinesLV.SelectedIndex].Title; ArticleImage.LoadImage(CurrentData[HeadlinesLV.SelectedIndex].Images, false, true); ArticleTextTB.Text = CurrentData[HeadlinesLV.SelectedIndex].Text; } }
/// <summary> /// Updates an existing image /// </summary> /// <param name="image">Definition of the image to update.</param> /// <returns>The updated image object.</returns> public ApiResult <ArticleImage> UpdateArticleImage(ArticleImage image) { if (image.Id == 0) { throw new InvalidValueException("To update an image, the Id must not be 0."); } return(put <ApiResult <ArticleImage> >($"/products/{image.ArticleId}/images/{image.Id}", image)); }
//GET public ActionResult AddImage(int id, string title) { var model = new ArticleImage(); model.ArticleId = id; ViewBag.articleTitle = title; return(View(model)); }
private async Task UploadImage(IFormFile image, Article article) { var uploadedPhoto = await filesManager.Upload(image, $"articles/{article.Id}"); var articleImage = ArticleImage.Create(uploadedPhoto.Path, article.Id); await database.ArticleImageRepository.Insert(articleImage, false); article.SetImageUrl(uploadedPhoto.Path); }
public ActionResult Edit([Bind(Include = "Id,ArticleId,FileName")] ArticleImage articleImage) { if (ModelState.IsValid) { db.Entry(articleImage).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ArticleId = new SelectList(db.Articles, "Id", "Title", articleImage.ArticleId); return(View(articleImage)); }
//lorsque l'on quitte l'input du lien de l'image, recharge l'image à partir du nouvel url private void textBox1_Leave(object sender, EventArgs e) { try { ArticleImage.Load(ArticleLienImage.Text); //Recharge l'image } catch { MessageBox.Show("image non trouvée"); //Message d'erreur } }
public ActionResult Edit([Bind(Include = "ArticleId,SmallImageUrl,MediumImageUrl,LargelImageUrl,OrderIndex,Id")] ArticleImage articleimage) { if (ModelState.IsValid) { db.Entry(articleimage).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ArticleId = new SelectList(db.Articles, "Id", "UrlName", articleimage.ArticleId); return(View(articleimage)); }
public ActionResult Create([Bind(Include = "Id,ArticleId,FileName")] ArticleImage articleImage) { if (ModelState.IsValid) { db.ArticleImages.Add(articleImage); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ArticleId = new SelectList(db.Articles, "Id", "Title", articleImage.ArticleId); return(View(articleImage)); }
public string GetArticleURLByImage(int image_id) { ArticleImage img = DAManager.ArticleImagesRepository.Get(i => i.ImageId == image_id, null, "Article").FirstOrDefault(); if (img == null) { return(""); } else { return(img.Article.URL); } }
public bool CreateArticleImage(ArticleImage articleImage) { try { _context.Add(articleImage); _context.SaveChanges(); } catch (DbUpdateException) { return(false); } return(true); }
public virtual OperationResult Create(ArticleImageInfo info) { OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!"); using (var DbContext = new CmsDbContext()) { ArticleImage entity = new ArticleImage(); DESwap.ArticleImageDTE(info, entity); ArticleImageRpt.Insert(DbContext, entity); DbContext.SaveChanges(); } result.ResultType = OperationResultType.Success; result.Message = "操作成功!"; return result; }
public BaseObject InsertArticleImage(ArticleImageEntity param) { BaseObject obj = new BaseObject(); if (_db.ArticleImages.Any(m => m.Title == param.Title)) { obj.Tag = -2; obj.Message = "该标题已经存在!"; return(obj); } try { var image = new ArticleImage() { Author = param.Author, Content = param.Content, DateCreated = DateTime.Now, IsDelete = PublicType.No, MetaDescription = param.MetaDescription, PageTitle = param.PageTitle, MetaKeywords = param.MetaKeywords, PageVisits = param.PageVisits, ShortTitle = param.ShortTitle, Slug = param.Slug, SortOrder = param.SortOrder, Source = param.Source, Title = param.Title, UpdateUser = param.UpdateUser, Overview = param.Overview, ColumnID = param.ColumnID }; _db.ArticleImages.Add(image); _db.SaveChanges(); obj.Tag = 1; if (HandlePicture(param, image.ID).Tag != 1) { obj.Tag = -2; } } catch (Exception e) { obj.Tag = -1; } return(obj); }
// GET: /Admin/ArticleImages/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ArticleImage articleimage = db.ArticleImages.Find(id); if (articleimage == null) { return(HttpNotFound()); } return(View(articleimage)); }
// GET: /Admin/ArticleImages/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ArticleImage articleimage = db.ArticleImages.Find(id); if (articleimage == null) { return(HttpNotFound()); } ViewBag.ArticleId = new SelectList(db.Articles, "Id", "UrlName", articleimage.ArticleId); return(View(articleimage)); }
/// <summary> /// 保存对应段落的图片 /// </summary> /// <param name="data"></param> /// <returns></returns> public async Task <int> Add(ArticleImage data) { await _db.ArticleImages.AddAsync(data); var result = await _db.SaveChangesAsync(); if (result > 0) { return(data.id); } else { return(0); } }
public ActionResult Create([Bind(Include = "id,ArticleId,Image,title")] ArticleImage articleImage, HttpPostedFileBase Image) { articleImage.Image = System.IO.Path.GetFileName(Image.FileName); if (ModelState.IsValid) { db.ArticleImages.Add(articleImage); db.SaveChanges(); Image.SaveAs(Server.MapPath("../uploads/articleImages/" + articleImage.id.ToString() + "_" + articleImage.Image)); return(RedirectToAction("Index")); } ViewBag.ArticleId = new SelectList(db.articles, "id", "title", articleImage.ArticleId); return(View(articleImage)); }
public ArticleView(string user, string article = null) { client.setClient(user); InitializeComponent(); get_categories(); //si on modifie un articel déjà présent if (article != null && article != "") { ArticleModif.setArticle(article); //on enregistre l'id de l'article de sorte à l'utiliser plus tard MySqlCommand cmd = conn.CreateCommand(); //affichage du bouton supprimer Supprimer.Visible = true; Supprimer.Enabled = true; cmd.Parameters.AddWithValue("@client", user); cmd.Parameters.AddWithValue("@article", article); cmd.CommandText = "SELECT article.nom, article.prix, article.quantite, article.description, article.image, categorie.nom FROM article INNER JOIN magasin ON magasin.idMagasin = article.idMagasin INNER JOIN categorie ON article.idCategorie = categorie.idCategorie WHERE magasin.idProprietaire = @client AND article.idArticle = @article"; try { conn.Open(); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { //On place les éléments de la page dans les inputs ArticleName.Text = reader.GetString(0); ArticlePrix.Value = reader.GetDecimal(1); ArticleQuantite.Value = reader.GetInt32(2); ArticleDescription.Text = reader.GetString(3); ArticleLienImage.Text = reader.GetString(4); ArticleImage.Load(ArticleLienImage.Text); ArticleCategorie.SelectedItem = reader.GetString(5); } conn.Close(); } catch (MySqlException ex) { Console.WriteLine(ex); } } else //Si on veut créer un nouvel article { //On fait disparaitre le bouton supprimer Supprimer.Visible = false; Supprimer.Enabled = false; } }
public NewsUpdateResult UpdateArticleImage(ArticleImage articleImage) { try { _context.Update(articleImage); _context.SaveChanges(); } catch (DbUpdateConcurrencyException) { return(NewsUpdateResult.ConcurrencyError); } catch (DbUpdateException) { return(NewsUpdateResult.DbError); } return(NewsUpdateResult.Success); }
public virtual OperationResult Create(IEnumerable<ArticleImageInfo> infoList) { OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!"); List<ArticleImage> eList = new List<ArticleImage>(); infoList.ForEach(x => { ArticleImage entity = new ArticleImage(); DESwap. ArticleImageDTE(x, entity); eList.Add(entity); }); using (var DbContext = new CmsDbContext()) { ArticleImageRpt.Insert(DbContext, eList); DbContext.SaveChanges(); } result.ResultType = OperationResultType.Success; result.Message = "操作成功!"; return result; }
public ArticleImage GetArticleImage(int imageId) { ArticleImage articleImage = null; try { using (IDataStoreContext dataStoreContext = this._DataStore.CreateContext()) { CMSFile file = dataStoreContext.cms_Files_Get(imageId, Contracts.CMS.FileType.ArticleImage); if (file != null) { articleImage = new ArticleImage(file, dataStoreContext.cms_Tags_GetByFileId(imageId).ToList()); } } } catch (SqlException ex) { _Log.Error("Error at cms_Files_Get", ex); throw new DataStoreException(ex, true); } return(articleImage); }
public bool Update(ArticleImage entity) { try { var _Cate = db.ArticleImages.Find(entity.ArticleImageID); _Cate.ArticleID = entity.ArticleID; _Cate.MetaTitle = entity.MetaTitle; _Cate.Description = entity.Description; _Cate.Image = entity.Image; _Cate.CreateDate = entity.CreateDate; _Cate.CreateUser = entity.CreateUser; _Cate.ModifiedDate = DateTime.Now; _Cate.ModifiedUser = entity.ModifiedUser; _Cate.IsActive = entity.IsActive; db.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public async Task <IActionResult> ArticleDetail(int?id) { if (id != null) { // Article article = await db.Articles.FirstOrDefaultAsync(i => i.Id == id); Article article = await db.Articles.Include(a => a.ArticlesTags).ThenInclude(at => at.Tag).FirstOrDefaultAsync(i => i.Id == id); if (article != null) { ArticleImage articleImage = new ArticleImage { Artical = article }; if (article.HeroImage != null) { articleImage.Image = Convert.ToBase64String(article.HeroImage); } return(View(articleImage)); } } return(NotFound()); }
private static ArticleImage[] TryCreateImages(byte[][] data, Article article) { ArticleImage[] images = new ArticleImage[data.Length]; bool success = true; for (int i = 0; success && i < data.Length; i++) { try { using (MemoryStream ms = new MemoryStream(data[i])) { Image image = Image.FromStream(ms); var jpg = System.Drawing.Imaging.ImageFormat.Jpeg; using (var outStream = new MemoryStream()) { image.Save(outStream, jpg); images[i] = new ArticleImage() { ImageData = outStream.ToArray(), Article = article }; } } } catch { success = false; } } if (success) { return(images); } else { return(null); } }
public ArticleImage GetTemporaryArticleImage(int imageId) { ArticleImage articleImage = null; try { using (IDataStoreContext dataStoreContext = this._DataStore.CreateContext()) { CMSFile file = dataStoreContext.cms_FilesTemp_Get(imageId, FileType.ArticleImage); if (file != null) { articleImage = new ArticleImage(file); } } } catch (SqlException ex) { _Log.Error("Error at cms_FilesTemp_Get", ex); throw new DataStoreException(ex, true); } return(articleImage); }
public ActionResult Edit([Bind(Include = "ArticleImageID,ArticleID,MetaTitle,Description,Image,CreateDate,CreateUser,ModifiedDate,ModifiedUser,IsActive")] ArticleImage articleImage) { var UserSession = (UserLogin)Session[TechDeviShopVs002.Common.CommonConstants.USER_SESSION]; if (ModelState.IsValid) { var _dal = new ArticleImageDAL(); articleImage.ModifiedUser = UserSession.UserID; var _result = _dal.Update(articleImage); if (_result) { return(RedirectToAction("Index", "ArticleImages")); } else { ModelState.AddModelError("", "Cập nhật ảnh bài viết ko thành công"); } } ViewBag.ArticleID = new SelectList(db.Articles, "ArticleID", "Title", articleImage.ArticleID); return(View(articleImage)); }
/// <summary> /// 修改对应段落图片的描述 /// </summary> /// <param name="data"></param> /// <returns></returns> public async Task <bool> UpdateTitle(ArticleImage data) { if (data.ArticleConTentId == 0) { return(false); } var artimgs = _db.ArticleImages.Where(a => a.ArticleConTentId == data.ArticleConTentId); if (artimgs.Count() > 0) { foreach (var item in artimgs) { item.title = data.title; } var result = await _db.SaveChangesAsync(); if (result > 0) { return(true); } } return(false); }
public void Delete(DbContext DbContext,ArticleImage entity) { DbContext.Entry(entity).State = EntityState.Deleted; }
public override OperationResult Create(ArticleInfo info) { OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!"); using (var DbContext = new CmsDbContext()) { /*******保存资讯正文摘要*******/ info.AuditTime = DateTime.Now; info.AuditState = (int)sct.dto.cms.EnumSet.ArticleAuditState.Edit; Article entity = new Article(); DESwap.ArticleDTE(info, entity); ArticleRpt.Insert(DbContext, entity); if (info.ArticleType == (int)sct.dto.cms.EnumSet.ArticleType.Article) { /*******保存正文*******/ if (info.ArticleDetail == null) { info.ArticleDetail = new ArticleDetailInfo(); } info.ArticleDetail.Id = System.Guid.NewGuid().ToString(); info.ArticleDetail.ArticleId = info.Id; ArticleDetail detail = new ArticleDetail(); DESwap.ArticleDetailDTE(info.ArticleDetail, detail); ArticleDetailRpt.Insert(DbContext, detail); } else if (info.ArticleType == (int)sct.dto.cms.EnumSet.ArticleType.Picture) { /*******保存图片*******/ List<ArticleImage> imagelist = new List<ArticleImage>(); foreach (var imageinfo in info.ArticleImageList) { if (string.IsNullOrEmpty(imageinfo.Id)) { imageinfo.Id = System.Guid.NewGuid().ToString(); imageinfo.ArticleId = info.Id; ArticleImage image = new ArticleImage(); DESwap.ArticleImageDTE(imageinfo, image); imagelist.Add(image); } } ArticleImageRpt.Insert(DbContext, imagelist); } else if (info.ArticleType == (int)sct.dto.cms.EnumSet.ArticleType.Video) { /*******保存视频*******/ if (info.ArticleVideo == null) { info.ArticleVideo = new ArticleVideoInfo(); } info.ArticleVideo.Id = System.Guid.NewGuid().ToString(); info.ArticleVideo.ArticleId = info.Id; ArticleVideo video = new ArticleVideo(); DESwap.ArticleVideoDTE(info.ArticleVideo, video); ArticleVideoRpt.Insert(DbContext, video); } /*异常数据未处理*/ DbContext.SaveChanges(); } result.ResultType = OperationResultType.Success; result.Message = "操作成功!"; return result; }
public override OperationResult Modify(ArticleInfo info) { OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!"); using (var DbContext = new CmsDbContext()) { /*******保存资讯正文摘要*******/ Article article = ArticleRpt.Get(DbContext, info.Id); DESwap.ArticleDTE(info, article); ArticleRpt.Update(DbContext, article); if (info.ArticleType == (int)sct.dto.cms.EnumSet.ArticleType.Article) { /*******保存正文*******/ ArticleDetail detail = ArticleDetailRpt.Get(DbContext, info.ArticleDetail.Id); DESwap.ArticleDetailDTE(info.ArticleDetail, detail); ArticleDetailRpt.Update(DbContext, detail); } else if (info.ArticleType == (int)sct.dto.cms.EnumSet.ArticleType.Picture) { /*****新增列表*********/ List<ArticleImage> imageinsertlist = new List<ArticleImage>(); /*****例改列表*********/ List<ArticleImage> imageupdatelist = new List<ArticleImage>(); /*****删除列表*********/ List<ArticleImage> imagedeletelist = new List<ArticleImage>(); var imageexistlist = (from i in DbContext.ArticleImage where i.ArticleId.Equals(article.Id) select i).ToList(); /*************新增或修改******************/ foreach (var imageinfo in info.ArticleImageList) { if (string.IsNullOrEmpty(imageinfo.Id)) { /*************新增************************/ imageinfo.Id = System.Guid.NewGuid().ToString(); imageinfo.ArticleId = info.Id; ArticleImage image = new ArticleImage(); DESwap.ArticleImageDTE(imageinfo, image); imageinsertlist.Add(image); } else { /****************修改********************/ var image = imageexistlist.Where(x => x.Id.Equals(imageinfo.Id)).FirstOrDefault(); if (image != null) { //ArticleImage image = ArticleImageRpt.Get(DbContext, imageinfo.Id); DESwap.ArticleImageDTE(imageinfo, image); imageupdatelist.Add(image); } else { imageinfo.Id = System.Guid.NewGuid().ToString(); imageinfo.ArticleId = info.Id; image = new ArticleImage(); DESwap.ArticleImageDTE(imageinfo, image); imageinsertlist.Add(image); } } } /*************删除******************/ foreach (var imageexist in imageexistlist) { var image = info.ArticleImageList.Where(x => x.Id.Equals(imageexist.Id)).FirstOrDefault(); if (image == null) { imagedeletelist.Add(imageexist); } } ArticleImageRpt.Insert(DbContext, imageinsertlist); ArticleImageRpt.Update(DbContext, imageupdatelist); ArticleImageRpt.Delete(DbContext, imagedeletelist); } else if (info.ArticleType == (int)sct.dto.cms.EnumSet.ArticleType.Video) { /*******保存视频*******/ ArticleVideo video = ArticleVideoRpt.Get(DbContext, info.ArticleVideo.Id); DESwap.ArticleVideoDTE(info.ArticleVideo, video); ArticleVideoRpt.Update(DbContext, video); } /*异常数据未处理*/ DbContext.SaveChanges(); } result.ResultType = OperationResultType.Success; result.Message = "操作成功!"; return result; }
public void Insert(DbContext DbContext,ArticleImage entity) { DbContext.Entry(entity).State = EntityState.Added; }
public static void ArticleImageDTE(ArticleImageInfo info, ArticleImage entity) { if (info._IdIsDirty == 1) { entity.Id = info.Id; info._IdIsDirty = 0; } if (info._ArticleIdIsDirty == 1) { entity.ArticleId = info.ArticleId; info._ArticleIdIsDirty = 0; } if (info._AltTextIsDirty == 1) { entity.AltText = info.AltText; info._AltTextIsDirty = 0; } if (info._SummaryIsDirty == 1) { entity.Summary = info.Summary; info._SummaryIsDirty = 0; } if (info._PathIsDirty == 1) { entity.Path = info.Path; info._PathIsDirty = 0; } if (info._ThumbPathIsDirty == 1) { entity.ThumbPath = info.ThumbPath; info._ThumbPathIsDirty = 0; } if (info._SYS_OrderSeqIsDirty == 1) { entity.SYS_OrderSeq = info.SYS_OrderSeq; info._SYS_OrderSeqIsDirty = 0; } if (info._SYS_IsValidIsDirty == 1) { entity.SYS_IsValid = info.SYS_IsValid; info._SYS_IsValidIsDirty = 0; } if (info._SYS_IsDeletedIsDirty == 1) { entity.SYS_IsDeleted = info.SYS_IsDeleted; info._SYS_IsDeletedIsDirty = 0; } if (info._SYS_RemarkIsDirty == 1) { entity.SYS_Remark = info.SYS_Remark; info._SYS_RemarkIsDirty = 0; } if (info._SYS_StaffIdIsDirty == 1) { entity.SYS_StaffId = info.SYS_StaffId; info._SYS_StaffIdIsDirty = 0; } if (info._SYS_StationIdIsDirty == 1) { entity.SYS_StationId = info.SYS_StationId; info._SYS_StationIdIsDirty = 0; } if (info._SYS_DepartmentIdIsDirty == 1) { entity.SYS_DepartmentId = info.SYS_DepartmentId; info._SYS_DepartmentIdIsDirty = 0; } if (info._SYS_CompanyIdIsDirty == 1) { entity.SYS_CompanyId = info.SYS_CompanyId; info._SYS_CompanyIdIsDirty = 0; } if (info._SYS_AppIdIsDirty == 1) { entity.SYS_AppId = info.SYS_AppId; info._SYS_AppIdIsDirty = 0; } if (info._SYS_CreateTimeIsDirty == 1) { entity.SYS_CreateTime = info.SYS_CreateTime; info._SYS_CreateTimeIsDirty = 0; } if (info._SYS_ModifyTimeIsDirty == 1) { entity.SYS_ModifyTime = info.SYS_ModifyTime; info._SYS_ModifyTimeIsDirty = 0; } if (info._SYS_DeleteTimeIsDirty == 1) { entity.SYS_DeleteTime = info.SYS_DeleteTime; info._SYS_DeleteTimeIsDirty = 0; } }