/// <summary>
/// Metodo para obtener flete interno detalle por flete interno id
/// </summary>
/// <returns></returns>
internal List <FleteInternoCostoInfo> ObtenerPorFleteInternoDetalleId(FleteInternoDetalleInfo fleteInternoDetalleInfo)
{
try
{
Logger.Info();
var parameters = AuxFleteInternoCostoDAL.ObtenerParametrosObtenerPorFleteInternoDetalleId(fleteInternoDetalleInfo);
var ds = Retrieve("FleteInternoCosto_ObtenerPorFleteInternoDetalleID", parameters);
List <FleteInternoCostoInfo> result = null;
if (ValidateDataSet(ds))
{
result = MapFleteInternoCostoDAL.ObtenerPorFleteInternoDetalleId(ds);
}
return(result);
}
catch (SqlException ex)
{
Logger.Error(ex);
throw new ExcepcionServicio(MethodBase.GetCurrentMethod(), ex);
}
catch (DataException ex)
{
Logger.Error(ex);
throw new ExcepcionServicio(MethodBase.GetCurrentMethod(), ex);
}
catch (Exception ex)
{
Logger.Error(ex);
throw new ExcepcionDesconocida(MethodBase.GetCurrentMethod(), ex);
}
}
/// <summary>
/// Crea flete interno costo a partir de un listado
/// </summary>
internal int Crear(List <FleteInternoCostoInfo> listaFleteInternoCosto, FleteInternoDetalleInfo fleteInternoDetalleInfo)
{
try
{
Logger.Info();
Dictionary <string, object> parameters = AuxFleteInternoCostoDAL.ObtenerParametrosCrearFleteInternoCosto(listaFleteInternoCosto, fleteInternoDetalleInfo);
int result = Create("FleteInternoCosto_Crear", parameters);
return(result);
}
catch (SqlException ex)
{
Logger.Error(ex);
throw new ExcepcionServicio(MethodBase.GetCurrentMethod(), ex);
}
catch (DataException ex)
{
Logger.Error(ex);
throw new ExcepcionServicio(MethodBase.GetCurrentMethod(), ex);
}
catch (Exception ex)
{
Logger.Error(ex);
throw new ExcepcionDesconocida(MethodBase.GetCurrentMethod(), ex);
}
}
/// <summary>
/// Actualizar flete interno detalle
/// </summary>
/// <returns></returns>
internal void Actualizar(FleteInternoDetalleInfo fleteInternoDetalleInfo)
{
try
{
Logger.Info();
var fleteInternoDetalleDal = new FleteInternoDetalleDAL();
fleteInternoDetalleDal.Actualizar(fleteInternoDetalleInfo);
}
catch (ExcepcionGenerica)
{
throw;
}
catch (Exception ex)
{
Logger.Error(ex);
throw new ExcepcionDesconocida(MethodBase.GetCurrentMethod(), ex);
}
}
/// <summary>
/// Crea un flete interno detalle
/// </summary>
/// <returns></returns>
internal int Crear(FleteInternoDetalleInfo fleteInternoDetalleInfo)
{
try
{
Logger.Info();
var fleteInternoDetalleDal = new FleteInternoDetalleDAL();
int result = fleteInternoDetalleDal.Crear(fleteInternoDetalleInfo);
return(result);
}
catch (ExcepcionGenerica)
{
throw;
}
catch (Exception ex)
{
Logger.Error(ex);
throw new ExcepcionDesconocida(MethodBase.GetCurrentMethod(), ex);
}
}
/// <summary>
/// Obtener un listado de flete interno costo
/// </summary>
/// <returns></returns>
internal List <FleteInternoCostoInfo> ObtenerPorFleteInternoDetalleId(FleteInternoDetalleInfo fleteInternoDetalleInfo)
{
try
{
Logger.Info();
var fleteInternoCostoDal = new FleteInternoCostoDAL();
List <FleteInternoCostoInfo> result = fleteInternoCostoDal.ObtenerPorFleteInternoDetalleId(fleteInternoDetalleInfo);
return(result);
}
catch (ExcepcionGenerica)
{
throw;
}
catch (Exception ex)
{
Logger.Error(ex);
throw new ExcepcionDesconocida(MethodBase.GetCurrentMethod(), ex);
}
}
/// <summary>
/// Actualizar flete interno detalle
/// </summary>
internal void Actualizar(FleteInternoDetalleInfo fleteInternoDetalleInfo)
{
try
{
Logger.Info();
Dictionary <string, object> parameters = AuxFleteInternoDetalleDAL.ObtenerParametrosActualizarFleteInternoDetalle(fleteInternoDetalleInfo);
Update("FleteInternoDetalle_Actualizar", parameters);
}
catch (SqlException ex)
{
Logger.Error(ex);
throw new ExcepcionServicio(MethodBase.GetCurrentMethod(), ex);
}
catch (DataException ex)
{
Logger.Error(ex);
throw new ExcepcionServicio(MethodBase.GetCurrentMethod(), ex);
}
catch (Exception ex)
{
Logger.Error(ex);
throw new ExcepcionDesconocida(MethodBase.GetCurrentMethod(), ex);
}
}
/// <summary>
/// Actualiza un flete interno detalle
/// </summary>
/// <param name="fleteInternoDetalleInfo"></param>
/// <returns></returns>
internal static Dictionary <string, object> ObtenerParametrosActualizarFleteInternoDetalle(FleteInternoDetalleInfo fleteInternoDetalleInfo)
{
try
{
Logger.Info();
var parametros =
new Dictionary <string, object>
{
{ "@FleteInternoDetalleID", fleteInternoDetalleInfo.FleteInternoDetalleId },
{ "@MermaPermitida", fleteInternoDetalleInfo.MermaPermitida },
{ "@Observaciones", fleteInternoDetalleInfo.Observaciones },
{ "@Activo", fleteInternoDetalleInfo.Activo.GetHashCode() },
{ "@UsuarioModificacionID", fleteInternoDetalleInfo.UsuarioModificacionId },
{ "@TipoTarifaID", fleteInternoDetalleInfo.TipoTarifaID }
};
return(parametros);
}
catch (Exception ex)
{
Logger.Error(ex);
}
return(null);
}
/// <summary>
/// Obtener listado de fleteinternocosto por fleteinternodetalle
/// </summary>
/// <returns></returns>
internal static Dictionary <string, object> ObtenerParametrosObtenerPorFleteInternoDetalleId(FleteInternoDetalleInfo fleteInternoDetalleInfo)
{
try
{
Logger.Info();
var parametros =
new Dictionary <string, object>
{
{ "@FleteInternoDetalleID", fleteInternoDetalleInfo.FleteInternoDetalleId },
{ "@Activo", fleteInternoDetalleInfo.Activo.GetHashCode() },
};
return(parametros);
}
catch (Exception ex)
{
Logger.Error(ex);
}
return(null);
}
/// <summary>
/// Metodo que obtiene parametros para crear flete interno costo
/// </summary>
/// <returns></returns>
internal static Dictionary <string, object> ObtenerParametrosCrearFleteInternoCosto(List <FleteInternoCostoInfo> listaFleteInternoCosto, FleteInternoDetalleInfo fleteInternoDetalleInfo)
{
try
{
Logger.Info();
var xml =
new XElement("ROOT",
from detalle in listaFleteInternoCosto
select new XElement("XmlFleteInternoCosto",
new XElement("FleteInternoDetalleID", fleteInternoDetalleInfo.FleteInternoDetalleId),
new XElement("CostoID", detalle.Costo.CostoID),
new XElement("Tarifa", detalle.Tarifa),
new XElement("Activo", (int)EstatusEnum.Activo),
new XElement("UsuarioCreacionID", detalle.UsuarioCreacionId)
));
var parametros = new Dictionary <string, object>
{
{ "@XmlFleteInternoCosto", xml.ToString() }
};
return(parametros);
}
catch (Exception ex)
{
Logger.Error(ex);
throw new ExcepcionDesconocida(MethodBase.GetCurrentMethod(), ex);
}
}
