Export Script

#r System.Data.Common.dll
#r System.Data.dll
#r System.Net.dll
#r System.Net.Mail.dll
#r System.ComponentModel.TypeConverter.dll
#r System.Net.Primitives.dll
#r System.Runtime.InteropServices.dll


using System;
using System.IO;
using System.Data;
using System.Text;
using System.Net;
using System.Net.Mail;
using System.Collections.Generic;


public static bool  ExportScript(ExportContext context)
	{
		var ChatGPT= context.GlobalData["ChatGPT"] as string;
		if(ChatGPT == "1")
		{
			context.Log("Executing Email script");
			var data_files = new List<string>();
			data_files = context.ExportFiles.GetDataFiles();
			var filename= data_files[0];
			var EXPORT_DIR= Path.GetDirectoryName(filename);
			var processedFileName = Path.Combine(EXPORT_DIR, "processed_articles.csv");
			//context.Log("ProcessedFile "+processedFileName);
			if (File.Exists(processedFileName) && (new FileInfo(processedFileName).Length!= 0))
			{


				context.Log("DataTable is not empty");
				var emailBody = generateEmailBody(context, processedFileName);
				//context.Log("emailBody"+emailBody.ToString());
				var dtemail = DateTime.UtcNow.ToString("MM-dd-yyyy");
				string subject = "V4 NewsMonitorBing- Negative Sentiment Alert:" + dtemail;				
				sent_email(context, subject, emailBody);
			}
			else
			{
			context.Log("DataTable is empty");	
			return true;
			}
			
		}


		return true;
	}
	public static void sent_email(ExportContext context, string emailSubject, string emailBody)
	{
		if (!string.IsNullOrEmpty(emailBody))
		{
			var toAddress = context.GlobalData["DistributionList"] as string;
			context.Log(toAddress);
			
			var dtemail = DateTime.UtcNow.ToString("MM-dd-yyyy");


			context.Log("Successful Credentials");
			
			


			string img1=context.SharedFiles["NewsMonitor.zip/1c195a45eb5b931303b1766dc9854dbf.png"];
			string img2=context.SharedFiles["NewsMonitor.zip/81d966296b73f2aeecc892b90a47710b.jpg"];
			string img3=context.SharedFiles["NewsMonitor.zip/465665d51ef28198d2939afe39b25604.png"];
			string img4=context.SharedFiles["NewsMonitor.zip/8368706fdbd631efccf7eb83699d3214.png"];
            string[] imagesList = {img1, img2, img3, img4};
			


			 
	        try
	        {
				context.ScriptUtilities.SendEmail(toAddress, emailSubject, emailBody, true, null, null, null, imagesList, true, false);
	            //smtp.Send(message);
	            context.Log("Email sent successfully!");
	        }
	        catch (Exception ex)
	        {
	            context.Log("Error sending email: " + ex.Message);
	        }


		}
	}
	
	public static string generateEmailBody(ExportContext context, string csvPath)
	{
		//context.Log("Under generateEmailBody function");
		Dictionary<string, List<Dictionary<string, string>>> negativeNewsArticles = new Dictionary<string, List<Dictionary<string, string>>>();
		List<string> emailMessageList = new List<string>();
		
		var articleOpeningTag = @"<div class=""w  pr-16 pl-16"" style=""background:#fffffe;background-color:#fffffe;margin:0px auto;max-width:622px;"">
								<table align=""center"" border=""0"" cellpadding=""0"" cellspacing=""0"" role=""presentation"" style=""background:#fffffe;background-color:#fffffe;width:100%;"">
								<tbody><tr><td style=""border:none;direction:ltr;font-size:0;padding:0px 32px 32px 32px;text-align:center;"">";
		
		var articleClosingTag = "</td></tr></tbody></table></div>";
		
		var emailTemplate =  File.ReadAllText(context.SharedFiles["NewsMonitor.zip/emailTemplate.html"]);
		var insertCompany = File.ReadAllText(context.SharedFiles["NewsMonitor.zip/insertCompanyTag.txt"]);
		var insertArticle = File.ReadAllText(context.SharedFiles["NewsMonitor.zip/insertArticleTag.txt"]);
		var insertSeparator = File.ReadAllText(context.SharedFiles["NewsMonitor.zip/insertArticleSeparatorTag.txt"]);
		var currentDate = DateTime.UtcNow.ToString("MM/dd/yy");
		
		var csv_read_all = context.ScriptUtilities.LoadCsvFileIntoDataTable(csvPath);
		
		var articleScanned = csv_read_all.Rows.Count;
		
		DataView dv = new DataView(csv_read_all);
		dv.RowFilter = "TRIM([Sentiment]) = 'negative'";
		dv.Sort = "Company ASC";
		DataTable filtered_data = dv.ToTable(true);
		
		var negativeArticles = filtered_data.Rows.Count;
		
        foreach (System.Data.DataRow row in filtered_data.Rows)
        {
			var companyName = row["Company"].ToString();
			
            if (!negativeNewsArticles.ContainsKey(companyName))
                negativeNewsArticles[companyName] = new List<Dictionary<string, string>>();
			
			Dictionary<string, string> articleList = new Dictionary<string, string>
			{
				{"Title", row["Title"].ToString()},
				{"Site Name", row["Site Name"].ToString()},
				{"ImageURL", row["ImageURL"].ToString()},
				{"TitleURL", row["Page Url"].ToString()}
				
			};
			negativeNewsArticles[companyName].Add(articleList);
        }
		
        foreach (var kvp in negativeNewsArticles)
        {
			List<string> articleMessageList = new List<string>();
			var companyName = insertCompany.Replace("{COMPANY_NAME}", kvp.Key);


			emailMessageList.Add(companyName);


            foreach (var innerDict in kvp.Value)
            {
				var article = insertArticle.Replace("{ARTICLE_TITLE}", innerDict["Title"])
					.Replace("{ARTICLE_SITE_NAME}", innerDict["Site Name"])
					.Replace("{ARTICLE_IMAGE_URL}", innerDict["ImageURL"])
					.Replace("{ARTICLE_TITLE_URL}", innerDict["TitleURL"]);
				
				articleMessageList.Add(article);
            }
			var articleBody = string.Join(insertSeparator, articleMessageList.ToArray());
			
			if (!string.IsNullOrEmpty(articleBody))
			{
				emailMessageList.Add(string.Format("{0}{1}{2}", articleOpeningTag, articleBody, articleClosingTag));
			}
		}
		
		var articleData = string.Join("", emailMessageList.ToArray());
		//context.Log("articleData value=  "+articleData.ToString());
		emailTemplate = emailTemplate.Replace("{CURRENT_DATE}", currentDate).Replace("{NUMBER_OF_NEGATIVE_ARTICLE}", negativeArticles.ToString()).Replace("{ARTICLE_SCANNED}", articleScanned.ToString()).Replace("{ARTICLE_DATA}", articleData);
		//context.Log("emailTemplate value=  "+emailTemplate.ToString());
		return emailTemplate;
	}