public static void ExcludeRelation()
{
Console.Clear();
PlanStakeholderDAO psk = new PlanStakeholderDAO();
planStakeList = psk.getRelations();
Console.WriteLine("\nEscolha qual relacao deseja remover: ");
foreach (var item in planStakeList)
{
Console.WriteLine(item);
}
Console.WriteLine("0-Cancelar");
int stakeId = Int32.Parse(Console.ReadLine());
if (stakeId == 0)
{
Console.WriteLine("OPERACAO CANCELADA!");
SubmenuStake();
return;
}
Console.Clear();
psk.exclude(stakeId);
SubmenuStake();
}
public static void ReadByUser()
{
Console.Clear();
UserDAO userDAO = new UserDAO();
PlanStakeholderDAO psk = new PlanStakeholderDAO();
userList = userDAO.getUser();
Console.WriteLine("\nEscolha o usuario: ");
foreach (var item in userList)
{
Console.WriteLine(item.Id + "-" + item.Name);
}
Console.WriteLine("0-Cancelar");
int userId = Int32.Parse(Console.ReadLine());
if (userId == 0)
{
Console.WriteLine("OPERACAO CANCELADA!");
SubmenuStake();
return;
}
Console.Clear();
planStakeList = psk.getByUserId(userId);
foreach (var item in planStakeList)
{
Console.WriteLine("\n" + item);
}
SubmenuStake();
}
public static void ReadByPlan()
{
Console.Clear();
PlanDAO planDAO = new PlanDAO();
PlanStakeholderDAO psk = new PlanStakeholderDAO();
planList = planDAO.getPlans();
Console.WriteLine("\nEscolha o plano: ");
foreach (var item in planList)
{
Console.WriteLine(item.Id + "-" + item.Name);
}
Console.WriteLine("0-Cancelar");
int planId = Int32.Parse(Console.ReadLine());
if (planId == 0)
{
Console.WriteLine("OPERACAO CANCELADA!");
SubmenuStake();
return;
}
Console.Clear();
planStakeList = psk.getByPlanId(planId);
foreach (var item in planStakeList)
{
Console.WriteLine("\n" + item);
}
SubmenuStake();
}
public static void ReadRelations()
{
Console.Clear();
PlanStakeholderDAO psk = new PlanStakeholderDAO();
Console.WriteLine("\nRelacoes de planos e interessados");
planStakeList = psk.getRelations();
foreach (var item in planStakeList)
{
Console.WriteLine(item);
}
SubmenuStake();
}
public static void InsertRelation()
{
Console.Clear();
PlanDAO planDAO = new PlanDAO();
UserDAO userDAO = new UserDAO();
PlanStakeholderDAO psk = new PlanStakeholderDAO();
planList = planDAO.getPlans();
userList = userDAO.getUser();
Console.WriteLine("\nEscolha o plano a ser relacionado: ");
foreach (var item in planList)
{
Console.WriteLine(item.Id + "-" + item.Name);
}
int planId = Int32.Parse(Console.ReadLine());
Console.Clear();
Console.WriteLine("\nEscolha o usuario interessado no plano: ");
foreach (var item in userList)
{
Console.WriteLine(item.Id + "-" + item.Name);
}
int userId = Int32.Parse(Console.ReadLine());
Console.Clear();
PlanStakeholder ps = new PlanStakeholder(0, planDAO.getOnePlan(planId), userDAO.getResponsible(userId));
Console.WriteLine("\nConfirme seus dados: ");
Console.WriteLine(ps);
Console.WriteLine("\n1-Sim\n2-Nao");
int confirm = Int32.Parse(Console.ReadLine());
if (confirm == 1)
{
psk.insert(ps);
}
else
{
Console.WriteLine("\nOperacao cancelada!");
}
SubmenuStake();
}
