private Servicio_Via SelectOne(String CONS_TabVIA, String CONS_CodVIA, Int32 SERV_Codigo) { try { Servicio_Via item = new Servicio_Via(); DataAccessEnterpriseSQL.DAAsignarProcedure("TCOM_SP_CONSULTAR_Servicio_Via"); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_TabVIA", CONS_TabVIA, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_CodVIA", CONS_CodVIA, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintSERV_Codigo", SERV_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader()) { if (reader.Read()) { Loader.LoadEntity(reader, item); item.Instance = InstanceEntity.Unchanged; } else { throw new Exception("No se encontro el registro."); } } return(item); } catch (Exception ex) { throw ex; } }
private bool Delete(ref Servicio_Via item) { try { if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted) { DataAccessEnterpriseSQL.DAAsignarProcedure("TCOM_SP_ELIMINAR_Servicio_Via"); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_TabVIA", item.CONS_TabVIA, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONS_CodVIA", item.CONS_CodVIA, SqlDbType.Char, 3, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintSERV_Codigo", item.SERV_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0) { return(true); } else { return(false); } } else { return(true); } } catch (Exception ex) { throw ex; } }
public BLServicio_Via(IUnityContainer container) { this.ContainerService = container; Loader = new BusinessEntityLoader <Servicio_Via>(); Servicio_Via item = new Servicio_Via(); Loader.EntityType = item.GetType(); }
public Boolean SaveServicio_Via(Servicio_Via Item) { try { if (Item.Instance != Infrastructure.Aspect.BusinessEntity.InstanceEntity.Unchanged) { return(BL_Servicio_Via.Save(ref Item)); } return(true); } catch (Exception ex) { throw ex; } }
public Boolean Save(ref Servicio_Via Item) { try { Boolean m_isCorrect = true; switch (Item.Instance) { case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added: m_isCorrect = Insert(ref Item); break; case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted: m_isCorrect = Delete(ref Item); break; } return(m_isCorrect); } catch (Exception) { throw; } }
private ObservableCollection <Servicio_Via> SelectAll() { try { ObservableCollection <Servicio_Via> items = new ObservableCollection <Servicio_Via>(); Servicio_Via item = new Servicio_Via(); DataAccessEnterpriseSQL.DAAsignarProcedure("TCOM_SP_CONSULTAR_Servicio_Via"); using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader()) { while (reader.Read()) { item = new Servicio_Via(); Loader.LoadEntity(reader, item); item.Instance = InstanceEntity.Unchanged; items.Add(item); } } return(items); } catch (Exception ex) { throw ex; } }
private ObservableCollection <Servicio_Via> SelectAllByServicio(Int32 SERV_Codigo) { try { ObservableCollection <Servicio_Via> items = new ObservableCollection <Servicio_Via>(); Servicio_Via item = new Servicio_Via(); DataAccessEnterpriseSQL.DAAsignarProcedure("TCOM_SP_CONSULTAR_Servicio_Via"); DataAccessEnterpriseSQL.DAAgregarParametro("@pintSERV_Codigo", SERV_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader()) { while (reader.Read()) { item = new Servicio_Via(); Loader.LoadEntity(reader, item); item.Instance = InstanceEntity.Unchanged; items.Add(item); } } return(items); } catch (Exception ex) { throw ex; } }