public async Task GetHospitalsAsync(IHospitalListCallback hospitalCallback) { List <Hospital> results = new List <Hospital>(); try { //var db = await dbHandler.DBConnection(); if (DBHandler.db == null) { DBHandler.DBConnection(); } results = await DBHandler.db.QueryAsync <Hospital>( "SELECT * FROM HOSPITAL "); System.Diagnostics.Debug.WriteLine("results=" + results.Count()); if (results != null && results.Count > 0) { hospitalCallback.ReadSuccess(results); await DBHandler.db.CloseAsync(); } else { hospitalCallback.ReadFail(); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine("SELECT EXCEPTION" + e.Message); } }
public async Task GetHospitalByLocationAsync(string name, IHospitalListCallback hospitalCallback) { if (DBHandler.db == null) { DBHandler.DBConnection(); } var results = await DBHandler.db.QueryAsync <Hospital>(String.Format("SELECT * FROM HOSPITAL " + "WHERE LOCATION='{0}'", name)); if (results != null && results.Count > 0) { hospitalCallback.ReadSuccess(results); //await DoctorDBHandler.db.CloseAsync(); } else { hospitalCallback.ReadFail(); } }
public async Task GetHospitalByDept(string location, int dept_id, IHospitalListCallback hospitalCallback, int rating = -1) { if (DBHandler.db == null) { DBHandler.DBConnection(); } List <Hospital> results = new List <Hospital>(); try { //var db = await dbHandler.DBConnection(); DBHandler.DBConnection(); if (dept_id > 0) { results = await DBHandler.db.QueryAsync <Hospital>(String.Format("SELECT * FROM HOSPITAL WHERE ID IN(" + "SELECT HOSP_ID FROM ROSTER GROUP BY DOC_ID HAVING DOC_ID IN(" + "SELECT ID FROM DOCTOR WHERE DEPT_ID={0})" + "AND COUNT(*)>0) AND LOCATION='{1}' AND RATING >={2}", dept_id, location, rating) ); } else { results = await DBHandler.db.QueryAsync <Hospital>(String.Format("SELECT * FROM HOSPITAL WHERE ID IN(" + "SELECT HOSP_ID FROM ROSTER GROUP BY DOC_ID HAVING COUNT(*)>0) AND LOCATION='{1}' AND " + "RATING >={2}", dept_id, location, rating) ); } System.Diagnostics.Debug.WriteLine("results=" + results.Count()); if (results != null) { hospitalCallback.ReadSuccess(results); //await DoctorDBHandler.db.CloseAsync(); } else { hospitalCallback.ReadFail(); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine("SELECT EXCEPTION" + e.Message); } }
public async Task GetHospitalByNameAsync(string name, string location, IHospitalListCallback hospitalCallback) { if (DBHandler.db == null) { DBHandler.DBConnection(); } var results = await DBHandler.db.QueryAsync <Hospital>(String.Format("SELECT * FROM HOSPITAL " + "WHERE NAME LIKE'{0}%' AND LOCATION='{1}'", name, location)); if (results != null && results.Count > 0) { hospitalCallback.ReadSuccess(results); //await DoctorDBHandler.db.CloseAsync(); } else { hospitalCallback.ReadFail(); } System.Diagnostics.Debug.WriteLine("hosp dao val=" + results[0].Number_Of_Rating); }