public int Update(MerFin entity)
{
string query = "Update MerFin set";
SqlParameter[] sqlParameters = new SqlParameter[3];
int idx = 0;
sqlParameters[idx++] = new SqlParameter("@cod_un", entity.cod_un);
if (entity.nome != null)
{
sqlParameters[idx++] = new SqlParameter("@nome", entity.nome);
query += " nome=@nome";
}
if (entity.descrição != null)
{
sqlParameters[idx++] = new SqlParameter("@descrição", entity.descrição);
if (entity.nome != null)
{
query += ",";
}
query += " descrição=@descrição";
}
query += " where cod_un = @cod_un";
return(ConnectionGate.ExecuteCUD(query, sqlParameters));
}
public void Run()
{
Console.WriteLine("\nTesting Connection...");
if (ConnectionGate.TestConnection())
{
Console.WriteLine("Connection SUCCEFUL\nPress any key to continue");
Console.ReadKey();
Option userInput = Option.Unknown;
while (userInput != Option.Exit)
{
Console.Clear();
userInput = DisplayMenu();
Console.Clear();
try {
__methods[userInput]();
}
catch (KeyNotFoundException ex) {
Console.WriteLine("Option unknown. ->" + ex.Message + ". Press any key to continue");
Console.ReadKey();
}
}
}
else
{
Console.WriteLine("Connection UNSUCCEFUL\nPress any key to exit");
Console.ReadKey();
}
}
public int Delete(MerFin entity)
{
string query = "Delete from RegDiaMerFin where cod_un=@cod_un;" +
"Delete from MerFin where cod_un=@cod_un";
SqlParameter p = new SqlParameter("@cod_un", entity.cod_un);
return(ConnectionGate.ExecuteCUD(query, new SqlParameter[] { p }));
}
public int Create(Portfolio entity)
{
string query = "Insert into Portfolio (cc, nome) values (@cc, @nome)";
SqlParameter p1 = new SqlParameter("@cc", entity.cc);
SqlParameter p2 = new SqlParameter("@nome", entity.nome);
return(ConnectionGate.ExecuteCUD(query, new SqlParameter[] { p1, p2 }));
}
public int Create(MerFin entity)
{
string query = "Insert into MerFin (cod_un, descrição, nome) values (@cod_un, @descrição, @nome)";
SqlParameter p1 = new SqlParameter("@cod_un", entity.cod_un);
SqlParameter p2 = new SqlParameter("@nome", entity.nome);
SqlParameter p3 = new SqlParameter("@descrição", entity.descrição);
return(ConnectionGate.ExecuteCUD(query, new SqlParameter[] { p1, p2, p3 }));
}
public int Delete(Portfolio entity)
{
string query = "Delete from Posições where cc=@cc and nome=@nome;" +
"Delete from Portfolio where cc=@cc and nome=@nome";
SqlParameter p1 = new SqlParameter("@cc", entity.cc);
SqlParameter p2 = new SqlParameter("@nome", entity.nome);
return(ConnectionGate.ExecuteCUD(query, new SqlParameter[] { p1, p2 }));
}
private void ApresentarPortfolio()
{
Portfolio portfolio = new Portfolio();
Console.WriteLine("Insert cc of Client");
portfolio.cc = Int32.Parse(Console.ReadLine());
Console.WriteLine("Insert name of Portfolio");
portfolio.nome = Console.ReadLine();
IEnumerable res = ConnectionGate.ExecuteReadLazy("Select * from fListaPortfolio(@ccT,@nomeT)", new SqlParameter[] { new SqlParameter("@ccT", portfolio.cc), new SqlParameter("@nomeT", portfolio.nome) });
PrintResults(res.GetEnumerator());
}
private void AtualizarValoresDiários()
{
int aux = ConnectionGate.ExecuteStoredProcedure("p_actualizaValorDiario", null);
if (aux > 0)
{
Console.WriteLine("The values were updated");
}
else if (aux == 0)
{
Console.WriteLine("There aren't Triples available");
}
}
private void AtualizarDadosFundamentais()
{
string isin = "";
Console.WriteLine("Please enter the ISIN of the instrument or just press enter to update all");
isin = Console.ReadLine();
if (ConnectionGate.ExecuteStoredProcedure("p_actualizaDadosInstrumentos", new SqlParameter[] { new SqlParameter("@isinT", isin) }) >= 0)
{
Console.WriteLine("The values were updated");
}
else
{
Console.WriteLine("The value were NOT updated");
}
}
public PilimMenu()
{
ConnectionGate.SetConnection(getCredentials().GetCredentials());
Method aux = () => {
Console.WriteLine("Press any key to contiue.");
Console.ReadKey();
};
__methods = new Dictionary <Option, Method>();
__methods.Add(Option.Exit, () => {});
__methods.Add(Option.AtualizarValoresDiários, AtualizarValoresDiários + aux);
__methods.Add(Option.AtualizarDadosFundamentais, AtualizarDadosFundamentais + aux);
__methods.Add(Option.CriarPortfolio, CriarPortfolio + aux);
__methods.Add(Option.ApresentarPortfolio, ApresentarPortfolio + aux);
__methods.Add(Option.InserirMercadoFinanceiro, InserirMercadoFinanceiro + aux);
__methods.Add(Option.RemoverMercadoFinanceiro, RemoverMercadoFinanceiro + aux);
__methods.Add(Option.AtualizarMercadoFinanceiro, AtualizarMercadoFinanceiro + aux);
__methods.Add(Option.RemoverPortfolio, RemoverPortfolio + aux);
__array = __methods.Keys.ToArray();
}
