public dbChangePassword()
        {
            //SqlConnection con;

            dbConnection cn = new dbConnection(); //Establishes a connection

            con = cn.connect();                   //Establishes a connection
        }
Beispiel #2
0
        public DataSet retrievePendingTestsDetails()
        {
            dbConnection con       = new dbConnection();
            string       cmdString = "select mrn,TestName,TestOrderDate from labtest where TestStatus='Pending '";

            SqlDataAdapter adapter = new SqlDataAdapter(cmdString, con.connect());
            DataSet        ds      = new DataSet();

            adapter.Fill(ds, "labtest");
            return(ds);
        }
        public DataSet getPharmacyOrders(string date)
        {
            dbConnection con       = new dbConnection();
            string       cmdString = "select * from pharmacy where VisitDate='" + date + "'and DispenseStatus='no'";

            SqlDataAdapter adapter = new SqlDataAdapter(cmdString, con.connect());
            DataSet        ds      = new DataSet();

            adapter.Fill(ds, "pharmacy");

            return(ds);
        }
Beispiel #4
0
        // a function which retrieves all the tests to be done for the day
        public DataSet getLabTestOrders(string today)
        {
            dbConnection con       = new dbConnection();
            string       cmdString = "select mrn,TestName,TestOrderDate from labtest where TestOrderDate='" + today + "' and TestStatus='Pending'";

            SqlDataAdapter adapter = new SqlDataAdapter(cmdString, con.connect());
            DataSet        ds      = new DataSet();

            adapter.Fill(ds, "labtest");

            return(ds);
        }
Beispiel #5
0
        //a function to retrieve the list of tests ordered for a
        //particular patient on a particular visit date
        public DataSet retrieveTestsInfo(int mrn, string orderDate, out string firstName, out string middleName, out string lastName)
        {
            string f, m, l;

            getname(mrn, out f, out m, out l);
            firstName  = f;
            middleName = m;
            lastName   = l;

            dbConnection   con     = new dbConnection();
            string         str     = "select TestName,TestOrderDate,TestStatus,Result,Reference,Impression from labtest where TestOrderDate='" + orderDate + "' and MRN='" + mrn + "'";
            SqlDataAdapter adapter = new SqlDataAdapter(str, con.connect());
            DataSet        ds      = new DataSet();

            adapter.Fill(ds, "labtest");
            return(ds);
        }
        //a function to retrieve the list of tests ordered for a
        //particular patient on a particular visit date
        public DataSet retrieveOrders(int mrn, string orderDate, out string firstName, out string middleName, out string lastName)
        {
            string f, m, l;

            getname(mrn, out f, out m, out l);
            firstName  = f;
            middleName = m;
            lastName   = l;

            dbConnection con = new dbConnection();
            // MessageBox.Show(Convert.ToString(mrn));
            // MessageBox.Show(orderDate);
            string         str     = "select * from pharmacy where VisitDate='" + orderDate + "' and MRN='" + mrn + "'";
            SqlDataAdapter adapter = new SqlDataAdapter(str, con.connect());
            DataSet        ds      = new DataSet();

            adapter.Fill(ds, "pharmacy");
            // MessageBox.Show("y");

            return(ds);
        }
        public dbPharmacy()
        {
            dbConnection cn = new dbConnection(); //Establishes a connection

            con = cn.connect();                   //Establishes a connection
        }
        public dbregistration()
        {
            dbConnection cn = new dbConnection(); //Establishes a connection

            con = cn.connect();                   //Establishes a connection
        }
Beispiel #9
0
        public dbLogin()
        {
            dbConnection cn = new dbConnection(); //Establishes a connection

            con = cn.connect();                   //Establishes a connection
        }
Beispiel #10
0
        public dbAppointment()
        {
            dbConnection cn = new dbConnection(); //Establishes a connection

            con = cn.connect();                   //Establishes a connection
        }