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");
}
}
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");
}
}
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;
}
}
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);
}
}
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");
}
}
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);
}
}
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");
}
}
}
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);
}
}
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);
}
}
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);
}
}
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;
}
}
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");
}
}
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);
}
}
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);
}
}
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);
}
}