// GET: Account public ActionResult Index() { if (Session["userId"] is null) { return(RedirectToAction("NotFound", "Home", new { id = "User not logged in" })); } UserBll userBll = new UserBll(); MVCPAP.Models.User user = userBll.GetUserById(Session["userId"].ToString()); VideoBll videoBll = new VideoBll(); ViewBag.videos = videoBll.GetVideosByUserId(Session["userId"].ToString()); return(View(user)); }
public ActionResult profile(string id) { if (!id.Contains("-")) { Response.Redirect("PageNotFound..."); } int discriminator = int.Parse(id.Split('-')[0]); string username = id.Split('-')[1]; // SqlConnection connection = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=PAP1;Integrated Security=True"); // SqlDataAdapter dataAdapter = new SqlDataAdapter( //"SELECT * FROM [User] Where username='******' And discriminator=" + discriminator, connection); // DataSet dataSet = new DataSet(); // dataAdapter.Fill(dataSet); // if(dataSet.Tables[0].Rows.Count<=0) // { // throw new Exception("User not found"); // } // _User user = new _User(); // user.email = dataSet.Tables[0].Rows[0]["email"].ToString(); // user.username = username; // user.discriminator = discriminator; // user.profilePicture = dataSet.Tables[0].Rows[0]["profilePicture"].ToString(); // user.password = dataSet.Tables[0].Rows[0]["password"].ToString(); UserBll userBll = new UserBll(); try { ViewBag.user = userBll.GetUserById(id); } catch (Exception ex) { return(RedirectToAction("NotFound", "Home", new { message = ex.Message })); } // SqlDataAdapter dataAdapter2 = new SqlDataAdapter( //"SELECT * FROM Video Where username='******' And discriminator='" + discriminator + "'", connection); // DataSet dataSet2 = new DataSet(); // dataAdapter2.Fill(dataSet2); // List<_Video> Videos = new List<_Video>(); // foreach (DataRow row in dataSet2.Tables[0].Rows) // { // _Video V = new _Video(); // V.id = int.Parse(row["id"].ToString()); // V.title = row["title"].ToString(); // V.username = row["username"].ToString(); // V.discriminator = int.Parse(row["discriminator"].ToString()); // V.videoFile = row["videoFile"].ToString(); // V.thumbnail = row["thumbnail"].ToString(); // Videos.Add(V); // } VideoBll videoBll = new VideoBll(); ViewBag.Videos = videoBll.GetVideosByUserId(id); return(View()); }