public MemberCheckInVM SearchEventCheckIn(SearchMemberVM SearchMember)
{
MemberCheckInVM MemberCheckInVM = new MemberCheckInVM();
using (var db = new TagsDataModel())
{
var currentEventId = Convert.ToInt32(ConfigurationManager.AppSettings["CurrentEventID"]);
var model = (from memberEvent in db.MEMBER_EVENT_CHECKINS
join member in db.TAGS_MEMBER on memberEvent.MEMBER_ID equals member.MEMBER_ID
where member.EMAIL_ID.ToLower().Equals(SearchMember.email.ToLower()) && memberEvent.EVENT_ID == currentEventId
select memberEvent).FirstOrDefault();
if (model != null)
{
MemberCheckInVM.eventCheckInVM = new EventCheckInVM();
MemberCheckInVM.eventCheckInVM.EVENT_CHECKIN_ID = model.EVENT_CHECKIN_ID;
MemberCheckInVM.eventCheckInVM.EVENT_ID = model.EVENT_ID;
MemberCheckInVM.eventCheckInVM.IS_CHECKEDIN = model.IS_CHECKEDIN;
MemberCheckInVM.eventCheckInVM.IS_PAID = model.IS_PAID;
MemberCheckInVM.eventCheckInVM.MEMBER_ID = model.MEMBER_ID;
MemberCheckInVM.eventCheckInVM.UESR_ID = model.UESR_ID;
MemberCheckInVM.IsRegistered = true;
MemberCheckInVM.IsExistingMember = true;
}
else
{
var TagsMember = (from member in db.TAGS_MEMBER
where member.EMAIL_ID.ToLower().Equals(SearchMember.email.ToLower())
select member).FirstOrDefault();
if (TagsMember != null)
{
MemberCheckInVM.eventCheckInVM = new EventCheckInVM();
MemberCheckInVM.eventCheckInVM.MEMBER_ID = TagsMember.MEMBER_ID;
MemberCheckInVM.eventCheckInVM.EVENT_ID = currentEventId;
MemberCheckInVM.IsRegistered = false;
MemberCheckInVM.IsExistingMember = true;
}
else
{
MemberCheckInVM.eventCheckInVM = new EventCheckInVM();
MemberCheckInVM.eventCheckInVM.EVENT_ID = currentEventId;
MemberCheckInVM.newMember = new MemberVM();
MemberCheckInVM.IsRegistered = false;
MemberCheckInVM.IsExistingMember = false;
}
}
}
return(MemberCheckInVM);
}
public MemberCheckInVM UpdateEventCheckIn(MemberCheckInVM memberCheckInVM)
{
var currentEventId = Convert.ToInt32(ConfigurationManager.AppSettings["CurrentEventID"]);
using (var db = new TagsDataModel())
{
var user = (from loggedInUser in db.TAGS_LOGIN
where loggedInUser.LAST_NAME.ToLower().Equals(User.Identity.Name)
select loggedInUser).FirstOrDefault();
if (memberCheckInVM.IsExistingMember && memberCheckInVM.IsRegistered)
{
var model = (from eve in db.MEMBER_EVENT_CHECKINS
where eve.EVENT_CHECKIN_ID == memberCheckInVM.eventCheckInVM.EVENT_CHECKIN_ID
select eve).FirstOrDefault();
model.IS_PAID = memberCheckInVM.eventCheckInVM.IS_PAID;
model.IS_CHECKEDIN = memberCheckInVM.eventCheckInVM.IS_CHECKEDIN;
model.UESR_ID = user.USER_ID;
db.SaveChanges();
memberCheckInVM.eventCheckInVM.isUpdated = true;
}
else if (memberCheckInVM.IsExistingMember && !memberCheckInVM.IsRegistered)
{
MEMBER_EVENT_CHECKINS membCheckIn = new MEMBER_EVENT_CHECKINS();
membCheckIn.EVENT_ID = currentEventId;
membCheckIn.MEMBER_ID = Convert.ToInt32(memberCheckInVM.eventCheckInVM.MEMBER_ID);
db.MEMBER_EVENT_CHECKINS.Add(membCheckIn);
db.SaveChanges();
memberCheckInVM.eventCheckInVM.EVENT_CHECKIN_ID = membCheckIn.EVENT_CHECKIN_ID;
memberCheckInVM.eventCheckInVM.MEMBER_ID = membCheckIn.MEMBER_ID;
memberCheckInVM.eventCheckInVM.EVENT_ID = membCheckIn.EVENT_ID;
memberCheckInVM.IsRegistered = true;
}
else if (!memberCheckInVM.IsExistingMember && !memberCheckInVM.IsRegistered)
{
MemberVM addedMember = AddMember(memberCheckInVM.newMember);
memberCheckInVM.eventCheckInVM.MEMBER_ID = addedMember.MEMBER_ID;
memberCheckInVM.IsExistingMember = true;
}
}
return(memberCheckInVM);
}
