public bool UpdateProfile(Model.Profile profile)
        {
            var returnValue = false;

            try
            {
                var profil = _dbContext.Profile.Where(x => x.Id == profile.ProfileId).SingleOrDefault();
                if (profil != null)
                {
                    profil.Firstname    = profile.Firstname;
                    profil.Middlename   = profile.Middlename;
                    profil.Lastname     = profile.Lastname;
                    profil.GenderId     = profile.GenderId;
                    profil.ModifiedBy   = _username;
                    profil.ModifiedDate = DateTime.Now;
                    _dbContext.Profile.Add(profil);
                    var result = _dbContext.SaveChanges();
                    if (result == 1)
                    {
                        returnValue = true;
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(returnValue);
        }
        public bool AddProfile(Model.Profile profile)
        {
            var returnValue = false;

            try
            {
                var pro = new Profile
                {
                    Id          = Guid.NewGuid(),
                    Firstname   = profile.Firstname,
                    Middlename  = profile.Middlename,
                    Lastname    = profile.Lastname,
                    GenderId    = profile.GenderId,
                    StatusId    = Guid.Parse(Constants.ACTIVESTATUS),
                    CreatedBy   = _username,
                    CreatedDate = DateTime.Now
                };
                _dbContext.Profile.Add(pro);
                var result = _dbContext.SaveChanges();
                if (result == 1)
                {
                    returnValue = true;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(returnValue);
        }
        public Model.Profile FetchProfileById(Guid profileId)
        {
            var profile = new Model.Profile();

            try
            {
                var activeStatatus = Guid.Parse(Constants.ACTIVESTATUS);
                profile = _dbContext.Profile.Where(x => x.Id == profileId && x.StatusId == activeStatatus)
                          .Select(x => new Model.Profile
                {
                    ProfileId  = x.Id,
                    Firstname  = x.Firstname,
                    Middlename = x.Middlename,
                    Lastname   = x.Lastname,
                    Gender     = x.Gender.Name
                }).SingleOrDefault();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(profile);
        }