public bool RecordMembershipApplication(MembershipApplication newMembershipApplication) { bool confirmation; using (SqlConnection connection = new SqlConnection(connectionString)) { using (SqlCommand command = new SqlCommand("RecordMembershipApplication", connection) { CommandType = System.Data.CommandType.StoredProcedure }) { command.Parameters.AddWithValue("@lastName", newMembershipApplication.ProspectiveMemberContactInfo.LastName); command.Parameters.AddWithValue("@firstName", newMembershipApplication.ProspectiveMemberContactInfo.FirstName); command.Parameters.AddWithValue("@applicantAddress", newMembershipApplication.ProspectiveMemberContactInfo.Address); command.Parameters.AddWithValue("@applicantCity", newMembershipApplication.ProspectiveMemberContactInfo.City); command.Parameters.AddWithValue("@applicantPostalCode", newMembershipApplication.ProspectiveMemberContactInfo.PostalCode); command.Parameters.AddWithValue("@applicantPhone", newMembershipApplication.ProspectiveMemberContactInfo.PrimaryPhone); command.Parameters.AddWithValue("@applicantAlternatePhone", newMembershipApplication.ProspectiveMemberContactInfo.AlternatePhone); command.Parameters.AddWithValue("@email", newMembershipApplication.ProspectiveMemberContactInfo.Email); command.Parameters.AddWithValue("@dateOfBirth", newMembershipApplication.DateOfBirth); command.Parameters.AddWithValue("@membershipType", newMembershipApplication.MembershipType.ToString()); command.Parameters.AddWithValue("@occupation", newMembershipApplication.Occupation); command.Parameters.AddWithValue("@companyName", newMembershipApplication.EmploymentDetails.CompanyName); command.Parameters.AddWithValue("@employerAddress", newMembershipApplication.EmploymentDetails.Address); command.Parameters.AddWithValue("@employerCity", newMembershipApplication.EmploymentDetails.City); command.Parameters.AddWithValue("@employerPostalCode", newMembershipApplication.EmploymentDetails.PostalCode); command.Parameters.AddWithValue("@employerPhone", newMembershipApplication.EmploymentDetails.PrimaryPhone); command.Parameters.AddWithValue("@prospectiveMemberCertification", newMembershipApplication.ProspectiveMemberCertification); command.Parameters.AddWithValue("@sponsoringShareholder1", newMembershipApplication.Shareholder1); command.Parameters.AddWithValue("@shareholder1SigningDate", newMembershipApplication.Shareholder1SigningDate); command.Parameters.AddWithValue("@sponsoringShareholder2", newMembershipApplication.Shareholder2); command.Parameters.AddWithValue("@shareholder2SigningDate", newMembershipApplication.Shareholder2SigningDate); command.Parameters.AddWithValue("@shareholderCertification", newMembershipApplication.ShareholderCertification); command.Parameters.Add(new SqlParameter("@returnCode", -1) { Direction = System.Data.ParameterDirection.ReturnValue }); connection.Open(); try { command.ExecuteNonQuery(); confirmation = command.Parameters[command.Parameters.Count - 1].Value.ToString() == "0"; } catch (Exception ex) { confirmation = false; } } return(confirmation); } }
public List <MembershipApplication> GetMembershipApplications(DateTime startDate, DateTime endDate) { List <MembershipApplication> foundMembershipApplications = null; using (SqlConnection connection = new SqlConnection(connectionString)) { using (SqlCommand command = new SqlCommand("GetMembershipApplications", connection) { CommandType = System.Data.CommandType.StoredProcedure }) { command.Parameters.AddWithValue("@startDate", startDate); command.Parameters.AddWithValue("@endDate", endDate); connection.Open(); using (SqlDataReader reader = command.ExecuteReader()) { if (reader.HasRows) { foundMembershipApplications = new List <MembershipApplication>(); while (reader.Read()) { MembershipApplication foundApplication = new MembershipApplication(connectionString, (DateTime)reader["ApplicationDate"]) { ProspectiveMemberContactInfo = new ContactInformation() { LastName = reader["LastName"].ToString(), FirstName = reader["FirstName"].ToString(), Address = reader["ApplicantAddress"].ToString(), City = reader["ApplicantCity"].ToString(), PostalCode = reader["ApplicantPostalCode"].ToString(), PrimaryPhone = reader["ApplicantPhone"].ToString(), AlternatePhone = reader["ApplicantAlternatePhone"].ToString(), Email = reader["Email"].ToString() }, DateOfBirth = (DateTime)reader["DateOfBirth"], MembershipType = (MembershipType)Enum.Parse(typeof(MembershipType), reader["MembershipType"].ToString()), Occupation = reader["Occupation"].ToString(), EmploymentDetails = new ContactInformation() { CompanyName = reader["CompanyName"].ToString(), Address = reader["EmployerAddress"].ToString(), City = reader["EmployerCity"].ToString(), PostalCode = reader["EmployerPostalCode"].ToString(), AlternatePhone = reader["EmployerPhone"].ToString() }, ProspectiveMemberCertification = (bool)reader["ProspectiveMemberCertification"], Shareholder1 = reader["SponsoringShareholder1"].ToString(), Shareholder1SigningDate = (DateTime)reader["Shareholder1SigningDate"], Shareholder2 = reader["SponsoringShareholder2"].ToString(), Shareholder2SigningDate = (DateTime)reader["Shareholder2SigningDate"], ShareholderCertification = (bool)reader["ShareholderCertification"], ApplicationStatus = reader["ApplicationStatus"] is DBNull ? ApplicationStatus.New : (ApplicationStatus)Enum.Parse(typeof(ApplicationStatus), reader["ApplicationStatus"].ToString()) }; foundMembershipApplications.Add(foundApplication); } } } } } return(foundMembershipApplications); }