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); } }