// GET: /Category/Edit public ActionResult Edit(int categoryId) { Debug.WriteLine("in controller " + categoryId); if (categoryId < 0) { //Debug.WriteLine("null"); return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } if (categoryId < 0) { Debug.WriteLine("not found"); return HttpNotFound(); } Category c = new Category(categoryId); return View(c); }
public ActionResult Add(Category c) { if (c == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } if (c == null) { return HttpNotFound(); } if (ModelState.IsValid) { Debug.WriteLine("id = "); c.insertCategory(c); } else { Debug.WriteLine("id != "); return View(c); } return RedirectToAction("Details"); }
public void insertCategory(Category c) { using (MySqlConnection con = new MySqlConnection(con_str)) { con.Open(); using (MySqlCommand cmd = new MySqlCommand("insertNewCategory", con)) { cmd.CommandType = CommandType.StoredProcedure; //params for insert into category cmd.Parameters.AddWithValue("@_catName", c.categoryName); cmd.Parameters.AddWithValue("@_catDescription", c.categoryDescrip); cmd.Parameters.AddWithValue("@_catInUse", c.catInUse); cmd.Parameters.AddWithValue("@_picUrl", c.picURL); cmd.ExecuteNonQuery(); con.Close(); } } }