/// <summary> /// Get generic product. /// </summary> /// <param name="genericProductId">The generic product identifier.</param> /// <param name="passKey">The pass key.</param> /// <returns>LexiData.GenericProduct.</returns> public GenericProduct rx_GetGenericProduct(int genericProductId, string passKey) { if (!ValidationAndEncryptDecrypt.ValidateKey(passKey)) { return(null); } SqlConnection dbConn = new SqlConnection(); GenericDAL myDal = null; try { dbConn = OpenLexidataConnection(); myDal = GetLexidataDAL(dbConn); var genericProduct = myDal.GetGenericProduct(genericProductId); return(genericProduct); } catch (Exception e) { StringBuilder sb = new StringBuilder(); sb.AppendLine("Method: rx_GetGenericProduct"); sb.AppendLine(genericProductId == 0 ? "genericProductId is null" : "genericProductId: " + genericProductId); sb.AppendLine(""); sb.AppendLine(e.ExceptionToString()); WriteEventLogEntry(sb.ToString()); sb.Clear(); sb.Destroy(); throw; } finally { myDal.Destroy(); CloseConnection(dbConn); } }
/// <summary> /// The rx_GetDrugInteractions. /// </summary> /// <param name="patientId">The patientId<see cref="int"/>.</param> /// <param name="genDrugId">The genDrugId<see cref="string"/>.</param> /// <param name="passKey">The passKey<see cref="string"/>.</param> /// <returns>The <see cref="List{DrugDrugInterResult}"/>.</returns> public List <DrugDrugInterResult> rx_GetDrugInteractions(int patientId, string genDrugId, string passKey) { if (!ValidationAndEncryptDecrypt.ValidateKey(passKey)) { return(null); } if (patientId == 0) { return(null); } SqlConnection dbConn = new SqlConnection(); GenericDAL myDal = null; try { dbConn = OpenLexidataConnection(); myDal = GetLexidataDAL(dbConn); ScreeningContext interactionScreening = new ScreeningContext(); // add existing drugs SqlCommand cmd = XSql1.CreateStoredProcedureCommand("rx_SelectPatientInteractionData"); cmd.AddParameter("@PatientId", patientId); DataSet interactDs = XSql1.GetDataSet(cmd); foreach (DataRow row in interactDs.Tables[0].Rows) { int productId = row["RootProductId"].ToString().ToInt(0); if (productId > 0) { GenericDrug gd = myDal.GetGenericDrug((myDal.GetGenericProduct(productId)).GenDrugID); if (gd != null) { interactionScreening.Drugs.Add(gd); } } } // Add new drug GenericDrug newGd = myDal.GetGenericDrug(genDrugId); if (newGd != null) { interactionScreening.Drugs.Add(newGd); } var drugInteractions = myDal.GetDrugDrugInteractions(interactionScreening, false, 0); List <DrugDrugInterResult> ddirList = new List <DrugDrugInterResult>(); foreach (DrugDrugInteractionResult ddir in drugInteractions) { DrugDrugInterResult newDdir = new DrugDrugInterResult { Drug1 = { GenDrugId = ddir.Drug1.GenDrugID, GenericName = ddir.Drug1.GenericName }, Drug2 = { GenDrugId = ddir.Drug2.GenDrugID, GenericName = ddir.Drug2.GenericName }, InteractionDescription = ddir.InteractionDescription, SeverityDescription = ddir.SeverityDescription }; ddirList.Add(newDdir); } return(ddirList); } catch (Exception e) { StringBuilder sb = new StringBuilder(); sb.AppendLine("Method: rx_GetDrugInteractions"); sb.AppendLine("PatientId: " + patientId); sb.AppendLine(genDrugId == null ? "genDrugId is null" : "genDrugId: " + genDrugId); sb.AppendLine(""); sb.AppendLine(e.ExceptionToString()); WriteEventLogEntry(sb.ToString()); sb.Clear(); sb.Destroy(); throw; } finally { myDal.Destroy(); CloseConnection(dbConn); } }
/// <summary> /// Get drug 2 drug interactions. /// </summary> /// <param name="productId">The product identifier.</param> /// <param name="genDrugId">The gen drug identifier.</param> /// <param name="passKey">The pass key.</param> /// <returns>List<DrugDrugInterResult>.</returns> public List <DrugDrugInterResult> rx_GetDrugDrugInteractions(int productId, string genDrugId, string passKey) { if (!ValidationAndEncryptDecrypt.ValidateKey(passKey)) { return(null); } if (productId == 0) { return(null); } SqlConnection dbConn = new SqlConnection(); GenericDAL myDal = null; try { dbConn = OpenLexidataConnection(); myDal = GetLexidataDAL(dbConn); ScreeningContext screen = new ScreeningContext(); GenericDrug gd = myDal.GetGenericDrug((myDal.GetGenericProduct(productId)).GenDrugID); if (gd != null) { screen.Drugs.Add(gd); } GenericDrug newGd = myDal.GetGenericDrug(genDrugId); if (gd != null) { screen.Drugs.Add(newGd); } var drugInteractions = myDal.GetDrugDrugInteractions(screen, false, 0); List <DrugDrugInterResult> r = new List <DrugDrugInterResult>(); foreach (DrugDrugInteractionResult ir in drugInteractions) { DrugDrugInterResult newR = new DrugDrugInterResult { Drug1 = { GenDrugId = ir.Drug1.GenDrugID, GenericName = ir.Drug1.GenericName }, Drug2 = { GenDrugId = ir.Drug2.GenDrugID, GenericName = ir.Drug2.GenericName }, InteractionDescription = ir.InteractionDescription, SeverityDescription = ir.SeverityDescription }; r.Add(newR); } return(r); } catch (Exception e) { StringBuilder sb = new StringBuilder(); sb.AppendLine("Method: rx_GetDrugDrugInteractions"); sb.AppendLine("ProductId: " + productId); sb.AppendLine(genDrugId == null ? "genDrugId is null" : "genDrugId: " + genDrugId); sb.AppendLine(""); sb.AppendLine(e.ExceptionToString()); WriteEventLogEntry(sb.ToString()); sb.Clear(); sb.Destroy(); throw; } finally { myDal.Destroy(); CloseConnection(dbConn); } }