public void Delete()
{
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString)) {
SqlTransaction transaction;
cn.Open();
transaction = cn.BeginTransaction();
try {
SqlCommand cmd = new SqlCommand("DELETE FROM cms_DocumentLink WHERE DocumentSerial = @DocumentSerial", cn, transaction);
cmd.Parameters.Add("@DocumentSerial", SqlDbType.Int).Value = _DocumentSerial;
cmd.ExecuteNonQuery();
cmd.CommandText = "DELETE FROM cms_Document WHERE DocumentSerial = @DocumentSerial";
cmd.ExecuteNonQuery();
transaction.Commit();
} catch (SqlException sqlError) {
transaction.Rollback();
Elmah.ErrorLog.GetDefault(HttpContext.Current).Log(new Elmah.Error(sqlError));
}
cn.Close();
}
// Remove from Lucene search index
Indexer.LuceneIndexer li = new Indexer.LuceneIndexer();
li.CreateIndexWriter();
li.Delete(DocumentID.ToString());
li.Close();
}
public void Delete()
{
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString)) {
using (SqlCommand cmd = new SqlCommand("DELETE FROM cms_News WHERE NewsSerial = @NewsSerial", cn)) {
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@NewsSerial", SqlDbType.Int).Value = _NewsSerial;
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
}
// Remove from Lucene search index
Indexer.LuceneIndexer li = new Indexer.LuceneIndexer();
li.CreateIndexWriter();
li.Delete(NewsID.ToString());
li.Close();
}