public void conductPendingTest(DataGridView grid)
{
dbLab lab = new dbLab();
DataSet ds = lab.retrievePendingTestsDetails();
grid.DataSource = ds.Tables["labtest"].DefaultView;
}
public void displayLabOrders(DataGridView grid)
{
dbLab lab = new dbLab();
string today = getdate();
DataSet ds = lab.getLabTestOrders(today);
grid.DataSource = ds.Tables["labtest"].DefaultView;
}
public void saveTestResults(TextBox mrn, TextBox resultDate, DataGridView reportGrid)
{
bool statusFlag = false;
bool impressionFlag = false;
int rowcount = reportGrid.RowCount - 2;
while (rowcount >= 0)
{
DataGridViewRow row = reportGrid.Rows[rowcount];
string status = row.Cells[2].Value.ToString();
string impression = row.Cells[5].Value.ToString();
if (status == "Pending" || status == "Complete" || status == "retest")
{
statusFlag = true;
}
if (impression == "Normal" || impression == "Abnormal")
{
impressionFlag = true;
}
rowcount--;
}
if (!statusFlag)
{
MessageBox.Show("Check for the 'Teststatus'!!\nEnter Pending or Complete");
}
if (!impressionFlag)
{
MessageBox.Show("Check for the 'Impression' column!!\nEnter either 'Normal' or 'Abnormal' only");
}
if (statusFlag && impressionFlag)
{
int count = reportGrid.RowCount - 2;
int cellsCount = reportGrid.Rows[0].Cells.Count;
while (count >= 0)
{
DataGridViewRow currentRow = reportGrid.Rows[count];
string testName = currentRow.Cells[0].Value.ToString();
string testOrderDate = currentRow.Cells[1].Value.ToString();
string status = currentRow.Cells[2].Value.ToString();
string result = currentRow.Cells[3].Value.ToString();
string reference = currentRow.Cells[4].Value.ToString();
string impression = currentRow.Cells[5].Value.ToString();
dbLab l = new dbLab();
int MRN = Convert.ToInt16(mrn.Text);
l.saveTestReport(MRN, testName, testOrderDate, resultDate.Text, status, result, reference, impression);
count--;
//MessageBox.Show("Test Report Saved successfully!!!");
}
MessageBox.Show("Test Report Saved successfully!!!");
}
}
public void conductNewTest(int mrn, string orderDate, DataGridView reportGrid, TextBox MRN, TextBox first, TextBox middle, TextBox last, TextBox date)
{
string fname, mname, lname;
dbLab lab = new dbLab();
DataSet ds = lab.retrieveTestsInfo(mrn, orderDate, out fname, out mname, out lname);
reportGrid.DataSource = ds.Tables["labtest"].DefaultView;
first.Text = fname;
middle.Text = mname;
last.Text = lname;
MRN.Text = mrn.ToString();
date.Text = getdate();
}
