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);
}