public ActionResult Create(Post_Table post, Article article, Comment comment) { try { using (PostEntity pe = new PostEntity()) { DomainTech.DomainTechService dt = new DomainTech.DomainTechService(); List <Domain_Table> DomainList = dt.GetDomainList(); ViewBag.DomainList = new SelectList(DomainList, "did", "domain"); pe.Configuration.ProxyCreationEnabled = false; List <Technology_Table> TechnologyList = dt.GetTechforDomain(post.domain); ViewBag.TechnologyList = new SelectList(TechnologyList, "tid", "technology"); //Get the Domain ID int did = Convert.ToInt32(article.Post.domain); //Get the Technology ID int tid = Convert.ToInt32(article.Post.technology); DomainTechEntity dte = new DomainTechEntity(); //Convert the Domain ID to Domain Name var d = dte.Domain_Table.Where(x => x.did == did).FirstOrDefault(); post.domain = d.domain; //Convert the Technology ID to Technology Name var t = dte.Technology_Table.Where(x => x.tid == tid).FirstOrDefault(); post.technology = t.technology; //Check for same title int count = pe.Post_Table.Where(x => x.title == article.Post.title && x.category == true).Count(); if (count > 0) { ViewBag.ErrorMessage = "Please modify the TITLE, Article found with same TITLE"; return(View(article)); } else { post.title = article.Post.title; post.tags = article.Post.tags; post.content_ = article.Post.content_; post.date = DateTime.Now; post.category = true; post.userid = Session["userid"].ToString(); ViewData["Article"] = post; pe.Post_Table.Add(post); pe.SaveChanges(); return(View("ResultView")); } } } catch { return(View()); } }
public JsonResult GetTechList(int did) { using (DomainTechEntity dt = new DomainTechEntity()) { dt.Configuration.ProxyCreationEnabled = false; List <Technology_Table> TechList = dt.Technology_Table.Where(x => x.did == did).ToList(); return(Json(TechList, JsonRequestBehavior.AllowGet)); } }
public ActionResult EditPost(int id) { using (PostEntity pe = new PostEntity()) { DomainTechEntity dte = new DomainTechEntity(); List <Domain_Table> DomainList = dte.Domain_Table.ToList(); ViewBag.DomainList = new SelectList(DomainList, "did", "domain"); var post = pe.Post_Table.Where(x => x.postid == id).FirstOrDefault(); return(View(post)); } }
public ActionResult EditPost(int id, Post_Table post) { StreamWriter stream = null; DomainTech.DomainTechService dt = new DomainTech.DomainTechService(); List <DomainTech.Domain_Table> DomainList = dt.GetDomainList(); ViewBag.DomainList = new SelectList(DomainList, "did", "domain"); try { using (PostEntity pe = new PostEntity()) { //Get all the values of article/blog var postvalues = pe.Post_Table.Where(x => x.postid == id).FirstOrDefault(); //set all the values post.postid = postvalues.postid; post.date = postvalues.date; post.category = postvalues.category; post.userid = postvalues.userid; int did = Convert.ToInt32(post.domain); int tid = Convert.ToInt32(post.technology); DomainTechEntity dte = new DomainTechEntity(); var d = dte.Domain_Table.Where(x => x.did == did).FirstOrDefault(); post.domain = d.domain; var t = dte.Technology_Table.Where(x => x.tid == tid).FirstOrDefault(); post.technology = t.technology; post.userid = Session["userid"].ToString(); ViewData["Article"] = post; pe.Post_Table.AddOrUpdate(post); pe.SaveChanges(); } return(View("../Post/ResultView")); } catch (Exception e) { stream = new StreamWriter(@"D:/EditException.txt"); stream.WriteLine(e); stream.Close(); return(View()); } }
public ActionResult BrowseBlog(Post_Table post) { using (PostEntity pe = new PostEntity()) { DomainTech.DomainTechService dt = new DomainTech.DomainTechService(); List <Domain_Table> DomainList = dt.GetDomainList(); ViewBag.DomainList = new SelectList(DomainList, "did", "domain"); pe.Configuration.ProxyCreationEnabled = false; List <Technology_Table> TechnologyList = dt.GetTechforDomain(post.domain); ViewBag.TechnologyList = new SelectList(TechnologyList, "tid", "technology"); int did = Convert.ToInt32(post.domain); int tid = Convert.ToInt32(post.technology); DomainTechEntity dte = new DomainTechEntity(); var d = dte.Domain_Table.Where(x => x.did == did).FirstOrDefault(); post.domain = d.domain; var t = dte.Technology_Table.Where(x => x.tid == tid).FirstOrDefault(); post.technology = t.technology; List <Post_Table> browseblog = pe.Post_Table.Where(x => x.domain == post.domain && x.technology == post.technology && x.category == false).ToList(); if (browseblog.Count > 0) { ViewData["browseblog"] = browseblog; } else { ViewData["browseblog"] = null; ViewBag.Message = "No blog found"; } } return(View()); }
public ActionResult Create(Post_Table post, Blog blog, Comment comment) { StreamWriter stream = null; try { using (PostEntity pe = new PostEntity()) { DomainTech.DomainTechService dt = new DomainTech.DomainTechService(); List <Domain_Table> DomainList = dt.GetDomainList(); ViewBag.DomainList = new SelectList(DomainList, "did", "domain"); pe.Configuration.ProxyCreationEnabled = false; List <Technology_Table> TechnologyList = dt.GetTechforDomain(post.domain); ViewBag.TechnologyList = new SelectList(TechnologyList, "tid", "technology"); //Get the Domain ID int did = Convert.ToInt32(blog.Post.domain); //Get the Technology ID int tid = Convert.ToInt32(blog.Post.technology); DomainTechEntity dte = new DomainTechEntity(); //Convert the Domain ID to Domain Name var d = dte.Domain_Table.Where(x => x.did == did).FirstOrDefault(); post.domain = d.domain; //Convert the Technology ID to Technology Name var t = dte.Technology_Table.Where(x => x.tid == tid).FirstOrDefault(); post.technology = t.technology; //Check for same title int count = pe.Post_Table.Where(x => x.title == blog.Post.title && x.category == false).Count(); if (count > 0) { ViewBag.ErrorMessage = "Please modify the TITLE, Blog found with same TITLE"; return(View(blog)); } else { // Add the date, category and post.title = blog.Post.title; post.tags = blog.Post.tags; post.content_ = blog.Post.content_; post.date = DateTime.Now; post.category = false; post.userid = Session["userid"].ToString(); ViewData["Blog"] = post; pe.Post_Table.Add(post); pe.SaveChanges(); return(View("../Post/ResultView")); } } } catch (DbEntityValidationException dbEx) { stream = new StreamWriter(@"D:\BlogException.txt"); foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { stream.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } stream.Close(); return(View()); } }