public ViewLabOrderUserControl()
{
InitializeComponent();
labOrdersTestController = new Lab_Orders_have_Lab_TestsController();
visitTests = new List <LabOrderTestDTO>();
selectedLabOrderTestDTO = new LabOrderTestDTO();
visitDTO = new VisitDTO();
}
///
/// </summary>
/// <param name="visitId"></param>
/// <returns></returns>
public static List <LabOrderTestDTO> GetVisitTests(int visitId)
{
List <LabOrderTestDTO> labTests = new List <LabOrderTestDTO>();
string selectStatement = @"select l.labOrderID, l.labTestCode, l.testPerformed, l.results,
o.visitID, o.dateOrdered,
t.name as testName ,
l.isNormal as isNormal
from Lab_Orders_have_Lab_Tests l
inner join Lab_Order o on l.labOrderID = o.id
inner join Lab_Test t on l.labTestCode = t.code
where o.visitID = @VisitID";
using (SqlConnection connection = GetSQLConnection.GetConnection())
{
connection.Open();
using (SqlCommand selectCommand = new SqlCommand(selectStatement, connection))
{
selectCommand.Parameters.AddWithValue("@VisitID", visitId);
using (SqlDataReader reader = selectCommand.ExecuteReader())
{
while (reader.Read())
{
LabOrderTestDTO labTest = new LabOrderTestDTO();
labTest.OrderId = Convert.ToInt32(reader["labOrderID"].ToString());
labTest.OrderedDate = (DateTime)reader["dateOrdered"];
labTest.TestCode = (int)reader["labTestCode"];
labTest.TestName = reader["testName"].ToString();
labTest.TestResult = reader["results"].ToString();
if (!reader.IsDBNull(reader.GetOrdinal("isNormal")))
{
labTest.IsNormal = (bool)reader["isNormal"];
}
if (labTest.IsNormal.HasValue)
{
if (labTest.IsNormal.Value)
{
labTest.TestResultStatus = "Normal";
}
else
{
labTest.TestResultStatus = "Abnormal";
}
}
if (!reader.IsDBNull(reader.GetOrdinal("testPerformed")))
{
labTest.TestDate = (DateTime)reader["testPerformed"];
}
labTest.VisitId = Convert.ToInt32(reader["visitID"].ToString());
labTests.Add(labTest);
}
}
}
}
return(labTests);
}
private void LabOrderTestGrid_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
selectedLabOrderTestDTO = (LabOrderTestDTO)labOrderTestGrid.Rows[e.RowIndex].DataBoundItem;
if (labOrderTestGrid.Columns[e.ColumnIndex].Name == "EditLabTest")
{
using (Form editLabOrderTestDialog = new EditLabOrderTestDialog(selectedLabOrderTestDTO))
{
DialogResult result = editLabOrderTestDialog.ShowDialog();
if (result == DialogResult.OK || result == DialogResult.Cancel)
{
this.RefreshDataGrid();
}
}
}
}
public void PopulateDataGrid(LabOrderTestDTO selectedLabOrderTestDTO)
{
this.selectedLabOrderTestDTO = selectedLabOrderTestDTO;
this.labOrderIDTextBox.Text = selectedLabOrderTestDTO.OrderId.ToString();
this.visitIDTextBox.Text = selectedLabOrderTestDTO.VisitId.ToString();
this.testNameTextBox.Text = selectedLabOrderTestDTO.TestName;
this.orderDateTimePicker.Value = selectedLabOrderTestDTO.OrderedDate;
this.testResultTextBox.Text = selectedLabOrderTestDTO.TestResult;
if (selectedLabOrderTestDTO.IsNormal.HasValue)
{
this.normalRadioButton.Checked = selectedLabOrderTestDTO.IsNormal.Value ? true : false;
this.abNormalRadioButton.Checked = selectedLabOrderTestDTO.IsNormal.Value ? false : true;
}
this.messageLabel.Text = "";
this.messageLabel.Visible = false;
this.testDateError.Text = "";
if (!String.IsNullOrWhiteSpace(selectedLabOrderTestDTO.TestResult))
{
this.testResultTextBox.ReadOnly = true;
this.testPerformedDateTimePicker.Enabled = false;
this.orderDateTimePicker.Enabled = false;
this.testResultTextBox.ReadOnly = true;
this.updateLabTestButton.Visible = false;
this.normalRadioButton.Enabled = false;
this.abNormalRadioButton.Enabled = false;
this.editLabOrderTestLabel.Text = "View Lab Test";
this.testPerformedDateTimePicker.Value = selectedLabOrderTestDTO.TestDate;
this.messageLabel.Text = "Lab Test Cannot be modified as test results are already submitted!!";
this.messageLabel.Visible = true;
SetTestTime();
}
else
{
this.testPerformedDateTimePicker.MinDate = selectedLabOrderTestDTO.OrderedDate;
this.testPerformedDateTimePicker.Value = DateTime.Now;
this.testPerformedDateTimePicker.MaxDate = DateTime.Now;
this.testTime.SelectedIndex = -1;
this.testDateError.Text = "";
this.testResultTextBox.ReadOnly = false;
this.testResultTextBox.Text = selectedLabOrderTestDTO.TestResult;
}
}
public EditLabOrderTestDialog(LabOrderTestDTO selectedLabOrderTestDTO)
{
InitializeComponent();
this.editLabOrderTestUserControl.PopulateDataGrid(selectedLabOrderTestDTO);
}
public EditLabOrderTestUserControl()
{
InitializeComponent();
labOrdersTestController = new Lab_Orders_have_Lab_TestsController();
selectedLabOrderTestDTO = new LabOrderTestDTO();
}
