public Agenda Add(Agenda agenda)
{
MM_Agenda agendaDbModel = new MM_Agenda()
{
MeetingId = agenda.Meeting.Id,
HeadingId = agenda.Heading == null? (int?)null : agenda.Heading.Id,
Title = agenda.Title,
SerialId = agenda.SerialId,
OrderId = agenda.OrderId,
IsCompleted = false
};
_meetingDbContext.MM_Agendas.Add(agendaDbModel);
try
{
_meetingDbContext.SaveChanges();
}
catch (Exception ex)
{
throw new AddFailedException <MeetingLocation>();
}
return(agendaDbModel.ConvertToAgendas());
}
public void Update(Agenda agenda)
{
MM_Agenda agendaDbModel = _meetingDbContext.MM_Agendas.Find(agenda.Id);
if (agendaDbModel == null)
{
throw new EntityNotFoundException <MeetingLocation>((int)agendaDbModel.Id);
}
if (agenda.IsCompleted == true)
{
agendaDbModel.IsCompleted = agenda.IsCompleted;
}
else
{
agendaDbModel.Title = agenda.Title;
agendaDbModel.SerialId = agenda.SerialId;
}
//agendaDbModel.OrderId = agenda.OrderId;
//agendaDbModel.MeetingId = agenda.MeetingId;
//agendaDbModel.HeadingId = agenda.Heading.Id;
try
{
_meetingDbContext.SaveChanges();
}
catch (Exception ex)
{
throw new UpdateFailedException <MeetingLocation>();
}
}
public Agenda GetByTitle(string title)
{
MM_Agenda agendaDbModel = _meetingDbContext.MM_Agendas.FirstOrDefault(r => r.Title == title);
if (agendaDbModel == null)
{
throw new EntityNotFoundException <MeetingLocation>(title);
}
return(agendaDbModel.ConvertToAgendas());
}
public Agenda GetById(int id)
{
MM_Agenda agendaDbModel = _meetingDbContext.MM_Agendas.FirstOrDefault(r => r.Id == id);
if (agendaDbModel == null)
{
throw new EntityNotFoundException <MeetingLocation>(id);
}
return(agendaDbModel.ConvertToAgendas());
}
public void Delete(int id)
{
MM_Agenda agendaDbModel = _meetingDbContext.MM_Agendas.FirstOrDefault(x => x.Id == id);
if (agendaDbModel == null)
{
throw new EntityNotFoundException <MeetingLocation>(id);
}
_meetingDbContext.MM_Agendas.Remove(agendaDbModel);
try
{
_meetingDbContext.SaveChanges();
}
catch (Exception ex)
{
throw new DeleteFailedException <MeetingLocation>(id);
}
}
public static Agenda ConvertToAgendas(this MM_Agenda agendaDbModel)
{
return(new Agenda()
{
Id = agendaDbModel.Id,
Title = agendaDbModel.Title,
//Heading= agendaDbModel.HeadingId==null ? null : agendaDbModel.MM_Agenda2.ConvertToAgendas(),
//Heading = agendaDbModel.HeadingId == null ? null : new Agenda() { Id = 0 },
//new Agenda() { Id = (int)agendaDbModel.HeadingId }
Heading = agendaDbModel.HeadingId == null ? null : new Agenda()
{
Id = (int)agendaDbModel.HeadingId
},
//Meeting = agendaDbModel.MM_Meeting.ConvertToMeeting(),
SubTitles = agendaDbModel.MM_Agenda1.Select(x => x.ConvertToAgendas()).ToList(),
SerialId = agendaDbModel.SerialId,
OrderId = agendaDbModel.OrderId.GetValueOrDefault(),
IsCompleted = agendaDbModel.IsCompleted,
AgendaMinute = agendaDbModel.MM_Minute.Select(x => x.ConvertToMinutes()).ToList()
});
}
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);
}
