//protected void DeleteProcedure_ServerClick(object sender, EventArgs e)
        //{
        //    string UserName = Session["User"].ToString();
        //    int ID = Convert.ToInt32(HiddenFieldPatientProcedure.Value);

        //    PatientProcedureDAL oProcedureDAL = new PatientProcedureDAL();
        //    PatientProcedureModel oProcedureClass = new PatientProcedureModel();

        //    oProcedureClass.IsDeleted = true;
        //    oProcedureClass.ReasonDelete = deleteCPTReason.InnerText;
        //    string lbl = lblPatientProcedure.Text;
        //    oProcedureClass.ID = ID;
        //    oProcedureDAL.DeleteData(UserName, oProcedureClass);

        //    PopulateOrders(EncounterNo.Value);
        //}

        protected void AddMedication_ServerClick(object sender, EventArgs e)
        {
            string sUserName = Session["User"].ToString();

            PatientMedicationDAL   oMedicationDAL   = new PatientMedicationDAL();
            PatientMedicationModel oMedicationClass = new PatientMedicationModel();

            oMedicationClass.EncounterNo = EncounterNo.Value;
            oMedicationClass.PatientNo   = PatientNo.Value;
            oMedicationClass.CaseNo      = "";
            oMedicationClass.Code        = medsList.SelectedValue;     //txtMedCode.Value;
            oMedicationClass.Description = medsList.SelectedItem.Text; //txtMedDescription.Value;
            oMedicationClass.Dosage      = Prescription.Value;         //txtMedDose.Value;
            oMedicationClass.PatientNo   = PatientNo.Value;
            oMedicationClass.StartDate   = DateTime.Now;
            oMedicationClass.Notes       = "";
            oMedicationDAL.InsertData(sUserName, oMedicationClass);

            if (cbFavorite.Checked == true)
            {
                var medFavoriteModel = new PhysicianPrescriptionTemplateModel();
                var medFavoriteDal   = new PhysicianPrescriptionTemplateDAL();

                medFavoriteModel.PhysicianID = Convert.ToInt16(PhysicianID.Value);
                medFavoriteModel.Dosage      = Prescription.Value;
                medFavoriteDal.InsertData(sUserName, medFavoriteModel);
                LoadPrescriptionFavorite(Convert.ToInt16(PhysicianID.Value));
            }

            PopulateMeds(EncounterNo.Value);
            ClearEntry();
        }
        private void LoadPrescriptionFavorite(int PhysicianID)
        {
            var prescriptionFavoriteModel = new PhysicianPrescriptionTemplateModel();
            var prescriptionFavoriteDAl   = new PhysicianPrescriptionTemplateDAL();

            oDs = new DataSet();

            prescriptionFavoriteModel.PhysicianID = PhysicianID;
            oDs = prescriptionFavoriteDAl.SelectByPhysicianID(prescriptionFavoriteModel);

            var dosageTable = new DataTable();

            dosageTable.Columns.Add("Dosage");
            var dosageRow = dosageTable.NewRow();

            dosageRow[0] = "--Select Favorite--";
            dosageTable.Rows.Add(dosageRow);

            if (oDs != null)
            {
                if (oDs.Tables[0].Rows.Count > 0)
                {
                    for (int i = 0; i <= oDs.Tables[0].Rows.Count - 1; i++)
                    {
                        var dosageFavorite = dosageTable.NewRow();
                        dosageFavorite[0] = oDs.Tables[0].Rows[i]["dosage"].ToString();
                        dosageTable.Rows.Add(dosageFavorite);
                    }
                }
            }

            ddlPrescriptionTemplate.DataSource     = dosageTable;
            ddlPrescriptionTemplate.DataTextField  = "dosage";
            ddlPrescriptionTemplate.DataValueField = "dosage";
            ddlPrescriptionTemplate.DataBind();
        }