/// ** 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"])) ) ); }