static public void Save(Library.Notificacao Notificacao)
{
NpgsqlConnection conexao = null;
try
{
long id = GetNextId();
conexao = new NpgsqlConnection(global::Connection.Connection.StringPostgree());
using (NpgsqlCommand comando = conexao.CreateCommand())
{
comando.CommandText = "INSERT INTO \"Notificacao\" (idTermoCompromisso, texto, data, isJudicial) VALUES (@idTermoCompromisso, @texto, @data, @isJudicial)";
comando.Parameters.AddWithValue("@idTermoCompromisso", Notificacao.TermoCompromisso.Id);
comando.Parameters.AddWithValue("@texto", Notificacao.Texto);
comando.Parameters.AddWithValue("@data", Notificacao.Data);
if (Notificacao.isJudicial)
{
comando.Parameters.AddWithValue("@isJudicial", 1);
}
else
{
comando.Parameters.AddWithValue("@isJudicial", 0);
}
conexao.Open();
Notificacao.Id = id;
comando.ExecuteNonQuery();
}
}
catch (Exception ex)
{
Library.Classes.Logger.Error(ex);;
}
finally
{
if (conexao != null)
{
conexao.Close();
}
}
}
static public void Update(Library.Notificacao Notificacao)
{
NpgsqlConnection conexao = null;
try
{
conexao = new NpgsqlConnection(global::Connection.Connection.StringPostgree());
using (NpgsqlCommand comando = conexao.CreateCommand())
{
comando.CommandText = "UPDATE \"Notificacao\" SET idTermoCompromisso = @idTermoCompromisso, texto = @texto, data = @data, isJudicial = @isJudicial WHERE (id= " + Notificacao.Id + ")";
comando.Parameters.AddWithValue("@idTermoCompromisso", Notificacao.TermoCompromisso.Id);
comando.Parameters.AddWithValue("@texto", Notificacao.Texto);
comando.Parameters.AddWithValue("@data", Notificacao.Data);
if (Notificacao.isJudicial)
{
comando.Parameters.AddWithValue("@isJudicial", 1);
}
else
{
comando.Parameters.AddWithValue("@isJudicial", 0);
}
conexao.Open();
comando.ExecuteNonQuery();
}
}
catch (Exception ex)
{
Library.Classes.Logger.Error(ex);;
}
finally
{
if (conexao != null)
{
conexao.Close();
}
}
}
