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; }
}
