public void CreateMeetingByUser(MeetingMember meetingMember, int userId) { using (var connection = new SqlConnection(_connectionString)) { connection.Open(); using (var command = connection.CreateCommand()) { /*if (meetingMember == null) throw new ArgumentNullException("meetingMember");*/ command.CommandText = "INSERT INTO [dbo].[meeting] (place_id, theme, time, duration) " + "VALUES (@place_id, @theme, @time, @duration); " + "SELECT @id = SCOPE_IDENTITY()"; var outId = command.Parameters.Add("@id", SqlDbType.Int); outId.Direction = ParameterDirection.Output; command.Parameters.AddWithValue("@place_id", meetingMember.MeetingId.FPlace.Id); command.Parameters.AddWithValue("@theme", meetingMember.MeetingId.Theme); command.Parameters.AddWithValue("@time", meetingMember.MeetingId.Time); command.Parameters.AddWithValue("@duration", meetingMember.MeetingId.Duration); command.ExecuteNonQuery(); meetingMember.MeetingId.Id = (int)outId.Value; command.CommandText ="INSERT INTO [dbo].[meeeting_member] " + "(users_id, meeting_id, status)" + " VALUES (@users_id, @meeting_id, @status)"; command.Parameters.AddWithValue("@users_id", userId); command.Parameters.AddWithValue("@meeting_id", meetingMember.MeetingId.Id ); command.Parameters.AddWithValue("@status", STATUS_ADMIN); command.ExecuteNonQuery(); } } }
public List<MeetingMember> CreateMeetingByUser(MeetingMember meetingMember, int userId) { _repository.CreateMeetingByUser(meetingMember, userId); return _repository.GetMeetingByUser(userId); }