/// <summary> /// Inserts into patient Treatment /// </summary> /// <param name="newPatientTreatment"></param> /// <returns></returns> public Int32 Insert(BCPatientTreatmentDAL newPatientTreatment) { string sql = string.Format( "INSERT INTO patientTreatment " + "(patientID,treatmentId,datePrescribed) " + "VALUES({0},{1},'{2}'", newPatientTreatment.patientID, newPatientTreatment.treatmentID, newPatientTreatment.datePrecribed); 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(); } }
/// <summary> /// deletes record based on patient id /// </summary> /// <param name="patientTreatment">patient treatment class</param> public void Delete(BCPatientTreatmentDAL patientTreatment) { Delete(patientTreatment.patientTreatmentId); }