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