public BLDet_Operacion(IUnityContainer container) { this.ContainerService = container; Loader = new BusinessEntityLoader <Det_Operacion>(); Det_Operacion item = new Det_Operacion(); Loader.EntityType = item.GetType(); }
private bool Update(Det_Operacion item) { try { if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified) { DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_DOPESU_UnReg"); DataAccessEnterpriseSQL.DAAgregarParametro("@pintDOPE_Item", item.DOPE_Item, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintCOPE_Codigo", item.COPE_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@psinDTAR_Item", item.DTAR_Item, SqlDbType.SmallInt, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintCTAR_Codigo", item.CTAR_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCTAR_Tipo", item.CTAR_Tipo, SqlDbType.Char, 1, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintPACK_Codigo", item.PACK_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_CodBas", item.CONS_CodBas, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_TabBas", item.CONS_TabBas, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@psinDOPE_Cantidad", item.DOPE_Cantidad, SqlDbType.SmallInt, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecDOPE_PrecioUnitCosto", item.DOPE_PrecioUnitCosto, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecDOPE_PrecioTotCosto", item.DOPE_PrecioTotCosto, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecDOPE_PrecioUnitVta", item.DOPE_PrecioUnitVta, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecDOPE_PrecioTotVta", item.DOPE_PrecioTotVta, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecDOPE_Minimo", item.DOPE_Minimo, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pnumDOPE_Peso", item.DOPE_Peso, SqlDbType.Decimal, 12, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pnumDOPE_Volumen", item.DOPE_Volumen, SqlDbType.Decimal, 12, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecDOPE_CostoSada", item.DOPE_CostoSada, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecDOPE_Costo", item.DOPE_Costo, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecDOPE_VentaSada", item.DOPE_VentaSada, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecDOPE_Venta", item.DOPE_Venta, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_TabZON", item.TIPO_TabZON, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_CodZONOrigen", item.TIPO_CodZONOrigen, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_CodTRA", item.CONS_CodTRA, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_TabTRA", item.CONS_TabTRA, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_CodZONDestino", item.TIPO_CodZONDestino, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@psinTIPE_Codigo", item.TIPE_Codigo, SqlDbType.SmallInt, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintENTC_Codigo", item.ENTC_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_CodEST", item.CONS_CodEST, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_TabEST", item.CONS_TabEST, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchUSR_UsrMod", item.USR_UsrMod, SqlDbType.VarChar, 20, ParameterDirection.Input); if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0) { return(true); } else { return(false); } } else { return(true); } } catch (Exception ex) { throw ex; } }
public Boolean SaveDet_Operacion(ref Det_Operacion Item) { try { if (Item.Instance != Infrastructure.Aspect.BusinessEntity.InstanceEntity.Unchanged) { return(BL_Det_Operacion.Save(ref Item)); } return(true); } catch (Exception) { throw; } }
public Boolean Save(Det_Operacion Item) { try { Boolean m_isCorrect = true; if (Item.Trasanct) { Infrastructure.Aspect.DataAccess.DataAccessEnterpriseSQL.DABeginTransaction(); switch (Item.Instance) { case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added: m_isCorrect = Insert(Item); break; case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified: m_isCorrect = Update(Item); break; case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted: m_isCorrect = Delete(Item); break; } if (m_isCorrect) { Infrastructure.Aspect.DataAccess.DataAccessEnterpriseSQL.DACommitTransaction(); } else { Infrastructure.Aspect.DataAccess.DataAccessEnterpriseSQL.DARollbackTransaction(); } return(m_isCorrect); } else { switch (Item.Instance) { case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added: m_isCorrect = Insert(Item); break; case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified: m_isCorrect = Update(Item); break; case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted: m_isCorrect = Delete(Item); break; } return(m_isCorrect); } } catch (Exception) { Infrastructure.Aspect.DataAccess.DataAccessEnterpriseSQL.DARollbackTransaction(); throw; } }
private bool Delete(Det_Operacion item) { try { if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted) { DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_DOPESD_UnReg"); DataAccessEnterpriseSQL.DAAgregarParametro("@pintDOPE_Item", item.DOPE_Item, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintCOPE_Codigo", item.COPE_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAExecuteNonQuery(); return(true); } else { return(true); } } catch (Exception ex) { throw ex; } }
private Det_Operacion SelectOne(Int32 DOPE_Item, Int32 COPE_Codigo) { try { Det_Operacion item = new Det_Operacion(); DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_DOPESS_UnReg"); DataAccessEnterpriseSQL.DAAgregarParametro("@pintDOPE_Item", DOPE_Item, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintCOPE_Codigo", COPE_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader()) { if (reader.Read()) { Loader.LoadEntity(reader, item); item.Instance = InstanceEntity.Unchanged; } } return(item); } catch (Exception ex) { throw ex; } }
private ObservableCollection <Det_Operacion> SelectAllByOperacion(Int32 x_COPE_Codigo) { try { ObservableCollection <Det_Operacion> items = new ObservableCollection <Det_Operacion>(); Det_Operacion item = new Det_Operacion(); DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_DOPESS_TodosByOperacion"); DataAccessEnterpriseSQL.DAAgregarParametro("@pintCOPE_Codigo", x_COPE_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader()) { while (reader.Read()) { item = new Det_Operacion(); Loader.LoadEntity(reader, item); item.Instance = InstanceEntity.Unchanged; items.Add(item); } } return(items); } catch (Exception ex) { throw ex; } }
private bool Insert(Det_Operacion item) { try { if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added) { DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_DOPESI_UnReg"); DataAccessEnterpriseSQL.DAAgregarParametro("@pintDOPE_Item", item.DOPE_Item, SqlDbType.Int, 4, ParameterDirection.InputOutput); DataAccessEnterpriseSQL.DAAgregarParametro("@pintCOPE_Codigo", item.COPE_Codigo, SqlDbType.Int, 4, ParameterDirection.InputOutput); DataAccessEnterpriseSQL.DAAgregarParametro("@psinDTAR_Item", item.DTAR_Item, SqlDbType.SmallInt, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintCTAR_Codigo", item.CTAR_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCTAR_Tipo", item.CTAR_Tipo, SqlDbType.Char, 1, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintPACK_Codigo", item.PACK_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_CodBas", item.CONS_CodBas, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_TabBas", item.CONS_TabBas, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@psinDOPE_Cantidad", item.DOPE_Cantidad, SqlDbType.SmallInt, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecDOPE_PrecioUnitCosto", item.DOPE_PrecioUnitCosto, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecDOPE_PrecioTotCosto", item.DOPE_PrecioTotCosto, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecDOPE_PrecioUnitVta", item.DOPE_PrecioUnitVta, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecDOPE_PrecioTotVta", item.DOPE_PrecioTotVta, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecDOPE_Minimo", item.DOPE_Minimo, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pnumDOPE_Peso", item.DOPE_Peso, SqlDbType.Decimal, 12, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pnumDOPE_Volumen", item.DOPE_Volumen, SqlDbType.Decimal, 12, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecDOPE_CostoSada", item.DOPE_CostoSada, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecDOPE_Costo", item.DOPE_Costo, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecDOPE_VentaSada", item.DOPE_VentaSada, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdecDOPE_Venta", item.DOPE_Venta, SqlDbType.Decimal, 15, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_TabZON", item.TIPO_TabZON, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_CodZONOrigen", item.TIPO_CodZONOrigen, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_CodTRA", item.CONS_CodTRA, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_TabTRA", item.CONS_TabTRA, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_CodZONDestino", item.TIPO_CodZONDestino, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@psinTIPE_Codigo", item.TIPE_Codigo, SqlDbType.SmallInt, 2, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintENTC_Codigo", item.ENTC_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_CodEST", item.CONS_CodEST, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_TabEST", item.CONS_TabEST, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchAUDI_UsrCrea", item.AUDI_UsrCrea, SqlDbType.VarChar, 20, ParameterDirection.Input); if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0) { Int32 _DOPE_Item; if (Int32.TryParse(DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pintDOPE_Item"].Value.ToString(), out _DOPE_Item)) { item.DOPE_Item = _DOPE_Item; } Int32 _COPE_Codigo; if (Int32.TryParse(DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pintCOPE_Codigo"].Value.ToString(), out _COPE_Codigo)) { item.COPE_Codigo = _COPE_Codigo; } return(true); } else { return(false); } } else { return(true); } } catch (Exception ex) { throw ex; } }
public Boolean Save(ref Cab_Operacion Item) { try { Boolean m_isCorrect = true; Infrastructure.Aspect.DataAccess.DataAccessEnterpriseSQL.DABeginTransaction(); switch (Item.Instance) { case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added: m_isCorrect = Insert(ref Item); /* Items Detalle Operación */ if (Item.ItemsDet_Operacion != null && Item.ItemsDet_Operacion.Count > 0) { foreach (var _item in Item.ItemsDet_Operacion) { Det_Operacion _Deta = new Det_Operacion(); _Deta = _item; _Deta.COPE_Codigo = Item.COPE_Codigo; _Deta.Trasanct = false; _Deta.Instance = Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added; m_isCorrect = BLDet_Operacion.Save(_Deta); if (!m_isCorrect) { break; } } } /* Items Servicios Operación */ if (Item.ItemsDet_Operacion_Servicio != null && Item.ItemsDet_Operacion_Servicio.Count > 0) { foreach (var _itemServ in Item.ItemsDet_Operacion_Servicio) { Det_Operacion_Servicio _Servicio = new Det_Operacion_Servicio(); _Servicio = _itemServ; _Servicio.COPE_Codigo = Item.COPE_Codigo; _Servicio.Trasanct = false; _Servicio.Instance = Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added; _Servicio.AUDI_UsrCrea = Item.AUDI_UsrCrea; m_isCorrect = BLDet_Operacion_Servicio.Save(_Servicio); if (!m_isCorrect) { break; } } } break; case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified: m_isCorrect = Update(ref Item); /* Eliminar los detalles de operacion */ if (Item.ItemsDet_Operacion_Eliminados != null && Item.ItemsDet_Operacion_Eliminados.Count > 0 && m_isCorrect) { foreach (Entities.Det_Operacion iEliminados in Item.ItemsDet_Operacion_Eliminados) { iEliminados.Instance = Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted; Det_Operacion _Deta = new Det_Operacion(); _Deta = iEliminados; _Deta.COPE_Codigo = Item.COPE_Codigo; _Deta.Trasanct = false; BLDet_Operacion.Save(_Deta); //if (!m_isCorrect) { break; } } } /* Items Detalle Operación */ if (Item.ItemsDet_Operacion != null && Item.ItemsDet_Operacion.Count > 0 && m_isCorrect) { foreach (var _item in Item.ItemsDet_Operacion) { Det_Operacion _Deta = new Det_Operacion(); _Deta = _item; _Deta.COPE_Codigo = Item.COPE_Codigo; _Deta.Trasanct = false; m_isCorrect = BLDet_Operacion.Save(_Deta); if (!m_isCorrect) { break; } } } /* Eliminar Items Servicios Operación */ if (Item.ItemsDet_Operacion_Servicio_Eliminados != null && Item.ItemsDet_Operacion_Servicio_Eliminados.Count > 0 && m_isCorrect) { foreach (Entities.Det_Operacion_Servicio _itemServ in Item.ItemsDet_Operacion_Servicio_Eliminados) { Det_Operacion_Servicio _Servicio = new Det_Operacion_Servicio(); _Servicio = _itemServ; _Servicio.COPE_Codigo = Item.COPE_Codigo; _Servicio.Trasanct = false; _Servicio.Instance = Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted; _Servicio.AUDI_UsrCrea = Item.AUDI_UsrMod; BLDet_Operacion_Servicio.Save(_Servicio); //if (!m_isCorrect) { break; } } } /* Items Servicios Operación */ if (Item.ItemsDet_Operacion_Servicio != null && Item.ItemsDet_Operacion_Servicio.Count > 0 && m_isCorrect) { foreach (var _itemServ in Item.ItemsDet_Operacion_Servicio) { Det_Operacion_Servicio _Servicio = new Det_Operacion_Servicio(); _Servicio = _itemServ; _Servicio.COPE_Codigo = Item.COPE_Codigo; _Servicio.Trasanct = false; //_Servicio.Instance = Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added; _Servicio.AUDI_UsrCrea = Item.AUDI_UsrMod; if (_Servicio.SOPE_Item == 0) { _Servicio.Instance = Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added; } m_isCorrect = BLDet_Operacion_Servicio.Save(_Servicio); if (!m_isCorrect) { break; } } } break; case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted: m_isCorrect = Delete(ref Item); break; } if (m_isCorrect) { Infrastructure.Aspect.DataAccess.DataAccessEnterpriseSQL.DACommitTransaction(); } else { Infrastructure.Aspect.DataAccess.DataAccessEnterpriseSQL.DARollbackTransaction(); } return(m_isCorrect); } catch (Exception) { Infrastructure.Aspect.DataAccess.DataAccessEnterpriseSQL.DARollbackTransaction(); throw; } }