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