コード例 #1
0
        /// <summary>
        /// Updates a record in the Registration table.
        /// </summary>
        public void Update()
        {
            SqlConnection scon = DBHandling.GetConnection();
            SqlCommand    scom = new SqlCommand("RegistrationUpdate", scon);

            scom.CommandType = CommandType.StoredProcedure;


            scom.Parameters.Add("@StudentID", SqlDbType.Int, 4);
            scom.Parameters.Add("@Name", SqlDbType.VarChar, 500);
            scom.Parameters.Add("@DateOfBirth", SqlDbType.DateTime, 8);
            scom.Parameters.Add("@GradePointAvg", SqlDbType.Decimal, 9);
            scom.Parameters.Add("@Active", SqlDbType.Bit, 1);


            scom.Parameters["@StudentID"].Value     = studentID;
            scom.Parameters["@Name"].Value          = name;
            scom.Parameters["@DateOfBirth"].Value   = dateOfBirth;
            scom.Parameters["@GradePointAvg"].Value = gradePointAvg;
            scom.Parameters["@Active"].Value        = active;


            scon.Open();
            scom.ExecuteNonQuery();
            scon.Close();
        }
コード例 #2
0
        /// <summary>
        /// Deletes a record from the Registration table by its primary key.
        /// </summary>
        public void Delete()
        {
            SqlConnection scon = DBHandling.GetConnection();
            SqlCommand    scom = new SqlCommand("RegistrationDelete", scon);

            scom.CommandType = CommandType.StoredProcedure;

            scom.Parameters.Add("@StudentID", SqlDbType.Int, 4);
            scom.Parameters["@StudentID"].Value = studentID;


            scon.Open();
            scom.ExecuteNonQuery();
            scon.Close();
        }
コード例 #3
0
        /// <summary>
        /// Selects all records from the Registration table.
        /// </summary>
        public static List <Registration> SelectAll()
        {
            SqlConnection scon = DBHandling.GetConnection();
            SqlCommand    scom = new SqlCommand("RegistrationSelectAll", scon);

            scom.CommandType = CommandType.StoredProcedure;
            scon.Open();

            List <Registration> registrationList = new List <Registration>();

            using (SqlDataReader dataReader = scom.ExecuteReader()){
                while (dataReader.Read())
                {
                    Registration registration = MakeRegistration(dataReader);
                    registrationList.Add(registration);
                }
            }
            scon.Close();
            return(registrationList);
        }
コード例 #4
0
        /// <summary>
        /// Selects a single record from the Registration table.
        /// </summary>
        public static Registration Select(int studentID_Incoming)
        {
            Registration  Registrationins = new Registration();
            SqlConnection scon            = DBHandling.GetConnection();
            SqlCommand    scom            = new SqlCommand("RegistrationSelect", scon);

            scom.CommandType = CommandType.StoredProcedure;
            scon.Open();

            scom.Parameters.Add("@StudentID", SqlDbType.Int, 4);
            scom.Parameters["@StudentID"].Value = studentID_Incoming;
            using (SqlDataReader dataReader = scom.ExecuteReader()){
                if (dataReader.Read())
                {
                    Registrationins = MakeRegistration(dataReader);
                }
                else
                {
                    Registrationins = null;
                }
            }
            scon.Close();
            return(Registrationins);
        }