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
}