public ActionResult commentlist() { p.onTable = "Fetch_Comment_Data"; ds = dl.FetchMaster(p); List <Account_Data> commentlist = new List <Account_Data>(); try { foreach (DataRow i in ds.Tables[0].Rows) { Account_Data pa = new Account_Data(); pa.comment_id = i["comment_id"].ToString(); pa.user_id = i["user_id"].ToString(); pa.comment = i["comment"].ToString(); pa.Date = Convert.ToDateTime(i["Date"]).ToString("dd-MM-yyy"); pa.videoid = "https://www.youtube.com/embed/" + i["videoid"].ToString(); pa.Status = i["Status"].ToString(); pa.Name = i["Name"].ToString(); commentlist.Add(pa); } ViewBag.commentlist = commentlist; } catch (Exception ex) { } return(View()); }
// GET: blog public ActionResult Index() { p.onTable = "Home_Data"; ds = dl.FetchMaster(p); List <blogdata> bloglist = new List <blogdata>(); try { foreach (DataRow i in ds.Tables[0].Rows) { blogdata cs = new blogdata(); cs.blogid = i["blogid"].ToString(); cs.title = i["title"].ToString(); cs.image = i["image"].ToString(); cs.videourl = i["videourl"].ToString(); cs.discription = i["discription"].ToString(); cs.status = i["status"].ToString(); cs.blogdate = Convert.ToDateTime(i["blogdate"]).ToString("dd-MM-yyy"); bloglist.Add(cs); } ViewBag.bloglist = bloglist; } catch (Exception ex) { } return(View()); }
public ActionResult login(Account_Data Au) { var videoid = TempData["mi"]; var bloid = TempData["blogid"]; var urllink = TempData["blogurl"]; p.Condition1 = Au.Email; p.Condition2 = Au.Paasword; p.onTable = "Fetch_Login"; ds = dl.FetchMaster(p); try { if (ds.Tables[0].Rows.Count > 0) { HttpCookie loginCookie = Request.Cookies["crystalthoughts"]; String Type = ds.Tables[0].Rows[0]["UserType"].ToString(); String Status = ds.Tables[0].Rows[0]["Status"].ToString(); if (Status == "True") { loginCookie = new HttpCookie("crystalthoughts"); loginCookie["Account_id"] = enc.Encrypt(ds.Tables[0].Rows[0]["Account_id"].ToString()); loginCookie["Name"] = enc.Encrypt(ds.Tables[0].Rows[0]["Name"].ToString()); loginCookie["UserType"] = enc.Encrypt(ds.Tables[0].Rows[0]["UserType"].ToString()); loginCookie["Status"] = enc.Encrypt(ds.Tables[0].Rows[0]["Status"].ToString()); Response.Cookies.Add(loginCookie); if (videoid.ToString() == "blog") { return(Redirect("/blog/details/" + bloid + "/" + urllink)); } else { return(Redirect("/video/details/" + videoid)); } } else { TempData["MSGlogin"] = "******"; return(Redirect("/Home")); } } } catch (Exception ex) { } return(View()); }
public ActionResult details(string id) { TempData["videoid"] = id; var info = new crystalthoughts.Models.Videolist(); try { YouTubeService yt = new YouTubeService(new BaseClientService.Initializer() { ApiKey = "AIzaSyCcuv08bsWw3YwAgK3Aah2cv2BoL2lAH_Q" }); var searchListRequest = yt.Search.List("snippet"); searchListRequest.ChannelId = "UCyk2f2QGr2LEjLNopAcy6qA"; var searchListResult = searchListRequest.Execute(); foreach (var item in searchListResult.Items) { if (item.Id.VideoId != null) { if (id == item.Id.VideoId) { info.Title = item.Snippet.Title; info.Description = item.Snippet.Description; info.Video = "https://www.youtube.com/embed/" + item.Id.VideoId; info.Videoid = item.Id.VideoId; info.Videoimage = item.Snippet.Thumbnails.High.Url; } } } } catch (Exception ex) { } p.onTable = "Fetch_Comment_Data"; ds = dl.FetchMaster(p); List <Account_Data> commentlist = new List <Account_Data>(); try { foreach (DataRow i in ds.Tables[1].Rows) { Account_Data pa = new Account_Data(); pa.comment = i["comment"].ToString(); pa.Date = Convert.ToDateTime(i["Date"]).ToString("dd-MM-yyy"); pa.Name = i["Name"].ToString(); commentlist.Add(pa); } ViewBag.commentlist = commentlist; } catch (Exception ex) { } return(View(info)); }
// GET: about public ActionResult Index() { p.onTable = "Fetch_Aboutus_Data"; ds = dl.FetchMaster(p); var info = new crystalthoughts.Models.aboutus(); try { if (ds?.Tables[0].Rows.Count > 0) { DataRow i = ds.Tables[0].Rows[0]; info.aboutid = i["aboutid"].ToString(); info.title = i["title"].ToString(); info.image = i["image"].ToString(); info.Description = i["Description"].ToString(); } } catch (Exception ex) { } return(View(info)); }