public ActionResult SearchFilter(string search, bool members = true, bool meetings = true, bool oldMeetings = true)
{
search = search.ToUpper();
SearchResult sr = new SearchResult();
using (var ctx = new KlubbdatabasEntities2())
{
ctx.Configuration.ProxyCreationEnabled = false;
if (meetings)
{
sr.Meetings = ctx.GameLocations.Include(x => x.MeetingParticipants).ToList();
if (!oldMeetings)
{
sr.Meetings = sr.Meetings.Where(x => x.IsUpcoming).ToList();
}
}
if (members)
{
sr.Members = ctx.Personers.ToList();
}
}
if (!string.IsNullOrEmpty(search))
{
if (meetings)
{
sr.Meetings = sr.Meetings.Where(x => x.Adress.ToUpper().Contains(search)).ToList();
}
if (members)
{
sr.Members = sr.Members.Where(x => x.Namn.ToUpper().Contains(search) || x.Adress.ToUpper().Contains(search)).ToList();
}
}
return(PartialView("~/Views/Shared/_SearchFilter.cshtml", sr));
}
public ActionResult DeleteMeeting(int id)
{
GameLocation meeting;
using (var ctx = new KlubbdatabasEntities2())
{
meeting = ctx.GameLocations.Where(x => x.ID == id).FirstOrDefault();
}
return(View(meeting));
}
public ActionResult EditMeeting(int id)
{
GameLocation meeting;
using (var ctx = new KlubbdatabasEntities2())
{
meeting = (GameLocation)ctx.GameLocations.Where(x => x.ID == id).Include("MeetingParticipants.Personer").FirstOrDefault();
}
return(View(meeting));
}
public ActionResult DeleteMeeting(GameLocation meeting)
{
using (var ctx = new KlubbdatabasEntities2())
{
var model = ctx.GameLocations.Find(meeting.ID);
ctx.GameLocations.Remove(model);
ctx.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult DeleteMember(int id)
{
Personer person;
using (var ctx = new KlubbdatabasEntities2())
{
person = ctx.Personers.Where(x => x.ID == id).FirstOrDefault();
}
return(View(person));
}
public ActionResult DeleteMember(Personer person)
{
using (var ctx = new KlubbdatabasEntities2())
{
var model = ctx.Personers.Find(person.ID);
model.Active = false;
ctx.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult NewMeeting()
{
GameLocation model = new GameLocation();
using (var ctx = new KlubbdatabasEntities2())
{
model.ID = ctx.GameLocations.Max(x => x.ID) + 1;
}
return(View(model));
}
public ActionResult GetAvaibleMembers(int meetingId)
{
AddMember model = new AddMember();
model.CurrentMeetingId = meetingId;
using (var ctx = new KlubbdatabasEntities2())
{
model.AvailableMembers = ctx.Personers.Where(x => x.MeetingParticipants.All(y => y.GameLocationId != meetingId)).Where(z => z.Active).ToList();
}
return(PartialView("~/Views/Shared/_Members.cshtml", model));
}
public ActionResult Index()
{
SearchResult sr = new SearchResult();
using (var ctx = new KlubbdatabasEntities2())
{
sr.Meetings = ctx.GameLocations.Include(x => x.MeetingParticipants).ToList();
sr.Members = ctx.Personers.ToList();
}
return(View(sr));
}
public ActionResult AddMember(Personer person)
{
if (!ModelState.IsValid)
{
return(View(person));
}
using (var ctx = new KlubbdatabasEntities2())
{
ctx.Personers.Add(person);
ctx.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult EditMeeting(GameLocation meeting)
{
using (var ctx = new KlubbdatabasEntities2())
{
var model = ctx.GameLocations.Find(meeting.ID);
if (TryUpdateModel(model))
{
ctx.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
public ActionResult NewMeeting(GameLocation meeting)
{
if (!ModelState.IsValid)
{
return(View(meeting));
}
using (var ctx = new KlubbdatabasEntities2())
{
ctx.GameLocations.Add(meeting);
ctx.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult DeleteParticipant(int participantId, int meetingId)
{
ICollection <MeetingParticipant> collection;
using (var ctx = new KlubbdatabasEntities2())
{
var participant = ctx.MeetingParticipants.Find(participantId);
ctx.MeetingParticipants.Remove(participant);
ctx.SaveChanges();
collection = ctx.MeetingParticipants.Where(x => x.GameLocationId == meetingId).Include(y => y.Personer).ToList();
}
return(PartialView("~/Views/Shared/_Participants.cshtml", collection));
}
public ActionResult EditMember(Personer person)
{
if (!ModelState.IsValid)
{
return(View(person));
}
using (var ctx = new KlubbdatabasEntities2())
{
var model = ctx.Personers.Find(person.ID);
if (TryUpdateModel(model))
{
ctx.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
public ActionResult AddParticipants(AddMember model)
{
string errors = "";
ICollection <MeetingParticipant> collection;
using (var ctx = new KlubbdatabasEntities2())
{
GameLocation meeting = ctx.GameLocations.Where(x => x.ID == model.CurrentMeetingId).SingleOrDefault();
if (meeting == null)
{
meeting = ctx.GameLocations.Add(new GameLocation {
ID = model.CurrentMeetingId, Datum = DateTime.Now, Adress = "blä"
});
}
foreach (var item in model.AvailableMembers.Where(x => x.Add))
{
meeting.MeetingParticipants.Add(new MeetingParticipant {
PersonId = item.ID
});
try
{
ctx.SaveChanges();
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
errors += string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:\n",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
errors += string.Format("- Property: \"{0}\", Value: \"{1}\", Error: \"{2}\"\n",
ve.PropertyName,
eve.Entry.CurrentValues.GetValue <object>(ve.PropertyName),
ve.ErrorMessage);
}
}
}
}
collection = ctx.MeetingParticipants.Where(x => x.GameLocationId == model.CurrentMeetingId).Include(y => y.Personer).ToList();
}
return(PartialView("~/Views/Shared/_Participants.cshtml", collection));
}
