public static List <DBO.ArticleAttach> GetListArticleAttachByArticle(long article_id) { List <DBO.ArticleAttach> result = new List <DBO.ArticleAttach>(); try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { List <T_Article_Attach> list = bdd.T_Article_Attach.Where(x => x.id_article == article_id).ToList(); foreach (T_Article_Attach ArticleAttach in list) { DBO.ArticleAttach newAttach = new DBO.ArticleAttach() { Id = ArticleAttach.id, IdArticle = ArticleAttach.id_article, FilePath = ArticleAttach.file_path, Name = ArticleAttach.name }; result.Add(newAttach); } return(result); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(result); } }
public static bool CreateArticleAttach(DBO.ArticleAttach articleAttach) { try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { T_Article_Attach newArticleAttach = new T_Article_Attach() { id_article = articleAttach.IdArticle, file_path = articleAttach.FilePath, name = articleAttach.Name }; bdd.T_Article_Attach.Add(newArticleAttach); bdd.SaveChanges(); return(true); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(false); } }
public static bool UpdateArticleAttach(DBO.ArticleAttach articleAttach) { try { using (MeditateBookEntities bdd = new MeditateBookEntities()) { T_Article_Attach old = bdd.T_Article_Attach.Where(x => x.id == articleAttach.Id).FirstOrDefault(); if (old != null) { old.id_article = articleAttach.IdArticle; old.file_path = articleAttach.FilePath; old.name = articleAttach.Name; bdd.SaveChanges(); return(true); } return(false); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(false); } }
public ActionResult EditArticle(EditArticleModel model, HttpPostedFileBase file) { if (!ModelState.IsValid) { return(View(model)); } var result = true; switch (result) { case true: DBO.Article article = new DBO.Article { Title = model.Title, Content = model.Content, Validated = false, CreatedDate = DateTime.Now }; var idCreator = HttpContext.Session["UserID"]; if (idCreator != null) { article.IdCreator = (long)idCreator; } BusinessManagement.Article.CreateArticle(ref article); if (file != null) { string pic = System.IO.Path.GetFileName(file.FileName); string dir = Server.MapPath("~/images/article"); string path = System.IO.Path.Combine(dir, pic); if (!Directory.Exists(dir)) { Directory.CreateDirectory(dir); } // file is uploaded file.SaveAs(path); DBO.ArticleImage image = new DBO.ArticleImage(); image.ImagePath = path; image.Name = pic; image.IdArticle = article.Id; BusinessManagement.ArticleImage.CreateArticleImage(image); } string dirAttach = Server.MapPath("~/images/attach"); int i = 0; if (HttpContext.Session["ListAttach" + i] != null) { while (HttpContext.Session["ListAttach" + i] != null) { DBO.ArticleAttach articleAttach = new DBO.ArticleAttach(); articleAttach.Name = (string)HttpContext.Session["ListAttach" + i]; articleAttach.FilePath = Path.Combine(dirAttach, articleAttach.Name); articleAttach.IdArticle = article.Id; BusinessManagement.ArticleAttach.CreateArticleAttach(articleAttach); i++; } } return(RedirectToAction("Submit", "Articles")); case false: ModelState.AddModelError("", "Insertion d'article invalide"); return(View(model)); default: ModelState.AddModelError("", "Insertion d'article invalide"); return(View(model)); } }
public static bool CreateArticleAttach(DBO.ArticleAttach articleAttach) { return(DataAccess.ArticleAttach.CreateArticleAttach(articleAttach)); }