public static void sendShoppingEmail(int userID, string reminder) { Database myDatabase = new Database(); myDatabase.ReturnConnection(); string command = "SELECT * FROM UserTable Where ID=" + userID + ";"; var reader = myDatabase.ExcuteQuery(command); reader.Read(); User userObj = new User(); userObj.Name = reader["Name"].ToString(); userObj.Email = reader["Email"].ToString(); string message = "Hi, " + userObj.Name + " this is a reminder for you when go shop for food" + System.Environment.NewLine + System.Environment.NewLine + reminder; Email.SendEmail("*****@*****.**", "FoodnStuff@support", userObj.Email, userObj.Name, "Shopping food reminder", message); myDatabase.CloseConnection(); }
public static void sendRemindEmail(int userID) { Database myDatabase = new Database(); myDatabase.ReturnConnection(); string command = "SELECT * FROM UserTable Where ID=" + userID + ";"; var reader = myDatabase.ExcuteQuery(command); reader.Read(); User userObj = new User(); userObj.Name = reader["Name"].ToString(); userObj.Email = reader["Email"].ToString(); List<Ingredient> expiredIngredientList = Model.StorageManagement.GetExpiredIngredient(userID); string message = "Hi, " + userObj.Name + " you have some food will expired today. Take a look" + System.Environment.NewLine + System.Environment.NewLine; foreach (Ingredient ing in expiredIngredientList) { message += ing.Amount + " " + ing.Unit + " " + ing.Name + " Expired day " + ing.ExpiredDay + System.Environment.NewLine; } Email.SendEmail("*****@*****.**", "FoodnStuff@support", userObj.Email, userObj.Name, "Expired food reminder", message); myDatabase.CloseConnection(); }