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