public List <Sigesoft.Node.WinClient.BE.ProtocolList> GetProtocolPagedAndFiltered(ref OperationResult pobjOperationResult, int?pintPageIndex, int?pintResultsPerPage, string pstrSortExpression, string pstrFilterExpression)
{
//mon.IsActive = true;
try
{
SigesoftEntitiesModel dbContext = new SigesoftEntitiesModel();
var query = from A in dbContext.protocol
join B in dbContext.organization on A.v_EmployerOrganizationId equals B.v_OrganizationId
join C in dbContext.location on A.v_EmployerLocationId equals C.v_LocationId
join D in dbContext.groupoccupation on A.v_GroupOccupationId equals D.v_GroupOccupationId
join E in dbContext.systemparameter on new { a = A.i_EsoTypeId.Value, b = 118 }
equals new { a = E.i_ParameterId, b = E.i_GroupId } into J3_join
from E in J3_join.DefaultIfEmpty()
join F in dbContext.organization on A.v_CustomerOrganizationId equals F.v_OrganizationId
join I in dbContext.location on A.v_CustomerLocationId equals I.v_LocationId
join G in dbContext.organization on A.v_WorkingOrganizationId equals G.v_OrganizationId into J4_join
from G in J4_join.DefaultIfEmpty()
join J in dbContext.location on A.v_WorkingLocationId equals J.v_LocationId into J6_join
from J in J6_join.DefaultIfEmpty()
join H in dbContext.systemparameter on new { a = A.i_MasterServiceId.Value, b = 119 }
equals new { a = H.i_ParameterId, b = H.i_GroupId } into J5_join
from H in J5_join.DefaultIfEmpty()
join J1 in dbContext.systemuser on new { i_InsertUserId = A.i_InsertUserId.Value }
equals new { i_InsertUserId = J1.i_SystemUserId } into J1_join
from J1 in J1_join.DefaultIfEmpty()
join J2 in dbContext.systemuser on new { i_UpdateUserId = A.i_UpdateUserId.Value }
equals new { i_UpdateUserId = J2.i_SystemUserId } into J2_join
from J2 in J2_join.DefaultIfEmpty()
where A.i_IsDeleted == 0
select new Sigesoft.Node.WinClient.BE.ProtocolList
{
v_ProtocolId = A.v_ProtocolId,
v_Protocol = A.v_Name,
v_Organization = B.v_Name + " / " + C.v_Name,
v_Location = C.v_Name,
v_EsoType = E.v_Value1,
v_GroupOccupation = D.v_Name,
v_OrganizationInvoice = F.v_Name + " / " + I.v_Name,
v_CostCenter = A.v_CostCenter,
v_IntermediaryOrganization = G.v_Name + " / " + J.v_Name,
i_ServiceTypeId = A.i_MasterServiceTypeId.Value,
v_MasterServiceName = H.v_Value1,
i_MasterServiceId = A.i_MasterServiceId.Value,
v_OrganizationId = F.v_OrganizationId + "|" + I.v_LocationId,
i_EsoTypeId = A.i_EsoTypeId,
v_WorkingOrganizationId = G.v_OrganizationId,
v_OrganizationInvoiceId = F.v_OrganizationId,
v_GroupOccupationId = D.v_GroupOccupationId,
v_CreationUser = J1.v_UserName,
v_UpdateUser = J2.v_UserName,
d_CreationDate = A.d_InsertDate,
d_UpdateDate = A.d_UpdateDate,
v_LocationId = A.v_EmployerLocationId,
v_CustomerLocationId = A.v_CustomerLocationId,
v_WorkingLocationId = A.v_WorkingLocationId,
i_IsActive = A.i_IsActive
};
if (!string.IsNullOrEmpty(pstrFilterExpression))
{
query = query.Where(pstrFilterExpression);
}
if (!string.IsNullOrEmpty(pstrSortExpression))
{
query = query.OrderBy(pstrSortExpression);
}
if (pintPageIndex.HasValue && pintResultsPerPage.HasValue)
{
int intStartRowIndex = pintPageIndex.Value * pintResultsPerPage.Value;
query = query.Skip(intStartRowIndex);
}
if (pintResultsPerPage.HasValue)
{
query = query.Take(pintResultsPerPage.Value);
}
List <Sigesoft.Node.WinClient.BE.ProtocolList> objData = query.ToList();
pobjOperationResult.Success = 1;
return(objData);
}
catch (Exception ex)
{
pobjOperationResult.Success = 0;
pobjOperationResult.ExceptionMessage = Common.Utils.ExceptionFormatter(ex);
return(null);
}
}
public static BoardProtocol GetAllProtocols(BoardProtocol data)
{
try
{
string WorkingOrganization = data.EmpresaTrabajo == "-1" ? "-1" : data.EmpresaTrabajo.Split('|')[0];
string EmployerOrganization = data.EmpresaEmpleadora == "-1" ? "-1" : data.EmpresaEmpleadora.Split('|')[0];
string CustomerOrganization = data.EmpresaCliente == "-1" ? "-1" : data.EmpresaCliente.Split('|')[0];
DatabaseContext dbContext = new DatabaseContext();
int skip = (data.Index - 1) * data.Take;
var query = from A in dbContext.Protocol
join B in dbContext.Organization on A.v_EmployerOrganizationId equals B.v_OrganizationId
join C in dbContext.Location on A.v_EmployerLocationId equals C.v_LocationId
join D in dbContext.GroupOccupation on A.v_GroupOccupationId equals D.v_GroupOccupationId
join E in dbContext.SystemParameter on new { a = A.i_EsoTypeId.Value, b = 118 }
equals new { a = E.i_ParameterId, b = E.i_GroupId } into J3_join
from E in J3_join.DefaultIfEmpty()
join F in dbContext.Organization on A.v_CustomerOrganizationId equals F.v_OrganizationId
join I in dbContext.Location on A.v_CustomerLocationId equals I.v_LocationId
join G in dbContext.Organization on A.v_WorkingOrganizationId equals G.v_OrganizationId into J4_join
from G in J4_join.DefaultIfEmpty()
join J in dbContext.Location on A.v_WorkingLocationId equals J.v_LocationId into J6_join
from J in J6_join.DefaultIfEmpty()
join H in dbContext.SystemParameter on new { a = A.i_MasterServiceId.Value, b = 119 }
equals new { a = H.i_ParameterId, b = H.i_GroupId } into J5_join
from H in J5_join.DefaultIfEmpty()
join J1 in dbContext.SystemUser on new { i_InsertUserId = A.i_InsertUserId.Value }
equals new { i_InsertUserId = J1.i_SystemUserId } into J1_join
from J1 in J1_join.DefaultIfEmpty()
join J2 in dbContext.SystemUser on new { i_UpdateUserId = A.i_UpdateUserId.Value }
equals new { i_UpdateUserId = J2.i_SystemUserId } into J2_join
from J2 in J2_join.DefaultIfEmpty()
join L in dbContext.ProtocolComponent on A.v_ProtocolId equals L.v_ProtocolId
join K in dbContext.Component on L.v_ComponentId equals K.v_ComponentId
where A.i_IsDeleted == 0 &&
(A.v_Name.Contains(data.ProtocolName) || data.ProtocolName == null) &&
(A.i_MasterServiceId == data.MasterService || data.MasterService == -1) && (B.v_OrganizationId == EmployerOrganization || EmployerOrganization == "-1") &&
(F.v_OrganizationId == CustomerOrganization || CustomerOrganization == "-1") && (G.v_OrganizationId == WorkingOrganization || WorkingOrganization == "-1") &&
(A.i_MasterServiceTypeId == data.MasterServiceType || data.MasterServiceType == -1) && (D.v_GroupOccupationId == data.GESO || data.GESO == "-1") && (A.i_EsoTypeId == data.EsoType || data.EsoType == -1) &&
(K.v_Name.Contains(data.ComponentName) || data.ComponentName == null) && A.i_IsActive == data.IsActive
select new ProtocolList
{
v_ProtocolId = A.v_ProtocolId,
v_Protocol = A.v_Name,
v_Organization = B.v_Name + " / " + C.v_Name,
v_Location = C.v_Name,
v_EsoType = E.v_Value1,
v_GroupOccupation = D.v_Name,
v_OrganizationInvoice = F.v_Name + " / " + I.v_Name,
v_CostCenter = A.v_CostCenter,
v_IntermediaryOrganization = G.v_Name + " / " + J.v_Name,
i_ServiceTypeId = A.i_MasterServiceTypeId.Value,
v_MasterServiceName = H.v_Value1,
i_MasterServiceId = A.i_MasterServiceId.Value,
v_OrganizationId = B.v_OrganizationId + "|" + C.v_LocationId,
i_EsoTypeId = A.i_EsoTypeId,
v_WorkingOrganizationId = G.v_OrganizationId + "|" + J.v_LocationId,
v_OrganizationInvoiceId = F.v_OrganizationId + "|" + I.v_LocationId,
v_GroupOccupationId = D.v_GroupOccupationId,
v_Geso = D.v_Name,
v_CreationUser = J1.v_UserName,
v_UpdateUser = J2.v_UserName,
d_CreationDate = A.d_InsertDate,
d_UpdateDate = A.d_UpdateDate,
v_LocationId = A.v_EmployerLocationId,
v_CustomerLocationId = A.v_CustomerLocationId,
v_WorkingLocationId = A.v_WorkingLocationId,
i_IsActive = A.i_IsActive,
v_ComponenteNombre = K.v_Name,
r_PriceFactor = A.r_PriceFactor,
r_HospitalBedPrice = A.r_HospitalBedPrice,
r_DiscountExam = A.r_DiscountExam,
r_MedicineDiscount = A.r_MedicineDiscount,
AseguradoraId = A.v_AseguradoraOrganizationId
};
var list = query.ToList();
list = list.GroupBy(x => x.v_ProtocolId).Select(z => z.First()).OrderByDescending(x => x.v_ProtocolId).ToList();
int totalRecords = list.Count;
if (data.Take > 0)
{
list = list.Skip(skip).Take(data.Take).ToList();
}
data.List = list;
data.TotalRecords = totalRecords;
return(data);
}
catch (Exception ex)
{
return(null);
}
}
public static ProtocolList GetProtocolById(string pstrProtocolId)
{
try
{
DatabaseContext dbContext = new DatabaseContext();
var objProtocol = (from A in dbContext.Protocol
join B in dbContext.Organization on A.v_EmployerOrganizationId equals B.v_OrganizationId
join C in dbContext.Location on A.v_EmployerLocationId equals C.v_LocationId
join D in dbContext.GroupOccupation on A.v_GroupOccupationId equals D.v_GroupOccupationId
join E in dbContext.SystemParameter on new { a = A.i_EsoTypeId.Value, b = 118 } equals new { a = E.i_ParameterId, b = E.i_GroupId }
join F in dbContext.Organization on A.v_CustomerOrganizationId equals F.v_OrganizationId
join H in dbContext.SystemParameter on new { a = A.i_MasterServiceId.Value, b = 119 } equals new { a = H.i_ParameterId, b = H.i_GroupId }
join I in dbContext.Location on A.v_CustomerLocationId equals I.v_LocationId
join J in dbContext.Location on A.v_EmployerLocationId equals J.v_LocationId
join J1 in dbContext.SystemUser on new { i_InsertUserId = A.i_InsertUserId.Value }
equals new { i_InsertUserId = J1.i_SystemUserId } into J1_join
from J1 in J1_join.DefaultIfEmpty()
join J2 in dbContext.SystemUser on new { i_UpdateUserId = A.i_UpdateUserId.Value }
equals new { i_UpdateUserId = J2.i_SystemUserId } into J2_join
from J2 in J2_join.DefaultIfEmpty()
join J3 in dbContext.Organization on new { a = A.v_WorkingOrganizationId }
equals new { a = J3.v_OrganizationId } into J3_join
from J3 in J3_join.DefaultIfEmpty()
join J4 in dbContext.Area on new { a = C.v_LocationId }
equals new { a = J4.v_LocationId } into J4_join
from J4 in J4_join.DefaultIfEmpty()
join J5 in dbContext.Ges on new { a = J4.v_AreaId }
equals new { a = J5.v_AreaId } into J5_join
from J5 in J5_join.DefaultIfEmpty()
join J6 in dbContext.Occupation on new { a = J5.v_GesId, b = D.v_GroupOccupationId }
equals new { a = J6.v_GesId, b = J6.v_GroupOccupationId } into J6_join
from J6 in J6_join.DefaultIfEmpty()
//join J7 in dbContext.groupoccupation on new { a = J4.v_AreaId }
// equals new { a = J7.v_AreaId } into J7_join
//from J5 in J5_join.DefaultIfEmpty()
where (A.v_ProtocolId == pstrProtocolId) && (A.i_IsDeleted == 0)
select new ProtocolList
{
v_Name = A.v_Name,
v_ProtocolId = A.v_ProtocolId, //id Protocolo
v_Protocol = A.v_Name, // monbre protocolo
v_Organization = B.v_Name + " / " + J.v_Name, // nombre organizacion
v_Location = C.v_Name, // nombre de sede
v_EsoType = E.v_Value1, // Esoa, Esor
v_OrganizationInvoice = F.v_Name, // empresa que factura
v_CostCenter = A.v_CostCenter, // centro de costo
v_IntermediaryOrganization = J3.v_Name + " / " + I.v_Name, // empresa intermediaria
v_MasterServiceName = H.v_Value1, // Eso o no Eo
v_OrganizationId = B.v_OrganizationId,
i_EsoTypeId = E.i_ParameterId, // Id de (Esoa, Esor, Espo)
v_WorkingOrganizationId = J3.v_OrganizationId,
v_OrganizationInvoiceId = F.v_OrganizationId,
v_GroupOccupationId = D.v_GroupOccupationId,
v_Ges = J5.v_Name,
v_GroupOccupation = D.v_Name, // nombre GESO
v_Occupation = J6.v_Name,
i_ServiceTypeId = A.i_MasterServiceTypeId.Value,
i_MasterServiceId = A.i_MasterServiceId.Value,
v_CreationUser = J1.v_UserName,
v_UpdateUser = J2.v_UserName,
d_CreationDate = A.d_InsertDate,
d_UpdateDate = A.d_UpdateDate,
v_ContacName = F.v_ContacName,
v_Address = F.v_Address,
v_CustomerOrganizationId = A.v_CustomerOrganizationId
}).FirstOrDefault();
ProtocolList objData = objProtocol;
return(objData);
}
catch (Exception ex)
{
return(null);
}
}
public BoardProductsSAMBHS GetProductsSAMBHS_PV(BoardProductsSAMBHS data)
{
try
{
DatabaseSAMBHSContext cnx = new DatabaseSAMBHSContext();
var RucEmpresa = data.RucEmpresa == null ? "" : data.RucEmpresa;
var fltValue = data.ProductName == null ? "" : data.ProductName;
var ListaSaldosIniciales = new List <CostoNotasIngresoPedido>();
data.IdAlmacen = int.Parse(System.Configuration.ConfigurationManager.AppSettings["appAlmacenPredeterminado"]);
var periodo = DateTime.Now.Year.ToString();
if (RucEmpresa == Constants.RucWortec)
{
ListaSaldosIniciales = SaldosIniciales(periodo);
}
IQueryable query;
if (data.ConStock)
{
#region Query Con Stock
query = (from n in cnx.Producto
join D in cnx.ProductoDetalle on n.v_IdProducto equals D.v_IdProducto into D_join
from D in D_join.DefaultIfEmpty()
join J3 in cnx.ProductoAlmacen on new { a = D.v_IdProductoDetalle, b = data.IdAlmacen, eliminado = 0, _periodo = periodo } equals new { a = J3.v_ProductoDetalleId, b = J3.i_IdAlmacen, eliminado = J3.i_Eliminado.Value, _periodo = J3.v_Periodo } into J3_join
from J3 in J3_join.DefaultIfEmpty()
join J4 in cnx.DataHierarchy on new { a = n.i_IdUnidadMedida.Value, b = 17 }
equals new { a = J4.i_ItemId.Value, b = J4.i_GroupId } into J4_join
from J4 in J4_join.DefaultIfEmpty()
join J5 in cnx.Linea on n.v_IdLinea equals J5.v_IdLinea into J5_join
from J5 in J5_join.DefaultIfEmpty()
join J6 in cnx.DataHierarchy on new { a = n.i_IdPerfilDetraccion.Value, b = 176 }
equals new { a = J6.i_ItemId.Value, b = J6.i_GroupId } into J6_join
from J6 in J6_join.DefaultIfEmpty()
where (n.v_Descripcion.Contains(fltValue) || n.v_CodInterno.Contains(fltValue) || fltValue == "") && n.i_Eliminado == 0 && n.i_EsServicio == 0 && n.i_EsActivoFijo == 0 && n.i_EsActivo == 1 &&
J3.d_StockActual > 0 &&
J3_join.Any(p => p.v_ProductoDetalleId == D.v_IdProductoDetalle) // <---linea clave
select new
{
n.v_IdProducto,
D.v_IdProductoDetalle,
n.v_Descripcion,
n.v_CodInterno,
n.i_EsServicio,
n.i_EsLote,
n.d_PrecioVenta,
n.i_IdTipoProducto,
stockActual = J3.d_StockActual,
J3.v_IdProductoAlmacen,
d_separacion = J3.d_SeparacionTotal ?? 0,
n.i_IdUnidadMedida,
EmpaqueUnidadMedida = J4.v_Value1,
n.d_Empaque,
n.i_EsAfectoDetraccion,
TasaDetraccion = J6 != null ? J6.v_Value2 : "0",
TopeDetraccion = J6 != null ? J6.v_Field : "0",
n.i_NombreEditable,
StockDisponible = J3.d_StockActual - J3.d_SeparacionTotal,
n.i_ValidarStock,
n.i_EsAfectoPercepcion,
n.d_TasaPercepcion,
n.i_PrecioEditable,
ProductoAlmacen = J3.v_IdProductoAlmacen,
NroCuentaVenta = J5.v_NroCuentaVenta,
NroCuentaCompra = J5.v_NroCuentaCompra,
J3.i_IdAlmacen,
v_NroPedidoExportacion = J3.v_NroPedido,
ValorUM = string.IsNullOrEmpty(J4.v_Value2) ? "0" : J4.v_Value2,
UM = "UNIDADES",
Observaciones = n.v_Caracteristica,
AfectoIsc = n.i_EsAfectoIsc,
StockMinimo = n.d_StockMinimo == null ? 1 : J3 == null || J3.d_StockActual == null ? 1 : J3.d_StockActual <= n.d_StockMinimo ? 1 : 0,
n.v_Descripcion2,
i_SolicitarNroLoteIngreso = n.i_SolicitarNroLoteIngreso ?? 0,
i_SolicitarNroSerieIngreso = n.i_SolicitarNroSerieIngreso ?? 0,
i_SolicitaOrdenProduccionIngreso = n.i_SolicitaOrdenProduccionIngreso ?? 0,
i_SolicitarNroSerieSalida = n.i_SolicitarNroSerieSalida ?? 0,
i_SolicitarNroLoteSalida = n.i_SolicitarNroLoteSalida ?? 0,
i_SolicitaOrdenProduccionSalida = n.i_SolicitaOrdenProduccionSalida ?? 0,
J3.v_NroLote,
J3.v_NroSerie,
t_FechaCaducidad = J3.t_FechaCaducidad == null ? Fechanull : J3.t_FechaCaducidad,
}).ToList().Select(p =>
{
var PrecioWortec = Constants.RucWortec == RucEmpresa
? ListaSaldosIniciales.Where(
a =>
a.v_IdProductoDetalle == p.v_IdProductoDetalle &&
a.NroPedido == p.v_NroPedidoExportacion).ToList()
: null;
return(new ProductCustomSAMBHS
{
TasaDetraccion = p.TasaDetraccion,
TopeDetraccion = p.TopeDetraccion,
v_IdProducto = p.v_IdProducto,
v_IdProductoDetalle = p.v_IdProductoDetalle,
v_Descripcion = p.v_Descripcion,
v_CodInterno = p.v_CodInterno,
i_EsServicio = p.i_EsServicio,
i_EsLote = p.i_EsLote,
i_IdTipoProducto = p.i_IdTipoProducto,
stockActual = p.stockActual,
v_IdProductoAlmacen = p.v_IdProductoAlmacen,
d_separacion = p.d_separacion,
i_IdUnidadMedida = p.i_IdUnidadMedida,
EmpaqueUnidadMedida = p.EmpaqueUnidadMedida,
d_Empaque = p.d_Empaque,
i_EsAfectoDetraccion = p.i_EsAfectoDetraccion,
i_NombreEditable = p.i_NombreEditable,
StockDisponible = p.StockDisponible,
i_ValidarStock = p.i_ValidarStock,
i_EsAfectoPercepcion = p.i_EsAfectoPercepcion,
d_TasaPercepcion = p.d_TasaPercepcion,
i_PrecioEditable = p.i_PrecioEditable,
d_Precio = Constants.RucWortec == RucEmpresa ? (PrecioWortec.Any() ? DevuelveValorRedondeado(PrecioWortec.Average(x => x.Costo), 4)
: 0)
: p.d_PrecioVenta,
d_Descuento = 0,
IdMoneda = 1,
NroCuentaVenta = p.NroCuentaVenta,
NroCuentaCompra = p.NroCuentaCompra,
IdAlmacen = p.i_IdAlmacen,
v_NroPedidoExportacion = p.v_NroPedidoExportacion,
StockActualUM = p.stockActual / int.Parse(p.ValorUM),
SeparacionActualUM = p.d_separacion / int.Parse(p.ValorUM),
SaldoUM = (p.stockActual / int.Parse(p.ValorUM)) - p.d_separacion / int.Parse(p.ValorUM),
UM = p.UM,
Observacion = p.Observaciones.Trim(),
EsAfectoIsc = p.AfectoIsc.HasValue && p.AfectoIsc == 1,
StockMinimo = p.StockMinimo,
v_Descripcion2 = p.v_Descripcion2,
i_SolicitarNroLoteIngreso = p.i_SolicitarNroLoteIngreso,
i_SolicitarNroSerieIngreso = p.i_SolicitarNroSerieIngreso,
i_SolicitaOrdenProduccionIngreso = p.i_SolicitaOrdenProduccionIngreso,
i_SolicitarNroSerieSalida = p.i_SolicitarNroSerieSalida,
i_SolicitarNroLoteSalida = p.i_SolicitarNroLoteSalida,
i_SolicitaOrdenProduccionSalida = p.i_SolicitaOrdenProduccionSalida,
v_NroLote = p.v_NroLote,
v_NroSerie = p.v_NroSerie,
t_FechaCaducidad = p.t_FechaCaducidad.Value,
});
}).AsQueryable();
int skip = (data.Index - 1) * data.Take;
var FinalList = query.Cast <ProductCustomSAMBHS>().ToList().OrderBy(o => o.t_FechaCaducidad).ToList();
var ListProducts = FinalList.GroupBy(g => g.v_IdProducto).Select(s => s.First()).ToList();
data.TotalRecords = ListProducts.Count;
if (data.Take > 0)
{
ListProducts = ListProducts.Skip(skip).Take(data.Take).ToList();
}
data.List = ListProducts;
#endregion
}
else
{
#region Query Sin Importar Stock
query = (from n in cnx.Producto
join D in cnx.ProductoDetalle on n.v_IdProducto equals D.v_IdProducto into D_join
from D in D_join.DefaultIfEmpty()
join J4 in cnx.DataHierarchy on new { a = n.i_IdUnidadMedida, b = 17 }
equals new { a = J4.i_ItemId, b = J4.i_GroupId } into J4_join
from J4 in J4_join.DefaultIfEmpty()
join J5 in cnx.Linea on n.v_IdLinea equals J5.v_IdLinea into J5_join
from J5 in J5_join.DefaultIfEmpty()
join J6 in cnx.ProductoAlmacen on new { a = D.v_IdProductoDetalle, b = data.IdAlmacen, eliminado = 0, _periodo = periodo }
equals new { a = J6.v_ProductoDetalleId, b = J6.i_IdAlmacen, eliminado = J6.i_Eliminado.Value, _periodo = J6.v_Periodo } into J6_join
from J6 in J6_join.DefaultIfEmpty()
join J7 in cnx.DataHierarchy on new { a = n.i_IdPerfilDetraccion, b = 176 }
equals new { a = J7.i_ItemId, b = J7.i_GroupId } into J7_join
from J7 in J7_join.DefaultIfEmpty()
where n.i_Eliminado == 0 && n.i_EsServicio == 0 && n.i_EsActivoFijo == 0 && n.i_EsActivo == 1 &&
D_join.Any(p => p.v_IdProductoDetalle.Equals(J6.v_ProductoDetalleId))
select new
{
v_IdProducto = n.v_IdProducto,
v_IdProductoDetalle = D.v_IdProductoDetalle,
v_Descripcion = n.v_Descripcion,
v_CodInterno = n.v_CodInterno,
i_EsServicio = n.i_EsServicio,
i_EsLote = n.i_EsLote,
n.d_PrecioVenta,
i_IdTipoProducto = n.i_IdTipoProducto,
i_IdUnidadMedida = n.i_IdUnidadMedida,
EmpaqueUnidadMedida = J4.v_Value1,
d_Empaque = n.d_Empaque,
i_EsAfectoDetraccion = n.i_EsAfectoDetraccion,
i_NombreEditable = n.i_NombreEditable,
i_ValidarStock = n.i_ValidarStock,
i_EsAfectoPercepcion = n.i_EsAfectoPercepcion,
d_TasaPercepcion = n.d_TasaPercepcion,
i_PrecioEditable = n.i_PrecioEditable,
NroCuentaVenta = J5.v_NroCuentaVenta,
NroCuentaCompra = J5.v_NroCuentaCompra,
NroPedido = J6.v_NroPedido,
stockActual = J6.d_StockActual,
v_IdProductoAlmacen = J6.v_IdProductoAlmacen,
d_Separacion = J6.d_SeparacionTotal == null ? 0 : J6.d_SeparacionTotal,
d_StockActual = J6.d_StockActual,
i_IdAlmacen = J6.i_IdAlmacen,
v_NroPedidoExportacion = J6.v_NroPedido,
ValorUM = string.IsNullOrEmpty(J4.v_Value2) ? "0" : J4.v_Value2,
UM = "UNIDADES",
AfectoIsc = n.i_EsAfectoIsc,
StockMinimo = n.d_StockMinimo == null ? 1 : J6 == null || J6.d_StockActual == null ? 1 : J6.d_StockActual <= n.d_StockMinimo ? 1 : 0,
v_Descripcion2 = n.v_Descripcion2,
TasaDetraccion = J7 != null ? J7.v_Value2 : "0",
TopeDetraccion = J7 != null ? J7.v_Field : "0",
i_SolicitarNroLoteIngreso = n.i_SolicitarNroLoteIngreso ?? 0,
i_SolicitarNroSerieIngreso = n.i_SolicitarNroSerieIngreso ?? 0,
i_SolicitaOrdenProduccionIngreso = n.i_SolicitaOrdenProduccionIngreso ?? 0,
i_SolicitarNroSerieSalida = n.i_SolicitarNroSerieSalida ?? 0,
i_SolicitarNroLoteSalida = n.i_SolicitarNroLoteSalida ?? 0,
i_SolicitaOrdenProduccionSalida = n.i_SolicitaOrdenProduccionSalida ?? 0,
v_NroLote = J6.v_NroLote,
v_NroSerie = J6.v_NroSerie,
t_FechaCaducidad = J6.t_FechaCaducidad == null ? Fechanull : J6.t_FechaCaducidad.Value,
}).ToList().Select(p =>
{
decimal?PrecioWortec = Constants.RucWortec == RucEmpresa
? ListaSaldosIniciales.Where(
a =>
a.v_IdProductoDetalle == p.v_IdProductoDetalle &&
a.NroPedido == p.v_NroPedidoExportacion).Sum(a => a.Costo)
: 0;
return(new ProductCustomSAMBHS
{
v_IdProducto = p.v_IdProducto,
v_IdProductoDetalle = p.v_IdProductoDetalle,
v_Descripcion = p.v_Descripcion,
v_CodInterno = p.v_CodInterno,
i_EsServicio = p.i_EsServicio,
i_EsLote = p.i_EsLote,
i_IdTipoProducto = p.i_IdTipoProducto,
stockActual = p.v_IdProductoAlmacen != null ? p.stockActual ?? 0 : 0,
v_IdProductoAlmacen = p.v_IdProductoAlmacen,
d_separacion = p.v_IdProductoAlmacen != null ? p.d_Separacion ?? 0 : 0,
i_IdUnidadMedida = p.i_IdUnidadMedida,
EmpaqueUnidadMedida = p.EmpaqueUnidadMedida,
d_Empaque = p.d_Empaque,
i_EsAfectoDetraccion = p.i_EsAfectoDetraccion,
i_NombreEditable = p.i_NombreEditable,
StockDisponible = p.d_StockActual,
i_ValidarStock = p.i_ValidarStock,
i_EsAfectoPercepcion = p.i_EsAfectoPercepcion,
d_TasaPercepcion = p.d_TasaPercepcion,
i_PrecioEditable = p.i_PrecioEditable,
d_Precio = p.v_IdProductoAlmacen != null ? RucEmpresa == Constants.RucWortec ? PrecioWortec != null ? PrecioWortec : 0 : p.d_PrecioVenta : 0,
d_Descuento = 0,
IdMoneda = 1,
NroCuentaVenta = p.NroCuentaVenta,
NroCuentaCompra = p.NroCuentaCompra,
IdAlmacen =
p.v_IdProductoAlmacen != null ? -1 : p.i_IdAlmacen == 0 ? -1 : p.i_IdAlmacen,
v_NroPedidoExportacion = p.NroPedido,
StockActualUM = p.stockActual == 0 || p.ValorUM == "0" ? 0 : p.stockActual / int.Parse(p.ValorUM),
SeparacionActualUM = p.d_Separacion == 0 || p.ValorUM == "0" ? 0 : p.d_Separacion / int.Parse(p.ValorUM),
SaldoUM =
p.ValorUM == "0"
? 0
: p.stockActual != 0 && p.ValorUM != "0" && p.d_Separacion != 0
? (p.stockActual / int.Parse(p.ValorUM)) -
p.d_Separacion / int.Parse(p.ValorUM)
: p.stockActual == 0 && p.ValorUM != "0" && p.d_Separacion != 0
? -p.d_Separacion / int.Parse(p.ValorUM)
: p.d_Separacion == 0 && p.ValorUM != "0" && p.stockActual != 0
? (p.stockActual / int.Parse(p.ValorUM))
: 0,
UM = p.UM,
EsAfectoIsc = p.AfectoIsc.HasValue && p.AfectoIsc == 1,
StockMinimo = p.StockMinimo,
v_Descripcion2 = p.v_Descripcion2,
TasaDetraccion = p.TasaDetraccion,
TopeDetraccion = p.TopeDetraccion,
i_SolicitarNroLoteIngreso = p.i_SolicitarNroLoteIngreso,
i_SolicitarNroSerieIngreso = p.i_SolicitarNroSerieIngreso,
i_SolicitaOrdenProduccionIngreso = p.i_SolicitaOrdenProduccionIngreso,
i_SolicitarNroSerieSalida = p.i_SolicitarNroSerieSalida,
i_SolicitarNroLoteSalida = p.i_SolicitarNroLoteSalida,
i_SolicitaOrdenProduccionSalida = p.i_SolicitaOrdenProduccionSalida,
v_NroSerie = p.v_NroSerie,
v_NroLote = p.v_NroLote,
t_FechaCaducidad = p.t_FechaCaducidad,
});
}).AsQueryable();
int skip = (data.Index - 1) * data.Take;
var FinalList = query.Cast <ProductCustomSAMBHS>().ToList().OrderBy(o => o.t_FechaCaducidad).ToList();
var ListProducts = FinalList.GroupBy(g => g.v_IdProducto).Select(s => s.First()).ToList();
data.TotalRecords = ListProducts.Count;
if (data.Take > 0)
{
ListProducts = ListProducts.Skip(skip).Take(data.Take).ToList();
}
data.List = ListProducts;
#endregion
}
return(data);
}
catch (Exception ex)
{
return(null);
}
}
