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

Question

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.

Mageshwaran R · Answer

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( "yourmailid@gmail.com" , "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();

Salman Beg · Answer

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.

Malvik Bhavsar · Answer

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.