Click here to Skip to main content
15,888,218 members
Search within:


I am reading mail from gmail and then insert it into database along with body but in body tag it is showing HTML content along with body data
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
C#
ASP.NET
 
I am Reading Mail from Gmail and then Insert it Into sql server database along with body but In body tag it is inserting html content along with body data


eg my email content body tag as follows 

Your password changed	
Hi my,
The password for your Google Account memyid2016@gmail.com was recently changed.

Don't recognize this activity?
Click here for more information on how to recover your account.
The Google Accounts team



but in database it is showing as follows

<html lang=en><head><meta content="date=no" name="format-detection"><meta content="email=no" name="format-detection"><style>.awl a {color: #FFFFFF; text-decoration: none;}.abml a {color: #000000; font-family: Roboto-Medium,Helvetica,Arial,sans-serif; font-weight: bold; text-decoration: none;}.adgl a {color: rgba(0, 0, 0, 0.87); text-decoration: none;}.afal a {color: #b0b0b0; text-decoration: none;}@media screen and (min-width: 600px) {.v2sp {padding: 6px 30px 0px;} .v2rsp {padding: 0px 10px;}}</style></head><body bgcolor="#FFFFFF" style="margin: 0; padding: 0;"><table border=0 cellpadding=0 cellspacing=0 height="100%" style="min-width: 348px;" width="100%"><Tbody><tr height=32px></tr><tr align=center><td width=32px></td><td><table border=0 cellpadding=0 cellspacing=0 style="max-width: 600px;"><Tbody><tr><td><table border=0 cellpadding=0 cellspacing=0 width="100%"><Tbody><tr><td align=left><img height=32 src="https://www.gstatic.com/accountalerts/email/googlelogo_color_188x64dp.png" style="display: block; width: 92px; height: 32px;" width=92></td><td align=right><img height=32 src="https://www.gstatic.com/accountalerts/email/shield.png" style="display: block; width: 32px; height: 32px;" width=32></td></tr></Tbody></table></td></tr><tr height=16></tr><tr><td><table bgcolor="#D94235" border=0 cellpadding=0 cellspacing=0 style="min-width: 332px; max-width: 600px; border: 1px solid #F0F0F0; border-bottom: 0; border-top-left-radius: 3px; border-top-right-radius: 3px;" width="100%"><Tbody><tr><td colspan=3 height=72px></td></tr><tr><td width=32px></td><td style="font-family: Roboto-Regular,Helvetica,Arial,sans-serif; font-size: 24px; color: #FFFFFF; line-height: 1.25; min-width: 300px;">Your password changed</td><td width=32px></td></tr><tr><td colspan=3 height=18px></td></tr></Tbody></table></td></tr><tr><td><table bgcolor="#FAFAFA" border=0 cellpadding=0 cellspacing=0 style="min-width: 332px; max-width: 600px; border: 1px solid #F0F0F0; border-bottom: 1px solid #C0C0C0; border-top: 0; border-bottom-left-radius: 3px; border-bottom-right-radius: 3px;" width="100%"><Tbody><tr height=16px><td rowspan=3 width=32px></td><td></td><td rowspan=3 width=32px></td></tr><tr><td><table border=0 cellpadding=0 cellspacing=0 style="min-width: 300px;"><Tbody><tr><td style="font-family: Roboto-Regular,Helvetica,Arial,sans-serif; font-size: 13px; color: #202020; line-height: 1.5;padding-bottom: 4px;">Hi my,</td></tr><tr><td style="font-family: Roboto-Regular,Helvetica,Arial,sans-serif; font-size: 13px; color: #202020; line-height: 1.5;padding: 4px 0;">The password for your Google Account <a>memyid2016@gmail.com</a> was recently changed.<br><br>Don't recognize this activity?<br>Click <a data-meta-key="recover-account" href="https://accounts.google.com/RecoverAccount?fpOnly=1&source=ancppe&Email=memyid2016@gmail.com" style="text-decoration: none; color: #4285F4;" target="_blank">here</a> for more information on how to recover your account.</td></tr><tr><td style="font-family: Roboto-Regular,Helvetica,Arial,sans-serif; font-size: 13px; color: #202020; line-height: 1.5; padding-top: 28px;">The Google Accounts team</td></tr><tr height=16px></tr><tr><td><table style="font-family: Roboto-Regular,Helvetica,Arial,sans-serif; font-size: 12px; color: #B9B9B9; line-height: 1.5;"><Tbody><tr><td>This email can't receive replies. For more information, visit the <a data-meta-key=help href="https://support.google.com/accounts/answer/1628875" style="text-decoration: none; color: #4285F4;" target="_blank">Google Accounts Help Center</a>.</td></tr></Tbody></table></td></tr></Tbody></table></td></tr><tr height=32px></tr></Tbody></table></td></tr><tr height=16></tr><tr><td style="max-width: 600px; font-family: Roboto-Regular,Helvetica,Arial,sans-serif; font-size: 10px; color: #BCBCBC; line-height: 1.5;"></td></tr><tr><td><table style="font-family: Roboto-Regular,Helvetica,Arial,sans-serif; font-size: 10px; color: #666666; line-height: 18px; padding-bottom: 10px"><Tbody><tr><td>You received this mandatory email service announcement to update you about important changes to your Google product or account.</td></tr><tr height=6px></tr><tr><td><div style="direction: ltr; text-align: left">© 2018 Google Inc., 1600 Amphitheatre Parkway, Mountain View, CA 94043, USA</div><div style="display: none !important; mso-hide:all; max-height:0px; max-width:0px;">et:1</div></td></tr></Tbody></table></td></tr></Tbody></table></td><td width=32px></td></tr><tr height=32px></tr></Tbody></table><img height=1 src="https://notifications.googleapis.com/email/a.gif?t=AFG8qyXeAbLKIeVj-ZuQi4EX_keEmYi7SYKydF9LSgpMZSEVGNNEAeZved2etWJ2CMAYyByKS4uA5Z7AA0gjsJkxBuilM31JjkPk5iKHrkq_bY7d804fjLI5EOHQAY351j2ewxCDNwUmKJfFf2XoRZPbh3XGxcmi9aji_2wgoNMOPdAZkwYA06qe6_5yoaQzXL1ANykZ60RP29mE915LuwsMqUKg18_T6Ou9STw44sEZ" width=1></body></html>


I dont want html content I just want Message

What I have tried:

Created ASPX page to login and one gridview to show content of Mail

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="EmailSolution.WebForm1" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>


         <table class="style1">
            <tr>
                <td colspan="3">
                    <h2 style="text-align: center">Welcome To Gmail</h2></td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="Label1" runat="server" Text="Gmail ID :"></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txt_email" runat="server" Width="241px"></asp:TextBox>
                </td>
                <td>
                    <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" 
                        ControlToValidate="txt_email" ErrorMessage="Invalid Mail Format" 
                        ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"></asp:RegularExpressionValidator>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="Label2" runat="server" Text="Password :"></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txt_password" runat="server" TextMode="Password" Width="239px"></asp:TextBox>
                </td>
                <td>
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" 
                        ControlToValidate="txt_password" ErrorMessage="*"></asp:RequiredFieldValidator>
                </td>
            </tr>
            <tr>
                <td colspan="3" style="text-align: center">
                    <asp:Button ID="Button1" runat="server" CausesValidation="False" 
                        onclick="Button1_Click" style="text-align: center" Text="Login" Width="72px" />
                </td>
            </tr>
        </table>


        <asp:GridView ID="gvEmails" runat="server" AllowPaging="true" PageSize="5" OnPageIndexChanging="gvEmails_PageIndexChanging"></asp:GridView>
    </div>
    </form>
</body>
</html>


and .cs files as follows

using OpenPop.Mime;
using OpenPop.Pop3;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace EmailSolution
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        static string ConnectionString = ConfigurationManager.ConnectionStrings["MailConnection"].ConnectionString;
        protected List<Email> Emails
        {
            get { return (List<Email>)ViewState["Emails"]; }
            set { ViewState["Emails"] = value; }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
               
            }

        }
        
        private void Read_Emails(string Email, string Password)
        {
            Pop3Client pop3Client;
            if (Session["Pop3Client"] == null)
            {
                pop3Client = new Pop3Client();
                pop3Client.Connect("pop.gmail.com", 995, true);
                //pop3Client.Authenticate("email@gmail.com", "123456", AuthenticationMethod.TryBoth);
                pop3Client.Authenticate(Email, Password);
                //pop3Client.Authenticate("memyid2016@gmail.com", "Qaz1234567890");
                Session["Pop3Client"] = pop3Client;
            }
            else
            {
                pop3Client = (Pop3Client)Session["Pop3Client"];
            }
            int count = pop3Client.GetMessageCount();
            this.Emails = new List<Email>();
            int counter = 0;
            for (int i = count; i >= 1; i--)
            {
                Message message = pop3Client.GetMessage(i);
                Email email = new Email()
                {
                    MessageNumber = i,
                    Subject = message.Headers.Subject,
                    DateSent = message.Headers.DateSent,
                    From = string.Format("<a href = 'mailto:{1}'>{0}</a>", message.Headers.From.DisplayName, message.Headers.From.Address),
                };
                MessagePart body = message.FindFirstHtmlVersion();
                if (body != null)
                {
                    email.Body = body.GetBodyAsText();
                }
                else
                {
                    body = message.FindFirstPlainTextVersion();
                    if (body != null)
                    {
                        email.Body = body.GetBodyAsText();
                    }
                }
                //List<MessagePart> attachments = message.FindAllAttachments();

                //foreach (MessagePart attachment in attachments)
                //{
                //    email.Attachments.Add(new Attachment
                //    {
                //        FileName = attachment.FileName,
                //        ContentType = attachment.ContentType.MediaType,
                //        Content = attachment.Body
                //    });
                //}
                this.Emails.Add(email);
                counter++;
                if (counter > count)
                {
                    break;
                }
                
            }
            Insert(Emails);
            gvEmails.DataSource = this.Emails;
            gvEmails.DataBind();
        }
        protected void OnRowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                Repeater rptAttachments = (e.Row.FindControl("rptAttachments") as Repeater);
                List<Attachment> attachments = this.Emails.Where(email => email.MessageNumber == Convert.ToInt32(gvEmails.DataKeys[e.Row.RowIndex].Value)).FirstOrDefault().Attachments;
                rptAttachments.DataSource = attachments;
                rptAttachments.DataBind();
            }
        }
        protected void Download(object sender, EventArgs e)
        {
            LinkButton lnkAttachment = (sender as LinkButton);
            GridViewRow row = (lnkAttachment.Parent.Parent.NamingContainer as GridViewRow);
            List<Attachment> attachments = this.Emails.Where(email => email.MessageNumber == Convert.ToInt32(gvEmails.DataKeys[row.RowIndex].Value)).FirstOrDefault().Attachments;
            Attachment attachment = attachments.Where(a => a.FileName == lnkAttachment.Text).FirstOrDefault();
            Response.AddHeader("content-disposition", "attachment;filename=" + attachment.FileName);
            Response.ContentType = attachment.ContentType;
            Response.BinaryWrite(attachment.Content);
            Response.End();
        }


        [Serializable]
        public class Email
        {
            public Email()
            {
                this.Attachments = new List<Attachment>();
            }
            public int MessageNumber { get; set; }
            public string From { get; set; }
            public string Subject { get; set; }
            public string Body { get; set; }
            public DateTime DateSent { get; set; }
            public List<Attachment> Attachments { get; set; }
        }
        [Serializable]
        public class Attachment
        {
            public string FileName { get; set; }
            public string ContentType { get; set; }
            public byte[] Content { get; set; }
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            Session["email"] = txt_email.Text;
            Session["pwd"] = txt_password.Text;

            Read_Emails(txt_email.Text, txt_password.Text);
        }



        public void Insert(List<Email> emails)
        {
            SqlConnection con = new SqlConnection(ConnectionString);
            string userId;
            string MFrom;
            string MSubject;
            string MBody;
            DateTime MailDate;
            int MessageNumber;
            DateTime drvalues;
            string finalstring;           
            if (emails.Count > 0)
            {
                bool flag = false;
                foreach (var iteam in emails)
                {
                    //MContentType = iteam.From.ToString();
                    userId = Session["email"].ToString();
                    MFrom = iteam.From.ToString();
                    MSubject = iteam.Subject.ToString();
                    MBody = iteam.Body.ToString();
                    MailDate = iteam.DateSent;
                    string str;
                    MessageNumber = Convert.ToInt32(iteam.MessageNumber);
                    if (flag == false)
                    {
                        flag = true;
                        SqlCommand cmd1 = new SqlCommand("select max(mDateSent) as mDateSent from tblNewMail where userId='" + userId + "'", con);
                        con.Open();
                        SqlDataReader dr = cmd1.ExecuteReader();
                        while (dr.Read())
                        {
                            string mstr = dr["mDateSent"].ToString();
                            if (mstr != null && mstr != "")
                            {
                                ViewState["drvalues"] = dr["mDateSent"].ToString();
                            }
                            
                        }
                        con.Close();
                    }
                    //str = ;
                    if (ViewState["drvalues"]== null)
                    {
                        drvalues = Convert.ToDateTime(ViewState["drvalues"]);
                        if (drvalues < MailDate)
                        {
                            
                            ViewState["drvalues"] = null;
                            string input = MFrom;
                            int index = input.IndexOf(">");
                            if (index > 0)
                                input = input.Substring(0, index);
                            int index1 = input.IndexOf('<');
                            finalstring = input.Substring(index1 + 1);
                            SqlCommand cmd = new SqlCommand("Sp_InsertNewMailData", con);
                            cmd.CommandType = CommandType.StoredProcedure;

                            cmd.Parameters.AddWithValue("@MessageNumber", MessageNumber);
                            cmd.Parameters.AddWithValue("@MFrom", MFrom);
                            cmd.Parameters.AddWithValue("@MSubject", MSubject);
                            cmd.Parameters.AddWithValue("@MBody", MBody);
                            cmd.Parameters.AddWithValue("@mDateSent", MailDate);
                            cmd.Parameters.AddWithValue("@userId", userId);                           
                            con.Close();
                            con.Open();
                            cmd.ExecuteNonQuery();
                            con.Close();

                        }
                    }
                   else
                    {
                        drvalues = Convert.ToDateTime(ViewState["drvalues"]);
                        if (drvalues < MailDate)
                        {
                            ViewState["drvalues"] = null;
                            string input = MFrom;
                        int index = input.IndexOf(">");
                        if (index > 0)
                        input = input.Substring(0, index);
                        int index1 = input.IndexOf('<');
                        finalstring = input.Substring(index1 + 1);
                        SqlCommand cmd = new SqlCommand("Sp_InsertNewMailData", con);
                        cmd.CommandType = CommandType.StoredProcedure;
                        cmd.Parameters.AddWithValue("@MessageNumber", MessageNumber);
                        cmd.Parameters.AddWithValue("@MFrom", MFrom);
                        cmd.Parameters.AddWithValue("@MSubject", MSubject);
                        cmd.Parameters.AddWithValue("@MBody", MBody);
                        cmd.Parameters.AddWithValue("@mDateSent", MailDate);
                        cmd.Parameters.AddWithValue("@userId", userId);
                        con.Close();
                        con.Open();
                        cmd.ExecuteNonQuery();
                        con.Close();                        
                    }      
                        }              
                }
            }
        }

        protected void gvEmails_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            gvEmails.PageIndex = e.NewPageIndex;
            gvEmails.DataSource = this.Emails;
            gvEmails.DataBind();
        }
       
    }
}
Posted
Add a Solution

1 solution

You call "FindFirstHtmlVersion" and if that exists you go on to store it, you only call "FindFirstPlainTextVersion" if the other call returns null. You probably only want to call "FindFirstPlainTextVersion" if you're only interested in the plain text, don't bother with FindFirstHtmlVersion.
 
Share this answer
 
Posted
Comments
paul_vin 6-Mar-18 8:49am    
Its working but when I am assign list values to string variables if null then throwing exception

MSubject = iteam.Subject.ToString(); // if null throwing exception

if I put it into in if block to handle null
if(iteam.Subject.ToString()!=nuul)
{
MSubject = iteam.Subject.ToString();
}

then MSubject variable is not accessible outside
so how can handle this
F-ES Sitecore 6-Mar-18 9:18am    
lol I'm sure I've said this before but I refuse to believe you have written that code but don't understand such basic concepts as variable scope. Your "if" isn't going to work either, you're checking the wrong thing for null. This is technically a different issue so you should post a new question.
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
Why body parser in not parsing the content?
Image not display in gmail message body in mail content
Using mailto to create an email with subject, addresses and body from a database kills the signature
Why is this element not covering the whole height of the body?
showing the html page in the body of emailing.
How to read data response body after success login razor page ?
How can we send mail in HTML body by asp.net. Read below :
Open mail window by filling html content in body
Html IFrame tag is not being interpret in email body
Php mail function - HTML body is not displaying in email

Advertise
Privacy
Cookies
Terms of Use
Last Updated 6 Mar 2018
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web01 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900