private async Task <int> CreateConcepto(ConceptoDTO concepto, CancellationToken cancellationToken) { var result = Parameters.CreateOutputParameter("@result", SqlDbType.Int); var parameters = new SqlParameter[] { Parameters.CreateParameter("@conCodigo", concepto.Codigo, ParameterDirection.Input, SqlDbType.VarChar), Parameters.CreateParameter("@conNombre", concepto.Nombre, ParameterDirection.Input, SqlDbType.VarChar), Parameters.CreateParameter("@conParametro", concepto.Parametro, ParameterDirection.Input, SqlDbType.VarChar), Parameters.CreateParameter("@conTipo", concepto.Tipo, ParameterDirection.Input, SqlDbType.VarChar), Parameters.CreateParameter("@conInactivo", false, ParameterDirection.Input, SqlDbType.Bit), result }; await this._dbContext.Database.ExecuteSqlCommandAsync( $@"EXECUTE {procs.CREATE_CONCEPTO} @conCodigo,@conNombre,@conParametro,@conTipo,@conInactivo,@result OUTPUT", parameters, cancellationToken); return(int.Parse(result.Value.ToString())); }
public Task Insert(ConceptoDTO obj) { throw new NotImplementedException(); }