public ActionResult Edit(decimal id) { BusinessLayer.FoodGroup fooditem = dbset.FoodGroups.Single(emp => emp.FoodGroupId == id); if (fooditem == null) { return(HttpNotFound()); } return(View(fooditem)); }
//[ValidateAntiForgeryToken] public ActionResult Edit(BusinessLayer.FoodGroup fooditem) { if (ModelState.IsValid) { dbset.SaveChangesFoodGroupToDB(fooditem); //db.Entry(fooditem).State = EntityState.Modified; //db.SaveChanges(); return(RedirectToAction("Index")); } return(View(fooditem)); }
//[ActionName("Create")] //[ValidateAntiForgeryToken] public ActionResult Create(BusinessLayer.FoodGroup fooditem)//Create(FormCollection formCollection) { if (ModelState.IsValid) { dbset.AddFoodGroupToDB(fooditem); return(RedirectToAction("Index")); } //ViewBag.FoodGroupId = new SelectList(dbset.FoodGroups, "FoodGroupId", "FoodGroupName"); return(View()); }
public void AddFoodGroupToDB(FoodGroup employee) { using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("spAddFoodGroup", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter paramFoodName = new SqlParameter(); paramFoodName.ParameterName = "@FoodName"; paramFoodName.Value = employee.FoodGroupName; cmd.Parameters.Add(paramFoodName); con.Open(); cmd.ExecuteNonQuery(); } }