Ejemplo n.º 1
0
    /// <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();
        }
    }
Ejemplo n.º 2
0
 /// <summary>
 /// deletes record based on patient id
 /// </summary>
 /// <param name="patientTreatment">patient treatment class</param>
 public void Delete(BCPatientTreatmentDAL patientTreatment)
 {
     Delete(patientTreatment.patientTreatmentId);
 }