Ejemplo n.º 1
0
        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));
        }
Ejemplo n.º 3
0
        public DataTable SelectCollege()
        {
            string query = "SELECT * FROM COLLEGE;";

            return(dbMan.ExecuteReader(query));
        }
Ejemplo n.º 4
0
        public DataTable SelectAllEmp()
        {
            string query = "SELECT * FROM Employee;";

            return(dbMan.ExecuteReader(query));
        }
Ejemplo n.º 5
0
        public DataTable GetAllBooks()
        {
            string StoredProcedureName = StoredProcedures.GetBooks;

            return(dbMan.ExecuteReader(StoredProcedureName, null));
        }
Ejemplo n.º 6
0
        /*-----------------------A_ViewDoctorRatings Form-----------------------*/

        public DataTable SelectDoctorIDsNames()
        {
            string query = "SELECT DID, Name FROM Doctor;";

            return(dbMan.ExecuteReader(query));
        }
Ejemplo n.º 7
0
        public DataTable ShowPlayers()
        {
            string query = "SELECT * FROM Players;";

            return(dbMan.ExecuteReader(query));
        }
Ejemplo n.º 8
0
 public DataTable GetReservedSeats(int number)
 {
     string query = "select Seats "
         + "from Busses "
         + "where Number = " + number;
     return dbMan.ExecuteReader(query);
 }