public List<FileLogEntity> readEmail()
        {
            List<FileLogEntity> lstFileLogs = new List<FileLogEntity>();
            foreach (string file in Directory.GetFiles(Settings.GetConfig("EmailsDorp")))
            {
                FileLogEntity fileLogEntity = new FileLogEntity();
                Message message = Message.Load(new FileInfo(file));
                if (message.Headers.Subject.ToLower() == Settings.GetConfig("EmailSubjectForTiff").ToLower())
                    fileLogEntity.fileType = FileType.TiffFileLog;
                else if (message.Headers.Subject.ToLower() == Settings.GetConfig("EmailSubjectForZip").ToLower())
                    fileLogEntity.fileType = FileType.ZipFileLog;
                foreach (MessagePart mp in message.FindAllAttachments())
                {
                    if(Path.GetExtension(mp.FileName) == Settings.GetConfig("EmailAttachmentExtension"))
                    {
                        fileLogEntity.fileName = mp.FileName;
                        fileLogEntity.data = mp.GetBodyAsText();
                        break;
                    }
                }
                lstFileLogs.Add(fileLogEntity);
            }

            return lstFileLogs;
        }
        private void updateTransmission(FileLogEntity fileLog)
        {
            try
            {
                string[] lines = fileLog.data.Replace(" - ","|").Split('|');

                string fileName = lines[1].Trim();

                string[] dateAndStatus = lines[0].Replace("[", "").Replace("]","-").Split('-');

                DateTime dateTime = new DateTime();
                DateTime.TryParseExact(dateAndStatus[0],Settings.GetConfig("DateFormat"), CultureInfo.InvariantCulture, DateTimeStyles.None, out dateTime);

                string status = dateAndStatus[1];

                DAL dbLayer = new DAL();
                dbLayer.UpdateTransmission(fileName, dateTime, status);

            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
        }
        private void updateTriplets(FileLogEntity fileLog)
        {
            try
            {
                string[] lines = fileLog.data.Split('\n');
                foreach(string line in lines)
                {
                    if (!string.IsNullOrEmpty(line))
                    {
                        string batchId = line.Split('.')[1];
                        string status = line.Split('-')[1];

                        DAL dbLayer = new DAL();
                        dbLayer.UpdateTriplets(batchId);
                    }
                }
            }
            catch(Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
        }