public string SaveDentalAdultTreatmentDiagnosis(IDentalTreatment dentalTreatment)
{
try
{
dataSet = new DataSet();
_storedProcedure = "SaveDentalAdultTreatmentDiagnosis";
_parameters = new SqlParameter[5];
//_parameters[0] = new SqlParameter("@DoctorTreatmentDiagnosisTypeTbl", SqlDbType.Structured);
//_parameters[0].Value = dentalTreatment.DoctorTreatmentsDT;
_parameters[0] = new SqlParameter("@DoctorTreatmentIllnessTypeTbl", SqlDbType.Structured);
_parameters[0].Value = dentalTreatment.DoctorTreatmentIllnessesDT;
_parameters[1] = new SqlParameter("@DoctorTreatmentSymptomTypeTbl", SqlDbType.Structured);
_parameters[1].Value = dentalTreatment.DoctorTreatmentSymptonsDT;
_parameters[2] = new SqlParameter("@DoctorTreatmentPatientProblemTypeTbl", SqlDbType.Structured);
_parameters[2].Value = dentalTreatment.DoctorTreatmentPatientProblemsDT;
_parameters[3] = new SqlParameter("@DoctorTreatmentId", SqlDbType.BigInt);
_parameters[3].Value = dentalTreatment.DoctorTreatmentId;
_parameters[4] = new SqlParameter("@VisitRegisterId", SqlDbType.BigInt);
_parameters[4].Value = dentalTreatment.VisitRegisterid;
dataSet = RunProcedure(_storedProcedure, _parameters, true);
return(dataSet.Tables[0].Rows[0][0].ToString());
}
catch (System.Exception)
{
throw;
}
}
public DataSet SaveDentalTreatmentPlanning(IDentalTreatment dentalTreatment)
{
try
{
dataSet = new DataSet();
_storedProcedure = "Dental_SaveTreatmentPlanning";
_parameters = new SqlParameter[1];
_parameters[0] = new SqlParameter("@DoctorTreatmentDiagnosisTypeTbl", SqlDbType.Structured);
_parameters[0].Value = dentalTreatment.DoctorTreatmentsDT;
dataSet = RunProcedure(_storedProcedure, _parameters, true);
return(dataSet);//(dataSet.Tables[0].Rows[0][0].ToString());
}
catch (System.Exception)
{
throw;
}
}