public void Handle(ScheduleMeetingCommand command)
        {
            var meeting = new MeetingFactory().Schedule(command.MeetingId, command.On, command.LocationId, command.SpeakerId, command.Capacity);

            repository.Add(meeting);

            //events from meeting?
            //AddNewSessionToSpeakerProfile(meeting.Id);
            //AddLocationUsage(meeting.Id)
        }
Exemple #2
0
        /// <summary>
        /// Извлекает все встречи репозитория.
        /// </summary>
        /// <returns></returns>
        public IEnumerable <Meeting> FindAll()
        {
            IMeetingFactory meetingFactory = new MeetingFactory();
            List <Meeting>  meetings       = new List <Meeting>();

            try
            {
                using (SqlConnection connection = new SqlConnection(_connectionString))
                {
                    connection.Open();
                    SqlCommand    command = new SqlCommand("SELECT * FROM Meetings", connection);
                    SqlDataReader reader  = command.ExecuteReader();
                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            DateTime?note;
                            if (reader.IsDBNull(3))
                            {
                                note = null;
                            }
                            else
                            {
                                note = reader.GetDateTime(3);
                            }
                            meetings.Add(meetingFactory.Create(reader.GetInt32(0), reader.GetDateTime(1), reader.GetDateTime(2), note));
                        }
                    }
                    reader.Close();
                    connection.Close();
                }
            }
            catch (Exception e)
            {
                throw new Exception(e.Message);
            }

            return(meetings);
        }