public Planillas GetOne(Int16 EMPR_Codigo, String PLAN_Tipo, String PLAN_Codigo)
{
try
{
if (EMPR_Codigo == null || PLAN_Tipo == null || PLAN_Codigo == null)
{
return(null);
}
Entities.Planillas _planilla = SelectOne(EMPR_Codigo, PLAN_Tipo, PLAN_Codigo);
if (_planilla != null)
{
ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> _listFilters = new ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL>();
_listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL()
{
FilterName = "@psinEMPR_Codigo", FilterValue = _planilla.EMPR_Codigo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Int16, FilterSize = 2
});
_listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL()
{
FilterName = "@pchrPLAN_Tipo", FilterValue = _planilla.PLAN_Tipo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Varchar, FilterSize = 3
});
_listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL()
{
FilterName = "@pvchPLAN_Codigo", FilterValue = _planilla.PLAN_Codigo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Varchar, FilterSize = 20
});
_planilla.ListMovimiento = BL_Movimiento.GetAllFilter("CAJ_MOVISS_EgresosPorPlanilla", _listFilters);
_planilla.ListDetCtaCte = BL_DetCtaCte.GetAllFilter("CAJ_DCCTSS_TodosPorPlanilla", _listFilters);
_planilla.Monto = _planilla.ListDetCtaCte.Sum(Det => Det.CCCT_Pendiente).Value;
}
return(_planilla);
}
catch (Exception)
{ throw; }
}
public Transferencia GetOne(Int16 EMPR_Codigo, Int32 TRAN_Codigo)
{
try
{
if (EMPR_Codigo == null || TRAN_Codigo == null)
{
return(null);
}
Transferencia _transferencia = SelectOne(EMPR_Codigo, TRAN_Codigo);
if (_transferencia != null)
{
/*
* Cargar los detalles
*/
ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> listFilters = new ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL>();
listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL()
{
FilterName = "@psinEMPR_Codigo", FilterValue = EMPR_Codigo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Int16, FilterSize = 2
});
listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL()
{
FilterName = "@pintTRAN_Codigo", FilterValue = TRAN_Codigo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Int32, FilterSize = 4
});
_transferencia.ListEgresos = BL_Movimiento.GetAllFilter("CAJ_MOVISS_EgresosPorTransferencia", listFilters);
_transferencia.ListIngresos = BL_Movimiento.GetAllFilter("CAJ_MOVISS_IngresosPorTransferencia", listFilters);
_transferencia.ListGastosBancarios = BL_GastosBancarios.GetAllFilter("CAJ_GBANSS_TodosPorTransferencia", listFilters);
}
return(_transferencia);
}
catch (Exception)
{ throw; }
}
