public ActionResult details(string id, string id1) { var info = new crystalthoughts.Models.blogdata(); p.Condition1 = id; TempData["bloid"] = id; TempData["blgurl"] = id1; p.onTable = "Home_Data"; ds = dl.FetchMaster(p); try { if (ds?.Tables[1].Rows.Count > 0) { DataRow i = ds.Tables[1].Rows[0]; info.blogid = i["blogid"].ToString(); info.title = i["title"].ToString(); info.videourl = i["videourl"].ToString(); info.image = i["image"].ToString(); info.discription = i["discription"].ToString(); info.status = i["status"].ToString(); info.blogdate = Convert.ToDateTime(i["blogdate"]).ToString("dd-MM-yyy"); } } 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[3].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)); }
public ActionResult blog(string id) { p.Condition1 = id; p.onTable = "Fetch_Blog_Data"; ds = dl.FetchMaster(p); var info = new crystalthoughts.Models.blogdata(); try { if (ds?.Tables[1].Rows.Count > 0) { DataRow i = ds.Tables[1].Rows[0]; info.blogid = i["blogid"].ToString(); info.title = i["title"].ToString(); info.videourl = i["videourl"].ToString(); info.image = i["image"].ToString(); info.discription = i["discription"].ToString(); info.status = i["status"].ToString(); } } catch (Exception ex) { } return(View(info)); }
public int Insertblog(blogdata bg) { string[] pname = { "@blogid", "@title", "@image", "@videourl", "@discription", "@status" }; string[] pvalue = { bg.blogid, bg.title, bg.image, bg.videourl, bg.discription, bg.status }; return(Int_Process("Insertblog", pname, pvalue)); }