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)); }