public void AddWords(UpdateWordRequest request) { var query = @" INSERT INTO Word (Word, CreatedBy) VALUES (@Word,@CreatedBy)"; var existed = GetAllWords() .Select(l => l.Text).ToList(); var wordsToBeSaved = request.Words .Where(l => !existed.Contains(l, StringComparer.OrdinalIgnoreCase)) .ToList(); foreach (var item in wordsToBeSaved) { var parameters = new List<SQLiteParameter>(); parameters.Add(new SQLiteParameter("Word", item)); parameters.Add(new SQLiteParameter("CreatedBy", request.CreatedBy)); try { SQLiteHelper.ExecuteNonQuery(query, parameters.ToArray()); } catch (SQLiteException) { } } }
public void Expire(UpdateWordRequest request) { var query = @" UPDATE Word SET IsExpired = 1, ExpiredAt = CURRENT_TIMESTAMP WHERE Word=@Word"; foreach (var item in request.Words) { var parameters = new List<SQLiteParameter>(); parameters.Add(new SQLiteParameter("Word", item)); try { SQLiteHelper.ExecuteNonQuery(query, parameters.ToArray()); } catch (SQLiteException) { } } }
public HttpResponseMessage Expire(UpdateWordRequest request) { var engine = new WordEngine(); engine.Expire(request); return Request.CreateResponse(HttpStatusCode.Created); }