コード例 #1
0
        public List <InterviewDetails> GetAllInterview()
        {
            List <InterviewDetails> allInterviews = new List <InterviewDetails>();

            using (var conn = GetConnection())
            {
                var comm = new SqlCommand("dbo.uspInterview_Get", conn);
                comm.CommandType = CommandType.StoredProcedure;
                conn.Open();

                using (var dr = comm.ExecuteReader())
                {
                    while (dr.Read())
                    {
                        var interview = new InterviewDetails
                        {
                            JobTitle        = dr["JobTitle"].ToString(),
                            Department      = dr["JobDepartment"].ToString(),
                            CandidateName   = dr["CandidateName"].ToString(),
                            HiringManager   = dr["HiringManager"].ToString(),
                            InterviewDate   = dr["Interviewdate"].ToString(),
                            InterviewStatus = dr["InterviewStatus"].ToString(),
                            InterviewId     = (int)dr["InterviewId"]
                        };

                        allInterviews.Add(interview);
                    }
                }
                return(allInterviews);
            }
        }
コード例 #2
0
        public async Task <ApiResponse> Handle(AddInterviewDetailsCommand request, CancellationToken cancellationToken)
        {
            ApiResponse response = new ApiResponse();

            try
            {
                if (request != null)
                {
                    InterviewDetails obj = _mapper.Map <InterviewDetails>(request);
                    obj.InterviewStatus = null; //Approve - Reject Flag
                    obj.CreatedById     = request.CreatedById;
                    obj.CreatedDate     = request.CreatedDate;
                    obj.IsDeleted       = false;
                    await _dbContext.InterviewDetails.AddAsync(obj);

                    //Rating Based Criteria
                    foreach (var item in request.RatingBasedCriteriaList)
                    {
                        RatingBasedCriteria ratingobj = new RatingBasedCriteria();
                        ratingobj.InterviewDetailsId = obj.InterviewDetailsId;
                        ratingobj.CriteriaQuestion   = item.CriteriaQuestion;
                        ratingobj.Rating             = item.Rating;
                        ratingobj.CreatedById        = request.CreatedById;
                        ratingobj.CreatedDate        = request.CreatedDate;
                        ratingobj.IsDeleted          = false;
                        await _dbContext.RatingBasedCriteria.AddAsync(ratingobj);
                    }

                    foreach (var item in request.InterviewLanguageModelList)
                    {
                        InterviewLanguages IL = new InterviewLanguages();
                        IL.InterviewDetailsId = obj.InterviewDetailsId;
                        IL.LanguageName       = item.LanguageName;
                        IL.LanguageId         = item.LanguageId;
                        IL.Reading            = item.Reading;
                        IL.Writing            = item.Writing;
                        IL.Listening          = item.Listening;
                        IL.Speaking           = item.Speaking;
                        IL.CreatedById        = request.CreatedById;
                        IL.CreatedDate        = request.CreatedDate;
                        IL.IsDeleted          = false;
                        await _dbContext.InterviewLanguages.AddAsync(IL);
                    }

                    foreach (var item in request.InterviewTechQuesModelList)
                    {
                        InterviewTechnicalQuestion itq = new InterviewTechnicalQuestion();
                        itq.InterviewDetailsId = obj.InterviewDetailsId;
                        itq.Question           = item.Question;
                        itq.Answer             = item.Answer;
                        itq.CreatedById        = request.CreatedById;
                        itq.CreatedDate        = request.CreatedDate;
                        itq.IsDeleted          = false;
                        await _dbContext.InterviewTechnicalQuestion.AddAsync(itq);
                    }

                    foreach (var item in request.InterviewTrainingModelList)
                    {
                        InterviewTrainings it = new InterviewTrainings();
                        it.InterviewDetailsId = obj.InterviewDetailsId;
                        it.TraininigType      = item.TraininigType;
                        it.TrainingName       = item.TrainingName;
                        it.StudyingCountry    = item.StudyingCountry;
                        it.StartDate          = item.StartDate;
                        it.EndDate            = item.EndDate;
                        it.CreatedById        = request.CreatedById;
                        it.CreatedDate        = request.CreatedDate;
                        it.IsDeleted          = false;
                        await _dbContext.InterviewTrainings.AddAsync(it);
                    }

                    foreach (var employeeId in request.Interviewers)
                    {
                        HRJobInterviewers hRJobInterviewers = new HRJobInterviewers();

                        hRJobInterviewers.CreatedDate        = request.CreatedDate;
                        hRJobInterviewers.CreatedById        = request.CreatedById;
                        hRJobInterviewers.EmployeeId         = employeeId.Interviewer;
                        hRJobInterviewers.InterviewDetailsId = obj.InterviewDetailsId;
                        hRJobInterviewers.IsDeleted          = false;
                        await _dbContext.HRJobInterviewers.AddAsync(hRJobInterviewers);
                    }

                    await _dbContext.SaveChangesAsync();

                    response.StatusCode = StaticResource.successStatusCode;
                    response.Message    = "Success";
                }
            }
            catch (Exception ex)
            {
                response.StatusCode = StaticResource.failStatusCode;
                response.Message    = ex.Message;
            }
            return(response);
        }