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