// GET: Ideas public ActionResult Index() { string conStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString.ToString(); User um = new User(); using (SqlConnection con = new SqlConnection(conStr)) { try { con.Open(); SqlCommand cmd = new SqlCommand("usp_getIdeas", con); cmd.CommandType = CommandType.StoredProcedure; DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds); um.AllIdea = new List <Ideator>(); int numRows = ds.Tables[0].Rows.Count; for (int i = 0; i < numRows; i++) { Ideator idea = new Ideator(); idea.Title = ds.Tables[0].Rows[i]["Title"].ToString(); idea.Description = ds.Tables[0].Rows[i]["Description"].ToString(); um.AllIdea.Add(idea); } } catch (Exception ex) { return(RedirectToAction("Index", "Error")); } } return(View(um)); }
public JsonResult Index(int id) { string conStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString.ToString(); User um = new User(); List <Ideator> useridea = new List <Ideator>(); using (SqlConnection con = new SqlConnection(conStr)) { try { con.Open(); SqlCommand cmd = new SqlCommand("usp_selectUserIdea", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("userID", id); DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds); um.UserIdea = new List <Ideator>(); int numRows = ds.Tables[0].Rows.Count; for (int i = 0; i < numRows; i++) { Ideator idea = new Ideator(); idea.Title = ds.Tables[0].Rows[i]["Title"].ToString(); idea.Description = ds.Tables[0].Rows[i]["Description"].ToString(); idea.IdeasID = Convert.ToInt32(ds.Tables[0].Rows[i]["IdeasID"]); um.UserIdea.Add(idea); } } catch (Exception ex) { throw ex; } return(Json(um, JsonRequestBehavior.AllowGet)); } }
public PartialViewResult GetIdea(int id) { string conStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString.ToString(); User um = new User(); List <Ideator> useridea = new List <Ideator>(); using (SqlConnection con = new SqlConnection(conStr)) { try { con.Open(); SqlCommand cmd = new SqlCommand("usp_selectIdea", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("ideaID", id); DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds); um.UserIdea = new List <Ideator>(); Ideator idea = new Ideator(); idea.Title = ds.Tables[0].Rows[0]["Title"].ToString(); idea.Description = ds.Tables[0].Rows[0]["Description"].ToString(); idea.IdeasID = Convert.ToInt32(ds.Tables[0].Rows[0]["IdeasID"]); um.UserIdea.Add(idea); } catch (Exception ex) { throw ex; } } return(PartialView("UpdateIdea", um)); }