public ParticipantDTO FindParticipant(int id)
{
Participants participant = db.Participants
.Include(i => i.EventID)
.Include(i => i.AccountID)
.SingleOrDefault(x => x.Id == id);
ParticipantDTO participantDto = MapParticipantToDTO(participant);
return(participantDto);
}
public ParticipantDTO MapParticipantToDTO(Participants participant)
{
ParticipantDTO participantDto = new ParticipantDTO();
participantDto.Id = participant.Id;
participantDto.eventId = participant.EventID.Id;
participantDto.NumberOfTicket = participant.NumberOfTicket;
participantDto.Reminder = participant.Reminder;
participantDto.userId = participant.AccountID.Id;
participantDto.emailNotificationOn = participant.emailNotificationOn;
participantDto.SMSNotificationOn = participant.SMSNotificationOn;
participantDto.Barcodes = GetBarcodeGuidsByParticipant(participant.Id);
return(participantDto);
}
public ParticipantDTO FindParticipantByBarcode(string guid)
{
Barcodes barcode = db.Barcodes
.Where(x => x.Barcode.ToString() == guid && x.IsActive == true)
.SingleOrDefault();
ParticipantDTO pDTO = new ParticipantDTO();
Participants participant = db.Participants
.Include(x => x.Barcodes)
.Include(x => x.EventID)
.Include(x => x.AccountID)
.Where(x => x.Barcodes.Select(y => y.Id).ToList().Contains(barcode.Id) && x.IsActive == true)
.SingleOrDefault();
pDTO = MapParticipantToDTO(participant);
return(pDTO);
}
public void UpdateParticipantReminders(ParticipantDTO pDTO)
{
string userId = HttpContext.Current.User.Identity.GetUserId();
ApplicationUser user = db.Users.Find(userId);
Participants pRec = db.Participants.Find(pDTO.Id);
pRec.Reminder = pDTO.Reminder;
pRec.emailNotificationOn = pDTO.emailNotificationOn;
pRec.SMSNotificationOn = pDTO.SMSNotificationOn;
if (pDTO.Phone != ConstantValues.phoneValidation && pDTO.Phone != null)
{
user.PhoneNumber = pDTO.Phone;
}
db.Entry(pRec).State = EntityState.Modified;
db.SaveChanges();
}
public List <ParticipantDTO> QueryUserEventsAttending()
{
string userId = HttpContext.Current.User.Identity.GetUserId();
ApplicationUser user = db.Users.Find(userId);
List <ParticipantDTO> dtoList = new List <ParticipantDTO>();
List <Participants> participantsList = db.Participants
.Include(i => i.EventID)
.Include(i => i.AccountID)
.Where(i => i.AccountID.Id == userId && i.EventID.IsActive == true && i.EventID.TimeStart >= DateTime.Now)
//.OrderBy(i => i.EventID.TimeStart)
.ToList();
foreach (Participants userEvents in participantsList)
{
ParticipantDTO participantDto = MapParticipantToDTO(userEvents);
dtoList.Add(participantDto);
}
return(dtoList);
}
public int CreateParticipant(ParticipantDTO participantsDTO)
{
string userId = HttpContext.Current.User.Identity.GetUserId();
ApplicationUser user = db.Users.Find(userId);
Events events = db.Events.Find(participantsDTO.eventId);
List <Barcodes> barcodes = new List <Barcodes>();
foreach (Guid barcode in participantsDTO.Barcodes)
{
var barcodeRecord = new Barcodes
{
Barcode = barcode,
CreatedBy = user,
CreatedDate = DateTime.Now,
IsActive = true
};
barcodes.Add(barcodeRecord);
}
var participant = new Participants
{
AccountID = user,
NumberOfTicket = participantsDTO.NumberOfTicket,
Reminder = participantsDTO.Reminder,
EventID = events,
CreatedBy = user,
IsActive = true,
CreatedDate = DateTime.Now,
Barcodes = barcodes
};
db.Participants.Add(participant);
db.SaveChanges();
return(participant.Id);
}