public Meeting GetById(int id)
{
MM_Meeting meetingDbModel = _meetingDbContext.MM_Meetings.FirstOrDefault(r => r.Id == id);
if (meetingDbModel == null)
{
throw new EntityNotFoundException <Meeting>(id);
}
Console.WriteLine("Log Event got by id.");
return(meetingDbModel.ConvertToMeeting());
}
public void Update(Meeting meeting)
{
MM_Meeting meetingDbModel = _meetingDbContext.MM_Meetings.Find(meeting.Id);
if (meetingDbModel == null)
{
throw new EntityNotFoundException <Meeting>((int)meeting.Id);
}
meetingDbModel.MeetingStatus = (int)meeting.StatusType;
if (meeting.StatusType == MeetingStatusType.Ended)
{
meetingDbModel.EndDateTime = DateTime.UtcNow;
}
else
{
meetingDbModel.EndDateTime = null;
meetingDbModel.MeetingLocationId = meeting.Location.Id;
meetingDbModel.MeetingStatus = (int)meeting.StatusType;
meetingDbModel.StartDateTime = meeting.StartDate;// meeting.StartDate;
//meetingDbModel.EndDateTime = meeting.EndDate;//meeting.EndDate;
meetingDbModel.Subject = meeting.Subject;
IList <MM_MeetingMember> meetingMembers = meetingDbModel.MM_MeetingMember.Select(x => x).ToList();
//Add meeting members.
foreach (MeetingMember member in meeting.Members)
{
MM_MeetingMember meetingMemberDbModel = new MM_MeetingMember()
{
UserId = member.Id,
MemberAs = (int)member.MemberAs
};
meetingDbModel.MM_MeetingMember.Add(meetingMemberDbModel);
}
}
try
{
_meetingDbContext.SaveChanges();
}
catch (Exception ex)
{
throw new UpdateFailedException <Meeting>((int)meeting.Id);
}
Console.WriteLine("Log Event is Updated.");
}
public static Meeting ConvertToMeeting(this MM_Meeting meetingDbModel)
{
return(new Meeting()
{
Id = meetingDbModel.Id,
EndDate = meetingDbModel.EndDateTime.GetValueOrDefault(),
StartDate = meetingDbModel.StartDateTime.GetValueOrDefault(),
Location = meetingDbModel.MM_MeetingLocation.ConvertToMeetingLocation(),
StatusType = (MeetingStatusType)meetingDbModel.MeetingStatus,
Subject = meetingDbModel.Subject,
CreatedDate = meetingDbModel.CreatedDate.GetValueOrDefault(),
CreatedUser = meetingDbModel.MM_User.ConvertToUser(),
Members = meetingDbModel.MM_MeetingMember.Select(x => x.ConvertToMeetingMembers()).ToList(),
Titles = meetingDbModel.MM_Agenda.Select(x => x.ConvertToAgendas()).ToList(),
ParentMeeting = meetingDbModel.ParentMeetingId == null ? null : new Meeting()
{
Id = (int)meetingDbModel.Id
},
//Where(y=>y.HeadingId==null).
});
}
public void Delete(int id)
{
MM_Meeting meetingDbModel = _meetingDbContext.MM_Meetings.FirstOrDefault(x => x.Id == id);
if (meetingDbModel == null)
{
throw new EntityNotFoundException <Meeting>(id);
}
_meetingDbContext.MM_Meetings.Remove(meetingDbModel);
try
{
_meetingDbContext.SaveChanges();
}
catch (Exception ex)
{
throw new DeleteFailedException <Meeting>(id);
}
Console.WriteLine("Log Event is Deleted.");
}
public int Add(Meeting meeting)
{
MM_Meeting meetingDbModel = new MM_Meeting()
{
CreatedDate = DateTime.UtcNow,
CreatedUserId = meeting.CreatedUser.Id,
MeetingLocationId = meeting.Location.Id,
MeetingStatus = (int)meeting.StatusType,
StartDateTime = meeting.StartDate, //meeting.StartDate,
EndDateTime = null, //meeting.EndDate,//DateTime.UtcNow,//meeting.EndDate,
Subject = meeting.Subject,
ParentMeetingId = meeting.ParentMeeting == null ? (int?)null : meeting.ParentMeeting.Id
};
_meetingDbContext.MM_Meetings.Add(meetingDbModel);
foreach (MeetingMember memberMember in meeting.Members)
{
MM_MeetingMember meetingMemberDbModel = new MM_MeetingMember()
{
UserId = memberMember.Id,
MemberAs = (int)memberMember.MemberAs
};
meetingDbModel.MM_MeetingMember.Add(meetingMemberDbModel);
}
foreach (Agenda title in meeting.Titles)
{
int parentOrderId = 0;
if (title.Heading == null)
{
MM_Agenda agenda = new MM_Agenda()
{
Title = title.Title,
SerialId = title.SerialId,
OrderId = title.OrderId,
};
int childOrderId = 0;
foreach (Agenda subtitle in title.SubTitles)
{
MM_Agenda subTitle = new MM_Agenda()
{
Title = subtitle.Title,
SerialId = subtitle.SerialId,
OrderId = subtitle.OrderId,
};
agenda.MM_Agenda1.Add(subTitle);
}
meetingDbModel.MM_Agenda.Add(agenda);
}
}
try
{
_meetingDbContext.SaveChanges();
}
catch (Exception ex)
{
throw new AddFailedException <Meeting>();
}
Console.WriteLine("Log Item is Added.");
return(meetingDbModel.Id);
}
