public ObservableCollection <Tipos> GetAllTiposFilter(String x_procedure, ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> x_filters) { try { return(BL_Tipos.GetAllFilter(x_procedure, x_filters)); } catch (Exception) { throw; } }
public ObservableCollection <Tipos> GetAllTiposByTipoCodTabla(String TIPO_CodTabla) { try { return(BL_Tipos.GetAllByTipoCodTabla(TIPO_CodTabla)); } catch (Exception ex) { throw ex; } }
public Boolean SaveAnular(ref Movimiento Item) { try { Boolean m_isCorrect = true; DataAccessEnterpriseSQL.DABeginTransaction(); Item.SetEstado(Movimiento.Estado.Anulado); m_isCorrect = UpdateAnular(ref Item); if (Item != null && m_isCorrect) { ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> listFilters = new ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL>(); listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@psinEMPR_Codigo", FilterValue = Item.EMPR_Codigo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Int16, FilterSize = 2 }); listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pintMOVI_Codigo", FilterValue = Item.MOVI_Codigo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Int32, FilterSize = 4 }); Item.ListDetCtaCte = BL_DetCtaCte.GetAllFilter("CAJ_DCCTSS_TodosPorMovimiento", listFilters); Item.TIPO_Movimiento = BL_Tipos.GetOne(Item.TIPO_TabMOV, Item.TIPO_CodMOV); foreach (DetCtaCte iDetCtaCte in Item.ListDetCtaCte) { if (iDetCtaCte.DCCT_MontoDebe < iDetCtaCte.DCCT_MontoHaber) { iDetCtaCte.DCCT_MontoDebe = iDetCtaCte.DCCT_MontoHaber; iDetCtaCte.DCCT_MontoHaber = 0; iDetCtaCte.DCCT_MontoDebeD = iDetCtaCte.DCCT_MontoHaberD; iDetCtaCte.DCCT_MontoHaberD = 0; } else if (iDetCtaCte.DCCT_MontoDebe > iDetCtaCte.DCCT_MontoHaber) { iDetCtaCte.DCCT_MontoHaber = iDetCtaCte.DCCT_MontoDebe; iDetCtaCte.DCCT_MontoDebe = 0; iDetCtaCte.DCCT_MontoHaberD = iDetCtaCte.DCCT_MontoDebeD; iDetCtaCte.DCCT_MontoDebeD = 0; } iDetCtaCte.Instance = InstanceEntity.Added; iDetCtaCte.AUDI_UsrCrea = Item.AUDI_UsrMod; iDetCtaCte.CONS_TabTDC = Infrastructure.Aspect.Constants.Util.GetTTipoMovimientoDetCtaCte(); iDetCtaCte.CONS_CodTDC = Infrastructure.Aspect.Constants.Util.GetTTipoMovimientoDetCtaCte(Infrastructure.Aspect.Constants.TTipoMovimientoDetCtaCte.Extorno); Entities.DetCtaCte _detCtaCte = iDetCtaCte; BL_DetCtaCte.Save(ref _detCtaCte); } GAsientos genAsientos = new GAsientos(GAsientos.TipoAsiento.AsientoCaja); genAsientos.ItemMovimiento = Item; genAsientos.Anular(Item.AUDI_UsrMod, GAsientos.TipoItem.Movimiento); } if (m_isCorrect) { DataAccessEnterpriseSQL.DACommitTransaction(); } else { DataAccessEnterpriseSQL.DARollbackTransaction(); } return(m_isCorrect); } catch (Exception) { DataAccessEnterpriseSQL.DARollbackTransaction(); throw; } }