After sending the mail can i save the data in the database

Hi,

I am sending mail through asp.net c# MVC project .i doing through enity freamework, mail is going to sender. i am trying to save the data . could you please tell me how to save the data in asp.net c@ mvc code.

using System.Data.SqlClient;
using System.Net.Mail;
MailMessage email = new MailMessage();
email.To.Add(totxt.Text);
email.From = new MailAddress("frommailid");
email.Body=txtbody.text;
email.IsBodyHtml = false;
SmtpClient smtp = new SmtpClient("smtp.gmail.com", 587);
smtp.UseDefaultCredentials = false;
smtp.EnableSsl = true;
smtp.Credentials = new System.Net.NetworkCredential("[email protected]", "yourpwd");
smtp.Send(email);
SqlConnection sqlCon = new SqlConnection(connectionString);
SqlCommand sqlcmnd = new SqlCommand("Insert Into tablename message values(@message)", sqlCon);
sqlcmnd.Parameters.AddWithValue("@message", txtbody.text);
sqlcmnd.ExecuteNonQuery();

Hi.

After sending mail,create one table and insert data in table using entity framework.

To Know how to insert data using entity fraework you can follow this article,

https://www.aspsnippets.com/Articles/Insert-data-using-Entity-Framework-in-ASPNet-MVC.aspx

Thanks.

Dear Debasis Mohapatra,

Yes, you can.

For that creating one table for store email content and sender details.

E.g.

[EmailNotification]

Id - bigint

EmailId - varchar(100)

EmailBody - nvarchar(max)

CreatedDate - datetime

Status - bit (Store 1 if success else 0 for fail)

ResponseMessage - nvarchar(500) (Store response message of email, success or fail in case of error in sending email)

Write logic for insert entry in this table after sending email funcation.