public ActionResult MyForumDetails(int id, string submit, FormCollection collection)
{
forum f = forumS.readForumById(id);
if (submit == "Update Post!")
{
try
{
//forum f = null;
//// TODO: Add update logic here
//f = forumS.readForumById(id);
f.subject = collection["subject"];
f.question = collection["question"];
f.description = collection["description"];
if (ModelState.IsValid)
{
forumS.updatePost(f);
return(RedirectToAction("MyForum"));
}
return(View("MyForumDetails", f));
}
catch
{
return(View());
}
}
return(View(f));
}
public ActionResult Comment(string text, int?id)
{
var cs = db.courses.FirstOrDefault(c => c.courseID == id);
var forum = db.fora.Where(f => f.courseID == id);
bool sonuc = false;
try
{
forum yeniyorum = new forum();
yeniyorum.text = text;
yeniyorum.studentID = int.Parse(Session["studentid"].ToString());
yeniyorum.courseID = int.Parse(Session["CourseID"].ToString());
yeniyorum.addedtime = DateTime.Now;
yeniyorum.student = db.students.Find(yeniyorum.studentID);
yeniyorum.Active = false;
db.fora.Add(yeniyorum);
sonuc = db.SaveChanges() > 0;
TempData["alert"] = "<script>alert('yorum eklenmistir');</script>";
}
catch (Exception e)
{
e.ToString();
}
var newForum = db.fora.Where(f => f.courseID == id);
return(Comment(id));
}
public ActionResult Edit(int id, forum f)
{
string role = null;
ViewData["Role"] = "";
IEnumerable <string> roles = new List <string>();
roles = ((ClaimsIdentity)User.Identity).Claims
.Where(c => c.Type == ClaimTypes.Role)
.Select(c => c.Value);
foreach (var x in roles)
{
role = x;
}
if (role != null)
{
ViewData["Role"] = role;
}
forum f1 = new forum();
f1 = se.GetById(id);
f1.nomForum = f.nomForum;
f1.sujets = f.sujets;
f1.DateSubmit = f.DateSubmit;
f1.description = f.description;
se.Update(f1);
se.Commit();
return(RedirectToAction("Index"));
}
//Task-7: Delete Queries
public int DeleteQuery(forum objforum)
{
objforum = objdb.forums.Find(objforum.questionid);
List <int> replyids = objdb.forumreplies.Where(r => r.questionid == objforum.questionid).Select(r => r.replyid).ToList();
try
{
//if we want to delete query
//first we have to delete child table records that is forum replies
//later we have to delete parent table query
if (replyids != null)
{
foreach (int rid in replyids)
{
forumreply objreply = objdb.forumreplies.Find(rid);
objdb.forumreplies.Remove(objreply);
}
}
objdb.forums.Remove(objforum);
objdb.SaveChanges();
return(1);
}
catch
{
return(0);
}
}
public ActionResult Create(forum f)
{
string role = null;
ViewData["Role"] = "";
IEnumerable <string> roles = new List <string>();
roles = ((ClaimsIdentity)User.Identity).Claims
.Where(c => c.Type == ClaimTypes.Role)
.Select(c => c.Value);
foreach (var x in roles)
{
role = x;
}
if (role != null)
{
ViewData["Role"] = role;
}
f.idUser = User.Identity.GetUserId();
f.DateSubmit = DateTime.Now;
ServiceForum s = new ServiceForum();
s.Add(f);
s.Commit();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int num)
{
forum forum = Db.forum.Find(num);
Db.forum.Remove(forum);
Db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteForums()
{
forum objforum = new forum();
objforum.questionid = int.Parse(Request.QueryString["fid"]);
objadminmodel.DeleteQuery(objforum);
ViewBag.forums = objadminmodel.GetQueries();
return(View("~/Views/Admin/ForumsList.cshtml"));
}
public ActionResult Delete(int num = 0)
{
forum forum = Db.forum.Find(num);
if (forum == null)
{
return(HttpNotFound());
}
return(View(forum));
}
public ActionResult Edit(int num = 0)
{
forum forum = Db.forum.Find(num);
if (forum == null)
{
return(HttpNotFound());
}
ViewBag.CategoryId = new SelectList(Db.category, "Id", "Name", forum.CategoryId);
return(View(forum));
}
public ActionResult Edit(forum forum)
{
if (ModelState.IsValid)
{
Db.Entry(forum).State = EntityState.Modified;
forum.Seo = OK.ConvertSeo(forum.Name);
Db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CategoryId = new SelectList(Db.category, "Id", "Name", forum.CategoryId);
return(View(forum));
}
//Task-6: Post Query
public int PostQuery(forum objforum)
{
try
{
objforum = objdb.forums.Add(objforum);
objdb.SaveChanges();
return(1);
}
catch
{
return(0);
}
}
public ActionResult PostQuery()
{
if (Request["btnPostQuery"] == "Post Query")
{
forum objforum = new forum();
objforum.questionid = int.Parse(Request["txtQueryId"]);
objforum.question = Request["txtQuery"];
objforum.loginid = (int)Session["loginid"];
ViewData["PostQueryValue"] = objusermodel.PostQuery(objforum);
}
ViewData["txtQueryId"] = objdb.forums.Select(f => f.questionid).DefaultIfEmpty(0).Max() + 1;
return(View());
}
public ActionResult Create(forum forum)
{
if (ModelState.IsValid)
{
forum.Seo = OK.ConvertSeo(forum.Name);
Db.forum.Add(forum);
Db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CategoryId = new SelectList(Db.category, "Id", "Name", forum.CategoryId);
return(View(forum));
}
public ActionResult ChangeApproval(int num = 0)
{
string result = "";
forum forum = Db.forum.Find(num);
if (forum != null)
{
forum.IsApproval = forum.IsApproval == true ? false : true;
result = forum.IsApproval == true ? "Forum başarıyla onaylandı." : "Forumun onayı başarıyla kaldırıldı.";
Db.SaveChanges();
}
return(Content("<script type=\"text/javascript\">SuccessInfo('" + result + "');</script>"));
}
public ActionResult Create(forum f, FormCollection collection)
{
try
{
// TODO: Add insert logic here
f.subject = collection["subject"];
f.question = collection["question"];
f.description = collection["description"];
if (ModelState.IsValid)
{
forumS.createPost(f);
return(RedirectToAction("Index"));
}
return(View("Create", f));
}
catch
{
return(View());
}
}
public ActionResult ReplyQuery()
{
if (Request["btnReply"] == "Reply")
{
forumreply objfreply = new forumreply();
objfreply.replyid = objdb.forumreplies.Select(r => r.replyid).DefaultIfEmpty(0).Max() + 1;
objfreply.reply = Request["txtQReply"];
objfreply.questionid = Convert.ToInt32(TempData["questionid"]);
objfreply.loginid = (int)Session["loginid"];
ViewData["replyvalue"] = objusermodel.ReplyQuery(objfreply);
ViewBag.forums = objusermodel.GetQueries();
return(View("~/Views/User/ViewAllQueries.cshtml"));
}
else
{
forum objforum = objdb.forums.Find(int.Parse(Request.QueryString["qid"]));
ViewData["SelectedQuery"] = objforum.question;
TempData["questionid"] = Request.QueryString["qid"];
return(View());
}
}
public ActionResult Edit(forum f, FormCollection collection)
{
try
{
//forum f = null;
//// TODO: Add update logic here
//f = forumS.readForumById(id);
f.subject = collection["subject"];
f.question = collection["question"];
f.description = collection["description"];
if (ModelState.IsValid)
{
forumS.updatePost(f);
return(RedirectToAction("MyForum"));
}
return(View("Edit", f));
}
catch
{
return(View());
}
}
public ActionResult Forum()
{
forum model = new forum();
return(View(model));
}
public ActionResult Forum(forum model)
{
return(View(model));
}
public static topic LastTopic(forum forum)
{
return(forum.topics.Where(x => x.IsApproval == true).OrderByDescending(x => x.ModifyDate).FirstOrDefault());
}
