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
});
}
public static void DeleteBadword(int Id)
{
IBadWordFilter dal = Factory <IBadWordFilter> .Create("BadWordFilter");
BadwordInfo badword = dal.GetById(Id);
dal.Delete(badword);
}
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 static void UpdateBadword(int Id, string badword, string replace)
{
IBadWordFilter dal = Factory <IBadWordFilter> .Create("BadWordFilter");
BadwordInfo bw = dal.GetById(Id);
bw.Badword = badword;
bw.Replace = replace;
dal.Update(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());
}
