// GET: Event/Delete/5
public ActionResult Delete(int id)
{
using (EventManagerEntities dbModel = new EventManagerEntities())
{
return(View(dbModel.Events.Where(x => x.EventId == id).FirstOrDefault()));
}
}
public List <Participant> ListParticipantGender()
{
EventManagerEntities myDB = new EventManagerEntities();
List <Participant> listGender = myDB.Participants.Where(s => s.ParticipantId > 0).ToList <Participant>();
return(listGender);
}
// GET: Event/Index
public ActionResult Index()
{
using (EventManagerEntities dbModel = new EventManagerEntities())
{
return(View(dbModel.Events.ToList()));
}
}
public List <Participant> SearchBirthDate(DateTime date)
{
EventManagerEntities myDB = new EventManagerEntities();
List <Participant> listBirthDate = myDB.Participants.Where(s => s.BirthDate == date).ToList <Participant>();
return(listBirthDate);
}
public List <Participant> SearchEmailAddress(string email)
{
EventManagerEntities myDB = new EventManagerEntities();
List <Participant> listEmail = myDB.Participants.Where(s => s.EmailAddress == email).ToList <Participant>();
return(listEmail);
}
public List <Participant> SearchLastName(string lastName)
{
EventManagerEntities myDB = new EventManagerEntities();
List <Participant> listLastName = myDB.Participants.Where(s => s.LastName == lastName).ToList <Participant>();
return(listLastName);
}
public string RemoveParticipant(int id)
{
EventManagerEntities myDB = new EventManagerEntities();
Participant newParticipant = myDB.Participants.Where(s => s.ParticipantId == id).FirstOrDefault();
myDB.Participants.Remove(newParticipant);
myDB.SaveChanges();
return("DELETE Success!");
}
public User Get(string name)
{
User user;
using (var db = new EventManagerEntities())
{
using (var tx = db.Database.Connection.BeginTransaction(IsolationLevel.Unspecified))
{
user = db.Users.First(m => m.username == name);
tx.Commit();
}
}
return user;
}
public User Get(string name)
{
User user;
using (var db = new EventManagerEntities())
{
using (var tx = db.Database.Connection.BeginTransaction(IsolationLevel.Unspecified))
{
user = db.Users.First(m => m.username == name);
if (user == null)
{
return HttpNotFound();
}
}
}
}
public string PutParticipants(int ParticipantId, string FirstName, string LastName, string Gender, DateTime BirthDate, string EmailAddress)
{
EventManagerEntities myDB = new EventManagerEntities();
Participant newParticipant = myDB.Participants.Where(s => s.ParticipantId == ParticipantId).FirstOrDefault();
newParticipant.FirstName = FirstName;
newParticipant.LastName = LastName;
newParticipant.EmailAddress = EmailAddress;
newParticipant.BirthDate = BirthDate;
newParticipant.Gender = Gender;
myDB.SaveChanges();
return("PUT Success!");
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
WebApiConfig.Register(GlobalConfiguration.Configuration);
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
//Database.SetInitializer(new SampleData());
Database.SetInitializer(new CreateDatabaseIfNotExists <EventManagerEntities>());
var context = new EventManagerEntities();
context.Database.Initialize(true);
}
public ActionResult Create(Event e)
{
try
{
// TODO: Add insert logic here
using (EventManagerEntities dbModel = new EventManagerEntities())
{
dbModel.Events.Add(e);
dbModel.SaveChanges();
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Edit(int id, Event e)
{
try
{
// TODO: Add update logic here
using (EventManagerEntities dbModel = new EventManagerEntities())
{
dbModel.Entry(e).State = EntityState.Modified;
dbModel.SaveChanges();
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public VerificationResult VerifyUsernameAndPassword(string username, string password)
{
User user;
using (var db = new EventManagerEntities())
{
user = db.Users.FirstOrDefault(m => m.username.ToUpper() == username.ToUpper());
if (user == null)
{
return VerificationResult.UserNameDoesNotExist;
}
else if (user.password != password)
{
return VerificationResult.PasswordIncorrect;
}
return VerificationResult.Correct;
}
}
public ActionResult Delete(int id, FormCollection collection)
{
try
{
using (EventManagerEntities dbModel = new EventManagerEntities())
{
Event e = dbModel.Events.Where(x => x.EventId == id).FirstOrDefault();
dbModel.Events.Remove(e);
dbModel.SaveChanges();
}
// TODO: Add delete logic here
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public string PostNewParticipant(string FirstName, string LastName, string Gender, DateTime BirthDate, string EmailAddress)
{
EventManagerEntities myDB = new EventManagerEntities();
Participant newParticipant = new Participant();
newParticipant.FirstName = FirstName;
newParticipant.LastName = LastName;
newParticipant.Gender = Gender;
newParticipant.BirthDate = BirthDate;
newParticipant.EmailAddress = EmailAddress;
myDB.Participants.Add(newParticipant);
myDB.SaveChanges();
return("POST Success!");
}
public IPagedList<Event> GetEvents(int page, int pageSize, string sortOrder, string searchString)
{
IPagedList<Event> viewModel;
searchString = searchString.ToUpper();
using (var db = new EventManagerEntities())
{
using (var tx = db.Database.Connection.BeginTransaction(IsolationLevel.Unspecified))
{
var events = from i in db.Events select i;
if (!String.IsNullOrEmpty(searchString))
{
events = events.Where(i => i.title.ToUpper().Contains(searchString)
|| i.location.ToUpper().Contains(searchString)
|| i.Category.ToString().ToUpper().Contains(searchString)
|| i.eventDescription.ToUpper().Contains(searchString)
|| i.Type.ToString().ToUpper().Contains(searchString));
}
viewModel = events.ToPagedList(page, pageSize);
tx.Commit();
return viewModel;
}
}
}
public BaseRepository(EventManagerEntities context)
{
Context = context;
}
public EventRepository(EventManagerEntities context)
: base(context)
{
}
