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