示例#1
0
        private void collectMemberships()
        {
            //Query to get memberships table
            string membershipSelect = "SELECT MEMBERSHIP_ID, DURATION, COST, RESTRICTED, " +
                                      "DESCRIPTION, ACTIVE, EXP_DATE, EXP_TYPE, DAY_PASS FROM MEMBERSHIP_TYPE ";

            command = new SqlCommand(membershipSelect, connection);

            try
            {
                connection.Open();
                SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);

                //Reads the memberships and stores them
                while (reader.Read())
                {
                    Memberships tempMember = new Memberships();

                    tempMember.MembershipID   = reader["MEMBERSHIP_ID"].ToString();
                    tempMember.Duration       = reader["DURATION"].ToString();
                    tempMember.Cost           = reader["COST"].ToString();
                    tempMember.Description    = reader["DESCRIPTION"].ToString();
                    tempMember.Active         = reader["ACTIVE"].ToString();
                    tempMember.Restricted     = reader["RESTRICTED"].ToString();
                    tempMember.ExpirationType = reader["EXP_TYPE"].ToString();
                    tempMember.Daypass        = reader["DAY_PASS"] is DBNull ? "N" : reader["DAY_PASS"].ToString();
                    tempMember.Expiration     = reader["EXP_DATE"] is DBNull ? DateTime.Now : Convert.ToDateTime(reader["EXP_DATE"]);

                    memberships.Add(tempMember);
                }
                loadMembers();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error 1 Membership Display: \n" + ex);
            }
            finally
            {
                connection.Close();
            }
        }
示例#2
0
        private void loadMembershipCombo()
        {
            string membSelect = "SELECT        MEMBERSHIP_ID, DESCRIPTION " +
                                "FROM            MEMBERSHIP_TYPE";

            command = new SqlCommand(membSelect, connection);
            //open the connection to the database
            try
            {
                connection.Open();
                //create the SqlDataReader object using the command object
                SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
                //use loop to read data
                while (reader.Read())
                {
                    //create temp object and call constructor
                    Memberships tempMemb = new Memberships();
                    //read the rows and save in tempMemb
                    tempMemb.MembershipID = reader["MEMBERSHIP_ID"].ToString();
                    tempMemb.Description  = reader["DESCRIPTION"].ToString();
                    //add tempMemb object to the list
                    memberships.Add(tempMemb);
                }
                //close the database
                connection.Close();
                //load the name in the combo box
                foreach (Memberships aMembership in memberships)
                {
                    string membDesc = aMembership.Description;
                    cboMembType.Items.Add(membDesc);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error Loading Memberships: " + ex);
            }
        }