private bool Delete(ref LiqCtaCte Item)
{
try
{
if (Item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("CAJ_LCCCSD_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@psinEMPR_Codigo", Item.EMPR_Codigo, SqlDbType.SmallInt, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchLIQU_Codigo", Item.LIQU_Codigo, SqlDbType.VarChar, 20, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintCCCT_Codigo", Item.CCCT_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@psinLCCC_Item", Item.LCCC_Item, SqlDbType.SmallInt, 2, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (Exception)
{ throw; }
}
private LiqCtaCte SelectOne(Int16 EMPR_Codigo, String LIQU_Codigo, Int32 CCCT_Codigo, Int16 LCCC_Item)
{
try
{
LiqCtaCte item = new LiqCtaCte();
DataAccessEnterpriseSQL.DAAsignarProcedure("CAJ_LCCCSS_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@psinEMPR_Codigo", EMPR_Codigo, SqlDbType.SmallInt, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchLIQU_Codigo", LIQU_Codigo, SqlDbType.VarChar, 20, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintCCCT_Codigo", CCCT_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@psinLCCC_Item", LCCC_Item, 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)
{ throw; }
}
public BLLiqCtaCte(IUnityContainer container)
{
this.ContainerService = container;
Loader = new BusinessEntityLoader <LiqCtaCte>();
LiqCtaCte Item = new LiqCtaCte();
Loader.EntityType = Item.GetType();
}
public Boolean SaveLiqCtaCte(ref LiqCtaCte Item)
{
try
{
if (Item.Instance != Infrastructure.Aspect.BusinessEntity.InstanceEntity.Unchanged)
{
return(BL_LiqCtaCte.Save(ref Item));
}
return(true);
}
catch (Exception)
{ throw; }
}
public Boolean Save(ref LiqCtaCte Item)
{
try
{
Boolean m_isCorrect = true;
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;
}
return(m_isCorrect);
}
catch (Exception)
{ throw; }
}
private ObservableCollection <LiqCtaCte> SelectAll()
{
try
{
ObservableCollection <LiqCtaCte> items = new ObservableCollection <LiqCtaCte>();
LiqCtaCte item = new LiqCtaCte();
DataAccessEnterpriseSQL.DAAsignarProcedure("CAJ_LCCCSS_Todos");
using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader())
{
while (reader.Read())
{
item = new LiqCtaCte();
Loader.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
items.Add(item);
}
}
return(items);
}
catch (Exception)
{ throw; }
}
private ObservableCollection <LiqCtaCte> SelectAllByFilter(String x_procedure, ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> x_filters)
{
try
{
ObservableCollection <LiqCtaCte> items = new ObservableCollection <LiqCtaCte>();
LiqCtaCte item = new LiqCtaCte();
if (!String.IsNullOrEmpty(x_procedure))
{
DataAccessEnterpriseSQL.DAAsignarProcedure(x_procedure);
}
else
{
DataAccessEnterpriseSQL.DAAsignarProcedure("CAJ_LCCCSS_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 LiqCtaCte();
Loader.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
items.Add(item);
}
}
return(items);
}
catch (Exception)
{ throw; }
}
private bool Insert(ref LiqCtaCte Item)
{
try
{
if (Item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("CAJ_LCCCSI_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@psinEMPR_Codigo", Item.EMPR_Codigo, SqlDbType.SmallInt, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchLIQU_Codigo", Item.LIQU_Codigo, SqlDbType.VarChar, 20, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintCCCT_Codigo", Item.CCCT_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@psinLCCC_Item", Item.LCCC_Item, SqlDbType.SmallInt, 2, ParameterDirection.InputOutput);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchAUDI_UsrCrea", Item.AUDI_UsrCrea, SqlDbType.VarChar, 20, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
Int16 _LCCC_Item;
if (Int16.TryParse(DataAccessEnterpriseSQL.DASqlCommand.Parameters["@psinLCCC_Item"].Value.ToString(), out _LCCC_Item))
{
Item.LCCC_Item = _LCCC_Item;
}
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (Exception)
{ throw; }
}
public Boolean Save(ref Liquidacion 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;
foreach (Entities.CtaCte iCtaCte in Item.ListCtaCte.Where(CCCT => CCCT.Seleccionar).ToObservableCollection())
{
iCtaCte.ItemLiqCtaCte = new LiqCtaCte();
iCtaCte.ItemLiqCtaCte.Instance = Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added;
}
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;
default:
x_usuario = String.IsNullOrEmpty(Item.AUDI_UsrMod) ? Item.AUDI_UsrCrea : Item.AUDI_UsrMod;
break;
}
/*
* Grabar detalles
*/
Item.ListCtaCteEliminados = Item.ListCtaCte.Where(Cta => !Cta.Seleccionar && Cta.LCCC_Item != null).ToObservableCollection();
if (Item.ListCtaCteEliminados != null && Item.ListCtaCteEliminados.Count > 0)
{
foreach (Entities.CtaCte iCtaCte in Item.ListCtaCteEliminados)
{
Entities.LiqCtaCte _item = new LiqCtaCte();
_item.CCCT_Codigo = iCtaCte.CCCT_Codigo;
_item.LIQU_Codigo = Item.LIQU_Codigo;
_item.EMPR_Codigo = Item.EMPR_Codigo;
_item.LCCC_Item = iCtaCte.LCCC_Item;
_item.Instance = Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted;
m_isCorrect = BL_LiqCtaCte.Save(ref _item);
}
}
if (Item.ListCtaCte != null && Item.ListCtaCte.Count > 0)
{
foreach (Entities.CtaCte iCtaCte in Item.ListCtaCte.Where(CCCT => CCCT.Seleccionar).ToObservableCollection())
{
iCtaCte.ItemLiqCtaCte.CCCT_Codigo = iCtaCte.CCCT_Codigo;
iCtaCte.ItemLiqCtaCte.LIQU_Codigo = Item.LIQU_Codigo;
iCtaCte.ItemLiqCtaCte.EMPR_Codigo = Item.EMPR_Codigo;
if (iCtaCte.ItemLiqCtaCte.LCCC_Item == null)
{
iCtaCte.ItemLiqCtaCte.Instance = Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added;
}
switch (iCtaCte.ItemLiqCtaCte.Instance)
{
case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added:
iCtaCte.ItemLiqCtaCte.AUDI_UsrCrea = x_usuario;
break;
case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified:
iCtaCte.ItemLiqCtaCte.AUDI_UsrMod = x_usuario;
break;
}
Entities.LiqCtaCte _item = iCtaCte.ItemLiqCtaCte;
m_isCorrect = BL_LiqCtaCte.Save(ref _item);
}
}
if (m_isCorrect)
{
DataAccessEnterpriseSQL.DACommitTransaction();
}
else
{
DataAccessEnterpriseSQL.DARollbackTransaction();
}
return(m_isCorrect);
}
catch (Exception)
{
DataAccessEnterpriseSQL.DARollbackTransaction();
throw;
}
}
