private ObservableCollection <Cab_Seguimientos> SelectAllByFiltros(DateTime x_CSEG_FechaEmisionIni, DateTime x_CSEG_FechaEmisionFin, String x_Nave) { try { ObservableCollection <Cab_Seguimientos> items = new ObservableCollection <Cab_Seguimientos>(); Cab_Seguimientos item = new Cab_Seguimientos(); DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_CSEGSS_TodosByFiltros"); DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmCSEG_FechaEmisionIni", x_CSEG_FechaEmisionIni, SqlDbType.DateTime, 8, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmCSEG_FechaEmisionFin", x_CSEG_FechaEmisionFin, SqlDbType.DateTime, 8, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchNave", x_Nave, SqlDbType.VarChar, 20, ParameterDirection.Input); using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader()) { while (reader.Read()) { item = new Cab_Seguimientos(); Loader.LoadEntity(reader, item); item.Instance = InstanceEntity.Unchanged; items.Add(item); } } return(items); } catch (Exception ex) { throw ex; } }
private bool Delete(ref Cab_Seguimientos item) { try { if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted) { DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_CSEGSD_UnReg"); DataAccessEnterpriseSQL.DAAgregarParametro("@pintCSEG_Codigo", item.CSEG_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0) { return(true); } else { return(false); } } else { return(true); } } catch (Exception ex) { throw ex; } }
private bool Update(ref Cab_Seguimientos item) { try { if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified) { DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_CSEGSU_UnReg"); DataAccessEnterpriseSQL.DAAgregarParametro("@pintCSEG_Codigo", item.CSEG_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchCSEG_HBL", item.CSEG_HBL, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmCSEG_FechaEmision", item.CSEG_FechaEmision, SqlDbType.DateTime, 8, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintCDIR_Codigo", item.CDIR_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintCOPE_Codigo", item.COPE_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchAUDI_UsrMod", item.AUDI_UsrMod, SqlDbType.VarChar, 20, ParameterDirection.Input); if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0) { return(true); } else { return(false); } } else { return(true); } } catch (Exception ex) { throw ex; } }
public BLCab_Seguimientos(IUnityContainer container) { this.ContainerService = container; Loader = new BusinessEntityLoader <Cab_Seguimientos>(); Cab_Seguimientos item = new Cab_Seguimientos(); Loader.EntityType = item.GetType(); }
public bool GetExisteSeguimientoOperacion(Cab_Seguimientos item) { try { return(ExisteOperacion(item)); } catch (Exception ex) { throw ex; } }
public Boolean SaveCab_Seguimientos(ref Cab_Seguimientos Item) { try { if (Item.Instance != Infrastructure.Aspect.BusinessEntity.InstanceEntity.Unchanged) { return(BL_Cab_Seguimientos.Save(ref Item)); } return(true); } catch (Exception ex) { throw ex; } }
public bool ExisteOperacion(Cab_Seguimientos item) { try { DataSet _dt = new DataSet(); DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_CSEGSS_ExisteOperacion"); DataAccessEnterpriseSQL.DAAgregarParametro("@pintCOPE_Codigo", item.COPE_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); _dt = DataAccessEnterpriseSQL.DAExecuteDataSet(); if (_dt != null && _dt.Tables.Count > 0 && _dt.Tables[0].Rows.Count > 0) { return(true); } return(false); } catch (Exception ex) { throw ex; } }
private Cab_Seguimientos SelectOne(Int32 CSEG_Codigo) { try { Cab_Seguimientos item = new Cab_Seguimientos(); DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_CSEGSS_UnReg"); DataAccessEnterpriseSQL.DAAgregarParametro("@pintCSEG_Codigo", CSEG_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; } }
public void Nuevo() { try { MView.ClearItem(); ItemCab_Seguimientos = new Cab_Seguimientos { AUDI_UsrCrea = Session.UserName, AUDI_FecCrea = Session.Fecha, Instance = InstanceEntity.Added }; MView.ClearItemsDetalles(); MView.SetInstance(InstanceView.New); if (LView != null) { ((PRO006MView)MView).Icon = System.Drawing.Icon.FromHandle(((System.Drawing.Bitmap)LView.IconView).GetHicon()); } ((PRO006MView)MView).ShowDialog(); } catch (Exception ex) { Dialogos.MostrarMensajeError(Title, Mensajes.NewPresenter, ex); } }
private bool Insert(ref Cab_Seguimientos item) { try { if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added) { DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_CSEGSI_UnReg"); DataAccessEnterpriseSQL.DAAgregarParametro("@pintCSEG_Codigo", item.CSEG_Codigo, SqlDbType.Int, 4, ParameterDirection.InputOutput); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchCSEG_HBL", item.CSEG_HBL, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmCSEG_FechaEmision", item.CSEG_FechaEmision, SqlDbType.DateTime, 8, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintCDIR_Codigo", item.CDIR_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintCOPE_Codigo", item.COPE_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchAUDI_UsrCrea", item.AUDI_UsrCrea, SqlDbType.VarChar, 20, ParameterDirection.Input); if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0) { Int32 _CSEG_Codigo; if (Int32.TryParse(DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pintCSEG_Codigo"].Value.ToString(), out _CSEG_Codigo)) { item.CSEG_Codigo = _CSEG_Codigo; } return(true); } else { return(false); } } else { return(true); } } catch (Exception ex) { throw ex; } }
public Boolean Save(ref Cab_Seguimientos 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.ItemsDetSeguimientos != null && Item.ItemsDetSeguimientos.Count > 0) { foreach (var item in Item.ItemsDetSeguimientos) { Det_Seguimientos _Deta = new Det_Seguimientos(); _Deta = item; _Deta.CSEG_Codigo = Item.CSEG_Codigo; _Deta.Tranct = false; m_isCorrect = BLDet_Seguimientos.Save(_Deta); if (!m_isCorrect) { break; } } } break; case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified: m_isCorrect = Update(ref Item); if (Item.ItemsDetSeguimientos != null && Item.ItemsDetSeguimientos.Count > 0) { foreach (var item in Item.ItemsDetSeguimientos) { Det_Seguimientos _Deta = new Det_Seguimientos(); _Deta = item; _Deta.CSEG_Codigo = Item.CSEG_Codigo; _Deta.Tranct = false; m_isCorrect = BLDet_Seguimientos.Save(_Deta); 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; } }