private int CreateUserDetails(ParticipantRegistration model, string createdBy) { int userDetailsID = 0; using (meetingContext = new OCASIAMeetingContext()) { UserDetail request = new UserDetail() { FirstLastName = model.FirstLastName, TitleID = model.TitleID, FamilyName = model.FamilyName, GivenName = model.GivenName, Email = model.Email, IsActive = true, IsPublish = true, CreatedBy = createdBy, CreatedOn = DateTime.Now, MeetingID = model.MeetingID }; meetingContext.UserDetails.Add(request); meetingContext.SaveChanges(); userDetailsID = request.UserDetailID; return(userDetailsID); } }
public MeetingPage ValidateMeetingUrl(int meetingID = 0) { using (meetingContext = new OCASIAMeetingContext()) { var result = meetingContext.Meetings.Where(el => el.MeetingID == meetingID && el.IsActive).FirstOrDefault(); if (result == null) { return(MeetingPage.DoesNotExists); } else if (result.AllowRegistration == false) { MeetingName = result.MeetingName; return(MeetingPage.Experired); } else if ( result.ApplicationStartDate != null && result.ApplicationStartDate.HasValue && DateTime.Compare(result.ApplicationStartDate.Value.Date, DateTime.Today.Date) < 0 && result.ApplicationEndDate != null && result.ApplicationEndDate.HasValue && DateTime.Compare(result.ApplicationEndDate.Value.Date, DateTime.Today.Date) >= 0) { MeetingName = result.MeetingName; Tabs = result.RegistrationTabs; return(MeetingPage.Active); } else { return(MeetingPage.Experired); } } }
public List <MeetingViewModel> GetMeetingDetailsbyID(int MeetingID) { using (meetingContext = new OCASIAMeetingContext()) { var res = meetingContext.Meetings.Include(a => a.RegistrationTabs).Include(a => a.RegistrationTabDetails).Include(a => a.Users).Where(el => el.MeetingID == MeetingID).Select(el => new MeetingViewModel() { MeetingID = el.MeetingID, MeetingName = el.MeetingName, Abbreviation = el.Abbreviation, EventStartDate = el.EventStartDate, EventEndDate = el.EventEndDate, ApplicationStartDate = el.ApplicationStartDate, ApplicationEndDate = el.ApplicationEndDate, CreatedOn = el.CreatedOn, CreatedBy = el.Users.UserName, IsPublish = el.IsPublish }).ToList(); return(res); } return(null); }
public List <MeetingViewModel> GetMeetingDetails() { using (meetingContext = new OCASIAMeetingContext()) { var res = meetingContext.Meetings.Include(a => a.Users).Where(el => el.IsActive).Select(el => new MeetingViewModel() { MeetingID = el.MeetingID, MeetingName = el.MeetingName, Abbreviation = el.Abbreviation, EventStartDate = el.EventStartDate, EventEndDate = el.EventEndDate, ApplicationStartDate = el.ApplicationStartDate, ApplicationEndDate = el.ApplicationEndDate, CreatedOn = el.CreatedOn, CreatedBy = el.Users.UserName, IsPublish = el.IsPublish, AllowRegistration = el.AllowRegistration }).OrderByDescending(el => el.MeetingID).AsQueryable(); return(res.ToList()); } return(null); }
public List <CollectionDetails> GetTitleList() { List <CollectionDetails> lstTitles = new List <CollectionDetails>(); using (meetingContext = new OCASIAMeetingContext()) { lstTitles = meetingContext.Titles.Where(el => el.IsActive).Select(el => new CollectionDetails() { ID = el.TitleID, Name = el.TitleName }).ToList(); } return(lstTitles); }
public List <CollectionDetails> GetRegistrationTabList() { List <CollectionDetails> lstRegistrationTabs = new List <CollectionDetails>(); using (meetingContext = new OCASIAMeetingContext()) { lstRegistrationTabs = meetingContext.RegistrationTabs.Where(el => el.IsActive).Select(el => new CollectionDetails() { ID = el.RegistrationTabID, Name = el.DisplayText }).ToList(); } return(lstRegistrationTabs); }
public bool AccessKeyValidation(string accesskey, int meetingID) { using (meetingContext = new OCASIAMeetingContext()) { var result = meetingContext.Invitations.Where(el => el.IsActive && el.IsPublish && el.InvitationAccessKeyName == accesskey && el.MeetingID == meetingID).FirstOrDefault(); if (result == null) { return(false); } else { return(true); } } }
public TabDetailModel GetMeetingInfoTabDetils(int meetingID, int tabIDs = 1) { using (meetingContext = new OCASIAMeetingContext()) { TabDetailModel model = meetingContext.RegistrationTabDetails.Where(el => el.IsActive && el.MeetingID == meetingID && el.RegistrationTabID == tabIDs). Select(el => new TabDetailModel() { RegistrationTabID = el.RegistrationTabID, MeetingID = el.MeetingID, BasicDescription = el.BasicDescription, Description1 = el.Description1, Description1PicturePath = el.Description1PicturePath, Description2 = el.Description2, Description2PicturePath = el.Description2PicturePath, Description3 = el.Description3, Description3PicturePath = el.Description3PicturePath, Description4 = el.Description4, Description4PicturePath = el.Description4PicturePath , FileName1 = el.FileName1, FileName1Path = el.FileName1Path, FileName2 = el.FileName2, FileName2Path = el.FileName2Path, FileName3 = el.FileName3, FileName3Path = el.FileName3Path, FileName4 = el.FileName4, FileName4Path = el.FileName4Path }).FirstOrDefault(); if (model == null) { return(new TabDetailModel()); } #if DEBUG model.Description1PicturePath = model.Description2PicturePath = model.Description3PicturePath = model.Description4PicturePath = "../Content/banners.jpg"; model.FileName1Path = model.FileName2Path = model.FileName3Path = model.FileName4Path = "../Content/banners.jpg"; #else #endif return(model); } }
public MeetingDetail GetMeetingDetail(int meetingID, string email = null) { MeetingDetail model = new MeetingDetail(); if (meetingID == 0 && string.IsNullOrEmpty(email)) { return(null); } using (meetingContext = new OCASIAMeetingContext()) { if (meetingID == 0) { model = meetingContext.UserDetails.Where(el => el.IsActive && el.Email == email).Select(el => new MeetingDetail() { MeetingID = el.MeetingID.Value, MeetingName = el.Meetings.MeetingName, UserDetailsID = el.UserDetailID, Tabs = el.Meetings.RegistrationTabs, EmailAddress = el.Meetings.OfficalEmail, PageBanner = el.Meetings.PageBannerPath, FaqDescription = el.Meetings.FaqDescription, FaqPath = el.Meetings.FaqPath, UserName = el.GivenName, StartDate = el.Meetings.EventStartDate, ContactNumber = el.Meetings.PhoneNumber, ReadOnly = el.IsSubmitted == null ? false : el.IsSubmitted.Value, IsPersonalFilled = string.IsNullOrEmpty(el.PassportNumber) ? false : true } ).FirstOrDefault(); if (model == null) { return(null); } model.IsTravelFilled = meetingContext.TravelDetails.Where(el => el.IsActive && el.UserDetailID == model.UserDetailsID).FirstOrDefault() == null ? true : false; model.IsGuestsFilled = meetingContext.UserDetails.Where(el => el.IsActive && el.GuestOf == model.UserDetailsID.ToString()).FirstOrDefault() == null ? true : false; } else { model = meetingContext.Meetings.Where(el => el.IsActive && el.AllowRegistration && el.IsActive && el.MeetingID == meetingID).Select(el => new MeetingDetail() { MeetingID = el.MeetingID, MeetingName = el.MeetingName, StartDate = el.EventStartDate, Tabs = el.RegistrationTabs, ContactNumber = el.PhoneNumber, EmailAddress = el.OfficalEmail, FaqDescription = el.FaqDescription, FaqPath = el.FaqPath, PageBanner = el.PageBannerPath }).FirstOrDefault(); } if (model == null) { return(null); } #if DEBUG model.PageBanner = "../Content/banners.jpg"; model.FaqPath = "../Content/banners.jpg"; #else model.PageBanner = model.PageBanner?.Replace("~", Helper.FilePath); model.FaqPath = model.FaqPath?.Replace("~", Helper.FilePath); #endif } return(model); }
public bool AddMettingDeatils(MeetingViewModel model) { if (model != null) { using (meetingContext = new OCASIAMeetingContext()) { Meeting mdl = new Meeting(); mdl.Abbreviation = model.Abbreviation; mdl.MeetingName = model.MeetingName; mdl.MeetingDescription = model.MeetingDescription; mdl.EventStartDate = model.EventStartDate; mdl.EventEndDate = model.EventEndDate; mdl.ApplicationStartDate = model.ApplicationStartDate; mdl.ApplicationEndDate = model.ApplicationEndDate; mdl.PageBannerPath = model.PageBannerPath; mdl.FaqDescription = model.FaqDescription; mdl.FaqPath = model.FaqPath; mdl.SchedulePath = model.SchedulePath; mdl.OfficalEmail = model.OfficalEmail; mdl.Address = model.Address; mdl.PhoneNumber = model.PhoneNumber; mdl.FaxNumber = model.FaxNumber; if (model.RegistrationTabs != null) { mdl.RegistrationTabs = model.RegistrationTabs; mdl.AllowRegistration = false; } else { mdl.AllowRegistration = false; } mdl.CreatedBy = model.CreatedBy; mdl.CreatedOn = DateTime.Now; mdl.IsActive = true; mdl.IsPublish = false; meetingContext.Meetings.Add(mdl); meetingContext.SaveChanges(); if (!string.IsNullOrEmpty(model.BasicDescription)) { RegistrationTabDetail obj = new RegistrationTabDetail(); obj.MeetingID = mdl.MeetingID; obj.BasicDescription = model.BasicDescription; obj.Description1 = model.Description1; obj.Description1PicturePath = model.Description1PicturePath; obj.FileName1 = model.FileName1; obj.Description1 = model.Description1; obj.Description1PicturePath = model.Description1PicturePath; obj.FileName1 = model.FileName1; obj.Description2 = model.Description2; obj.Description2PicturePath = model.Description2PicturePath; obj.FileName2 = model.FileName2; obj.Description3 = model.Description3; obj.Description3PicturePath = model.Description3PicturePath; obj.FileName3 = model.FileName3; obj.Description4 = model.Description4; obj.Description4PicturePath = model.Description4PicturePath; obj.FileName4 = model.FileName4; obj.RegistrationTabID = model.RegistrationTabID; obj.CreatedBy = model.CreatedBy; obj.CreatedOn = DateTime.Now; obj.IsActive = true; meetingContext.RegistrationTabDetails.Add(obj); meetingContext.SaveChanges(); } return(true); } } return(false); }