Example #1
0
        private void prescriptionDataGridView_MouseDoubleClick(object sender, MouseEventArgs e)
        {
            DataSet1TableAdapters.Prescription_DrugTableAdapter presc_drug = new DataSet1TableAdapters.Prescription_DrugTableAdapter();
            DataSet1.Prescription_DrugDataTable dt = presc_drug.GetDataByPrescriptionId((int)((DataRowView)prescriptionBindingSource.Current)["ID"]);
            String tmp = "DATE:\t" + Convert.ToString(((DataRowView)prescriptionBindingSource.Current)["DATE"]) + "\nDoctor:\t" + Convert.ToString(((DataRowView)prescriptionBindingSource.Current)["Doctor_ID"])
                         + "\nPatient:\t" + Convert.ToString(((DataRowView)prescriptionBindingSource.Current)["Patient_ID"]) + "\n";

            foreach (DataRow row in dt)
            {
                tmp += Convert.ToString((String)drugTableAdapter.GetDataByID(Convert.ToInt32(row["DrugID"])).Rows[0]["Name"])
                       + ":\t" + Convert.ToString(row["NumOfUnits"]) + "\n";
            }

            MessageBox.Show(tmp);
        }
Example #2
0
        private void btnOk_Click(object sender, EventArgs e)
        {
            if (drugIDComboBox.Text.Trim() == "" || numOfUnitsMaskedTextBox.Text.Trim() == "")
            {
                MessageBox.Show("doctor & patient Error");
                return;
            }

            DataSet1TableAdapters.Prescription_DrugTableAdapter pd = new DataSet1TableAdapters.Prescription_DrugTableAdapter();
            DataSet1.Prescription_DrugDataTable dt = pd.GetDataByPDID(PrescriptionID, (int)drugIDComboBox.SelectedValue);
            if (dt.Rows.Count > 0)
            {
                MessageBox.Show("Drug Error");
                return;
            }

            this.Validate();
            this.prescription_DrugBindingSource.EndEdit();
            ((DataRowView)prescription_DrugBindingSource.Current)["DrugID"] = (int)drugIDComboBox.SelectedValue;
            this.prescription_DrugTableAdapter.Update(this.dataSet1.Prescription_Drug);
            DialogResult = DialogResult.OK;
        }