public void insert(PlanStakeholder p)
{
string connectionString = "Data Source=FORLOGIC357;Initial Catalog=PLANNER;Integrated Security=True";
string sqlQuery = "INSERT INTO plan_interested_user VALUES (@idPlan, @idUser)";
using (SqlConnection connection =
new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(sqlQuery, connection);
command.Parameters.AddWithValue("@idPlan", p.Plan.Id);
command.Parameters.AddWithValue("@idUser", p.User.Id);
try
{
connection.Open();
command.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
connection.Close();
}
}
}
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();
}
public IList <PlanStakeholder> getByPlanId(int id)
{
string connectionString = "Data Source=FORLOGIC357;Initial Catalog=PLANNER;" +
"Integrated Security=True";
string sqlQuery = "SELECT * FROM plan_interested_user WHERE id_plan = @id";
PlanStakeholder psk = null;
UserDAO userDAO = new UserDAO();
PlanDAO planDAO = new PlanDAO();
using (SqlConnection connection =
new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(sqlQuery, connection);
command.Parameters.AddWithValue("@id", id);
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
psk = new PlanStakeholder((int)reader[0], planDAO.getOnePlan((int)reader[1]), userDAO.getResponsible((int)reader[2]));
planStakeList.Add(psk);
}
reader.Close();
return(this.planStakeList);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(this.planStakeList);
}
finally
{
connection.Close();
}
}
}
