public dbChangePassword() { //SqlConnection con; dbConnection cn = new dbConnection(); //Establishes a connection con = cn.connect(); //Establishes a connection }
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); }
// 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); }
//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 }
public dbLogin() { dbConnection cn = new dbConnection(); //Establishes a connection con = cn.connect(); //Establishes a connection }
public dbAppointment() { dbConnection cn = new dbConnection(); //Establishes a connection con = cn.connect(); //Establishes a connection }