public void Cadastrar(Clinica c)
{
using (FbConnection Con = new FbConnection(Firebird.StringConexao))
{
try
{
Con.Open();
string TxtSQL = @" INSERT
INTO
CLINICACONTRATO
(
CC_CODIGO,
CC_NOME,
CC_STATUS,
CC_TELEFONE
)
VALUES
(
@CC_CODIGO,
@CC_NOME,
@CC_STATUS,
@CC_TELEFONE
)";
using (FbCommand cmdInsert = new FbCommand(TxtSQL, Con))
{
this.Codigo = GerarCodigo();
cmdInsert.Parameters.AddWithValue("CC_CODIGO", this.Codigo);
cmdInsert.Parameters.AddWithValue("CC_NOME", c.Nome);
cmdInsert.Parameters.AddWithValue("CC_STATUS", "A");
cmdInsert.Parameters.AddWithValue("CC_TELEFONE", c.Telefone);
cmdInsert.ExecuteNonQuery();
}
}
finally
{
Con.Close();
}
}
}