public bool SaveNewHotspot(AdminNewHotspotModel addHotspot) { try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO add_hotspots VALUES (@title, @description, @mediaTypes, @url);", conn); cmd.Parameters.AddWithValue("@title", addHotspot.Title); cmd.Parameters.AddWithValue("@description", addHotspot.Description); cmd.Parameters.AddWithValue("@mediaType", addHotspot.MediaType); cmd.Parameters.AddWithValue("@url", addHotspot.URL); cmd.ExecuteNonQuery(); return(true); } } catch (SqlException) { return(false); } }
public ActionResult AddHotspotResult(AdminNewHotspotModel addHotspot) { return(View("AddHotspotResult")); }
public ActionResult AddHotspot(AdminNewHotspotModel addHotspot) { bool success = dal.SaveNewHotspot(addHotspot); return(RedirectToAction("AddHotspotResult", success)); }