///<summary>Inserts one Formulary into the database. Returns the new priKey.</summary>
internal static long Insert(Formulary formulary)
{
if(DataConnection.DBtype==DatabaseType.Oracle) {
formulary.FormularyNum=DbHelper.GetNextOracleKey("formulary","FormularyNum");
int loopcount=0;
while(loopcount<100){
try {
return Insert(formulary,true);
}
catch(Oracle.DataAccess.Client.OracleException ex){
if(ex.Number==1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated")){
formulary.FormularyNum++;
loopcount++;
}
else{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else {
return Insert(formulary,false);
}
}
///<summary>Inserts one Formulary into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(Formulary formulary, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
formulary.FormularyNum = ReplicationServers.GetKey("formulary", "FormularyNum");
}
string command = "INSERT INTO formulary (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "FormularyNum,";
}
command += "Description) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(formulary.FormularyNum) + ",";
}
command +=
"'" + POut.String(formulary.Description) + "')";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
formulary.FormularyNum = Db.NonQ(command, true);
}
return(formulary.FormularyNum);
}
///<summary>Inserts one Formulary into the database. Returns the new priKey.</summary>
internal static long Insert(Formulary formulary)
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
formulary.FormularyNum = DbHelper.GetNextOracleKey("formulary", "FormularyNum");
int loopcount = 0;
while (loopcount < 100)
{
try {
return(Insert(formulary, true));
}
catch (Oracle.DataAccess.Client.OracleException ex) {
if (ex.Number == 1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated"))
{
formulary.FormularyNum++;
loopcount++;
}
else
{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else
{
return(Insert(formulary, false));
}
}
private List <Formulary> getFormularies()
{
List <Formulary> result = new List <Formulary>();
MySqlConnection sqlCon = Configurations.connection;
if (sqlCon.State == ConnectionState.Closed)
{
sqlCon.Open();
}
String query = "SELECT * FROM formulary ;";
MySqlCommand sqlCmd = new MySqlCommand(query, sqlCon);
sqlCmd.CommandType = CommandType.Text;
int count = Convert.ToInt32(sqlCmd.ExecuteScalar());
MySqlDataReader reader = sqlCmd.ExecuteReader();
while (reader.Read())
{
Formulary form = new Formulary();
{
form.IdFormulary = reader.GetInt32(0);
form.Name = reader.GetString(1);
form.Type = reader.GetString(3);
form.Description = reader.GetString(3);
};
result.Add(form);
}
reader.Close();
sqlCon.Close();
return(result);
}
///<summary>Updates one Formulary in the database.</summary>
internal static void Update(Formulary formulary)
{
string command = "UPDATE formulary SET "
+ "Description = '" + POut.String(formulary.Description) + "' "
+ "WHERE FormularyNum = " + POut.Long(formulary.FormularyNum);
Db.NonQ(command);
}
public QuizzPage(int id, int userId)
{
InitializeComponent();
questionList = getQuestions(id);
form = form.getFormById(id);
formId = id;
actualQuestion = 0;
this.userId = userId;
displayQuestion();
}
public QuizzQuestionsPage(string id)
{
InitializeComponent();
this.IdForm = Int32.Parse(id);
List <Question> result = getQuestions();
questionList.ItemsSource = result;
DataContext = result;
form = form.getFormById(IdForm);
this.id = id;
}
/// <summary>
/// This method is used to store a formulary in DB.
/// </summary>
/// <param name="formulary">formulary to be inserted/updated.</param>
public async Task <bool> ProcessFormularyRequest(Formulary formulary)
{
_logger.LogInformation(string.Format(CommonConstants.LoggingMessage.DataReceivedFromFormulary, JsonConvert.SerializeObject(formulary)));
var result = await _formularyRepository.GetFormularyById(formulary.FormularyId);
if (result == null)
{
return(await _formularyRepository.InsertFormulary(formulary));
}
else
{
return(await _formularyRepository.UpdateFormulary(formulary));
}
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <Formulary> TableToList(DataTable table)
{
List <Formulary> retVal = new List <Formulary>();
Formulary formulary;
for (int i = 0; i < table.Rows.Count; i++)
{
formulary = new Formulary();
formulary.FormularyNum = PIn.Long(table.Rows[i]["FormularyNum"].ToString());
formulary.Description = PIn.String(table.Rows[i]["Description"].ToString());
retVal.Add(formulary);
}
return(retVal);
}
private bool SetExceptionTransaction(Facility facility, Formulary formulary, FacilityFormulary facilityFormulary, FacilityStorageSpace storageSpaceInfo, TransactionRequest request, Item item, int quantity, TransactionQueueModel newTransaction)
{
var isItemAccepted = (facilityFormulary != null && facilityFormulary.Approved) ? true : false;
var isActiveFormulary = (formulary != null && !formulary.IsActive.GetValueOrDefault()) ? false : true;
if (formulary == null)
{
newTransaction.Description = item.ItemName;
SetTransactionException(newTransaction, CommonConstants.TransactionException.UnknownItemId);
if (!int.TryParse(item.OrderAmount.Trim(), out quantity))
{
newTransaction.Exception += Environment.NewLine + CommonConstants.TransactionException.InvalidQuantity;
}
newTransaction.Quantity = quantity;
return(true);
}
if (!isActiveFormulary)
{
SetTransactionException(newTransaction, CommonConstants.TransactionException.InactiveFormularyItem);
return(true);
}
if (facilityFormulary == null)
{
SetTransactionException(newTransaction, CommonConstants.TransactionException.FormularyNotMapped);
return(true);
}
if (!isItemAccepted)
{
SetTransactionException(newTransaction, CommonConstants.TransactionException.NotApprovedFormularyItem);
return(true);
}
if (quantity <= 0)
{
SetTransactionException(newTransaction, CommonConstants.TransactionException.InvalidUnitQuantity);
return(true);
}
if (storageSpaceInfo == null)
{
SetTransactionException(newTransaction, CommonConstants.TransactionException.UnassignedLocation);
return(true);
}
return(false);
}
///<summary>Updates one Formulary in the database. Uses an old object to compare to, and only alters changed fields. This prevents collisions and concurrency problems in heavily used tables.</summary>
internal static void Update(Formulary formulary, Formulary oldFormulary)
{
string command = "";
if (formulary.Description != oldFormulary.Description)
{
if (command != "")
{
command += ",";
}
command += "Description = '" + POut.String(formulary.Description) + "'";
}
if (command == "")
{
return;
}
command = "UPDATE formulary SET " + command
+ " WHERE FormularyNum = " + POut.Long(formulary.FormularyNum);
Db.NonQ(command);
}
///<summary>Inserts one Formulary into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(Formulary formulary,bool useExistingPK)
{
if(!useExistingPK && PrefC.RandomKeys) {
formulary.FormularyNum=ReplicationServers.GetKey("formulary","FormularyNum");
}
string command="INSERT INTO formulary (";
if(useExistingPK || PrefC.RandomKeys) {
command+="FormularyNum,";
}
command+="Description) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(formulary.FormularyNum)+",";
}
command+=
"'"+POut.String(formulary.Description)+"')";
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command);
}
else {
formulary.FormularyNum=Db.NonQ(command,true);
}
return formulary.FormularyNum;
}
private void SetTransactionDetails(TransactionPriority priority, Formulary formulary, Facility facility,
FacilityFormulary facilityFormulary, Destination destination, TransactionRequest incomingRequest,
Item item, int partNo, int orderCount, TransactionQueueModel newTransaction, int quantity)
{
var localNow = DateTime.Now;
var utcNow = DateTime.UtcNow;
User usr = new User(UserName.Admin.ToString());
newTransaction.StatusChangeDT = localNow;
newTransaction.StatusChangeUtcDateTime = utcNow;
if (formulary != null)
{
newTransaction.Description = (priority != null && priority.UseInterfaceItemName.GetValueOrDefault()) ? item.ItemName : formulary.Description;
newTransaction.FormularyId = formulary.FormularyId;
}
// Apply ADU Round if Qualifies
if (quantity > 0 && facility != null && priority != null && destination != null &&
facilityFormulary != null && (priority.IsAdu != null && (bool)priority.IsAdu) &&
(facility.AduQtyRounding != null && (bool)facility.AduQtyRounding) &&
(facilityFormulary.AduQtyRounding != null && (bool)facilityFormulary.AduQtyRounding) &&
(destination.AduQtyRounding != null && (bool)destination.AduQtyRounding))
{
newTransaction.Quantity = AduQtyRound(quantity);
newTransaction.QuantityProcessed = newTransaction.Quantity;
_logger.LogInformation(string.Format(CommonConstants.LoggingMessage.AduQuantity, newTransaction.Quantity, incomingRequest.RequestId));
}
else
{
newTransaction.Quantity = quantity;
newTransaction.QuantityProcessed = newTransaction.Quantity;
}
newTransaction.Type = TransactionType.Pick;
newTransaction.OrderId = incomingRequest.Order?.OrderNo;
newTransaction.ItemId = item.ItemId;
if (!string.IsNullOrEmpty(item.ComponentStrength))
{
newTransaction.Strength = item.ComponentStrength.Trim();
}
if (!string.IsNullOrEmpty(item.ComponentStrengthUnits))
{
newTransaction.StrengthUnit = item.ComponentStrengthUnits.Trim();
}
//set these two to real values for display purposes
newTransaction.ComponentNumber = partNo;
newTransaction.NumberOfComponents = orderCount;
// Patient info
SetPatientInfo(newTransaction, incomingRequest);
newTransaction.FacilityId = facility.Id;
newTransaction.IncomingRequestId = incomingRequest.RequestId;
if (priority != null)
{
newTransaction.TranPriorityId = priority.TransactionPriorityId;
}
newTransaction.ReceivedDt = localNow;
newTransaction.ReceivedUtcDateTime = utcNow;
if (usr != null)
{
newTransaction.RequestedBy = usr.UserName;
}
if (!string.IsNullOrEmpty(incomingRequest.Patient?.DeliverToLocation))
{
newTransaction.Destination = incomingRequest.Patient.DeliverToLocation.Trim();
}
if (!string.IsNullOrEmpty(newTransaction.Exception) &&
newTransaction.Exception.Length > 80)
{
newTransaction.Exception = newTransaction.Exception.Substring(0, 80);
}
if (!string.IsNullOrEmpty(item.Concentration))
{
newTransaction.Concentration = item.Concentration.Trim();
}
if (!string.IsNullOrEmpty(item.TotalDose))
{
newTransaction.TotalDose = item.TotalDose.Trim();
}
if (!string.IsNullOrEmpty(item.DispenseAmount))
{
newTransaction.DispenseAmount = item.DispenseAmount.Trim();
}
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List<Formulary> TableToList(DataTable table)
{
List<Formulary> retVal=new List<Formulary>();
Formulary formulary;
for(int i=0;i<table.Rows.Count;i++) {
formulary=new Formulary();
formulary.FormularyNum= PIn.Long (table.Rows[i]["FormularyNum"].ToString());
formulary.Description = PIn.String(table.Rows[i]["Description"].ToString());
retVal.Add(formulary);
}
return retVal;
}
///<summary>Updates one Formulary in the database.</summary>
internal static void Update(Formulary formulary)
{
string command="UPDATE formulary SET "
+"Description = '"+POut.String(formulary.Description)+"' "
+"WHERE FormularyNum = "+POut.Long(formulary.FormularyNum);
Db.NonQ(command);
}
///<summary>Updates one Formulary in the database. Uses an old object to compare to, and only alters changed fields. This prevents collisions and concurrency problems in heavily used tables.</summary>
internal static void Update(Formulary formulary,Formulary oldFormulary)
{
string command="";
if(formulary.Description != oldFormulary.Description) {
if(command!=""){ command+=",";}
command+="Description = '"+POut.String(formulary.Description)+"'";
}
if(command==""){
return;
}
command="UPDATE formulary SET "+command
+" WHERE FormularyNum = "+POut.Long(formulary.FormularyNum);
Db.NonQ(command);
}
protected override void Page_Load(object sender, EventArgs e)
{
try
{
var MedicationId = Request.QueryString["MedicationId"].ToString();
var PrescriberId = Request.QueryString["PrescriberId"].ToString();
var ClientId = ((Streamline.BaseLayer.StreamlinePrinciple)Context.User).Client.ClientId.ToString();
Eligibility objEligibility = new Eligibility();
string response = objEligibility.GetEligibility(ClientId, PrescriberId);
List <PBM> listpbm = new List <PBM>();
Formulary objFormulary = new Formulary(ClientId, MedicationId);
objFormulary = objFormulary.GetFormulary();
if (!IsPostBack)
{
BindDropdown(objFormulary); //Fill the dropdown with all pbm
int index = objFormulary.DefaultPBMIndex; //pbmListNo represents the pbm having highest formulary status
ddlPBM.SelectedIndex = index;
}
if (objFormulary.Alternative == null && objFormulary.Copays == null && objFormulary.Coverage == null && objFormulary.DefaultPBMName == null &&
objFormulary.DrugClass == null && objFormulary.DrugType == null && objFormulary.PatientDetails == null)
{
Status.Text = objFormulary.FormularyStatus;
}
else
{
Status.Text = "";
}
lbPBMName.Text = objFormulary.DefaultPBMName; //Set the PBM Name, DefaultPBMName is the properties that always holds current PBM Name
lbFormulary.Text = objFormulary.FormularyStatus; //Formulary Status of Medication, Example:- On Formulary, Prefered Formulary-3 etc
lbDrugType.Text = objFormulary.DrugType; //Drug Type that display Branded or Generic
lbDrugClass.Text = objFormulary.DrugClass;
DataTable dtPatient = new DataTable(); //Create a Datatable to store all the patient Details
dtPatient.Columns.Add("InfoType", typeof(string));
dtPatient.Columns.Add("Info", typeof(string));
if (objFormulary.PatientDetails != null) //Display Patient Details
{
Patient objPatient = objFormulary.PatientDetails; //"PatientDetails" gets the the object of Patient class which gives all the patient details as properties
if (objPatient.LastName != string.Empty)
{
dtPatient.Rows.Add("Patient Name", objPatient.Suffix + " "
+ objPatient.FirstName + " " + objPatient.MiddleName + " "
+ objPatient.LastName);
}
if (objPatient.Address1 != string.Empty || objPatient.City != string.Empty ||
objPatient.State != string.Empty || objPatient.Zip != string.Empty)
{
dtPatient.Rows.Add("Address", objPatient.Address1 + "\r\n"
+ objPatient.Address2 + "\r\n" + objPatient.City + "\r\n"
+ objPatient.State + "\r\n" + objPatient.Zip);
}
if (objPatient.Gender != string.Empty)
{
dtPatient.Rows.Add("Gender", objPatient.Gender); //Add Gender to Datatable
}
if (objPatient.DOB != string.Empty)
{
dtPatient.Rows.Add("DOB", objPatient.DOB); //Add DOB to Datatable
}
}
GVPatient.DataSource = dtPatient;
GVPatient.DataBind();
#region Copay details
DataTable dtCop = new DataTable(); //Create a datatable to store all copay
dtCop = CopayDetails(objFormulary.Copays); //Copays is a property which is a collection of object of Class Copay
//CopayDetails() collects all the copay details and keep them Datatable
GVCOPAY.DataSource = dtCop;
GVCOPAY.DataBind();
#endregion
#region CoverageDetails
if (objFormulary.Coverage != null)
{
DataTable CoverageTable = new DataTable(); //Create a Coverage Table that holds all the copay details
CoverageTable = CoverageDetails(objFormulary.Coverage); //ObjFormulary.Coverage--> Coverage is the property Which is a collection of property
GVCOV.DataSource = CoverageTable;
GVCOV.DataBind();
}
#endregion
#region Therapeutic alternative
DataTable dtTherapeutic = new DataTable(); //Create a datatable to holds Therapeutic alternative
dtTherapeutic.Columns.Add("Therapeutic", typeof(DataTable)); //Datatable is having a single column of type DataTable
if (objFormulary.TherapeuticAlternative != null) //TherapeuticAlternative is the propery which is the collection of all the therapeutic Details
{
foreach (AlternativeMedication objTherapeutic in objFormulary.TherapeuticAlternative) //objTherapeutic is the object of class AlternativeMedication
{ //which is a set of properties
DataTable dtInnerTherapeutic = new DataTable(); //Create a DataTable that contains Medication Name, Formulary Status, Drug Type
dtInnerTherapeutic.Columns.Add("Type", typeof(string));
dtInnerTherapeutic.Columns.Add("Data", typeof(string));
dtInnerTherapeutic.Rows.Add("Medication Name:", objTherapeutic.MedicationName); //Medication Name of Therapeutic Medication
dtInnerTherapeutic.Rows.Add("FormularyStatus", objTherapeutic.FormularyStatus); //Formulary Status of Therapeutic Medication
dtInnerTherapeutic.Rows.Add("Drug Type", objTherapeutic.DrugType); //
DataTable dtCopayTherap = CopayDetails(objTherapeutic.Copays); //CopayDetails takes a collection of object of class
//Copay and each object have its own properties
foreach (DataRow dr in dtCopayTherap.Rows)
{
dtInnerTherapeutic.ImportRow(dr); //Import Copay Details to the inner table
}
dtTherapeutic.Rows.Add(dtInnerTherapeutic);
if (objTherapeutic.Coverages != null)
{
DataTable dtCov = new DataTable();
dtCov = CoverageDetails(objTherapeutic.Coverages);
foreach (DataRow dr in dtCov.Rows)
{
dtInnerTherapeutic.ImportRow(dr);
}
dtTherapeutic.Rows.Add(dtInnerTherapeutic);
}
}
GVTHALT.DataSource = dtTherapeutic;
GVTHALT.DataBind();
}
#endregion
#region alternative
DataTable dtAlt = new DataTable();
dtAlt.Columns.Add("ALT", typeof(DataTable));
if (objFormulary.Alternative != null)
{
foreach (AlternativeMedication Alt in objFormulary.Alternative)
{
DataTable dtAlt1 = new DataTable();
dtAlt1.Columns.Add("Type", typeof(string));
dtAlt1.Columns.Add("Data", typeof(string));
dtAlt1.Rows.Add("Medication Name:", Alt.MedicationName);
dtAlt1.Rows.Add("FormularyStatus", Alt.FormularyStatus);
dtAlt1.Rows.Add("Drug Type", Alt.DrugType);
DataTable dtcop = CopayDetails(Alt.Copays);
foreach (DataRow dr in dtcop.Rows) //Add Copay Details
{
dtAlt1.ImportRow(dr);
}
//dtAlt.Rows.Add(dtAlt1);
if (Alt.Coverages != null)
{
DataTable dtCov = new DataTable();
dtCov = CoverageDetails(Alt.Coverages);
foreach (DataRow dr in dtCov.Rows)
{
dtAlt1.ImportRow(dr);
}
}
dtAlt.Rows.Add(dtAlt1);
}
GVALT.DataSource = dtAlt;
GVALT.DataBind();
#endregion
}
}
catch (Exception ex) { }
}
/// <summary>
/// This method is used to store a formulary facility in DB.
/// </summary>
/// <param name="formulary">formulary facility to be updated.</param>
public async Task <bool> UpdateFormularyFacility(Formulary formulary)
{
_logger.LogInformation(string.Format(CommonConstants.LoggingMessage.DataReceivedFromFormularyFacility, JsonConvert.SerializeObject(formulary)));
return(await _formularyRepository.UpdateFormularyFacility(formulary));
}
private void BindDropdown(Formulary objformulary)
{
ddlPBM.DataSource = objformulary.PBMs; //PBMS is the list of all PBM for a patient
ddlPBM.DataTextField = "Name"; //Shows PBMNAME
ddlPBM.DataBind();
}
