// GET: Event
        public ActionResult Index()
        {
            RegistrationEntities1 database = new RegistrationEntities1();
            var evnt = from e in database.Events
                       orderby e.EventName
                       select e;

            return(View(evnt));
        }
        public ActionResult Test(FormCollection form)
        {
            string[] info = new string[form.Count];
            form.CopyTo(info, 0);
            int id = Convert.ToInt16(info[0]);
            string model = info[1];

               //RegistrationEntities1Entities1 db = new RegistrationEntities1Entities1();
            RegistrationEntities1 db = new RegistrationEntities1();

            db.ProjectTables.Add(new ProjectTable
            {
                ProcessModelChosen = model
            });

            db.SaveChanges();

            List<ProjectTable> projectTables = db.ProjectTables.ToList();
            ProjectTable justAdded = projectTables.Last();

            db.JunctionTableProjectAndAccountV2.Add(new JunctionTableProjectAndAccountV2
            {
                AID = id,
                PId = justAdded.ProjectId,
                Responsibilities = "Leader",
                Role = "Leader"
            });

            db.SaveChanges();

            leaderTableV2 leader = db.leaderTableV2.Find(id);
            Account User = new Account();
            User.AccountId = leader.Id;
            User.Rank = "Leader";
            User.UserName = leader.UserName;

            return RedirectToAction("ExistingProjects", "Project", User);
        }