public MensagensTemplate BuscarTemplate(int id) { try { MensagensTemplate template = null; DBSession session = new DBSession(); Query quey = session.CreateQuery("SELECT * FROM mailing_templates WHERE idtemplate = @id"); quey.SetParameter("id", id); IDataReader reader = quey.ExecuteQuery(); if (reader.Read()) { template = new MensagensTemplate(Convert.ToInt32(reader["idtemplate"]), Convert.ToString(reader["txtemplate"]), Convert.ToString(reader["txhtml"]), Convert.ToBoolean(reader["flpadrao"]), Convert.ToString(reader["txjson"])); } reader.Close(); session.Close(); return(template); } catch (Exception error) { throw error; } }
public void AlterarTemplate(MensagensTemplate variavel) { try { DBSession session = new DBSession(); Query query = session.CreateQuery("UPDATE mailing_templates set txtemplate = @template, txhtml = @html, txjson = @json WHERE idtemplate = @ident "); query.SetParameter("ident", variavel.idtemplate) .SetParameter("template", variavel.txtemplate) .SetParameter("html", variavel.txhtml) .SetParameter("json", variavel.txjson); query.ExecuteUpdate(); session.Close(); } catch (Exception error) { throw error; } }
public void SalvarTemplate(MensagensTemplate variavel) { try { DBSession session = new DBSession(); Query query = session.CreateQuery("INSERT INTO mailing_templates (txtemplate, txhtml, flpadrao, txjson) VALUES (@template, @html, @padrao, @json) "); query.SetParameter("template", variavel.txtemplate) .SetParameter("html", variavel.txhtml) .SetParameter("padrao", variavel.flpadrao) .SetParameter("json", variavel.txjson); query.ExecuteUpdate(); session.Close(); } catch (Exception error) { throw error; } }