Exemple #1
0
        public async Task <ServiceResponse <List <GetProductStockLogDto> > > DelectStockLog(int Id)
        {
            ServiceResponse <List <GetProductStockLogDto> > res = new ServiceResponse <List <GetProductStockLogDto> >();
            ProductStockLog stockLog = await _db.ProductStockLogs
                                       .Include(c => c.Product)
                                       .FirstOrDefaultAsync(c => c.StockLogId == Id);

            if (stockLog == null)
            {
                return(ResponseResult.Failure <List <GetProductStockLogDto> >("Data Not Found"));
            }
            try
            {
                _db.ProductStockLogs.Remove(stockLog);
                await _db.SaveChangesAsync();

                res.Data = (_db.ProductStockLogs.Select(c => _mapper.Map <GetProductStockLogDto>(c))).ToList();
            }
            catch (Exception ex)
            {
                res.IsSuccess = false;
                res.Message   = ex.Message;
            }
            return(res);
        }
Exemple #2
0
        public async Task <ServiceResponse <GetProductStockLogDto> > UpdateStockLog(UpdateStockProduct updateStock)
        {
            ServiceResponse <GetProductStockLogDto> res = new ServiceResponse <GetProductStockLogDto>();
            ProductStockLog stockLog = await _db.ProductStockLogs
                                       .Include(x => x.Product)
                                       .FirstOrDefaultAsync(c => c.StockLogId == updateStock.StockLogId);

            if (stockLog == null)
            {
                return(ResponseResult.Failure <GetProductStockLogDto>("data not found"));
            }

            try
            {
                stockLog.NewEdit      = updateStock.NewEdit;
                stockLog.UpdatedDate  = DateTime.Now;
                stockLog.AmountAfter  = updateStock.AmountAfter;
                stockLog.AmountBefore = updateStock.AmountBefore;
                stockLog.TextRemark   = updateStock.TextRemark;
                stockLog.IsActice     = updateStock.IsActice;
                _db.ProductStockLogs.Update(stockLog);
                await _db.SaveChangesAsync();

                res.Data = _mapper.Map <GetProductStockLogDto>(stockLog);
            }
            catch (Exception ex)
            {
                res.IsSuccess = false;
                res.Message   = ex.Message;
            }
            return(res);
        }
Exemple #3
0
        public async Task <ServiceResponse <GetProductStockLogDto> > GetStockLogById(int Id)
        {
            ServiceResponse <GetProductStockLogDto> res = new ServiceResponse <GetProductStockLogDto>();
            ProductStockLog stockLog = await _db.ProductStockLogs
                                       .Include(c => c.Product)
                                       .FirstOrDefaultAsync(x => x.StockLogId == Id);

            if (stockLog == null)
            {
                res.IsSuccess = false;
                res.Message   = "Data not found";
            }
            res.Data = _mapper.Map <GetProductStockLogDto>(stockLog);
            return(res);
        }
Exemple #4
0
        public async Task <ServiceResponse <List <GetProductStockLogDto> > > AddStockLog(AddProductStockLogDto newstockLogDto)
        {
            ServiceResponse <List <GetProductStockLogDto> > res = new ServiceResponse <List <GetProductStockLogDto> >();

            var Product = await _db.Products.FirstOrDefaultAsync(x => x.ProductId == newstockLogDto.ProductId);

            var stock = Product.Stock;

            if (Product == null)
            {
                res.IsSuccess = false;
                res.Message   = "date not found";
            }
            if (newstockLogDto.TypeAdd == 2)    // 2 = ลบ
            {
                if (newstockLogDto.NewEdit > stock)
                {
                    res.IsSuccess = false;
                    res.Message   = " calculate fail";
                }
                else
                {
                    Product.Stock = (stock - newstockLogDto.NewEdit);
                }
            }
            else
            {
                Product.Stock = (newstockLogDto.NewEdit + stock);
            }

            if (res.IsSuccess == true)
            {
                _db.Products.Update(Product);
                await _db.SaveChangesAsync();

                ProductStockLog productStockLog = _mapper.Map <ProductStockLog>(newstockLogDto);
                _db.ProductStockLogs.Add(productStockLog);

                await _db.SaveChangesAsync();

                res.Data = (_db.ProductStockLogs.Select(c => _mapper.Map <GetProductStockLogDto>(c))).ToList();
            }

            return(res);
        }