private bool Delete(Cab_Direccionamiento item) { try { if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted) { DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_CDIRSD_UnReg"); DataAccessEnterpriseSQL.DAAgregarParametro("@pintCDIR_Codigo", item.CDIR_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0) { return(true); } else { return(false); } } else { return(true); } } catch (Exception ex) { throw ex; } }
public Boolean Save(ref Cab_Direccionamiento 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); 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); } catch (Exception) { Infrastructure.Aspect.DataAccess.DataAccessEnterpriseSQL.DARollbackTransaction(); throw; } }
public void AgregarDireccionamiento(DataTable dt) { for (int i = 0; i < dt.Rows.Count; i++) { if (!(dt.Rows[i]["CodCliente"] != DBNull.Value && !String.IsNullOrEmpty(dt.Rows[i]["CodCliente"].ToString()))) { Infrastructure.WinFormsControls.Dialogos.MostrarMensajeInformacion(Title, "No tiene un codigo de cliente valido"); return; } Cab_Direccionamiento _Item = new Cab_Direccionamiento { AUDI_UsrCrea = Session.UserName, Instance = Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added, CDIR_HBL = dt.Rows[i]["HBL"].ToString(), CDIR_MBL = dt.Rows[i]["MBL"].ToString(), CDIR_Viaje = dt.Rows[i]["Viaje"].ToString(), CDIR_Nave = dt.Rows[i]["Nave"].ToString(), CDIR_FecArribo = Convert.ToDateTime(dt.Rows[i]["FLLegada"].ToString()), CDIR_FecEmision = Convert.ToDateTime(dt.Rows[i]["FSalida"].ToString()), ENTC_CodCliente = Convert.ToInt32(dt.Rows[i]["CodCliente"].ToString()), ENTC_CodLinea = Convert.ToInt32(dt.Rows[i]["CodLinea"].ToString()), }; Client.SaveCab_Direccionamiento(ref _Item); CargarDetalleForward(Int16.Parse(dt.Rows[i]["CCOT_Tipo"].ToString()), Int32.Parse(dt.Rows[i]["CCOT_Numero"].ToString()), _Item.CDIR_Codigo); } }
public BLCab_Direccionamiento(IUnityContainer container) { this.ContainerService = container; Loader = new BusinessEntityLoader <Cab_Direccionamiento>(); Cab_Direccionamiento item = new Cab_Direccionamiento(); Loader.EntityType = item.GetType(); }
public Boolean SaveCab_Direccionamiento(ref Cab_Direccionamiento Item) { try { if (Item.Instance != Infrastructure.Aspect.BusinessEntity.InstanceEntity.Unchanged) { return(BL_Cab_Direccionamiento.Save(ref Item)); } return(true); } catch (Exception ex) { throw ex; } }
private bool Insert(ref Cab_Direccionamiento item) { try { if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added) { DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_CDIRSI_UnReg"); DataAccessEnterpriseSQL.DAAgregarParametro("@pintCDIR_Codigo", item.CDIR_Codigo, SqlDbType.Int, 4, ParameterDirection.InputOutput); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchCDIR_HBL", item.CDIR_HBL, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchCDIR_MBL", item.CDIR_MBL, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmCDIR_FecArribo", item.CDIR_FecArribo, SqlDbType.DateTime, 8, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchCDIR_Observaciones", item.CDIR_Observaciones, SqlDbType.VarChar, 1024, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintENTC_CodCliente", item.ENTC_CodCliente, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintENTC_CodLinea", item.ENTC_CodLinea, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintENTC_CodTemporal", item.ENTC_CodTemporal, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmCDIR_FecEmision", item.CDIR_FecEmision, SqlDbType.DateTime, 8, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintCDIR_Nave", item.CDIR_Nave, SqlDbType.VarChar, 100, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchCDIR_Viaje", item.CDIR_Viaje, SqlDbType.VarChar, 100, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchAUDI_UsrCrea", item.AUDI_UsrCrea, SqlDbType.VarChar, 20, ParameterDirection.Input); if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0) { Int32 _CDIR_Codigo; if (Int32.TryParse(DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pintCDIR_Codigo"].Value.ToString(), out _CDIR_Codigo)) { item.CDIR_Codigo = _CDIR_Codigo; } return(true); } else { return(false); } } else { return(true); } } catch (Exception ex) { throw ex; } }
public void AgregarDireccionamiento(DataTable dt) { for (int i = 0; i < dt.Rows.Count; i++) { Cab_Direccionamiento _Item = new Cab_Direccionamiento { AUDI_UsrCrea = Session.UserName, Instance = Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added, CDIR_HBL = dt.Rows[i]["HBL"].ToString(), CDIR_MBL = dt.Rows[i]["MBL"].ToString(), CDIR_Viaje = dt.Rows[i]["Viaje"].ToString(), CDIR_Nave = dt.Rows[i]["Nave"].ToString(), CDIR_FecArribo = Convert.ToDateTime(dt.Rows[i]["FLLegada"].ToString()), CDIR_FecEmision = Convert.ToDateTime(dt.Rows[i]["FSalida"].ToString()), ENTC_CodCliente = Convert.ToInt32(dt.Rows[i]["CodCliente"].ToString()), ENTC_CodLinea = Convert.ToInt32(dt.Rows[i]["CodLinea"].ToString()), }; Client.SaveCab_Direccionamiento(ref _Item); CargarDetalleForward(Convert.ToInt32(dt.Rows[i]["Operacion"].ToString()), _Item.CDIR_Codigo); } }
private bool Update(Cab_Direccionamiento item) { try { if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified) { DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_CDIRSU_UnReg"); DataAccessEnterpriseSQL.DAAgregarParametro("@pintCDIR_Codigo", item.CDIR_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchCDIR_HBL", item.CDIR_HBL, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchCDIR_MBL", item.CDIR_MBL, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmCDIR_FecArribo", item.CDIR_FecArribo, SqlDbType.DateTime, 8, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchCDIR_Observaciones", item.CDIR_Observaciones, SqlDbType.VarChar, 1024, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintENTC_CodCliente", item.ENTC_CodCliente, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintENTC_CodLinea", item.ENTC_CodLinea, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintENTC_CodTemporal", item.ENTC_CodTemporal, SqlDbType.Int, 4, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmCDIR_FecEmision", item.CDIR_FecEmision, SqlDbType.DateTime, 8, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pintCDIR_Nave", item.CDIR_Nave, SqlDbType.VarChar, 100, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@pvchCDIR_Viaje", item.CDIR_Nave, SqlDbType.VarChar, 100, 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; } }
private Cab_Direccionamiento SelectOne(Int32 CDIR_Codigo) { try { Cab_Direccionamiento item = new Cab_Direccionamiento(); DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_CDIRSS_UnReg"); DataAccessEnterpriseSQL.DAAgregarParametro("@pintCDIR_Codigo", CDIR_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 DataTable SelectAll(DateTime CDIR_FecEmisionInicio, DateTime CDIR_FecEmisionFin, Nullable <DateTime> CDIR_FecArriboInicio, Nullable <DateTime> CDIR_FecArriboFin, String CDIR_HBL, String CDIR_MBL, Int32 ENTC_CodCliente, Int32 ENTC_CodLinea, Int32 ENTC_CodTemporal, Int16 NAVE_Codigo) { try { ObservableCollection <Cab_Direccionamiento> items = new ObservableCollection <Cab_Direccionamiento>(); Cab_Direccionamiento item = new Cab_Direccionamiento(); DataAccessEnterpriseSQL.DAAsignarProcedure("SLI_CDIRSS_Todos"); DataAccessEnterpriseSQL.DAAgregarParametro("@CDIR_FecEmisionInicio", CDIR_FecEmisionInicio, SqlDbType.DateTime, 8, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@CDIR_FecEmisionFin", CDIR_FecEmisionFin, SqlDbType.DateTime, 8, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@CDIR_FecArriboInicio", CDIR_FecArriboInicio, SqlDbType.DateTime, 8, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@CDIR_FecArriboFin", CDIR_FecArriboFin, SqlDbType.DateTime, 8, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@CDIR_HBL", CDIR_HBL, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterpriseSQL.DAAgregarParametro("@CDIR_MBL", CDIR_MBL, SqlDbType.VarChar, 20, ParameterDirection.Input); if (ENTC_CodCliente == 0) { DataAccessEnterpriseSQL.DAAgregarParametro("@ENTC_CodCliente", DBNull.Value, SqlDbType.Int, 4, ParameterDirection.Input); } else { DataAccessEnterpriseSQL.DAAgregarParametro("@ENTC_CodCliente", ENTC_CodCliente, SqlDbType.Int, 4, ParameterDirection.Input); } if (ENTC_CodLinea == 0) { DataAccessEnterpriseSQL.DAAgregarParametro("@ENTC_CodLinea", DBNull.Value, SqlDbType.Int, 4, ParameterDirection.Input); } else { DataAccessEnterpriseSQL.DAAgregarParametro("@ENTC_CodLinea", ENTC_CodLinea, SqlDbType.Int, 4, ParameterDirection.Input); } if (ENTC_CodTemporal == 0) { DataAccessEnterpriseSQL.DAAgregarParametro("@ENTC_CodTemporal", DBNull.Value, SqlDbType.Int, 4, ParameterDirection.Input); } else { DataAccessEnterpriseSQL.DAAgregarParametro("@ENTC_CodTemporal", ENTC_CodTemporal, SqlDbType.Int, 4, ParameterDirection.Input); } if (NAVE_Codigo == 0) { DataAccessEnterpriseSQL.DAAgregarParametro("@NAVE_Codigo", DBNull.Value, SqlDbType.Int, 4, ParameterDirection.Input); } else { DataAccessEnterpriseSQL.DAAgregarParametro("@NAVE_Codigo", NAVE_Codigo, SqlDbType.Int, 4, ParameterDirection.Input); } System.Data.DataSet ds = DataAccessEnterpriseSQL.DAExecuteDataSet(); if (ds != null && ds.Tables.Count > 0) { return(ds.Tables[0]); } else { return(null); } //using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader()) //{ // while (reader.Read()) // { // item = new Cab_Direccionamiento(); // Loader.LoadEntity(reader, item); // item.Instance = InstanceEntity.Unchanged; // items.Add(item); // } //} //return items; } catch (Exception ex) { throw ex; } }