public DataTable SearchForItems(string name, int type, string genre) { string q = StoredProcedures.Search; Dictionary <string, object> Parameters = new Dictionary <string, object>(); Parameters.Add("@name", name); Parameters.Add("@type", type); Parameters.Add("@genre", genre); return(dbMan.ExecuteReader(q, Parameters)); }
//1-Retrieves Salary & JobCode public DataTable getSalaryJCode(int SSN) { string StoredProcedureName = StoredProcedures.getSalaryJobCode; Dictionary <string, object> Parameters = new Dictionary <string, object>(); Parameters.Add("@EmpSSN", SSN); return(dbMan.ExecuteReader(StoredProcedureName, Parameters)); }
public DataTable SelectCollege() { string query = "SELECT * FROM COLLEGE;"; return(dbMan.ExecuteReader(query)); }
public DataTable SelectAllEmp() { string query = "SELECT * FROM Employee;"; return(dbMan.ExecuteReader(query)); }
public DataTable GetAllBooks() { string StoredProcedureName = StoredProcedures.GetBooks; return(dbMan.ExecuteReader(StoredProcedureName, null)); }
/*-----------------------A_ViewDoctorRatings Form-----------------------*/ public DataTable SelectDoctorIDsNames() { string query = "SELECT DID, Name FROM Doctor;"; return(dbMan.ExecuteReader(query)); }
public DataTable ShowPlayers() { string query = "SELECT * FROM Players;"; return(dbMan.ExecuteReader(query)); }
public DataTable GetReservedSeats(int number) { string query = "select Seats " + "from Busses " + "where Number = " + number; return dbMan.ExecuteReader(query); }