コード例 #1
0
        /// <summary>
        /// registers the data in the immunization table
        /// </summary>
        /// <param name="immunization">object</param>
        /// <returns>object</returns>
        public static int RegisterImmunization(Immunization immunization)
        {
            SqlConnection connection = pchrDB.GetConnection();

            try
            {
                connection.Open();
                //insert string
                string insertStatement =
                    "INSERT INTO IMMUNIZATION_TBL " +
                    "(PATIENT_ID, IMMUNIZATION, DATE, NOTE) " +
                    "VALUES (@PatientID, @Immunization, @Date, @Note) ";

                //adds to the immunization table
                SqlCommand insertCommmand = new SqlCommand(insertStatement, connection);
                insertCommmand.Parameters.AddWithValue("@PatientID", immunization.IDNumber);
                insertCommmand.Parameters.AddWithValue("@Immunization", immunization.GetImmunization);
                insertCommmand.Parameters.AddWithValue("@Date", Convert.ToDateTime(immunization.Date));
                insertCommmand.Parameters.AddWithValue("@Note", immunization.Note);

                insertCommmand.ExecuteNonQuery();
                return(immunization.ImmunizationID);
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            finally
            {
                connection.Close();
            }
        }
コード例 #2
0
        /// <summary>
        /// deletes information from the immunization table
        /// </summary>
        /// <param name="immunization">object </param>
        /// <param name="immunizationID">immunization id</param>
        public static void DeleteImmunization(Immunization immunization, int immunizationID)
        {
            SqlConnection connection = pchrDB.GetConnection();


            try
            {
                connection.Open();
                // delete string
                string deleteStatement =
                    "DELETE FROM IMMUNIZATION_TBL " +
                    "WHERE PATIENT_ID = @PatientID " +
                    "AND IMMUNIZATION_ID = @ImmunizationID " +
                    "AND IMMUNIZATION = @Immunization " +
                    "AND DATE = @Date " +
                    "AND NOTE = @Note";
                SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection);
                // deletes data from the immunization table
                deleteCommand.Parameters.AddWithValue("@PatientID", Form2.ID);
                deleteCommand.Parameters.AddWithValue("@ImmunizationID", immunizationID);
                deleteCommand.Parameters.AddWithValue("@Immunization", immunization.GetImmunization);
                deleteCommand.Parameters.AddWithValue("@Date", Convert.ToDateTime(immunization.Date));
                deleteCommand.Parameters.AddWithValue("@Note", immunization.Note);

                deleteCommand.ExecuteNonQuery();
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            finally
            {
                connection.Close();
            }
        }
コード例 #3
0
        /// <summary>
        /// updates the data in the immunization table
        /// </summary>
        /// <param name="oldImmunization">old object</param>
        /// <param name="newImmunization">new object</param>
        public static void UpdateImmunization(Immunization oldImmunization,
                                              Immunization newImmunization)
        {
            SqlConnection connection = pchrDB.GetConnection();

            try
            {
                connection.Open();
                // update string
                string updateStatement =
                    "UPDATE IMMUNIZATION_TBL SET " +
                    "IMMUNIZATION = @NewImmunization, " +
                    "DATE = @NewDate, " +
                    "NOTE = @NewNote " +
                    "WHERE PATIENT_ID = @oldPatientID " +
                    "AND IMMUNIZATION_ID = @oldImmunizationID " +
                    "AND IMMUNIZATION = @oldImmunization " +
                    "AND DATE = @oldDate " +
                    "AND NOTE = @oldNote ";

                SqlCommand updateCommand =
                    new SqlCommand(updateStatement, connection);
                //updates data in the immunization table
                updateCommand.Parameters.AddWithValue("@NewImmunization",
                                                      newImmunization.GetImmunization);
                updateCommand.Parameters.AddWithValue("@NewDate",
                                                      newImmunization.Date);
                updateCommand.Parameters.AddWithValue("@NewNote",
                                                      newImmunization.Note);
                updateCommand.Parameters.AddWithValue("@oldPatientID",
                                                      oldImmunization.IDNumber);
                updateCommand.Parameters.AddWithValue("@oldImmunizationID",
                                                      oldImmunization.ImmunizationID);
                updateCommand.Parameters.AddWithValue("@oldImmunization",
                                                      oldImmunization.GetImmunization);
                updateCommand.Parameters.AddWithValue("@oldDate",
                                                      oldImmunization.Date);
                updateCommand.Parameters.AddWithValue("@oldNote",
                                                      oldImmunization.Note);

                updateCommand.ExecuteNonQuery();
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            finally
            {
                connection.Close();
            }
        }
コード例 #4
0
        /// <summary>
        /// gets the data in the immunization table
        /// </summary>
        /// <param name="idNumber">patient id</param>
        /// <param name="immunizationID">immunization id</param>
        /// <returns></returns>
        public static Immunization GetImmunization(int idNumber, int immunizationID)
        {
            SqlConnection connection = pchrDB.GetConnection();
            // select string
            string selectStatement
                = "SELECT PATIENT_ID, IMMUNIZATION_ID, IMMUNIZATION, DATE, NOTE "
                  + "FROM IMMUNIZATION_TBL "
                  + "WHERE PATIENT_ID = @ID " +
                  "AND IMMUNIZATION_ID = @ImmunizationID ";
            SqlCommand selectCommand =
                new SqlCommand(selectStatement, connection);

            selectCommand.Parameters.AddWithValue("@ID", idNumber);
            selectCommand.Parameters.AddWithValue("@ImmunizationID", immunizationID);
            try
            {
                connection.Open();
                SqlDataReader custReader =
                    selectCommand.ExecuteReader(CommandBehavior.SingleRow);
                if (custReader.Read())
                {
                    //reads data from the immunization table
                    Immunization immunization = new Immunization();
                    immunization.IDNumber        = Convert.ToInt32(custReader["PATIENT_ID"]);
                    immunization.ImmunizationID  = Convert.ToInt32(custReader["IMMUNIZATION_ID"]);
                    immunization.GetImmunization = custReader["IMMUNIZATION"].ToString();
                    immunization.Date            = custReader["DATE"].ToString();
                    immunization.Note            = custReader["NOTE"].ToString();

                    return(immunization);
                }
                else
                {
                    return(null);
                }
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            finally
            {
                connection.Close();
            }
        }