public void FindLastInConversation(Outlook.MailItem mailItem)
{
if (mailItem is Outlook.MailItem)
{
// Determine the store of the mail item.
Outlook.Folder folder = mailItem.Parent as Outlook.Folder;
Outlook.Store store = folder.Store;
if (store.IsConversationEnabled)
{
// Obtain a Conversation object.
Outlook.Conversation conv = mailItem.GetConversation();
// Check for null Conversation.
if (conv != null)
{
// Obtain Table that contains rows
Outlook.Table table = conv.GetTable();
int count = table.GetRowCount();
Logger.Log("Conversation Items Count: " + count.ToString());
table.MoveToStart();
if (!table.EndOfTable)
{
// lastRow conatins the last item from the conversation
Outlook.Row lastRow = table.GetNextRow();
//Logger.Log(lastRow["Subject"] + " Modified: " + lastRow["LastModificationTime"]);
}
}
}
}
}
/// <summary>
/// Read all possible contact and return it
/// </summary>
/// <param name="cacheTimeStamp">For future using</param>
/// <returns>Distionry where key is EntryID and Value is Last Modification Time</returns>
public Dictionary <string, DateTime> GetTableFilter(DateTime cacheTimeStamp)
{
//string criteria = string.Format("[LastModificationTime] > '{0}'", cacheTimeStamp.ToString("yyyyMMdd HH:mm:ss"));
Outlook.Table table = _ContactFolder.GetTable(Type.Missing, Type.Missing);
Dictionary <string, DateTime> ret = new Dictionary <string, DateTime>();
while (!table.EndOfTable)
{
Outlook.Row nextRow = table.GetNextRow();
ret.Add(nextRow["EntryID"].ToString(), (DateTime)nextRow["LastModificationTime"]);
}
return(ret);
}
/// <summary>Creates a DataGridView control that displays the contact
/// information contained in the specified Table object.</summary>
/// <param name="table">The Table containing the contact data to display.
/// </param>
/// <returns>The new DataGridView.</returns>
private DataGridView NewDataGrid(Outlook.Table table)
{
DataGridView dataGrid = new DataGridView();
// For each column in the table, add a column to the control. Note that the
// Table column collection uses 1-based indexing; whereas, the DataGridView
// column collection uses 0-based indexing.
dataGrid.ColumnCount = table.Columns.Count;
for (int i = 1; i <= table.Columns.Count; i++)
{
Outlook.Column tableColumn = table.Columns[i];
DataGridViewColumn dataColumn = dataGrid.Columns[i - 1];
dataColumn.Name = tableColumn.Name;
dataColumn.HeaderText = Constants.GetDisplayName(tableColumn.Name);
dataColumn.ValueType = Constants.GetDataType(tableColumn.Name);
dataColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
// Format the Purchase Estimate property data as currency.
if (dataColumn.HeaderText == Constants.purchaseEstimateDisplayName)
{
dataColumn.DefaultCellStyle.Format = "C";
}
}
// For each row in the table, add the contact data to the control.
table.MoveToStart();
while (!table.EndOfTable)
{
Outlook.Row contact = table.GetNextRow();
object[] contactData = contact.GetValues();
// The ordering of the contact property values returned by the
// Table's GetValues method matches the ordering of the column
// information returned by the Table's Columns property.
dataGrid.Rows.Add(contactData);
}
// Modify the control's display and behavior properties.
dataGrid.AutoSize = true;
dataGrid.Dock = DockStyle.Fill;
dataGrid.BorderStyle = BorderStyle.FixedSingle;
dataGrid.ReadOnly = true;
return(dataGrid);
}
private void DemoTableColumns()
{
const string PR_HAS_ATTACH =
"http://schemas.microsoft.com/mapi/proptag/0x0E1B000B";
// Obtain Inbox
Microsoft.Office.Interop.Outlook.Folder folder = MailNS.GetDefaultFolder(OlDefaultFolders.olFolderInbox) as Folder;//Microsoft.Office.Interop.Outlook.Application.Session.GetDefaultFolder(Microsoft.Office.Interop.Outlook.OlDefaultFolders.olFolderInbox)as Microsoft.Office.Interop.Outlook.Folder;
// Create filter
string filter = "@SQL=" + "\""
+ PR_HAS_ATTACH + "\"" + " = 1";
// Must use 'like' comparison for Find/FindNext
string filter1 = "@SQL="
+ "\"" + "urn:schemas:httpmail:subject" + "\""
+ " like '%License Keys - Order%'";
Microsoft.Office.Interop.Outlook.Table table =
folder.GetTable(filter,
Microsoft.Office.Interop.Outlook.OlTableContents.olUserItems);
// Remove default columns
table.Columns.RemoveAll();
// Add using built-in name
table.Columns.Add("EntryID");
table.Columns.Add("Subject");
table.Columns.Add("ReceivedTime");
table.Sort("ReceivedTime", Microsoft.Office.Interop.Outlook.OlSortOrder.olDescending);
// Add using namespace
// Date received
table.Columns.Add(
"urn:schemas:httpmail:datereceived");
while (!table.EndOfTable)
{
Microsoft.Office.Interop.Outlook.Row nextRow = table.GetNextRow();
StringBuilder sb = new StringBuilder();
sb.AppendLine(nextRow["Subject"].ToString());
// Reference column by name
sb.AppendLine("Received (Local): "
+ nextRow["ReceivedTime"]);
// Reference column by index
sb.AppendLine("Received (UTC): " + nextRow[4]);
sb.AppendLine();
System.Diagnostics.Debug.WriteLine(sb.ToString());
}
}
private void searchSentMailUsingTable()
{
Outlook.NameSpace nameSpace = null;
Outlook.Folder sentFolder = null;
Outlook.Table sentTable = null;
Messages messages = new Messages(System.Security.Principal.WindowsIdentity.GetCurrent().Name);
try
{
nameSpace = OutlookApplication.GetNamespace("MAPI");
sentFolder = nameSpace.GetDefaultFolder(
Outlook.OlDefaultFolders.olFolderSentMail) as Outlook.Folder;
if (sentFolder != null)
{
sentTable = sentFolder.GetTable();
sentTable.Columns.Add(TO);
sentTable.Columns.Add(CC);
while (!sentTable.EndOfTable)
{
Outlook.Row row = sentTable.GetNextRow();
messages.Add(new Message(row[TO], row[CC], null));
Marshal.ReleaseComObject(row);
}
Marshal.ReleaseComObject(sentTable);
}
}
finally
{
if (sentFolder != null)
{
Marshal.ReleaseComObject(sentFolder);
}
if (nameSpace != null)
{
Marshal.ReleaseComObject(nameSpace);
}
}
if (messages.items.Count() > 0)
{
postHistory(messages);
}
}
public IItemData[] GetFiles()
{
var outputFiles = new List <IItemData>();
Outlook.Table folderTable = folder.GetTable("", Outlook.OlTableContents.olUserItems);
folderTable.Columns.RemoveAll();
// For property names, see: https://stackoverflow.com/questions/50576645/outlook-mapi-message-class-metadata-in-outlook-2016
// Open Outlook script editor in developer mode and Press F2 to browse classes and fields
// https://docs.microsoft.com/en-us/office/vba/outlook/concepts/forms/outlook-fields-and-equivalent-properties
folderTable.Columns.Add("MessageClass");
folderTable.Columns.Add("Subject");
folderTable.Columns.Add("Size");
folderTable.Columns.Add("LastModificationTime");
while (!folderTable.EndOfTable)
{
try
{
Outlook.Row row = folderTable.GetNextRow();
if (row["subject"] == null)
{
continue;
}
var messageClass = row["MessageClass"].ToString();
var pathParts = new List <string>(this.FullName.Split(new char[] { '/', '\\' }));
pathParts.Add(row["Subject"].ToString());
var newItem = new ColumnarItemData(pathParts.ToArray(), Columns.ColumnLookup);
newItem.SetValue(ITEMSIZE, (int)row["Size"]);
var lastModificationTime = row["LastModificationTime"];
newItem.SetValue(ITEMDATE, lastModificationTime.ToString());
outputFiles.Add(newItem);
}
catch (System.Exception e)
{
Debug.WriteLine("Mesage Error: " + e.Message);
}
}
return(outputFiles.ToArray());
}
public IItemData[] GetFiles()
{
var outputFiles = new List <IItemData>();
Outlook.Table folderTable = folder.GetTable("", Outlook.OlTableContents.olUserItems);
folderTable.Columns.RemoveAll();
folderTable.Columns.Add("MessageClass");
folderTable.Columns.Add("Subject");
folderTable.Columns.Add("Size");
while (!folderTable.EndOfTable)
{
Outlook.Row row = folderTable.GetNextRow();
if (row["subject"] == null)
{
continue;
}
var newItem = new ColumnarItemData(new string[] { row["Subject"].ToString() }, Columns.ColumnLookup);
newItem.SetValue(ITEMSIZE, (int)row["Size"]);
outputFiles.Add(newItem);
}
return(outputFiles.ToArray());
}
static List <Mail1> checkMailsInFolderForAnswer(string folder)
{
Outlook.Folder defFold = ns.GetDefaultFolder(Outlook.OlDefaultFolders.olFolderInbox) as Outlook.Folder;
Outlook.Folder tempFold = null;
foreach (Outlook.Folder subfolder in defFold.Folders)
{
if (subfolder.Name == folder)
{
tempFold = subfolder;
break;
}
}
string filter = DateTime.Now.AddHours(-DateTime.Now.Hour).AddMinutes(-DateTime.Now.Minute).AddHours(-3).ToString("dd/MM/yyyy HH:mm").Replace(".", "/");
Outlook.Items items = tempFold.Items.Restrict($"[CreationTime]>'{filter}'");
List <Mail1> mails1TempList = new List <Mail1>();
foreach (Outlook.MailItem mail in items)
{
Mail1 mailTemp = new Mail1();
mailTemp.sender = mail.SenderName;
mailTemp.Topic = mail.ConversationTopic;
mailTemp.senderEmailAdr = getSenderEmailAddress(mail);
mailTemp.sendDate = mail.CreationTime;
Outlook.Conversation tc = mail.GetConversation();
Outlook.Table table1 = tc.GetTable();
table1.Columns.Add("http://schemas.microsoft.com/mapi/proptag/0x5D0A001F"); //email от кого письмо
table1.Columns.Add("http://schemas.microsoft.com/mapi/proptag/0x3FF8001F"); //От кого письмо
//Console.WriteLine(table1.GetRowCount());
if (table1.GetRowCount() > 1)
{
List <Mail1> listOfMembers = new List <Mail1>();
while (!table1.EndOfTable)
{
Mail1 t = new Mail1();
Outlook.Row row = table1.GetNextRow();
t.sendDate = row["CreationTime"];
t.sender = row["http://schemas.microsoft.com/mapi/proptag/0x3FF8001F"];
t.senderEmailAdr = row["http://schemas.microsoft.com/mapi/proptag/0x5D0A001F"];
t.sender = row["http://schemas.microsoft.com/mapi/proptag/0x3FF8001F"];
if (needToBesnaweredByThisList.Contains(t.senderEmailAdr))
{
if (t.sender != mailTemp.sender)
{
mailTemp.answeredByList.Add(t);
}
}
}
mails1TempList.Add(mailTemp);
}
else
{
mails1TempList.Add(mailTemp);
}
}
return(mails1TempList);
#region commented
// For this example, you will work only with
//MailItem. Other item types such as
//MeetingItem and PostItem can participate
//in Conversation.
//if (selectedItem is Outlook.MailItem)
//{
// // Cast selectedItem to MailItem.
// Outlook.MailItem mailItem =
// selectedItem as Outlook.MailItem; ;
// // Determine store of mailItem.
// Outlook.Folder folder = mailItem.Parent
// as Outlook.Folder;
// Outlook.Store store = folder.Store;
// if (store.IsConversationEnabled == true)
// {
// // Obtain a Conversation object.
// Outlook.Conversation conv =
// mailItem.GetConversation();
// // Check for null Conversation.
// if (conv != null)
// {
// // Obtain Table that contains rows
// // for each item in Conversation.
// Outlook.Table table = conv.GetTable();
// Debug.WriteLine("Conversation Items Count: " +
// table.GetRowCount().ToString());
// Debug.WriteLine("Conversation Items from Table:");
// while (!table.EndOfTable)
// {
// Outlook.Row nextRow = table.GetNextRow();
// Console.WriteLine(nextRow["Subject"]
// + " Modified: "
// + nextRow["LastModificationTime"]);
// }
// Debug.WriteLine("Conversation Items from Root:");
// // Obtain root items and enumerate Conversation.
// Outlook.SimpleItems simpleItems
// = conv.GetRootItems();
// foreach (object item in simpleItems)
// {
// // In this example, enumerate only MailItem type.
// // Other types such as PostItem or MeetingItem
// // can appear in Conversation.
// if (item is Outlook.MailItem)
// {
// Outlook.MailItem mail = item
// as Outlook.MailItem;
// Outlook.Folder inFolder =
// mail.Parent as Outlook.Folder;
// string msg = mail.Subject
// + " in folder " + inFolder.Name;
// Debug.WriteLine(msg);
// }
// // Call EnumerateConversation
// // to access child nodes of root items.
// EnumerateConversation(item, conv);
// }
// }
// }
//}
#endregion
}