public string forum_content(string content, int articleID) { Member member = Session[CDictionary.SK_Logined_Member] as Member; try { if (Session[CDictionary.SK_Logined_Member] == null) { return("您尚未登入!即將跳轉至登入頁面"); } else { TicketSysEntities db = new TicketSysEntities(); Reply rp = new Reply(); rp.MemberID = member.MemberID; rp.ReplyDate = DateTime.Now; rp.ArticleID = articleID; rp.ReplyContent = content; db.Reply.Add(rp); db.SaveChanges(); return("成功"); } } catch (Exception ex) { return(ex.Message); } }
// GET api/<controller>/5 public string Get(string qrCodeContent) { TicketSysEntities db = new TicketSysEntities(); ActivityData activityData = db.TicketQRCodes.AsEnumerable().Where(tqrc => tqrc.QRCode == qrCodeContent). Select(tqrc => { Order_Detail order_Detail = tqrc.Order_Detail; return(new ActivityData() { ActivityName = order_Detail.Tickets.Activity.ActivityName, TicketCategoryName = order_Detail.Tickets.TicketCategory.TicketCategoryName, TicketTime = order_Detail.Tickets.TicketTimes.TicketTime.ToString("yyyy/MM/dd HH:mm") }); }).FirstOrDefault(); if (activityData != null) { string json = JsonConvert.SerializeObject(activityData); return(json); } else { return("false"); } }
public string Edit_article(string title, string content, int ArticleID, string picPath, int[] Activities) { TicketSysEntities db = new TicketSysEntities(); Article article = db.Article.Where(n => n.ArticleID == ArticleID).FirstOrDefault(); if (article != null) { article.ArticleTitle = title; article.ArticleContent = content; article.Date = DateTime.Now; if (!string.IsNullOrEmpty(picPath)) { article.Picture = picPath; } if (Activities != null) { //把先前的紀錄清空 foreach (var items in db.Ad_Article_Activity.Where(n => n.ArticleID == ArticleID)) { db.Ad_Article_Activity.Remove(items); } //加入新的活動連結 foreach (var item in Activities) { Ad_Article_Activity ad_Article_Activity = new Ad_Article_Activity(); ad_Article_Activity.ActivityID = item; ad_Article_Activity.ArticleID = ArticleID; db.Ad_Article_Activity.Add(ad_Article_Activity); } } db.SaveChanges(); } return("OK"); }
public ActionResult Reply_Delete(int replyID, int ArticleID) { TicketSysEntities db = new TicketSysEntities(); var q = db.Reply.Where(n => n.ReplyID == replyID).FirstOrDefault(); db.Reply.Remove(q); db.SaveChanges(); return(RedirectToAction("forum_content", "Forum", new { articleID = ArticleID })); }
// public ActionResult Add_article() { Member member = Session[CDictionary.SK_Logined_Member] as Member; TicketSysEntities db = new TicketSysEntities(); VMforum_mainblock vMforum_Mainblock = new VMforum_mainblock(); vMforum_Mainblock.activities = db.Activity.Where(n => n.SellerID == member.MemberID).ToList(); vMforum_Mainblock.ArticleCategories = db.ArticleCategories.ToList(); return(View(vMforum_Mainblock)); }
//在ActivityList頁面中Ajax調用這個方法取得活動的次詳細分頁 public ActionResult GetActivitySubDetailPage(int activityId) { TicketSysEntities db = new TicketSysEntities(); Activity activity = db.Activity.Where(a => a.ActivityStatusID == 1).FirstOrDefault(a => a.ActivityID == activityId); if (activity == null) { //todo 回傳活動是空值的錯誤頁面 } return(PartialView("GetActivitySubDetailPage", activity)); }
public string Add_article(string title, string content, string picPath, int[] Activities) { if (Session[CDictionary.SK_Logined_Member] == null) { return("Fail"); } try { if (string.IsNullOrEmpty(title)) { return("標題不得空白"); } if (string.IsNullOrEmpty(content)) { return("內文不得空白"); } //其他部分 TicketSysEntities db = new TicketSysEntities(); Member member = Session[CDictionary.SK_Logined_Member] as Member;//如果轉型失敗,回傳null; Article article = new Article(); article.MemberID = member.MemberID; article.Date = DateTime.Now; article.ArticleCategoryID = 1; article.ArticleTitle = title; article.ArticleContent = content; if (string.IsNullOrEmpty(picPath)) { article.Picture = picPath; } //article 的活動 if (Activities != null) { foreach (var item in Activities) { Ad_Article_Activity ad_Article_Activity = new Ad_Article_Activity(); ad_Article_Activity.ActivityID = item; ad_Article_Activity.ArticleID = article.ArticleID; db.Ad_Article_Activity.Add(ad_Article_Activity); } } db.Article.Add(article); db.SaveChanges(); return("OK"); } catch (Exception ex) { return(ex.Message); } }
//初次載入調用,之後都用不到惹 public ActionResult forum_mainblock(string searchText) { TicketSysEntities db = new TicketSysEntities(); var q = (from n in db.Article orderby n.Date descending select n).ToList(); var p = db.ArticleCategories.Select(n => n).ToList(); int maxPage = q.Count / 4; var qq = new VMforum_mainblock { Article = q, ArticleCategories = p, page = maxPage, searchWord = searchText }; return(View("forum_mainblock", "_ForumLayout", qq)); }
//載入留言內容 public ActionResult forum_reply(int?articleID) { TicketSysEntities db = new TicketSysEntities(); var q = from n in db.Article where n.ArticleID == articleID select n; Article article = q.FirstOrDefault(); List <Report> report = db.Report.ToList(); return(PartialView(new VMReport() { Article = article, Report = report })); }
//文章搜尋 public ActionResult SearchArticle(string searchText = "", int Page = 0, int CategoryID = 0, int searchType = 30) { TicketSysEntities db = new TicketSysEntities(); CForum_ArticleList_Factory al = new CForum_ArticleList_Factory(); List <Article> articles = db.Article.ToList(); //有選擇討論版 if (CategoryID != 0) { articles = al.Article_Category(articles, CategoryID); } //搜尋有文字 if (!string.IsNullOrEmpty(searchText)) { //searchType =2...有勾作者 //searchType =3...有勾標題 //searchType =5...有勾內文 List <Article> q = new List <Article>(); if (searchType % 2 == 0) { q = q.Union(al.Article_Search_Editor(articles, searchText)).ToList(); } if (searchType % 3 == 0) { q = q.Union(al.Article_Search_Title(articles, searchText)).ToList(); } if (searchType % 5 == 0) { q = q.Union(al.Article_Search_Content(articles, searchText)).ToList(); } articles = q; } //todo:按日期檢索 /// int maxPage = (articles.Count() / 4); //第幾頁 articles = articles.OrderByDescending(n => n.Date).Skip(Page * 4).ToList();//這個頁數不能一起算欸!放最後篩好了 var p = db.ArticleCategories.Select(n => n).ToList(); var qq = new VMforum_mainblock { Article = articles, ArticleCategories = p, searchWord = searchText, page = maxPage, ArticleCategoryID = CategoryID }; return(PartialView(qq)); }
public ActionResult Edit_article(int?articleID) { TicketSysEntities db = new TicketSysEntities(); var q = from n in db.Article where n.ArticleID == articleID select n; var p = db.ArticleCategories.Select(n => n); Article article = q.FirstOrDefault(); VMforum_mainblock vMforum_Mainblock = new VMforum_mainblock(); vMforum_Mainblock.Article = new List <Article>(); vMforum_Mainblock.ArticleCategories = new List <ArticleCategories>(); vMforum_Mainblock.Article.Add(article); vMforum_Mainblock.ArticleCategories = p.ToList(); vMforum_Mainblock.activities = db.Activity.Where(n => n.SellerID == article.MemberID).ToList(); return(View(vMforum_Mainblock)); }
public ActionResult ActivityDetail(int id) { CBackEndActivityDetailModel cBackEndActivityDetailModel = new CBackEndActivityDetailModel(); TicketSysEntities ticket = new TicketSysEntities(); cBackEndActivityDetailModel.Detail = ( from t in ticket.Activity from s in ticket.Seller from Status in ticket.ActivityStatus join tickettime in ticket.TicketTimes on t.ActivityID equals tickettime.ActivityId into tickettimeNull from tickettime in tickettimeNull.DefaultIfEmpty() where t.SellerID == s.SellerID && t.ActivityStatusID == Status.ActivityStatusID && t.ActivityID == id select new CBackEndActivityDetail { ActivityEntity = t, Seller = s, ActivityStatus = Status, TicketTimes = tickettime } ).FirstOrDefault(); cBackEndActivityDetailModel.FailedReason = ticket.ActivityFailedReason .Select(f => new CBackEndActivityReason { failedReason = f }).ToList(); cBackEndActivityDetailModel.ActivityTimes = ticket.TicketTimes .Where(t => t.ActivityId.Equals(id)) .Select(t => new CBackEndActivityTimes { TicketTimes = t }) .ToList(); return(View(cBackEndActivityDetailModel)); }
//載入活動資訊 public ActionResult forum_Activity(int?articleID) { TicketSysEntities db = new TicketSysEntities(); var q = from n in db.Ad_Article_Activity where n.ArticleID == articleID select n; List <Ad_Article_Activity> Ads = q.ToList(); List <Activity> Activitys = new List <Activity>(); foreach (var item in Ads) { Activity activity = db.Activity.Where(n => n.ActivityID == item.ActivityID).FirstOrDefault(); Activitys.Add(activity); } Article article = db.Article.Where(n => n.ArticleID == articleID).FirstOrDefault(); return(PartialView(Activitys)); }
public string Article_EmotionAction_Cancel(int ArticleID) { try { if (Session[CDictionary.SK_Logined_Member] == null) { return("您尚未登入!即將跳轉至登入頁面"); } TicketSysEntities db = new TicketSysEntities(); Member member = Session[CDictionary.SK_Logined_Member] as Member; var q = db.Article_Emotion.Where(n => n.ArticleId == ArticleID && n.MemberId == member.MemberID).FirstOrDefault(); db.Article_Emotion.Remove(q); db.SaveChanges(); return("成功"); } catch (Exception ex) { return(ex.Message); } }
public string Reply_Edit(string rpcontent, int replyID) { try { TicketSysEntities db = new TicketSysEntities(); Reply reply = db.Reply.Where(n => n.ReplyID == replyID).FirstOrDefault(); if (reply != null) { reply.ReplyContent = rpcontent; reply.ReplyDate = DateTime.Now; db.SaveChanges(); } return("OK"); } catch (Exception ex) { return(ex.Message); } }
//此類別寫入判斷瀏覽者權限的方法 //1. 未登入 //2. 一般會員 //3. 商家會員 //4. 管理者 public List <string> Authorityjudgment(Member member) { List <string> author = new List <string>(); TicketSysEntities db = new TicketSysEntities(); if (member == null) { author.Add("未登入"); } else if (member.MemberRoleId == 4) { author.Add("管理員"); } else if (member.MemberID == 3) { author.Add("商家會員"); } else if (member.MemberRoleId == 1) { author.Add("一般會員"); } return(author); }
public void before_Edit_article(int?articleID) { Member member = Session[CDictionary.SK_Logined_Member] as Member; List <string> author = authority.Authorityjudgment(member); TicketSysEntities db = new TicketSysEntities(); Article article = db.Article.Where(n => n.ArticleID == articleID).FirstOrDefault(); if (author.Contains("未登入")) { Page Page = new Page(); Response.Write("<script>alert('您尚未登入!即將跳轉至登入頁面');" + "window.location.href='http://localhost:49949/Login/Login';</script> "); } else if (article.MemberID == member.MemberID || member.MemberRoleId == 3) { Response.Write("<script>" + $"window.location.href='http://localhost:49949/Forum/Edit_article?articleID={articleID}';</script> "); } else { Response.Write("<script>alert('您非該文章作者,禁止編輯!即將跳轉至討論版首頁');" + "window.location.href='http://localhost:49949/Forum/forum_mainblock';</script> "); } }
public string Article_EmotionAction(int ArticleID, int ActionID) { try { if (Session[CDictionary.SK_Logined_Member] == null) { return("您尚未登入!即將跳轉至登入頁面"); } TicketSysEntities db = new TicketSysEntities(); Article_Emotion AE = new Article_Emotion(); Member member = Session[CDictionary.SK_Logined_Member] as Member; AE.MemberId = member.MemberID; AE.ArticleId = ArticleID; AE.ActionId = ActionID; db.Article_Emotion.Add(AE); db.SaveChanges(); return("成功"); } catch (Exception ex) { return(ex.Message); } }
//⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇貼文、留言Emotion⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇// public string Reply_EmotionAction(int ReplyID, int ActionID) { try { if (Session[CDictionary.SK_Logined_Member] == null) { return("您尚未登入!即將跳轉至登入頁面"); } TicketSysEntities db = new TicketSysEntities(); Reply_Emotion RE = new Reply_Emotion(); Member member = Session[CDictionary.SK_Logined_Member] as Member; RE.MemberId = member.MemberID; RE.ReplyId = ReplyID; RE.ActionId = ActionID; db.Reply_Emotion.Add(RE); db.SaveChanges(); return("成功"); } catch (Exception ex) { return(ex.Message); } }
public string Article_report(int ReportID, int ArticleID) { try { if (Session[CDictionary.SK_Logined_Member] == null) { return("您尚未登入!即將跳轉至登入頁面"); } TicketSysEntities db = new TicketSysEntities(); Article_Report report = new Article_Report(); Member member = Session[CDictionary.SK_Logined_Member] as Member; report.MemberId = member.MemberID; report.ArticleId = ArticleID; report.ReportId = ReportID; db.Article_Report.Add(report); db.SaveChanges(); return("成功"); } catch (Exception ex) { return(ex.Message); } }
public void Delete(int articleID) { Member member = Session[CDictionary.SK_Logined_Member] as Member; List <string> author = authority.Authorityjudgment(member); TicketSysEntities db = new TicketSysEntities(); //是一般會員且是作者,就可以編輯 Article article = db.Article.Where(n => n.ArticleID == articleID).FirstOrDefault(); if (author.Contains("管理員")) { var q = db.Article.Where(n => n.ArticleID == articleID).FirstOrDefault(); var reply = db.Reply.Where(n => n.ArticleID == articleID); foreach (var item in reply) { var qq = db.Reply_Emotion.Where(n => n.ReplyId == item.ReplyID); foreach (var items in qq) { db.Reply_Emotion.Remove(items); } } foreach (var item in reply) { db.Reply.Remove(item); } db.Article.Remove(q); db.SaveChanges(); Response.Write("<script>" + "alert('刪除成功!即將跳轉至討論版首頁');" + "window.location.href='http://localhost:49949/Forum/forum_mainblock';" + "</script> "); } else if (author.Contains("一般會員")) { if (article.MemberID == member.MemberID) { var q = db.Article.Where(n => n.ArticleID == articleID).FirstOrDefault(); var reply = db.Reply.Where(n => n.ArticleID == articleID); foreach (var item in reply) { db.Reply.Remove(item); } db.Article.Remove(q); db.SaveChanges(); Response.Write("<script>" + "alert('刪除成功!即將跳轉至討論版首頁');" + "window.location.href='http://localhost:49949/Forum/forum_mainblock';" + "</script> "); } else { Response.Write("<script>alert('您非該文章作者,禁止刪除!即將跳轉至討論版首頁');" + "window.location.href='http://localhost:49949/Forum/forum_mainblock';</script> "); } } else { Response.Write("<script>alert('您尚未登入!即將跳轉至登入頁面');" + "window.location.href='http://localhost:49949/Login/Login';</script> "); } }