private bool UpdatePromotionalPricing(User user, Price price)
{
try
{
UserPrice uPrice = crumbsRepository.FindUserPriceByUserID(user.UserID, price.Type);
if (uPrice == null)
{
// no current promotions for this user - create a new one
UserPrice newUserPrice = new UserPrice()
{
User = user,
Price = price,
Subscribed = 0
};
crumbsRepository.InsertOrUpdateUserPrice(newUserPrice);
}
else if (uPrice.Subscribed == 0)
{
if (uPrice.Price.Expiration < DateTime.Now)
{
// expired promotion found - replace it
uPrice.Price = price;
uPrice.Amount = 0;
uPrice.PaymentID = "";
crumbsRepository.InsertOrUpdateUserPrice(uPrice);
}
else
{
// un-expired promotion found - keep it
return false;
}
}
else
{
// already subscribed - leave it alone
return false;
}
}
catch (Exception ex)
{
Console.WriteLine("Exception is:" + ex.ToString());
return false;
}
return true;
}
public bool SendMail(User user, Mailing mail, Price price, MidiFile file)
{
if (user.Email == null)
return false;
if (price != null)
{
if (UpdatePromotionalPricing(user, price) == false)
return false;
}
try
{
SmtpClient client = new SmtpClient("m02.internetmailserver.net", 587);
client.EnableSsl = false;
MailAddress from = new MailAddress("*****@*****.**", "PianoCrumbs.com");
MailAddress to = new MailAddress(user.Email, "");
MailMessage message = new MailMessage(from, to);
message.Subject = mail.Subject;
message.IsBodyHtml = true;
string fileName = "";
string urlAction = "";
if (file != null)
{
fileName = file.Name;
urlAction = Url.Action("MidiView", "Crumbs", new { id = file.MidiID, name = file.DisplayName }, "http");
}
string latestLinks = "";
IQueryable<MidiFile> latestFiles = crumbsRepository.LatestCrumbs.Take(5);
foreach (var item in latestFiles)
{
string url = Url.Action("MidiView", "Crumbs", new { id = item.MidiID, name = item.DisplayName }, "http");
latestLinks += string.Format("<p><a href='{0}'>{0}</a></p>", url);
}
string popualrLinks = "";
IQueryable<MidiFile> popularFiles = crumbsRepository.RatedCrumbs.Take(5);
foreach (var item in popularFiles)
{
string url = Url.Action("MidiView", "Crumbs", new { id = item.MidiID, name = item.DisplayName }, "http");
popualrLinks += string.Format("<p><a href='{0}'>{0}</a></p>", url);
}
message.Body = string.Format(mail.Text, user.UserName, fileName, urlAction, latestLinks, popualrLinks);
string unsubLink = Url.Action("Unsubscribe", "Account", new { username = user.UserName, reset = CrumbsExtensions.HashResetParams(user.UserName, user.UserKey) }, Request.Url.Scheme);
message.Body += "<p><a href='" + unsubLink + "'>Unsubscribe</a>";
NetworkCredential myCreds = new NetworkCredential("*****@*****.**", "Crumbs123", "");
client.Credentials = myCreds;
client.Send(message);
}
catch (Exception ex)
{
Console.WriteLine("Exception is:" + ex.ToString());
return false;
}
SentMail sent = new SentMail();
sent.UserID = user.UserID;
sent.MailID = mail.ID;
sent.Date = DateTime.Now;
crumbsRepository.InsertOrUpdateSentMail(sent);
crumbsRepository.Save();
return true;
}
