// Basic public async Task <int> AddAsync(CompanyCreditCardEntity companyCreditCardEntity) { int indicator = -1; try { var dynamicParameters = new DynamicParameters(companyCreditCardEntity); dynamicParameters.Add("CompanyCreditCardId", DbType.Int32, direction: ParameterDirection.Output); using (var connection = new SqlConnection(_connectionString)) { indicator = await connection.ExecuteAsync( _mainCommandText.AddCompanyCreditCard, dynamicParameters, commandType : CommandType.StoredProcedure ); companyCreditCardEntity.CompanyCreditCardId = dynamicParameters.Get <int>("CompanyCreditCardId"); } } catch (Exception exception) { } return(indicator); }
public async Task <CompanyCreditCardEntity> GetByIdAsync(int companyCreditCardId) { var rs = new CompanyCreditCardEntity(); try { using (var connection = new SqlConnection(_connectionString)) { rs = await connection.QueryFirstOrDefaultAsync <CompanyCreditCardEntity>( _mainCommandText.GetCompanyCreditCardById, new { CompanyCreditCardId = companyCreditCardId }, commandType : CommandType.StoredProcedure ); } } catch (Exception exception) { } return(rs); }
public async Task <int> UpdateAsync(CompanyCreditCardEntity companyCreditCardEntity) { int indicator = -1; try { var dynamicParameters = new DynamicParameters(companyCreditCardEntity); using (var connection = new SqlConnection(_connectionString)) { indicator = await connection.ExecuteAsync( _mainCommandText.UpdateCompanyCreditCard, dynamicParameters, commandType : CommandType.StoredProcedure ); } } catch (Exception exception) { } return(indicator); }
public async Task <int> UpdateAsync(CompanyCreditCardEntity companyCreditCardEntity) { return(await _companyCreditCardRepository.UpdateAsync(companyCreditCardEntity)); }