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)); }
[ResponseType(typeof(Meeting))] //post data for craete new tarining public IHttpActionResult PostMeeting(Models.MeetingM meeting) //bind training model { try { if (!ModelState.IsValid) { return(NotFound()); } Schedule sch = new Schedule(); //object schedule entity sch.StartTime = DateTime.ParseExact(meeting.StartTime, "yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture); sch.EndTime = DateTime.ParseExact(meeting.EndTime, "yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture); var obj = db.Schedules.Add(sch); sch.RoomId = meeting.RoomId; db.SaveChanges(); //save data in schedule table Meeting met = new Meeting(); //object of Training entity met.MeetingName = meeting.MeetingName; met.Agenda = meeting.Agenda; met.ScheduleId = obj.ScheduleId; //getting Scheduleid from schedule table met.CreatedAt = DateTime.Now; met.UpdatedAt = DateTime.Now; met.UserId = meeting.UserId; var obj1 = db.Meetings.Add(met); db.Meetings.Add(met); //save data in meeting db db.SaveChanges(); foreach (int userid in meeting.MeetingAttendeeId) { MeetingsAttendee mList = new MeetingsAttendee(); //object of model class mList.UserId = userid; mList.MeetingId = obj1.MeetingId; db.MeetingsAttendees.Add(mList); db.SaveChanges(); } } catch (Exception e) { return(BadRequest(e.Message)); } return(CreatedAtRoute("DefaultApi", new { id = meeting.MeetingId }, meeting)); }