Send Html Mail in Console application

Question

4.38/5 (5 votes)

See more:

i have created a console application to send mail now i have html templates
i am getting data from database according to user now how to bind this data in html.
my code is

C#

private static void Main(string[] args)
        {
            // Get All User
            var userList = BLLMailAlert.GetAllSubscribedUser();
            // Send UserID as Parameter and Find Tenders For Users
            foreach (var user in userList)
            {
                BLLMailAlert.GetAllTenderForPaidUser(user.UserID);

                // For Each AlertId Find Template Name and EmailId
                foreach (var usr in userList)
                {
                    var detail = BLLMailAlert.GetUserAllDetail(usr.AlertID);

                    // According to TemplateName FIND Template and Write Tender in that Template
                    switch (usr.UserTypeTemplate.TemplateType.TemplateTypeName)
                    {
                        case "TemplateForPaidUser.htm":
                        {
                            // Send Template in Mail To Each User
                            var fromEmail = string.Empty;
                            var toEmail = string.Empty;
                            toEmail = usr.Email;
                            fromEmail = Convert.ToString(ConfigurationManager.AppSettings["adminmail"]);
                            const string TemplatePath = "[Path to resource]";
                            var mailContent = new StreamReader(TemplatePath).ReadToEnd();
                            mailContent += detail;
                            BLLMailAlert.SendTenderAlert(fromEmail, toEmail, mailContent);
                        }

                            break;
                    }
                }
            }
        }

 //function to send mail
// I have Class named Mail which i am using to send mail
public static bool SendTenderAlert(string fromEmail, string toEmail, string mailContent)
        {
            try
            {
                var currentDate = System.DateTime.Now.Date;
                Mail.SendHtmlMail(fromEmail, toEmail, "TenderKhabar | Fresh Tenders Of |" + currentDate, mailContent);
                return true;
            }
            catch
            {
                return false;
            }
        }

Posted 26-Nov-13 18:47pm

V1CT0R.

Updated 26-Nov-13 20:42pm

v2

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 27-Nov-13 2:33am

Can you post the SendTenderAlert function code? What is the problem there?

V1CT0R. 27-Nov-13 2:39am

function SendTenderAlert is just for sending mail the problem is how to write data in html template which i am getting in var detail = BLLMailAlert.GetUserAllDetail(usr.AlertID);

V1CT0R. 27-Nov-13 2:48am

Like if there are only few fields i can append it in string builder but the detail i am getting is List and i can't use gridview as i am working on console application

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 27-Nov-13 4:22am

You can make one html table by looping through the results.

2 solutions

Solution 1

You can try somthing like this to mak your mail body nice ...... :D

C#

string GetBody()
{
   string PreDefinedMailFormat = @"<html>
                                <head>
                                    <title></title>
                                </head>
                                <body>
                                    <div>
                                        <span style='font-size:12px;'><span style='font-family:verdana,geneva,sans-serif;'>Hi {1} {2},</span></span></div>
                                    <div>
                                        &nbsp;</div>
                                    <div>
                                        <span style='font-size:12px;'><span style='font-family:verdana,geneva,sans-serif;'><strong>Congratulations!</strong> {0} has received and accepted your invitation.</span></span></div>
                                    <div>
                                </body>
                            </html>
                            ";

   string MailReceiverFName = "Moumit";
   string MailReceiverLName = "Mondal";
   string MailSenderName = "KAKA";

            //Final mail body
   string MailBody = string.Format(PreDefinedMailFormat, MailSenderName, MailReceiverFName, MailReceiverLName);
   return MailBody;
}

Posted 26-Nov-13 23:06pm

Moumit Mondal

Updated 26-Nov-13 23:10pm

v3

Comments

V1CT0R. 27-Nov-13 5:40am

@Moumit Mondal the problem is i am getting data in List so i need something like gridview in Console application

Moumit Mondal 28-Nov-13 5:30am

Whys that??? Sorry @V1CT0R. your problem is not clear to me ... :(

V1CT0R. 28-Nov-13 10:58am

well suppose I am getting a List Of Customer in That List there are approx 15-20 Customer
and each user has some details like 6 or 7 fields now as we can bind them simply in GridView
by DataBind method and write the table column's name BoundField's DataField I want to do similar thing in Console application........

Moumit Mondal 29-Nov-13 8:23am

In that case it's out of my hands :( ... I did not worked in console ... But if you wish then can use trick like this...

void ShowData(DataTable dt)
{

foreach (DataColumn item in dt.Columns)
{
Console.Write(item.ColumnName);
Console.Write("\t");
}

Console.Write(Environment.NewLine);

for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 0; j < dt.Columns.Count; j++)
{
Console.Write(dt.Rows[i][j]);
Console.Write("\t");
}
Console.Write(Environment.NewLine);
}

Console.ReadKey();
}

Vishal Pand3y 30-Nov-13 9:19am

its better to use HTML template rather than saving Template in database

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Vishal Pand3y · Accepted Answer · 2013-11-30T03:12:00

Hey Victor
To Send HTML Template in Console Application You Can use String Builder and StreamReader and try to Append and replace the Content For more Detail See this StringBuilder.Append Method and StringBuilder.Replace Method
So your Code will be Like

C#

//create String Builder
var sbMail = new StringBuilder();
//for iteration You can use foreach 
foreach(--Your Condition--)
{
  using (var sReader = new StreamReader(TemplatePath))
   {
     sbMail.Append(sReader.ReadToEnd());
     sbMail.Replace("{YourTitle}", DataSource.YourTitle);
     .............
     sbMail.Append("br/");
   }
}

now in html template
try something Like that

<table>>
<tr>
  <td>
     {YourTitle}
  </td>
</tr>
</table>

that will replace {YourTitle} and Append the next {YourTitle} in the Mail
Hop That Helps..........