private void ValidateHomeMedication()
{
try
{
SqlConnection conn = new SqlConnection(_ConnectionString);
SqlCommand cmd = new SqlCommand("BH_OPlus_HomeMedicationStatus_Sp", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ClientVisitGUID", this._ClientVisitGUID);
cmd.Parameters.AddWithValue("@ClientGUID", this._ClientGUID);
string omrStatus = string.Empty;
DataSet dataSet = new DataSet();
DataTable dataTable = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(dataSet);
//dataHandler.GetStoredProcedureResults(this._ConnectionString, "BH_OPlus_HomeMedicationStatus_Sp", parameters);
if (dataSet.Tables.Count > 0)
{
dataTable = dataSet.Tables[0];
}
foreach (DataRow dataRow in dataTable.Rows)
omrStatus = dataRow["OMRStatus"].ToString();
if (omrStatus != "Complete")
this.Show();
else
{
OrderReconciliationManager orderReconciliationManager = new OrderReconciliationManager() { ClientVisitPrimaryKey = Convert.ToInt64(this._ClientVisitGUID) };
orderReconciliationManager.ShowDialog();
this.Close();
}
}
catch (Exception ex)
{
HandleExceptions(ex);
}
}
private void ValidateHomeMedication()
{
try
{
IDataHandler dataHandler = new DataHandler();
List<StoredProcedureParameter> parameters = new List<StoredProcedureParameter>();
parameters.Add(new StoredProcedureParameter("@ClientVisitGUID", SqlDbType.BigInt, this._ClientVisitGUID));
parameters.Add(new StoredProcedureParameter("@ClientGUID", SqlDbType.BigInt, this._ClientGUID));
string omrStatus = string.Empty;
DataTable dataTable = dataHandler.GetStoredProcedureResults(this._ConnectionString, "BH_OPlus_HomeMedicationStatus_Sp", parameters);
foreach (DataRow dataRow in dataTable.Rows)
omrStatus = dataRow["OMRStatus"].ToString();
if (omrStatus != "Complete")
this.Show();
else
{
OrderReconciliationManager orderReconciliationManager = new OrderReconciliationManager() { ClientVisitPrimaryKey = Convert.ToInt64(this._ClientVisitGUID) };
orderReconciliationManager.ShowDialog();
this.Close();
}
}
catch (Exception ex)
{
HandleExceptions(ex);
}
}
