-
Notifications
You must be signed in to change notification settings - Fork 0
/
dbLab.cs
133 lines (84 loc) · 3.79 KB
/
dbLab.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Data.Sql;
using System.Data.SqlTypes;
using System.Drawing;
using System.Windows.Forms;
namespace login1
{
public class dbLab
{
SqlConnection con;
public dbLab()
{
dbConnection cn = new dbConnection();//Establishes a connection
con = cn.connect();//Establishes a connection
}
// 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;
}
public void getname(int mrn,out string fname,out string mname,out string lname)
{
fname = "";
mname = "";
lname = "";
string strSQL = "Select P_firstName,P_middleName,P_lastName from Patient_general_info where mrn='" + mrn + "'";
SqlCommand cmd = new SqlCommand(strSQL, con);
SqlDataReader rd;
rd = cmd.ExecuteReader();
while (rd.Read())
{
fname = rd.GetString(rd.GetOrdinal("P_firstName"));
mname = rd.GetString(rd.GetOrdinal("P_middleName"));
lname = rd.GetString(rd.GetOrdinal("P_lastName"));
}
}
//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;
}
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 void saveTestReport(int mrn, string testName, string dateOfOrder, string dateOfConduction, string status, string result, string reference, string impression)
{
string strSQL = "Update labtest set TestConductionDate='"+dateOfConduction+"',TestStatus='"+status+"',Result='"+result+"',Reference='"+reference+"',Impression='"+impression+"' where MRN='"+mrn+"' and TestOrderDate='"+dateOfOrder+"' and TestName='"+testName+"'";
SqlCommand cmd = new SqlCommand(strSQL, con);
cmd.ExecuteNonQuery();
SqlDataReader rd;
rd = cmd.ExecuteReader();
}
public void saveTestReport(DataSet ds)
{
}
}
}