Exemplo n.º 1
0
        public void Add(DTOExport model)
        {
            if (model.InventoryId == 0 || model.EmployeeId == 0 || model.CustomerId == 0)
            {
                return;
            }

            Export export = _mapper.Map <Export>(model);
            List <ExportDetail> exportDetails = _mapper.Map <List <ExportDetail> >(model.ExportProductList);

            if (model.InventoryId > 0 && model.EmployeeId > 0)
            {
                export.EmployeeId = model.EmployeeId;
            }
            _context.Add(export);
            _context.SaveChanges();

            if (exportDetails != null)
            {
                foreach (var ed in exportDetails)
                {
                    ed.ExportId = export.Id;
                    double productPrice = _context.ProductPrices
                                          .Where(x => x.ProductId == ed.ProductId && !x.IsDeleted)
                                          .FirstOrDefault().Price;
                    ed.Price = ed.Quantity * productPrice - (ed.Quantity * productPrice * ed.Discount / 100);
                }
                _context.AddRange(exportDetails);
                _context.SaveChanges();
            }
        }
Exemplo n.º 2
0
        public void Edit(DTOExport model)
        {
            Export export = _mapper.Map <Export>(model);
            List <ExportDetail> newDetails = _mapper.Map <List <ExportDetail> >(model.ExportProductList);
            List <ExportDetail> oldDetails = _context.ExportDetails
                                             .Where(x => x.ExportId == model.Id).ToList();

            _context.Update(export);

            if (newDetails != null && newDetails.Count > 0)
            {
                _context.RemoveRange(oldDetails);
                if (newDetails != null)
                {
                    foreach (var nd in newDetails)
                    {
                        nd.ExportId = export.Id;
                        double productPrice = _context.ProductPrices
                                              .Where(x => x.ProductId == nd.ProductId && !x.IsDeleted)
                                              .FirstOrDefault().Price;
                        nd.Price = nd.Quantity * productPrice - (nd.Quantity * productPrice * nd.Discount / 100);
                    }
                    _context.AddRange(newDetails);
                }
            }
            _context.SaveChanges();
        }
        public IActionResult Details(int id)
        {
            DTOExport model = _unitOfWork.Exports.GetDetailsByIdDto(id);

            if (model != null)
            {
                return(PartialView("Details", model));
            }
            return(RedirectToAction(nameof(Index)));
        }
        public IActionResult SaveExport(DTOExport model)
        {
            if (model.Id == 0)
            {
                _unitOfWork.Exports.Add(model);
            }
            else
            {
                _unitOfWork.Exports.Edit(model);
            }

            return(RedirectToAction(nameof(Index)));
        }
        public IActionResult EditExport(int id)
        {
            DTOExport model = _unitOfWork.Exports.GetByIdDto(id);

            model.Customers = _unitOfWork.Customers.GetAll()
                              .Select(x => new SelectListItem
            {
                Text  = x.Name,
                Value = x.Id.ToString()
            }).ToList();
            model.ExportDetails = _unitOfWork.Exports.GetExportDetails(id);

            return(View(model));
        }
        public IActionResult AddExport()
        {
            DTOExport model = new DTOExport
            {
                Inventories = _unitOfWork.Inventories.GetAll()
                              .Select(x => new SelectListItem(x.Name, x.Id.ToString())).ToList(),
                Customers = _unitOfWork.Customers.GetAll()
                            .Select(x => new SelectListItem(x.Name, x.Id.ToString())).ToList(),
                Employees = _unitOfWork.Employees.GetAll()
                            .Select(x => new SelectListItem(x.Username, x.Id.ToString())).ToList()
            };

            return(View("AddExport", model));
        }
Exemplo n.º 7
0
        public DTOExport GetDetailsByIdDto(int exportId)
        {
            Export export = _context.Exports
                            .Include(x => x.Inventory)
                            .FirstOrDefault(x => x.Id == exportId);

            if (export == null)
            {
                return(null);
            }

            DTOExport model = _mapper.Map <DTOExport>(export);

            model.ExportDetails = _context.ExportDetails
                                  .Where(x => x.ExportId == exportId)
                                  .Include(x => x.Product).ToList();

            model.Quantity   = (int)model.ExportDetails.Sum(x => x.Quantity);
            model.TotalPrice = model.ExportDetails.Sum(x => x.Price);

            return(model);
        }