Ejemplo n.º 1
0
        public async System.Threading.Tasks.Task <ActionResult> SendEmailsAsync(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Task task = db.Tasks.Find(id);

            if (task == null)
            {
                return(HttpNotFound());
            }

            MailSender sender = new MailSender();

            var to      = task.Users.Select(i => i.EMailAddress).ToList();
            var subject = "";

            if (!string.IsNullOrEmpty(task.Mail))
            {
                subject = task.Mail.Substring(0, task.Mail.Length > 100 ? 100 : task.Mail.Length);
            }

            Email.Email email = new Email.Email(subject, to, task.Mail);

            await sender.SendEmails(email, task);

            task.Status          = "running";
            db.Entry(task).State = EntityState.Modified;
            db.SaveChanges();

            return(View("Index", db.Tasks.ToList()));
        }
        public void NewEnquiry(EnquiryEntity enquiry, Email.Email email)
        {
            if (enquiry == null)
            {
                throw new ArgumentNullException(nameof(enquiry));
            }

            _emailService.Send(email);
            SaveEnquiry(enquiry);
        }
Ejemplo n.º 3
0
        public ActionResult Email(long id, string t)
        {
            var data      = new Email.Email();
            var me        = repository.GetUserById(sessionid.Value, subdomainid.Value);
            var orderType = OrderHelper.GetQueryType(t);

            var order = repository.GetOrder(subdomainid.Value, id);

            if (string.IsNullOrEmpty(order.viewid))
            {
                repository.UpdateOrderViewID(order);
            }

            if (!order.receiverUserid.HasValue)
            {
                throw new NotImplementedException();
            }

            // set new url location
            data.orderID   = order.id;
            data.orderType = t;
            data.receiver  = order.user.email;
            if (!string.IsNullOrEmpty(order.user.firstName))
            {
                var name = order.user.firstName;
                if (!string.IsNullOrEmpty(order.user.lastName))
                {
                    name = string.Concat(name, " ", order.user.lastName);
                }
                data.receiver = name;
            }
            data.sender  = string.Concat(me.organisation1.name, " (", me.email, ")");
            data.viewloc = order.user.organisation1.MASTERsubdomain.ToHostName().ToDomainUrl("/browse/" + order.viewid);
            if (orderType.Value == TransactionType.INVOICE)
            {
                data.heading = "Send Invoice By Email";
                data.subject = string.Concat("[", me.organisation1.name, "] New Sales Invoice ",
                                             order.orderNumber.ToString("D8"));
                data.message = "You have received a new invoice. To view the invoice, follow the link below: ";
            }
            else if (orderType.Value == TransactionType.ORDER)
            {
                data.heading = "Send Order By Email";
                data.subject = string.Concat("[", me.organisation1.name, "] New Purchase Order ",
                                             order.orderNumber.ToString("D8"));
                data.message = "You have received a new order. To view the order, follow the link below: ";
            }
            else
            {
                throw new Exception("Unknown type");
            }

            return(View(data));
        }
Ejemplo n.º 4
0
 static void Main(string[] args)
 {
     Email.Email email = Email.Email.Build()
                         .Header
                         .From("*****@*****.**")
                         .To("test2.example.com")
                         .Subject("this is sample subject")
                         .Body
                         .Body("This is sample body")
                         .Attachment("This is sample attachment");
     Console.WriteLine(email.ToString());
 }
Ejemplo n.º 5
0
        private void checkuser()
        {
            Cursor = Cursors.WaitCursor;
            try
            {
                MySqlConnection connection = Program.sql.MySqlConnection();
                MySqlCommand    cmd        = Program.sql.MySqlSelectUserByUserNameAndEmail(txt_username.Text, txt_email.Text, connection);

                connection.Open();

                MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);
                DataSet          ds      = new DataSet();
                adapter.Fill(ds);

                connection.Close();

                int count = ds.Tables[0].Rows.Count;

                if (count == 1)
                {
                    this.Hide();

                    Random r = new Random();

                    for (int i = 0; i < 7; i++)
                    {
                        newpassword += alphabet[r.Next(0, alphabet.Count() - 1)];
                    }

                    Email.Email email = new Email.Email(txt_email.Text, "Password reset request", "Your account " + txt_username.Text + "'s password has had a reset request.\n\n\n" +
                                                        "New randomly generated password: "******"\n\n" +
                                                        "Change the password ASAP, during first login.\n\n\n" +
                                                        "Email sent from -Insert Software name here-\n" +
                                                        "@ " + DateTime.Now + " " + TimeZone.CurrentTimeZone.StandardName);
                    email.send();
                    changepassword();
                }
                else
                {
                    MessageBox.Show("No user found with provided information");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }


            Cursor = Cursors.Default;
        }
Ejemplo n.º 6
0
        public void Log <TState>(LogLevel logLevel, EventId eventId, TState state, Exception exception, Func <TState, Exception, string> formatter)
        {
            if (!IsEnabled(logLevel))
            {
                return;
            }

            // Prepare the email
            var email = new Email.Email(_provider.Email)
            {
                Subject = $"Unhandled Error on: {_provider.InstanceIdentifier ?? "Tellma"} - Id: {eventId.Id}",
                Body    = formatter(state, exception),
            };

            // Fire and forget (no need to await this)
            _provider.EmailSender.SendAsync(email);
        }
        private bool SendResetPasswordEmail(string resetLink, string emailAddress)
        {
            var email = new Email.Email
            {
                To       = emailAddress,
                Subject  = "Şifre sıfırlama isteği",
                Template = new Template
                {
                    Name      = "reset-password-link.html",
                    Variables = new Dictionary <string, string>
                    {
                        { "reset_link", resetLink }
                    }
                }
            };

            return(_emailService.SendEmail(email));
        }
Ejemplo n.º 8
0
        //void SetupCalendarForSubsription()
        //{
        //    try
        //    {
        //        scopes.Add(CalendarService.Scope.Calendar);
        //        UserCredential credential = default(UserCredential);
        //        FileDataStore _fdsToken = new FileDataStore("CT");
        //        credential = GoogleWebAuthorizationBroker.AuthorizeAsync(
        //          new ClientSecrets
        //          {
        //              ClientId = "532982290458-u189keaaki44sskvtki6p28rq5crjl6d.apps.googleusercontent.com",
        //              ClientSecret = "DDO62gcKn5nYWm4XCXlJkngo",
        //          }, scopes,
        //          "Z",
        //        CancellationToken.None, _fdsToken).Result;
        //        credential.Token.ExpiresInSeconds = 500000;
        //        String token = credential.Token.RefreshToken;
        //        credential.Token.RefreshToken = "1/wU76ItFh-n64iqZLjIiXER0Vx4u-MxEnHtHFLgQpa7E";
        //        credential.Token.ExpiresInSeconds = 500000;
        //        // Create the calendar service using an initializer instance
        //        BaseClientService.Initializer initializer = new BaseClientService.Initializer();
        //        initializer.HttpClientInitializer = credential;
        //        initializer.ApplicationName = "DPI Google Calendar";
        //        service = new CalendarService(initializer);
        //    }
        //    catch (Exception ex)
        //    {
        //    }
        //}
        public void CheckAllCalendarEvents(int orgId)
        {
            SetCalendar(orgId);
            bool IsAllDay = false;
            var list = service.CalendarList.List().Execute().Items;
            try
            {

                foreach (var cal in list)
                {
                    InsertGoogleSyncTime(cal.Id, DateTime.Now);
                    var itemlistreq = service.Events.List(cal.Id);
                    // itemlistreq.PageToken = token;
                    itemlistreq.MaxResults = 100000;
                    itemlistreq.ShowDeleted = true;
                    itemlistreq.ShowHiddenInvitations = true;
                    var itemlistex = itemlistreq.Execute();

                    //itemlistex.Items[0].
                    var token = itemlistex.NextPageToken;
                    string[] Descs = null;
                    for (int i = 0; i < itemlistex.Items.Count; i++)
                    {
                        IsAllDay = false;
                        string Calendar = cal.Id;
                        string EventId = itemlistex.Items[i].Id;
                        string RecurringEventId = itemlistex.Items[i].RecurringEventId;
                        if (RecurringEventId == null) { RecurringEventId = ""; };
                        var Attendees = itemlistex.Items[i].Attendees;
                        string Attendes = "";
                        if (Attendees != null)
                        {

                            for (int j = 0; j < Attendees.Count; j++)
                            { Attendes = Attendes + "~" + Attendees[j]; };
                        }
                        string ColorId = itemlistex.Items[i].ColorId;
                        if (ColorId == null) { ColorId = ""; };
                        bool? AttendeesOmitted = itemlistex.Items[i].AttendeesOmitted;
                        if (AttendeesOmitted == null) { AttendeesOmitted = false; };
                        bool? AnyoneCanAddSelf = itemlistex.Items[i].AnyoneCanAddSelf;
                        if (AnyoneCanAddSelf == null) { AnyoneCanAddSelf = false; };
                        string Title = itemlistex.Items[i].Summary;
                        if (Title == null) { Title = ""; }
                        string Location = itemlistex.Items[i].Location;
                        if (Location == null) { Location = ""; }
                        string Description = itemlistex.Items[i].Description;
                        if (Description == null) { Description = ""; }
                        string Kind = itemlistex.Items[i].Kind;
                        if (Kind == null) { Kind = ""; }
                        DateTime StartDate = Convert.ToDateTime("01/01/1900");
                        if (itemlistex.Items[i].Start != null)
                        {
                            if (itemlistex.Items[i].Start.Date != null)
                            {
                                StartDate = Convert.ToDateTime(itemlistex.Items[i].Start.Date);
                            }
                            if (StartDate == null || StartDate == Convert.ToDateTime("01/01/1900"))
                            {
                                { StartDate = Convert.ToDateTime(itemlistex.Items[i].Start.DateTime); }
                                if (StartDate != null && StartDate.ToString().Contains("0001")) { StartDate = Convert.ToDateTime("01/01/1900"); }
                            }
                        }
                        DateTime EndDate = Convert.ToDateTime("01/01/1900");
                        if (itemlistex.Items[i].End != null)
                        {
                            if (itemlistex.Items[i].End.Date != null)
                            {
                                EndDate = Convert.ToDateTime(itemlistex.Items[i].End.Date);
                                IsAllDay = true;// here this is all day event
                                EndDate = EndDate.AddDays(-1);

                                //text = File.ReadAllText("C://Google.txt");
                                //text = text + Environment.NewLine + " End Date- " + EndDate.ToString();
                                //File.WriteAllText("C://Google.txt", text);

                            }

                            if (EndDate == null || EndDate == Convert.ToDateTime("01/01/1900"))
                            {
                                { EndDate = Convert.ToDateTime(itemlistex.Items[i].End.DateTime); }
                                if (EndDate != null && EndDate.ToString().Contains("0001")) { EndDate = Convert.ToDateTime("01/01/1900"); }
                            }
                        }

                        DateTime MovedOn = Convert.ToDateTime("01/01/1900");
                        if (itemlistex.Items[i].Created != null)
                        { MovedOn = Convert.ToDateTime(itemlistex.Items[i].Created); }
                        if (MovedOn != null && MovedOn.ToString().Contains("0001")) { MovedOn = Convert.ToDateTime("01/01/1900"); }
                        string Status = itemlistex.Items[i].Status;
                        var Recurrence = itemlistex.Items[i].Recurrence;
                        string Recurrences = "";
                        if (Recurrence != null)
                        {

                            for (int j = 0; j < Recurrence.Count; j++)
                            { Recurrences = Recurrences + "~" + Recurrence[j]; };
                        }
                        string Organizer = "";
                        if (itemlistex.Items[i].Organizer != null)
                        {
                            Organizer = itemlistex.Items[i].Organizer.DisplayName;
                        }
                        if (Organizer == null) { Organizer = ""; }
                        string Creator = "";
                        if (itemlistex.Items[i].Creator != null)
                        {
                            Creator = itemlistex.Items[i].Creator.DisplayName;
                        }
                        if (Creator == null) { Creator = ""; }
                        bool? Locked = false;
                        try
                        {
                            Locked = itemlistex.Items[i].Locked;
                        }
                        catch { };
                        Locked = false;
                        //if (Locked == null) { Locked = false; };
                        int Sequence = 0;
                        if (itemlistex.Items[i].Sequence != null)
                        { Sequence = (int)itemlistex.Items[i].Sequence; }
                        string Transperancy = itemlistex.Items[i].Transparency;
                        if (Transperancy == null) { Transperancy = ""; }
                        DateTime Updated = Convert.ToDateTime("01/01/1900");
                        if (itemlistex.Items[i].Updated != null)
                        { Updated = Convert.ToDateTime(itemlistex.Items[i].Updated); }
                        if (Updated != null && Updated.ToString().Contains("0001")) { Updated = Convert.ToDateTime("01/01/1900"); }
                        string Visibility = itemlistex.Items[i].Visibility;
                        if (Visibility == null) { Visibility = ""; }

                        InsertOtherEvents(Calendar, EventId, RecurringEventId, ColorId, Attendes, AttendeesOmitted, AnyoneCanAddSelf, Locked, Title, Location, Description, Kind, StartDate, EndDate, MovedOn, Status, Recurrences, Organizer, Creator, Sequence, Transperancy, Updated, Visibility, IsAllDay);

                    }

                }
            }
            catch (Exception ex)
            {
                Email.Email eml = new Email.Email();
                string strLog = ex.StackTrace.ToString() + "~~~~~~~~~~~~Error~~~~~~~~~~~:" + ex.Message.ToString();
                eml.SendMail("Error syncing google calendar", "Error :- " + strLog, "*****@*****.**", "", false);

            };
        }
Ejemplo n.º 9
0
        public void CheckCalendarMovements(string calendar, int orgId)
        {
            SetCalendar(orgId);
            //CheckCalendarEvents(calendar);

            string a;
            var list = service.CalendarList.List().Execute().Items;//.Where(x=>x.Id==calendar);
            try
            {

                foreach (var cal in list)
                {

                    // if (cal.Id != "*****@*****.**") { continue; }
                    int res = InsertCalendars(cal.Id, 1, cal.TimeZone);
                    //Subscribe(cal);
                    //var itemlistreq = service.Events.List(cal.Id);
                    //// itemlistreq.PageToken = token;
                    //itemlistreq.MaxResults = 100000;
                    //itemlistreq.ShowDeleted = true;
                    //itemlistreq.ShowHiddenInvitations = true;
                    //var itemlistex = itemlistreq.Execute();

                    ////itemlistex.Items[0].
                    //var token = itemlistex.NextPageToken;
                    //for (int i = 0; i < itemlistex.Items.Count; i++)
                    //{
                    //    if (itemlistex.Items[i].Description != null)
                    //    {

                    //        if (Convert.ToDateTime(itemlistex.Items[i].Created).Date == DateTime.Now.Date || Convert.ToDateTime(itemlistex.Items[i].Created).Date == DateTime.Now.Date.AddDays(-1) || Convert.ToDateTime(itemlistex.Items[i].Created).Date == DateTime.Now.Date.AddDays(-2))
                    //        {
                    //            if (itemlistex.Items[i].Description.Contains("Order Item (Please donot delete or update OrderItemId) :") == true)
                    //            {
                    //                string Desc = itemlistex.Items[i].Description;

                    //                string[] Descs = Desc.Split(new string[] { "Order Item (Please donot delete or update OrderItemId) :" }, StringSplitOptions.None);
                    //                string OrderItemId = Descs[1];
                    //                string Title = itemlistex.Items[i].Summary;
                    //                string Calendar = cal.Id;
                    //                DateTime StartDate = Convert.ToDateTime(itemlistex.Items[i].Start.DateTime);
                    //                DateTime EndDate = Convert.ToDateTime(itemlistex.Items[i].End.DateTime);
                    //                DateTime MovedOn = Convert.ToDateTime(itemlistex.Items[i].Created);
                    //                string Status = itemlistex.Items[i].Status;
                    //                //InsertCalendarEvents(Calendar, OrderItemId, Title, StartDate, EndDate, MovedOn, Status);

                    //            }

                    //        }
                    //    }
                    //}

                    //Here, itemlistreq.PageToken == null;
                }
                //UpdateCalendar();
            }
            catch (Exception ex)
            {
                Email.Email eml = new Email.Email();
                string strLog = ex.StackTrace.ToString() + "~~~~~~~~~~~~Error~~~~~~~~~~~:" + ex.Message.ToString();
                eml.SendMail("Error syncing google calendar", "Error :- " + strLog, "*****@*****.**", "", false);

            };
        }
Ejemplo n.º 10
0
        public void SyncGoogleCalendars(int orgId)
        {
            SetCalendar(orgId);
            //CheckCalendarEvents();

            string a;
            var list = service.CalendarList.List().Execute().Items;
            try
            {

                foreach (var cal in list)
                {
                    // if (cal.Id != "*****@*****.**") { continue; }

                    int result = InsertCalendars(cal.Id, 825, cal.TimeZone, cal.Kind, cal.ETag, int.Parse(cal.ColorId), cal.BackgroundColor, cal.ForegroundColor, cal.AccessRole, cal.Selected ?? false);
                    if (result == 2)
                    {
                        Subscribe(cal, orgId);
                    }
                    var itemlistreq = service.Events.List(cal.Id);
                    // itemlistreq.PageToken = token;
                    itemlistreq.MaxResults = 100000;
                    itemlistreq.ShowDeleted = true;
                    itemlistreq.ShowHiddenInvitations = true;
                    try
                    {
                        var itemlistex = itemlistreq.Execute();

                        //itemlistex.Items[0].
                        var token = itemlistex.NextPageToken;
                        for (int i = 0; i < itemlistex.Items.Count; i++)
                        {
                            if (itemlistex.Items[i].Description != null)
                            {

                                if (Convert.ToDateTime(itemlistex.Items[i].Created).Date == DateTime.Now.Date || Convert.ToDateTime(itemlistex.Items[i].Created).Date == DateTime.Now.Date.AddDays(-1) || Convert.ToDateTime(itemlistex.Items[i].Created).Date == DateTime.Now.Date.AddDays(-2))
                                {
                                    if (itemlistex.Items[i].Description.Contains("Order Item (Please donot delete or update OrderItemId) :") == true)
                                    {
                                        string Desc = itemlistex.Items[i].Description;
                                        string[] Descs = Desc.Split(new string[] { "Order Item (Please donot delete or update OrderItemId) :" }, StringSplitOptions.None);
                                        string OrderItemId = Descs[1];
                                        string Title = itemlistex.Items[i].Summary;
                                        string Calendar = cal.Id;
                                        DateTime StartDate = Convert.ToDateTime(itemlistex.Items[i].Start.DateTime);
                                        DateTime EndDate = Convert.ToDateTime(itemlistex.Items[i].End.DateTime);
                                        DateTime MovedOn = Convert.ToDateTime(itemlistex.Items[i].Created);
                                        string Status = itemlistex.Items[i].Status;
                                        InsertCalendarEvents(Calendar, OrderItemId, Title, StartDate, EndDate, MovedOn, Status);

                                    }

                                }
                            }
                        }
                    }
                    catch
                    { }
                    //Here, itemlistreq.PageToken == null;
                }
            }
            catch (Exception ex)
            {
                Email.Email eml = new Email.Email();
                string strLog = ex.StackTrace.ToString() + "~~~~~~~~~~~~Error~~~~~~~~~~~:" + ex.Message.ToString();
                eml.SendMail("Error syncing google calendars Only (Inserting newly added calendar in db)", "Error :- " + strLog, "*****@*****.**", "", false);

            };
        }
Ejemplo n.º 11
0
        public async System.Threading.Tasks.Task <ActionResult> Create([Bind(Include = "TaskId,Mail,QuantityOfUsers,QuantityOfSentMails")] Task task, string action, IEnumerable <string> GroupOfRecipients)
        {
            if (ModelState.IsValid)
            {
                var users = db.Users;

                foreach (var group in GroupOfRecipients)
                {
                    task.SelectedGroupsOfUsers.Add(new SelectedGroupsOfUsers {
                        Name = group, TasksId = task.TaskId
                    });
                }

                foreach (var user in users)
                {
                    foreach (var group in GroupOfRecipients)
                    {
                        if (user.GroupOfRecipients == group)
                        {
                            task.Users.Add(user);
                        }
                    }
                }

                if (action == "Save")
                {
                    task.QuantityOfUsers = task.Users.Count;
                    task.Status          = "stopped";
                    db.Tasks.Add(task);
                    db.SaveChanges();
                    return(RedirectToAction("Index"));
                }
                if (action == "Send")
                {
                    if (task == null)
                    {
                        return(HttpNotFound());
                    }

                    MailSender sender = new MailSender();

                    var to      = task.Users.Select(i => i.EMailAddress).ToList();
                    var subject = "";
                    if (!string.IsNullOrEmpty(task.Mail))
                    {
                        subject = task.Mail.Substring(0, task.Mail.Length > 100 ? 100 : task.Mail.Length);
                    }

                    Email.Email email = new Email.Email(subject, to, task.Mail);

                    task.QuantityOfUsers = task.Users.Count;
                    task.Status          = "running";
                    db.Tasks.Add(task);
                    db.SaveChanges();

                    await sender.SendEmails(email, task);

                    return(RedirectToAction("Index"));
                }
            }

            return(View(task));
        }
Ejemplo n.º 12
0
        public string ProcessData()
        {
            string strLog = "";
            XmlDocument xmlDoc = new XmlDocument();
            IOAuthSession session;
            DateTime DueDate = DateTime.Now;
            string strd;
            string Subject;
            string jpgfilename;
            Email.Email eml = new Email.Email();

            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();
                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"))
                {
                    int propertyId = 0;
                    string location=string.Empty;

                    filename = Path.GetFileName(file);
                    jpgfilename = filename.Replace("htm", "jpg");
                    // 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
                    {
                        #region Fixed on 9 Oct 2014

                        if (SplitValues[3] == "at")
                        {
                            var midleName = SplitValues[1];
                            SplitValues = SplitValues.Where(x => x != midleName).ToArray();
                            var lastName = SplitValues[1];
                            SplitValues[1] = midleName + " " + lastName;
                        }

                        #endregion

                        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);
                    location = str33;

                    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);
                                            try
                                            {
                                                propertyId = int.Parse(PropertyIdElement.InnerText);
                                            }
                                            catch
                                            { }

                                        }

                                        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.Month.ToString().PadLeft(2, '0') + "-" + objRequiredDate.Day.ToString().PadLeft(2, '0') + "-" + objRequiredDate.Year;
                                            RequiredDateElement.InnerText = objRequiredDate.ToShortDateString();
                                            rootElement.AppendChild(RequiredDateElement);
                                            DueDate = Convert.ToDateTime(objRequiredDate.ToShortDateString());
                                            //DueDate = DateTime.Parse(RequiredDate, "dd/MM/yyyy").ToString("MM/dd/yyyy");
                                        }

                                        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("&amp;", "and").Replace("andamp;", " and ");
                    strd = strd.Replace("'", "''");
                    DataSet ds = new DataSet();
                    strd = strd.Replace("\r\n",string.Empty);
                    strd = strd.Replace(";", string.Empty);
                    ds = ExecuteProcess(strd);
                    xmlDoc.RemoveAll();
                    if (propertyId != 0 && !string.IsNullOrEmpty(location))
                    {
                        ProprtyCoordinates(propertyId, location);
                    }
                    if (ds.Tables[0].Rows.Count > 0)
                    {
                        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 productGroupName = string.Empty;
                                string productGroupId = string.Empty;
                                try
                                {
                                    if (dsProductNotification.Tables[0].Rows[dsProductNotification.Tables[0].Rows.Count - 1]["ProductGroupId"] != null)
                                    {
                                        productGroupId = dsProductNotification.Tables[0].Rows[dsProductNotification.Tables[0].Rows.Count - 1]["ProductGroupId"].ToString();
                                    }
                                    if (dsProductNotification.Tables[0].Rows[dsProductNotification.Tables[0].Rows.Count - 1]["ProductGroupName"] != null)
                                    {
                                        productGroupName = dsProductNotification.Tables[0].Rows[dsProductNotification.Tables[0].Rows.Count - 1]["ProductGroupName"].ToString();
                                    }
                                }
                                catch
                                {
                                    productGroupId = string.Empty;
                                    productGroupName = string.Empty;
                                }

                                //(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];
                                    CampaignTrack_MailScarapper.GoogleService.IGoogleNotificationService client = (CampaignTrack_MailScarapper.GoogleService.IGoogleNotificationService)new CampaignTrack_MailScarapper.GoogleService.GoogleNotificationServiceClient();

                                    //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());
                                            string orderItemDetails = string.Empty;
                                            if (!string.IsNullOrEmpty(productGroupId))
                                            {
                                                orderItemDetails = "Order Item (Please do not delete or update Order Item Id) :" + dtRecordtoProcess.Rows[i]["OrderId"].ToString() + ", " + productGroupId + "-" + productGroupName;
                                            }
                                            else
                                            {
                                                orderItemDetails = "Order Item (Please do not delete or update Order Item Id) :" + dtRecordtoProcess.Rows[i]["OrderId"].ToString();
                                            }
                                            //string description = "SalesContact : " + dtRecordtoProcess.Rows[i]["SalesContact"].ToString() + Environment.NewLine + Environment.NewLine + "Required On :" + Convert.ToDateTime(dtRecordtoProcess.Rows[i]["RequiredDate"].ToString()).ToShortDateString() + Environment.NewLine + Environment.NewLine + "Product Description :" + dtRecordtoProcess.Rows[i]["ProductDescription"].ToString() + Environment.NewLine + Environment.NewLine + "Supplier Instructions :" + dtRecordtoProcess.Rows[i]["Comments"].ToString().Replace("Supplier Instructions", "") + Environment.NewLine + Environment.NewLine + "Order Item (Please do not delete or update Order Item Id) :" + dtRecordtoProcess.Rows[i]["OrderId"].ToString() + ", " + productGroupId + "-" + productGroupName;
                                            string description = "SalesContact : " + dtRecordtoProcess.Rows[i]["SalesContact"].ToString() + Environment.NewLine + Environment.NewLine + "Required On :" + Convert.ToDateTime(dtRecordtoProcess.Rows[i]["RequiredDate"].ToString()).ToShortDateString() + Environment.NewLine + Environment.NewLine + "Product Description :" + dtRecordtoProcess.Rows[i]["ProductDescription"].ToString() + Environment.NewLine + Environment.NewLine + "Supplier Instructions :" + dtRecordtoProcess.Rows[i]["Comments"].ToString().Replace("Supplier Instructions", "") + Environment.NewLine + Environment.NewLine + orderItemDetails;
                                            //client.CreateEvent(dtRecordtoProcess.Rows[i]["Title"].ToString(), dtRecordtoProcess.Rows[i]["Location"].ToString(), dtRecordtoProcess.Rows[i]["SalesContact"].ToString(), Convert.ToDateTime(dtRecordtoProcess.Rows[i]["Startdate"].ToString()), Convert.ToDateTime(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(), "*****@*****.**", description, string.Empty, false);
                                            //  if (s.CheckedCalendarEvent == 0) { s.CheckedCalendarEvent = 1; }
                                            //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
                        }

                        Invoice invoice = new Invoice();
                        invoice.Type = "ACCREC";
                        invoice.Contact = new Contact { Name = ds.Tables[0].Rows[0]["XeroName"].ToString() };
                        invoice.Date = DateTime.Today;
                        invoice.DueDate = DateTime.Today.AddDays(30);
                        invoice.Status = "DRAFT";
                        invoice.TotalTax = 0;
                        invoice.HasAttachments = true;
                        invoice.LineAmountTypes = XeroApi.Model.LineAmountType.Inclusive;
                        invoice.Reference = ds.Tables[0].Rows[0]["Property"].ToString();
                        LineItems lineitems = new LineItems();
                        invoice.LineItems = new XeroApi.Model.LineItems();
                        for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
                        {
                            if (ds.Tables[0].Rows[j]["CreateInvoice"].ToString() == "True")
                            {
                                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 + "\\" + jpgfilename;
                            var SalesInvoice = repository.Invoices.FirstOrDefault(it => it.InvoiceID == invoiceId);
                            var newAttachment = repository.Attachments.Create(SalesInvoice, new FileInfo(AnyAttachmentFilename));
                            InsertPropertyInvoice((int)ds.Tables[1].Rows[0]["Property_Id"], invoiceNo);
                            ds.Tables[1].DefaultView.RowFilter = string.Empty;
                            System.Threading.Thread.Sleep(5000);
                        }
                        catch (Exception ex)
                        {
                            strLog = ex.StackTrace.ToString() + "~~~~~~~~~~~~Error~~~~~~~~~~~:" + ex.Message.ToString();
                            WriteLog(strLog + "For Filename :" + filename);
                            File.Move(System.Configuration.ConfigurationSettings.AppSettings["MailPath"] + filename, System.Configuration.ConfigurationSettings.AppSettings["Error"] + filename);
                            filename = filename.Replace("htm", "txt");
                            File.Move(System.Configuration.ConfigurationSettings.AppSettings["MailPath"] + filename, System.Configuration.ConfigurationSettings.AppSettings["Error"] + filename);
                        }
                        System.Threading.Thread.Sleep(5000);
                        System.IO.File.Move(System.Configuration.ConfigurationSettings.AppSettings["MailPath"] + filename, System.Configuration.ConfigurationSettings.AppSettings["Archive"] + filename);
                        //System.IO.File.Delete(System.Configuration.ConfigurationSettings.AppSettings["MailPath"] + "\\" + filename);
                        filename = filename.Replace("htm", "txt");
                        //if (System.IO.File.Exists(System.Configuration.ConfigurationSettings.AppSettings["MailPath"] + "\\" + filename))
                        //{ 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);

                    }
                    else
                    {
                        eml.SendMail("No Product Match..", "The file name is " + filename, "*****@*****.**", "", false);
                        File.Move(System.Configuration.ConfigurationSettings.AppSettings["MailPath"] + filename, System.Configuration.ConfigurationSettings.AppSettings["NoMatch"] + filename);
                        filename = filename.Replace("htm", "txt");
                        File.Move(System.Configuration.ConfigurationSettings.AppSettings["MailPath"] + filename, System.Configuration.ConfigurationSettings.AppSettings["NoMatch"] + filename);

                    };

                }
            }
            catch (Exception ex)
            {
                strLog = ex.StackTrace.ToString() + "~~~~~~~~~~~~Error~~~~~~~~~~~:" + ex.Message.ToString();
                //if (strLog.Contains("at Google.Apis.Requests.ClientServiceRequest") == false)
                //{
                    eml.SendMail("Error in parsing file..", "The file name is " + filename + ". Error :- " + strLog, "*****@*****.**", "", false);
                    WriteLog(strLog + "For Filename :" + filename);
                    File.Move(System.Configuration.ConfigurationSettings.AppSettings["MailPath"] + filename, System.Configuration.ConfigurationSettings.AppSettings["Error"] + filename);
                    filename = filename.Replace("htm", "txt");
                    File.Move(System.Configuration.ConfigurationSettings.AppSettings["MailPath"] + filename, System.Configuration.ConfigurationSettings.AppSettings["Error"] + filename);
                //}
            }

            return strLog;
        }