public string ProcessData()
{
string strLog = "";
try
{
OpreateData opftp = new OpreateData();
string strLogs = opftp.GetDataFromServer(ref connectionSuccess);//, ref index);
HtmlAgilityPack.HtmlDocument htmlDoc = new HtmlAgilityPack.HtmlDocument();
XmlDocument xmlDoc = new XmlDocument();
foreach (string file in Directory.EnumerateFiles(System.Configuration.ConfigurationSettings.AppSettings["MailPath"], "*.htm"))
{
filename = Path.GetFileName(file);
XmlNode rootElement = xmlDoc.CreateElement("Root");
xmlDoc.AppendChild(rootElement);
htmlDoc.Load(file);
htmlDoc.OptionWriteEmptyNodes = true;
htmlDoc.OptionOutputAsXml = true;
string value = "";
HtmlNodeCollection nodesitemheading = htmlDoc.DocumentNode.SelectNodes(".//td[@class='content']");
XmlElement FileNameElement = xmlDoc.CreateElement("FileName");
FileNameElement.InnerText = Path.GetFileName(file);
rootElement.AppendChild(FileNameElement);
string strfile = file.Replace("htm", "txt");
string[] lines = File.ReadAllLines(strfile);
string From = lines[0].ToString().Replace("From:", "");
XmlElement FromElement = xmlDoc.CreateElement("From");
FromElement.InnerText = From;
rootElement.AppendChild(FromElement);
string SentDate = lines[1].ToString().Replace("SentDate:", "");
XmlElement SentDateElement = xmlDoc.CreateElement("SentDate");
SentDateElement.InnerText = SentDate;
rootElement.AppendChild(SentDateElement);
string Subject = lines[2].ToString().Replace("Subject:", "");
XmlElement SubjectElement = xmlDoc.CreateElement("Subject");
SubjectElement.InnerText = Subject;
rootElement.AppendChild(SubjectElement);
foreach (HtmlNode childNode in nodesitemheading)
{
if (childNode.ChildNodes.Count > 0)
{
foreach (HtmlNode childOfChildNode in childNode.ChildNodes)
{
if (childOfChildNode.Name == "#text")
{
if (childOfChildNode.ChildNodes.Count > 0)
{
foreach (HtmlNode childOfChildofChildNode in childOfChildNode.ChildNodes)
{
if (childOfChildofChildNode.InnerText != "" && childOfChildofChildNode.InnerText != " " && childOfChildofChildNode.InnerText != "\r\n ")
{
if (childOfChildofChildNode.InnerText.Trim().Contains("This is an order"))
{
XmlElement Element = xmlDoc.CreateElement("PrimaryContact");
String[] SplitValue = Splits(sep(childOfChildofChildNode.InnerText, "from "), new char[] { ' ' });
string str1 = SplitValue[0] + " " + SplitValue[1];//primary contact
string str2 = SplitValue[3] + " " + SplitValue[4] + " " + SplitValue[5];//company name
str2 = str2.Replace("Relating", "");
string str3 = SplitValue[7] + " " + SplitValue[8] + " " + SplitValue[9] + " " + SplitValue[10] + SplitValue[11];//email body subject
XmlElement PrimaryContactElement = xmlDoc.CreateElement("PrimaryContact");
PrimaryContactElement.InnerText = str1;
rootElement.AppendChild(PrimaryContactElement);
XmlElement CompanyNameElement = xmlDoc.CreateElement("CompanyName");
CompanyNameElement.InnerText = str2;
rootElement.AppendChild(CompanyNameElement);
XmlElement EmailBodySubjectElement = xmlDoc.CreateElement("EmailBodySubject");
EmailBodySubjectElement.InnerText = str3;
rootElement.AppendChild(EmailBodySubjectElement);
XmlElement PropertyNameElement = xmlDoc.CreateElement("PropertyName");
str3 = str3.Replace("campaign:", "");
PropertyNameElement.InnerText = str3;
rootElement.AppendChild(PropertyNameElement);
//MessageBox.Show(str1 + ' ' + str2);
}
if (childOfChildofChildNode.InnerText.Trim().Contains("Property ID"))
{
//MessageBox.Show(childOfChildofChildNode.InnerText.Trim().Replace("Property ID:", ""));//Property Id
XmlElement PropertyIdElement = xmlDoc.CreateElement("PropertyId");
PropertyIdElement.InnerText = childOfChildofChildNode.InnerText.Trim().Replace("Property ID:", "");
rootElement.AppendChild(PropertyIdElement);
}
if (childOfChildofChildNode.InnerText.Trim().Contains("OrderItem"))
{
// MessageBox.Show(childOfChildofChildNode.InnerText.Trim().Replace("OrderItem:", ""));
String[] SplitValue = Splits(childOfChildofChildNode.InnerText.Trim().Replace("OrderItem:", ""), new char[] { ',' });//Order Item Id
SplitValueOrderItemId = Splits(childOfChildofChildNode.InnerText.Trim().Replace("OrderItem:", ""), new char[] { ',' });
XmlElement OrderItemIdElement = xmlDoc.CreateElement("OrderItemId");
for (int i = 0; i < SplitValue.Length; i++)
{
string str = SplitValue[i];
XmlElement IdElement = xmlDoc.CreateElement("Id");
IdElement.InnerText = str;
OrderItemIdElement.AppendChild(IdElement);
}
rootElement.AppendChild(OrderItemIdElement);
}
if (childOfChildofChildNode.InnerText.Trim().Contains("Sales contacts"))
{
// MessageBox.Show(childOfChildofChildNode.InnerText.Trim().Replace("Sales contacts:", ""), "8");
String[] SplitValue = Splits(childOfChildofChildNode.InnerText.Trim().Replace("Sales contacts:", ""), new char[] { ',' });
for (int i = 0; i < SplitValue.Length; i++)
{
string str = (SplitValue[i].Replace(" on", ","));
String[] strValue = Splits(str, new char[] { ',' });
string str1 = strValue[0];//Sales contact name
string str2 = strValue[1].Replace("or", "");//Sales contact phone number
XmlElement SalesContactElement = xmlDoc.CreateElement("SalesContact");
SalesContactElement.InnerText = str1;
rootElement.AppendChild(SalesContactElement);
XmlElement SalesContactNumberElement = xmlDoc.CreateElement("SalesContactNumber");
SalesContactNumberElement.InnerText = str2;
rootElement.AppendChild(SalesContactNumberElement);
}
HtmlNodeCollection adminemail = htmlDoc.DocumentNode.SelectNodes(".//a[@href]");
string stradmin = adminemail[1].InnerText;//Admin email address
XmlElement AdminContactEmailElement = xmlDoc.CreateElement("AdminContactEmail");
AdminContactEmailElement.InnerText = stradmin;
rootElement.AppendChild(AdminContactEmailElement);
}
if (childOfChildofChildNode.InnerText.Trim().Contains("Admin contact"))
{
// MessageBox.Show(childOfChildofChildNode.InnerText.Trim(), "9");
String[] SplitValue = Splits(childOfChildofChildNode.InnerText.Trim().Replace("Admin contact:", "").Replace(" on", ","), new char[] { ',' });
string str1 = SplitValue[0];//Admin contact name
string str2 = SplitValue[1].Replace("or", "");//Admin contact phone number
XmlElement AdminContactElement = xmlDoc.CreateElement("AdminContact");
AdminContactElement.InnerText = str1;
rootElement.AppendChild(AdminContactElement);
XmlElement AdminContactNumberElement = xmlDoc.CreateElement("AdminContactNumber");
AdminContactNumberElement.InnerText = str2;
rootElement.AppendChild(AdminContactNumberElement);
}
if (childOfChildofChildNode.InnerText.Trim().Contains("Supplier:"))
{
//MessageBox.Show(childOfChildofChildNode.InnerText.Trim(), "10");
string str1 = childOfChildofChildNode.InnerText.Replace("Supplier:", "");//Product
XmlElement SupplierElement = xmlDoc.CreateElement("Supplier");
SupplierElement.InnerText = str1;
rootElement.AppendChild(SupplierElement);
}
if (childOfChildofChildNode.InnerText.Trim().Contains("Description of product/service being ordered:"))
{
value = "Description of product";
continue;
}
if (value == "Description of product")
{
//MessageBox.Show(childOfChildofChildNode.InnerText.Trim(), "11");
string str = childOfChildofChildNode.InnerText.Replace("Description of product/service being ordered: ", "");//Product Description
value = "";
XmlElement DescriptionElement = xmlDoc.CreateElement("Description");
DescriptionElement.InnerText = str;
rootElement.AppendChild(DescriptionElement);
}
if (childOfChildofChildNode.InnerText.Trim().Contains("Required"))
{
// MessageBox.Show(childOfChildofChildNode.InnerText.Trim(), "12");
string str = childOfChildofChildNode.InnerText.Replace("Required on", "");//Required Date
XmlElement RequiredDateElement = xmlDoc.CreateElement("RequiredDate");
RequiredDateElement.InnerText = str;
rootElement.AppendChild(RequiredDateElement);
}
if (value == "PROPERTY")
{
// MessageBox.Show(childOfChildofChildNode.InnerText, "2");//Property Comments
XmlElement PropertyDetailsElement = xmlDoc.CreateElement("PropertyDetails");
PropertyDetailsElement.InnerText = childOfChildofChildNode.InnerText;
rootElement.AppendChild(PropertyDetailsElement);
HtmlNodeCollection propertycomments = htmlDoc.DocumentNode.SelectNodes(".//i");
string str = propertycomments[1].InnerText;//Property Comments
value = "";
XmlElement PropertyCommentsElement = xmlDoc.CreateElement("PropertyComments");
PropertyCommentsElement.InnerText = str;
rootElement.AppendChild(PropertyCommentsElement);
}
if (childOfChildofChildNode.InnerText.Trim() == "PROPERTY")
{
value = "PROPERTY";
continue;
}
}
}
}
}
}
}
}
HtmlNodeCollection Nds = htmlDoc.DocumentNode.SelectNodes(".//table[@class='MsoNormalTable']");
int cnt = 1;
foreach (HtmlNode childNds in Nds)
{
if (childNds.ChildNodes.Count > 0)
{
if (childNds.InnerText.Contains("This is an order"))
{
continue;
}
else
{
if (childNds.ChildNodes.Count > 0)
{
foreach (HtmlNode childofChildNds in childNds.ChildNodes)
{
XmlElement OrderItemDetailsElement = xmlDoc.CreateElement("OrderItemDetails");
if (childofChildNds.InnerText.Trim() != "" && childofChildNds.InnerText.Trim() != "Client PriceCost Price" && childofChildNds.InnerText.Trim() != "campaigntrack.com.auhelpdesk")
{
string str = childofChildNds.InnerText;
str = str.Replace("$", "|");
String[] SplitValue = Splits(str, new char[] { '|' });
string str1 = SplitValue[0].ToString().Trim();
string str2 = SplitValue[1].ToString().Trim();
string str3 = SplitValue[2].ToString().Trim();
//MessageBox.Show(str1 + ' ' + str2 + ' ' + str3);
//for (int i = 1; i < SplitValue.Length; i++)
//{
// if (i != 4 && i != 10 && i != 16) { continue; }
// if (str1 == " " || str2 == " " || str3 == " ") { continue; }
// string str = SplitValue[i];
// XmlElement IdElement = xmlDoc.CreateElement("n");
// //cnt = cnt + 1;
// IdElement.InnerText = cnt.ToString() + "_" + str1 + "|" + str2 + "|" + str3;
// OrderItemDetailsElement.AppendChild(IdElement);
//}
if (str1 != "" || str2 != "" || str3 != "")
{
XmlElement IdElement = xmlDoc.CreateElement("n");
IdElement.InnerText = cnt.ToString() + "_" + str1 + "|" + str2 + "|" + str3;
OrderItemDetailsElement.AppendChild(IdElement);
rootElement.AppendChild(OrderItemDetailsElement);
}
}
}
{ cnt = cnt + 1; }
}
}
}
}
string strd = xmlDoc.InnerXml.ToString();
strd = strd.Replace("&", "and").Replace("andamp;", " and ");
ExecuteProcess(strd);
xmlDoc.RemoveAll();
System.IO.File.Move(System.Configuration.ConfigurationSettings.AppSettings["MailPath"] + "\\" + filename, System.Configuration.ConfigurationSettings.AppSettings["MailPath"] + "\\Archive\\" + filename);
filename = filename.Replace("htm", "txt");
System.IO.File.Move(System.Configuration.ConfigurationSettings.AppSettings["MailPath"] + "\\" + filename, System.Configuration.ConfigurationSettings.AppSettings["MailPath"] + "\\Archive\\" + filename);
// s.A1CreateEvent("*****@*****.**", "abc", "03-12-2013", "04-12-2013", "Test", "def", "ghi");
}
DataSet dsRecordtoProcess = new DataSet();
DataTable dtRecordtoProcess = new DataTable();
dsRecordtoProcess = ReturnDataforCalenderEntry();
dtRecordtoProcess = dsRecordtoProcess.Tables[0];
GoogleCalSvc s = new GoogleCalSvc();
if (dtRecordtoProcess.Rows.Count > 0)
{
for (int i = 0; i < dtRecordtoProcess.Rows.Count; i++)
{
s.userName = dtRecordtoProcess.Rows[i]["UserName"].ToString();
s.userPassword = dtRecordtoProcess.Rows[i]["Password"].ToString();
s.CreateEvent(dtRecordtoProcess.Rows[i]["Name"].ToString(), dtRecordtoProcess.Rows[i]["Startdate"].ToString(), dtRecordtoProcess.Rows[i]["EndDate"].ToString());
// s.A1CreateEvent("*****@*****.**", "abc", "05-12-2013", "06-12-2013", "Test", "def", "ghi");
}
}
}
catch (Exception ex)
{
strLog = ex.Message;
WriteLog(strLog);
}
return strLog;
}
public string ProcessData()
{
string strLog = "";
XmlDocument xmlDoc = new XmlDocument();
IOAuthSession session;
DateTime DueDate = DateTime.Now;
string strd;
string Subject;
try
{
session = XeroAPI();
Repository repository = new Repository(session);
OpreateData opftp = new OpreateData();
string strLogs = opftp.GetDataFromServer(ref connectionSuccess);//, ref index);
HtmlAgilityPack.HtmlDocument htmlDoc = new HtmlAgilityPack.HtmlDocument();
DataSet dsProductNotification = new DataSet();
Email.Email eml = new Email.Email();
String[] OrderId = null;
foreach (string file in Directory.EnumerateFiles(FullPath, "*.htm"))
{
filename = Path.GetFileName(file);
// filename = "201404161759591372889.htm";
htmlDoc.Load(file);
StartBrowser(htmlDoc.DocumentNode.OuterHtml);
}
// }
foreach (string file in Directory.EnumerateFiles(FullPath, "*.htm"))
{
filename = Path.GetFileName(file);
// filename = "201404161759591372889.htm";
XmlNode rootElement = xmlDoc.CreateElement("Root");
xmlDoc.AppendChild(rootElement);
htmlDoc.Load(file);
htmlDoc.OptionWriteEmptyNodes = true;
htmlDoc.OptionOutputAsXml = true;
string value = "";
HtmlNodeCollection nodesitemheading = htmlDoc.DocumentNode.SelectNodes(".//b");
/*This is an order notification from Robin Parker at Marshall White Brighton<br />
<i>Relating to
campaign: 11 Lagnicourt Street, Hampton</i> */
String[] SplitValues = new String[1000];
XmlElement Element = xmlDoc.CreateElement("PrimaryContact");
try
{
SplitValues = Splits(sep(nodesitemheading[0].InnerText, "from "), new char[] { ' ' });
}
catch
{
File.Move(file, System.Configuration.ConfigurationSettings.AppSettings["Error"] + "\\" + filename);
File.Move(file.Replace("htm", "txt"), System.Configuration.ConfigurationSettings.AppSettings["Error"] + "\\" + filename.Replace("htm", "txt"));
xmlDoc.RemoveAll();
continue;
};
string cncl1 = "", cncl2 = "", cncl3 = "";
if (nodesitemheading[0].InnerText.Contains("The order listed below was cancelled by"))
{
IList<string> arrayAsList = (IList<string>)SplitValues;
int index;
index = arrayAsList.IndexOf("campaign:");
if (index == -1)
index = arrayAsList.IndexOf("\r\ncampaign:");
for (int i = index + 1; i < SplitValues.Length; i++)
{
if (SplitValues[i].Contains("of")) { break; };
cncl1 = cncl1 + " " + SplitValues[i];//email body subject
cncl1 = cncl1.Replace("Description", "").Replace("\r\n", "");
}
IList<string> arrayAsList1 = (IList<string>)SplitValues;
int index1 = arrayAsList.IndexOf("being");
for (int i = index1 + 2; i < SplitValues.Length; i++)
{
if (SplitValues[i].Contains("on")) { break; };
cncl2 = cncl2 + " " + SplitValues[i];//email body subject
cncl2 = cncl2.Replace("Required", "").Replace("\r\n", "");
}
IList<string> arrayAsList2 = (IList<string>)SplitValues;
int index2 = arrayAsList.IndexOf("on");
cncl3 = SplitValues[index2 + 1].Replace("Product", "");
InsertCancelledOrders(cncl1, cncl2, cncl3, filename);
File.Move(file, System.Configuration.ConfigurationSettings.AppSettings["Cancelled"] + "\\" + filename);
File.Move(file.Replace("htm", "txt"), System.Configuration.ConfigurationSettings.AppSettings["Cancelled"] + "\\" + filename.Replace("htm", "txt"));
xmlDoc.RemoveAll();
continue;
}
string str11 = "", str22 = "", str33 = "";
try
{
str11 = SplitValues[0] + " " + SplitValues[1];//primary contact
str22 = SplitValues[3] + " " + SplitValues[4] + " " + SplitValues[5];//company name
str22 = str22.Replace("Relating", "");
//if (SplitValues[7].Contains("to"))
//{
// str33 = "";
// for (int i = 8; i < SplitValues.Length; i++)
// {
// str33 = str33 + " " + SplitValues[i];//email body subject
// }
//}
//else
// str33 = SplitValues[7] + " " + SplitValues[8] + " " + SplitValues[9] + " " + SplitValues[10] + SplitValues[11];//email body subject
IList<string> arrayAsList = (IList<string>)SplitValues;
int index;
index = arrayAsList.IndexOf("Relating".Replace("\r\n", ""));
if (index == -1)
index = arrayAsList.IndexOf("\r\ncampaign:");//campaign:
if (index == -1)
index = arrayAsList.IndexOf("campaign:");//campaign:
for (int i = index + 1; i < SplitValues.Length; i++)
{
if (SplitValues[i].Contains("of")) { break; };
str33 = str33 + " " + SplitValues[i];//email body subject
str33 = str33.Replace("Description", "").Replace("\r\n", "");
}
//if (SplitValues[7].Contains("Relating"))
//{
// str33 = "";
// for (int i = 10; i < SplitValues.Length; i++)
// {
// str33 = str33 + " " + SplitValues[i];//email body subject
// }
//}
}
catch
{
File.Move(file, System.Configuration.ConfigurationSettings.AppSettings["Error"] + "\\" + filename);
File.Move(file.Replace("htm", "txt"), System.Configuration.ConfigurationSettings.AppSettings["Error"] + "\\" + filename.Replace("htm", "txt"));
xmlDoc.RemoveAll();
continue;
};
XmlElement PrimaryContactElement = xmlDoc.CreateElement("PrimaryContact");
PrimaryContactElement.InnerText = str11;
rootElement.AppendChild(PrimaryContactElement);
XmlElement CompanyNameElement = xmlDoc.CreateElement("CompanyName");
CompanyNameElement.InnerText = str22;
rootElement.AppendChild(CompanyNameElement);
XmlElement EmailBodySubjectElement = xmlDoc.CreateElement("EmailBodySubject");
EmailBodySubjectElement.InnerText = nodesitemheading[0].InnerText;
rootElement.AppendChild(EmailBodySubjectElement);
XmlElement PropertyNameElement = xmlDoc.CreateElement("PropertyName");
str33 = str33.Replace("campaign:", "");
PropertyNameElement.InnerText = str33;
rootElement.AppendChild(PropertyNameElement);
XmlElement FileNameElement = xmlDoc.CreateElement("FileName");
FileNameElement.InnerText = Path.GetFileName(file);
rootElement.AppendChild(FileNameElement);
string strfile = file.Replace("htm", "txt");
string[] lines = File.ReadAllLines(strfile);
string From = lines[0].ToString().Replace("From:", "");
XmlElement FromElement = xmlDoc.CreateElement("From");
FromElement.InnerText = From;
rootElement.AppendChild(FromElement);
string SentDate = lines[1].ToString().Replace("SentDate:", "");
XmlElement SentDateElement = xmlDoc.CreateElement("SentDate");
//DateTime objSentDate = Convert.ToDateTime(SentDate,CultureInfo.CreateSpecificCulture("en-US"));
DateTime objSentDate = DateTime.Parse(SentDate, CultureInfo.GetCultureInfo("en-gb"));
// SentDateElement.InnerText = objSentDate.Month.ToString().PadLeft(2, '0') + "/" + objSentDate.Day.ToString().PadLeft(2, '0') + "/" + objSentDate.Year + " " + objSentDate.ToLongTimeString();
rootElement.AppendChild(SentDateElement);
Subject = lines[2].ToString().Replace("Subject:", "");
XmlElement SubjectElement = xmlDoc.CreateElement("Subject");
SubjectElement.InnerText = Subject;
rootElement.AppendChild(SubjectElement);
HtmlNodeCollection nodesitemcontacts = htmlDoc.DocumentNode.SelectNodes(".//td[@class='content']");
//htmlDoc.DocumentNode.SelectNodes(".//td[@class='content']")[0].ChildNodes
foreach (HtmlNode childNode in nodesitemcontacts)
{
if (childNode.ChildNodes.Count > 0)
{
foreach (HtmlNode childOfChildNode in childNode.ChildNodes)
{
if (childOfChildNode.Name == "#text")
{
if (childOfChildNode.ChildNodes.Count == 0)
{
if (childOfChildNode.InnerText.Trim().Contains("Property ID") || childOfChildNode.InnerText.Trim().Contains("Property"))
{
//MessageBox.Show(childOfChildofChildNode.InnerText.Trim().Replace("Property ID:", ""));//Property Id
XmlElement PropertyIdElement = xmlDoc.CreateElement("PropertyId");
PropertyIdElement.InnerText = childOfChildNode.InnerText.Trim().Replace("Property ID:", "").Replace("\r\n", "").Replace("Property ID:", "");
rootElement.AppendChild(PropertyIdElement);
}
if (childOfChildNode.InnerText.Trim().Contains("OrderItem"))
{
// MessageBox.Show(childOfChildofChildNode.InnerText.Trim().Replace("OrderItem:", ""));
String[] SplitValue = Splits(childOfChildNode.InnerText.Trim().Replace("OrderItem:", ""), new char[] { ',' });//Order Item Id
OrderId = SplitValue;
SplitValueOrderItemId = Splits(childOfChildNode.InnerText.Trim().Replace("OrderItem:", ""), new char[] { ',' });
XmlElement OrderItemIdElement = xmlDoc.CreateElement("OrderItemId");
for (int i = 0; i < SplitValue.Length; i++)
{
string str = SplitValue[i];
XmlElement IdElement = xmlDoc.CreateElement("Id");
IdElement.InnerText = str.Trim();
OrderItemIdElement.AppendChild(IdElement);
}
rootElement.AppendChild(OrderItemIdElement);
}
if (childOfChildNode.InnerText.Trim().Contains("Sales contacts"))
{
// MessageBox.Show(childOfChildofChildNode.InnerText.Trim().Replace("Sales contacts:", ""), "8");
String[] SplitValue = Splits(childOfChildNode.InnerText.Trim().Replace("Sales contacts:", ""), new char[] { ',' });
for (int i = 0; i < SplitValue.Length; i++)
{
string str = (SplitValue[i].Replace(" on ", ",").Replace("\r\non", ","));
String[] strValue = Splits(str, new char[] { ',' });
string str1 = strValue[0];//Sales contact name
string str2 = strValue[1].Replace("or", "");//Sales contact phone number
XmlElement SalesContactElement = xmlDoc.CreateElement("SalesContact");
SalesContactElement.InnerText = str1.Trim(); ;
rootElement.AppendChild(SalesContactElement);
XmlElement SalesContactNumberElement = xmlDoc.CreateElement("SalesContactNumber");
SalesContactNumberElement.InnerText = str2.Trim();
rootElement.AppendChild(SalesContactNumberElement);
}
HtmlNodeCollection adminemail = htmlDoc.DocumentNode.SelectNodes(".//a[@href]");
string stradmin = adminemail[1].InnerText;//Admin email address
}
if (childOfChildNode.InnerText.Trim().Contains("Admin contact"))
{
// MessageBox.Show(childOfChildofChildNode.InnerText.Trim(), "9");
// String[] SplitValue = Splits(childOfChildNode.InnerText.Trim().Replace("Admin contact:", "").Replace(" on", ","), new char[] { ',' });
String[] SplitValue = Splits(childOfChildNode.InnerText.Trim().Replace("Admin contact:", "").Replace(" on", ","), "or".ToCharArray());
string admindetails = childOfChildNode.InnerText.Trim().Replace("Admin contact:", "");//Admin contact name
string str1;
try
{
// bool string1Matched = Regex.IsMatch(string1, @"\bthe\b", RegexOptions.IgnoreCase);
str1 = admindetails.Substring(0, admindetails.IndexOf(" or "));
str1 = str1.Substring(0, str1.IndexOf(" on "));//Admin name
string str2;
str2 = admindetails.Substring(0, admindetails.IndexOf(" or "));
str2 = str2.Substring(str2.LastIndexOf(" on ") + 3);//Admin Phone
string str3 = "";
str3 = admindetails.Substring(admindetails.IndexOf(" or ") + 4);
XmlElement AdminContactElement = xmlDoc.CreateElement("AdminContact");
AdminContactElement.InnerText = str1.Trim();
rootElement.AppendChild(AdminContactElement);
XmlElement AdminContactNumberElement = xmlDoc.CreateElement("AdminContactNumber");
AdminContactNumberElement.InnerText = str2.Trim();
rootElement.AppendChild(AdminContactNumberElement);
XmlElement AdminContactEmailElement = xmlDoc.CreateElement("AdminContactEmail");
AdminContactEmailElement.InnerText = str3.Trim();
rootElement.AppendChild(AdminContactEmailElement);
}
catch (Exception ex)
{
strLog = ex.StackTrace.ToString();
WriteLog(strLog + " " + filename);
}
}
if (childOfChildNode.InnerText.Trim().Contains("Supplier:"))
{
//MessageBox.Show(childOfChildofChildNode.InnerText.Trim(), "10");
string str1 = childOfChildNode.InnerText.Replace("Supplier:", "");//Product
XmlElement SupplierElement = xmlDoc.CreateElement("Supplier");
SupplierElement.InnerText = str1.Trim();
rootElement.AppendChild(SupplierElement);
}
if (childOfChildNode.InnerText.Trim().Contains("Description of product/service being ordered:"))
{
value = "Description of product";
continue;
}
if (value == "Description of product")
{
//MessageBox.Show(childOfChildofChildNode.InnerText.Trim(), "11");
string str = childOfChildNode.InnerText.Replace("Description of product/service being ordered: ", "");//Product Description
value = "";
XmlElement DescriptionElement = xmlDoc.CreateElement("Description");
DescriptionElement.InnerText = str.Trim();
rootElement.AppendChild(DescriptionElement);
}
if (childOfChildNode.InnerText.Trim().Contains("Required"))
{
// MessageBox.Show(childOfChildofChildNode.InnerText.Trim(), "12");
string RequiredDate = childOfChildNode.InnerText.Replace("Required on", "").Replace("Required \r\non", "").Replace("\r\n", "");//Required Date
DateTime objRequiredDate = DateTime.Parse(RequiredDate, CultureInfo.GetCultureInfo("en-gb"));
XmlElement RequiredDateElement = xmlDoc.CreateElement("RequiredDate");
//RequiredDateElement.InnerText = objRequiredDate.Mo.ToString().PadLeft(2, '0') + "/" + objRequiredDate.Month.ToString().PadLeft(2, '0') + "/" + objRequiredDate.Year;
RequiredDateElement.InnerText = objRequiredDate.ToString();
rootElement.AppendChild(RequiredDateElement);
DueDate = Convert.ToDateTime(RequiredDateElement.InnerText);
}
if (value == "PROPERTY")
{
// MessageBox.Show(childOfChildofChildNode.InnerText, "2");//Property Comments
XmlElement PropertyDetailsElement = xmlDoc.CreateElement("PropertyDetails");
PropertyDetailsElement.InnerText = childOfChildNode.InnerText;
rootElement.AppendChild(PropertyDetailsElement);
HtmlNodeCollection propertycomments = htmlDoc.DocumentNode.SelectNodes(".//i");
string str = propertycomments[1].InnerText;//Property Comments
value = "";
XmlElement PropertyCommentsElement = xmlDoc.CreateElement("PropertyComments");
PropertyCommentsElement.InnerText = str.Trim();
rootElement.AppendChild(PropertyCommentsElement);
}
if (childOfChildNode.InnerText.Trim() == "PROPERTY")
{
value = "PROPERTY";
continue;
}
//}
// }
}
}
}
}
}
HtmlNodeCollection Nds = htmlDoc.DocumentNode.SelectNodes(".//table[@cellpadding='3']");
int cnt = 1;
if (Nds == null)
{
if (Subject.Contains("cancellation"))
{
File.Move(file, System.Configuration.ConfigurationSettings.AppSettings["Cancelled"] + "\\" + filename);
File.Move(file.Replace("htm", "txt"), System.Configuration.ConfigurationSettings.AppSettings["Cancelled"] + "\\" + filename.Replace("htm", "txt"));
}
};
if (Nds != null)
{
foreach (HtmlNode childNds in Nds)
{
if (childNds.ChildNodes.Count > 0)
{
if (childNds.InnerText.Contains("This is an order"))
{
continue;
}
else
{
if (childNds.ChildNodes.Count > 0)
{
foreach (HtmlNode childofChildNds in childNds.ChildNodes)
{
XmlElement OrderItemDetailsElement = xmlDoc.CreateElement("OrderItemDetails");
if (childofChildNds.InnerText.Trim() != "" && childofChildNds.InnerText.Contains("Client PriceCost") == false && childofChildNds.InnerText.Contains("Client \r\nPriceCost") == false && childofChildNds.InnerText.Trim() != "campaigntrack.com.auhelpdesk")
{
string str = childofChildNds.InnerText;
str = str.Replace("$", "|");
String[] SplitValue = Splits(str, new char[] { '|' });
string str1 = SplitValue[0].ToString().Trim();
string str2 = SplitValue[1].ToString().Trim();
string str3 = SplitValue[2].ToString().Trim();
//MessageBox.Show(str1 + ' ' + str2 + ' ' + str3);
//for (int i = 1; i < SplitValue.Length; i++)
//{
// if (i != 4 && i != 10 && i != 16) { continue; }
// if (str1 == " " || str2 == " " || str3 == " ") { continue; }
// string str = SplitValue[i];
// XmlElement IdElement = xmlDoc.CreateElement("n");
// //cnt = cnt + 1;
// IdElement.InnerText = cnt.ToString() + "_" + str1 + "|" + str2 + "|" + str3;
// OrderItemDetailsElement.AppendChild(IdElement);
//}
if (str1 != "" || str2 != "" || str3 != "")
{
XmlElement IdElement = xmlDoc.CreateElement("n");
IdElement.InnerText = cnt.ToString() + "_" + str1 + "|" + str2 + "|" + str3;
OrderItemDetailsElement.AppendChild(IdElement);
rootElement.AppendChild(OrderItemDetailsElement);
}
//dsProductNotification = ProductEmailNotification(str1);
//if (dsProductNotification.Tables[0].Rows.Count > 0)
//{
// //(String subject,String Message,string To,string CC, bool hasattachment)
// // eml.SendMail("", "", dsProductNotification.Tables[0].Rows[0]["EmailTo"].ToString(), dsProductNotification.Tables[0].Rows[0]["EmailCC"].ToString(), false);
//}
}
}
{ cnt = cnt + 1; }
}
}
}
}
}
strd = xmlDoc.InnerXml.ToString();
strd = strd.Replace("&", "and").Replace("andamp;", " and ");
strd = strd.Replace("'", "''");
DataSet ds = new DataSet();
ds = ExecuteProcess(strd,htmlDoc.DocumentNode.OuterHtml);
xmlDoc.RemoveAll();
for (int j = 0; j < ds.Tables[1].Rows.Count; j++)
{
dsProductNotification = ProductSchedule((int)ds.Tables[1].Rows[j]["Xero_Id"]);
if (dsProductNotification.Tables[0].Rows.Count > 0)
{
//(String subject,String Message,string To,string CC, bool hasattachment)
// eml.SendMail("", "", dsProductNotification.Tables[0].Rows[0]["EmailTo"].ToString(), dsProductNotification.Tables[0].Rows[0]["EmailCC"].ToString(), false);
if (dsProductNotification.Tables[0].Rows[dsProductNotification.Tables[0].Rows.Count - 1]["Value"].ToString().Contains("@"))
{
// eml.SendMail(Subject, htmlDoc.DocumentNode.OuterHtml, dsProductNotification.Tables[0].Rows[0]["EmailTo"].ToString(), "", false);
eml.SendMail(Subject, htmlDoc.DocumentNode.OuterHtml, "*****@*****.**", "", false);
}
else
{
DataSet dsRecordtoProcess = new DataSet();
DataTable dtRecordtoProcess = new DataTable();
dsRecordtoProcess = ReturnDataforCalenderEntry(ds.Tables[1].Rows[j]["OrderId"].ToString());
dtRecordtoProcess = dsRecordtoProcess.Tables[0];
GoogleCalSvc s = new GoogleCalSvc();
if (dtRecordtoProcess.Rows.Count > 0)
{
for (int i = 0; i < dtRecordtoProcess.Rows.Count; i++)
{
s.CreateEvent(dtRecordtoProcess.Rows[i]["Title"].ToString(), dtRecordtoProcess.Rows[i]["Location"].ToString(), dtRecordtoProcess.Rows[i]["SalesContact"].ToString(), dtRecordtoProcess.Rows[i]["Startdate"].ToString(), dtRecordtoProcess.Rows[i]["Enddate"].ToString(), dtRecordtoProcess.Rows[i]["Comments"].ToString(), dtRecordtoProcess.Rows[i]["ProductDescription"].ToString(), dtRecordtoProcess.Rows[i]["OrderId"].ToString(), dtRecordtoProcess.Rows[i]["RequiredDate"].ToString(), dtRecordtoProcess.Rows[i]["ColorId"].ToString());
//UpdateOrderEvent((int)ds.Tables[1].Rows[j]["row_id1"]);//OrderId
// s.A1CreateEvent("*****@*****.**", "abc", "05-12-2013", "06-12-2013", "Test", "def", "ghi");
}
}
}
}
UpdateOrderEvent((int)ds.Tables[1].Rows[j]["row_id1"]);//OrderId
}
for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
{
if (ds.Tables[0].Rows[j]["CreateInvoice"].ToString() == "True")
{
Invoice invoice = new Invoice();
invoice.Type = "ACCREC";
invoice.Contact = new Contact { Name = ds.Tables[0].Rows[j]["XeroName"].ToString() };
invoice.Date = DateTime.Today;
invoice.DueDate = DueDate;
invoice.Status = "DRAFT";
invoice.TotalTax = 0;
invoice.HasAttachments = true;
invoice.LineAmountTypes = XeroApi.Model.LineAmountType.Inclusive;
invoice.Reference = ds.Tables[0].Rows[j]["Property"].ToString();
LineItems lineitems = new LineItems();
invoice.LineItems = new XeroApi.Model.LineItems();
ds.Tables[1].DefaultView.RowFilter = "OrderId='" + ds.Tables[0].Rows[j]["OrderId"].ToString() + "'";
for (int i = 0; i < ds.Tables[1].DefaultView.Count; i++)
{
LineItem lineItem = new LineItem();
lineItem.ItemCode = ds.Tables[1].DefaultView[i]["XeroCode"].ToString();
lineItem.Description = ds.Tables[1].DefaultView[i]["XeroItemDescription"].ToString();
lineItem.Quantity = 1;
lineItem.UnitAmount = Convert.ToDecimal(ds.Tables[1].DefaultView[i]["Cost1"]);
lineItem.TaxType = ds.Tables[1].DefaultView[i]["SalesTaxType"].ToString().Replace("GST on Income", "OUTPUT");
lineItem.AccountCode = ds.Tables[1].DefaultView[i]["SalesAccountCode"].ToString();
invoice.LineItems.Add(lineItem);
}
var inv = repository.Create<XeroApi.Model.Invoice>(invoice);
if (invoice.ValidationStatus == ValidationStatus.ERROR)
{
foreach (var message in invoice.ValidationErrors)
{
}
}
try
{
Guid invoiceId = inv.InvoiceID;
string invoiceNo = inv.InvoiceNumber;
// System.Threading.Thread.Sleep(5000);
string AnyAttachmentFilename = FullPath + "\\" + filename.Replace("htm", "jpg");
var SalesInvoice = repository.Invoices.FirstOrDefault(it => it.InvoiceID == invoiceId);
var newAttachment = repository.Attachments.Create(SalesInvoice, new FileInfo(AnyAttachmentFilename));
InsertProductInvoiceNo((int)ds.Tables[1].Rows[j]["Row_Id"], ds.Tables[0].Rows[j]["OrderId"].ToString(), invoiceNo);
ds.Tables[1].DefaultView.RowFilter = string.Empty;
}
catch (Exception ex)
{
strLog = ex.StackTrace.ToString();
WriteLog(strLog + " " + filename);
File.Move(System.Configuration.ConfigurationSettings.AppSettings["MailPath"] + "\\" + filename, System.Configuration.ConfigurationSettings.AppSettings["MailPath"] + "\\Error\\" + filename);
};
}
}
System.Threading.Thread.Sleep(30000);
System.IO.File.Delete(System.Configuration.ConfigurationSettings.AppSettings["MailPath"] + "\\" + filename);
filename = filename.Replace("htm", "txt");
System.IO.File.Delete(System.Configuration.ConfigurationSettings.AppSettings["MailPath"] + "\\" + filename);
//filename = filename.Replace("txt", "jpg");
//System.IO.File.Move(System.Configuration.ConfigurationSettings.AppSettings["MailPath"] + "\\" + filename, System.Configuration.ConfigurationSettings.AppSettings["MailPath"] + "\\Archive\\" + filename);
}
}
catch (Exception ex)
{
strLog = ex.StackTrace.ToString();
WriteLog(strLog + " " + filename);
File.Move(System.Configuration.ConfigurationSettings.AppSettings["MailPath"] + "\\" + filename, System.Configuration.ConfigurationSettings.AppSettings["MailPath"] + "\\Error\\" + filename);
}
return strLog;
}
