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));
}
