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())); }