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));
}
