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);
}
