public void GetDataFromAccessDb()
{
string sql = @"SELECT * FROM T_EmailInfo";
DataSet ds = _accessDBConnection.GetDataFromDb(sql);
var dt = ds.Tables[0];
foreach (DataRow dtRow in dt.Rows)
{
string to = dtRow["To"].ToString();
string cc = dtRow["CC"].ToString();
string subject = dtRow["Subject"].ToString();
string body = dtRow["Body"].ToString();
insertIntoExcel(to, cc, subject, body);
}
_accessDBConnection.CloseDbConnection();
}
public void readEmailByFolderAndSaveToDb()
{
Outlook.Application application = new Outlook.Application();
Outlook.NameSpace ns = application.GetNamespace("mapi");
mainbox = ns.GetDefaultFolder(Outlook.OlDefaultFolders.olFolderInbox);
Outlook.MAPIFolder targetFolder = mainbox.Folders[ConfigureHelper.GetAppSettingsKeyValue(Constants.FolderA)];
Outlook.MAPIFolder processFolder = mainbox.Folders[ConfigureHelper.GetAppSettingsKeyValue(Constants.ProcessFolder)];
int loopTime = targetFolder.Items.Count;
for (int i = 0; i < loopTime; i++)
{
item = targetFolder.Items.GetFirst();
SaveEmailInfo(item);
targetFolder.Items.GetFirst().Move(processFolder);
}
_accessDBConnection.CloseDbConnection();
}