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