protected void Page_Load(object sender, EventArgs e) { usernameCheck(); taFoods = new FoodTrackerDataTableAdapters.FoodsTableAdapter(); dtFoods = new FoodTrackerData.FoodsDataTable(); taContains = new FoodTrackerDataTableAdapters.ContainsTableAdapter(); }
protected void btnEmail_Click(object sender, EventArgs e) { dtMeals = taMeals.getMealsbyFoodID(foodID); if (dtMeals.Count > 0) { dtFood = taFood.getFoodByFoodID(foodID); FoodTrackerData.FoodsRow rowFood = dtFood[0]; FoodTrackerData.MealsRow rowMeals; String strRecipe = "You need a recipe first"; rowMeals = dtMeals[0]; strRecipe = rowMeals["recipe"].ToString(); SmtpClient m_clientSmtp; //setup smtp client m_clientSmtp = new SmtpClient("smtp.gmail.com"); m_clientSmtp.Port = 587; m_clientSmtp.UseDefaultCredentials = false; m_clientSmtp.Credentials = new NetworkCredential("foodtracker123", "foodtracker1234"); m_clientSmtp.EnableSsl = true; //setup mail MailMessage msgMail = new MailMessage(); msgMail.From = new MailAddress("*****@*****.**"); msgMail.Subject = "[FoodTracker]Your Recipe is here! The recipe for " + rowFood["foodName"].ToString() + " from " + username; msgMail.Body = strRecipe; //send test ads msgMail.To.Add(boxEmail.Text); m_clientSmtp.Send(msgMail); msgMail.To.Clear(); } }
protected void btnAddFood_Click(object sender, EventArgs e) { String food = FoodName.Text; String quantity = Quantity.Text; String storageEnvironment = StorageEnvironment.Text; taFoods.AddFood(food, quantity, storageEnvironment); dtFoods = taFoods.getAllFoods(); FoodTrackerData.FoodsRow rowFood = dtFoods[dtFoods.Count - 1]; String strFoodID = rowFood["foodID"].ToString(); int FoodID = Convert.ToInt32(strFoodID); taContains.insertIntoContains(username, FoodID); Response.Redirect("FoodForm.aspx"); }
protected void Page_Load(object sender, EventArgs e) { usernameCheck(); String strFoodID = Request.QueryString["foodID"].ToString(); foodID = Convert.ToInt32(strFoodID); taMeals = new FoodTrackerDataTableAdapters.MealsTableAdapter(); dtMeals = new FoodTrackerData.MealsDataTable(); taFood = new FoodTrackerDataTableAdapters.FoodsTableAdapter(); dtFood = new FoodTrackerData.FoodsDataTable(); if (!IsPostBack) { dtMeals = taMeals.getMealsbyFoodID(foodID); if (dtMeals.Count > 0) { FoodTrackerData.MealsRow rowMeals = dtMeals[0]; boxRecipe.Text = rowMeals["recipe"].ToString(); } } }