public void Atualizar(Convenio c, int CodigoClinica)
{
using (FbConnection Con = new FbConnection(Firebird.StringConexao))
{
try
{
Con.Open();
string TxtSQL = @" UPDATE
CONVENIO
SET
C_DESCRICAO =@C_DESCRICAO,
C_STATUS =@C_STATUS
WHERE
C_CODIGO =@C_CODIGO AND
C_CLINICA =@C_CLINICA";
using (FbCommand cmdUpdate = new FbCommand(TxtSQL, Con))
{
cmdUpdate.Parameters.AddWithValue("C_DESCRICAO", c.Descricao);
cmdUpdate.Parameters.AddWithValue("C_STATUS", c.Status);
cmdUpdate.Parameters.AddWithValue("C_CODIGO", c.Codigo);
cmdUpdate.Parameters.AddWithValue("C_CLINICA", CodigoClinica);
cmdUpdate.ExecuteNonQuery();
}
}
finally
{
Con.Close();
}
}
}
public void Cadastrar(Convenio c, int CodigoClinica)
{
using (FbConnection Con = new FbConnection(Firebird.StringConexao))
{
try
{
Con.Open();
string TxtSQL = @" INSERT
INTO
CONVENIO
(
C_CODIGO,
C_DESCRICAO,
C_STATUS,
C_CLINICA
)
VALUES
(
@C_CODIGO,
@C_DESCRICAO,
@C_STATUS,
@C_CLINICA
)";
using (FbCommand cmdInsert = new FbCommand(TxtSQL, Con))
{
cmdInsert.Parameters.AddWithValue("C_CODIGO", GerarCodigo());
cmdInsert.Parameters.AddWithValue("C_CLINICA", CodigoClinica);
cmdInsert.Parameters.AddWithValue("C_DESCRICAO", c.Descricao);
cmdInsert.Parameters.AddWithValue("C_STATUS", "A");
cmdInsert.ExecuteNonQuery();
}
}
finally
{
Con.Close();
}
}
}