public async Task <IActionResult> PostInterviewDetails([FromBody] TblInterviewDetails tblInterviewDetails)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            _context.TblInterviewDetails.Add(tblInterviewDetails);
            await _context.SaveChangesAsync();

            return(CreatedAtAction("GetTblInterviewDetails", new { id = tblInterviewDetails.ApplicationId }, tblInterviewDetails));
        }
        public async Task <IActionResult> PutInterviewDetails([FromRoute] int id, [FromBody] Update details)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != details.CandidateId)
            {
                return(BadRequest());
            }
            TblInterviewDetails tblInterviewDetails = _context.TblInterviewDetails.Where(x => x.CandidateId == details.CandidateId).FirstOrDefault();

            if (details.EmployeeRole == "HR" || details.EmployeeRole == "hr")
            {
                tblInterviewDetails.Hrinterviewer = details.EmployeeId;
                tblInterviewDetails.Status        = tblInterviewDetails.Status + 1;
                tblInterviewDetails.Comments      = details.Comments;
            }
            if (details.EmployeeRole == "IT" || details.EmployeeRole == "it")
            {
                tblInterviewDetails.Itinterviewer = details.EmployeeId;
                tblInterviewDetails.Status        = tblInterviewDetails.Status + 1;
                foreach (Mark mark in details.Marks)
                {
                    _context.TblSkills.Add(new TblSkills
                    {
                        CandidateId = details.CandidateId,
                        CourseId    = mark.CourseID,
                        Marks       = mark.Marks
                    });
                }
            }
            _context.Entry(tblInterviewDetails).State = EntityState.Modified;

            try
            {
                await _context.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!TblInterviewDetailsExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(NoContent());
        }
        public async Task <IActionResult> PostCandidate([FromBody] TblCandidate tblCandidate)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }
            TblCandidate isUser = _context.TblCandidate.Where(x => x.CandidateEmail == tblCandidate.CandidateEmail).FirstOrDefault();

            if (isUser != null)
            {
                return(Ok("Email already exist"));
            }
            //// HttpContext.Current.Server.MapPath("~/UploadedFiles")
            //var httpRequest = HttpContext.Request.Form;
            //if (httpRequest.Files.Count > 0)
            //{
            //    var docfiles = new List<string>();
            //    foreach (var file in httpRequest.Files)

            //    {
            //        var postedFile = httpRequest.Files[0];
            //        var name = httpRequest.Files[0].FileName;
            //    }
            //}

            _context.TblCandidate.Add(tblCandidate);

            try
            {
                await _context.SaveChangesAsync();
            }
            catch (DbUpdateException)
            {
                if (TblCandidateExists(tblCandidate.CandidateEmail))
                {
                    return(new StatusCodeResult(StatusCodes.Status409Conflict));
                }
                else
                {
                    throw;
                }
            }
            isUser = _context.TblCandidate.Where(x => x.CandidateEmail == tblCandidate.CandidateEmail).FirstOrDefault();
            TblInterviewDetails tblInterviewDetails = new TblInterviewDetails();

            tblInterviewDetails.CandidateId   = isUser.CandidateId;
            tblInterviewDetails.Hrinterviewer = 1;
            tblInterviewDetails.Itinterviewer = 1;
            _context.TblInterviewDetails.Add(tblInterviewDetails);
            _context.SaveChanges();
            return(Ok("Register Successful"));
        }