public IHttpActionResult GetTraining(int id)
{
TrainingListM trainingListM = null;
try
{
using (var context = new TrainingAndMeetingDBEntities())
{
trainingListM = context.Trainings.Include("TrainingId") //to get list of training by comapring id
.Where(s => s.TrainingId == id)
.Select(s => new TrainingListM()
{
Topic = s.Topic,
TrainerName = s.User.FirstName,
StartTime = s.Schedule.StartTime.Value,
EndTime = s.Schedule.EndTime.Value,
RoomName = s.Schedule.RoomDetail.RoomName,
Description = s.Description
}).FirstOrDefault <TrainingListM>();
}
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
if (trainingListM == null)
{
return(NotFound());
}
return(Ok(trainingListM));
}
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 IHttpActionResult PutTraining(int id, Models.TrainingModel training)
{
if (!ModelState.IsValid)
{
return(NotFound());
}
try
{
using (var ctx = new TrainingAndMeetingDBEntities())
{
Training tra = new Training();
Schedule sch = new Schedule();
RoomDetail rm = new RoomDetail();
var existingtraining = ctx.Trainings.Where(s => s.TrainingId == id)
.FirstOrDefault <Training>();
var existingschedule = ctx.Schedules.Where(s => s.ScheduleId == existingtraining.ScheduleId)
.FirstOrDefault <Schedule>();
if (existingtraining != null)
{
existingschedule.StartTime = DateTime.ParseExact(training.StartTime, "yyyy-MM-dd HH:mm:ss",
System.Globalization.CultureInfo.InvariantCulture);
existingschedule.EndTime = DateTime.ParseExact(training.EndTime, "yyyy-MM-dd HH:mm:ss",
System.Globalization.CultureInfo.InvariantCulture);
existingschedule.RoomId = training.RoomId;
var obj = db.Schedules.Add(sch);
ctx.SaveChanges();
existingtraining.Topic = training.Topic; //add value in training table
existingtraining.Description = training.Description;
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
return(Ok(training));
}
