public IEnumerable <Planning> QueryPlanningsFromMember(int idUser, bool onlyGranted) { IList <Planning> plannings = new List <Planning>(); IFactory <Planning> _planningFactory = new PlanningFactory(); using (SqlConnection connection = Database.GetConnection()) { connection.Open(); SqlCommand command_1 = connection.CreateCommand(); // si onlyGrated, on ne récupère que les granted users if (onlyGranted) { command_1.CommandText = MemberQueries.ReqQueryPlanningsFromGrantedMember; } else { command_1.CommandText = MemberQueries.ReqQueryPlanningsFromMember; } command_1.Parameters.AddWithValue($"@{MemberQueries.ColIdUser}", idUser); SqlDataReader reader_1 = command_1.ExecuteReader(); while (reader_1.Read()) { plannings.Add(_planningFactory.CreateFromReader(reader_1)); } SqlCommand command_2 = connection.CreateCommand(); command_2.CommandText = PlanningQueries.ReqGetBySuperUser; command_2.Parameters.AddWithValue($"@{PlanningQueries.ColIdSuperUser}", idUser); reader_1.Close(); SqlDataReader reader_2 = command_2.ExecuteReader(CommandBehavior.CloseConnection); if (reader_2.Read()) { plannings.Add(_planningFactory.CreateFromReader(reader_2)); } } return(plannings); }
public IEnumerable <Planning> QueryPlanningsOfUserRecever(int idUserRecever) { IFactory <Planning> _planningFactory = new PlanningFactory(); IList <Planning> invitedPlannings = new List <Planning>(); using (var connection = Database.GetConnection()) { connection.Open(); var command = connection.CreateCommand(); command.CommandText = InvitationQueries.ReqGetPlanningsOfUserRecever; command.Parameters.AddWithValue($"@{InvitationQueries.ColIdUserRecever}", idUserRecever); var reader = command.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { invitedPlannings.Add(_planningFactory.CreateFromReader(reader)); } } return(invitedPlannings); }