public static string FileLocation(Outlook.MailItem email)
{
try
{
string loc = "";
string[] sArray = email.Headers("Message-ID");
//Should only ever be 1 message-ID!
string id = "";
if (sArray.Length == 1)
{
id = sArray[0];
MessageBox.Show(id);
}
else
{
MessageBox.Show("Unable to find message Id");
}
DataTable fileid = XLSQL.ReturnTable("Select fileid + '-' + version from VCMailID where MailID = '" + id + "'");
string filename = "";
if (fileid != null)
{
filename = fileid.Rows[0][0].ToString();
MessageBox.Show(filename);
}
else
{
MessageBox.Show("Unable to find file ID");
}
string folder = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "\\Virtual Cabinet\\Edited documents\\";
loc = folder + filename;
return(loc);
}
catch (Exception ex)
{
MessageBox.Show("Unable to get file location");
XLtools.LogException("FileLocation", ex.ToString());
return(null);
}
}
private void button1_Click(object sender, EventArgs e)
{
this.textBox1.Text = DateTime.Now.ToString() + "\r\n";
Outlook.MAPIFolder selectedFolder = (Outlook.MAPIFolder) this.comboBox1.SelectedValue;
List <Outlook.MAPIFolder> processFolders = new List <Outlook.MAPIFolder>();
processFolders.Add(selectedFolder);
foreach (Outlook.MAPIFolder folder in selectedFolder.Folders)
{
processFolders.Add(folder);
foreach (Outlook.MAPIFolder subFolder_1 in folder.Folders)
{
processFolders.Add(subFolder_1);
foreach (Outlook.MAPIFolder subFolder_2 in subFolder_1.Folders)
{
processFolders.Add(subFolder_2);
foreach (Outlook.MAPIFolder subFolder_3 in subFolder_2.Folders)
{
processFolders.Add(subFolder_3);
}
}
}
}
foreach (Outlook.MAPIFolder folder in processFolders)
{
this.textBox1.AppendText(string.Format("Carpeta: {0}\r\n", folder.Name));
}
int totalItems = processFolders.Select <Outlook.MAPIFolder, int>(fld => fld.Items.Count).Aggregate <int>((a, b) => a + b);
this.textBox1.AppendText(string.Format("Cant Items: {0}\r\n", totalItems));
Dictionary <string, int> dictCuenta = new Dictionary <string, int>();
DataTable dtMails = new DataTable();
dtMails.Columns.Add("Carpeta", typeof(string));
dtMails.Columns.Add("Id", typeof(int));
dtMails.Columns.Add("EntryID", typeof(string));
dtMails.Columns.Add("Message-ID", typeof(string));
dtMails.Columns.Add("MessageClass", typeof(string));
dtMails.Columns.Add("Sender", typeof(string));
dtMails.Columns.Add("ReceivedTime", typeof(DateTime));
dtMails.Columns.Add("Subject", typeof(string));
this.dataGridView1.DataSource = null;
foreach (Outlook.MAPIFolder folder in processFolders)
{
this.textBox1.AppendText(string.Format("Procesando Carpeta: {0}...\r\n", folder.Name));
totalItems = folder.Items.Count;
this.textBox1.AppendText(string.Format(" Cant Items: {0}\r\n", totalItems));
for (int i = 1; i <= totalItems; i++)
{
dynamic item = folder.Items[i];
var row = dtMails.NewRow();
row["Carpeta"] = folder.Name;
row["Id"] = i;
if (item is Outlook.MailItem)
{
Outlook.MailItem mail = (Outlook.MailItem)folder.Items[i];
//this.textBox1.AppendText(i.ToString() + ": (MAIL)\r\n");
//this.textBox1.AppendText(i.ToString() + ": " + mail.EntryID + "\r\n");
int cant = 0;
if (dictCuenta.TryGetValue(mail.EntryID, out cant))
{
dictCuenta[mail.EntryID] = cant + 1;
}
else
{
dictCuenta.Add(mail.EntryID, 1);
}
Outlook.PropertyAccessor pa = (Outlook.PropertyAccessor)mail.PropertyAccessor;
string[] headers = mail.Headers("Message-ID");
string message_id = string.Empty;
if (headers.Length > 0)
{
message_id = mail.Headers("Message-ID")[0];
}
else
{
message_id = "*";
StringBuilder text_to_hash = new StringBuilder(100000);
text_to_hash.Append(mail.To); text_to_hash.Append("\r\n...\r\n");
text_to_hash.Append(mail.CC); text_to_hash.Append("\r\n...\r\n");
text_to_hash.Append(mail.Subject); text_to_hash.Append("\r\n...\r\n");
text_to_hash.Append(mail.HTMLBody); text_to_hash.Append("\r\n...\r\n");
text_to_hash.Append(mail.Body); text_to_hash.Append("\r\n...\r\n");
text_to_hash.Append(mail.RTFBody); text_to_hash.Append("\r\n...\r\n");
var sha1 = new System.Security.Cryptography.SHA1Managed();
var hash = sha1.ComputeHash(Encoding.UTF8.GetBytes(text_to_hash.ToString()));
var str_hash = string.Join("", hash.Select(b => b.ToString("x2")).ToArray());
message_id = "HASH-" + str_hash;
}
row["EntryID"] = mail.EntryID;
row["Message-ID"] = message_id;
row["MessageClass"] = mail.MessageClass;
if (mail.Sender != null)
{
row["Sender"] = mail.Sender.Name;
}
row["ReceivedTime"] = mail.ReceivedTime;
row["Subject"] = mail.Subject;
}
else if (item is Outlook.MeetingItem)
{
Outlook.MeetingItem meeting = (Outlook.MeetingItem)item;
row["EntryID"] = meeting.EntryID;
row["Sender"] = meeting.SenderName;
row["MessageClass"] = meeting.MessageClass;
row["ReceivedTime"] = meeting.ReceivedTime;
row["Subject"] = meeting.Subject;
//this.textBox1.AppendText(i.ToString() + ": (MEETING)" + "\r\n");
}
else
{
row["EntryID"] = item.EntryID;
row["MessageClass"] = item.MessageClass;
try
{
row["ReceivedTime"] = item.ReceivedTime;
}
catch
{
try
{
row["ReceivedTime"] = item.CreationTime;
}
catch { }
}
row["Subject"] = item.Subject;
//this.textBox1.AppendText(i.ToString() + ": (OTRO)\r\n");
}
dtMails.Rows.Add(row);
if (i % 100 == 0)
{
this.textBox1.AppendText(i + "... ");
}
}
this.textBox1.AppendText(totalItems + ".\r\n");
}
this.dataGridView1.DataSource = dtMails;
}
