protected void food_drifters_menu(FoodDriftersdb db) { food_menu.InnerHtml = ""; string searchkey = ""; string query = "select * from foodblogpages"; if (searchkey != "") { query += " WHERE foodblogtitle like '%" + searchkey + "%' "; query += " or chefname like '%" + searchkey + "%' "; query += " or foodblogbody like '%" + searchkey + "%' "; } List <Dictionary <String, String> > rs = db.List_Query(query); foreach (Dictionary <String, String> row in rs) { food_menu.InnerHtml += "<div class=\"listitem\">"; string foodblogid = row["foodblogid"]; string foodblogtitle = row["foodblogtitle"]; food_menu.InnerHtml += "<a href=\"ShowFoodBolg.aspx? foodblogid = " + foodblogid + "\">" + foodblogtitle + "</a>"; } }
protected void ShowFoodBlogInfo(FoodDriftersdb db) { bool valid = true; string foodblogid = Request.QueryString["foodblogid"]; if (String.IsNullOrEmpty(foodblogid)) { valid = false; } if (valid) { Debug.WriteLine("show the data"); FoodBlog foodblog_record = db.FindFoodBlog(Int32.Parse(foodblogid)); foodblogtitle.Text = foodblog_record.GetFoodBlogTitle(); chefname.Text = foodblog_record.GetChefName(); foodblogbody.Text = foodblog_record.GetFoodBlogBody(); } if (!valid) { ErrorBox.InnerHtml = "There was an error finding that foodblog."; } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { FoodDriftersdb db = new FoodDriftersdb(); ShowFoodBlogInfo(db); } }
//delete the record protected void Delete_FoodBlog(object sender, EventArgs e) { bool valid = true; string foodblogid = Request.QueryString["foodblogid"]; if (String.IsNullOrEmpty(foodblogid)) { valid = false; } FoodDriftersdb db = new FoodDriftersdb(); //deleting the foodblog from the system if (valid) { db.DeleteFoodBlog(Int32.Parse(foodblogid)); Response.Redirect("FoodBlogList.aspx"); } }
protected void Add_Recipe(object sender, EventArgs e) { FoodDriftersdb db = new FoodDriftersdb(); //create a new particular FoodBlog FoodBlog new_recipe = new FoodBlog(); //set that FoodBlog data new_recipe.SetFoodBlogTitle(foodblogtitle.Text); new_recipe.SetChefName(chefname.Text); new_recipe.SetFoodBlogBody(foodblogbody.Text); //add the food blog to the database db.AddFoodBlog(new_recipe); Response.Redirect("FoodBlogList.aspx"); }
protected void Update_FoodBlog(object sender, EventArgs e) { Debug.WriteLine("Please allow me to update"); FoodDriftersdb db = new FoodDriftersdb(); bool valid = true; string foodblogid = Request.QueryString["foodblogid"]; if (String.IsNullOrEmpty(foodblogid)) { valid = false; } if (valid) { FoodBlog new_foodblog = new FoodBlog(); //set that food blog data new_foodblog.SetFoodBlogTitle(foodblogtitle.Text); new_foodblog.SetChefName(chefname.Text); new_foodblog.SetFoodBlogBody(foodblogbody.Text); //add the food blog to the database try { db.UpdateFoodBlog(Int32.Parse(foodblogid), new_foodblog); Response.Redirect("ShowFoodBolg.aspx?foodblogid=" + foodblogid); } catch { valid = false; } } if (!valid) { foodblog.InnerHtml = "There was an error updating that student."; } }
protected void Page_Load(object sender, EventArgs e) { foodblogs_result.InnerHtml = ""; string searchkey = ""; if (Page.IsPostBack) { searchkey = blog_search.Text; } string query = "select * from foodblogpages"; if (searchkey != "") { query += " WHERE foodblogtitle like '%" + searchkey + "%' "; query += " or chefname like '%" + searchkey + "%' "; query += " or foodblogbody like '%" + searchkey + "%' "; } var db = new FoodDriftersdb(); List <Dictionary <String, String> > rs = db.List_Query(query); foreach (Dictionary <String, String> row in rs) { foodblogs_result.InnerHtml += "<div class=\"listitem\">"; string foodblogid = row["foodblogid"]; string foodblogtitle = row["foodblogtitle"]; foodblogs_result.InnerHtml += "<div class=\"col2\"><a href=\"ShowFoodBolg.aspx?foodblogid=" + foodblogid + "\">" + foodblogtitle + "</a></div>"; string chefname = row["chefname"]; foodblogs_result.InnerHtml += "<div class=\"col2\">" + chefname + "</div>"; string foodblogbody = row["foodblogbody"]; foodblogs_result.InnerHtml += "<div class=\"col2last\">" + foodblogbody + "</div>"; } }
protected void Page_Load(object sender, EventArgs e) { FoodDriftersdb db = new FoodDriftersdb(); food_drifters_menu(db); }