public void GenerateAllergyReconciliationRows(int GlobalCodeId, int DocumentVersionId)
{
try
{
String RowIdentifier = null;
int AllergyType = 8794;
int ClientId = ((Streamline.BaseLayer.StreamlinePrinciple)Context.User).Client.ClientId;
int StaffId = ((Streamline.BaseLayer.StreamlineIdentity)Context.User.Identity).UserId;
Streamline.UserBusinessServices.ClientMedication objClientMedications = new ClientMedication();
Streamline.UserBusinessServices.DataSets.DataSetClientMedications dsClientMedications = new Streamline.UserBusinessServices.DataSets.DataSetClientMedications();
if (Session["DataSetClientMedications"] != null)
{
dsClientMedications = (Streamline.UserBusinessServices.DataSets.DataSetClientMedications)Session["DataSetClientMedications"];
}
if (dsClientMedications.Tables["ClientMedications"].Rows.Count > 0)
{
RowIdentifier = dsClientMedications.Tables["ClientMedications"].Rows[0]["RowIdentifier"].ToString();
}
objClientMedications.GetMedReconciliationData(GlobalCodeId, DocumentVersionId, ClientId, StaffId, AllergyType, RowIdentifier);
}
catch (Exception ex)
{
}
}
private void GetClientSummaryData()
{
Streamline.UserBusinessServices.DataSets.DataSetClientMedications DataSetClientMedications;
Streamline.UserBusinessServices.ClientMedication objectClientMedications = null;
DataSet dataSetClientSummary = null;
Session["DataSetClientSummary"] = null;
try
{
objectClientMedications = new Streamline.UserBusinessServices.ClientMedication();
CommonFunctions.Event_Trap(this);
string _ClientRowIdentifier = "";
string _ClinicianrowIdentifier = "";
DataSetClientMedications = new Streamline.UserBusinessServices.DataSets.DataSetClientMedications();
try
{
_ClinicianrowIdentifier = ((Streamline.BaseLayer.StreamlineIdentity)Context.User.Identity).ClinicianRowIdentifier;
}
catch (Exception ex)
{
if (ex.Data["CustomExceptionInformation"] == null)
{
ex.Data["CustomExceptionInformation"] = "";
}
string ParseMessage = ex.Message;
if (ParseMessage.Contains("Object") == true)
{
throw new Exception("Session Expired");
}
}
_ClientRowIdentifier = ((Streamline.BaseLayer.StreamlinePrinciple)Context.User).Client.ClientRowIdentifier;
if (_ClientRowIdentifier != "" && _ClinicianrowIdentifier != "")
{
dataSetClientSummary = objectClientMedications.DownloadClientMedicationSummary(_ClientRowIdentifier, _ClinicianrowIdentifier);
Session["DataSetClientMedications"] = null;
Session["DataSetClientSummary"] = dataSetClientSummary;
DataSetClientMedications.EnforceConstraints = false;
DataSetClientMedications.Tables["ClientMedications"].Merge(dataSetClientSummary.Tables["ClientMedications"]);
DataSetClientMedications.Tables["ClientMedicationInstructions"].Merge(dataSetClientSummary.Tables["ClientMedicationInstructions"]);
}
}
catch (Exception ex)
{
throw (ex);
}
finally
{
objectClientMedications = null;
}
}
//Ended over here
#region Update
public bool DocumentUpdateDocument()
{
DataRow BlankRow = null;
try
{
Streamline.UserBusinessServices.DataSets.DataSetClientMedications dsClientMedications = new Streamline.UserBusinessServices.DataSets.DataSetClientMedications();
CommonFunctions.Event_Trap(this);
if (Session["DataSetClientMedications"] != null)
{
dsClientMedications = (Streamline.UserBusinessServices.DataSets.DataSetClientMedications)Session["DataSetClientMedications"];
}
if (dsClientMedications.Tables["ClientMedications"].Rows.Count > 0)
{
ClientMedication objClientMedication = new ClientMedication();
if (dsClientMedications != null)
{
DataSet dsTemp = objClientMedication.UpdateDocuments(dsClientMedications);
Session["DataSetClientMedications"] = dsTemp;
}
}
Session["LoadMgt"] = true;
Session["ClientIdForValidateToken"] = ((Streamline.BaseLayer.StreamlinePrinciple)Context.User).Client.ClientId;
Session["CurrentControl"] = "~/UserControls/MedicationMgt.ascx";
Session["InitializeClient"] = true;
return(true);
}
catch (Exception ex)
{
if (ex.Data["CustomExceptionInformation"] == null)
{
ex.Data["CustomExceptionInformation"] = "";
}
else
{
ex.Data["CustomExceptionInformation"] = "";
}
if (ex.Data["DatasetInfo"] == null)
{
ex.Data["DatasetInfo"] = "";
}
Streamline.BaseLayer.LogManager.LogException(ex, LogManager.LoggingCategory.General, LogManager.LoggingLevel.Error, this);
return(false);
}
}
/// <summary>
///<Author>Sony </Author>
/// Purpose:To Get the drug Interactions between Medications and Merge the interactions in DataSet accordingly
/// </summary>
/// <param name="dsTemp"></param>
private void getDrugInteraction(Streamline.UserBusinessServices.DataSets.DataSetClientMedications dsTemp)
{
try
{
CommonFunctions.Event_Trap(this);
string MedicationIds = "";
foreach (DataRow dr in dsTemp.ClientMedicationInstructions.Select("isnull(Recorddeleted,'N')<>'Y'"))
{
MedicationIds += dr["StrengthId"].ToString() + ",";
}
if (MedicationIds.Length > 1)
{
MedicationIds = MedicationIds.TrimEnd(',');
}
Streamline.UserBusinessServices.ClientMedication objClientMed = new Streamline.UserBusinessServices.ClientMedication();
DataSet dsTempInteraction = objClientMed.GetClientMedicationDrugInteraction(MedicationIds, ((Streamline.BaseLayer.StreamlinePrinciple)Context.User).Client.ClientId, ((Streamline.BaseLayer.StreamlineIdentity)Context.User.Identity).UserId);
if (dsTempInteraction.Tables.Count > 0)
{
createClientMedicationInteraction(dsTempInteraction);
Streamline.UserBusinessServices.DataSets.DataSetClientMedications dsClientMedicationsTemp = (Streamline.UserBusinessServices.DataSets.DataSetClientMedications)Session["DataSetClientMedications"];
dsClientMedicationsTemp.ClientAllergiesInteraction.Merge(dsTempInteraction.Tables["ClientAllergyInteraction"]);
}
}
catch (Exception ex)
{
if (ex.Data["CustomExceptionInformation"] == null)
{
ex.Data["CustomExceptionInformation"] = "";
}
else
{
ex.Data["CustomExceptionInformation"] = "";
}
if (ex.Data["DatasetInfo"] == null)
{
ex.Data["DatasetInfo"] = null;
}
throw (ex);
}
}
public string CheckExistingMedication(int medicationNameId)
{
try
{
Streamline.UserBusinessServices.DataSets.DataSetClientMedications DataSet1 = null;
if (Session["DataSetClientMedications"] != null)
{
DataSet1 = (Streamline.UserBusinessServices.DataSets.DataSetClientMedications)Session["DataSetClientMedications"];
if (DataSet1.ClientMedications.Select("MedicationNameId=" + medicationNameId + " and DrugCategory=2").Length > 0)
{
return("Selected medication already exists in Medication List");
}
}
return("");
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// <description>Function used to set the titartion dataset to session on page load.</description>
/// <author>Ankesh Bharti</author>
/// <createdDate>24/12/2008</createdDate>
/// </summary>
private void FillMedicationInfo()
{
try
{
if (Session["DataSetTitration"] != null)
{
using (DataSet _dataSetClientTitration = ((DataSet)Session["DataSetTitration"]).Copy())
{
Session["DataSetTitration"] = _dataSetClientTitration;
}
}
else
{
_DataSetClientMedications = new Streamline.UserBusinessServices.DataSets.DataSetClientMedications();
Session["DataSetTitration"] = _DataSetClientMedications;
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Purpose:This function will be used to Get Client Medication Summary Data
/// </summary>
private void GetClientSummaryData()
{
Streamline.UserBusinessServices.DataSets.DataSetClientMedications DataSetClientMedications;
try
{
objectClientMedications = new ClientMedication();
//objectCommonFunctions = new ApplicationCommonFunctions();
CommonFunctions.Event_Trap(this);
string _ClientRowIdentifier = "";
string _ClinicianrowIdentifier = "";
DataSetClientMedications = new Streamline.UserBusinessServices.DataSets.DataSetClientMedications();
try
{
_ClinicianrowIdentifier = ((Streamline.BaseLayer.StreamlineIdentity)Context.User.Identity).ClinicianRowIdentifier;
}
catch (Exception ex)
{
if (ex.Data["CustomExceptionInformation"] == null)
{
ex.Data["CustomExceptionInformation"] = "";
}
string ParseMessage = ex.Message;
if (ParseMessage.Contains("Object") == true)
{
throw new Exception("Session Expired");
}
}
_ClientRowIdentifier = ((Streamline.BaseLayer.StreamlinePrinciple)Context.User).Client.ClientRowIdentifier;
if (_ClientRowIdentifier != "" && _ClinicianrowIdentifier != "")
{
_DataSetClientSummary = objectClientMedications.DownloadClientMedicationSummary(_ClientRowIdentifier, _ClinicianrowIdentifier);
Session["DataSetClientMedications"] = null;
Session["DataSetPrescribedClientMedications"] = null;//Added As per task#3323 By Pradeep on 4 March 2011
Session["DataSetClientSummary"] = _DataSetClientSummary;
DataSetClientMedications.EnforceConstraints = false;
DataSetClientMedications.Tables["ClientMedications"].Merge(_DataSetClientSummary.Tables["ClientMedications"]);
DataSetClientMedications.Tables["ClientMedicationInstructions"].Merge(_DataSetClientSummary.Tables["ClientMedicationInstructions"]);
//Activate the MedicationClientPersonalInformation Control
//MedicationClientPersonalInformation1.showEditableAllergyList = true;
//MedicationClientPersonalInformation1.Activate();
//LabelClientName.Text = "";
//LabelClientName.Text = _DataSetClientSummary.Tables["ClientInformation"].Rows[0]["ClientInformationLabel"].ToString(); //DataSetClientSummary.Tables["ClientInformation"].Rows[0]["ClientInformationLabel"].ToString();
}
}
catch (Exception ex)
{
if (ex.Data["CustomExceptionInformation"] == null)
{
ex.Data["CustomExceptionInformation"] = "";
}
else
{
ex.Data["CustomExceptionInformation"] = "";
}
if (ex.Data["DatasetInfo"] == null)
{
ex.Data["DatasetInfo"] = _DataSetClientSummary;
}
Streamline.BaseLayer.LogManager.LogException(ex, LogManager.LoggingCategory.General, LogManager.LoggingLevel.Error, this);
}
finally
{
objectClientMedications = null;
//objectCommonFunctions = null;
}
}
/// <summary>
/// Author Sony John
/// Purpose to get the Interaction rows corresponding to the Passed Rows array
/// </summary>
/// <param name="drTemp"></param>
private void getInteractionRows(DataRow[] drTemp)
{
try
{
Streamline.UserBusinessServices.DataSets.DataSetClientMedications dsClientMedications = (Streamline.UserBusinessServices.DataSets.DataSetClientMedications)Session["DataSetClientMedications"];
int ClientMedicationInteractionId = 0;
CommonFunctions.Event_Trap(this);
for (int i = 0; i < drTemp.Length; i++)//Takes the first id and makes possible combination with all the rest of the ids
{
int MedicationId1 = 0;
int MedicationId2 = 0;
int k = i + 1;
for (; k < drTemp.Length; k++)
{
DataRow[] ClientMedication1 = dsClientMedications.ClientMedications.Select("StrengthId=" + drTemp[i]["MedicationId"] + " and isnull(recorddeleted,'N')<>'Y'");
if (ClientMedication1.Length > 0)
{
MedicationId1 = Convert.ToInt32(ClientMedication1[0]["ClientMedicationId"]);
}
DataRow[] ClientMedication2 = dsClientMedications.ClientMedications.Select("StrengthId=" + drTemp[k]["MedicationId"] + " and isnull(recorddeleted,'N')<>'Y'");
if (ClientMedication2.Length > 0)
{
MedicationId2 = Convert.ToInt32(ClientMedication2[0]["ClientMedicationId"]);
}
Streamline.UserBusinessServices.DataSets.DataSetClientMedications.ClientMedicationInteractionsRow[] drExists = null;
string Query = "((MedicationNameId1=" + drTemp[i]["MedicationId"] + " and MedicationNameId2=" + drTemp[k]["MedicationId"] + ") or (MedicationNameId2=" + drTemp[i]["MedicationId"] + " and MedicationNameId1=" + drTemp[k]["MedicationId"] + "))";
Query += " and InteractionLevel<=" + Convert.ToInt32(drTemp[i]["SeverityLevel"]);
Query += " and isnull(recorddeleted,'N')<>'Y'";
drExists = (Streamline.UserBusinessServices.DataSets.DataSetClientMedications.ClientMedicationInteractionsRow[])dsClientMedications.ClientMedicationInteractions.Select(Query);
bool newRow = false;
bool modifyrow = false;
drExists = (Streamline.UserBusinessServices.DataSets.DataSetClientMedications.ClientMedicationInteractionsRow[])dsClientMedications.ClientMedicationInteractions.Select(Query);
Streamline.UserBusinessServices.DataSets.DataSetClientMedications.ClientMedicationInteractionsRow drInteraction = null;
if (drExists.Length > 0)
{
ClientMedicationInteractionId = Convert.ToInt32(drExists[0]["ClientMedicationInteractionId"]);
newRow = false;
modifyrow = false;
if (Convert.ToInt32(drExists[0]["InteractionLevel"]) > Convert.ToInt32(drTemp[i]["SeverityLevel"]))
{
drInteraction = drExists[0];
modifyrow = true;
}
}
else
{
newRow = true;
}
if (newRow == true || modifyrow == true)
{
drInteraction = dsClientMedications.ClientMedicationInteractions.NewClientMedicationInteractionsRow();
drInteraction.ClientMedicationId1 = MedicationId1;
drInteraction.ClientMedicationId2 = MedicationId2;
drInteraction.InteractionLevel = drTemp[i]["SeverityLevel"].ToString();
drInteraction.DrugInteractionMonographId = Convert.ToInt32(drTemp[i]["DrugInteractionMonographId"]);
if (newRow)
{
drInteraction.CreatedBy = ((Streamline.BaseLayer.StreamlineIdentity)Context.User.Identity).UserCode;
drInteraction.CreatedDate = System.DateTime.Now;
}
drInteraction.ModifiedBy = ((Streamline.BaseLayer.StreamlineIdentity)Context.User.Identity).UserCode;
drInteraction.ModifiedDate = System.DateTime.Now;
drInteraction.MedicationNameId1 = Convert.ToInt32(drTemp[i]["MedicationId"]);
drInteraction.MedicationNameId2 = Convert.ToInt32(drTemp[k]["MedicationId"]);
drInteraction.PrescriberAcknowledgementRequired = "Y";
if (newRow)
{
dsClientMedications.ClientMedicationInteractions.Rows.Add(drInteraction);
}
ClientMedicationInteractionId = drInteraction.ClientMedicationInteractionId;
}
}
//Added into ClientMedicationInteractionDetails
bool newDetailsRow = false;
DataRow drClientMedicationDetail = null;
DataRow[] DetailsExists = dsClientMedications.ClientMedicationInteractionDetails.Select("ClientMedicationInteractionId=" + ClientMedicationInteractionId + "and DrugDrugInteractionId=" + Convert.ToInt32(drTemp[i]["DrugDrugInteractionId"]) + " and isnull(recorddeleted,'N')<>'Y'");
if (DetailsExists.Length > 0)
{
drClientMedicationDetail = DetailsExists[0];
newDetailsRow = false;
}
else
{
drClientMedicationDetail = dsClientMedications.ClientMedicationInteractionDetails.NewRow();
newDetailsRow = true;
}
drClientMedicationDetail["ClientMedicationInteractionId"] = ClientMedicationInteractionId;
drClientMedicationDetail["DrugDrugInteractionId"] = drTemp[i]["DrugDrugInteractionId"];
if (newDetailsRow == true)
{
drClientMedicationDetail["RowIdentifier"] = System.Guid.NewGuid().ToString();
drClientMedicationDetail["CreatedBy"] = ((Streamline.BaseLayer.StreamlineIdentity)Context.User.Identity).UserCode;
drClientMedicationDetail["CreatedDate"] = DateTime.Now;
}
drClientMedicationDetail["ModifiedBy"] = ((Streamline.BaseLayer.StreamlineIdentity)Context.User.Identity).UserCode;
drClientMedicationDetail["ModifiedDate"] = DateTime.Now;
if (newDetailsRow)
{
dsClientMedications.ClientMedicationInteractionDetails.Rows.Add(drClientMedicationDetail);
}
}
Session["DataSetClientMedications"] = dsClientMedications;
}
catch (Exception ex)
{
if (ex.Data["CustomExceptionInformation"] == null)
{
ex.Data["CustomExceptionInformation"] = "";
}
else
{
ex.Data["CustomExceptionInformation"] = "";
}
if (ex.Data["DatasetInfo"] == null)
{
ex.Data["DatasetInfo"] = null;
}
throw (ex);
}
}
