private bool Update(ref CabPerfilAsientos Item)
{
try
{
if (Item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("CON_CABPSU_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCABP_Ano", Item.CABP_Ano, SqlDbType.Char, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchCABP_Codigo", Item.CABP_Codigo, SqlDbType.VarChar, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchCABP_Desc", Item.CABP_Desc, SqlDbType.VarChar, 100, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_CodREG", Item.TIPO_CodREG, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_TabREG", Item.TIPO_TabREG, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdecCABP_ValorRef", Item.CABP_ValorRef, SqlDbType.Decimal, 15, 2, 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 CabPerfilAsientos SelectOne(String CABP_Ano, String CABP_Codigo)
{
try
{
CabPerfilAsientos item = new CabPerfilAsientos();
DataAccessEnterpriseSQL.DAAsignarProcedure("CON_CABPSS_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCABP_Ano", CABP_Ano, SqlDbType.Char, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchCABP_Codigo", CABP_Codigo, SqlDbType.VarChar, 3, 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 BLCabPerfilAsientos(IUnityContainer container)
{
this.ContainerService = container;
Loader = new BusinessEntityLoader <CabPerfilAsientos>();
CabPerfilAsientos Item = new CabPerfilAsientos();
Loader.EntityType = Item.GetType();
}
public Boolean SaveCabPerfilAsientos(ref CabPerfilAsientos Item)
{
try
{
if (Item.Instance != Infrastructure.Aspect.BusinessEntity.InstanceEntity.Unchanged)
{
return(BL_CabPerfilAsientos.Save(ref Item));
}
return(true);
}
catch (Exception)
{ throw; }
}
private bool Insert(ref CabPerfilAsientos Item)
{
try
{
if (Item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("CON_CABPSI_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCABP_Ano", Item.CABP_Ano, SqlDbType.Char, 4, ParameterDirection.InputOutput);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchCABP_Codigo", Item.CABP_Codigo, SqlDbType.VarChar, 3, ParameterDirection.InputOutput);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchCABP_Desc", Item.CABP_Desc, SqlDbType.VarChar, 100, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_CodREG", Item.TIPO_CodREG, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_TabREG", Item.TIPO_TabREG, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdecCABP_ValorRef", Item.CABP_ValorRef, SqlDbType.Decimal, 15, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchAUDI_UsrCrea", Item.AUDI_UsrCrea, SqlDbType.VarChar, 20, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
if (DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pchrCABP_Ano"].Value != DBNull.Value && !String.IsNullOrEmpty(DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pchrCABP_Ano"].Value.ToString()))
{
Item.CABP_Ano = DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pchrCABP_Ano"].Value.ToString();
}
if (DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pvchCABP_Codigo"].Value != DBNull.Value && !String.IsNullOrEmpty(DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pvchCABP_Codigo"].Value.ToString()))
{
Item.CABP_Codigo = DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pvchCABP_Codigo"].Value.ToString();
}
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (Exception)
{ throw; }
}
private bool Delete(ref CabPerfilAsientos Item)
{
try
{
if (Item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("CON_CABPSD_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCABP_Ano", Item.CABP_Ano, SqlDbType.Char, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchCABP_Codigo", Item.CABP_Codigo, SqlDbType.VarChar, 3, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (SqlException ex)
{
if (ex.Number == 547)
{
throw new Exception
(String.Format("# No se puede Eliminar este Registro por tener relaciones activas. #" + ex.Message, ex));
}
else
{
throw;
}
}
catch (Exception)
{ throw; }
}
private ObservableCollection <CabPerfilAsientos> SelectAll()
{
try
{
ObservableCollection <CabPerfilAsientos> items = new ObservableCollection <CabPerfilAsientos>();
CabPerfilAsientos item = new CabPerfilAsientos();
DataAccessEnterpriseSQL.DAAsignarProcedure("CON_CABPSS_Todos");
using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader())
{
while (reader.Read())
{
item = new CabPerfilAsientos();
Loader.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
items.Add(item);
}
}
return(items);
}
catch (Exception)
{ throw; }
}
private ObservableCollection <CabPerfilAsientos> SelectAllByFilter(String x_procedure, ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> x_filters)
{
try
{
ObservableCollection <CabPerfilAsientos> items = new ObservableCollection <CabPerfilAsientos>();
CabPerfilAsientos item = new CabPerfilAsientos();
if (!String.IsNullOrEmpty(x_procedure))
{
DataAccessEnterpriseSQL.DAAsignarProcedure(x_procedure);
}
else
{
DataAccessEnterpriseSQL.DAAsignarProcedure("CON_CABPSS_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 CabPerfilAsientos();
Loader.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
items.Add(item);
}
}
return(items);
}
catch (Exception)
{ throw; }
}
public Boolean Save(ref CabPerfilAsientos Item)
{
try
{
DataAccessEnterpriseSQL.DABeginTransaction();
Boolean m_isCorrect = true;
String x_usuario = "";
switch (Item.Instance)
{
case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added:
m_isCorrect = Insert(ref Item);
x_usuario = Item.AUDI_UsrCrea;
break;
case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified:
m_isCorrect = Update(ref Item);
x_usuario = Item.AUDI_UsrMod;
break;
case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted:
m_isCorrect = Delete(ref Item); break;
}
#region Guardar Detalles
if (Item.ListDetPerfilAsientosEliminados != null && Item.ListDetPerfilAsientosEliminados.Count > 0)
{
foreach (DetPerfilAsientos item in Item.ListDetPerfilAsientosEliminados)
{
item.Instance = InstanceEntity.Deleted;
Entities.DetPerfilAsientos _item = item;
m_isCorrect = BL_DetPerfilAsientos.Save(ref _item);
if (!m_isCorrect)
{
throw new Exception(String.Format("No se puede eliminar el item {0}", item.DETP_Item));
}
}
}
if (Item.ListDetPerfilAsientos != null && Item.ListDetPerfilAsientos.Count > 0)
{
foreach (DetPerfilAsientos item in Item.ListDetPerfilAsientos)
{
item.CABP_Ano = Item.CABP_Ano;
item.CABP_Codigo = Item.CABP_Codigo;
switch (item.Instance)
{
case InstanceEntity.Added:
item.AUDI_UsrCrea = x_usuario;
break;
case InstanceEntity.Modified:
item.AUDI_UsrMod = x_usuario;
break;
}
Entities.DetPerfilAsientos _item = item;
m_isCorrect = BL_DetPerfilAsientos.Save(ref _item);
if (!m_isCorrect)
{
throw new Exception(String.Format("No se puede grabar el item {0}", item.DETP_Item));
}
}
}
#endregion
if (m_isCorrect)
{
DataAccessEnterpriseSQL.DACommitTransaction();
}
else
{
DataAccessEnterpriseSQL.DARollbackTransaction();
}
return(m_isCorrect);
}
catch (Exception)
{ DataAccessEnterpriseSQL.DARollbackTransaction(); throw; }
}
