Skip to main content

Send mail in asp.net

Send mail in asp.net

public bool sendEMail(string leavs, string uniqueCode)
        {
            try
            {
                //string subject = "";
                string emailMsg = "";
                LeavePersistence objLeavePersistence = new LeavePersistence();

                System.Net.Mail.MailMessage Msg = new System.Net.Mail.MailMessage();
                // Msg.From = new MailAddress(currentEmailId);

                Msg.From = new MailAddress(ConfigurationManager.AppSettings["Sender"].ToString());

                DataSet ds = objLeavePersistence.GetEmailContentByEmpId(uniqueCode, "Leave2");
                DataTable dtemail = ds.Tables[1];
                // DataTable dtemailDetails = ds.Tables[2];
                DataTable dtemailid = ds.Tables[0];



                emailMsg = dtemail.Rows[0]["Email_message"].ToString();

                if (ds.Tables[0].Rows.Count > 0)
                {
                    Msg.Subject = "Leave Cancellation";

                    emailMsg = emailMsg.Replace("[ Leave Title]", "Cancel Leaves")
                        .Replace("[Dates]", leavs);

                }
                //  Msg.To.Add("puneet.kumar@jsimple.net");


                Msg.To.Add(dtemailid.Rows[0]["email"].ToString());


                SmtpClient smtp = new SmtpClient();
                Msg.IsBodyHtml = true;
                Msg.Body = emailMsg;
                // Msg.CC.Add(ConfigurationManager.AppSettings["CCAddress"].ToString());

                smtp.EnableSsl = true;
                smtp.Host = Convert.ToString(ConfigurationManager.AppSettings["SMTPHost"]);
                smtp.Port = Convert.ToInt32(ConfigurationManager.AppSettings["SMTPPort"]);
                smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
                smtp.Credentials = new System.Net.NetworkCredential(Convert.ToString(ConfigurationManager.AppSettings["SMTPUserId"]), Convert.ToString(ConfigurationManager.AppSettings["SMTPPassword"]));
                smtp.Send(Msg);

                return true;
            }
            catch (Exception ex)
            {
                throw ex;
                //return false; 
            }
        }

Comments

Popular posts from this blog

Convert row to column

Convert rows to column select * from (   select distinct  lm.LeaveDescription, lb.EmpId, usr.UserId,   usr.UserFirstName +' ' + usr.UserLastName as EmpName, [dbo].[GetBalanceLeave](lb.EmpId, lb.LeaveType) as BalanceLeave       from Leave_BalanceLeave lb       left join  tm_User usr on usr.EmpId=lb.EmpId     inner join Leave_Master lm on lm.LeaveId = lb.LeaveType ) as src pivot (   sum(BalanceLeave)   for LeaveDescription in ([Casual Leave], [Earned Leave], [Sick Leave],[Compensatory Off]) ) as piv;

Download Customize pdf and excel

Convert rows to column select * from (   select distinct  lm.LeaveDescription, lb.EmpId, usr.UserId,   usr.UserFirstName +' ' + usr.UserLastName as EmpName, [dbo].[GetBalanceLeave](lb.EmpId, lb.LeaveType) as BalanceLeave       from Leave_BalanceLeave lb       left join  tm_User usr on usr.EmpId=lb.EmpId     inner join Leave_Master lm on lm.LeaveId = lb.LeaveType ) as src pivot (   sum(BalanceLeave)   for LeaveDescription in ([Casual Leave], [Earned Leave], [Sick Leave],[Compensatory Off]) ) as piv;