public Event FindEvent(int EventID, int PageType) { string settings = ConfigurationManager.ConnectionStrings["dbconnectionTraining"].ConnectionString; conn = new SqlConnection(settings); IContainerRepository servicioContainer = new ContainerRepository(); IEventRepository eventRepository = new EventRepository(); Event newEvent; conn.Open(); string sql = "EXECUTE EventByID;"; SqlCommand command = new SqlCommand(sql, conn) { CommandType = CommandType.StoredProcedure, CommandText = "EventByID" }; command.Parameters.Add("@EvenID", SqlDbType.Int); command.Parameters["@EvenID"].Value = EventID; SqlDataReader dataReader = command.ExecuteReader(); while (dataReader.Read()) { int eventId = int.Parse(dataReader.GetValue(0).ToString()); int OrganizationID = int.Parse(dataReader.GetValue(1).ToString()); List <P2PContainer> containers = servicioContainer.ContainersByEvent(eventId, PageType); newEvent = addEvent(eventId, OrganizationID, containers); conn.Close(); return(newEvent); } conn.Close(); return(null); }
public List <Event> AllEvents() { string settings = ConfigurationManager.ConnectionStrings["dbconnectionTraining"].ConnectionString; conn = new SqlConnection(settings); IEventRepository eventRepository = new EventRepository(); IContainerRepository servicioContainer = new ContainerRepository(); List <Event> events = new List <Event>(); conn.Open(); string sql = "EXECUTE AllEvents"; SqlCommand command = new SqlCommand(sql, conn); command.CommandType = CommandType.StoredProcedure; command.CommandText = "AllEvents"; SqlDataReader dataReader = command.ExecuteReader(); while (dataReader.Read()) { int EventID = int.Parse(dataReader.GetValue(0).ToString()); int OrganizationID = int.Parse(dataReader.GetValue(1).ToString()); List <P2PContainer> container = servicioContainer.ContainersByEvent(EventID, 1); Event newEvent = addEvent(EventID, OrganizationID, container); events.Add(newEvent); } return(events); }