/// <summary>
/// checks if we are logged in and logs in if we are not
/// </summary>
/// <param name="data"></param>
/// <param name="lMDWSUserID"></param>
/// <returns></returns>
public REVAMP.TIU.CStatus MDWSLogin(REVAMP.TIU.CData data,
BaseMaster BaseMstr,
string strConnectionString,
bool bAudit,
out long lMDWSUserID)
{
REVAMP.TIU.CStatus status = new REVAMP.TIU.CStatus();
//if the user is logged in and not times out then
//no reason to login again.
lMDWSUserID = 0;
REVAMP.TIU.CAppUser appUser = new REVAMP.TIU.CAppUser(data);
status = appUser.CheckMDWSConnection(out lMDWSUserID);
if (!status.Status)
{
status = appUser.MDWSLogin(strConnectionString,
bAudit,
BaseMstr.FXUserID,
BaseMstr.Key,
BaseMstr.Session,
out lMDWSUserID);
}
return(status);
}
/// <summary>
/// get patient ids
/// </summary>
/// <param name="strConnectionString"></param>
/// <param name="bAudit"></param>
/// <param name="baseMstr"></param>
/// <param name="data"></param>
/// <param name="strPatientID"></param>
/// <param name="strMDWSPatientID"></param>
/// <param name="strProviderID"></param>
/// <returns></returns>
public REVAMP.TIU.CStatus GetPatientIDs(string strConnectionString,
bool bAudit,
BaseMaster baseMstr,
REVAMP.TIU.CData data,
string strPatientID,
out string strMDWSPatientID,
out string strProviderID)
{
strMDWSPatientID = String.Empty;
strProviderID = String.Empty;
REVAMP.TIU.CStatus status = new REVAMP.TIU.CStatus();
//get the MDWS patient ids
DataSet dsPat;
REVAMP.TIU.CPatientData pd = new REVAMP.TIU.CPatientData(data);
status = pd.GetPatientIDDS(strConnectionString,
bAudit,
baseMstr.FXUserID,
baseMstr.SelectedPatientID,
out dsPat);
if (status.Status)
{
strMDWSPatientID = REVAMP.TIU.CDataUtils.GetDSStringValue(dsPat, "MDWS_PATIENT_ID");
strProviderID = REVAMP.TIU.CDataUtils.GetDSStringValue(dsPat, "PROVIDER_ID");
}
return(status);
}
/// <summary>
/// load note titles ddl
/// </summary>
/// <param name="strNoteTitleLabel"></param>
/// <param name="master"></param>
/// <param name="ddlNoteTitle"></param>
/// <returns></returns>
public bool LoadNoteTitlesDDL(string strNoteTitleLabel,
BaseMaster master,
DropDownList ddlNoteTitle)
{
ddlNoteTitle.Items.Clear();
REVAMP.TIU.CStatus status = new REVAMP.TIU.CStatus();
//get data object and connection info
string strConnectionString = String.Empty;
REVAMP.TIU.CData data = null;
bool bAudit = false;
CMDWSUtils mdwsUtils = new CMDWSUtils();
mdwsUtils.GetDataInfo(master,
master.Session,
out data,
out strConnectionString,
out bAudit);
//check connection login if we are not connected
long lMDWSUserID = 0;
status = mdwsUtils.MDWSLogin(data,
master,
strConnectionString,
bAudit,
out lMDWSUserID);
if (!status.Status)
{
return(false);
}
REVAMP.TIU.CNoteTitleData ntd = new REVAMP.TIU.CNoteTitleData(data);
DataSet dsNoteTitles = null;
status = ntd.GetNoteTitleDS(strConnectionString,
bAudit,
master.FXUserID,
master.Session,
out dsNoteTitles);
status = REVAMP.TIU.CDropDownList.RenderDataSet(dsNoteTitles,
ddlNoteTitle,
"NOTE_TITLE_LABEL",
"NOTE_TITLE_LABEL");
ddlNoteTitle.SelectedIndex = -1;
REVAMP.TIU.CDropDownList.SelectItemByValue(ddlNoteTitle, strNoteTitleLabel);
return(true);
}
/// <summary>
/// load clinics DDL
/// </summary>
/// <returns></returns>
public bool LoadClinicsDDL(long lNoteClinicID,
BaseMaster master,
DropDownList ddlClinic)
{
ddlClinic.Items.Clear();
REVAMP.TIU.CStatus status = new REVAMP.TIU.CStatus();
//get data object and connection info
string strConnectionString = String.Empty;
REVAMP.TIU.CData data = null;
bool bAudit = false;
CMDWSUtils mdwsUtils = new CMDWSUtils();
mdwsUtils.GetDataInfo(master,
master.Session,
out data,
out strConnectionString,
out bAudit);
//check connection login if we are not connected
long lMDWSUserID = 0;
status = MDWSLogin(data,
master,
strConnectionString,
bAudit,
out lMDWSUserID);
if (!status.Status)
{
return(false);
}
REVAMP.TIU.CClinicData ntd = new REVAMP.TIU.CClinicData(data);
DataSet dsClinics = null;
status = ntd.GetClinicDS(strConnectionString,
bAudit,
master.FXUserID,
master.Session,
out dsClinics);
status = REVAMP.TIU.CDropDownList.RenderDataSet(dsClinics,
ddlClinic,
"CLINIC_LABEL",
"CLINIC_ID");
ddlClinic.SelectedIndex = -1;
REVAMP.TIU.CDropDownList.SelectItemByValue(ddlClinic, lNoteClinicID);
return(true);
}
/// <summary>
/// TIU SUPPORT - transfer MDWS patients
/// </summary>
/// <param name="strSearch"></param>
/// <returns></returns>
protected bool MDWSPatientTransfer(long lMatchType, string strSearch)
{
REVAMP.TIU.CStatus status = new REVAMP.TIU.CStatus();
//get data object and connection info
string strConnectionString = String.Empty;
REVAMP.TIU.CData data = null;
bool bAudit = false;
CMDWSUtils mdwsUtils = new CMDWSUtils();
mdwsUtils.GetDataInfo(BaseMstr,
Session,
out data,
out strConnectionString,
out bAudit);
//check connection login if we are not connected
long lMDWSUserID = 0;
status = mdwsUtils.MDWSLogin(data,
BaseMstr,
strConnectionString,
bAudit,
out lMDWSUserID);
if (!status.Status)
{
return(false);
}
//transfer the patient(s)
long lPatCount = 0;
REVAMP.TIU.CMDWSOps mdws = new REVAMP.TIU.CMDWSOps(data);
status = mdws.GetMDWSMatchPatients(strConnectionString,
bAudit,
BaseMstr.FXUserID,
BaseMstr.Key,
BaseMstr.Session,
lMatchType,
strSearch,
out lPatCount);
if (!status.Status)
{
return(false);
}
return(true);
}
/// <summary>
/// load sites ddl
/// </summary>
/// <param name="lRegionID"></param>
/// <param name="lSiteID"></param>
/// <param name="master"></param>
/// <param name="ddlSite"></param>
/// <returns></returns>
public bool LoadSitesDDL(long lRegionID,
long lSiteID,
BaseMaster master,
DropDownList ddlSite)
{
ddlSite.Items.Clear();
DataSet dsSite = null;
//status
REVAMP.TIU.CStatus status = new REVAMP.TIU.CStatus();
//get data object and connection info
string strConnectionString = String.Empty;
REVAMP.TIU.CData data = null;
bool bAudit = false;
CMDWSUtils mdwsUtils = new CMDWSUtils();
mdwsUtils.GetDataInfo(master,
master.Session,
out data,
out strConnectionString,
out bAudit);
REVAMP.TIU.CSiteData siteData = new REVAMP.TIU.CSiteData(data);
//get all sites for this region
siteData.GetSiteDS(strConnectionString,
bAudit,
master.FXUserID,
lRegionID,
out dsSite);
REVAMP.TIU.CDropDownList.RenderDataSet(dsSite,
ddlSite,
"SITE_NAME",
"SITE_ID");
ddlSite.SelectedIndex = -1;
REVAMP.TIU.CDropDownList.SelectItemByValue(ddlSite, lSiteID);
return(true);
}
/// <summary>
/// update mdws defaults
/// </summary>
/// <param name="lClinicID"></param>
/// <param name="strNoteTitleLabel"></param>
/// <param name="master"></param>
/// <returns></returns>
public bool UpdateMDWSDefaults(long lClinicID,
string strNoteTitleLabel,
BaseMaster master)
{
//status
REVAMP.TIU.CStatus status = new REVAMP.TIU.CStatus();
//get data object and connection info
string strConnectionString = String.Empty;
REVAMP.TIU.CData data = null;
bool bAudit = false;
CMDWSUtils mdwsUtils = new CMDWSUtils();
mdwsUtils.GetDataInfo(master,
master.Session,
out data,
out strConnectionString,
out bAudit);
//user data
REVAMP.TIU.CUserData userData = new REVAMP.TIU.CUserData(data);
//update the account
status = userData.UpdateMDWSAccount(strConnectionString,
bAudit,
master.FXUserID,
strNoteTitleLabel,
lClinicID);
if (!status.Status)
{
//error so update status
master.StatusCode = 1;
master.StatusComment = "An error occured while saving MDWS TIU Note defaults, Please contact your System Administrator!";
return(false);
}
master.StatusCode = 0;
master.StatusComment = "";
return(status.Status);
}
/// <summary>
/// get data info
/// </summary>
public REVAMP.TIU.CStatus GetDataInfo(BaseMaster BaseMstr,
HttpSessionState WebSession,
out REVAMP.TIU.CData data,
out string strConnectionString,
out bool bAudit)
{
//status
REVAMP.TIU.CStatus status = new REVAMP.TIU.CStatus();
//conn string
strConnectionString = String.Empty;
//audit
bAudit = false;
//need a data class
data = new REVAMP.TIU.CData(null,
BaseMstr.ClientIP,
BaseMstr.FXUserID,
BaseMstr.ASPSessionID,
WebSession,
true);
//get the conenction string
strConnectionString = ConfigurationManager.ConnectionStrings["DBConnString"].ConnectionString;
//get the audit
bAudit = false;
string strAudit = "";
if (System.Configuration.ConfigurationManager.AppSettings["AUDIT"] != null)
{
strAudit = System.Configuration.ConfigurationManager.AppSettings["AUDIT"].ToString();
if (strAudit == "1")
{
bAudit = true;
}
}
return(status);
}
/// <summary>
/// get mdws account info
/// </summary>
/// <param name="lFXUserID"></param>
/// <param name="strMDWSUserName"></param>
/// <param name="strMDWSPWD"></param>
/// <param name="lRegionID"></param>
/// <param name="lSiteID"></param>
/// <param name="strNoteTitleLabel"></param>
/// <param name="lNoteClinicID"></param>
/// <param name="master"></param>
/// <returns></returns>
public bool GetMDWSAccountInfo(long lFXUserID,
out string strMDWSUserName,
out string strMDWSPWD,
out long lRegionID,
out long lSiteID,
out string strNoteTitleLabel,
out long lNoteClinicID,
BaseMaster master)
{
strMDWSUserName = String.Empty;
strMDWSPWD = String.Empty;
lRegionID = 0;
lSiteID = 0;
strNoteTitleLabel = String.Empty;
lNoteClinicID = 0;
//status
REVAMP.TIU.CStatus status = new REVAMP.TIU.CStatus();
//get data object and connection info
string strConnectionString = String.Empty;
REVAMP.TIU.CData data = null;
bool bAudit = false;
CMDWSUtils mdwsUtils = new CMDWSUtils();
mdwsUtils.GetDataInfo(master,
master.Session,
out data,
out strConnectionString,
out bAudit);
//user data
REVAMP.TIU.CUserData userData = new REVAMP.TIU.CUserData(data);
//update the account
DataSet ds = null;
status = userData.GetMDWSAccountDS(strConnectionString,
bAudit,
master.FXUserID,
lFXUserID,
master.Key,
out ds);
if (!status.Status)
{
//error so update status
master.StatusCode = 1;
master.StatusComment = status.StatusComment;
}
else
{
strMDWSUserName = REVAMP.TIU.CDataUtils.GetDSStringValue(ds, "MDWS_USER_NAME");
strMDWSPWD = REVAMP.TIU.CDataUtils.GetDSStringValue(ds, "MDWS_PWD");
lRegionID = REVAMP.TIU.CDataUtils.GetDSLongValue(ds, "MDWS_REGION_ID");
lSiteID = REVAMP.TIU.CDataUtils.GetDSLongValue(ds, "MDWS_SITE_ID");
strNoteTitleLabel = REVAMP.TIU.CDataUtils.GetDSStringValue(ds, "MDWS_NOTE_TITLE_LABEL");
lNoteClinicID = REVAMP.TIU.CDataUtils.GetDSLongValue(ds, "MDWS_NOTE_CLINIC_ID");
}
return(status.Status);
}
/// <summary>
/// update the mdws account
/// </summary>
/// <param name="lRegionID"></param>
/// <param name="lSiteID"></param>
/// <param name="strUserName"></param>
/// <param name="strPWD"></param>
/// <param name="master"></param>
/// <returns></returns>
public bool UpdateMDWSAccount(long lRegionID,
long lSiteID,
string strUserName,
string strPWD,
BaseMaster master)
{
//status
REVAMP.TIU.CStatus status = new REVAMP.TIU.CStatus();
//get data object and connection info
string strConnectionString = String.Empty;
REVAMP.TIU.CData data = null;
bool bAudit = false;
CMDWSUtils mdwsUtils = new CMDWSUtils();
mdwsUtils.GetDataInfo(master,
master.Session,
out data,
out strConnectionString,
out bAudit);
//user data
REVAMP.TIU.CUserData userData = new REVAMP.TIU.CUserData(data);
//try a test login to get the MDWS user id
long lMDWSUserID = 0;
REVAMP.TIU.CAppUser appuser = new REVAMP.TIU.CAppUser(data);
status = appuser.MDWSLogin(strConnectionString,
bAudit,
master.FXUserID,
master.Key,
strUserName,
strPWD,
lRegionID,
lSiteID,
out lMDWSUserID);
if (!status.Status)
{
master.StatusCode = 1;
master.StatusComment = status.StatusComment;
if (status.StatusComment.ToUpper() == "FAILED TO LOGIN!")
{
master.StatusComment = "Invalid MDWS Credentials, Please check your data entry!";
}
return(false);
}
//update the account
status = userData.UpdateMDWSAccount(strConnectionString,
bAudit,
master.FXUserID,
master.FXUserID,
master.Key,
strUserName,
strPWD,
lRegionID,
lSiteID,
lMDWSUserID);
if (!status.Status)
{
//error so update status
master.StatusCode = 1;
master.StatusComment = "An error occured while saving MDWS credentials, Please contact your System Administrator!";
return(false);
}
master.StatusCode = 0;
master.StatusComment = "";
return(status.Status);
}
/// <summary>
/// TIU SUPPORT - get the tiu note
/// </summary>
protected void GetTIUNote()
{
//status
REVAMP.TIU.CStatus status = new REVAMP.TIU.CStatus();
//get data object and connection info
string strConnectionString = String.Empty;
REVAMP.TIU.CData data = null;
bool bAudit = false;
CMDWSUtils mdwsUtils = new CMDWSUtils();
mdwsUtils.GetDataInfo(BaseMstr,
Session,
out data,
out strConnectionString,
out bAudit);
//check connection to mdws login if we are not connected
long lMDWSUserID = 0;
status = mdwsUtils.MDWSLogin(data,
BaseMstr,
strConnectionString,
bAudit,
out lMDWSUserID);
if (!status.Status)
{
return;
}
//get the MDWS patient id
string strMDWSPatID = "";
string strProviderID = "";
status = mdwsUtils.GetPatientIDs(strConnectionString,
bAudit,
m_BaseMstr,
data,
m_BaseMstr.SelectedPatientID,
out strMDWSPatID,
out strProviderID);
if (!status.Status || strMDWSPatID == String.Empty)
{
return;
}
//write the note to tiu
string strNoteText = String.Empty;
REVAMP.TIU.CMDWSOps ops = new REVAMP.TIU.CMDWSOps(data);
status = ops.GetMDWSTIUNote(strConnectionString,
bAudit,
m_BaseMstr.FXUserID,
m_BaseMstr.SelectedPatientID,
m_BaseMstr.SelectedTreatmentID,
m_BaseMstr.SelectedEncounterID,
out strNoteText);
if (status.Status)
{
if (strNoteText != String.Empty)
{
txtViewTIU.Text = strNoteText;
pnlWriteNote.Visible = false;
pnlViewNote.Visible = true;
}
else
{
pnlWriteNote.Visible = true;
pnlViewNote.Visible = false;
//preload the the tiu note from SOAP
string strSubjective = txtSubjective.Text.Trim();
string strObjective = txtObjective.Text.Trim();
string strAssessment = txtAssessment.Text.Trim();
string strNote = String.Empty;
strNote += strSubjective;
strNote += "\r\n\r\n";
strNote += strObjective;
strNote += "\r\n\r\nASSESSMENT/PLAN:\r\n\r\n";
//
//get the diagnosis
CDataParameterList pListDiag = new CDataParameterList(m_BaseMstr);
pListDiag.AddInputParameter("pi_vPatientID", m_BaseMstr.SelectedPatientID);
pListDiag.AddInputParameter("pi_nTreatmentID", m_BaseMstr.SelectedTreatmentID);
pListDiag.AddInputParameter("pi_vEncounterID", m_BaseMstr.SelectedEncounterID);
long lStatusCode = 0;
string strStatusComment = String.Empty;
DataSet dsDiag = null;
CDataSet cds = new CDataSet();
dsDiag = cds.GetOracleDataSet(m_BaseMstr.DBConn,
"PCK_REVAMP_TIU.GetEncTIUNoteDiagRS",
pListDiag,
out lStatusCode,
out strStatusComment);
string strDiagnosis = "";
if (!REVAMP.TIU.CDataUtils.IsEmpty(dsDiag))
{
foreach (DataTable table in dsDiag.Tables)
{
foreach (DataRow row in table.Rows)
{
string strDiagCode = "";
string strDiagnosticText = "";
strDiagCode = REVAMP.TIU.CDataUtils.GetDSStringValue(row, "DIAG_CODE");
strDiagnosticText = REVAMP.TIU.CDataUtils.GetDSStringValue(row, "DIAGNOSTIC_TEXT");
strDiagnosis += strDiagCode + " " + strDiagnosticText;
strDiagnosis += "\r\n";
}
}
}
//add the diagnosis to the text
strNote += "DIAGNOSIS:\r\n\r\n";
strNote += strDiagnosis;
strNote += "\r\n";
//add the assessment plan to the text
strNote += strAssessment;
//set the contents of the text
txtTIUNote.Text = strNote;
}
}
else
{
pnlWriteNote.Visible = true;
pnlViewNote.Visible = false;
}
}
/// <summary>
/// TIU SUPPORT - write a tiu note
/// </summary>
public void WriteTIU()
{
if (ddlClinic.SelectedIndex <= 0 ||
ddlNoteTitle.SelectedIndex <= 0)
{
BaseMstr.StatusCode = 1;
BaseMstr.StatusComment = "Please select a valid note title and clinic!";
ShowSysFeedback();
return;
}
//status
REVAMP.TIU.CStatus status = new REVAMP.TIU.CStatus();
//get data object and connection info
string strConnectionString = String.Empty;
REVAMP.TIU.CData data = null;
bool bAudit = false;
CMDWSUtils mdwsUtils = new CMDWSUtils();
mdwsUtils.GetDataInfo(BaseMstr,
Session,
out data,
out strConnectionString,
out bAudit);
//check connection to mdws login if we are not connected
long lMDWSUserID = 0;
status = mdwsUtils.MDWSLogin(data,
BaseMstr,
strConnectionString,
bAudit,
out lMDWSUserID);
if (!status.Status)
{
BaseMstr.StatusCode = 1;
BaseMstr.StatusComment = "Could not login to MDWS, please check your credentials!";
ShowSysFeedback();
return;
}
//get the MDWS patient id
string strMDWSPatID = "";
string strProviderID = "";
status = mdwsUtils.GetPatientIDs(strConnectionString,
bAudit,
m_BaseMstr,
data,
m_BaseMstr.SelectedPatientID,
out strMDWSPatID,
out strProviderID);
if (!status.Status || strMDWSPatID == String.Empty)
{
BaseMstr.StatusCode = 1;
BaseMstr.StatusComment = "This patient does not have a MDWS patient id! Please contact your System Administrator!";
ShowSysFeedback();
return;
}
//get the note title IEN
long lNoteTitleIEN = 0;
REVAMP.TIU.CNoteTitleData nd = new REVAMP.TIU.CNoteTitleData(data);
status = nd.GetNoteTitleIEN(strConnectionString,
bAudit,
m_BaseMstr.FXUserID,
m_BaseMstr.Session,
ddlNoteTitle.SelectedValue,
out lNoteTitleIEN);
if (!status.Status)
{
BaseMstr.StatusCode = 1;
BaseMstr.StatusComment = "Could not retrieve Note ID from MDWS! Please contact your System Administrator!";
ShowSysFeedback();
return;
}
//write the note to tiu
REVAMP.TIU.CMDWSOps ops = new REVAMP.TIU.CMDWSOps(data);
status = ops.WriteNote(strConnectionString,
bAudit,
m_BaseMstr.FXUserID,
m_BaseMstr.SelectedPatientID,
strMDWSPatID,
m_BaseMstr.SelectedTreatmentID,
m_BaseMstr.SelectedEncounterID,
Convert.ToString(lMDWSUserID),
txtSign.Text,
ddlClinic.SelectedValue,
Convert.ToString(lNoteTitleIEN),
txtTIUNote.Text);
if (status.Status)
{
//this will get the newly saved note from MDWS
//and swap the panels to view mode
GetTIUNote();
}
else
{
BaseMstr.StatusCode = 1;
BaseMstr.StatusComment = status.StatusComment;
ShowSysFeedback();
return;
}
}
