public IActionResult AddBadWord(BadWord badWord)
{
dataContext.BadWords.Add(badWord);
dataContext.SaveChanges();
return(RedirectToAction("ViewBadWords"));
}
public virtual BadWord InsertBadWord(BadWord entity)
{
BadWord other = new BadWord();
other = entity;
if (entity.IsTransient())
{
string sql = @"Insert into BadWord ( [LocaleSetting]
,[Word]
,[CreatedOn] )
Values
( @LocaleSetting
, @Word
, @CreatedOn );
Select scope_identity()" ;
SqlParameter[] parameterArray = new SqlParameter[] {
new SqlParameter("@BadWordID", entity.BadWordId)
, new SqlParameter("@LocaleSetting", entity.LocaleSetting)
, new SqlParameter("@Word", entity.Word)
, new SqlParameter("@CreatedOn", entity.CreatedOn)
};
var identity = SqlHelper.ExecuteScalar(this.ConnectionString, CommandType.Text, sql, parameterArray);
if (identity == DBNull.Value)
{
throw new DataException("Identity column was null as a result of the insert operation.");
}
return(GetBadWord(Convert.ToInt32(identity)));
}
return(entity);
}
public static bool BanWord(
string telegramGroup,
string name,
string text)
{
List <string> parts = new List <string>();
string[] words = text.Split(" ");
string regex = "";
foreach (string word in words)
{
string part = BuildRegex(word);
part += ".*";
parts.Add(part);
regex += part;
}
regex += "|";
parts.Reverse();
foreach (string part in parts)
{
regex += part;
}
regex = regex.Remove(regex.Length - 2, 2); // remove last .*
BadWord badWord = bwl.Add(telegramGroup, name, regex, BadWord.State.Active, -2);
CacheData.BadWords = bwl.Get();
return(badWord == null ? false : true);
}
public IActionResult AddBadWordTOList(BadWord badword)
{
_assignment1DataContext.BadWords.Add(badword);
_assignment1DataContext.SaveChanges();
return(RedirectToAction("ViewBadWords"));
}
public IHttpActionResult PutBadWord(int id, BadWord badWord)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != badWord.ID)
{
return(BadRequest());
}
db.Entry(badWord).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!BadWordExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task RemoveBadWord(string word)
{
BadWordList badWordsClass = Context.Guild.LoadFromFile <BadWordList>(true);
if (badWordsClass == null)
{
await ReplyAsync("Bad words is null");
return;
}
BadWord badToRemove = null;
foreach (BadWord badWord in badWordsClass.badWords)
{
if (badWord.word == word)
{
badToRemove = badWord;
}
}
if (badToRemove != null)
{
badWordsClass.badWords.Remove(badToRemove);
badWordsClass.SaveToFile(Context.Guild);
await ReplyAsync("removed " + word + " from bad word list");
}
else
{
await ReplyAsync("Bad word list doesn't contain " + word);
}
}
public virtual BadWord UpdateBadWord(BadWord entity)
{
if (entity.IsTransient())
{
return(entity);
}
BadWord other = GetBadWord(entity.BadWordId);
if (entity.Equals(other))
{
return(entity);
}
string sql = @"Update BadWord set [LocaleSetting]=@LocaleSetting
, [Word]=@Word
, [CreatedOn]=@CreatedOn
where BadWordID=@BadWordID" ;
SqlParameter[] parameterArray = new SqlParameter[] {
new SqlParameter("@BadWordID", entity.BadWordId)
, new SqlParameter("@LocaleSetting", entity.LocaleSetting)
, new SqlParameter("@Word", entity.Word)
, new SqlParameter("@CreatedOn", entity.CreatedOn)
};
SqlHelper.ExecuteNonQuery(this.ConnectionString, CommandType.Text, sql, parameterArray);
return(GetBadWord(entity.BadWordId));
}
public int Add(BadWord word)
{
if (!_library.BadWords.Exists(x => x.Value.ToLower() == word.Value.ToLower()))
{
_library.BadWords.Add(word);
}
return(_library.BadWords.Count);
}
public async Task RemoveBadWord(string word)
{
if (!((SocketGuildUser)Context.User).HasAdmin())
{
await ReplyAsync("You do have administrator permissions");
return;
}
ModerationFunctions.CheckDirectories(Context.Guild);
List <BadWord> badWords;
JsonSerializer serializer = new JsonSerializer();
serializer.NullValueHandling = NullValueHandling.Ignore;
if (!File.Exists("/home/bob_the_daniel/Data/" + Context.Guild.OwnerId + "/badwords.json"))
{
await ReplyAsync("No bad words file found");
return;
}
using (StreamReader sr = new StreamReader(@"/home/bob_the_daniel/Data/" + Context.Guild.OwnerId + "/badwords.json"))
using (JsonTextReader reader = new JsonTextReader(sr)) {
badWords = serializer.Deserialize <List <BadWord> >(reader);
}
if (badWords == null)
{
await ReplyAsync("Bad words is null");
return;
}
BadWord badToRemove = null;
foreach (BadWord badWord in badWords)
{
if (badWord.word == word)
{
badToRemove = badWord;
}
}
if (badToRemove != null)
{
badWords.Remove(badToRemove);
using (StreamWriter sw = new StreamWriter(@"/home/bob_the_daniel/Data/" + Context.Guild.OwnerId + "/badwords.json"))
using (JsonTextWriter writer = new JsonTextWriter(sw)) {
serializer.Serialize(sw, badWords);
}
await ReplyAsync("removed " + word + " from bad word list");
}
else
{
await ReplyAsync("Bad word list doesn't contain " + word);
}
}
public IActionResult SubmitBadWords(string word)
{
BadWord badWord = new BadWord();
badWord.Word = word;
_dataContext.BadWords.Add(badWord);
_dataContext.SaveChanges();
return(RedirectToAction("ViewBadWords"));
}
protected void SubmitInfo(object sender, EventArgs e)
{
var badWord = new BadWord();
badWord.Word = badWordText.Text;
db.BadWords.Add(badWord);
db.SaveChanges();
Response.Redirect("./BadWords.aspx");
}
public BadWordTests()
{
_badWord = new BadWord()
{
Id = 1,
DateAdded = new DateTime(2016, 1, 1),
ObjectState = ObjectState.Unchanged,
Phrase = "panty"
};
}
public void WordPropertyToReturnBad()
{
const string expectedWord = "Bad";
var badWord = new BadWord {
Value = "Bad"
};
Assert.AreEqual(expectedWord, badWord.Value);
}
public void Add_should_be_able_to_add_bad_word()
{
var badWord = new BadWord {
Expression = "F**k"
};
repository.Add(badWord);
Assert.True(badWord.Id >= 0);
}
public async Task AddBadWord(string word, string euphemism = null, float size = 0.5f)
{
BadWord badWord = new BadWord(word, euphemism, size);
BadWordList badWordsClass = Context.Guild.LoadFromFile <BadWordList>(true);
badWordsClass.badWords.Add(badWord);
badWordsClass.SaveToFile();
await ReplyAsync($"Added {badWord.Word}{((badWord.Euphemism != null) ? $", also known as {badWord.Euphemism}" : "")} to bad word list");
}
public IHttpActionResult GetBadWord(string word)
{
BadWord badWord = db.BadWord.Find(word);
if (badWord == null)
{
return(NotFound());
}
return(Ok(badWord));
}
public void AddsAndCountIsOne()
{
const int expectedCount = 1;
var newWord = new BadWord {
Value = "Bad"
};
var actualCount = _badWordRepository.Add(newWord);
Assert.AreEqual(expectedCount, actualCount);
}
public void AddsShouldNotAddExistingWord()
{
var newWord = new BadWord {
Value = "Bad"
};
var expectedCount = _badWordRepository.Add(newWord);
var actualCount = _badWordRepository.Add(newWord);
Assert.AreEqual(expectedCount, actualCount);
}
public IActionResult AddBadWordToDatabase()
{
BadWord badWordToAdd = new BadWord();
badWordToAdd.Word = HttpContext.Request.Form["badword"];
_context.BadWords.Add(badWordToAdd);
_context.SaveChanges();
return(RedirectToAction("ViewBadWords"));
}
public void IsMatching_should_return_correct_value(string badword, string expression, bool expected)
{
var badWord = new BadWord {
Expression = badword
};
repository.Add(badWord);
bool ismatched = repository.IsMatching(expression);
Assert.Equal(expected, ismatched);
}
public void Delete_should_be_able_to_delete_bad_word()
{
var badWord = new BadWord {
Expression = "F**k"
};
repository.Add(badWord);
repository.Delete(badWord);
Assert.False(Database.BadWords.Any(b => b.Id == badWord.Id));
}
public IHttpActionResult PostBadWord(BadWord badWord)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.BadWord.Add(badWord);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = badWord.ID }, badWord));
}
public int Remove(BadWord word)
{
var foundWord = _library.BadWords.FirstOrDefault(x => x.Value.ToLower() == word.Value.ToLower());
if (foundWord == null)
{
return(-1);
}
_library.BadWords.Remove(foundWord);
return(_library.BadWords.Count);
}
public IActionResult AddBadWord()
{
var word = Request.Form["bad"];
var badWord = new BadWord();
badWord.Word = word;
_blogContext.BadWords.Add(badWord);
_blogContext.SaveChanges();
return(RedirectToAction("ViewBadWords"));
}
public ActionResult Create(BadWord badWord)
{
using (Soc_NetWorkCF db = new Soc_NetWorkCF()) //создаем подключение
{
if (ModelState.IsValid) // провекра на валидность
{
db.BadWord.Add(badWord); // добавить слово
db.SaveChanges(); // сохраним изменинеия
return(RedirectToAction("Index"));
}
return(View(badWord));
}
}
public ActionResult Edit([Bind(Include = "ID,word")] BadWord badWord)
{
using (Soc_NetWorkCF db = new Soc_NetWorkCF())
{
if (ModelState.IsValid)
{
db.Entry(badWord).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(badWord));
}
}
public virtual BadWord BadWordFromDataRow(DataRow dr)
{
if (dr == null)
{
return(null);
}
BadWord entity = new BadWord();
entity.BadWordId = (System.Int32)dr["BadWordID"];
entity.LocaleSetting = dr["LocaleSetting"].ToString();
entity.Word = dr["Word"].ToString();
entity.CreatedOn = (System.DateTime)dr["CreatedOn"];
return(entity);
}
public IHttpActionResult DeleteBadWord(int id)
{
BadWord badWord = db.BadWord.Find(id);
if (badWord == null)
{
return(NotFound());
}
db.BadWord.Remove(badWord);
db.SaveChanges();
return(Ok(badWord));
}
public BadWord Update(BadWord badWord, int callerId)
{
using (UBContext ubc = new UBContext())
{
BadWord exists = ubc.BadWords
.Where(x => x.BadWordId == badWord.BadWordId)
.FirstOrDefault();
if (exists == null)
{
return(null);
}
try
{
exists.Name = badWord.Name;
exists.GroupId = badWord.GroupId;
exists.Regex = badWord.Regex;
exists.Status = badWord.Status;
exists.Match = badWord.Match;
ubc.SaveChanges();
return(badWord);
}
catch (Exception ex)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban",
Date = DateTime.Now,
Function = "Unifiedban.Data.BadWordService.Update",
Level = SystemLog.Levels.Warn,
Message = ex.Message,
UserId = callerId
});
if (ex.InnerException != null)
{
Utils.Logging.AddLog(new SystemLog()
{
LoggerName = "Unifiedban.Data",
Date = DateTime.Now,
Function = "Unifiedban.Data.BadWordService.Update",
Level = SystemLog.Levels.Warn,
Message = ex.InnerException.Message,
UserId = callerId
});
}
}
return(null);
}
}
public async Task AddBadWord(string word, string euphemism = null, float size = 0.5f)
{
if (!((SocketGuildUser)Context.User).HasAdmin())
{
await ReplyAsync("You do have administrator permissions");
return;
}
ModerationFunctions.CheckDirectories(Context.Guild);
BadWord badWord = new BadWord();
badWord.word = word;
badWord.euphemism = euphemism;
badWord.size = size;
List <BadWord> badWords;
JsonSerializer serializer = new JsonSerializer();
serializer.NullValueHandling = NullValueHandling.Ignore;
/*if (!File.Exists("/home/bob_the_daniel/Data/" + Context.Guild.OwnerId + "/badwords.json")) {
* File.Create("/home/bob_the_daniel/Data/" + Context.Guild.OwnerId + "/badwords.json");
* }*/
using (StreamReader sr = new StreamReader(@"/home/bob_the_daniel/Data/" + Context.Guild.OwnerId + "/badwords.json"))
using (JsonTextReader reader = new JsonTextReader(sr)) {
badWords = serializer.Deserialize <List <BadWord> >(reader);
}
if (badWords == null)
{
badWords = new List <BadWord>();
}
badWords.Add(badWord);
using (StreamWriter sw = new StreamWriter(@"/home/bob_the_daniel/Data/" + Context.Guild.OwnerId + "/badwords.json"))
using (JsonTextWriter writer = new JsonTextWriter(sw)) {
serializer.Serialize(sw, badWords);
}
if (euphemism != null)
{
await ReplyAsync("added " + badWord.word + " also known as " + euphemism + " to bad word list");
}
else
{
await ReplyAsync("added " + badWord.word + " to bad word list");
}
}
public void AddToBadWord(BadWord badWord)
{
base.AddObject("BadWord", badWord);
}
public static BadWord CreateBadWord(int id)
{
BadWord badWord = new BadWord();
badWord.ID = id;
return badWord;
}
