public static int AddBadword(string badword, string replace)
{
IBadWordFilter dal = Factory<IBadWordFilter>.Create("BadWordFilter");
BadwordInfo bw = new BadwordInfo();
bw.Badword = badword;
bw.Replace = replace;
return dal.Add(bw);
}
public int Add(BadwordInfo badword)
{
string strSql = "INSERT INTO " + Config.FilterTablePrefix + "BADWORDS (B_BADWORD,B_REPLACE) VALUES (@Badword,@Replaceword)";
List<OleDbParameter> parms = new List<OleDbParameter>
{
new OleDbParameter("@Badword", OleDbType.VarChar) {Value = badword.Badword},
new OleDbParameter("@Replaceword", OleDbType.VarChar) {Value = badword.Replace}
};
return Convert.ToInt32(SqlHelper.ExecuteInsertQuery(SqlHelper.ConnString, CommandType.Text, SELECT + strSql, parms.ToArray()));
}
public int Add(BadwordInfo badword)
{
string strSql = "INSERT INTO " + Config.FilterTablePrefix + "BADWORDS (B_BADWORD,B_REPLACE) VALUES (@Badword,@Replaceword); SELECT SCOPE_IDENTITY();";
List<SqlParameter> parms = new List<SqlParameter>
{
new SqlParameter("@Badword", SqlDbType.NVarChar) {Value = badword.Badword},
new SqlParameter("@Replaceword", SqlDbType.NVarChar) {Value = badword.Replace}
};
return Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.ConnString, CommandType.Text, SELECT + strSql, parms.ToArray()));
}
public BadwordInfo GetById(int id)
{
BadwordInfo badword = null;
using (OleDbDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnString, CommandType.Text, SELECT + "WHERE B_ID=@BadwordId", new OleDbParameter("@BadwordId", OleDbType.Numeric) { Value = id }))
{
while (rdr.Read())
{
badword = new BadwordInfo { Id = rdr.GetInt32(0), Badword = rdr.SafeGetString(1), Replace = rdr.SafeGetString(2) };
}
}
return badword;
}
public void Update(BadwordInfo badword)
{
string strSql = "UPDATE " + Config.FilterTablePrefix + "BADWORDS SET B_BADWORD=@Badword,B_REPLACE=@Replaceword WHERE B_ID=@BadwordId";
List<OleDbParameter> parms = new List<OleDbParameter>
{
new OleDbParameter("@BadwordId", OleDbType.Numeric) {Value = badword.Id},
new OleDbParameter("@Badword", OleDbType.VarChar) {Value = badword.Badword},
new OleDbParameter("@Replaceword", OleDbType.VarChar) {Value = badword.Replace}
};
SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, parms.ToArray());
}
public void Delete(BadwordInfo badword)
{
SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, "DELETE FROM " + Config.FilterTablePrefix + "BADWORDS WHERE B_ID=@BadwordId", new OleDbParameter("@BadwordId", OleDbType.Numeric) { Value = badword.Id });
}
