public DataTable ListarItem(int Entidad)
{
DataTable items = new DataTable();
items = InstanceOF.Obtener_Tabla(string.Format(@"select item.id, item.Descripcion as Item, ConceptoId, concepto.Descripcion as Concepto
from item inner join concepto on item.ConceptoId = Concepto.Id
where EntidadId = " + Entidad));
return(items);
}
public DataTable Lista_Concepto(int Entidad)
{
DataTable conceptos = new DataTable();
conceptos = InstanceOF.Obtener_Tabla(string.Format(@"select id, EntidadId, Descripcion, FlagNivel, FlagTipoControl
from Concepto
where EntidadId = " + Entidad + @"
order by FlagTipoControl ASC, Descripcion"));
return(conceptos);
}
public DataTable ObtenerListaThreshold()
{
DataTable Threshold = InstanceOF.Obtener_Tabla(string.Format(@" select
transaccion.id,
Valor as Clasificacion,
MontoREC as REC,
transaccion.SegmentoId,
NombreSegmento as Segmento,
Transaccion.MontoThreshold as Monto
from
Transaccion
inner join Cliente on transaccion.ClienteId = Cliente.Id
inner join ClasificacionCredito on Cliente.ClasificacionCreditoId = ClasificacionCredito.id
left join Segmento on Cliente.SegmentoId = Segmento.Id " ));
return(Threshold);
}
public DataTable ObtenerItemConcepto(int tipo)
{
DataTable lista = new DataTable();
lista = InstanceOF.Obtener_Tabla(string.Format(@" SELECT
ITEM.Id AS [ItemId],
ITEM.Descripcion AS [Item],
Concepto.Id AS [ConceptoId],
Concepto.Descripcion AS [Concepto],
Concepto.TipoConcepto AS [Tipo]
FROM
Concepto AS CONCEPTO
inner join Item AS ITEM ON CONCEPTO.Id = ITEM.ConceptoId
WHERE
TipoConcepto = " + tipo));
return(lista);
}
public DataTable ObtenerThreshold()
{
DataTable Threshold = InstanceOF.Obtener_Tabla(string.Format(@" select
TRANSACCION.Id as Id,
GRUPO.Descripcion as Modulo,
Producto = '',
--TIPO.NombreTipoTransaccion as Nombre,
CLIENTE.NombreCliente as Nombre,
NumeroTransaccion as Operacion,
MontoREC as REC,
TRANSACCION.MontoThreshold as Threshold
from
Transaccion as TRANSACCION
inner join Cliente as CLIENTE on TRANSACCION.ClienteId = CLIENTE.Id
inner join GrupoInstrumento as GRUPO on TRANSACCION.GrupoInstrumentoId = GRUPO.Id
inner join TransaccionTipo as TIPO on TRANSACCION.TransaccionTipoId = TIPO.Id" ));
return(Threshold);
}
public DataTable Instrumento()
{
DataTable result = InstanceOF.Obtener_Tabla(string.Format("select id, GrupoInstrumentoId, Descripcion from instrumento"));
return(result);
}