public Boolean Save(ref Det_Cotizacion_OV_Documento 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(ref Item); 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; }
}
private Det_Cotizacion_OV_Documento SelectOne(Int32 CCOT_Numero, Int32 DOOV_Codigo, Int16 CCOT_Tipo)
{
try
{
Det_Cotizacion_OV_Documento item = new Det_Cotizacion_OV_Documento();
DataAccessEnterpriseSQL.DAAsignarProcedure("TCOM_SP_CONSULTAR_Det_Cotizacion_OV_Documento");
DataAccessEnterpriseSQL.DAAgregarParametro("@pintCCOT_Numero", CCOT_Numero, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintDOOV_Codigo", DOOV_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@psinCCOT_Tipo", CCOT_Tipo, SqlDbType.SmallInt, 2, 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 Det_Cotizacion_OV_Documento item)
{
try
{
if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("TCOM_SP_ELIMINAR_Det_Cotizacion_OV_Documento");
DataAccessEnterpriseSQL.DAAgregarParametro("@pintCCOT_Numero", item.CCOT_Numero, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintDOOV_Codigo", item.DOOV_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@psinCCOT_Tipo", item.CCOT_Tipo, SqlDbType.SmallInt, 2, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (Exception ex)
{ throw ex; }
}
public BLDet_Cotizacion_OV_Documento(IUnityContainer container)
{
this.ContainerService = container;
Loader = new BusinessEntityLoader <Det_Cotizacion_OV_Documento>();
Det_Cotizacion_OV_Documento item = new Det_Cotizacion_OV_Documento();
Loader.EntityType = item.GetType();
}
private bool Insert(ref Det_Cotizacion_OV_Documento item)
{
try
{
if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("TCOM_SP_INSERTAR_Det_Cotizacion_OV_Documento");
DataAccessEnterpriseSQL.DAAgregarParametro("@pintCCOT_Numero", item.CCOT_Numero, SqlDbType.Int, 4, ParameterDirection.InputOutput);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintDOOV_Codigo", item.DOOV_Codigo, SqlDbType.Int, 4, ParameterDirection.InputOutput);
DataAccessEnterpriseSQL.DAAgregarParametro("@psinCCOT_Tipo", item.CCOT_Tipo, SqlDbType.SmallInt, 2, ParameterDirection.InputOutput);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchDOOV_Viaje", item.DOOV_Viaje, SqlDbType.VarChar, 50, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchDOOV_Feeder", item.DOOV_Feeder, SqlDbType.VarChar, 100, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmDOOV_ETA", item.DOOV_ETA, SqlDbType.DateTime, 8, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmDOOV_ETDF", item.DOOV_ETDF, SqlDbType.DateTime, 8, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmDOOV_ETDM", item.DOOV_ETDM, SqlDbType.DateTime, 8, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchDOOV_Cntr", item.DOOV_Cntr, SqlDbType.VarChar, 250, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrDOOV_HBL", item.DOOV_HBL, SqlDbType.Char, 50, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrDOOV_MBL", item.DOOV_MBL, SqlDbType.Char, 50, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrDOOV_CodReferencia", item.DOOV_CodReferencia, SqlDbType.Char, 50, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_TabDTM", item.TIPO_TabDTM, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_CodDTM", item.TIPO_CodDTM, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_TabVapor", item.TIPO_TabVapor, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_CodVapor", item.TIPO_CodVapor, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchAUDI_UsrCrea", item.AUDI_UsrCrea, SqlDbType.VarChar, 20, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
Int32 _CCOT_Numero;
if (Int32.TryParse(DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pintCCOT_Numero"].Value.ToString(), out _CCOT_Numero))
{
item.CCOT_Numero = _CCOT_Numero;
}
Int32 _DOOV_Codigo;
if (Int32.TryParse(DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pintDOOV_Codigo"].Value.ToString(), out _DOOV_Codigo))
{
item.DOOV_Codigo = _DOOV_Codigo;
}
Int16 _CCOT_Tipo;
if (Int16.TryParse(DataAccessEnterpriseSQL.DASqlCommand.Parameters["@psinCCOT_Tipo"].Value.ToString(), out _CCOT_Tipo))
{
item.CCOT_Tipo = _CCOT_Tipo;
}
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (Exception ex)
{ throw ex; }
}
public Boolean SaveDet_Cotizacion_OV_Documento(ref Det_Cotizacion_OV_Documento Item)
{
try
{
if (Item.Instance != Infrastructure.Aspect.BusinessEntity.InstanceEntity.Unchanged)
{
return(BL_Det_Cotizacion_OV_Documento.Save(ref Item));
}
return(true);
}
catch (Exception)
{ throw; }
}
private bool Update(ref Det_Cotizacion_OV_Documento item)
{
try
{
if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("TCOM_SP_ACTUALIZAR_Det_Cotizacion_OV_Documento");
DataAccessEnterpriseSQL.DAAgregarParametro("@pintCCOT_Numero", item.CCOT_Numero, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintDOOV_Codigo", item.DOOV_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@psinCCOT_Tipo", item.CCOT_Tipo, SqlDbType.SmallInt, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchDOOV_Viaje", item.DOOV_Viaje, SqlDbType.VarChar, 50, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchDOOV_Feeder", item.DOOV_Feeder, SqlDbType.VarChar, 100, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmDOOV_ETA", item.DOOV_ETA, SqlDbType.DateTime, 8, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmDOOV_ETDF", item.DOOV_ETDF, SqlDbType.DateTime, 8, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmDOOV_ETDM", item.DOOV_ETDM, SqlDbType.DateTime, 8, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchDOOV_Cntr", item.DOOV_Cntr, SqlDbType.VarChar, 250, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrDOOV_HBL", item.DOOV_HBL, SqlDbType.Char, 50, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrDOOV_MBL", item.DOOV_MBL, SqlDbType.Char, 50, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrDOOV_CodReferencia", item.DOOV_CodReferencia, SqlDbType.Char, 50, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_TabDTM", item.TIPO_TabDTM, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_CodDTM", item.TIPO_CodDTM, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_TabVapor", item.TIPO_TabVapor, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_CodVapor", item.TIPO_CodVapor, SqlDbType.Char, 3, 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 ObservableCollection <Det_Cotizacion_OV_Documento> SelectAll()
{
try
{
ObservableCollection <Det_Cotizacion_OV_Documento> items = new ObservableCollection <Det_Cotizacion_OV_Documento>();
Det_Cotizacion_OV_Documento item = new Det_Cotizacion_OV_Documento();
DataAccessEnterpriseSQL.DAAsignarProcedure("TCOM_SP_CONSULTAR_Det_Cotizacion_OV_Documento");
using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader())
{
while (reader.Read())
{
item = new Det_Cotizacion_OV_Documento();
Loader.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
items.Add(item);
}
}
return(items);
}
catch (Exception ex)
{ throw ex; }
}
