Ejemplo n.º 1
0
        public ResultRespose Import(ImportRequest request, AppSettingsSection _appSettings)
        {
            List <CsvValues>     dailyScanValues = new List <CsvValues>();
            List <EmpWorking>    empWorkings     = new List <EmpWorking>();
            List <DeliveryBlock> deliveryBlocks  = new List <DeliveryBlock>();
            List <Block>         blocks          = new List <Block>();
            List <PalletDetail>  palletDetails   = new List <PalletDetail>();
            List <Destination>   destinations    = new List <Destination>();
            EmpWorking           empl            = null;
            //Block block = null;
            PalletDetail pallet = null;
            //DeliveryBlock deliveryBlock = null;
            Destination destination = null;
            int         row         = 1;
            var         endBlock    = 0;
            int         totalLog    = 0;
            var         startScaner = DateTime.Now;

            var redAllLine = File.ReadAllLines(request.PathFile).ToList();

            dailyScanValues = redAllLine.Skip(0)
                              .Select(line => FileHelper.FromCsv(line, redAllLine.FindIndex(x => x.Equals(line))))
                              .ToList();
            _logService.LogInfo("Start: " + startScaner.ToString());
            CsvValues lineBlank = FileHelper.FromCsv("");

            //insert 10 line blank.end file
            for (int i = 0; i < 10; i++)
            {
                dailyScanValues.Add(lineBlank);
            }
            foreach (var item in dailyScanValues.ToList())
            {
                var index     = dailyScanValues.FindIndex(a => a.Id == item.Id);
                var prevIndex = index - 1;
                var nextIndex = index + 1;

                #region check item error
                //Special character row
                if (item.RowType.Equals(Contains.RowType.ENDBLOCK.ToString()))
                {
                    try
                    {
                        var nextItem = dailyScanValues[nextIndex];

                        if (nextItem.RowType.Equals(Contains.RowType.ENDBLOCK.ToString()) || nextItem.RowType.Equals(Contains.RowType.EXCEPTION.ToString()))
                        {
                            endBlock++;

                            if (endBlock > 1)
                            {
                                _logService.LogError("Special character row " + nextItem.BarCode + ", Line: " + row);
                                totalLog++;
                                return(new ResultRespose
                                {
                                    Status = false,
                                    Message = "Special character row " + nextItem.BarCode + ", Line: " + row,
                                    StartDate = startScaner
                                });
                            }
                        }
                    }
                    catch (Exception ex)
                    {
                        _logService.LogError(ex.ToString());
                    }
                }
                //over scan if 10 black row consecutive
                if (item.RowType.Equals(Contains.RowType.BLANK.ToString()))
                {
                    var nextItem = dailyScanValues[nextIndex];
                    if (nextItem.RowType.Equals(Contains.RowType.BLANK.ToString()))
                    {
                        try
                        {
                            var nextRow  = row + 1;
                            var blankRow = 0;
                            blankRow++;
                            for (int i = 1; i <= 8; i++)
                            {
                                if (dailyScanValues[nextRow].RowType.Equals(Contains.RowType.BLANK.ToString()))
                                {
                                    blankRow++;
                                    nextRow++;
                                }
                                else
                                {
                                    break;
                                }
                            }
                            if (blankRow >= 9)
                            {
                                break;
                            }
                        }
                        catch (Exception ex) { }
                    }
                }
                //Lacking date info
                if (item.IsBarCode && string.IsNullOrEmpty(item.Date))
                {
                    _logService.LogError("Lacking date Line: " + row);
                    totalLog++;
                    return(new ResultRespose
                    {
                        Status = false,
                        Message = "Lacking date Line: " + row,
                        StartDate = startScaner
                    });
                }

                //Lacking time info
                if (item.IsBarCode && string.IsNullOrEmpty(item.Time))
                {
                    _logService.LogError("Lacking time Line: " + row);
                    totalLog++;
                    return(new ResultRespose
                    {
                        Status = false,
                        Message = "Lacking time Line: " + row,
                        StartDate = startScaner
                    });
                }

                //Lacking prefix info
                if (item.IsBarCode && string.IsNullOrEmpty(item.Prefix))
                {
                    _logService.LogError("Lacking perfix Line: " + row);
                    totalLog++;
                    return(new ResultRespose
                    {
                        Status = false,
                        Message = "Lacking perfix Line: " + row,
                        StartDate = startScaner
                    });
                }
                //Redundant code info
                if (item.RowType.Equals(Contains.RowType.FOMATERROR.ToString()))
                {
                    _logService.LogError("Raw data file has wrong content format Line: " + row);
                    totalLog++;
                    return(new ResultRespose
                    {
                        Status = false,
                        Message = "Raw data file has wrong content format Line: " + row,
                        StartDate = startScaner
                    });
                }

                //Datetime Format is not correct
                if (item.IsBarCode &&
                    !string.IsNullOrEmpty(item.Date) &&
                    !string.IsNullOrEmpty(item.Time) &&
                    FileHelper.CvStringToDate(item.DateTime) == null)
                {
                    _logService.LogError("Datetime Format is not correct " + item.BarCode + ", Line: " + row);
                    totalLog++;
                    return(new ResultRespose
                    {
                        Status = false,
                        Message = "Datetime Format is not correct " + item.BarCode + ", Line: " + row,
                        StartDate = startScaner
                    });
                }

                //Lacking Barcode
                if (item.IsBarCode &&
                    string.IsNullOrEmpty(item.BarCode))
                {
                    _logService.LogError("Lacking Barcode " + item.BarCode + ", Line: " + row);
                    totalLog++;
                    return(new ResultRespose
                    {
                        Status = false,
                        Message = "Lacking Barcode " + item.BarCode + ", Line: " + row,
                        StartDate = startScaner
                    });
                }

                //Must have Emplyee ID at the first row of each scanner dataset
                if (row == 1 && item.RowType.Equals(Contains.RowType.PALLET.ToString()))
                {
                    _logService.LogError("Lacking Employee barcode " + item.BarCode + ", Line: " + row);
                    totalLog++;
                    return(new ResultRespose
                    {
                        Status = false,
                        Message = "Lacking Employee barcode " + item.BarCode + ", Line: " + row,
                        StartDate = startScaner
                    });
                }
                #endregion

                #region show log wanning file
                //check destination firt file
                if (empWorkings.Count() == 0)
                {
                    if (item.RowType.Equals(Contains.RowType.DESTINATION.ToString()))
                    {
                        dailyScanValues.Remove(item);
                        _logService.LogWarn("Redundant Destination barcode " + item.BarCode + ", Line: " + row);
                        totalLog++;
                    }
                }
                if (item.IsBarCode && row > 0 &&
                    item.RowType.Equals(Contains.RowType.DESTINATION.ToString()))
                {
                    try
                    {
                        var nextItem = dailyScanValues[nextIndex];
                        var prevItem = dailyScanValues[prevIndex];
                        //Destination barcodes are displayed at the beginning of Scanner dataset
                        if (prevItem.RowType.Equals(Contains.RowType.ENDBLOCK.ToString()))
                        {
                            dailyScanValues.Remove(item);
                            _logService.LogWarn("Redundant Destination barcode " + item.BarCode + ", Line: " + row);
                            totalLog++;
                        }
                        else if (nextItem.RowType.Equals(Contains.RowType.DESTINATION.ToString()) ||
                                 prevItem.RowType.Equals(Contains.RowType.EMPLOYEE.ToString()))
                        {
                            dailyScanValues.Remove(item);
                            _logService.LogWarn("Redundant Destination barcode " + item.BarCode + ", Line: " + row);
                            totalLog++;
                        }
                        else
                        {
                            destination = new Destination
                            {
                                BlockId       = palletDetails.Last().BlockId,
                                DestinationId = item.BarCode,
                                WorkTime      = FileHelper.CvStringToDate(item.DateTime)
                            };

                            destinations.Add(destination);
                        }
                    }
                    catch (Exception ex)
                    {
                        _logService.LogError(ex.ToString());
                    }
                }

                //Format is not correct
                if (item.RowType.Equals(Contains.RowType.UNDEFINED.ToString()))
                {
                    dailyScanValues.Remove(item);
                    _logService.LogWarn("EEID format is not correct " + item.BarCode + ", Line: " + row);
                    totalLog++;
                }

                //Multi Employee barcodes are displayed continuously in multi rows
                if (item.IsBarCode &&
                    !string.IsNullOrEmpty(item.BarCode) &&
                    item.RowType.Equals(Contains.RowType.EMPLOYEE.ToString()))
                {
                    //Lack Pallet barcode in working block (Pallet barcode-> Employee -> Destination)
                    try
                    {
                        var nextItem = dailyScanValues[nextIndex];
                        var prevItem = dailyScanValues[prevIndex];

                        if (prevItem.RowType.Equals(Contains.RowType.PALLET.ToString()) &&
                            nextItem.RowType.Equals(Contains.RowType.DESTINATION.ToString()))
                        {
                            dailyScanValues.Remove(item);
                            _logService.LogWarn("Redundant Employee barcode " + item.BarCode + ", Line: " + row);
                            totalLog++;
                        }
                    }
                    catch (Exception) { }

                    try
                    {
                        var nextItem = dailyScanValues[nextIndex];

                        //Employee barcode is displayed at the end of Scanner dataset
                        if (nextItem.RowType.Equals(Contains.RowType.ENDBLOCK.ToString()))
                        {
                            dailyScanValues.Remove(item);
                            _logService.LogWarn("Redundant Employee barcode " + item.BarCode + ", Line: " + row);
                            totalLog++;
                        }
                    }
                    catch (Exception ex) { _logService.LogError(ex.ToString()); }

                    if (empWorkings.Any())
                    {
                        if (dailyScanValues[prevIndex].IsBarCode &&
                            dailyScanValues[prevIndex].RowType.Equals(Contains.RowType.EMPLOYEE.ToString()))
                        {
                            var prevItem = dailyScanValues[prevIndex];
                            empWorkings.Remove(empWorkings.Last());
                            int prevRow = prevItem.Line;
                            dailyScanValues.Remove(prevItem);
                            _logService.LogWarn("Multi Employee Barcode " + prevItem.BarCode + ", Line: " + prevRow);
                            totalLog++;
                        }
                    }

                    empl = new EmpWorking
                    {
                        Id         = Guid.NewGuid(),
                        Day        = item.Date,
                        EmployeeId = item.BarCode,
                        WorkTime   = FileHelper.CvStringToDate(item.DateTime)
                    };
                    empWorkings.Add(empl);
                }

                //Lack Employee barcode after 1 Destination barcode (have Pallet barcode after Destination barcode)
                if (item.IsBarCode && row > 0 &&
                    !string.IsNullOrEmpty(item.BarCode) &&
                    item.RowType.Equals(Contains.RowType.PALLET.ToString()))
                {
                    index = dailyScanValues.FindIndex(a => a.Id == item.Id) - 1;
                    if (prevIndex < 0)
                    {
                        _logService.LogError("Lacking Employee barcode " + item.BarCode + ", Line: " + row);
                        return(new ResultRespose
                        {
                            Status = false,
                            Message = "Lacking Employee barcode " + item.BarCode + ", Line: " + row,
                            StartDate = startScaner
                        });
                    }
                    else
                    {
                        try
                        {
                            var prevItem = dailyScanValues[index];
                            var nextItem = dailyScanValues[nextIndex];
                            if (prevItem.RowType.Equals(Contains.RowType.FOMATERROR.ToString()))
                            {
                                _logService.LogError("Lacking Employee barcode " + item.BarCode + ", Line: " + row);
                                return(new ResultRespose
                                {
                                    Status = false,
                                    Message = "Lacking Employee barcode " + item.BarCode + ", Line: " + row,
                                    StartDate = startScaner
                                });
                            }
                            if (prevItem.RowType.Equals(Contains.RowType.DESTINATION.ToString()))
                            {
                                var lastEmp = empWorkings.Last();

                                empl = new EmpWorking
                                {
                                    Id         = Guid.NewGuid(),
                                    Day        = lastEmp.Day,
                                    EmployeeId = lastEmp.EmployeeId,
                                    WorkTime   = FileHelper.CvStringToDate(item.DateTime).Value.AddSeconds(-1)
                                };
                                empWorkings.Add(empl);
                                _logService.LogWarn("Lack Employee barcode before Pallet " + item.BarCode + ", Line: " + row);
                                totalLog++;
                            }
                            //Lacking Employee barcode after Pallet
                            if (nextItem.RowType.Equals(Contains.RowType.EMPLOYEE.ToString()))
                            {
                                _logService.LogWarn("Lacking Destination barcode after Pallet  " + item.BarCode + ", Line: " + row);
                            }
                            //Remove duplicate pallet
                            if (palletDetails.Any(p => p.PalletId == item.BarCode))
                            {
                                var listDuplicate =
                                    palletDetails.FirstOrDefault(x => x.PalletId == item.BarCode);

                                if (listDuplicate != null)
                                {
                                    dailyScanValues.Remove(item);
                                    _logService.LogWarn("Pallet Barcode is duplicated " + item.BarCode + ", Line: " + row);
                                    totalLog++;
                                }
                            }
                            else
                            {
                                //Create new Pallet
                                pallet = new PalletDetail
                                {
                                    BlockId        = empWorkings.Last().Id,
                                    Day            = empWorkings.Last().Day,
                                    EmployeeId     = empWorkings.Last().EmployeeId,
                                    PalletId       = item.BarCode,
                                    PalletScanTime = FileHelper.CvStringToDate(item.DateTime)
                                };
                                palletDetails.Add(pallet);
                            }
                        }
                        catch (Exception ex)
                        {
                            _logService.LogError(ex.ToString());
                        }
                    }
                }
                row++;
                #endregion
            }
            //Insert to DB
            var countDelviveBlock = 0;
            try
            {
                _logService.LogInfo("start Insert");
                var locationCode = "GFSPLT";

                //List<LocationShift> locationShifts = _shiftServices.GetLocationShift(locationCode);
                using (var dbContext = new barCodeDbContext())
                {
                    _logService.LogInfo("Insert");
                    dbContext.Configuration.AutoDetectChangesEnabled = false;
                    dbContext.Configuration.ValidateOnSaveEnabled    = false;
                    //List<LocationShift> locationShifts = dbContext.LocationShifts.Where(l=>l.LocationId == 35).ToList();
                    List <Block>  lstBlocks    = new List <Block>();
                    var           oldBlock     = new DeliveryBlock();
                    DeliveryBlock barCodeBlock = null;
                    EmpWorking    ep           = null;
                    Destination   des          = null;
                    Block         blo          = null;
                    try
                    {
                        foreach (var pl in palletDetails)
                        {
                            barCodeBlock = new DeliveryBlock();
                            ep           = empWorkings.Where(e => e.Id == pl.BlockId).FirstOrDefault();
                            if (pl.PalletId == null || (ep == null))
                            {
                                continue;
                            }
                            if (ep != null)
                            {
                                barCodeBlock.EmployeeId     = ep.EmployeeId;
                                barCodeBlock.BlockStartTime = FileHelper.CvStringToDate(ep.WorkTime.ToString());
                            }
                            barCodeBlock.PalletId = pl.PalletId.ToString();
                            barCodeBlock.BlockId  = pl.BlockId;
                            des = destinations.Where(d => d.BlockId == pl.BlockId).LastOrDefault();
                            if (des != null)
                            {
                                barCodeBlock.BlockEndTime  = FileHelper.CvStringToDate(des.WorkTime.ToString() == null ? new DateTime().ToString() : des.WorkTime.ToString());
                                barCodeBlock.DestinationId = des.DestinationId;
                            }
                            oldBlock = dbContext.DeliveryBlocks.Where(b => b.PalletId == barCodeBlock.PalletId && b.BlockStartTime == barCodeBlock.BlockStartTime &&
                                                                      (b.BlockEndTime.HasValue ? b.BlockEndTime == barCodeBlock.BlockEndTime : true)).FirstOrDefault();

                            if (oldBlock != null)
                            {
                                _logService.LogInfo(oldBlock.ToString());
                                continue;
                            }
                            blo = lstBlocks.Where(b => b.BlockId == pl.BlockId).FirstOrDefault();
                            if (blo == null)
                            {
                                Block bl = new Block();
                                bl.BlockId     = pl.BlockId;
                                bl.CreatedDate = DateTime.Now;
                                var shift = ShiftHelper.GetShift(dbContext, barCodeBlock);

                                if (shift != null)
                                {
                                    BlockShift blockShift = new BlockShift()
                                    {
                                        BlockId     = bl.BlockId,
                                        ShiftId     = shift.ShiftId,
                                        DateOfShift = shift.DateOfShift.Value.Date
                                    };
                                    dbContext.BlockShifts.Add(blockShift);
                                }
                                lstBlocks.Add(bl);
                            }
                            dbContext.DeliveryBlocks.Add(barCodeBlock);
                            dbContext.PalletDetails.Add(pl);
                        }
                        foreach (var item in lstBlocks)
                        {
                            dbContext.Blocks.Add(item);
                        }
                        dbContext.SaveChanges();
                        countDelviveBlock = lstBlocks.Count();
                    }
                    catch (Exception ex)
                    {
                        _logService.LogInfo(ex.ToString());
                        return(new ResultRespose
                        {
                            Status = false,
                            Message = "Can Not Insert To Database",
                            StartDate = startScaner
                        });
                    }
                }
            }
            catch (Exception e)
            {
                _logService.LogError(e.ToString());
            }
            //log success
            var endScaner = DateTime.Now;
            _logService.LogInfo("Status Batch Successful");
            _logService.LogInfo("Total Block Insert:" + countDelviveBlock.ToString());
            _logService.LogInfo("End: " + endScaner.ToString());
            _logService.LogInfo("##############################################");
            return(new ResultRespose
            {
                Status = true,
                StartDate = startScaner
            });
        }
Ejemplo n.º 2
0
        /// <summary>
        /// Convert data form CSV to list Object
        /// </summary>
        /// <param name="csvLine"></param>
        /// <returns></returns>
        public static CsvValues FromCsv(string csvLine, int row)
        {
            CsvValues dailyValues = null;

            string[] values = csvLine.Split(','); // delimiter CSV

            dailyValues = new CsvValues
            {
                Id   = Guid.NewGuid(),
                Line = row + 1
            };

            try
            {
                if (!string.IsNullOrEmpty(csvLine) && !csvLine.Contains("#"))
                {
                }
                {
                    if (string.IsNullOrEmpty(csvLine))
                    {
                        dailyValues.RowType = Contains.ItemStatus.BLANK.ToString();
                        return(dailyValues);
                    }
                    if (values.Count() > 0 && values.Count() != 4 && !csvLine.Contains("#"))
                    {
                        dailyValues.RowType = Contains.ItemStatus.FOMATERROR.ToString();
                        return(dailyValues);
                    }

                    var date   = values[0].TrimStart('"');
                    var time   = values[1];
                    var code   = values[3].TrimEnd('"');
                    var prefix = values[2];

                    dailyValues.RowType = Contains.RowType.UNDEFINED.ToString();

                    if (string.IsNullOrEmpty(code) && !string.IsNullOrEmpty(date) && !string.IsNullOrEmpty(time))
                    {
                        dailyValues.RowType   = Contains.RowType.EMPLOYEE.ToString();
                        dailyValues.IsBarCode = true;
                    }

                    if (!string.IsNullOrEmpty(code) && IsEmployeeBarCode(code))
                    {
                        dailyValues.RowType   = Contains.RowType.EMPLOYEE.ToString();
                        dailyValues.IsBarCode = true;
                    }

                    if (!string.IsNullOrEmpty(code) && IsDestinationBarCode(code))
                    {
                        dailyValues.RowType   = Contains.RowType.DESTINATION.ToString();
                        dailyValues.IsBarCode = true;
                    }

                    if (!string.IsNullOrEmpty(code) && IsPalletBarCode(code))
                    {
                        dailyValues.RowType   = Contains.RowType.PALLET.ToString();
                        dailyValues.IsBarCode = true;
                    }

                    dailyValues.Id      = Guid.NewGuid();
                    dailyValues.Date    = date;
                    dailyValues.Time    = time;
                    dailyValues.BarCode = code;
                    dailyValues.Prefix  = prefix;
                    dailyValues.Commas  = values.Count();
                }
            }
            catch (Exception ex)
            {
                if (values.Count() > 0 && values.Count() != 4 && !csvLine.Contains("#"))
                {
                    dailyValues.RowType = Contains.ItemStatus.FOMATERROR.ToString();
                }
                else if (csvLine.Contains("#"))
                {
                    dailyValues.RowType = Contains.RowType.ENDBLOCK.ToString();
                }
                else
                {
                    dailyValues.RowType = Contains.RowType.EXCEPTION.ToString();
                }
            }
            return(dailyValues);
        }