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