/// ** VALUES SET **
/// After 14 day since a transaction has occured set the following:
/// PostTable: IsActive = 0, IsTransacting = 0 [for each participant]
/// Transaction Table: IsActive = 0, confirmed = 3
///
public static void AutoConfirmTransaction()
{
DataAccess da = new DataAccess();
DataTable dt = da.ExecuteStoredProc("AutoConfirmTransaction");
dt.AsEnumerable().ToList().ForEach(x =>
AutoConfirmEmails(
Convert.ToString(x["BuyerEmail"]),
Convert.ToString(x["Buyer"]),
Convert.ToString(x["SellerEmail"]),
Convert.ToString(x["Seller"])
)
);
}
public static void commentReminderMail()
{
DataAccess da = new DataAccess();
DataTable dt = da.ExecuteStoredProc("getUsersToEmail");
dt.AsEnumerable().ToList().ForEach(x =>
EmailUtility.SendEmail(
Convert.ToString(x["UserName"]),
Convert.ToString(x["DisplayName"]),
String.Format("{0} has sent you a message! ",
Convert.ToString(x["Commentor_DisplayName"])),
String.Format("{0} has sent you a message: <br/> '{1}'",
Convert.ToString(x["Commentor_DisplayName"]),
Convert.ToString(x["Comment"]))
)
);
}
