public async Task <IActionResult> PutDocWord(Document doc) { //must have a body if (doc.body == null || doc.title == null) { return(BadRequest()); } //group equal words var wordsGroup = GroupWords(doc); //for every unique word found foreach (var grp in wordsGroup) { //fetch that word stats from the DB if exists DocWord docWord = (from P in _context.DocWords.Where(b => b.Name == grp.Key) select P).FirstOrDefault(); if (docWord == null) { //create new entry docWord = new DocWord(grp.Key, grp.Count()); _context.DocWords.Add(docWord); } else { //update count docWord.Count += grp.Count(); _context.Entry(docWord).State = EntityState.Modified; } } //fetch and increment document count on the database GlobalVar doccount = (from P in _context.Globals.Where(b => b.Name == "DocCount") select P).FirstOrDefault(); doccount.Value++; _context.Entry(doccount).State = EntityState.Modified; await _context.SaveChangesAsync(); return(NoContent()); }
public void DocWordAdd() { int orgID = GetOrgID(); Org org = (from c in CQGJ.Org where c.OrgID == orgID select c).First(); DocWord docWord = new DocWord(); docWord.WordName = GetString("WordName"); docWord.Org = org; CQGJ.AddToDocWord(docWord); CQGJ.SaveChanges(); RedirectToAction("DocWordList"); }
/// <summary> /// There are no comments for DocWord in the schema. /// </summary> public void AddToDocWord(DocWord docWord) { base.AddObject("DocWord", docWord); }
/// <summary> /// Create a new DocWord object. /// </summary> /// <param name="wordID">Initial value of WordID.</param> public static DocWord CreateDocWord(int wordID) { DocWord docWord = new DocWord(); docWord.WordID = wordID; return docWord; }