public async Task GetDoctorsByDeptCount(int dept, int hosp_id, IDoctorCountByDeptCallback callback)
{
if (DBHandler.db == null)
{
DBHandler.DBConnection();
}
var count = await DBHandler.db.ExecuteScalarAsync <int>(String.Format("select count(*) from roster group by DOC_ID " +
"having DOC_ID in " +
"(select id from DOCTOR where DEPT_ID={0}) " +
"and HOSP_ID={1}", dept, hosp_id)
);
if (count > 0)
{
callback.ReadCountSuccess(count);
}
else
{
callback.ReadCountFail();
}
}
public Task GetDoctorCountAsync(int dept, int hosp_id, IDoctorCountByDeptCallback callback)
{
throw new NotImplementedException();
}
