public ActionResult ForbiddenWords(ForbiddenWordViewModel model)
{
var words = unitOfWork.Repository <ForbiddenWord>().GetAll();
foreach (var x in words)
{
if (x.Word == model.word)
{
model.forbiddenWords = words;
ModelState.AddModelError("duplicate", "Given word is already in the list");
return(View("ForbiddenWords", model));
}
}
if (ModelState.IsValid)
{
var word = new ForbiddenWord()
{
Word = model.word,
};
unitOfWork.Repository <ForbiddenWord>().Add(word);
unitOfWork.Complete();
}
return(RedirectToAction("ForbiddenWords", model));
}
public bool InsertForbiddenWord(ForbiddenWord forbiddenWord)
{
stopwatch.Start();
try
{
string queryAddMotInterdit = nameBdd.insertForbiddenWord(forbiddenWord.word);
if (this.OpenConnection() == true)
{
MySqlCommand cmd = new MySqlCommand(queryAddMotInterdit, connection);
cmd.ExecuteNonQuery();
this.CloseConnection();
stopwatch.Stop();
log.Info("api.CONFIGURATION.InsertForbiddenWord ... (" + stopwatch.Elapsed.TotalSeconds + " ms)");
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
log.Error(ex);
return(false);
}
}
public ActionResult DeleteConfirmed(int id)
{
ForbiddenWord forbiddenWord = db.ForbiddenWords.Find(id);
db.ForbiddenWords.Remove(forbiddenWord);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void AddForbiddenWord(ForbiddenWord forbiddenWord)
{
if (ForbiddenWords == null)
{
ForbiddenWords = new List <ForbiddenWord>();
}
ForbiddenWords.Add(forbiddenWord);
}
public ActionResult Edit([Bind(Include = "ForbiddenWordID,Name")] ForbiddenWord forbiddenWord)
{
if (ModelState.IsValid)
{
db.Entry(forbiddenWord).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(forbiddenWord));
}
public ActionResult Create([Bind(Include = "ForbiddenWordID,Name")] ForbiddenWord forbiddenWord)
{
if (ModelState.IsValid)
{
db.ForbiddenWords.Add(forbiddenWord);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(forbiddenWord));
}
// GET: ForbiddenWords/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ForbiddenWord forbiddenWord = db.ForbiddenWords.Find(id);
if (forbiddenWord == null)
{
return(HttpNotFound());
}
return(View(forbiddenWord));
}
public void SeedForbidden()
{
if (!_dbContext.ForbiddenWords.Any())
{
var filePath = "Files/russian_bad_words.txt";
var words = File.ReadAllLines(filePath);
foreach (var word in words)
{
ForbiddenWord w = new ForbiddenWord();
w.Word = word;
_dbContext.ForbiddenWords.Add(w);
}
_dbContext.SaveChanges();
}
}
public WordViewModel()
{
CurrentWord = new ForbiddenWord();
}
