public EmailTemplatesBO GetEmailTemplate(string emailTemplateId)
{
EmailTemplatesBO objEmailTemplatesBO = new EmailTemplatesBO();
try
{
var sqlParams = new SqlParameter[1];
sqlParams[0] = new SqlParameter("@TemplateId", SqlDbType.Int)
{
Value = emailTemplateId
};
DataSet _objDataSet = SqlHelper.SqlHelper.ExecuteDataset(SqlHelper.SqlHelper.Connect(), CommandType.StoredProcedure, "Proc_GetEmailTemplateById", sqlParams);
if (_objDataSet.Tables[0].Rows.Count > 0)
{
var objDataRow = _objDataSet.Tables[0].Rows[0];
objEmailTemplatesBO.EmailTemplate = Convert.ToString(objDataRow["EmailTemplate"]);
objEmailTemplatesBO.EmailSubject = Convert.ToString(objDataRow["EmailSubject"]);
objEmailTemplatesBO.TemplateId = Convert.ToInt32(objDataRow["TemplateId"]);
}
}
catch (Exception ex)
{
log4netlogger.Error(ex);
}
return(objEmailTemplatesBO);
}
public bool Forgotpasswordinfo(string email)
{
bool finalresp = true;
string response = objSellffDefaultDAO.Forgotpasswordinfo(email);
if (!string.IsNullOrEmpty(response))
{
EmailTemplatesBO objEmailTemplatesBO = objSellffDefaultDAO.GetEmailTemplate(ConfigurationManager.AppSettings["ForgotPasswordEmail"].ToString());
try
{
var resarry = response.Split('~');
string emailBody = objEmailTemplatesBO.EmailTemplate;
emailBody = emailBody.Replace("[UserName]", resarry[0]);
emailBody = emailBody.Replace("[NewPwd]", resarry[1]);
SendSMTPEmail(email, objEmailTemplatesBO, emailBody);
}
catch (Exception ex)
{
finalresp = false;
}
}
else
{
finalresp = false;
}
return(finalresp);
}
public bool SendSMTPEmail(string Email, EmailTemplatesBO objEmailTemplatesBO, string EmailBody)
{
String FROM = ConfigurationManager.AppSettings["FROMEmail"].ToString();
String SUBJECT = objEmailTemplatesBO.EmailSubject;
objEmailTemplatesBO.SentTo = Email;
objEmailTemplatesBO.EmailTemplate = EmailBody;
objEmailTemplatesBO.SentFrom = FROM;
objEmailTemplatesBO.BCC = ConfigurationManager.AppSettings["BCCEmail"].ToString();
// Supply your SMTP credentials below. Note that your SMTP credentials are different from your AWS credentials.
String SMTP_USERNAME = ConfigurationManager.AppSettings["SMTPUsername"].ToString(); // Replace with your SMTP username.
String SMTP_PASSWORD = ConfigurationManager.AppSettings["SMTPPassword"].ToString(); // Replace with your SMTP password.
// Amazon SES SMTP host name. This example uses the US West (Oregon) region.
String HOST = ConfigurationManager.AppSettings["SMTPServer"].ToString();
// The port you will connect to on the Amazon SES SMTP endpoint. We are choosing port 587 because we will use
// STARTTLS to encrypt the connection.
int PORT = Convert.ToInt32(ConfigurationManager.AppSettings["SMTPPort"].ToString());
// Create an SMTP client with the specified host name and port.
using (System.Net.Mail.SmtpClient client = new System.Net.Mail.SmtpClient(HOST, PORT))
{
// Create a network credential with your SMTP user name and password.
client.Credentials = new System.Net.NetworkCredential(SMTP_USERNAME, SMTP_PASSWORD);
// Use SSL when accessing Amazon SES. The SMTP session will begin on an unencrypted connection, and then
// the client will issue a STARTTLS command to upgrade to an encrypted connection using SSL.
client.EnableSsl = Convert.ToBoolean(ConfigurationManager.AppSettings["ISSMTPSSL"].ToString());
System.Net.Mail.MailMessage Message = new System.Net.Mail.MailMessage(FROM, Email);
Message.Subject = SUBJECT;
Message.Body = EmailBody;
Message.IsBodyHtml = true;
if (!string.IsNullOrEmpty(ConfigurationManager.AppSettings["BCCEmail"].ToString()))
{
System.Net.Mail.MailAddress bcc = new System.Net.Mail.MailAddress(Convert.ToString(ConfigurationManager.AppSettings["BCCEmail"].ToString()));
Message.Bcc.Add(bcc);
}
// Message.CC = Convert.ToString(ConfigurationManager.AppSettings["CCEmail"].ToString());
// Send the email.
try
{
client.Send(Message);
objEmailTemplatesBO.IsSent = true;
}
catch (Exception ex)
{
objEmailTemplatesBO.IsSent = false;
objEmailTemplatesBO.StatusMessage = ex.Message;
}
finally
{
objSellffDefaultDAO.SaveEmailLogDetails(objEmailTemplatesBO);
}
}
return(true);
}
public void SaveEmailLogDetails(EmailTemplatesBO objEmailTemplatesBO)
{
try
{
var sqlParams = new SqlParameter[10];
sqlParams[0] = new SqlParameter("@TemplateId", SqlDbType.Int)
{
Value = objEmailTemplatesBO.TemplateId
};
sqlParams[1] = new SqlParameter("@EmailSubject", SqlDbType.VarChar)
{
Value = objEmailTemplatesBO.EmailSubject
};
sqlParams[2] = new SqlParameter("@EmailTemplate", SqlDbType.VarChar)
{
Value = objEmailTemplatesBO.EmailTemplate
};
sqlParams[3] = new SqlParameter("@SentFrom", SqlDbType.VarChar)
{
Value = objEmailTemplatesBO.SentFrom
};
sqlParams[4] = new SqlParameter("@SentTo", SqlDbType.VarChar)
{
Value = objEmailTemplatesBO.SentTo
};
sqlParams[5] = new SqlParameter("@CC", SqlDbType.VarChar)
{
Value = objEmailTemplatesBO.CC
};
sqlParams[6] = new SqlParameter("@BCC", SqlDbType.VarChar)
{
Value = objEmailTemplatesBO.BCC
};
sqlParams[7] = new SqlParameter("@UserId", SqlDbType.Int)
{
Value = objEmailTemplatesBO.UserId
};
sqlParams[8] = new SqlParameter("@StatusMessage", SqlDbType.VarChar)
{
Value = objEmailTemplatesBO.StatusMessage
};
sqlParams[9] = new SqlParameter("@IsSent", SqlDbType.Bit)
{
Value = objEmailTemplatesBO.IsSent
};
SqlHelper.SqlHelper.ExecuteNonQuery(SqlHelper.SqlHelper.Connect(), CommandType.StoredProcedure, "Proc_SaveEmailLog", sqlParams);
}
catch (Exception ex)
{
log4netlogger.Error(ex);
}
}
public bool UpdateUserInvitationSentDate(string InviteGuid)
{
InviteUsersBO objResponseBO = objSellffDefaultDAO.UpdateUserInvitationSentDate(InviteGuid);
EmailTemplatesBO objEmailTemplatesBO = objSellffDefaultDAO.GetEmailTemplate(ConfigurationManager.AppSettings["InviteEmail"].ToString());
try
{
SendEmail(objResponseBO.EmailId, objResponseBO.Name, objResponseBO.InviteGuid, ConfigurationManager.AppSettings["InitationURL"].ToString(), objEmailTemplatesBO, objResponseBO.RefereUserName);
}
catch (Exception ex)
{
}
return(true);
}
public AuthenticationBO RegisterSellffUserInfo(AuthenticationBO objAuthenticationBO)
{
AuthenticationBO objResponseBO = objSellffDefaultDAO.RegisterSellffUserInfo(objAuthenticationBO);
if (objAuthenticationBO.InviteGuid == "")
{
EmailTemplatesBO objEmailTemplatesBO = objSellffDefaultDAO.GetEmailTemplate(ConfigurationManager.AppSettings["RegEmail"].ToString());
try
{
SendEmail(objResponseBO.Email, objResponseBO.DisplayName, objResponseBO.InviteUniqueId, ConfigurationManager.AppSettings["ActivateAppDomain"].ToString(), objEmailTemplatesBO, "");
}
catch (Exception ex)
{
}
}
return(objResponseBO);
}
