private bool Delete(ref GRR Item)
{
try
{
if (Item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("COM_REBASD_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrREBA_Tipo", Item.REBA_Tipo, SqlDbType.Char, 1, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintREBA_Codigo", Item.REBA_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (Exception)
{ throw; }
}
public GRR GetOne(String REBA_Tipo, Int32 REBA_Codigo)
{
try
{
if (REBA_Tipo == null || REBA_Codigo == null)
{
return(null);
}
GRR Item = SelectOne(REBA_Tipo, REBA_Codigo);
ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> _filters = new ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL>();
_filters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL()
{
FilterName = "@pchrREBA_Tipo", FilterValue = Item.REBA_Tipo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Char, FilterSize = 1
});
_filters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL()
{
FilterName = "@pintREBA_Codigo", FilterValue = Item.REBA_Codigo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Int32, FilterSize = 4
});
Item.ListGRR_Paquetes = BL_GRR_Paquetes.GetAllFilter("COM_GPACSS_Todos", _filters);
Item.ListGRR_Contratos = BL_GRR_Contrato.GetAllFilter("COM_GCONSS_Todos", _filters);
return(Item);
}
catch (Exception)
{ throw; }
}
private GRR SelectOne(String REBA_Tipo, Int32 REBA_Codigo)
{
try
{
GRR item = new GRR();
DataAccessEnterpriseSQL.DAAsignarProcedure("COM_REBASS_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrREBA_Tipo", REBA_Tipo, SqlDbType.Char, 1, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintREBA_Codigo", REBA_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)
{ throw; }
}
public BLGRR(IUnityContainer container)
{
this.ContainerService = container;
Loader = new BusinessEntityLoader <GRR>();
GRR Item = new GRR();
Loader.EntityType = Item.GetType();
}
public Boolean SaveGRR(GRR Item)
{
try
{
if (Item.Instance != Infrastructure.Aspect.BusinessEntity.InstanceEntity.Unchanged)
{
return(BL_GRR.Save(ref Item));
}
return(true);
}
catch (Exception ex)
{ throw ex; }
}
private bool Insert(ref GRR Item)
{
try
{
if (Item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("COM_REBASI_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrREBA_Tipo", Item.REBA_Tipo, SqlDbType.Char, 1, ParameterDirection.InputOutput);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintREBA_Codigo", Item.REBA_Codigo, SqlDbType.Int, 4, ParameterDirection.InputOutput);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmREBA_FecIni", Item.REBA_FecIni, SqlDbType.DateTime, 8, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmREBA_FecFin", Item.REBA_FecFin, SqlDbType.DateTime, 8, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmREBA_FecCalc", Item.REBA_FecCalc, SqlDbType.DateTime, 8, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdecREBA_Valor", Item.REBA_Valor, SqlDbType.Decimal, 15, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdecREBA_LimiteSup", Item.REBA_LimiteSup, SqlDbType.Decimal, 15, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdecREBA_LimiteInf", Item.REBA_LimiteInf, SqlDbType.Decimal, 15, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdecREBA_CostoFlete", Item.REBA_CostoFlete, SqlDbType.Decimal, 15, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdecREBA_CostoFleteDes", Item.REBA_CostoFleteDes, SqlDbType.Decimal, 15, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@psinEMPR_Codigo", Item.EMPR_Codigo, SqlDbType.SmallInt, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintENTC_CodTransportista", Item.ENTC_CodTransportista, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_TabMND", Item.TIPO_TabMND, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_CodMND", Item.TIPO_CodMND, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchAUDI_UsrCrea", Item.AUDI_UsrCrea, SqlDbType.VarChar, 20, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
if (DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pchrREBA_Tipo"].Value != DBNull.Value && String.IsNullOrEmpty(DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pchrREBA_Tipo"].Value.ToString()))
{
Item.REBA_Tipo = DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pchrREBA_Tipo"].Value.ToString();
}
Int32 _REBA_Codigo;
if (Int32.TryParse(DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pintREBA_Codigo"].Value.ToString(), out _REBA_Codigo))
{
Item.REBA_Codigo = _REBA_Codigo;
}
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (Exception)
{ throw; }
}
private bool Update(ref GRR Item)
{
try
{
if (Item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("COM_REBASU_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrREBA_Tipo", Item.REBA_Tipo, SqlDbType.Char, 1, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintREBA_Codigo", Item.REBA_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmREBA_FecIni", Item.REBA_FecIni, SqlDbType.DateTime, 8, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmREBA_FecFin", Item.REBA_FecFin, SqlDbType.DateTime, 8, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmREBA_FecCalc", Item.REBA_FecCalc, SqlDbType.DateTime, 8, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdecREBA_Valor", Item.REBA_Valor, SqlDbType.Decimal, 15, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdecREBA_LimiteSup", Item.REBA_LimiteSup, SqlDbType.Decimal, 15, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdecREBA_LimiteInf", Item.REBA_LimiteInf, SqlDbType.Decimal, 15, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdecREBA_CostoFlete", Item.REBA_CostoFlete, SqlDbType.Decimal, 15, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdecREBA_CostoFleteDes", Item.REBA_CostoFleteDes, SqlDbType.Decimal, 15, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@psinEMPR_Codigo", Item.EMPR_Codigo, SqlDbType.SmallInt, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintENTC_CodTransportista", Item.ENTC_CodTransportista, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_TabMND", Item.TIPO_TabMND, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_CodMND", Item.TIPO_CodMND, 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)
{ throw; }
}
private ObservableCollection <GRR> SelectAll()
{
try
{
ObservableCollection <GRR> items = new ObservableCollection <GRR>();
GRR item = new GRR();
DataAccessEnterpriseSQL.DAAsignarProcedure("COM_REBASS_Todos");
using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader())
{
while (reader.Read())
{
item = new GRR();
Loader.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
items.Add(item);
}
}
return(items);
}
catch (Exception)
{ throw; }
}
private ObservableCollection <GRR> SelectAllByFilter(String x_procedure, ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> x_filters)
{
try
{
ObservableCollection <GRR> items = new ObservableCollection <GRR>();
GRR item = new GRR();
if (!String.IsNullOrEmpty(x_procedure))
{
DataAccessEnterpriseSQL.DAAsignarProcedure(x_procedure);
}
else
{
DataAccessEnterpriseSQL.DAAsignarProcedure("COM_REBASS_TodosByFilters");
}
if (x_filters != null && x_filters.Count > 0)
{
foreach (Infrastructure.Aspect.DataAccess.DataAccessFilterSQL _itemFilter in x_filters)
{
DataAccessEnterpriseSQL.DAAgregarParametro(_itemFilter.FilterName, _itemFilter.FilterValue, _itemFilter.FilterSQLType, _itemFilter.FilterSize);
}
}
using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader())
{
while (reader.Read())
{
item = new GRR();
Loader.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
items.Add(item);
}
}
return(items);
}
catch (Exception)
{ throw; }
}
public Boolean Save(ref GRR 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);
if (m_isCorrect)
{
Infrastructure.Aspect.DataAccess.DataAccessEnterpriseSQL.DACommitTransaction();
}
else
{
Infrastructure.Aspect.DataAccess.DataAccessEnterpriseSQL.DARollbackTransaction();
}
return(m_isCorrect);
}
if (m_isCorrect)
{
if (m_isCorrect)
{
for (int i = 0; i < Item.ListGRR_Paquetes.Count; i++)
{
GRR_Paquetes _itemGRR_Paquetes = Item.ListGRR_Paquetes[i];
_itemGRR_Paquetes.REBA_Tipo = Item.REBA_Tipo;
_itemGRR_Paquetes.REBA_Codigo = Item.REBA_Codigo;
m_isCorrect = BL_GRR_Paquetes.Save(ref _itemGRR_Paquetes);
if (!m_isCorrect)
{
break;
}
}
}
//if (m_isCorrect)
//{
// for (int i = 0; i < Item.ListGRR_PaquetesDeleted.Count; i++)
// {
// GRR_Paquetes _itemGRR_Paquetes = Item.ListGRR_PaquetesDeleted[i];
// m_isCorrect = BL_GRR_Paquetes.Save(ref _itemGRR_Paquetes);
// if (!m_isCorrect) { break; }
// }
//}
if (m_isCorrect)
{
for (int i = 0; i < Item.ListGRR_Contratos.Count; i++)
{
GRR_Contrato _itemGRR_Contrato = Item.ListGRR_Contratos[i];
_itemGRR_Contrato.REBA_Tipo = Item.REBA_Tipo;
_itemGRR_Contrato.REBA_Codigo = Item.REBA_Codigo;
m_isCorrect = BL_GRR_Contrato.Save(ref _itemGRR_Contrato);
if (!m_isCorrect)
{
break;
}
}
}
//if (m_isCorrect)
//{
// for (int i = 0; i < Item.ListGRR_ContratosDeleted.Count; i++)
// {
// GRR_Contrato _itemGRR_Contrato = Item.ListGRR_ContratosDeleted[i];
// m_isCorrect = BL_GRR_Contrato.Save(ref _itemGRR_Contrato);
// if (!m_isCorrect) { 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; }
}
