public void addTopic(int id)
{
Person_Topic newTopic = new Person_Topic();
var topic = db.Topics.Where(t => t.Topic_Seq == id).FirstOrDefault();
newTopic.Person_ID = User.Identity.Name;
newTopic.Topic_Seq = id;
db.Person_Topic.Add(newTopic);
db.SaveChanges();
//record action
global.addAudit("Students", "Students: Add Fav Topic", "Create", User.Identity.Name);
//get list of topics student already favourites
var favTopics = db.Person_Topic.Where(t => t.Person_ID == User.Identity.Name).Include(t => t.Topic).ToList();
//get list of available topics not favourited
var ts = (from t in favTopics
select t.Topic_Seq).ToList();
var availableTopics = (from t in db.Topics
where !ts.Contains(t.Topic_Seq)
select t).ToList();
Session["favTopics"] = favTopics;
Session["availTopics"] = availableTopics;
}
public ActionResult DeleteConfirmed(string id)
{
Person_Topic person_Topic = db.Person_Topic.Find(id);
db.Person_Topic.Remove(person_Topic);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Person_ID,Topic_Seq")] Person_Topic person_Topic)
{
if (ModelState.IsValid)
{
db.Entry(person_Topic).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Person_ID = new SelectList(db.Registered_Person, "Person_ID", "Person_Name", person_Topic.Person_ID);
ViewBag.Topic_Seq = new SelectList(db.Topics, "Topic_Seq", "Topic_Name", person_Topic.Topic_Seq);
return(View(person_Topic));
}
// GET: PersonTopic/Delete/5
public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Person_Topic person_Topic = db.Person_Topic.Find(id);
if (person_Topic == null)
{
return(HttpNotFound());
}
return(View(person_Topic));
}
public PartialViewResult DeletePersonTopic(DeletePersonTopicModel model)
{
Person_Topic person_Topic = db.Person_Topic.Find(User.Identity.Name, model.Topic_Sequence);
db.Person_Topic.Remove(person_Topic);
db.SaveChanges();
var topicList = from a in db.Topics
join b in db.Person_Topic on a.Topic_Seq equals b.Topic_Seq
where b.Person_ID.Equals(User.Identity.Name)
select a;
ViewBag.Topic_Sequence = new SelectList(topicList, "Topic_Seq", "Topic_Name");
return(PartialView());
}
// GET: PersonTopic/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Person_Topic person_Topic = db.Person_Topic.Find(id);
if (person_Topic == null)
{
return(HttpNotFound());
}
ViewBag.Person_ID = new SelectList(db.Registered_Person, "Person_ID", "Person_Name", person_Topic.Person_ID);
ViewBag.Topic_Seq = new SelectList(db.Topics, "Topic_Seq", "Topic_Name", person_Topic.Topic_Seq);
return(View(person_Topic));
}
public PartialViewResult AddPersonTopic(AddPersonTopicModel model)
{
var topicList = from a in db.Topics
join b in db.Person_Topic on a.Topic_Seq equals b.Topic_Seq
where b.Person_ID.Equals(User.Identity.Name)
select a;
var peopleDifference = from person2 in db.Topics
where !(
from person1 in topicList
select person1.Topic_Seq
).Contains(person2.Topic_Seq)
select person2;
if (ModelState.IsValid)
{
Person_Topic a = new Person_Topic();
a.Topic_Seq = model.Topic_Seq;
a.Person_ID = User.Identity.Name;
db.Person_Topic.Add(a);
db.SaveChanges();
TempData["Message"] = "Topic Added";
if (peopleDifference.Count() == 0)
{
ViewBag.Topic_Seq = null;
return(PartialView());
}
else
{
ViewBag.Topic_Seq = new SelectList((IEnumerable <Topic>)peopleDifference, "Topic_Seq", "Topic_Name");
return(PartialView());
}
}
else
{
ViewBag.Topic_Seq = new SelectList((IEnumerable <Topic>)peopleDifference, "Topic_Seq", "Topic_Name");
return(PartialView());
}
}
