public async Task <InterviewTemplate> UpdateInterviewTemplate(InterviewTemplate interviewTemplate)
{
using (var connection = new SqlConnection(_AppSettings.ConnectionStrings.DefaultConnection))
{
var interviewTemplateSqlModel = _Mapper.Map <InterviewTemplateSqlModel>(interviewTemplate);
await connection.ExecuteAsync(
StoredProcedures.UpdateInterviewTemplate,
interviewTemplateSqlModel,
commandType : CommandType.StoredProcedure);
return(interviewTemplate);
}
}
public async Task <InterviewTemplate> InsertInterviewTemplate(InterviewTemplate interviewTemplate)
{
using (var connection = new SqlConnection(_AppSettings.ConnectionStrings.DefaultConnection))
{
var parameters = new DynamicParameters(
new
{
Name = interviewTemplate.Name,
});
parameters.Add("Id", dbType: DbType.Int32, direction: ParameterDirection.Output);
await connection.ExecuteAsync(
StoredProcedures.InsertInterviewTemplate,
parameters,
commandType : CommandType.StoredProcedure);
interviewTemplate.Id = parameters.Get <int>("Id").ToString();
return(interviewTemplate);
}
}
