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);
}
