public MemberVM SearchMember(SearchMemberVM SearchMember)
{
using (var db = new TagsDataModel())
{
MemberVM memb = new MemberVM();
var model = (from member in db.TAGS_MEMBER
where member.EMAIL_ID.ToLower().Equals(SearchMember.email.ToLower())
select member).FirstOrDefault();
if (model != null)
{
memb.CELL_PHONE = model.CELL_PHONE;
memb.COMPANY_NAME = model.COMPANY_NAME;
memb.EMAIL_ID = model.EMAIL_ID;
memb.FIRST_NAME = model.FIRST_NAME;
memb.HOME_PHONE = model.HOME_PHONE;
memb.IS_VOLUNTEER = model.IS_VOLUNTEER;
memb.LAST_NAME = model.LAST_NAME;
memb.MemberNotFound = false;
memb.MEMBER_ID = model.MEMBER_ID;
}
else
{
memb.MemberNotFound = true;
}
return(memb);
}
}
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);
}
