/// <summary> /// Creates the data for Patient Medication /// </summary> /// <param name="newPatientMedication"></param> /// <returns></returns> public static Int32 Insert(BCPatientMedicationDAL newPatientMedication) { //Edit(newPatientTreatment); string sql = "INSERT INTO patientTreatment " + "(patientTreatmentId,din,dose,frequency,frencyPeriod,exactMinMax) " + "VALUES(" + newPatientMedication.patientMedicationId + ",'" + newPatientMedication.din + "'," + newPatientMedication.dose + "," + newPatientMedication.frequency + ",'" + newPatientMedication.frequencyPeriod + "','" + newPatientMedication.exactMinMax + "');"; SqlCommand patientCommand = new SqlCommand(sql, patientConnection); try { patientConnection.Open(); patientCommand.ExecuteNonQuery(); patientCommand.CommandText = "SELECT @@identity"; return(Convert.ToInt32(patientCommand.ExecuteScalar())); } catch (Exception ex) { throw ex; } finally { patientConnection.Close(); } }
public static string Valadate(BCPatientMedicationDAL newPM) { string errorMessage = ""; if ((newPM.exactMinMax == "n/a" && newPM.frequency <= 0) || (newPM.exactMinMax != "n/a" && newPM.frequency == 0)) { errorMessage += "exact/min/max dosn't match with frequency"; } return(errorMessage); }
public static Int32 Edit(BCPatientMedicationDAL newPatientMedication) { string errorMessage = Valadate(newPatientMedication); if (errorMessage != "") { throw new System.ArgumentException(errorMessage); } string sql = "UPDATE patientMedication " + "SET " +//din = '" + newPatientMedication.din + "'," + "dose = '" + newPatientMedication.dose + "', " + "frequency = " + newPatientMedication.frequency + ", " + "frequencyPeriod = '" + newPatientMedication.frequencyPeriod + "', " + "exactMinMax = '" + newPatientMedication.exactMinMax + "' " + "WHERE patientTreatmentId = " + newPatientMedication.PatientTreatmentId + ";"; SqlCommand patientCommand = new SqlCommand(sql, patientConnection); try { patientConnection.Open(); patientCommand.ExecuteNonQuery(); //patientCommand.CommandText = "SELECT @@identity"; return(Convert.ToInt32(patientCommand.ExecuteScalar())); //return 0; } catch (Exception ex) { throw ex; } finally { patientConnection.Close(); } }
/// <summary> /// Deletes patient medication feild based on patient medication id /// </summary> /// <param name="patientMedication">patient medication id</param> public static void Delete(BCPatientMedicationDAL patientMedication) { Delete(patientMedication.patientMedicationId); }