public ActionResult Register(Registration model)
        {
            if (ModelState.IsValid)
            {
                MembershipCreateStatus createStatus = MembershipService.CreateUser(model.username, model.password, model.email);
                svc.registerUser(model.username, model.email, model.password, model.firstname, model.middleinital, model.lastname, model.age, model.sex, model.mailingaddress, model.phonenumber, model.creditcardname, model.creditcardtype, model.creditcardnumber, model.creditcardsecuritynumber, model.insurancecompany, model.insurancepolicynumber, model.insurancepolicyholder, model.martialstatus, model.ssn, model.dob, model.operations, model.allergies, model.medication, model.pastdoctor, model.familyhistory, model.emergencycontactname, model.emergencycontactnumber, model.recenttests, model.latestbloodpressure);
                FormsService.SignIn(model.username, false);
                return RedirectToAction("Patient","Portal");
            }

            return View(model);

               /*
            if (ModelState.IsValid)
            {
                // Attempt to register the user
                MembershipCreateStatus createStatus = MembershipService.CreateUser(model.username, model.password, model.email);
                svc.registerUser(model.username, model.email, model.password, model.firstname, model.middleinital, model.lastname, model.age, model.sex, model.mailingaddress, model.phonenumber, model.creditcardname, model.creditcardtype, model.creditcardnumber, model.creditcardsecuritynumber, model.insurancecompany, model.insurancepolicynumber, model.insurancepolicyholder, model.martialstatus, model.ssn, model.dob, model.operations, model.allergies, model.medication, model.pastdoctor, model.familyhistory, model.emergencycontactname, model.emergencycontactnumber, model.recenttests, model.latestbloodpressure);

               if (createStatus == MembershipCreateStatus.Success)
                {
                    FormsService.SignIn(model.username, false);

                    return RedirectToAction("Index", "Portal");
                }
                else
                {
                    ModelState.AddModelError("", AccountValidation.ErrorCodeToString(createStatus));
                }

            }

            // If we got this far, something failed, redisplay form
            ViewData["PasswordLength"] = MembershipService.MinPasswordLength;
            return View(model);
             */
        }
 public List<Registration> getRegistration()
 {
     Registration r = new Registration();
     string query = "SELECT * FROM Registration WHERE user_id="+r.id;
     return getRegistration(query);
 }
        public List<Registration> getRegistration(string query)
        {
            List<Registration> reg = new List<Registration>();
            MySqlConnection connection = new MySqlConnection(connectionString);

            try
            {
                connection.Open();
                MySqlCommand verifyUser = new MySqlCommand(query, connection);
                verifyUser.ExecuteNonQuery();

                object[] values = new object[30];
                MySqlDataReader response = verifyUser.ExecuteReader();
                try
                {
                    while (response.Read())
                    {
                        int num = response.GetValues(values);
                        if (num == 30)
                        {
                            Registration r = new Registration();
                            r.id = (int)values[0];
                            r.username = (String)values[1];
                            r.email = (String)values[2];
                            r.password = (String)values[3];
                            r.firstname = (String)values[4];
                            r.middleinital = (String)values[5];
                            r.lastname = (String)values[6];
                            r.age = (String)values[7];
                            r.sex = (String)values[8];
                            r.mailingaddress = (String)values[9];
                            r.phonenumber = (String)values[10];
                            r.creditcardname = (String)values[11];
                            r.creditcardtype = (String)values[12];
                            r.creditcardnumber = (String)values[13];
                            r.creditcardsecuritynumber = (String)values[14];
                            r.insurancecompany = (String)values[15];
                            r.insurancepolicynumber = (String)values[16];
                            r.insurancepolicyholder = (String)values[17];
                            r.martialstatus = (String)values[18];
                            r.ssn = (String)values[19];
                            r.dob = (String)values[20];
                            r.operations = (String)values[21];
                            r.allergies = (String)values[22];
                            r.medication = (String)values[23];
                            r.pastdoctor = (String)values[24];
                            r.familyhistory = (String)values[25];
                            r.emergencycontactname = (String)values[26];
                            r.emergencycontactnumber = (String)values[27];
                            r.recenttests = (String)values[28];
                            r.latestbloodpressure = (String)values[29];

                            reg.Add(r);

                        }
                    }
                }
                finally
                {
                    response.Close();
                }

            }
            catch (Exception e)
            {
                throw new Exception("Could not access registrations. Error: " + e.Message, e);
            }
            finally
            {
                connection.Close();
            }

            return reg;
        }
 public ActionResult Index()
 {
     Registration r = new Registration();
     string user = r.username;
     return View(svc.getRegistrationForUser(user));
 }