Пример #1
0
 public bool ValidateUserWithMeetingDetails(string email)
 {
     using (OCASIAMeetingUOW db = new OCASIAMeetingUOW())
     {
         return(db.Repository <UserDetail>().GetAll().Where(el => el.IsActive && el.Email == email && el.Meetings.AllowRegistration == true).FirstOrDefault() == null ? false : true);
     }
 }
Пример #2
0
 public bool GetUserType(string email)
 {
     using (OCASIAMeetingUOW db = new OCASIAMeetingUOW())
     {
         return(db.Repository <ApplicationUser>().GetAll().Where(el => el.Email == email && el.IsActive && el.RoleCustomID == 1).FirstOrDefault() == null ? false : true);
     }
 }
Пример #3
0
        public TravelDetailsModel GetTravelDetails(int userDetailsID)
        {
            TravelDetailsModel model;
            bool IsreadOnly = CheckSubmitted(userDetailsID);

            using (OCASIAMeetingUOW db = new OCASIAMeetingUOW())
            {
                model = db.Repository <TravelDetail>().GetAll().Where(el => el.IsActive && el.UserDetailID == userDetailsID)
                        .Select(el => new TravelDetailsModel()
                {
                    ReadOnly            = IsreadOnly,
                    UserDetailID        = el.UserDetailID,
                    TravelDetailID      = el.TravelDetailID,
                    ArrivalAirport      = el.ArrivalAirport,
                    ArrivalDate         = el.ArrivalDate,
                    ArrivalFlightNumber = el.ArrivalFlightNumber,
                    NoCheckInBages      = el.NoCheckInBages,
                    ArrivalTime         = el.ArrivalTime,
                    DepartureDate       = el.DepartureDate,
                    DeparturelAirport   = el.DeparturelAirport,
                    DepartureTime       = el.DepartureTime,
                    Comments            = el.Comments
                }).FirstOrDefault();
            }
            return(model);
        }
Пример #4
0
 public bool EditMettingDeatils(MeetingViewModel model)
 {
     if (model != null)
     {
         using (dbContext = new OCASIAMeetingUOW())
         {
             var mdl = dbContext.Repository <OCASIA.Meeting.DAL.Meeting>().GetAll().Where(a => a.MeetingID == model.MeetingID).FirstOrDefault();
             if (mdl != null)
             {
                 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 != null ? model.PageBannerPath : mdl.PageBannerPath;
                 mdl.FaqDescription       = model.FaqDescription;
                 mdl.FaqPath          = model.FaqPath != null ? model.FaqPath : mdl.FaqPath;
                 mdl.SchedulePath     = model.SchedulePath != null ? model.SchedulePath : mdl.SchedulePath;
                 mdl.OfficalEmail     = model.OfficalEmail;
                 mdl.Address          = model.Address;
                 mdl.PhoneNumber      = model.PhoneNumber;
                 mdl.FaxNumber        = model.FaxNumber;
                 mdl.RegistrationTabs = model.RegistrationTabs;
                 mdl.UpdatedBy        = model.CreatedBy;
                 mdl.UpdateOn         = DateTime.Now;
                 dbContext.Repository <OCASIA.Meeting.DAL.Meeting>().Update(mdl);
                 dbContext.SaveChanges();
             }
             var obj = dbContext.Repository <OCASIA.Meeting.DAL.RegistrationTabDetail>().GetAll().Where(a => a.MeetingID == model.MeetingID).FirstOrDefault();
             if (obj != null)
             {
                 obj.MeetingID               = mdl.MeetingID;
                 obj.BasicDescription        = model.BasicDescription;
                 obj.Description1            = model.Description1;
                 obj.Description1PicturePath = model.Description1PicturePath != null ? model.SchedulePath : obj.Description1PicturePath;
                 obj.FileName1               = model.FileName1 != null ? model.FileName1 : obj.FileName1;
                 obj.Description2            = model.Description2;
                 obj.Description2PicturePath = model.Description2PicturePath != null ? model.Description2PicturePath : obj.Description2PicturePath;
                 obj.FileName2               = model.FileName2 != null ? model.FileName2 : obj.FileName2;
                 obj.Description3            = model.Description3;
                 obj.Description3PicturePath = model.Description3PicturePath != null ? model.Description3PicturePath : obj.Description3PicturePath;
                 obj.FileName3               = model.FileName3 != null ? model.FileName3 : obj.FileName3;
                 obj.Description4            = model.Description4;
                 obj.Description4PicturePath = model.Description4PicturePath != null ? model.Description4PicturePath : obj.Description4PicturePath;
                 obj.FileName4               = model.FileName4 != null ? model.FileName4 : obj.FileName4;
                 obj.RegistrationTabID       = model.RegistrationTabID;
                 obj.UpdatedBy               = model.CreatedBy;
                 obj.UpdateOn = DateTime.Now;
                 dbContext.Repository <OCASIA.Meeting.DAL.RegistrationTabDetail>().Update(obj);
                 dbContext.SaveChanges();
             }
             return(true);
         }
     }
     return(false);
 }
Пример #5
0
        public List <UserDetailsModel> GetGuestDetails(int userDetailsID)
        {
            List <UserDetailsModel> model = new List <UserDetailsModel>();

            using (OCASIAMeetingUOW db = new OCASIAMeetingUOW())
            {
                model = db.Repository <UserDetail>().GetAll().Where(el => el.IsActive && el.IsGust == true && el.GuestOf == userDetailsID.ToString()).Select(el =>
                                                                                                                                                             new UserDetailsModel()
                {
                    UserDetailID            = el.UserDetailID,
                    GuestOf                 = el.GuestOf,
                    AddressLine1            = el.AddressLine1,
                    AddressLine2            = el.AddressLine2,
                    AssitantEmail           = el.AssitantEmail,
                    City                    = el.City,
                    Company                 = el.Company,
                    Desc4                   = el.Desc4,
                    DOB                     = el.DOB,
                    Email                   = el.Email,
                    ExpiryDate              = el.ExpiryDate,
                    FamilyName              = el.FamilyName,
                    FirstLastName           = el.FirstLastName,
                    Gender                  = el.Gender,
                    GivenName               = el.GivenName,
                    IsGust                  = el.IsGust == null ? false : el.IsGust.Value,
                    IssueDate               = el.IssueDate,
                    Nationality             = el.Nationality,
                    Organization            = el.Organization,
                    OrganizationDesignation = el.OrganizationDesignation,
                    OrganizationFunction    = el.Organization,
                    PassportCoptyPath       = el.PassportCoptyPath,
                    PassportNumber          = el.PassportNumber,
                    PostalCode              = el.PostalCode,
                    StateProvince           = el.StateProvince,
                    TelephoneNumber         = el.TelephoneNumber,
                    Title                   = el.Titles.TitleName,
                    UploadedPicturePath     = el.UploadedPicturePath,
                    CountryID               = el.CountryID == null ? 0 : el.CountryID.Value,
                    CountryOfResidanceID    = el.CountryOfResidanceID == null ? 0 : el.CountryOfResidanceID.Value
                }).ToList();
                model.ForEach(el =>
                {
                    if (el.CountryID != 0)
                    {
                        el.CountryName = db.Repository <Mst_Country>().GetAllReffByID(inner => inner.CountryID == el.CountryID).Select(inner => inner.CountryName).FirstOrDefault();
                    }
                    if (el.CountryOfResidanceID != 0)
                    {
                        el.CountryOfResidance = db.Repository <Mst_Country>().GetAllReffByID(inner => inner.CountryID == el.CountryOfResidanceID).Select(inner => inner.CountryName).FirstOrDefault();
                    }
                });
            }
            return(model);
        }
Пример #6
0
        public static int AdminRoleID()
        {
            OCASIAMeetingUOW db = new OCASIAMeetingUOW();

            var RoleCustomID = db.Repository <RoleCustom>().GetAll().Where(a => a.RoleName == "Admin").Select(a => a.RoleCustomID).FirstOrDefault();

            if (RoleCustomID != 0)
            {
                return(RoleCustomID);
            }
            return(0);
        }
Пример #7
0
        public static string CurrentUserRole()
        {
            OCASIAMeetingUOW db = new OCASIAMeetingUOW();

            string UserId      = HttpContext.Current.User.Identity.GetUserId();
            var    CurrentRole = db.Repository <ApplicationUser>().GetAll().Where(a => a.Id == UserId).Include(a => a.RoleCustoms).Select(a => a.RoleCustoms.RoleName).FirstOrDefault();

            if (CurrentRole != null)
            {
                return(CurrentRole);
            }
            return(null);
        }
Пример #8
0
        public static int CurrentUserRoleID()
        {
            OCASIAMeetingUOW db = new OCASIAMeetingUOW();

            string UserId       = HttpContext.Current.User.Identity.GetUserId();
            var    RoleCustomID = db.Repository <ApplicationUser>().GetAll().Where(a => a.Id == UserId).Include(a => a.RoleCustoms).Select(a => a.RoleCustoms.RoleCustomID).FirstOrDefault();

            if (RoleCustomID != 0)
            {
                return(RoleCustomID);
            }
            return(0);
        }
Пример #9
0
        public List <CollectionDetails> GetListOfGuests(int userDetailsID)
        {
            List <CollectionDetails> model = new List <CollectionDetails>();

            using (OCASIAMeetingUOW db = new OCASIAMeetingUOW())
            {
                model = db.Repository <UserDetail>().GetAll().Where(el => el.IsActive && el.IsGust == true && el.GuestOf == userDetailsID.ToString()).Select(el => new CollectionDetails()
                {
                    ID = el.UserDetailID, Name = el.GivenName
                }).ToList();
            }
            return(model);
        }
Пример #10
0
        public MeetingViewModel GetMeetingDetailbyID(int meetingID)
        {
            MeetingViewModel model = new MeetingViewModel();

            using (dbContext = new OCASIAMeetingUOW())
            {
                var el = dbContext.Repository <OCASIA.Meeting.DAL.Meeting>().GetAll().Where(a => a.MeetingID == meetingID).FirstOrDefault();
                if (el != null)
                {
                    model.MeetingID            = el.MeetingID;
                    model.MeetingName          = el.MeetingName;
                    model.Abbreviation         = el.Abbreviation;
                    model.EventStartDate       = el.EventStartDate;
                    model.EventEndDate         = el.EventEndDate.Value.Date;
                    model.ApplicationStartDate = el.ApplicationStartDate.Value.Date;
                    model.ApplicationEndDate   = el.ApplicationEndDate.Value.Date;
                    model.RegistrationTabs     = el.RegistrationTabs;
                    model.PhoneNumber          = el.PhoneNumber;
                    model.FaxNumber            = el.FaxNumber;
                    model.OfficalEmail         = el.OfficalEmail;
                    model.Address            = el.Address;
                    model.MeetingDescription = el.MeetingDescription;
                    model.FaqDescription     = el.FaqDescription;
                    model.FaqPath            = el.FaqPath != null?el.FaqPath.Replace("~/UploadFiles/" + el.MeetingName + "/", "") : null;

                    model.PageBannerPath = el.PageBannerPath;
                    model.SchedulePath   = el.SchedulePath != null?el.SchedulePath.Replace("~/UploadFiles/" + el.MeetingName + "/", "") : null;
                }
                ;

                var res = dbContext.Repository <OCASIA.Meeting.DAL.RegistrationTabDetail>().GetAll().Where(a => a.MeetingID == meetingID).FirstOrDefault();
                if (res != null)
                {
                    model.BasicDescription        = res.BasicDescription;
                    model.Description1            = res.Description1;
                    model.Description1PicturePath = res.Description1PicturePath;
                    model.FileName1               = res.FileName1;
                    model.Description2            = res.Description2;
                    model.Description2PicturePath = res.Description2PicturePath;
                    model.FileName2               = res.FileName2;
                    model.Description3            = res.Description3;
                    model.Description3PicturePath = res.Description3PicturePath;
                    model.FileName3               = res.FileName3;
                    model.Description4            = res.Description4;
                    model.Description4PicturePath = res.Description4PicturePath;
                    model.FileName4               = res.FileName4;
                    model.RegistrationTabID       = res.RegistrationTabID;
                }
                return(model);
            }
        }
Пример #11
0
        /// <summary>
        /// Step 3: add travel details
        /// </summary>
        /// <param name="userDetail">Travel Details</param>
        /// <returns></returns>
        public bool UpdateTravelDetails(TravelDetailsModel travelDetail)
        {
            bool success = false;

            using (OCASIAMeetingUOW db = new OCASIAMeetingUOW())
            {
                TravelDetail record = new TravelDetail();

                if (travelDetail.TravelDetailID != 0)
                {
                    record = db.Repository <TravelDetail>().GetAll().Where(el => el.IsActive && el.TravelDetailID == travelDetail.TravelDetailID).Select(el => el).FirstOrDefault();
                }

                if (record == null)
                {
                    return(false);
                }

                record.UserDetailID        = travelDetail.UserDetailID;
                record.Address             = travelDetail.Address;
                record.ArrivalDate         = travelDetail.ArrivalDate;
                record.ArrivalAirport      = travelDetail.ArrivalAirport;
                record.ArrivalFlightNumber = travelDetail.ArrivalFlightNumber;
                record.ArrivalTime         = travelDetail.ArrivalTime;
                record.Comments            = travelDetail.Comments;
                record.CreatedBy           = travelDetail.CreatedBy;
                record.CreatedOn           = DateTime.Now;
                record.DepartureDate       = travelDetail.DepartureDate;
                record.DeparturelAirport   = travelDetail.DeparturelAirport;
                record.DepartureTime       = travelDetail.DepartureTime;
                record.NoCheckInBages      = travelDetail.NoCheckInBages;
                record.IsActive            = true;
                record.NoCheckInBages      = travelDetail.NoCheckInBages;
                record.PhoneNumber         = travelDetail.PhoneNumber;
                record.Desc1 = travelDetail.Desc1;
                record.Desc2 = travelDetail.Desc2;
                record.Desc3 = travelDetail.Desc3;

                if (travelDetail.TravelDetailID == 0)
                {
                    db.Repository <TravelDetail>().Add(record);
                }
                else
                {
                    db.Repository <TravelDetail>().Update(record);
                }
                db.SaveChanges();
                success = true;
            }
            return(success);
        }
Пример #12
0
 private bool CheckSubmitted(int userDetailsID)
 {
     using (OCASIAMeetingUOW db = new OCASIAMeetingUOW())
     {
         var v = db.Repository <UserDetail>().GetAll().Where(el => el.IsActive && el.UserDetailID == userDetailsID && el.IsSubmitted == true).FirstOrDefault();
         if (v == null)
         {
             return(false);
         }
         else
         {
             return(true);
         }
     }
 }
Пример #13
0
        /// <summary>
        /// Step 1 : user creation
        /// </summary>
        /// <param name="model">Registration details</param>
        /// <returns></returns>
        public int RegisterUser(ParticipantRegistration model)
        {
            string createdBy     = string.Empty;
            int    userDetailsID = 0;

            #region Create useer
            using (OCASIAMeetingUOW db = new OCASIAMeetingUOW())
            {
                var res = db.Repository <ApplicationUser>().GetAll().Where(f => f.Email == model.Email).FirstOrDefault();
                if (res == null)
                {
                    var user = new ApplicationUser()
                    {
                        UserName         = model.Email,
                        Email            = model.Email,
                        RoleCustomID     = 3,
                        IsActive         = true,
                        IspasswordActive = true
                    };
                    var userManager = new Microsoft.AspNet.Identity.UserManager <ApplicationUser>(new Microsoft.AspNet.Identity.EntityFramework.UserStore <ApplicationUser>(new OCASIAMeetingContext()));
                    var ures        = userManager.Create(user, model.Password);
                    if (ures.Succeeded)
                    {
                        // userManager.AddClaim(user.Id, new System.Security.Claims.Claim("FullName", model.Email));
                        Passwordhash mdl = new Passwordhash()
                        {
                            UserId   = user.Id,
                            Password = model.Password
                        };
                        db.Repository <Passwordhash>().Add(mdl);
                        db.SaveChanges();
                        createdBy = mdl.UserId;
                    }
                }
                else
                {
                    return(-1);
                }
            }
            #endregion
            if (string.IsNullOrEmpty(createdBy))
            {
                return(userDetailsID);
            }
            userDetailsID = CreateUserDetails(model, createdBy);
            return(userDetailsID);
        }
Пример #14
0
 public int GetCurrentMeetingID()
 {
     using (OCASIAMeetingUOW db = new OCASIAMeetingUOW())
     {
         var result = db.Repository <Meeting>().GetAll().Where(el => el.IsActive && el.AllowRegistration).Select(el => el).OrderByDescending(el => el.CreatedBy).FirstOrDefault();
         if (result == null)
         {
             return(0);
         }
         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)
             )
         {
             return(result.MeetingID);
         }
         else
         {
             return(-1);
         }
     }
 }
Пример #15
0
        /// <summary>
        /// Step 4 : Submitting or cancllation
        /// </summary>
        /// <param name="userDetailsId"></param>
        /// <param name="isCanclled"></param>
        /// <returns></returns>
        public bool UpdateUserConfirmtion(int userDetailsId, bool isSubmitted, bool isCanclled = false)
        {
            bool success = false;

            using (OCASIAMeetingUOW db = new OCASIAMeetingUOW())
            {
                UserDetail response = db.Repository <UserDetail>().GetAll().Where(el => el.IsActive && el.Meetings.AllowRegistration && el.UserDetailID == userDetailsId).Select(el => el).FirstOrDefault();
                if (response == null)
                {
                    return(success);
                }

                response.IsCanclled  = isCanclled;
                response.IsSubmitted = isSubmitted;

                db.Repository <UserDetail>().Update(response);
                db.SaveChanges();

                success = true;
            }
            return(success);
        }
Пример #16
0
        /// <summary>
        /// Step 2: User details
        /// </summary>
        /// <param name="userDetail">Personal details</param>
        /// <returns></returns>

        public bool UpdatePersonalDetails(UserDetailsModel userDetail, bool Isguest)
        {
            bool success = false;

            using (OCASIAMeetingUOW db = new OCASIAMeetingUOW())
            {
                var response = db.Repository <UserDetail>().GetAll().Where(el => el.IsActive && el.UserDetailID == userDetail.UserDetailID).FirstOrDefault();
                if (response == null)
                {
                    return(success);
                }
                if (Isguest == true)
                {
                    var res = db.Repository <UserDetail>().GetAll().Where(el => el.IsActive && el.IsGust == Isguest && el.UserDetailID == userDetail.UserDetailID).FirstOrDefault();
                    if (res == null)
                    {
                        UserDetail mdl = new UserDetail();

                        mdl.TitleID                 = userDetail.TitleID;
                        mdl.GivenName               = userDetail.GivenName;
                        mdl.FamilyName              = userDetail.FamilyName;
                        mdl.Email                   = userDetail.Email;
                        mdl.FirstLastName           = userDetail.FirstLastName;
                        mdl.AssitantEmail           = userDetail.AssitantEmail;
                        mdl.CountryOfResidanceID    = userDetail.CountryOfResidanceID;
                        mdl.CountryID               = userDetail.CountryID;
                        mdl.Organization            = userDetail.Organization;
                        mdl.OrganizationDesignation = userDetail.OrganizationDesignation;
                        mdl.OrganizationFunction    = userDetail.OrganizationFunction;
                        mdl.Company                 = userDetail.Company;
                        mdl.AddressLine1            = userDetail.AddressLine1;
                        mdl.AddressLine2            = userDetail.AddressLine2;
                        mdl.PostalCode              = userDetail.PostalCode;
                        mdl.City                = userDetail.City;
                        mdl.StateProvince       = userDetail.StateProvince;
                        mdl.TelephoneNumber     = userDetail.TelephoneNumber;
                        mdl.PassportNumber      = userDetail.PassportNumber;
                        mdl.UploadedPicturePath = userDetail.UploadedPicturePath;
                        mdl.Desc4               = userDetail.Desc4;
                        mdl.PassportCoptyPath   = userDetail.PassportCoptyPath;
                        mdl.DOB         = userDetail.DOB;
                        mdl.IssueDate   = userDetail.IssueDate;
                        mdl.Nationality = userDetail.Nationality;
                        mdl.ExpiryDate  = userDetail.ExpiryDate;
                        mdl.Gender      = userDetail.Gender;
                        mdl.GuestOf     = userDetail.UserDetailID.ToString();
                        mdl.IsGust      = Isguest;
                        mdl.IsActive    = true;
                        mdl.IsPublish   = true;
                        mdl.CreatedBy   = userDetail.CreatedBy;
                        mdl.CreatedOn   = DateTime.Now;
                        db.Repository <UserDetail>().Add(mdl);
                        db.SaveChanges();
                    }
                    else
                    {
                        res.TitleID                 = userDetail.TitleID;
                        res.GivenName               = userDetail.GivenName;
                        res.FamilyName              = userDetail.FamilyName;
                        res.Email                   = userDetail.Email;
                        res.FirstLastName           = userDetail.FirstLastName;
                        res.AssitantEmail           = userDetail.AssitantEmail;
                        res.CountryOfResidanceID    = userDetail.CountryOfResidanceID;
                        res.CountryID               = userDetail.CountryID;
                        res.Organization            = userDetail.Organization;
                        res.OrganizationDesignation = userDetail.OrganizationDesignation;
                        res.OrganizationFunction    = userDetail.OrganizationFunction;
                        res.Company                 = userDetail.Company;
                        res.AddressLine1            = userDetail.AddressLine1;
                        res.AddressLine2            = userDetail.AddressLine2;
                        res.PostalCode              = userDetail.PostalCode;
                        res.City                = userDetail.City;
                        res.StateProvince       = userDetail.StateProvince;
                        res.TelephoneNumber     = userDetail.TelephoneNumber;
                        res.PassportNumber      = userDetail.PassportNumber;
                        res.UploadedPicturePath = userDetail.UploadedPicturePath != null ? userDetail.UploadedPicturePath : null;
                        res.Desc4               = userDetail.Desc4 != null ? userDetail.Desc4 : null;
                        res.PassportCoptyPath   = userDetail.PassportCoptyPath != null ? userDetail.PassportCoptyPath : null;
                        res.DOB         = userDetail.DOB;
                        res.IssueDate   = userDetail.IssueDate;
                        res.Nationality = userDetail.Nationality;
                        res.ExpiryDate  = userDetail.ExpiryDate;
                        res.Gender      = userDetail.Gender;
                        res.CreatedBy   = userDetail.UpdatedBy;
                        res.UpdateOn    = DateTime.Now;
                        db.Repository <UserDetail>().Update(res);
                        db.SaveChanges();
                    }
                }
                else
                {
                    response.FirstLastName           = userDetail.FirstLastName;
                    response.AssitantEmail           = userDetail.AssitantEmail;
                    response.CountryOfResidanceID    = userDetail.CountryOfResidanceID;
                    response.CountryID               = userDetail.CountryID;
                    response.Organization            = userDetail.Organization;
                    response.OrganizationDesignation = userDetail.OrganizationDesignation;
                    response.OrganizationFunction    = userDetail.OrganizationFunction;
                    response.Company             = userDetail.Company;
                    response.AddressLine1        = userDetail.AddressLine1;
                    response.AddressLine2        = userDetail.AddressLine2;
                    response.PostalCode          = userDetail.PostalCode;
                    response.City                = userDetail.City;
                    response.StateProvince       = userDetail.StateProvince;
                    response.TelephoneNumber     = userDetail.TelephoneNumber;
                    response.PassportNumber      = userDetail.PassportNumber;
                    response.UploadedPicturePath = userDetail.UploadedPicturePath != null ? userDetail.UploadedPicturePath : null;
                    response.Desc4               = userDetail.Desc4 != null ? userDetail.Desc4 : null;
                    response.PassportCoptyPath   = userDetail.PassportCoptyPath != null ? userDetail.PassportCoptyPath : null;
                    response.DOB         = userDetail.DOB;
                    response.IssueDate   = userDetail.IssueDate;
                    response.Nationality = userDetail.Nationality;
                    response.ExpiryDate  = userDetail.ExpiryDate;
                    response.UpdatedBy   = userDetail.UpdatedBy;
                    response.UpdateOn    = DateTime.Now;
                    response.Gender      = userDetail.Gender;
                    db.Repository <UserDetail>().Update(response);
                    db.SaveChanges();
                }
                success = true;
            }
            return(success);
        }
Пример #17
0
        public UserDetailsModel GetUserPersonalDetails(int UserDetailID)
        {
            UserDetailsModel model = new UserDetailsModel();

            using (OCASIAMeetingUOW db = new OCASIAMeetingUOW())
            {
                model = db.Repository <UserDetail>().GetAll().Include(el => el.Meetings).Where(el => el.IsActive && el.UserDetailID == UserDetailID).Select(el =>
                                                                                                                                                            new UserDetailsModel()
                {
                    TitleID                 = el.TitleID,
                    UserDetailID            = el.UserDetailID,
                    Gender                  = el.Gender,
                    FirstLastName           = el.FirstLastName,
                    FamilyName              = el.FamilyName,
                    MeetingName             = el.Meetings.MeetingName,
                    AddressLine1            = el.AddressLine1,
                    AddressLine2            = el.AddressLine2,
                    AssitantEmail           = el.AssitantEmail,
                    City                    = el.City,
                    Company                 = el.Company,
                    DOB                     = el.DOB,
                    Email                   = el.Email,
                    ExpiryDate              = el.ExpiryDate,
                    GivenName               = el.GivenName,
                    IssueDate               = el.IssueDate,
                    Nationality             = el.Nationality,
                    Organization            = el.Organization,
                    OrganizationDesignation = el.OrganizationDesignation,
                    PassportNumber          = el.PassportNumber,
                    PostalCode              = el.PostalCode,
                    StateProvince           = el.StateProvince,
                    TelephoneNumber         = el.TelephoneNumber,
                    Title                   = el.Titles.TitleName,
                    UploadedPicturePath     = el.UploadedPicturePath,
                    Desc4                   = el.Desc4,
                    Desc3                   = el.PassportCoptyPath != null ? el.PassportCoptyPath.Replace("~/Participant/" + el.Meetings.MeetingName + "/", "") : null,
                    PassportCoptyPath       = el.PassportCoptyPath != null ? el.PassportCoptyPath.Replace("~/", "") : null,
                    CountryID               = el.CountryID == null ? 0 : el.CountryID.Value,
                    CountryOfResidanceID    = el.CountryOfResidanceID == null ? 0 : el.CountryOfResidanceID.Value
                }).FirstOrDefault();



                if (model != null)
                {
                    if (model.CountryID != 0)
                    {
                        model.CountryName = db.Repository <Mst_Country>().GetAll().Where(el => el.CountryID == model.CountryID).Select(el => el.CountryName).FirstOrDefault();
                    }
                    if (model.CountryOfResidanceID != 0)
                    {
                        model.CountryOfResidance = db.Repository <Mst_Country>().GetAll().Where(el => el.CountryID == model.CountryOfResidanceID).Select(el => el.CountryName).FirstOrDefault();
                    }

#if DEBUG
                    model.UploadedPicturePath = model.UploadedPicturePath != null?model.UploadedPicturePath.Replace("~", "..") : null;

                    model.Desc4 = model.Desc4 != null?model.Desc4.Replace("~", "..") : null;

                    model.Desc3 = model.PassportCoptyPath != null?model.PassportCoptyPath.Replace("~/Participant/" + model.MeetingName + "/", "") : null;

                    model.PassportCoptyPath = model.PassportCoptyPath != null?model.PassportCoptyPath.Replace("~/", "") : null;
#else
                    model.UploadedPicturePath = model.UploadedPicturePath?.Replace("~", CommonOperations.FilePath);
                    model.PassportCoptyPath   = model.PassportCoptyPath?.Replace("~", CommonOperations.FilePath);
                    model.PassportCoptyPath   = model.PassportCoptyPath?.Replace("~", CommonOperations.FilePath);
#endif
                }
            }
            return(model);
        }
Пример #18
0
        public PreviewDetails GetPreviewDetails(int userDetailsID)
        {
            PreviewDetails model = new PreviewDetails();

            using (OCASIAMeetingUOW db = new OCASIAMeetingUOW())
            {
                model.Guests = db.Repository <UserDetail>().GetAll().Where(el => (el.UserDetailID == userDetailsID || el.GuestOf == userDetailsID.ToString()) && el.IsActive).
                               Select(el => new UserDetailsModel()
                {
                    UserDetailID            = el.UserDetailID,
                    GuestOf                 = el.GuestOf,
                    AddressLine1            = el.AddressLine1,
                    AddressLine2            = el.AddressLine2,
                    AssitantEmail           = el.AssitantEmail,
                    City                    = el.City,
                    Company                 = el.Company,
                    Desc4                   = el.Desc4,
                    DOB                     = el.DOB,
                    Email                   = el.Email,
                    ExpiryDate              = el.ExpiryDate,
                    FamilyName              = el.FamilyName,
                    FirstLastName           = el.FirstLastName,
                    Gender                  = el.Gender,
                    GivenName               = el.GivenName,
                    IsGust                  = el.IsGust == null ? false : el.IsGust.Value,
                    IssueDate               = el.IssueDate,
                    Nationality             = el.Nationality,
                    Organization            = el.Organization,
                    OrganizationDesignation = el.OrganizationDesignation,
                    OrganizationFunction    = el.Organization,
                    PassportCoptyPath       = el.PassportCoptyPath,
                    PassportNumber          = el.PassportNumber,
                    PostalCode              = el.PostalCode,
                    StateProvince           = el.StateProvince,
                    TelephoneNumber         = el.TelephoneNumber,
                    Title                   = el.Titles.TitleName,
                    UploadedPicturePath     = el.UploadedPicturePath,
                    CountryID               = el.CountryID == null ? 0 : el.CountryID.Value,
                    CountryOfResidanceID    = el.CountryOfResidanceID == null ? 0 : el.CountryOfResidanceID.Value
                }).ToList();
                if (model.Guests == null && model.Guests.Count == 0)
                {
                    return(null);
                }
                if (model.Guests.Where(el => el.IsGust != true && !string.IsNullOrEmpty(el.PassportNumber)).Count() > 0)
                {
                    model.IsPersonalFilled = true;
                }

                if (model.Guests.Where(el => el.IsGust == true && !string.IsNullOrEmpty(el.PassportNumber)).Count() > 0)
                {
                    model.IsGuestsFilled = true;
                }
                model.Travel = db.Repository <TravelDetail>().GetAll().Where(el => el.UserDetailID == userDetailsID && el.IsActive).Select(el =>
                                                                                                                                           new TravelDetailsModel()
                {
                    TravelDetailID      = el.TravelDetailID,
                    NoCheckInBages      = el.NoCheckInBages,
                    PhoneNumber         = el.PhoneNumber,
                    Address             = el.Address,
                    ArrivalAirport      = el.ArrivalAirport,
                    ArrivalTime         = el.ArrivalTime,
                    Comments            = el.Comments,
                    DepartureDate       = el.DepartureDate,
                    DeparturelAirport   = el.DeparturelAirport,
                    DepartureTime       = el.DepartureTime,
                    ArrivalDate         = el.ArrivalDate,
                    ArrivalFlightNumber = el.ArrivalFlightNumber,
                    ReadOnly            = el.UserDetails.IsSubmitted == null ? false : el.UserDetails.IsSubmitted.Value
                }).FirstOrDefault();
                if (model.Travel != null)
                {
                    model.IsTravelFilled = true;
                }
                model.ShowSubmitButton = model.Travel?.ReadOnly == null ? true : false;

                model.Guests.ForEach(el =>
                {
                    el.ReadOnly = model.Travel?.ReadOnly == null ? false : true;
                    if (el.CountryID != 0)
                    {
                        el.CountryName = db.Repository <Mst_Country>().GetAllReffByID(inner => inner.CountryID == el.CountryID).Select(inner => inner.CountryName).FirstOrDefault();
                    }
                    if (el.CountryOfResidanceID != 0)
                    {
                        el.CountryOfResidance = db.Repository <Mst_Country>().GetAllReffByID(inner => inner.CountryID == el.CountryOfResidanceID).Select(inner => inner.CountryName).FirstOrDefault();
                    }

#if DEBUG
                    el.UploadedPicturePath = "../Content/banners.jpg";
                    el.Desc4             = "../Content/banners.jpg";
                    el.PassportCoptyPath = "../Content/banners.jpg";
#else
                    el.UploadedPicturePath = model.UploadedPicturePath?.Replace("~", CommonOperations.FilePath);
                    el.PassportCoptyPath   = model.PassportCoptyPath?.Replace("~", CommonOperations.FilePath);
                    el.PassportCoptyPath   = model.PassportCoptyPath?.Replace("~", CommonOperations.FilePath);
#endif
                });
            }
            return(model);
        }