private void btnDump_Click(object sender, EventArgs e)
{
this.openFileDialog1.Multiselect = true;
DialogResult msgFileSelectResult = this.openFileDialog1.ShowDialog();
if (msgFileSelectResult == DialogResult.OK)
{
string targetFolder = this.openFileDialog1.FileNames[0];
targetFolder = System.IO.Directory.GetParent(targetFolder).FullName;
foreach (string msgfile in this.openFileDialog1.FileNames)
{
bool attachGenerated = false;
string fileName = null;
using (Stream messageStream = File.Open(msgfile, FileMode.Open, FileAccess.Read))
{
fileName = string.Empty;
OutlookStorage.Message message = new OutlookStorage.Message(messageStream);
messageStream.Close();
try
{
//获取comment#
//Comment has been added as: 34227
string comment = null;
string body = message.BodyText;
comment = body.Substring(body.IndexOf("Comment has been added as:") + 26).Trim();
//Insurer: Aggressive Insurance Texas Elite
string insurer = null;
string state = null;
string title = message.Subject;
if (title.Contains("Reminder Email for debugging purpose"))
{
//CarrierName: Progressive Auto
insurer = ExtractHtml(body, "CarrierName:", "\r\n");
if (string.IsNullOrEmpty(insurer))
{
throw new Exception("Failed to extract CarrierName");
}
insurer = insurer.Trim().Split(' ')[0];
//Quoting State: VT
state = body.Substring(body.IndexOf("Quoting State:") + 14).Trim();
state = state.Substring(0, state.IndexOf("\r\n"));
}
else
{
//insurer = body.Substring(body.IndexOf("Insurer:")+8).Trim();
//insurer = insurer.Substring(0, insurer.IndexOf("\r\n"));
//insurer = insurer.Substring(0, insurer.IndexOf(" "));
//qpquote\stdInsurers\HartfordScrape.vb
insurer = body.Substring(body.LastIndexOf("qpquote\\stdInsurers\\") + 20);
if (insurer.Contains(".vb"))
{
insurer = insurer.Substring(0, insurer.IndexOf(".vb"));
if (insurer.Contains("Scrape"))
{
//insurer = insurer.Replace("Scrape", "");
insurer = insurer.Substring(0, insurer.IndexOf("Scrape"));
}
}
else
{
//Insurer: Progressive Insurance Company
insurer = ExtractHtml(insurer, "Insurer:", "Insurer Web Login:"******"Failed to extract Insurer Company Name");
}
insurer = insurer.Trim().Split(' ')[0];
}
//State Quoted: MA
state = body.Substring(body.IndexOf("State Quoted:") + 13).Trim();
state = state.Substring(0, state.IndexOf("\r\n"));
}
//2017-08-10,iimax:state rule changed
if (state.StartsWith("State"))
{
state = state.Substring(5);
}
fileName = string.Format("#{0}-{1} ({2}).txt", comment, insurer, state);
//附件
if (message.Attachments.Count > 0)
{
OutlookStorage.Attachment file = message.Attachments[0];
string fileContent = System.Text.Encoding.UTF8.GetString(file.Data);
//2016-06-29：修改last name为 testing，修改 effdate
System.Xml.XmlDocument doc = new System.Xml.XmlDocument();
doc.PreserveWhitespace = true;
doc.LoadXml(fileContent);
if (fileContent.Contains("<AutoQuote>"))
{
var CusLastName = doc.DocumentElement.SelectSingleNode("/AutoQuote/Quotation/CusLastName");
if (CusLastName != null)
{
//Create a comment.
XmlComment newComment = doc.CreateComment(CusLastName.OuterXml);
CusLastName.ParentNode.InsertAfter(newComment, CusLastName);
CusLastName.InnerText = "Testing";
}
var EffDate = doc.DocumentElement.SelectSingleNode("/AutoQuote/Quotation/EffDate");
if (EffDate != null)
{
string eff = EffDate.InnerText;
DateTime dt = DateTime.Today;
DateTime.TryParse(eff, out dt);
if (dt < DateTime.Today)
{
XmlComment newComment = doc.CreateComment(EffDate.OuterXml);
EffDate.ParentNode.InsertAfter(newComment, EffDate);
EffDate.InnerText = DateTime.Today.ToString("MM/dd/yyyy");
}
}
var drivers = doc.DocumentElement.SelectNodes("/AutoQuote/Quotation/Drivers/Driver");
if (drivers != null)
{
foreach (XmlNode item in drivers)
{
var LastName = item.SelectSingleNode("LastName");
if (LastName != null)
{
XmlComment newComment = doc.CreateComment(LastName.OuterXml);
LastName.ParentNode.InsertAfter(newComment, LastName);
LastName.InnerText = "Testing";
}
}
}
}
else if (fileContent.Contains("<HomeQuote>"))
{
var CusLastName = doc.DocumentElement.SelectSingleNode("/HomeQuote/InsuredInfo/CusLastName");
if (CusLastName != null)
{
//Create a comment.
XmlComment newComment = doc.CreateComment(CusLastName.OuterXml);
CusLastName.ParentNode.InsertAfter(newComment, CusLastName);
CusLastName.InnerText = "Testing";
}
var hEffDate = doc.DocumentElement.SelectSingleNode("/HomeQuote/InsuredInfo/hEffDate");
if (hEffDate != null)
{
string eff = hEffDate.InnerText;
DateTime dt = DateTime.Today;
if (DateTime.TryParse(eff, out dt))
{
}
if (dt < DateTime.Today)
{
XmlComment newComment = doc.CreateComment(hEffDate.OuterXml);
hEffDate.ParentNode.InsertAfter(newComment, hEffDate);
hEffDate.InnerText = DateTime.Today.ToString("MM/dd/yyyy");
var hExpDate = doc.DocumentElement.SelectSingleNode("/HomeQuote/InsuredInfo/hExpDate");
if (hExpDate != null)
{
XmlComment hExpDateComment = doc.CreateComment(hExpDate.OuterXml);
hExpDate.ParentNode.InsertAfter(hExpDateComment, hExpDate);
hExpDate.InnerText = DateTime.Today.AddYears(1).ToString("MM/dd/yyyy");
}
//修改 RiskInfo
var EffDate = doc.DocumentElement.SelectSingleNode("/HomeQuote/RiskInfo/ThisRisk/EffDate");
var ExpDate = doc.DocumentElement.SelectSingleNode("/HomeQuote/RiskInfo/ThisRisk/ExpDate");
if (EffDate != null)
{
XmlComment xComment = doc.CreateComment(EffDate.OuterXml);
EffDate.ParentNode.InsertAfter(xComment, EffDate);
EffDate.InnerText = DateTime.Today.ToString("MM/dd/yyyy");
}
if (ExpDate != null)
{
XmlComment xComment = doc.CreateComment(ExpDate.OuterXml);
ExpDate.ParentNode.InsertAfter(xComment, ExpDate);
ExpDate.InnerText = DateTime.Today.AddYears(1).ToString("MM/dd/yyyy");
}
}
}
}
fileContent = doc.OuterXml;
System.IO.File.WriteAllText(Path.Combine(targetFolder, fileName), fileContent);
}
attachGenerated = true;
//MessageBox.Show(fileName);
}
catch (Exception)
{
throw;
}
finally
{
message.Dispose();
}
if (attachGenerated)
{
//重命名msg
FileInfo fi = new FileInfo(msgfile);
//目标文件名
string msgfileName = fi.Name;
string ourfileName = fi.Name.Replace(".msg", string.Format("{0}.msg", fileName));
ourfileName = ourfileName.Replace("comment#", "#").Replace(".txt.", ".");
System.IO.File.Move(msgfile, Path.Combine(fi.DirectoryName, ourfileName));
}
}
}
}
}
void ddItem_Click(object sender, EventArgs e)
{
ToolStripMenuItem ddItem = sender as ToolStripMenuItem;
if (ddItem == null)
{
return;
}
string btnName = ddItem.Name;
int idx = ddItem.Name.IndexOf("btnFile");
if (idx == -1)
{
lblStatus.Text = "Error";
return;
}
string AttachIndex = ddItem.Name.Substring(idx + 7);
int? index = ToInt(AttachIndex);
if (index.HasValue && MessageFile != null)
{
int attachmentNum = Attachments[index.Value];
try
{
using (Stream messageStream = File.Open(MessageFile, FileMode.Open, FileAccess.Read))
{
//fileName = string.Empty;
OutlookStorage.Message message = null;
try
{
message = new OutlookStorage.Message(messageStream);
//messageStream.Close();
int i = 0;
OutlookStorage.Attachment attachment = null;
foreach (OutlookStorage.Attachment attachment_ in message.Attachments)
{
if (i == attachmentNum)
{
attachment = attachment_;
break;
}
}
if (attachment == null)
{
MessageBox.Show("Something has gone terribly wrong in opening this attachment (can't find it attached anymore)");
return;
}
string filename = String.Format("{0}{1}{2}", TempPath, Path.DirectorySeparatorChar, attachment.Filename);
using (FileStream f = new FileStream(filename, FileMode.OpenOrCreate, FileAccess.Write))
{
Task t = f.WriteAsync(attachment.Data, 0, attachment.Data.Length);
t.ContinueWith((prevTask) =>
{
System.Diagnostics.Process.Start(filename);
});
}
}
finally
{
if (message != null)
{
message.Dispose();
}
}
}
}catch (IOException ex)
{
Console.WriteLine("ex", ex.Message);
}
}
else
{
lblStatus.Text = "Error";
}
}
