private void RemoverMercadoFinanceiro()
{
Console.WriteLine("Insert Unique Code of Mercado Financeiro to REMOVE");
int cod = Int32.Parse(Console.ReadLine());
IEnumerable regs = from mer in dbContext.RegDiaMerFin
where mer.cod_un == cod
select mer;
foreach (RegDiaMerFin reg in regs)
{
dbContext.RegDiaMerFin.Remove(reg);
}
MerFin merFin = (from mer in dbContext.MerFin
where mer.cod_un == cod
select mer).FirstOrDefault();
if (merFin != null)
{
dbContext.MerFin.Remove(merFin);
if (dbContext.SaveChanges() > 0)
{
Console.WriteLine("SUCCESS");
}
else
{
Console.WriteLine("UNSUCCESS");
}
}
else
{
Console.WriteLine("No elements to be removed");
}
}
private void InserirMercadoFinanceiro()
{
MerFin merFin = dbContext.MerFin.Create();
Console.WriteLine("Insert Unique Code of Mercado Financeiro");
merFin.cod_un = Int32.Parse(Console.ReadLine());
Console.WriteLine("Insert Name of Mercado Financeiro");
merFin.nome = Console.ReadLine();
Console.WriteLine("Insert Description of Mercado Financeiro");
merFin.descrição = Console.ReadLine();
dbContext.MerFin.Add(merFin);
if (dbContext.SaveChanges() > 0)
{
Console.WriteLine("SUCCESS");
}
else
{
Console.WriteLine("UNSUCCESS");
}
}
private void AtualizarMercadoFinanceiro()
{
Console.WriteLine("Insert Unique Code of Mercado Financeiro to Update");
int cod = Int32.Parse(Console.ReadLine());
MerFin merFin = (from mer in dbContext.MerFin
where mer.cod_un == cod
select mer).FirstOrDefault();
if (merFin != null)
{
string src = "";
Console.WriteLine("Do you want to update the name of Mercado Financeiro?(Y/N)");
src = Console.ReadLine();
if (src.ToUpper().Contains("Y"))
{
Console.WriteLine("Insert the new name");
merFin.nome = Console.ReadLine();
}
Console.WriteLine("Do you want to update the description of Mercado Financeiro?(Y/N)");
src = Console.ReadLine();
if (src.ToUpper().Contains("Y"))
{
Console.WriteLine("Insert the new description");
merFin.descrição = Console.ReadLine();
}
if (dbContext.SaveChanges() > 0)
{
Console.WriteLine("SUCCESS");
}
else
{
Console.WriteLine("UNSUCCESS");
}
}
else
{
Console.WriteLine("Invalid Unique Code");
}
}
