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
});
}
