public int DeletarDocumento(ModeloDocumentoDTO entrada)
{
this.CreateTextCommand("delete from modelo_documento where id = @in_id");
this.AddInParameter("@in_id", (object)entrada.Id ?? DBNull.Value, DbType.Int32);
this.ExecuteNonQuery();
return(0);
}
public int SalvarDocumento(ModeloDocumentoDTO entrada)
{
this.CreateTextCommand("insert into modelo_documento (id, nome, html, id_categoria) values (@in_id, @in_nome, @in_html, @id_categoria) ON DUPLICATE KEY UPDATE nome=@in_nome, html=@in_html, id_categoria=@id_categoria; select LAST_INSERT_ID();");
this.AddInParameter("@in_id", (object)entrada.Id ?? DBNull.Value, DbType.Int32);
this.AddInParameter("@in_nome", entrada.Nome, DbType.String);
this.AddInParameter("@in_html", entrada.Html, DbType.String);
this.AddInParameter("@id_categoria", (object)entrada.Categoria ?? DBNull.Value, DbType.Int32);
return(Convert.ToInt32(this.ExecuteScalar()));
}
