public ActionResult StorageArticle(Models.Article model)
{
if (Session["idProfile"] != null)
{
ConnectionDataBase.StoreProcediur data = new ConnectionDataBase.StoreProcediur();
var nomaas = Request.Files;
for (var i = 0; i < nomaas.Count; i++)
{
if (nomaas[i].ContentLength > 0)
{
string FileName = Path.GetFileNameWithoutExtension(nomaas[i].FileName);
string FileExtension = Path.GetExtension(nomaas[i].FileName);
FileName = DateTime.Now.ToString("yyyyMMdd") + "_" + FileName.Trim() + FileExtension;
string UploadPath = System.Web.HttpContext.Current.Server.MapPath("/Content/images/");
string stringimg = "/Content/images/" + FileName;
nomaas[i].SaveAs(UploadPath + FileName);
model.Image = "/Content/images/" + FileName;
}
}
DataTable td = data.StorageArticle(model);
return(RedirectToAction("Catalogo", "Home"));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
public ActionResult Index()
{
ViewBag.Title = "Home Page";
var model = new Models.Article("TitleFromController", "TextFromController");
return(View(model));
}
public async Task <IActionResult> Create(ArticleFormObject formObject)
{
var article = new Models.Article
{
Slug = sanitizer.Sanitize(formObject.Slug),
Title = sanitizer.Sanitize(formObject.Title),
Description = sanitizer.Sanitize(formObject.Description),
ThumbnailUrl = sanitizer.Sanitize(formObject.ThumbnailUrl)
};
var index = 0;
foreach (var chapter in formObject.ArticleChapters)
{
article.ArticleChapters.Add(new ArticleChapter
{
Name = sanitizer.Sanitize(chapter.LinkText),
Text = sanitizer.Sanitize(chapter.Text),
ChapterNumber = ++index
});
}
await context.AddAsync(article);
await context.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public static async Task <List <Models.Article> > GetArticles(List <Models.Article> articles)
{
string pmids = string.Join(",", articles.Select(x => x.Pmid).ToList());
string requestUri = $"https://eutils.ncbi.nlm.nih.gov/entrez/eutils/efetch.fcgi?db=pubmed&id={pmids}&rettype=null&retmode=xml";
string response = await httpClient.GetStringAsync(requestUri);
foreach (XElement element in XElement.Parse(response).Elements())
{
try
{
Models.Article article = articles.FirstOrDefault(x => x.Pmid == element.Element("MedlineCitation").Element("PMID").Value);
article.Title = element.Element("MedlineCitation").Element("Article").Element("ArticleTitle").Value;
article.Date = DateTime.Now;
try
{
article.Abstract = element.Element("MedlineCitation").Element("Article").Element("Abstract").Element("AbstractText").Value;
}
catch
{
article.Abstract = null;
}
}
catch
{
continue;
}
}
articles = articles.Where(x => x.Abstract != null).ToList();
return(articles);
}
public ActionResult Details()
{
IsOff();
int id;
try
{
id = int.Parse(RouteData.Values["id"].ToString());
}
catch
{
return(Redirect("~"));
}
DataTable dt = DBHelper.GetDT("exec GetArticleById " + id + "");
Models.Article a = new Models.Article();
a.AID = int.Parse(dt.Rows[0]["AID"].ToString());
a.ATitle = dt.Rows[0]["ATitle"].ToString();
a.AText = dt.Rows[0]["AText"].ToString();
a.ATime = DateTime.Parse(dt.Rows[0]["ATime"].ToString());
a.Users = new Models.Users();
a.Users.UName = dt.Rows[0]["UName"].ToString();
a.Category = new Models.Category();
a.Category.CName = dt.Rows[0]["CName"].ToString();
dt = DBHelper.GetDT("exec GetBrother " + id + "");
ViewData["Prev"] = dt.Rows[0]["Prev"].ToString();
ViewData["Next"] = dt.Rows[0]["Next"].ToString();
ViewData["Tags"] = DBHelper.GetDT("exec GetTagById " + id + "");
return(View(a));
}
public async Task CreateArticle(string title, string content, Guid[] categoryIds, Guid userId)
{
using (IDAL.IArticleService articleSvc = new DAL.ArticleService())
{
var article = new Models.Article()
{
Title = title,
Content = content,
UserId = userId
};
await articleSvc.CreateAsync(article);
Guid articleId = article.Id;
using (var articleToCategroySvc = new DAL.ArticleToCategoryService())
{
foreach (var categoryId in categoryIds)
{
await articleToCategroySvc.CreateAsync(new Models.ArticleToCategory()
{
ArticleId = articleId,
BlogCategoryId = categoryId
}, saved : false);
}
await articleToCategroySvc.Save();
}
}
}
public ActionResult createArticle([Bind(Include = "articleID, articleStatus, userName, title, body,postDate")] Models.Article article)
{
string username = Session["username"].ToString();
var doctor = smokeFreeDB.Doctor.Find(username);
var generalUser = smokeFreeDB.GeneralUser.Find(username);
if (Session["username"] == null)
{
return(RedirectToAction("SignIn", "Account"));
}
if (ModelState.IsValid)
{
//Convert uploaded file to byte[]
HttpPostedFileBase postedFile = Request.Files["ImageFile"];
Stream stream = postedFile.InputStream;
BinaryReader binaryReader = new BinaryReader(stream);
byte[] img = binaryReader.ReadBytes((int)stream.Length);
article.postDate = DateTime.Now;
article.userName = Session["username"].ToString();
article.articleStatus = "pending";
string tags = Request["tagsinput"].ToString();
article.articlePicture = img;
//smokeFreeDB.Configuration.ValidateOnSaveEnabled = false;
smokeFreeDB.Article.Add(article);
smokeFreeDB.SaveChanges();
smokeFreeDB.Entry(article).Reload();
tagAccess.saveArticleTags(tags, article.articleID);
return(RedirectToAction("DrProfile", "Doctor", new { viewUsername = username, page = 1 }));
}
return(RedirectToAction("DrProfile", "Doctor", new { viewUsername = username, page = 1 }));
}
// 新增编辑
public ActionResult Add(string cate/*内容分类*/, string code/*内容编码*/,
bool single/*独立页面标识, true: 标识独立*/, int tag/*独立页面标识,枚举类:Models.Article.ArticleTag 的一个实例*/)
{
Models.Article article = null;
ViewData[EDITORFORMACTIONNAME] = "upd";
if (single)
{
article = GetSingleArticle(cate, code, tag);
return View(article);
}
//此处重新编辑
if (!string.IsNullOrWhiteSpace(code))
{
Models.EFDbContext db = new Models.EFDbContext();
article = db.Articles.Single(t => t.Code == code);
return View(article);
}
ViewData[EDITORFORMACTIONNAME] = "add";
//此处新增
if (string.IsNullOrWhiteSpace(cate))
cate = Models.Article.COMPANYCATEGORY;
article = new Models.Article() { Category = cate };
return View(article);
}
public ActionResult Delete(int?id)
{
Models.Article art = db.Articles.Find(id);
db.Articles.Remove(art);
db.SaveChanges();
return(RedirectToAction("MyIndexList"));
}
public IActionResult Index()
{
ViewBag.Title = "Home Page";
var model = new Models.Article("Title", "Text");
return(View(model));
}
public ActionResult UpArticle(Models.Article a)
{
string tag = "";
try {
tag = RouteData.Values["id"].ToString();
}
catch {
tag = "";
}
a.ATitle = string.IsNullOrEmpty(a.ATitle.Trim()) ? "Null_Title" : a.ATitle;
a.AText = string.IsNullOrEmpty(a.AText.Trim()) ? "NineCode" : a.AText;
string sql = "exec UpArticle " + a.AID +
",'" + a.ATitle +
"','" + a.AText +
"'," + a.CID +
"," + a.UNum + "";
UpTag(tag, a.AID);
string res = DBHelper.GetScalar(sql).ToString();
if (res == "true")
{
res = "tip,恭喜您，文章操作成功！";
}
else
{
res = "warning,抱歉，文章操作失败！";
}
res = "/Admin/Tip/" + System.Web.HttpUtility.UrlEncode(res, System.Text.Encoding.Default);
return(Json(new { url = res }, JsonRequestBehavior.DenyGet));
}
public void OnPost(int?id, string headerInput, string headerLatinInput, string bodyInput, string tagsIdsInput)
{
if (id.HasValue && headerInput != null && headerLatinInput != null && bodyInput != null)//&& tagsIdsInput != null
{
var sanitizer = new HtmlSanitizer();
var sbody = sanitizer.Sanitize(bodyInput);
var parser = new HtmlParser();
var result = parser.ParseDocument(sbody);
var cleaner = new CleanUpArticleText(result);
var content = cleaner.cleanedText;
tagsIdsInput = "";
var tagsAr = tagsIdsInput.Split(" ");
var tags = new List <int>(tagsAr.Length);
//foreach (var x in tagsAr)
//{
// tags.Add(int.Parse(x));
//}
var article = new Models.Article {
Id = id.Value, Body = content, Header = headerInput, HeaderLatin = headerLatinInput
};
//int userId = (int)HttpContext.Session.GetInt32("auid");
article.Update(tags);
Article = article;
SuccesInfo = StringResources.StringResources.Instance.SuccesCreated;
}
}
public ActionResult Editor()
{
Models.Article a = new Models.Article();
string id;
try
{
id = RouteData.Values["id"].ToString();
}
catch
{
id = "";
}
ViewData["Category"] = DBHelper.GetDT("exec GetCategory");
int aid;
if (int.TryParse(id, out aid))
{
//修改文章
DataTable dt = null;
try
{
dt = DBHelper.GetDT("exec GetArticleById " + id);
a.AID = int.Parse(dt.Rows[0]["AID"].ToString());
a.ATitle = dt.Rows[0]["ATitle"].ToString();
a.AText = dt.Rows[0]["AText"].ToString();
a.ATime = DateTime.Now;
a.UNum = int.Parse(User.Identity.Name.ToString());
a.Category = new Models.Category();
a.Category.CName = dt.Rows[0]["CName"].ToString();
}
catch
{
return(Content("false"));
}
DataTable tags = DBHelper.GetDT("exec GetTagById " + a.AID);
string tag = "";
for (int i = 0; i < tags.Rows.Count; i++)
{
tag += ("@" + tags.Rows[i]["TName"].ToString() + " ");
}
ViewData["Tag"] = tag;
ViewData["Type"] = "Up";
}
else
{
//添加文章
string res = DBHelper.GetScalar("exec NewArticel " + User.Identity.Name.ToString()).ToString();
a.AID = int.Parse(res);
a.ATime = DateTime.Now;
a.ATitle = "";
a.AText = "";
a.UNum = int.Parse(User.Identity.Name.ToString());
a.Category = new Models.Category();
a.Category.CName = "";
ViewData["Tag"] = "";
ViewData["Type"] = "New";
}
return(View(a));
}
public ListeArticleGestionnaireDetailViewModel(Window window, int idGestionnaire, int idArticle)
{
this._window = window;
DBContext = new DatabaseContext.GestionRelationClient_DBContext();
this.idGestionnaire = idGestionnaire;
this.Article = DBContext.Articles.Where(a => (a.Id.Equals(idArticle))).FirstOrDefault();
this.NomArticle = this.Article.Nom;
this.ImageArticle = this.Article.Image;
this.TypeArticle = this.Article.Type;
this.PrixArticle = this.Article.Prix + " $";
this.DescriptionArticle = this.Article.GetArticleDetails();
this.ManuelArticle = this.ManuelArticle;
// Navigation
GoToAccueilCommand = new RelayCommand(
o => true,
o => OpenAccueil()
);
GoToListeArticlesCommand = new RelayCommand(
o => true,
o => OpenListeArticle()
);
GoToPageGestionnaireCommand = new RelayCommand(
o => true,
o => OpenPageGestionnaire()
);
}
public IActionResult OnGet(string articleHeader)
{
if (!HttpContext.Session.Keys.Contains("auid"))
{
return(RedirectToPage("/Auth/Login"));
}
if (articleHeader != null)
{
var sqlCmd = $"select id,latin_header, russian_header from articles where lower(latin_header) like '%{articleHeader.ToLower()}%' or lower(russian_header) like '%{articleHeader.ToLower()}%'";
var cmd = new NpgsqlCommand(sqlCmd, DBConnect.Connection);
var reader = cmd.ExecuteReader();
List <Models.Article> articles = new List <Models.Article>();
while (reader.Read())
{
var artcl = new Models.Article();
artcl.Id = reader.GetInt32(0);
artcl.HeaderLatin = reader.GetString(1);
artcl.Header = reader.GetString(2);
articles.Add(artcl);
}
reader.Close();
cmd.Dispose();
return(new JsonResult(articles));
}
return(Page());
}
public void Create(Models.Article article)
{
using (var context = new ArticlesContext())
{
context.Articles.Add(article);
context.SaveChanges();
}
}
/// <summary>
/// Carga los datos para edición en el formulario
/// </summary>
/// <param name="article">Article para edición</param>
private void LoadDataForm(Models.Article article)
{
txtName.Text = article.Name;
txtDescription.Text = article.Description;
mskPrice.Text = article.Price.ToString();
mskTotalShelf.Text = article.TotalInShelf.ToString();
mskTotalVault.Text = article.TotalInVault.ToString();
}
public ActionResult Edit(Models.Article model)
{
model.CreateTime = DateTime.Now;
db.Entry(model).State = System.Data.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult <Models.Article> PostArticle(Models.Article article)
{
_db.Articles.Add(article);
_db.SaveChanges();
Events.OnCreateArticle(new CreateArticleEventArgs {
Article = article
});
_db.SaveChanges();
return(CreatedAtAction("GetArticleBySlug", new { slug = article.Slug }, article));
}
public ActionResult GetArticle(Models.Article article)
{
var result = EnterRepository.GetRepositoryEnter().ArticleRepository.LoadEntities(m => m.ID == article.ID).FirstOrDefault();
return(Json(new
{
state = "success",
result = result
}));
}
public ActionResult Add(Models.Article model)
{
model.CreateTime = DateTime.Now;
db.Articles.Add(model);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult CreateIndividual()
{
ViewBag.JournalistId = new SelectList(db.AspNetUsers, "Id", "Email");
Article article = new Models.Article();
string currentUserId = User.Identity.GetUserId();
article.JournalistId = currentUserId;
article.PubDate = DateTime.Now;
return(View(article));
}
public IActionResult PatchArticle(int id, Models.Article article)
{
Events.OnPatchArticle(new PatchArticleEventArgs()
{
TargetArticle = _db.Articles.Find(id), Patch = article
});
_db.SaveChanges();
return(NoContent());
}
[ValidateInput(false)] //取消输入验证 --因为有内容有标签-得加这句
public ActionResult Edit(Models.Article art)
{
//加上 using System.Data.Entity;
if (ModelState.IsValid)
{
db.Entry(art).State = EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public IActionResult _IndexArticles(int?pageindex)
{
if (pageindex == null)
{
pageindex = 1;
}
ViewBag.index = pageindex + 1;
Models.Article ac = new Models.Article();
return(PartialView(ac.GetArticlesData(pageindex)));
}
public Article(Models.Article a)
{
this.CreateDate = a.createDate;
this.Link = a.link;
this.Header = a.header;
this.Description = a.description;
this.Keywords = a.keywords;
this.Text = a.text;
}
public ArticleDataModel(Models.Article article)
{
_article = article;
Id = article.Id;
Title = article.Title;
Slug = article.Slug;
Body = article.Body;
BodyHtml = article.BodyHtml;
BodyAbstract = article.BodyAbstract;
Timestamp = article.Timestamp;
Author = new UserDataModel(article.Author);
}
public ActionResult Detail(int?id)
{
Models.Article art = db.Articles.Find(id);
if (art != null)
{
art.clickCount = art.clickCount + 1; //修改点击率
art.lastClickTime = DateTime.Now; //修改点击时间
db.Entry(art).State = EntityState.Modified;
db.SaveChanges(); //保存修改
}
return(View(art));
}
public async Task <RespContainer <ArticleResponse> > Handle(AddArticleCommand request, CancellationToken cancellationToken)
{
Models.Article article = _articleMapper.Map(request.Data);
Models.Article result = _articleRespository.Add(article);
int modifiedRecords = await _articleRespository.UnitOfWork.SaveChangesAsync();
_logger.LogInformation(Events.Add, Messages.NumberOfRecordAffected_modifiedRecords, modifiedRecords);
_logger.LogInformation(Events.Add, Messages.ChangesApplied_id, result?.Id);
return(RespContainer.Ok(_articleMapper.Map(result), "Article Created"));
}
Article ArticleInterface.Add(Models.Article item)
{
//throw new NotImplementedException();
if (item == null)
{
throw new ArgumentNullException("item");
}
// TO DO : Code to save record into database
db.Articles.Add(item);
db.SaveChanges();
return(item);
}
public bool UpdateArticle(Models.Article Article)
{
//EntityMapper<Models.Article, DataAccessLayer.Article> mapObj = new EntityMapper<Models.Article, DataAccessLayer.Article>();
DataAccessLayer.Article ArticleObj = new DataAccessLayer.Article();
ArticleObj.ArticleId = Article.ArticleId;
ArticleObj.ArticleName = Article.ArticleName;
ArticleObj.ArticleContent = Article.ArticleContent;
//ArticleObj = mapObj.Translate(Article);
var status = DAL.UpdateArticle(ArticleObj);
return(status);
}
public void DeleteAction()
{
string msg = "";
if (String.IsNullOrEmpty(_view.NumArticle)) msg += "Vous devez d'abord choisir un article par doublic-clic sur la ligne correspondante. \n";
if (!String.IsNullOrEmpty(msg))
{
MessageBox.Show(msg, "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
try
{
Models.Article article = new Models.Article();
article.Num = int.Parse(_view.NumArticle);
int nbTickets = ArticleDAO.GetNbTickets(article);
if (ArticleDAO.Get(article.Num).Num < 1)
{
throw new Exception("L'article n°" + article.Num + " n'existe pas.");
}
if (MessageBox.Show("L'article n°" + article.Num + " est référencé dans " + nbTickets.ToString() + " tickets.\n Voulez-vous vraiment supprimer l'article ?", "Information", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes && !TicketContenuDAO.Delete(article) & !ArticleDAO.Delete(article))
{
throw new Exception("L'article n°" + article.Num + " n'a pas pu être supprimé.");
}
listeArticles.RemoveAll(a => a.Num == article.Num);
search();
source.ResetBindings(false);
if (MessageBox.Show("L'article n°" + article.Num + " a bien été supprimé.\n Voulez-vous supprimer un autre atricle ?", "Information", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
ClearAction();
}
else
{
_view.CloseAction();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public void SaveAction()
{
if (!validation())
{
MessageBox.Show("Vous n'avez pas rempli tous les champs correctement.", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
try
{
Models.Article article = new Models.Article();
article.SousCategorie = _view.SelectedSousCategorie;
article.Marque = _view.Marque;
article.Description1 = _view.Description1;
article.Description2 = _view.Description2;
article.Prix = _view.Prix;
article.QuantiteStock = _view.QteStock;
if (!ArticleDAO.Insert(article))
{
throw new Exception("L'article n'a pas pu être ajouté.");
}
if (MessageBox.Show("L'article a bien été ajouté.\n Voulez-vous continuer la saisie ?", "Information", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
ClearAction();
}
else
{
_view.CloseAction();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public ActionResult SingleArticles(string cate, int tag)
{
Models.EFDbContext db = new Models.EFDbContext();
Models.Article article = db.Articles.SingleOrDefault(t => t.Category == cate && t.Tag == tag);
if (article == null)
article = new Models.Article() { Category = cate, Tag = tag };
return View(article);
}
public ActionResult Add()
{
var model = new Models.Article();
return View(model);
}
public void SaveAction()
{
string msg = "";
if (String.IsNullOrEmpty(_view.NumArticle)) msg += "Vous devez d'abord choisir un article par doublic-clic sur la ligne correspondante. \n";
else if (!validation()) msg += "Vous n'avez pas rempli tous les champs correctement.";
if (!String.IsNullOrEmpty(msg))
{
MessageBox.Show(msg, "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
try
{
Models.Article article = new Models.Article();
article.Num = _view.SelectedArticle.Num;
article.SousCategorie = _view.SelectedSousCategorieArticle;
article.Marque = _view.MarqueArticle;
article.Description1 = _view.Description1Article;
article.Description2 = _view.Description2Article;
article.Prix = _view.PrixArticle;
article.QuantiteStock = _view.QteStockArticle;
if (!ArticleDAO.Update(article))
{
throw new Exception("L'article n'a pas pu être modifié.");
}
// Remove the old item
int ind = listeArticles.FindIndex(a => a.Num == article.Num);
listeArticles.RemoveAt(ind);
// Add the new item
listeArticles.Insert(ind, article);
search();
if (MessageBox.Show("L'article a bien été modifié.\n Voulez-vous continuer la saisie ?", "Information", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
ClearAction();
}
else
{
_view.CloseAction();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public Models.Article GetSingleArticle(string cate, string code, int tag)
{
Models.Article article = null;
if (!string.IsNullOrWhiteSpace(code))
{
Models.EFDbContext db = new Models.EFDbContext();
article = db.Articles.SingleOrDefault(t => t.Code == code);
}
if (article == null)
{
ViewData[EDITORFORMACTIONNAME] = "add";
article = new Models.Article() { Category = cate, Tag = tag };
}
return article;
}
