public ActionResult setScheduleInterview(InterviewDto dtoInterview) { try { var result = new InterviewCore(_connection).setScheduleInterview(dtoInterview); return(Ok(result)); } catch (Exception ex) { return(StatusCode(StatusCodes.Status500InternalServerError, ex.Message.ToString())); } }
public async Task <IActionResult> ApplyToVacancy([FromBody] InterviewDto interviewDto) { if (ModelState.IsValid) { var interview = _interviewService.AddInterview(interviewDto); await _hubContext.Clients.All.SendAsync("AppliedToVacancy", interview); return(StatusCode(StatusCodes.Status201Created)); } return(BadRequest()); }
public async Task <IActionResult> UpdateInterview([FromBody] InterviewDto interviewDto) { if (ModelState.IsValid) { _interviewService.UpdateInterview(interviewDto); await _hubContext.Clients.All.SendAsync("InterviewUpdated", string.Empty); return(StatusCode(StatusCodes.Status204NoContent)); } return(BadRequest()); }
public async Task <HttpResponseMessage> PostInterview(InterviewDto interviewDto, string interviewTemplateId = null, string candidateId = null) { var queryStringBuilder = new QueryStringBuilder(); if (interviewTemplateId != null) { queryStringBuilder.AddParameter("templateId", interviewTemplateId); } if (candidateId != null) { queryStringBuilder.AddParameter("candidateId", candidateId); } return(await _HttpClient.PostAsync( $"{ApiRoutes.InterviewsRoute}{queryStringBuilder}", interviewDto.ToStringContent())); }
public object setScheduleInterview(InterviewDto dtoInterview) { using (var conexion = new SqlConnection(SqlServer.SqlServerConnection)) { conexion.Open(); using (var transaction = conexion.BeginTransaction()) { string msg = string.Empty; int value = 0; try { var result = _objInterviewDao.setScheduleInterview(transaction, dtoInterview, out msg, out value); if (value.Equals(1)) { transaction.Commit(); } else { transaction.Rollback(); } return(new ResponseDto <List <ScheduledDto> >() { value = value, msg = msg, result = result }); } catch (Exception ex) { transaction.Rollback(); msg = ex.Message.ToString(); return(new ResponseDto <List <ScheduledDto> >() { value = value, msg = msg, result = null }); } } } }
public static Interview ToInterview(this InterviewDto interviewDto) { return(new Interview(interviewDto.Date, interviewDto.Result)); }
public List <ScheduledDto> setScheduleInterview(SqlTransaction transaction, InterviewDto dtoInterview, out string msg, out int value) { msg = string.Empty; value = 0; List <SqlParameter> parameters = new List <SqlParameter>(); SqlParameter parameter1 = new SqlParameter(); parameter1.ParameterName = "@id"; parameter1.SqlDbType = SqlDbType.Int; parameter1.Direction = ParameterDirection.Input; parameter1.Value = dtoInterview.user.id; SqlParameter parameter2 = new SqlParameter(); parameter2.ParameterName = "@name"; parameter2.SqlDbType = SqlDbType.NVarChar; parameter2.Direction = ParameterDirection.Input; parameter2.Value = dtoInterview.user.name; SqlParameter parameter3 = new SqlParameter(); parameter3.ParameterName = "@user"; parameter3.SqlDbType = SqlDbType.NVarChar; parameter3.Direction = ParameterDirection.Input; parameter3.Value = dtoInterview.user.user; SqlParameter parameter4 = new SqlParameter(); parameter4.ParameterName = "@email"; parameter4.SqlDbType = SqlDbType.NVarChar; parameter4.Direction = ParameterDirection.Input; parameter4.Value = dtoInterview.user.email; SqlParameter parameter5 = new SqlParameter(); parameter5.ParameterName = "@address"; parameter5.SqlDbType = SqlDbType.NVarChar; parameter5.Direction = ParameterDirection.Input; parameter5.Value = dtoInterview.user.address; SqlParameter parameter6 = new SqlParameter(); parameter6.ParameterName = "@tel"; parameter6.SqlDbType = SqlDbType.NVarChar; parameter6.Direction = ParameterDirection.Input; parameter6.Value = dtoInterview.user.phone; SqlParameter parameter7 = new SqlParameter(); parameter7.ParameterName = "@webSite"; parameter7.SqlDbType = SqlDbType.NVarChar; parameter7.Direction = ParameterDirection.Input; parameter7.Value = dtoInterview.user.website; SqlParameter parameter8 = new SqlParameter(); parameter8.ParameterName = "@company"; parameter8.SqlDbType = SqlDbType.NVarChar; parameter8.Direction = ParameterDirection.Input; parameter8.Value = dtoInterview.user.company; SqlParameter parameter9 = new SqlParameter(); parameter9.ParameterName = "@typeInterview"; parameter9.SqlDbType = SqlDbType.Int; parameter9.Direction = ParameterDirection.Input; parameter9.Value = dtoInterview.type; SqlParameter parameter10 = new SqlParameter(); parameter10.ParameterName = "@datetime"; parameter10.SqlDbType = SqlDbType.DateTime; parameter10.Direction = ParameterDirection.Input; parameter10.Value = DateTime.Parse(dtoInterview.date); SqlParameter parameter11 = new SqlParameter(); parameter11.ParameterName = "@msg"; parameter11.SqlDbType = SqlDbType.NVarChar; parameter11.Direction = ParameterDirection.Output; parameter11.Size = 200; parameter11.Value = string.Empty; SqlParameter parameter12 = new SqlParameter(); parameter12.ParameterName = "@ReturnValue"; parameter12.SqlDbType = SqlDbType.Int; parameter12.Direction = ParameterDirection.ReturnValue; parameters.Add(parameter1); parameters.Add(parameter2); parameters.Add(parameter3); parameters.Add(parameter4); parameters.Add(parameter5); parameters.Add(parameter6); parameters.Add(parameter7); parameters.Add(parameter8); parameters.Add(parameter9); parameters.Add(parameter10); parameters.Add(parameter11); parameters.Add(parameter12); string procedure = @"[dbo].[ScheduleInterview]"; var dt = SqlServer.GetQueryResult(transaction, procedure, parameters); msg = parameter11.Value.ToString(); value = int.Parse(parameter12.Value.ToString()); var result = (from dr in dt.AsEnumerable() select new ScheduledDto { id = int.Parse(dr["code"].ToString()), name = dr["name"].ToString(), user = dr["user"].ToString(), email = dr["email"].ToString(), address = dr["address"].ToString(), phone = dr["tel"].ToString(), website = dr["website"].ToString(), company = dr["company"].ToString(), interview = dr["interview"].ToString(), }).ToList(); return(result); }
public void UpdateInterview(InterviewDto interviewDto) { _interviewRepository.UpdateInterview(_mapper.Map <InterviewDto, Interview>(interviewDto)); }
public InterviewDto AddInterview(InterviewDto interviewDto) { return(_mapper.Map <Interview, InterviewDto>(_interviewRepository.AddInterview( _mapper.Map <InterviewDto, Interview>(interviewDto)))); }
public object setScheduleInterview(InterviewDto dtoInterview) { return(_objInterviewTransactionDao.setScheduleInterview(dtoInterview)); }