public JsonResult SavFav(TermsController term) { int output = term.userInput1; string output2 = term.aspId; var resetQuery = from key in db.Terms select key; foreach (Term key in resetQuery) { if (key.IsLiked == true || key.IsLiked == null) { key.IsLiked = false; } } var setQuery = from key in db.Terms where key.TermID == output select key; foreach (Term key in setQuery) { if (key.IsLiked == false || key.IsLiked == null) { key.IsLiked = true; } } db.SaveChanges(); int tempfav = term.ctr++; int tempTerm = term.userInput1; string tempId = term.aspId; Favorite fav = new Favorite { FavoriteID = tempfav, TermID = tempTerm, Id = tempId }; // Add the new object to the Orders collection. db.Favorites.Add(fav); db.SaveChanges(); return(new JsonResult() { Data = JsonConvert.SerializeObject(output2), JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public JsonResult GetKey(TermsController term) { string outPut = term.userInput; var outPut1 = ""; if (ModelState.IsValid) { string[] keyArr = db.Terms.Select(x => x.TermName).ToArray(); var relaceQuery = from key in db.Terms where key.IsMatch == true select key; foreach (Term key in relaceQuery) { if (key.IsMatch == true) { key.IsMatch = false; } } db.SaveChanges(); for (int j = 0; j < keyArr.Length; j++) { outPut1 = keyArr[j]; } string[] wordArr = outPut.Split(' '); for (int i = 0; i < wordArr.Length; i++) { var tempword = wordArr[i]; wordArr[i] = UppercaseFirst(tempword); } for (int i = 0; i < wordArr.Length; i++) { var tempWord = wordArr[i]; if (keyArr.Contains(tempWord)) { var query = from key in db.Terms where key.TermName == tempWord select key; foreach (Term key in query) { if (key.IsMatch == null || key.IsMatch == false) { key.IsMatch = true; } } } } db.SaveChanges(); } return(new JsonResult() { Data = JsonConvert.SerializeObject(outPut1), JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public JsonResult SavFav(TermsController term) { term.output = term.userInput1; string output2 = term.aspId; var resetQuery = from key in db.Terms select key; foreach (Term key in resetQuery) { if (key.IsLiked == true || key.IsLiked == null) { key.IsLiked = false; } } var setQuery = from key in db.Terms where key.TermID == output select key; foreach (Term key in setQuery) { if (key.IsLiked == false || key.IsLiked == null) { key.IsLiked = true; } } db.SaveChanges(); int tempfav = term.ctr++; int tempTerm = term.userInput1; string tempId = term.aspId; List <string> wordArr1 = new List <string> { }; var checkFav = from key in db.Favorites select key.TermID.ToString(); wordArr1.AddRange(checkFav); var tempInput = term.output.ToString(); if (wordArr1.Contains(tempInput) == true) { term.isFav = true; } else { term.isFav = false; } if (term.isFav == false) { Favorite fav = new Favorite { FavoriteID = tempfav, TermID = tempTerm, Id = tempId }; db.Favorites.Add(fav); db.SaveChanges(); } return(new JsonResult() { Data = JsonConvert.SerializeObject(output2), JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }