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