public DataTable GetAll() { QuaintDatabaseManager db = new QuaintDatabaseManager(true); try { DataTable dt = db.ExecuteDataTable("Get_All_Guide", false); return(dt); } catch (Exception) { throw; } finally { db.Disconnect(); } }
public DataTable GetById(int id) { QuaintDatabaseManager db = new QuaintDatabaseManager(true); try { db.AddParameters("GuideId", id); DataTable dt = db.ExecuteDataTable("Get_Guide_By_Id", true); return(dt); } catch (Exception) { throw; } finally { db.Disconnect(); } }