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