// GET: Food_Item/Edit/5 public ActionResult Edit(int id) { Food_ItemModel fooditemModel = new Food_ItemModel(); DataTable dtblFood = new DataTable(); using (SqlConnection sqlCon = new SqlConnection(connectionString)) { sqlCon.Open(); string query = "SELECT * FROM [dbo].[dbo.Food_item] WHERE item_id = @ItemId"; SqlDataAdapter sqlDa = new SqlDataAdapter(query, sqlCon); sqlDa.SelectCommand.Parameters.AddWithValue("@ItemId", id); sqlDa.Fill(dtblFood); } if (dtblFood.Rows.Count == 1) { fooditemModel.item_id = Convert.ToInt32(dtblFood.Rows[0][0].ToString()); fooditemModel.item_name = dtblFood.Rows[0][1].ToString(); fooditemModel.item_price = Convert.ToDecimal(dtblFood.Rows[0][2].ToString()); return(View(fooditemModel)); } else { return(RedirectToAction("Index")); } }
public ActionResult Create(Food_ItemModel fooditemModel) { using (SqlConnection sqlCon = new SqlConnection(connectionString)) { sqlCon.Open(); string query = "INSERT INTO [dbo].[dbo.Food_item] values (@Item_name,@Item_price)"; SqlCommand sqlCmd = new SqlCommand(query, sqlCon); sqlCmd.Parameters.AddWithValue("@Item_name", fooditemModel.item_name); sqlCmd.Parameters.AddWithValue("@Item_price", fooditemModel.item_price); sqlCmd.ExecuteNonQuery(); } return(RedirectToAction("Index")); }
public ActionResult Edit(Food_ItemModel food_ItemModel) { using (SqlConnection sqlCon = new SqlConnection(connectionString)) { sqlCon.Open(); string query = "UPDATE [dbo].[dbo.Food_item] SET item_name = @ItemName, item_price = @ItemPrice WHERE item_id = @ItemId"; SqlCommand sqlcmd = new SqlCommand(query, sqlCon); sqlcmd.Parameters.AddWithValue("@ItemId", food_ItemModel.item_id); sqlcmd.Parameters.AddWithValue("@ItemName", food_ItemModel.item_name); sqlcmd.Parameters.AddWithValue("@ItemPrice", food_ItemModel.item_price); sqlcmd.ExecuteNonQuery(); } return(RedirectToAction("Index")); }