public static List <SatoriReview> getSynonims(SatoriReview card, Users user)
{
string searchString = card.definition_text + card.alternateDefinitions;
searchString = searchString.Replace(" ", "");
searchString = searchString.Replace("-", "");
searchString = searchString.Replace("(", "");
searchString = searchString.Replace(")", "");
searchString = searchString.Replace("'", "");
List <string> searchItems = new List <string>();
searchItems = searchString.Split(';').ToList();
string where = "where userId = " + user.id + " and (";
foreach (string item in searchItems)
{
if (!item.Equals(string.Empty))
{
if (where.EndsWith("and ("))
{
where += " definition like '%" + item + "%' or alternateDefinitions like '%" + item + "%'";
}
else
{
where += " or definition like '%" + item + "%' or alternateDefinitions like '%" + item + "%'";
}
}
}
where += ") and entryId != '" + card.entryId + "'";
return(conn.GetList <SatoriReview>(where).ToList <SatoriReview>());
}
public static void saveCardData(SatoriReview card, Users user)
{
SatoriReview newCard = checkIfCardExists(card, user);
if (newCard != null)
{
card.id = newCard.id;
card.userId = user.id;
conn.Update(card);
}
else
{
card.userId = user.id;
conn.Insert(card);
}
}
public static SatoriReview checkIfCardExists(SatoriReview card, Users user)
{
return(conn.GetList <SatoriReview>("where userId=" + user.id + " and entryId = '" + card.entryId + "'").SingleOrDefault <SatoriReview>());
}
