示例#1
0
        public static void FillupFormsUploaded()
        {
            try
            {
                logger.Info("Export FillupFormsUploaded Process Started. - {0}", DateTime.Now.ToString());
                TccLog.UpdateLog("Export FillupFormsUploaded Process Started", LogMessageType.Info, "ShipExport - FillupFormsUploaded");

                SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["TCCCMSDBConnectionString"].ConnectionString);
                con.Open();
                //SqlCommand cmd = new SqlCommand("stpExporttblFormUploaded", con);
                SqlCommand cmd = new SqlCommand("stpExportFillupUoloadedFormsFromShip", con);
                cmd.CommandType = CommandType.StoredProcedure;
                DataSet        ds = new DataSet();
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                da.Fill(ds);

                if (ds.Tables[0].Rows.Count > 0)
                {
                    ds.WriteXml(path + "\\" + ConfigurationManager.AppSettings["xmlFillupFormUpload"].ToString(), XmlWriteMode.WriteSchema);
                }
                con.Close();
                string xmlFile = path + "\\" + ConfigurationManager.AppSettings["xmlFillupFormUpload"].ToString();
                if (File.Exists(xmlFile))
                {
                    CreateUploadedFileZip("FILLUPUPLOADEDFILE", xmlFile);
                }
            }
            catch (Exception ex)
            {
                TccLog.UpdateLog(ex.InnerException.Message, LogMessageType.Error, "Export-FillupFoormsUploaded");
            }
        }
示例#2
0
        public void Connect(string userId, string password, string mailDomain, int port)
        {
            try
            {
                if (MailServerType == MailType.POP3)
                {
                    using (pop_Client = new Pop3Client(new ProtocolLogger("pop3.log")))
                    {
                        using (var cancel = new CancellationTokenSource())
                        {
                            pop_Client.Connect(mailDomain, port, true, cancel.Token);
                            pop_Client.AuthenticationMechanisms.Remove("XOAUTH2");
                            pop_Client.AuthenticationMechanisms.Remove("NTLM");
                            pop_Client.AuthenticationMechanisms.Remove("PLAIN");
                            pop_Client.Authenticate(userId, password, cancel.Token);
                        }
                    }
                }
                else if (MailServerType == MailType.IMAP)
                {
                    try
                    {
                        TccLog.UpdateLog("Connecting IMAP Client", LogMessageType.Info, "Ship Import - Connect");
                        //imap_Client = new ImapClient(new ProtocolLogger("imap.log"));
                        imap_Client = new ImapClient();

                        //Added blew 3lines on  12th Jul 2021 // for client
                        imap_Client.ServerCertificateValidationCallback = (s, c, h, e) => true;
                        imap_Client.CheckCertificateRevocation          = false;
                        imap_Client.SslProtocols = SslProtocols.Ssl3 | SslProtocols.Ssl2 | SslProtocols.Tls | SslProtocols.Tls11 | SslProtocols.Tls12;
                        //------For client

                        //imap_Client.Connect(mailDomain, port,false);// change true to false on 12th Jul 2021 // for client
                        imap_Client.Connect(mailDomain, port, true);

                        //imap_Client.Connect(mailDomain, port, SecureSocketOptions.StartTls);
                        imap_Client.AuthenticationMechanisms.Remove("XOAUTH2");
                        imap_Client.AuthenticationMechanisms.Remove("NTLM");
                        imap_Client.AuthenticationMechanisms.Remove("PLAIN");
                        imap_Client.Authenticate(userId, password);

                        TccLog.UpdateLog("IMAP Client Connected", LogMessageType.Info, "Ship Import - Connect");
                    }
                    catch (Exception ex)
                    {
                        LogHelper.Log(LogTarget.EventLog, ex.Message);
                        TccLog.UpdateLog(ex.Message, LogMessageType.Error, "Ship Import - Connect(IMAP)");
                    }
                }
                else
                {
                    Console.WriteLine(MailServerType + " unsupported mail server type");
                }
            }
            catch (Exception ex)
            {
                LogHelper.Log(LogTarget.EventLog, ex.Message);
                TccLog.UpdateLog(ex.Message, LogMessageType.Error, "Ship Import - Connect");
            }
        }
示例#3
0
        public static void UpdateFillupFormApproverMapper()
        {
            try
            {
                // Here your xml file
                string xmlFile = path + "\\" + ConfigurationManager.AppSettings["xmlApprovedFillupForm"].ToString();

                if (File.Exists(xmlFile))
                {
                    DataSet dataSet = new DataSet();
                    dataSet.ReadXmlSchema(xmlFile);
                    dataSet.ReadXml(xmlFile, XmlReadMode.ReadSchema);

                    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["TCCCMSDBConnectionString"].ConnectionString);
                    con.Open();
                    SqlCommand cmd = new SqlCommand("UpdateFormsUploadApproverMappingExportInShip", con);
                    cmd.CommandType = CommandType.StoredProcedure;

                    foreach (DataRow row in dataSet.Tables[0].Rows)
                    {
                        cmd.Parameters.AddWithValue("@FormsName", row["UploadedFormName"].ToString());
                        cmd.Parameters.AddWithValue("@ApproverUserId", int.Parse(row["ApproverUserId"].ToString()));

                        cmd.ExecuteNonQuery();
                        cmd.Parameters.Clear();
                    }
                }
            }
            catch (Exception ex)
            {
                TccLog.UpdateLog(ex.InnerException.Message, LogMessageType.Error, "Ship Export-UpdateFillupFormApproverMapper");
                logger.Error(ex, "FillupFormApproverMapper Export");
                //throw;
            }
        }
示例#4
0
        public static void UpdateExportedData()
        {
            logger.Info("Update Export Data Process Started. - {0}", DateTime.Now.ToString());
            TccLog.UpdateLog("Update Export Data Process Started", LogMessageType.Info, "UpdateExportedData");
            try
            {
                UpdateShipUser();
                TccLog.UpdateLog("Update UpdateShipUser IsExport Succesfully", LogMessageType.Info, "Ship Export-UpdateShipUser");
                UpdateTicket();
                TccLog.UpdateLog("Update Ticket IsExport Succesfully", LogMessageType.Info, "Ship Export-UpdateTicket");
                UpdateRevisionViewer();
                TccLog.UpdateLog("Update RevisionViewer IsExport Succesfully", LogMessageType.Info, "Ship Export-UpdateRevisionViewer");
                UpdateFillupFormsUploaded();
                TccLog.UpdateLog("Update FillupFormsUploaded IsExport Succesfully", LogMessageType.Info, "Ship Export-UpdateFillupFormsUploaded");
                UpdateFillupFormApproverMapper();
                TccLog.UpdateLog("Update FillupFormApproverMapper IsExport Succesfully", LogMessageType.Info, "Ship Export-UpdateFillupFormApproverMapper");

                // delete all xml files
                string[] xmlfilePaths = Directory.GetFiles(path + "\\");
                foreach (string filePath in xmlfilePaths)
                {
                    File.Delete(filePath);
                }
            }
            catch (Exception ex)
            {
                TccLog.UpdateLog(ex.InnerException.Message, LogMessageType.Error, "Ship Export-ExportData");
                logger.Error("Error in ExportData. - {0}", ex.Message + " :" + ex.InnerException);
                logger.Info("Ship Export process terminated unsuccessfully in ExportData.");
                //Environment.Exit(0);
            }
        }
示例#5
0
        public static void RevisionViewer()
        {
            try
            {
                logger.Info("Export RevisionViewer Process Started. - {0}", DateTime.Now.ToString());
                TccLog.UpdateLog("Export RevisionViewer Process Started", LogMessageType.Info, "ShipExport - RevisionViewer");

                SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["TCCCMSDBConnectionString"].ConnectionString);
                con.Open();
                //SqlCommand cmd = new SqlCommand("stpExporttblRevisionViewerFromShip", con);
                SqlCommand cmd = new SqlCommand("stpExportRevisionViewerFromShip", con);
                cmd.CommandType = CommandType.StoredProcedure;
                DataSet        ds = new DataSet();
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                da.Fill(ds);

                if (ds.Tables[0].Rows.Count > 0)
                {
                    ds.WriteXml(path + "\\" + ConfigurationManager.AppSettings["xmlRevisionViewer"].ToString(), XmlWriteMode.WriteSchema);
                }
                con.Close();
            }
            catch (Exception ex)
            {
                TccLog.UpdateLog(ex.InnerException.Message, LogMessageType.Error, "Export-RevisionViewer");
            }
        }
示例#6
0
 public static void ExportData()
 {
     logger.Info("Export Process Started. - {0}", DateTime.Now.ToString());
     TccLog.UpdateLog("Export Process Started", LogMessageType.Info, "Ship Export - ExportData");
     try
     {
         ShipUser();
         TccLog.UpdateLog("ShipUser Process Complete", LogMessageType.Info, "Ship Export - ExportData");
         FillupFormsUploaded();
         TccLog.UpdateLog("FillUpFormsUploaded Complete", LogMessageType.Info, "Ship Export - ExportData");
         FillupFormApproverMapper();
         TccLog.UpdateLog("FillUpFormApproverMapper Process Complete", LogMessageType.Info, "Ship Export - ExportData");
         Ticket();
         TccLog.UpdateLog("Ticket Process Complete", LogMessageType.Info, "Ship Export - ExportData");
         RevisionViewer();
         TccLog.UpdateLog("Revision Viewer Process Complete", LogMessageType.Info, "Ship Export - ExportData");
     }
     catch (Exception ex)
     {
         TccLog.UpdateLog(ex.InnerException.Message, LogMessageType.Error, "Export-ExportData");
         logger.Error("Error in ExportData. - {0}", ex.Message + " :" + ex.InnerException);
         logger.Info("Export process terminated unsuccessfully in ExportData.");
         //Environment.Exit(0);
     }
 }
示例#7
0
        public async Task Execute(IJobExecutionContext context)
        {
            logger.Info("Process Started. - {0}", DateTime.Now.ToString());
            TccLog.UpdateLog("Export Process Started", LogMessageType.Info, "Ship Export");
            if (ZipDirectoryContainsFiles())
            {
                TccLog.UpdateLog("Send Mail Process Started", LogMessageType.Info, "Ship Export");
                SendMail();
                if (isMailSendSuccessful)
                {
                    TccLog.UpdateLog("ArchiveZipFiles Process Started", LogMessageType.Info, "Ship Export");
                    ArchiveZipFiles();
                    TccLog.UpdateLog("ArchiveZipFiles Process Completed", LogMessageType.Info, "Ship Export");
                    //redo the whole process again
                    isMailSendSuccessful = false;
                    TccLog.UpdateLog("Export Process Started", LogMessageType.Info, "Ship Export");
                    ExportData();
                    TccLog.UpdateLog("Export Process Completed", LogMessageType.Info, "Ship Export");
                    TccLog.UpdateLog("Zip Process Started", LogMessageType.Info, "Ship Export");
                    CreateZip();
                    TccLog.UpdateLog("Zip Process Completed", LogMessageType.Info, "Ship Export");
                    TccLog.UpdateLog("SendMail Process Started", LogMessageType.Info, "Ship Export");
                    SendMail();
                    TccLog.UpdateLog("SendMail Process Completed", LogMessageType.Info, "Ship Export");

                    UpdateExportedData();
                    TccLog.UpdateLog("Update Exported Data Completed", LogMessageType.Info, "Ship Export");

                    if (isMailSendSuccessful)
                    {
                        TccLog.UpdateLog("Archive Process Started", LogMessageType.Info, "Ship Export");
                        ArchiveZipFiles();
                        TccLog.UpdateLog("Archive Process Completed", LogMessageType.Info, "Ship Export");
                    }
                }
            }
            else
            {
                isMailSendSuccessful = false;
                TccLog.UpdateLog("Export Process Started", LogMessageType.Info, "Ship Export");
                ExportData();
                TccLog.UpdateLog("Export Process Completed", LogMessageType.Info, "Ship Export");
                TccLog.UpdateLog("Zip Process Started", LogMessageType.Info, "Ship Export");
                CreateZip();
                TccLog.UpdateLog("Zip Process Completed", LogMessageType.Info, "Ship Export");
                TccLog.UpdateLog("Send Mail Process Started from Else", LogMessageType.Info, "Export");
                SendMail();
                TccLog.UpdateLog("SendMail Process Completed", LogMessageType.Info, "Ship Export");

                UpdateExportedData();
                TccLog.UpdateLog("Update Exported Data Completed", LogMessageType.Info, "Ship Export");

                if (isMailSendSuccessful)
                {
                    TccLog.UpdateLog("Archive Process Started", LogMessageType.Info, "Ship Export");
                    ArchiveZipFiles();
                    TccLog.UpdateLog("Archive Process Completed", LogMessageType.Info, "Ship Export");
                }
            }
        }
示例#8
0
        public static void ArchiveZipFiles()
        {
            string sourceFilePath      = zippath + "\\";
            string destinationFilePath = ziparchivePath + "\\";

            try
            {
                string[] sourceFiles = Directory.GetFiles(sourceFilePath);

                foreach (string sourceFile in sourceFiles)
                {
                    string fName    = Path.GetFileName(sourceFile);
                    string destFile = Path.Combine(destinationFilePath, fName);

                    File.Move(sourceFile, destFile);
                }

                TccLog.UpdateLog("ArchiveZipFiles Process Complete", LogMessageType.Info, "Export");
            }
            catch (Exception ex)
            {
                TccLog.UpdateLog(ex.InnerException.Message, LogMessageType.Error, "Directory not found Ship Export");
                TccLog.UpdateLog(ex.InnerException.Message, LogMessageType.Error, "Export process terminated unsuccessfully in Admin Export-ArchiveZipFiles");
                logger.Error("Directory not found. - {0}", ex.Message + " :" + ex.InnerException);
                logger.Info("Export process terminated unsuccessfully in ArchiveZipFiles.");
                Environment.Exit(0);
            }
        }
示例#9
0
        public static void SendMail()
        {
            string shipEmail    = GetConfigData("shipemail").Trim();
            string shipEmailpwd = GetConfigData("shipemailpwd").Trim();

            //string shipEmailpwd = EncodeDecode.DecryptString(GetConfigData("shipemailpwd"));

            TccLog.UpdateLog("Got Ship email/pwd", LogMessageType.Info, "ShipExport - SendMail");

            try
            {
                using (MailMessage mail = new MailMessage())
                {
                    mail.Subject = GetConfigData("tccSsubject");
                    //mail.From = new MailAddress(GetConfigData("mailfrom"));
                    //mail.To.Add(GetConfigData("mailto"));

                    //mail.From = new MailAddress(GetConfigData("shipemail"));

                    mail.From = new MailAddress(shipEmail);
                    mail.To.Add(GetConfigData("admincenteremail"));

                    if (ZipDirectoryContainsZipFiles())
                    {
                        string[] sourceFiles = Directory.GetFiles(zippath);

                        foreach (string sourceFile in sourceFiles)
                        {
                            //mail.Attachments.Add(new Attachment(zippath + "\\" + GetZipFileName()));
                            mail.Attachments.Add(new Attachment(sourceFile));
                        }
                    }

                    SmtpClient smtp = new SmtpClient(GetConfigData("smtp"));
                    smtp.EnableSsl = true;
                    //smtp.EnableSsl = false;
                    smtp.Port        = int.Parse(GetConfigData("port"));
                    smtp.Credentials = new System.Net.NetworkCredential(shipEmail, shipEmailpwd);

                    //smtp.Credentials = new System.Net.NetworkCredential(GetConfigData("mailfrom").Trim(), GetConfigData("frompwd").Trim());
                    //smtp.Credentials = new System.Net.NetworkCredential(GetConfigData("mailfrom").Trim(), EncodeDecode.DecryptString(GetConfigData("frompwd")));

                    TccLog.UpdateLog("Sending Mail", LogMessageType.Info, "ShipExport - SendMail");
                    smtp.Send(mail);
                    TccLog.UpdateLog("Send Mail Successfull", LogMessageType.Info, "Export - SendMail");
                    isMailSendSuccessful = true;
                }
            }
            catch (Exception ex)
            {
                //EventLog.WriteEntry("DataExport-SendMail", ex.Message + " :" + ex.InnerException, EventLogEntryType.Error);
                isMailSendSuccessful = false;
                TccLog.UpdateLog(ex.InnerException.Message, LogMessageType.Error, "Export-SendMail");
                logger.Error("Mail send failed - {0}", ex.Message + " :" + ex.InnerException);
                logger.Info("Export process terminated unsuccessfully.");
                Environment.Exit(0);
            }
        }
示例#10
0
 public static bool ZipDirectoryContainsFiles()
 {
     try
     {
         DirectoryInfo di = new DirectoryInfo(zippath + "\\");
         return(di.GetFiles("*.zip").Length > 0);
     }
     catch (Exception ex)
     {
         TccLog.UpdateLog(ex.InnerException.Message, LogMessageType.Error, "Ship Export-ZipDirectoryContainsZipFiles");
         logger.Error("Directory not found. - {0}", ex.Message + " :" + ex.InnerException);
         logger.Info("Export process terminated unsuccessfully in ZipDirectoryContainsZipFiles.");
         return(false);
         //Environment.Exit(0);
     }
 }
示例#11
0
        public static void UpdateTicket()
        {
            try
            {
                // Here your xml file
                string xmlFile = path + "\\" + ConfigurationManager.AppSettings["xmlTicket"].ToString();
                int    ShipId  = int.Parse(ConfigurationManager.AppSettings["SHIPID"].ToString());
                if (File.Exists(xmlFile))
                {
                    DataSet dataSet = new DataSet();
                    dataSet.ReadXmlSchema(xmlFile);
                    dataSet.ReadXml(xmlFile, XmlReadMode.ReadSchema);

                    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["TCCCMSDBConnectionString"].ConnectionString);
                    con.Open();
                    SqlCommand cmd = new SqlCommand("UpdateTicketExportInShip", con);
                    cmd.CommandType = CommandType.StoredProcedure;

                    foreach (DataRow row in dataSet.Tables[0].Rows)
                    {
                        //cmd.Parameters.AddWithValue("@ID", int.Parse(row["ID"].ToString()));

                        if (ShipId == int.Parse(row["ShipId"].ToString()))
                        {
                            cmd.Parameters.AddWithValue("@TicketNumber", row["TicketNumber"].ToString());


                            int x = cmd.ExecuteNonQuery();
                            cmd.Parameters.Clear();
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                TccLog.UpdateLog(ex.InnerException.Message, LogMessageType.Error, "Ship Export-UpdateTicket");
                logger.Error(ex, "Ticket Export");
                //throw;
            }
        }
示例#12
0
        public static void Ticket()
        {
            string uploadedFileName = string.Empty;
            string relativePath     = string.Empty;
            string filePath         = string.Empty;

            try
            {
                logger.Info("Export Ticket Process Started. - {0}", DateTime.Now.ToString());
                TccLog.UpdateLog("Export Ticket Process Started", LogMessageType.Info, "ShipExport - Ticket");

                SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["TCCCMSDBConnectionString"].ConnectionString);
                con.Open();
                //SqlCommand cmd = new SqlCommand("stpExporttblTicketFromShip", con);
                SqlCommand cmd = new SqlCommand("stpExportTicketFromShip", con);
                cmd.CommandType = CommandType.StoredProcedure;
                DataSet        ds = new DataSet();
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                da.Fill(ds);

                if (ds.Tables[0].Rows.Count > 0)
                {
                    ds.WriteXml(path + "\\" + ConfigurationManager.AppSettings["xmlTicket"].ToString(), XmlWriteMode.WriteSchema);
                }
                con.Close();


                string xmlFile = path + "\\" + ConfigurationManager.AppSettings["xmlTicket"].ToString();
                if (File.Exists(xmlFile))
                {
                    CreateUploadedFileZip("TICKET", xmlFile);
                }
            }
            catch (Exception ex)
            {
                TccLog.UpdateLog(ex.InnerException.Message, LogMessageType.Error, "Export-Ticket");
            }
        }
示例#13
0
        public void DownloadAllNewMails(string subjectLine, string attachmentFolderPath)
        {
            try
            {
                TccLog.UpdateLog("Start Downloading", LogMessageType.Info, "Ship Import - DownloadAllNewMails");
                if (MailServerType == MailType.POP3)
                {
                    TccLog.UpdateLog("Start Downloading in POP3", LogMessageType.Info, "Ship Import - DownloadAllNewMails");
                    for (int i = 0; i < pop_Client.Count; i++)
                    {
                        MimeMessage message = pop_Client.GetMessage(i);
                        if (message.Subject.Equals(subjectLine))
                        {
                            foreach (var attachment in message.Attachments)
                            {
                                var    fileName = attachment.ContentDisposition?.FileName ?? attachment.ContentType.Name;
                                string filePath = Path.Combine(attachmentFolderPath, fileName);
                                using (var stream = File.Create(filePath))
                                {
                                    if (attachment is MessagePart)
                                    {
                                        var part = (MessagePart)attachment;

                                        part.Message.WriteTo(stream);
                                    }
                                    else
                                    {
                                        var part = (MimePart)attachment;

                                        part.Content.DecodeTo(stream);
                                    }
                                }
                            }
                            pop_Client.DeleteMessage(i);
                        }
                    }
                }
                else if (MailServerType == MailType.IMAP)
                {
                    try
                    {
                        TccLog.UpdateLog("Start Downloading in IMAP", LogMessageType.Info, "Ship Import - DownloadAllNewMails");
                        IList <UniqueId> uids = null;
                        var inbox             = imap_Client.Inbox;
                        TccLog.UpdateLog("Checking Inbox null  in IMAP", LogMessageType.Info, "Ship Import - DownloadAllNewMails");
                        if (inbox != null)
                        {
                            inbox.Open(FolderAccess.ReadWrite);
                            uids = inbox.Search(SearchQuery.NotSeen);
                        }
                        TccLog.UpdateLog("Checked Inbox in IMAP", LogMessageType.Info, "Ship Import - DownloadAllNewMails");
                        foreach (UniqueId uid in uids)
                        {
                            MimeMessage message = inbox.GetMessage(uid);
                            if (message.Subject.Equals(subjectLine))
                            {
                                foreach (MimeEntity attach in message.Attachments)
                                {
                                    var    fileName = attach.ContentDisposition?.FileName ?? attach.ContentType.Name;
                                    string filePath = Path.Combine(attachmentFolderPath, fileName);
                                    using (var streem = File.Create(filePath))
                                    {
                                        if (attach is MessagePart)
                                        {
                                            var part = (MessagePart)attach;
                                            part.Message.WriteTo(streem);
                                        }
                                        else
                                        {
                                            var part = (MimePart)attach;
                                            part.Content.DecodeTo(streem);
                                        }
                                    }
                                }
                                inbox.AddFlags(uid, MessageFlags.Deleted, true);
                                inbox.Expunge();
                            }
                        }
                    }
                    catch (Exception ex)
                    {
                        TccLog.UpdateLog(ex.Message, LogMessageType.Error, "Ship Import - DownloadAllNewMails");
                    }
                }
            }
            catch (Exception ex)
            {
                LogHelper.Log(LogTarget.EventLog, ex.Message);
                TccLog.UpdateLog(ex.Message, LogMessageType.Error, "Ship Import - DownloadAllNewMails");
            }
            finally
            {
                if (MailServerType == MailType.POP3)
                {
                    //pop.Disconnect();
                    pop_Client.Disconnect(true);
                }
                else
                {
                    //imap.Disconnect();
                    imap_Client.Disconnect(true);
                }
                // Dispose();
            }
            if (MailServerType == MailType.POP3)
            {
                //pop.Disconnect();
                pop_Client.Disconnect(true);
            }
            else
            {
                //imap.Disconnect();
                imap_Client.Disconnect(true);
            }
        }
示例#14
0
        public static void CreateUploadedFileZip(string partName, string xmlFile)
        {
            try
            {
                TccLog.UpdateLog("Uploaded File Zip Creation Started", LogMessageType.Info, "Ship Export-CreateZip");
                logger.Info("Uploaded File Zip Creation Started.- {0}", DateTime.Now.ToString());

                //string xmlFile = path + "\\" + ConfigurationManager.AppSettings["xmlTicket"].ToString();
                string tmpPath = Path.Combine(Path.GetDirectoryName(path), "temp");

                TccLog.UpdateLog("tem path : " + tmpPath, LogMessageType.Info, "Ship Export-CreateZip");
                TccLog.UpdateLog("xml : " + xmlFile, LogMessageType.Info, "Ship Export-CreateZip");
                DataSet dataSet = new DataSet();
                dataSet.ReadXmlSchema(xmlFile);
                dataSet.ReadXml(xmlFile, XmlReadMode.ReadSchema);

                foreach (DataRow row in dataSet.Tables[0].Rows)
                {
                    //string sourcePath = @"C:\\inetpub\\wwwroot\\TCCCMS";
                    string sourcePath       = ConfigurationManager.AppSettings["iisPath"].ToString();
                    string uploadedFileName = string.Empty;
                    string relPath          = string.Empty;
                    string filePath         = string.Empty;
                    TccLog.UpdateLog(sourcePath, LogMessageType.Error, "Export-CreateUploadedZipFile- foreach");
                    if (partName == "TICKET")
                    {
                        filePath         = row["FilePath"].ToString();
                        uploadedFileName = Path.GetFileName(filePath);
                    }
                    else
                    {
                        filePath         = row["FormsPath"].ToString();
                        uploadedFileName = row["FormsName"].ToString();
                    }

                    relPath = Path.GetDirectoryName(filePath);
                    relPath = relPath.Replace("~", "").Replace("/", "");

                    //sourcePath = Path.Combine(sourcePath, relPath);
                    sourcePath = sourcePath + relPath;
                    sourcePath = Path.Combine(sourcePath, uploadedFileName);

                    TccLog.UpdateLog("Source: " + sourcePath, LogMessageType.Error, "Export-CreateUploadedZipFile- foreach");
                    TccLog.UpdateLog("Temp Destination: " + Path.Combine(tmpPath, uploadedFileName), LogMessageType.Error, "Export-CreateUploadedZipFile- foreach");

                    if (File.Exists(sourcePath))
                    {
                        File.Copy(sourcePath, Path.Combine(tmpPath, uploadedFileName));
                        TccLog.UpdateLog("File copied from IIS to Temp", LogMessageType.Error, "Export-CreateUploadedZipFile- foreach");
                    }
                    else
                    {
                        TccLog.UpdateLog("File not copied from IIS to Temp", LogMessageType.Error, "Export-CreateUploadedZipFile- foreach");
                    }
                }
                //if (File.Exists(tmpPath))
                if (Directory.GetFiles(tmpPath, "*.*").Length > 0)
                {
                    SqlConnection con    = new SqlConnection(ConfigurationManager.ConnectionStrings["TCCCMSDBConnectionString"].ConnectionString);
                    int           ShipId = int.Parse(ConfigurationManager.AppSettings["SHIPID"].ToString());

                    TccLog.UpdateLog("Ship NO:- " + ShipId, LogMessageType.Error, "Export-CreateUploadedZipFile- foreach");
                    con.Open();
                    SqlCommand cmd = new SqlCommand("GetShipDetailsById", con);
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.AddWithValue("@ShipId", ShipId);
                    DataSet        ds = new DataSet();
                    SqlDataAdapter da = new SqlDataAdapter(cmd);
                    da.Fill(ds);
                    //string fileName = ds.Tables[0].Rows[0]["IMONumber"].ToString();
                    string zipName = ds.Tables[0].Rows[0]["ID"].ToString();
                    //zipName = zipName + "_TICKET_" + DateTime.Now.ToString("MMddyyyyhhmm");
                    zipName = zipName + "_" + partName + "_" + DateTime.Now.ToString("MMddyyyyhhmm");
                    zipName = zipName + ".zip";

                    using (ZipFile zip = new ZipFile())
                    {
                        zip.AddDirectory(tmpPath + "\\");
                        zip.Comment = "This zip was created at " + System.DateTime.Now.ToString("G");

                        zip.MaxOutputSegmentSize = int.Parse(ConfigurationManager.AppSettings["OutputSize"].ToString());
                        zip.Save(path + "\\" + zipName); //---Create Zip of Uploaded file in 'xml' folder. ---
                                                         // SegmentsCreated = zip.NumberOfSegmentsForMostRecentSave;
                    }

                    //delete xml files
                    string[] filePaths = Directory.GetFiles(tmpPath + "\\");

                    foreach (string filePath in filePaths)
                    {
                        File.Delete(filePath);
                    }


                    ///------------------------------------------------
                }
                else
                {
                    TccLog.UpdateLog("file not exist in temp path : " + tmpPath, LogMessageType.Info, "Ship Export-CreateZip");
                }
            }
            catch (Exception ex)
            {
                TccLog.UpdateLog(ex.InnerException.Message, LogMessageType.Error, "Export-CreateUploadedZipFile");
                logger.Error("Error in CreateZip. - {0}", ex.Message + " :" + ex.InnerException);
                logger.Info("Export process terminated unsuccessfully in CreateZip.");
                //Environment.Exit(0);
            }
        }
示例#15
0
        public static void CreateZip()
        {
            try
            {
                //string[] xmlPaths = Directory.GetFiles(path + "\\");

                //foreach (string xmlfilePath in xmlPaths)
                //{
                //    //xml file copy to temp folder and then zip that file
                //    string xmlFile = Path.GetFileName(xmlfilePath);
                //    string tmpxPath = Path.Combine(Path.GetDirectoryName(xmlfilePath), "temp");
                //    File.Copy(xmlfilePath, Path.Combine(tmpxPath, xmlFile));

                //    string fileName = Path.GetFileNameWithoutExtension(xmlfilePath);
                //    fileName = fileName + "_" + DateTime.Now.ToString("MMddyyyyhhmm");
                //    fileName = fileName + ".zip";
                //    using (ZipFile zip = new ZipFile())
                //    {
                //        zip.AddDirectory(tmpxPath + "\\");
                //        zip.Comment = "This zip was created at " + System.DateTime.Now.ToString("G");

                //        zip.MaxOutputSegmentSize = int.Parse(ConfigurationManager.AppSettings["OutputSize"].ToString());
                //        zip.Save(zippath + "\\" + fileName);

                //        //Delete file from temp foldes
                //        File.Delete(Path.Combine(tmpxPath, xmlFile));
                //    }

                //    File.Delete(xmlfilePath);

                //}

                //------------------------------------------------------------------------------------------------------------
                if (Directory.GetFiles(path, "*.*").Length > 0) //Added on 20th jul 2021 @BK
                {
                    SqlConnection con    = new SqlConnection(ConfigurationManager.ConnectionStrings["TCCCMSDBConnectionString"].ConnectionString);
                    int           ShipId = int.Parse(ConfigurationManager.AppSettings["SHIPID"].ToString());
                    con.Open();
                    SqlCommand cmd = new SqlCommand("GetShipDetailsById", con);
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.AddWithValue("@ShipId", ShipId);
                    DataSet        ds = new DataSet();
                    SqlDataAdapter da = new SqlDataAdapter(cmd);
                    da.Fill(ds);
                    //string fileName = ds.Tables[0].Rows[0]["IMONumber"].ToString();
                    string fileName = ds.Tables[0].Rows[0]["ID"].ToString();
                    fileName = fileName + "_" + DateTime.Now.ToString("MMddyyyyhhmm");
                    fileName = fileName + ".zip";

                    using (ZipFile zip = new ZipFile())
                    {
                        zip.AddDirectory(path + "\\");
                        zip.Comment = "This zip was created at " + System.DateTime.Now.ToString("G");

                        zip.MaxOutputSegmentSize = int.Parse(ConfigurationManager.AppSettings["OutputSize"].ToString());
                        zip.Save(zippath + "\\" + fileName);
                        // SegmentsCreated = zip.NumberOfSegmentsForMostRecentSave;
                    }

                    //delete xml files
                    //string[] filePaths = Directory.GetFiles(path + "\\");

                    //foreach (string filePath in filePaths)

                    //    File.Delete(filePath);
                }
            }
            catch (Exception ex)
            {
                TccLog.UpdateLog(ex.InnerException.Message, LogMessageType.Error, "Export-CreateZip");
                logger.Error("Error in CreateZip. - {0}", ex.Message + " :" + ex.InnerException);
                logger.Info("Export process terminated unsuccessfully in CreateZip.");
                //Environment.Exit(0);
            }
        }