public static EmailTemplate GetEmailTemplate(string name)
{
var context = new SimplicityEntities();
var query = from c in context.EmailTemplates where c.Name == name select c;
if (query.Any())
{
return query.FirstOrDefault();
}
return null;
}
public static User GetLoggedInCustomer()
{
if (HttpContext.Current.Session[WebConstants.Session.USER_ID] != null)
{
int userId = (int)HttpContext.Current.Session[WebConstants.Session.USER_ID];
var context = new SimplicityEntities();
var query = from c in context.Users where (c.UserID == userId) select c;
if (query.Any())
{
return query.FirstOrDefault();
}
}
return null;
}
public static void SendViewDemoEmailToUser(string email)
{
MailMessage message = new MailMessage();
message.To.Add(new MailAddress(email));
message.IsBodyHtml = true;
var context = new SimplicityEntities();
var settings = (from c in context.Settings where c.SettingGroup == "ViewDemo" select c).ToList();
foreach(var n in settings)
{
if (n.SettingKey == "EmailSubject")
{
message.Subject = n.SettingValue;
}
else if (n.SettingKey == "EmailContents")
{
message.Body = n.SettingValue;
}
}
SendEmail(message);
}
public static void SendEmail(MailMessage message)
{
try
{
var context = new SimplicityEntities();
string toEmails = "";
string toNames = "";
foreach (MailAddress address in message.To)
{
toNames += address.DisplayName + ",";
toEmails += address.Address + ",";
}
EmailQueue ta = new EmailQueue{LogTime=DateTime.Now,NumOfTries=1, FromName="Simplicity4Business", FromAddress=FROM_ADDRESS,
ToNames=toNames.Substring(0, toNames.Length - 1), ToAddresses=toEmails.Substring(0, toEmails.Length),
Subject=message.Subject, Body=message.Body, SentTime=null};
}
catch (Exception ex)
{
}
}
