Ejemplo n.º 1
0
        public async Task <IActionResult> GetBoletaDeSalidaById(Int64 BoletaDeSalidaId)
        {
            BoletaDeSalida Items = new BoletaDeSalida();

            try
            {
                Items = await _context.BoletaDeSalida.Where(q => q.BoletaDeSalidaId == BoletaDeSalidaId).FirstOrDefaultAsync();
            }
            catch (Exception ex)
            {
                _logger.LogError($"Ocurrio un error: { ex.ToString() }");
                return(BadRequest($"Ocurrio un error:{ex.Message}"));
            }


            return(Ok(Items));
        }
Ejemplo n.º 2
0
        public async Task <ActionResult <BoletaDeSalida> > Insert([FromBody] BoletaDeSalida _BoletaDeSalida)
        {
            BoletaDeSalida _BoletaDeSalidaq = new BoletaDeSalida();

            try
            {
                _BoletaDeSalidaq = _BoletaDeSalida;
                _context.BoletaDeSalida.Add(_BoletaDeSalidaq);
                await _context.SaveChangesAsync();
            }
            catch (Exception ex)
            {
                _logger.LogError($"Ocurrio un error: { ex.ToString() }");
                return(BadRequest($"Ocurrio un error:{ex.Message}"));
            }

            return(Ok(_BoletaDeSalidaq));
        }
Ejemplo n.º 3
0
        public async Task <IActionResult> Delete([FromBody] BoletaDeSalida _BoletaDeSalida)
        {
            BoletaDeSalida _BoletaDeSalidaq = new BoletaDeSalida();

            try
            {
                _BoletaDeSalidaq = _context.BoletaDeSalida
                                   .Where(x => x.BoletaDeSalidaId == (Int64)_BoletaDeSalida.BoletaDeSalidaId)
                                   .FirstOrDefault();

                _context.BoletaDeSalida.Remove(_BoletaDeSalidaq);
                await _context.SaveChangesAsync();
            }
            catch (Exception ex)
            {
                _logger.LogError($"Ocurrio un error: { ex.ToString() }");
                return(BadRequest($"Ocurrio un error:{ex.Message}"));
            }

            return(Ok(_BoletaDeSalidaq));
        }
Ejemplo n.º 4
0
        public async Task <ActionResult <BoletaDeSalida> > Update([FromBody] BoletaDeSalida _BoletaDeSalida)
        {
            BoletaDeSalida _BoletaDeSalidaq = _BoletaDeSalida;

            try
            {
                _BoletaDeSalidaq = await(from c in _context.BoletaDeSalida
                                         .Where(q => q.BoletaDeSalidaId == _BoletaDeSalida.BoletaDeSalidaId)
                                         select c
                                         ).FirstOrDefaultAsync();

                _context.Entry(_BoletaDeSalidaq).CurrentValues.SetValues((_BoletaDeSalida));

                //_context.BoletaDeSalida.Update(_BoletaDeSalidaq);
                await _context.SaveChangesAsync();
            }
            catch (Exception ex)
            {
                _logger.LogError($"Ocurrio un error: { ex.ToString() }");
                return(BadRequest($"Ocurrio un error:{ex.Message}"));
            }

            return(Ok(_BoletaDeSalidaq));
        }
Ejemplo n.º 5
0
        public async Task <ActionResult <GoodsDelivered> > Insert([FromBody] GoodsDeliveredDTO _GoodsDelivered)
        {
            GoodsDelivered _GoodsDeliveredq = new GoodsDelivered();

            try
            {
                using (var transaction = _context.Database.BeginTransaction())
                {
                    try
                    {
                        _GoodsDeliveredq = _GoodsDelivered;

                        BoletaDeSalida _boletadesalida = new BoletaDeSalida
                        {
                            BranchId                     = _GoodsDelivered.BranchId,
                            BranchName                   = _GoodsDelivered.BranchName,
                            CustomerId                   = _GoodsDelivered.CustomerId,
                            CustomerName                 = _GoodsDelivered.CustomerName,
                            DocumentDate                 = _GoodsDelivered.DocumentDate,
                            FechaCreacion                = DateTime.Now,
                            FechaModificacion            = DateTime.Now,
                            Marca                        = _GoodsDelivered.Marca,
                            Placa                        = _GoodsDelivered.Placa,
                            Motorista                    = _GoodsDelivered.Name,
                            Quantity                     = _GoodsDelivered._GoodsDeliveredLine.Select(q => q.QuantitySacos).Sum(),
                            SubProductId                 = _GoodsDelivered.SubProductId,
                            SubProductName               = _GoodsDelivered.SubProductName,
                            GoodsDeliveryAuthorizationId = _GoodsDelivered.GoodsDeliveryAuthorizationId,
                            GoodsDeliveredId             = _GoodsDeliveredq.GoodsDeliveredId,
                            CargadoId                    = 13,
                            Cargadoname                  = "Cargado",
                            UsuarioCreacion              = _GoodsDelivered.UsuarioCreacion,
                            UsuarioModificacion          = _GoodsDelivered.UsuarioModificacion,
                            UnitOfMeasureId              = _GoodsDelivered._GoodsDeliveredLine[0].UnitOfMeasureId,
                            UnitOfMeasureName            = _GoodsDelivered._GoodsDeliveredLine[0].UnitOfMeasureName,
                            WeightBallot                 = _GoodsDelivered.WeightBallot,
                        };

                        _context.BoletaDeSalida.Add(_boletadesalida);
                        await _context.SaveChangesAsync();

                        _GoodsDeliveredq.ExitTicket = _boletadesalida.BoletaDeSalidaId;

                        _context.GoodsDelivered.Add(_GoodsDeliveredq);

                        foreach (var item in _GoodsDeliveredq._GoodsDeliveredLine)
                        {
                            item.GoodsDeliveredId = _GoodsDeliveredq.GoodsDeliveredId;
                            _context.GoodsDeliveredLine.Add(item);

                            Kardex _kardexmax = await(from c in _context.Kardex
                                                      .OrderByDescending(q => q.DocumentDate)
                                                      // .Take(1)
                                                      join d in _context.KardexLine on c.KardexId equals d.KardexId
                                                      where c.CustomerId == _GoodsDeliveredq.CustomerId && d.SubProducId == item.SubProductId &&
                                                      c.DocumentName != "CD" && d.WareHouseId == item.WareHouseId
                                                      select c
                                                      )
                                                .FirstOrDefaultAsync();

                            if (_kardexmax == null)
                            {
                                _kardexmax = new Kardex();
                            }
                            KardexLine _KardexLine = await _context.KardexLine
                                                     .Where(q => q.KardexId == _kardexmax.KardexId)
                                                     .Where(q => q.SubProducId == item.SubProductId)
                                                     .Where(q => q.WareHouseId == item.WareHouseId)
                                                     .Where(q => q.BranchId == _GoodsDeliveredq.BranchId)
                                                     .OrderByDescending(q => q.KardexLineId)
                                                     .Take(1)
                                                     .FirstOrDefaultAsync();

                            SubProduct _subproduct = await(from c in _context.SubProduct
                                                           .Where(q => q.SubproductId == item.SubProductId)
                                                           select c
                                                           ).FirstOrDefaultAsync();

                            if (_KardexLine.Total > item.Quantity)
                            {
                                item.Total = _KardexLine.TotalCD - item.Quantity;
                            }
                            else
                            {
                                return(await Task.Run(() => BadRequest("Inventario insuficiente!")));
                            }

                            _GoodsDelivered.Kardex._KardexLine.Add(new KardexLine
                            {
                                DocumentDate      = _GoodsDeliveredq.DocumentDate,
                                ProducId          = _GoodsDeliveredq.ProductId,
                                ProductName       = _GoodsDeliveredq.ProductName,
                                SubProducId       = item.SubProductId,
                                SubProductName    = item.SubProductName,
                                QuantityEntry     = 0,
                                QuantityOut       = item.Quantity,
                                BranchId          = _GoodsDeliveredq.BranchId,
                                BranchName        = _GoodsDeliveredq.BranchName,
                                WareHouseId       = item.WareHouseId,
                                WareHouseName     = item.WareHouseName,
                                UnitOfMeasureId   = item.UnitOfMeasureId,
                                UnitOfMeasureName = item.UnitOfMeasureName,
                                TypeOperationId   = 1,
                                TypeOperationName = "Salida",
                                Total             = item.Total,
                                TotalBags         = _KardexLine.TotalBags - item.QuantitySacos,
                                QuantityOutCD     = item.Quantity - (item.Quantity * _subproduct.Merma),
                                TotalCD           = _KardexLine.TotalCD - (item.Quantity - (item.Quantity * _subproduct.Merma)),
                            });
                        }

                        await _context.SaveChangesAsync();

                        _GoodsDelivered.Kardex.DocType           = 0;
                        _GoodsDelivered.Kardex.DocName           = "EntregaMercaderia/GoodsDelivered";
                        _GoodsDelivered.Kardex.DocumentDate      = _GoodsDeliveredq.DocumentDate;
                        _GoodsDelivered.Kardex.FechaCreacion     = DateTime.Now;
                        _GoodsDelivered.Kardex.FechaModificacion = DateTime.Now;
                        _GoodsDelivered.Kardex.TypeOperationId   = 1;
                        _GoodsDelivered.Kardex.TypeOperationName = "Salida";
                        _GoodsDelivered.Kardex.KardexDate        = DateTime.Now;

                        _GoodsDelivered.Kardex.DocumentName = "CE";

                        _GoodsDelivered.Kardex.CustomerId          = _GoodsDeliveredq.CustomerId;
                        _GoodsDelivered.Kardex.CustomerName        = _GoodsDeliveredq.CustomerName;
                        _GoodsDelivered.Kardex.CurrencyId          = _GoodsDeliveredq.CurrencyId;
                        _GoodsDelivered.Kardex.CurrencyName        = _GoodsDeliveredq.CurrencyName;
                        _GoodsDelivered.Kardex.DocumentId          = _GoodsDeliveredq.GoodsDeliveredId;
                        _GoodsDelivered.Kardex.UsuarioCreacion     = _GoodsDeliveredq.UsuarioCreacion;
                        _GoodsDelivered.Kardex.UsuarioModificacion = _GoodsDeliveredq.UsuarioModificacion;
                        _context.Kardex.Add(_GoodsDelivered.Kardex);

                        await _context.SaveChangesAsync();

                        BitacoraWrite _write = new BitacoraWrite(_context, new Bitacora
                        {
                            IdOperacion  = _GoodsDelivered.GoodsDeliveredId,
                            DocType      = "GoodsDelivered",
                            ClaseInicial =
                                Newtonsoft.Json.JsonConvert.SerializeObject(_GoodsDelivered, new JsonSerializerSettings {
                                ReferenceLoopHandling = ReferenceLoopHandling.Ignore
                            }),
                            ResultadoSerializado = Newtonsoft.Json.JsonConvert.SerializeObject(_GoodsDelivered, new JsonSerializerSettings {
                                ReferenceLoopHandling = ReferenceLoopHandling.Ignore
                            }),
                            Accion              = "Insert",
                            FechaCreacion       = DateTime.Now,
                            FechaModificacion   = DateTime.Now,
                            UsuarioCreacion     = _GoodsDelivered.UsuarioCreacion,
                            UsuarioModificacion = _GoodsDelivered.UsuarioModificacion,
                            UsuarioEjecucion    = _GoodsDelivered.UsuarioModificacion,
                        });

                        await _context.SaveChangesAsync();



                        _boletadesalida.GoodsDeliveredId = _GoodsDeliveredq.GoodsDeliveredId;
                        _context.Entry(_boletadesalida).CurrentValues.SetValues((_boletadesalida));

                        transaction.Commit();
                    }
                    catch (Exception ex)
                    {
                        transaction.Rollback();
                        throw ex;
                    }
                }
            }
            catch (Exception ex)
            {
                _logger.LogError($"Ocurrio un error: { ex.ToString() }");
                return(await Task.Run(() => BadRequest($"Ocurrio un error:{ex.Message}")));
            }

            return(await Task.Run(() => Ok(_GoodsDeliveredq)));
        }
Ejemplo n.º 6
0
        public async Task <ActionResult <GoodsReceived> > Insert([FromBody] GoodsReceivedDTO _GoodsReceived)
        {
            GoodsReceived _GoodsReceivedq = new GoodsReceived();

            try
            {
                using (var transaction = _context.Database.BeginTransaction())
                {
                    try
                    {
                        _GoodsReceivedq = _GoodsReceived;

                        BoletaDeSalida _boletadesalida = new BoletaDeSalida
                        {
                            BranchId            = _GoodsReceived.BranchId,
                            BranchName          = _GoodsReceived.BranchName,
                            CustomerId          = _GoodsReceived.CustomerId,
                            CustomerName        = _GoodsReceived.CustomerName,
                            DocumentDate        = _GoodsReceived.DocumentDate,
                            FechaCreacion       = DateTime.Now,
                            FechaModificacion   = DateTime.Now,
                            Marca               = _GoodsReceived.Marca,
                            Placa               = _GoodsReceived.Placa,
                            Motorista           = _GoodsReceived.Name,
                            Quantity            = _GoodsReceived._GoodsReceivedLine.Select(q => q.QuantitySacos).Sum(),
                            SubProductId        = _GoodsReceivedq._GoodsReceivedLine[0].SubProductId,
                            SubProductName      = _GoodsReceivedq._GoodsReceivedLine[0].SubProductName,
                            CargadoId           = 14,
                            Cargadoname         = "Vacío",
                            UsuarioCreacion     = _GoodsReceived.UsuarioCreacion,
                            UsuarioModificacion = _GoodsReceived.UsuarioModificacion,
                            UnitOfMeasureId     = _GoodsReceivedq._GoodsReceivedLine[0].UnitOfMeasureId,
                            UnitOfMeasureName   = _GoodsReceivedq._GoodsReceivedLine[0].UnitOfMeasureName,
                            WeightBallot        = _GoodsReceivedq.WeightBallot,
                            VigilanteId         = _GoodsReceivedq.VigilanteId,
                            Vigilante           = _GoodsReceivedq.VigilanteName,
                        };

                        _context.BoletaDeSalida.Add(_boletadesalida);
                        await _context.SaveChangesAsync();


                        _GoodsReceivedq.ExitTicket = _boletadesalida.BoletaDeSalidaId;

                        _context.GoodsReceived.Add(_GoodsReceivedq);
                        // await _context.SaveChangesAsync();

                        foreach (var item in _GoodsReceivedq._GoodsReceivedLine)
                        {
                            item.GoodsReceivedId = _GoodsReceivedq.GoodsReceivedId;


                            Kardex _kardexmax = await(from c in _context.Kardex
                                                      .OrderByDescending(q => q.DocumentDate)
                                                      // .Take(1)
                                                      join d in _context.KardexLine on c.KardexId equals d.KardexId
                                                      where c.CustomerId == _GoodsReceivedq.CustomerId && d.SubProducId == item.SubProductId &&
                                                      c.DocumentName != "CD" && d.WareHouseId == item.WareHouseId
                                                      select c
                                                      ).FirstOrDefaultAsync();

                            //Kardex _kardexmax = await (from kdx in _context.Kardex
                            //            .Where(q => q.CustomerId == _GoodsReceivedq.CustomerId)
                            //            from kdxline in _context.KardexLine
                            //                .Where(q => q.KardexId == kdx.KardexId)
                            //                .Where(o => o.SubProducId == item.SubProductId)
                            //                //.Where(q=>q.BranchId ==  _GoodsReceivedq.BranchId)
                            //                //.Where(q => q.WareHouseId == _GoodsReceivedq.WarehouseId)
                            //                .OrderByDescending(o => o.DocumentDate).Take(1)
                            //            select kdx).FirstOrDefaultAsync();

                            if (_kardexmax == null)
                            {
                                _kardexmax = new Kardex();
                            }


                            KardexLine _KardexLine = await _context.KardexLine
                                                     .Where(q => q.KardexId == _kardexmax.KardexId)
                                                     .Where(q => q.SubProducId == item.SubProductId)
                                                     .Where(q => q.WareHouseId == item.WareHouseId)
                                                     .Where(q => q.BranchId == _GoodsReceivedq.BranchId)
                                                     .OrderByDescending(q => q.KardexLineId)
                                                     .Take(1)
                                                     .FirstOrDefaultAsync();

                            if (_KardexLine == null)
                            {
                                _KardexLine = new KardexLine();
                            }

                            SubProduct _subproduct = await(from c in _context.SubProduct
                                                           .Where(q => q.SubproductId == item.SubProductId)
                                                           select c
                                                           ).FirstOrDefaultAsync();
                            if (_subproduct.ProductTypeId == 3)
                            {
                                //Alert AlertP = new Alert();
                                Alert Alerta = new Alert();
                                Alerta.DocumentId          = item.SubProductId;
                                Alerta.DocumentName        = "LISTA PROHIBIDA";
                                Alerta.AlertName           = "Productos";
                                Alerta.Code                = "PRODUCT01";
                                Alerta.DescriptionAlert    = "Lista de producto Prohibida";
                                Alerta.FechaCreacion       = Convert.ToDateTime(item.FechaCreacion);
                                Alerta.FechaModificacion   = Convert.ToDateTime(item.FechaModificacion);
                                Alerta.UsuarioCreacion     = item.UsuarioCreacion;
                                Alerta.UsuarioModificacion = item.UsuarioModificacion;
                                // var AlertaP = await InsertAlert(Alerta);
                                _context.Alert.Add(Alerta);
                                //await _context.SaveChangesAsync();

                                BitacoraWrite _writealert = new BitacoraWrite(_context, new Bitacora
                                {
                                    IdOperacion  = Alerta.AlertId,
                                    DocType      = "Alert",
                                    ClaseInicial =
                                        Newtonsoft.Json.JsonConvert.SerializeObject(Alerta, new JsonSerializerSettings {
                                        ReferenceLoopHandling = ReferenceLoopHandling.Ignore
                                    }),
                                    Accion              = "Insertar",
                                    FechaCreacion       = DateTime.Now,
                                    FechaModificacion   = DateTime.Now,
                                    UsuarioCreacion     = Alerta.UsuarioCreacion,
                                    UsuarioModificacion = Alerta.UsuarioModificacion,
                                    UsuarioEjecucion    = Alerta.UsuarioModificacion,
                                });

                                // await _context.SaveChangesAsync();
                            }

                            _context.GoodsReceivedLine.Add(item);

                            item.Total = item.Quantity + _KardexLine.Total;


                            _GoodsReceived.Kardex._KardexLine.Add(new KardexLine
                            {
                                DocumentDate      = _GoodsReceivedq.DocumentDate,
                                ProducId          = item.ProducId,
                                ProductName       = item.ProductName,
                                SubProducId       = item.SubProductId,
                                SubProductName    = item.SubProductName,
                                QuantityEntry     = item.Quantity,
                                QuantityOut       = 0,
                                QuantityEntryBags = item.QuantitySacos,
                                BranchId          = _GoodsReceivedq.BranchId,
                                BranchName        = _GoodsReceivedq.BranchName,
                                WareHouseId       = item.WareHouseId,
                                WareHouseName     = item.WareHouseName,
                                UnitOfMeasureId   = item.UnitOfMeasureId,
                                UnitOfMeasureName = item.UnitOfMeasureName,
                                TypeOperationId   = 1,
                                TypeOperationName = "Entrada",
                                Total             = item.Total,
                                TotalBags         = item.QuantitySacos + _KardexLine.TotalBags,
                                QuantityEntryCD   = item.Quantity - (item.Quantity * _subproduct.Merma),
                                TotalCD           = _KardexLine.TotalCD + (item.Quantity - (item.Quantity * _subproduct.Merma)),
                            });
                        }//Fin Foreach

                        await _context.SaveChangesAsync();

                        _GoodsReceived.Kardex.DocType           = 0;
                        _GoodsReceived.Kardex.DocName           = "ReciboMercaderia/GoodsReceived";
                        _GoodsReceived.Kardex.DocumentDate      = _GoodsReceivedq.DocumentDate;
                        _GoodsReceived.Kardex.FechaCreacion     = DateTime.Now;
                        _GoodsReceived.Kardex.FechaModificacion = DateTime.Now;
                        _GoodsReceived.Kardex.TypeOperationId   = 1;
                        _GoodsReceived.Kardex.TypeOperationName = "Entrada";
                        _GoodsReceived.Kardex.KardexDate        = DateTime.Now;
                        _GoodsReceived.Kardex.DocumentName      = "RM";

                        _GoodsReceived.Kardex.CustomerId          = _GoodsReceivedq.CustomerId;
                        _GoodsReceived.Kardex.CustomerName        = _GoodsReceivedq.CustomerName;
                        _GoodsReceived.Kardex.CurrencyId          = _GoodsReceivedq.CurrencyId;
                        _GoodsReceived.Kardex.CurrencyName        = _GoodsReceivedq.CurrencyName;
                        _GoodsReceived.Kardex.DocumentId          = _GoodsReceivedq.GoodsReceivedId;
                        _GoodsReceived.Kardex.UsuarioCreacion     = _GoodsReceivedq.UsuarioCreacion;
                        _GoodsReceived.Kardex.UsuarioModificacion = _GoodsReceivedq.UsuarioModificacion;



                        if (_GoodsReceived.ControlId > 0)
                        {
                            _context.Kardex.Add(_GoodsReceived.Kardex);
                        }

                        await _context.SaveChangesAsync();

                        foreach (var item in _GoodsReceivedq._GoodsReceivedLine)
                        {
                            if (item.ControlPalletsId == null)
                            {
                                item.ControlPalletsId = 0;
                            }
                            ControlPallets _ControlPalletsq = await _context.ControlPallets.Where(q => q.ControlPalletsId == item.ControlPalletsId)
                                                              .FirstOrDefaultAsync();

                            if (_ControlPalletsq != null)
                            {
                                _ControlPalletsq.QQPesoBruto = _GoodsReceivedq.PesoBruto;
                                _ControlPalletsq.QQPesoNeto  = _GoodsReceivedq.PesoNeto;
                                _ControlPalletsq.QQPesoFinal = _GoodsReceivedq.PesoNeto2;

                                _context.Entry(_ControlPalletsq).CurrentValues.SetValues((_ControlPalletsq));
                            }
                        }

                        await _context.SaveChangesAsync();

                        BoletaDeSalida _bol = await _context.BoletaDeSalida
                                              .Where(q => q.BoletaDeSalidaId == _boletadesalida.BoletaDeSalidaId).FirstOrDefaultAsync();

                        _bol.GoodsReceivedId = _GoodsReceivedq.GoodsReceivedId;
                        _context.Entry(_bol).CurrentValues.SetValues((_bol));

                        await _context.SaveChangesAsync();

                        JournalEntryConfiguration _journalentryconfiguration = await(_context.JournalEntryConfiguration
                                                                                     .Where(q => q.TransactionId == 1)
                                                                                     .Where(q => q.BranchId == _GoodsReceivedq.BranchId)
                                                                                     .Where(q => q.EstadoName == "Activo")
                                                                                     .Include(q => q.JournalEntryConfigurationLine)
                                                                                     ).FirstOrDefaultAsync();

                        BitacoraWrite _writejec = new BitacoraWrite(_context, new Bitacora
                        {
                            IdOperacion  = _GoodsReceived.CustomerId,
                            DocType      = "JournalEntryConfiguration",
                            ClaseInicial =
                                Newtonsoft.Json.JsonConvert.SerializeObject(_journalentryconfiguration, new JsonSerializerSettings {
                                ReferenceLoopHandling = ReferenceLoopHandling.Ignore
                            }),
                            ResultadoSerializado = Newtonsoft.Json.JsonConvert.SerializeObject(_journalentryconfiguration, new JsonSerializerSettings {
                                ReferenceLoopHandling = ReferenceLoopHandling.Ignore
                            }),
                            Accion              = "InsertGoodsReceived",
                            FechaCreacion       = DateTime.Now,
                            FechaModificacion   = DateTime.Now,
                            UsuarioCreacion     = _GoodsReceived.UsuarioCreacion,
                            UsuarioModificacion = _GoodsReceived.UsuarioModificacion,
                            UsuarioEjecucion    = _GoodsReceived.UsuarioModificacion,
                        });

                        // await _context.SaveChangesAsync();

                        double sumacreditos = 0, sumadebitos = 0;
                        if (_journalentryconfiguration != null)
                        {
                            //Crear el asiento contable configurado
                            //.............................///////
                            JournalEntry _je = new JournalEntry
                            {
                                Date         = _GoodsReceivedq.OrderDate,
                                Memo         = "Bienes Recibidos",
                                DatePosted   = _GoodsReceivedq.OrderDate,
                                ModifiedDate = DateTime.Now,
                                CreatedDate  = DateTime.Now,
                                ModifiedUser = _GoodsReceivedq.UsuarioModificacion,
                                CreatedUser  = _GoodsReceivedq.UsuarioCreacion,
                                DocumentId   = _GoodsReceivedq.GoodsReceivedId,
                            };



                            foreach (var item in _journalentryconfiguration.JournalEntryConfigurationLine)
                            {
                                GoodsReceivedLine _iline = new GoodsReceivedLine();
                                _iline = _GoodsReceivedq._GoodsReceivedLine.Where(q => q.SubProductId == item.SubProductId).FirstOrDefault();
                                if (_iline != null || item.SubProductName.ToUpper().Contains(("Impuesto").ToUpper()))
                                {
                                    if (!item.AccountName.ToUpper().Contains(("Impuestos sobre ventas").ToUpper()) &&
                                        !item.AccountName.ToUpper().Contains(("Sobre Servicios Diversos").ToUpper()))
                                    {
                                        _je.JournalEntryLines.Add(new JournalEntryLine
                                        {
                                            AccountId    = Convert.ToInt32(item.AccountId),
                                            Description  = item.AccountName,
                                            Credit       = item.DebitCredit == "Credito" ? _iline.Total : 0,
                                            Debit        = item.DebitCredit == "Debito" ? _iline.Total : 0,
                                            CreatedDate  = DateTime.Now,
                                            ModifiedDate = DateTime.Now,
                                            CreatedUser  = _GoodsReceivedq.UsuarioCreacion,
                                            ModifiedUser = _GoodsReceivedq.UsuarioModificacion,
                                            Memo         = "",
                                        });

                                        sumacreditos += item.DebitCredit == "Credito" ? _iline.Total : 0;
                                        sumadebitos  += item.DebitCredit == "Debito" ? _iline.Total : 0;
                                    }
                                    else
                                    {
                                        _je.JournalEntryLines.Add(new JournalEntryLine
                                        {
                                            AccountId    = Convert.ToInt32(item.AccountId),
                                            Description  = item.AccountName,
                                            CreatedDate  = DateTime.Now,
                                            ModifiedDate = DateTime.Now,
                                            CreatedUser  = _GoodsReceivedq.UsuarioCreacion,
                                            ModifiedUser = _GoodsReceivedq.UsuarioModificacion,
                                            Memo         = "",
                                        });

                                        //sumacreditos += item.DebitCredit == "Credito" ? _Invoiceq.Tax + _Invoiceq.Tax18 : 0;
                                        //sumadebitos += item.DebitCredit == "Debito" ? _Invoiceq.Tax + _Invoiceq.Tax18 : 0;
                                    }
                                }

                                // _context.JournalEntryLine.Add(_je);
                            }


                            if (sumacreditos != sumadebitos)
                            {
                                transaction.Rollback();
                                _logger.LogError($"Ocurrio un error: No coinciden debitos :{sumadebitos} y creditos{sumacreditos}");
                                return(BadRequest($"Ocurrio un error: No coinciden debitos :{sumadebitos} y creditos{sumacreditos}"));
                            }

                            _je.TotalCredit = sumacreditos;
                            _je.TotalDebit  = sumadebitos;
                            _context.JournalEntry.Add(_je);

                            await _context.SaveChangesAsync();
                        }

                        BitacoraWrite _write = new BitacoraWrite(_context, new Bitacora
                        {
                            IdOperacion  = _GoodsReceivedq.GoodsReceivedId,
                            DocType      = "GoodsReceived",
                            ClaseInicial =
                                Newtonsoft.Json.JsonConvert.SerializeObject(_GoodsReceivedq, new JsonSerializerSettings {
                                ReferenceLoopHandling = ReferenceLoopHandling.Ignore
                            }),
                            ResultadoSerializado = Newtonsoft.Json.JsonConvert.SerializeObject(_GoodsReceivedq, new JsonSerializerSettings {
                                ReferenceLoopHandling = ReferenceLoopHandling.Ignore
                            }),
                            Accion              = "Insert",
                            FechaCreacion       = DateTime.Now,
                            FechaModificacion   = DateTime.Now,
                            UsuarioCreacion     = _GoodsReceivedq.UsuarioCreacion,
                            UsuarioModificacion = _GoodsReceivedq.UsuarioModificacion,
                            UsuarioEjecucion    = _GoodsReceivedq.UsuarioModificacion,
                        });

                        await _context.SaveChangesAsync();


                        transaction.Commit();
                    }
                    catch (Exception ex)
                    {
                        transaction.Rollback();
                        throw ex;
                    }
                }
            }
            catch (Exception ex)
            {
                _logger.LogError($"Ocurrio un error: { ex.ToString() }");
                return(BadRequest($"Ocurrio un error:{ex.Message}"));
            }

            return(await Task.Run(() => Ok(_GoodsReceivedq)));
        }