private bool Delete(ref LoadingList Item)
{
try
{
if (Item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("OPE_LOADSD_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@pintLOAD_Codigo", Item.LOAD_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (Exception)
{ throw; }
}
private Boolean UpdateControlDoc(ref LoadingList item)
{
try
{
DataAccessEnterpriseSQL.DAAsignarProcedure("OPE_LOADUU_Pre_Alerta");
DataAccessEnterpriseSQL.DAAgregarParametro("@pintLOAD_Codigo", item.LOAD_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchLOAD_HBL", item.LOAD_HBL, SqlDbType.VarChar, 50, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchLOAD_MBL", item.LOAD_MBL, SqlDbType.VarChar, 50, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmLOAD_FecDevolucion", item.LOAD_FecDevolucion, SqlDbType.DateTime, 8, ParameterDirection.Input);
//DataAccessEnterpriseSQL.DAAgregarParametro("@pintCCOT_Numero", item.CCOT_Numero, SqlDbType.Int, 4, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException ex)
{
if (ex.Number == 2627)
{
throw new Exception
(String.Format("# El Número de HBL ya existe en la Base de Datos. #" + ex.Message, ex));
}
else
{
throw;
}
}
catch (Exception ex)
{ throw ex; }
}
private ObservableCollection <LoadingList> SelectImportResumido(DateTime LOAD_CargaFecha)
{
try
{
DataAccessEnterpriseSQL.DAAsignarProcedure("OPE_LOADSS_ImportacionResumido");
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmLOAD_CargaFecha", LOAD_CargaFecha, SqlDbType.DateTime, 8, ParameterDirection.Input);
ObservableCollection <LoadingList> items = new ObservableCollection <LoadingList>();
LoadingList item = new LoadingList();
using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader())
{
while (reader.Read())
{
item = new LoadingList();
Loader.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
items.Add(item);
}
}
return(items);
}
catch (Exception)
{ throw; }
}
public Boolean SaveControlDoc(ref LoadingList Item)
{
try
{
Boolean m_isCorrect = true;
Infrastructure.Aspect.DataAccess.DataAccessEnterpriseSQL.DABeginTransaction();
switch (Item.Instance)
{
case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added:
m_isCorrect = InsertControlDoc(ref Item); break;
case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified:
m_isCorrect = UpdateControlDoc(ref Item); break;
case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted:
m_isCorrect = DeleteControlDoc(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; }
}
public BLLoadingList(IUnityContainer container)
{
this.ContainerService = container;
Loader = new BusinessEntityLoader <LoadingList>();
LoadingList Item = new LoadingList();
Loader.EntityType = Item.GetType();
}
private bool Update(ref LoadingList Item)
{
try
{
if (Item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("OPE_LOADSU_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@pintLOAD_Codigo", Item.LOAD_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchLOAD_Shipper", Item.LOAD_Shipper, SqlDbType.VarChar, 100, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchLOAD_Consignee", Item.LOAD_Consignee, SqlDbType.VarChar, 100, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchLOAD_Notify", Item.LOAD_Notify, SqlDbType.VarChar, 100, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchLOAD_Carrier", Item.LOAD_Carrier, SqlDbType.VarChar, 100, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchLOAD_Booking", Item.LOAD_Booking, SqlDbType.VarChar, 50, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchLOAD_MBL", Item.LOAD_MBL, SqlDbType.VarChar, 50, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchLOAD_HBL", Item.LOAD_HBL, SqlDbType.VarChar, 50, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmLOAD_ETA", Item.LOAD_ETA, SqlDbType.DateTime, 8, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmLOAD_ETD", Item.LOAD_ETD, SqlDbType.DateTime, 8, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrLOAD_Payment", Item.LOAD_Payment, SqlDbType.Char, 1, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchLOAD_NaveViaje", Item.LOAD_NaveViaje, SqlDbType.VarChar, 50, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintCCOT_Numero", Item.CCOT_Numero, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@psinCCOT_Tipo", Item.CCOT_Tipo, SqlDbType.SmallInt, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchLOAD_ContractNRO", Item.LOAD_ContractNRO, SqlDbType.VarChar, 50, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchLOAD_PrimerUsuario", Item.LOAD_PrimerUsuario, SqlDbType.VarChar, 20, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pbitLOAD_SegundoOK", Item.LOAD_SegundoOK, SqlDbType.Bit, 1, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchLOAD_SegundoUsuario", Item.LOAD_SegundoUsuario, SqlDbType.VarChar, 20, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchLOAD_CargaUsuario", Item.LOAD_CargaUsuario, SqlDbType.VarChar, 20, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pbitLOAD_PrimerOK", Item.LOAD_PrimerOK, SqlDbType.Bit, 1, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pbitLOAD_Error", Item.LOAD_Error, SqlDbType.Bit, 1, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pbitLOAD_EnvioCorreo", Item.LOAD_EnvioCorreo, SqlDbType.Bit, 1, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmLOAD_EnvioCorreoFecha", Item.LOAD_EnvioCorreoFecha, SqlDbType.DateTime, 8, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchLOAD_EnvioCorreoUsuario", Item.LOAD_EnvioCorreoUsuario, SqlDbType.VarChar, 20, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchLOAD_ErrorDescripcion", Item.LOAD_ErrorDescripcion, SqlDbType.VarChar, 1024, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmLOAD_CargaFecha", Item.LOAD_CargaFecha, SqlDbType.DateTime, 8, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintPUER_CodOrigen", Item.PUER_CodOrigen, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintPUER_CodDestino", Item.PUER_CodDestino, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmLOAD_FecPrimerOK", Item.LOAD_FecPrimerOK, SqlDbType.DateTime, 8, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmLOAD_FecSegundoOK", Item.LOAD_FecSegundoOK, SqlDbType.DateTime, 8, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintNVIA_Codigo", Item.NVIA_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (Exception)
{ throw; }
}
public Boolean SaveLoadingListControlDoc(LoadingList Item)
{
try
{
if (Item.Instance != Infrastructure.Aspect.BusinessEntity.InstanceEntity.Unchanged)
{
return(BL_LoadingList.SaveControlDoc(ref Item));
}
return(true);
}
catch (Exception ex)
{ throw ex; }
}
private void LoadingFixMembersComplete(object sender, RunWorkerCompletedEventArgs e)
{
if (workingConn)
{
CompanyDataM.ViewZipCodeList = CompanyDataM.FullZipCodeList.Select(a => a.DataZC).ToList();
CompanyDataM.ViewSettlementList = CompanyDataM.FullSettlementList.Select(a => a.DataS).ToList();
LoadingList.RunWorkerAsync();
}
else
{
ConnectionMessage();
}
}
public void Eliminar()
{
try
{
if (_con_prealerta != true)
{
if (_load_codigo != null)
{
try
{
System.Windows.Forms.DialogResult _result = Infrastructure.WinForms.Controls.Dialogos.MostrarMensajePregunta(Title, Infrastructure.Aspect.Constants.Mensajes.PreguntaEliminar, Infrastructure.WinForms.Controls.Dialogos.LabelBoton.Si_No);
if (_result == System.Windows.Forms.DialogResult.Yes)
{
_Item = new LoadingList();
_Item.Instance = Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted;
_Item.LOAD_Codigo = _load_codigo;
if (Client.SaveLoadingListControlDoc(_Item))
{
Actualizar();
Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeSatisfactorio(Title, "Se ha eliminado el item.");
}
else
{
Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Title, "Ha ocurrido un error al guardar el item.");
}
}
}
catch (Exception ex)
{
string errorMsg = Delfin.Controls.Utils.getErrorMsg(ex);
Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, errorMsg, ex);
}
}
else
{
Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Title, "Debe seleccionar un elemento de la grilla");
}
}
else
{
Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Title, "No puede eliminar un registro que ya tiene Pre-Alerta");
}
}
catch (Exception ex)
{ Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, Infrastructure.Aspect.Constants.Mensajes.DeletePresenter, ex); }
}
private bool InsertControlDoc(ref LoadingList item)
{
try
{
if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("OPE_LOADIU_Pre_Alerta");
DataAccessEnterpriseSQL.DAAgregarParametro("@pintLOAD_Codigo", item.LOAD_Codigo, SqlDbType.Int, 4, ParameterDirection.InputOutput);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchLOAD_HBL", item.LOAD_HBL, SqlDbType.VarChar, 50, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchLOAD_MBL", item.LOAD_MBL, SqlDbType.VarChar, 50, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchLOAD_CargaUsuario", item.LOAD_CargaUsuario, SqlDbType.VarChar, 20, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
Int32 _LOAD_Codigo;
if (Int32.TryParse(DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pintLOAD_Codigo"].Value.ToString(), out _LOAD_Codigo))
{
item.LOAD_Codigo = _LOAD_Codigo;
}
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (SqlException ex)
{
if (ex.Number == 2627)
{
throw new Exception
(String.Format("# El Número de HBL ya existe en la Base de Datos. #" + ex.Message, ex));
}
else
{
throw;
}
}
catch (Exception ex)
{ throw ex; }
}
public Boolean Save(ref LoadingList 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 <LoadingList> SelectAll()
{
try
{
ObservableCollection <LoadingList> items = new ObservableCollection <LoadingList>();
LoadingList item = new LoadingList();
DataAccessEnterpriseSQL.DAAsignarProcedure("OPE_LOADSS_Todos");
using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader())
{
while (reader.Read())
{
item = new LoadingList();
Loader.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
items.Add(item);
}
}
return(items);
}
catch (Exception)
{ throw; }
}
private Boolean DeleteControlDoc(ref LoadingList item)
{
try
{
if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("OPE_LOADDU_Pre_Alerta");
DataAccessEnterpriseSQL.DAAgregarParametro("@pintLOAD_Codigo", item.LOAD_Codigo, SqlDbType.Int, 4, 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 esta Item por tener relaciones activas con otros Registros. #" + ex.Message, ex));
}
else
{
throw;
}
}
catch (Exception)
{ throw; }
}
private LoadingList SelectALoadingListByLoad_Codigo(Nullable <Int32> LOAD_Codigo)
{
try
{
DataAccessEnterpriseSQL.DAAsignarProcedure("OPE_LOADSU_Codigo");
DataAccessEnterpriseSQL.DAAgregarParametro("@pintLOAD_Codigo", LOAD_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
LoadingList item = new LoadingList();
using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader())
{
while (reader.Read())
{
item = new LoadingList();
Loader.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
}
}
return(item);
}
catch (Exception ex)
{ throw ex; }
}
private ObservableCollection <LoadingList> SelectAllByFilter(String x_procedure, ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> x_filters)
{
try
{
ObservableCollection <LoadingList> items = new ObservableCollection <LoadingList>();
LoadingList item = new LoadingList();
if (!String.IsNullOrEmpty(x_procedure))
{
DataAccessEnterpriseSQL.DAAsignarProcedure(x_procedure);
}
else
{
DataAccessEnterpriseSQL.DAAsignarProcedure("OPE_LOADSS_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 LoadingList();
Loader.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
items.Add(item);
}
}
return(items);
}
catch (Exception)
{ throw; }
}
private LoadingList SelectOne(Int32 LOAD_Codigo)
{
try
{
LoadingList item = new LoadingList();
DataAccessEnterpriseSQL.DAAsignarProcedure("OPE_LOADSS_UnReg");
DataAccessEnterpriseSQL.DAAgregarParametro("@pintLOAD_Codigo", LOAD_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; }
}
protected internal async void Refresh()
{
await Loading.Show();
new FormChecking(() => { refresh = true; LoadingList.RunWorkerAsync(); }, () => { }, true);
}
