예제 #1
0
        public List <SimpleJobPost> Get(String Username, [FromUri] int count)
        {
            JinderDBConnection dbContext = new JinderDBConnection();
            var usersTable = dbContext.JinderUsers;

            JinderUser jinderUser = (from user in usersTable
                                     where user.Username == Username
                                     select user).FirstOrDefault <JinderUser>();

            if (jinderUser.UserType != "seeker")
            {
                throw new Exception("JinderUser with username: "******" is not a seeker!");
            }

            var viewedJobPostIds = from id in dbContext.SeekerExpressionLogs
                                   where id.SeekerId == jinderUser.JinderUserId
                                   select id.JobPostId;

            var notViewedJobPosts = (from jobPost in dbContext.JobPosts
                                     where !viewedJobPostIds.Contains <int>(jobPost.JobPostId)
                                     select jobPost).Take <JobPost>(count);

            List <SimpleJobPost> simpleJobPosts = new List <SimpleJobPost>();

            foreach (JobPost post in notViewedJobPosts)
            {
                simpleJobPosts.Add(SimpleJobPost.getSimpleJobPost(post));
            }

            return(simpleJobPosts);
        }
예제 #2
0
        public List <JinderSeeker> Get(String Username, [FromUri] int count, int dummy = 0)
        {
            JinderDBConnection dbContext = new JinderDBConnection();
            var usersTable = dbContext.JinderUsers;

            JinderUser jinderUser = (from user in usersTable
                                     where user.Username == Username
                                     select user).FirstOrDefault <JinderUser>();

            if (jinderUser.UserType != "poster")
            {
                throw new Exception("JinderUser with username: "******" is not a poster!");
            }

            var viewedSeekerIds = from log in dbContext.PosterExpressionLogs
                                  where log.PosterId == jinderUser.JinderUserId
                                  select log.SeekerId;


            var notViewedSeekers = (from seeker in dbContext.JinderUsers
                                    where seeker.UserType == "seeker" &&
                                    !viewedSeekerIds.Contains <int>(seeker.JinderUserId)
                                    select seeker).Take <JinderUser>(count);

            List <JinderSeeker> jinderSeekers = new List <JinderSeeker>();

            foreach (JinderUser seeker in notViewedSeekers)
            {
                jinderSeekers.Add(JinderSeeker.getJinderSeeker(seeker));
            }

            return(jinderSeekers);
        }
예제 #3
0
        public HttpResponseMessage Post([FromBody] SignupInfo info)
        {
            JinderDBConnection dbContext = new JinderDBConnection();
            var usersTable = dbContext.JinderUsers;

            JinderUser jinderUser = (from user in usersTable
                                     where user.Username == info.Username
                                     select user).FirstOrDefault <JinderUser>();

            HttpResponseMessage message = new HttpResponseMessage();

            if (jinderUser != null)
            {
                message.StatusCode = HttpStatusCode.Conflict;
                message.Content    = new StringContent("Username: "******" is already registered.");

                return(message);
            }

            JinderUser newUser = new JinderUser();

            newUser.Username       = info.Username;
            newUser.Password       = info.Password;
            newUser.FullName       = info.FullName;
            newUser.DateOfBirth    = info.DateOfBirth;
            newUser.ProfilePicture = info.ProfilePicture;
            newUser.Gender         = info.Gender;
            newUser.Address        = info.Address;
            newUser.UserType       = info.UserType;

            usersTable.Add(newUser);
            dbContext.SaveChanges();

            if (info.UserType == "seeker")
            {
                SeekerProfile newSeekerProfile = new SeekerProfile();
                newSeekerProfile.JinderUserId  = newUser.JinderUserId;
                newSeekerProfile.Education     = info.Education;
                newSeekerProfile.Experience    = info.Experience;
                newSeekerProfile.Skills        = info.Skills;
                newSeekerProfile.Certification = info.Certification;

                var seekersTable = dbContext.SeekerProfiles;
                seekersTable.Add(newSeekerProfile);

                dbContext.SaveChanges();
            }

            message.StatusCode = HttpStatusCode.Created;
            return(message);
        }
예제 #4
0
        public HttpResponseMessage Post([FromBody] LoginInfo loginInfo)
        {
            JinderDBConnection  db      = new JinderDBConnection();
            HttpResponseMessage message = new HttpResponseMessage();

            // Try to get user
            JinderUser jinderUser = (from user in db.JinderUsers
                                     where user.Username == loginInfo.Username &&
                                     user.Password == loginInfo.Password
                                     select user).FirstOrDefault();

            if (jinderUser == null)
            {
                message.StatusCode = HttpStatusCode.BadRequest;
                return(message);
            }


            message.StatusCode = HttpStatusCode.OK;
            return(message);
        }
예제 #5
0
        public static JinderSeeker getJinderSeeker(JinderUser user)
        {
            if (user.UserType != "seeker")
            {
                throw new Exception("Provided JinderUser: "******" is not a seeker!");
            }

            JinderDBConnection dbContext     = new JinderDBConnection();
            SeekerProfile      seekerProfile = (from profile in dbContext.SeekerProfiles
                                                where profile.JinderUserId == user.JinderUserId
                                                select profile).FirstOrDefault <SeekerProfile>();

            if (seekerProfile == null)
            {
                throw new Exception("Could not find a SeekerProfile for JinderUser: " + user.Username);
            }

            JinderSeeker jinderSeeker = new JinderSeeker();

            jinderSeeker.JinderUserId   = user.JinderUserId;
            jinderSeeker.FullName       = user.FullName;
            jinderSeeker.DateOfBirth    = user.DateOfBirth;
            jinderSeeker.ProfilePicture = user.ProfilePicture;
            jinderSeeker.Gender         = user.Gender;
            jinderSeeker.Address        = user.Address;
            jinderSeeker.UserType       = user.UserType;
            jinderSeeker.Password       = user.Password;
            jinderSeeker.Username       = user.Username;

            jinderSeeker.SeekerProfileId = seekerProfile.SeekerProfileId;
            jinderSeeker.Education       = seekerProfile.Education;
            jinderSeeker.Experience      = seekerProfile.Experience;
            jinderSeeker.Skills          = seekerProfile.Skills;
            jinderSeeker.Certification   = seekerProfile.Certification;

            return(jinderSeeker);
        }