public int insertCoreDiagnostic(DiagnosticDTO newDiagnostic)
{
int flagInsert = new DIAGNOSTICTableAdapter().insertDiagnosticQuery(
newDiagnostic.IdSpecialist,
newDiagnostic.NumberRoom,
newDiagnostic.FullName,
newDiagnostic.Price
);
return(flagInsert);
}
public int updateCoreDiagnostic(DiagnosticDTO originalDiagnostic)
{
int flagUpdate = new DIAGNOSTICTableAdapter().updateDiagnosticQuery(
originalDiagnostic.IdSpecialist,
originalDiagnostic.NumberRoom,
originalDiagnostic.FullName,
originalDiagnostic.Price,
originalDiagnostic.IdDiagnostic
);
return(flagUpdate);
}
public int getPriceByIdDiagnostic(int _idDiagnostic)
{
var priceDiagnostic = new DIAGNOSTICTableAdapter().ScalarQuery(_idDiagnostic);
return(Convert.ToInt32(priceDiagnostic));
}
public PersonalClinicDataSet.DIAGNOSTICDataTable getData()
{
PersonalClinicDataSet.DIAGNOSTICDataTable tblDiagnostic = new DIAGNOSTICTableAdapter().GetData();
return(tblDiagnostic);
}
