/// <summary>
/// Connects to database and save email for subscribing.
/// </summary>
public async Task <int> SaveEmailSubscriber(NL_UserInfo objInfo)
{
try
{
List <SQLParam> Param = new List <SQLParam>
{
new SQLParam("@SubscriberID", objInfo.SubscriberID),
new SQLParam("@SubscriberEmail", objInfo.SubscriberEmail),
new SQLParam("@ClientIP", objInfo.ClientIP),
new SQLParam("@FirstName", objInfo.FirstName),
new SQLParam("@LastName", objInfo.LastName),
new SQLParam("@Location", objInfo.Location),
new SQLParam("@Gender", (int)objInfo.Gender),
new SQLParam("@InterestInAll", objInfo.InterestInAll),
new SQLParam("@Interest", objInfo.Interest),
new SQLParam("@IsImported", objInfo.IsImported),
new SQLParam("@RecipientGroup", objInfo.RecipientGroup),
new SQLParam("@CompanyName", objInfo.CompanyName),
new SQLParam("@PhoneNumber", objInfo.PhoneNumber),
new SQLParam("@Profession", objInfo.Profession),
new SQLParam("@Source", objInfo.Source),
new SQLParam("@AddedBy", objInfo.AddedBy)
};
SQLExecuteNonQueryAsync sqlh = new SQLExecuteNonQueryAsync();
return(await sqlh.ExecuteNonQueryAsync("[dbo].[usp_Wb_Mail_NL_Subscriber_Add]", Param, "@OpStatus"));
}
catch
{
throw;
}
}
public async Task <int> SaveEmailSubscriber(NL_UserInfo objInfo)
{
try
{
NL_Provider cont = new NL_Provider();
return(await cont.SaveEmailSubscriber(objInfo));
}
catch
{
throw;
}
}
public async Task SendMailToUser(string Email)
{
NL_UserInfo _UserInfo = await this.GetByEmail(Email);
if (_UserInfo != null)
{
Cbuilder.EmailTemplate.EmailTemplate mail = await _emailTemplate.GetByIdentifier("subscription-65F1A79A");
//string hostURL = TokenController.GetCurrnetHostURL();
if (mail != null)
{
List <TokenKeyValue> lstToken = new List <TokenKeyValue>
{
new TokenKeyValue {
Key = MailToken.FirstName, Value = _UserInfo.FirstName
},
new TokenKeyValue {
Key = MailToken.LastName, Value = _UserInfo.LastName
},
new TokenKeyValue {
Key = MailToken.Email, Value = _UserInfo.SubscriberEmail
},
new TokenKeyValue {
Key = MailToken.UnsubscribeLink, Value = _UserInfo.UniqueCode
},
new TokenKeyValue {
Key = MailToken.UserName, Value = string.Empty
},
new TokenKeyValue {
Key = MailToken.CurrnetHostURL, Value = ""
}
};
mail.ViewDOM = _emailTemplate.ReplaceToken(mail.ViewDOM, lstToken);
string AdminMail = /*pagebase.GetSettingValueByIndividualKey(SageFrameSettingKeys.PortalAdminEmail)*/ "";
_emailSender.SendEmailAsync(_UserInfo.SubscriberEmail, mail.Subject, mail.ViewDOM);
}
}
}