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