public IHttpActionResult PutMeeting(int id, [FromBody] Models.MeetingM meeting) { if (!ModelState.IsValid) { return(NotFound()); } try { using (var ctx = new TrainingAndMeetingDBEntities()) { Meeting tra = new Meeting(); Schedule sch = new Schedule(); RoomDetail rm = new RoomDetail(); MeetingListM mList = new MeetingListM(); //object of model class var data = db.Meetings.ToList(); //all list of meetings var existingmeeting = ctx.Meetings.Where(s => s.MeetingId == id) .FirstOrDefault <Meeting>(); //get existing meeting details var existingschedule = ctx.Schedules.Where(s => s.ScheduleId == existingmeeting.ScheduleId) .FirstOrDefault <Schedule>(); // get existing schedule var existingmeetingattendee = ctx.MeetingsAttendees.Where(s => s.MeetingId == existingmeeting.MeetingId) .FirstOrDefault <MeetingsAttendee>(); //get existing meeting attendee list if (existingmeeting != null) { existingschedule.StartTime = DateTime.ParseExact(meeting.StartTime, "yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture); existingschedule.EndTime = DateTime.ParseExact(meeting.EndTime, "yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture); existingschedule.RoomId = meeting.RoomId; var obj = db.Schedules.Add(sch); ctx.SaveChanges(); existingmeeting.MeetingName = meeting.MeetingName; //add value in training table existingmeeting.Agenda = meeting.Agenda; // existingmeetingattendee.MeetingId = meeting.MeetingId; var obj1 = db.Meetings.Add(tra); foreach (int userid in meeting.MeetingAttendeeId) { MeetingsAttendee list = new MeetingsAttendee(); //object of model class list.UserId = userid; list.MeetingId = existingmeeting.MeetingId; ctx.MeetingsAttendees.Add(list); ctx.SaveChanges(); } ctx.SaveChanges(); } else { return(NotFound()); } } } catch (Exception e) { return(BadRequest(e.Message)); } return(Ok(meeting)); }
public List <Models.MeetingListM> GetMeeting() //bind Training list model { List <Models.MeetingListM> list = new List <Models.MeetingListM>(); try { var data = db.Meetings.ToList(); //all list of meetings foreach (var item in data) { MeetingListM mList = new MeetingListM(); if (item.DeletedAt == null) { mList.MeetingId = item.MeetingId; mList.MeetingName = item.MeetingName; mList.OrganizerName = item.User.FirstName; mList.Agenda = item.Agenda; mList.StartTime = item.Schedule.StartTime.Value; mList.EndTime = item.Schedule.EndTime.Value; mList.RoomName = item.Schedule.RoomDetail.RoomName; List <Attendee> users = new List <Attendee>(); foreach (var one in item.MeetingsAttendees) { Attendee attend = new Attendee(); attend.AttendeeName = one.User.FirstName; attend.AttendeeID = one.User.UserId; users.Add(attend); } mList.MeetingAttendeesName = users; list.Add(mList); } } } catch (Exception e) { throw e; } return(list); }