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