Esempio n. 1
0
        private void OutPatientEntry_Load(object sender, EventArgs e)
        {
            this.KeyPreview = true;
            txtOpId.Text    = xDb.GetMaxId("txno", "outpatientdetails").ToString();
            cmbCaseType.Select();
            LoadGrid();
            cmbCaseType.SelectedIndex        = 0;
            cmbNoonType.SelectedIndex        = 0;
            cmbCaseType1.SelectedIndex       = 0;
            cmbOpPatientStatus.SelectedIndex = 1;
            cmbPaymentStatus.SelectedIndex   = 1;
            ConfigResponseModel configResponseModel = xDb.GetConfig();
            DoctorResponseModel doctorResponseModel = xDb.GetDoctorFromDoctorId(Convert.ToInt32(configResponseModel.DefualtDoctor));

            if (doctorResponseModel.DoctorId == 0)
            {
                MessageBox.Show("Could not Find Doctor Details");
            }
            {
                txtDoctorId.Text   = doctorResponseModel.DoctorId.ToString();
                txtDoctorName.Text = doctorResponseModel.DoctorName;
            }
            txtFees.Text = "150";
            GetMaxTokenNo();
        }
Esempio n. 2
0
        private void btnEdit_Click(object sender, EventArgs e)
        {
            if (txtLabId.Text == "")
            {
                MessageBox.Show("Please Enter Lab Id");
                txtLabId.Focus();
                return;
            }

            LabResponseModel     labResponse     = xDb.GetLabRecordFromLabId(Convert.ToInt32(txtLabId.Text));
            PatientResponseModel patientResponse = xDb.GetPatientFromPatientId(labResponse.PatientId);
            DoctorResponseModel  doctorResponse  = xDb.GetDoctorFromDoctorId(labResponse.DoctorId);

            txtBillDate.Text    = labResponse.BillDate.ToString();
            txtPatientId.Text   = patientResponse.PatientId.ToString();
            txtPatientName.Text = patientResponse.PatientName.ToString();
            txtUhid.Text        = patientResponse.UHID.ToString();
            txtDoctorName.Text  = doctorResponse.DoctorName;

            string xQry = "select bld.lab_id,bld.test_id,ltf.test_name as TestName, " +
                          " ltf.test_description as TestDescription, " +
                          " bld.patient_test_details as PatientTestDetails  " +
                          " from billing_lab_details bld, " +
                          " m_lab_test_fees ltf, billing_lab bl" +
                          " where bld.test_id = ltf.lab_test_fees_id " +
                          " and bl.lab_id = bld.lab_id and bld.lab_id= " + txtLabId.Text;

            xDb.LoadGrid(xQry, dataGridView1);
            dataGridView1.Columns[0].Visible = false;
            dataGridView1.Columns[1].Visible = false;
            dataGridView1.Columns[2].Width   = 200;
            txtLabId.Enabled  = false;
            btnUpdate.Enabled = true;
            btnView.Enabled   = true;
        }
        private void cmbIPNo_SelectedIndexChanged(object sender, EventArgs e)
        {
            IPDetailModel        ipResponse      = xDb.GetIpDetailsFromIpNo(Convert.ToInt32(cmbIPNo.Text));
            PatientResponseModel patientResponse = xDb.GetPatientFromPatientId(ipResponse.PatientId);
            DoctorResponseModel  doctorResponse  = xDb.GetDoctorFromDoctorId(ipResponse.DoctorId);

            txtPatientName.Text = patientResponse.PatientName.ToString();
            txtDoctorName.Text  = doctorResponse.DoctorName;
            txtCaseType.Text    = xDb.GetCaseTypeNameFromCaseTypeId(ipResponse.CaseTypeId);
        }
        public DoctorResponseModel GetDoctorFromDoctorId(int xDoctorId)
        {
            DoctorResponseModel model = new DoctorResponseModel();

            using (connection = new MySqlConnection(conString))
            {
                string xQry = "select * from m_doctor where  doctor_id = " + xDoctorId + "";
                connection.Open();
                MySqlCommand comm = new MySqlCommand(xQry, connection);

                MySqlDataReader reader = comm.ExecuteReader();

                while (reader.Read())
                {
                    model = new DoctorResponseModel()
                    {
                        DoctorId   = Convert.ToInt32(reader.GetInt32(0)),
                        DoctorName = reader.GetString(1)
                    };
                }
                connection.Close();
            }
            return(model);
        }