private void patient_profile_Edit_Load(object sender, EventArgs e) { try { DataTable dt_doc = this.cntrl.get_all_doctorname(); cmbDoctorName.ValueMember = "id"; cmbDoctorName.DisplayMember = "doctor_name"; cmbDoctorName.DataSource = dt_doc; DateTimePickerDob.MaxDate = DateTime.Now.Date; if (doctor_id != "1") { string id; id = this.cntrl.privillage_E(doctor_id); if (int.Parse(id) > 0) { btnSavePatient.Enabled = false; } else { btnSavePatient.Enabled = true; } id = this.cntrl.privillage_D(doctor_id); if (int.Parse(id) > 0) { btnDelete.Enabled = false; } else { btnDelete.Enabled = true; } } //DataGridViewCheckBoxColumn check = new DataGridViewCheckBoxColumn() //{ // Name = "Check" //}; //grmedical.Columns.Add(check); //check.Width = 100; //check.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; //DataTable dt8 = this.cntrl.get_medicalId(patient_id); //if (dt8.Rows.Count>0) //{ // string mht = this.cntrl.patient_medical(patient_id, dt8.Rows[0][0].ToString()); // if (mht != "") // { // grmedical.Rows.Add(dt8); // } //} //DataGridViewCheckBoxColumn checkgroup = new DataGridViewCheckBoxColumn() //{ // Name = "Check" //}; //dgvgroup.Columns.Add(checkgroup); //checkgroup.Width = 100; //checkgroup.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; //string dt9 = this.cntrl.groupname(); //if (dt9 != "") //{ // string gt = this.cntrl.patient_group(patient_id, dt9); // if (gt != "") // { // dgvgroup.Rows.Add(dt9); // } //} this.MinimumSize = new System.Drawing.Size(570, 650); this.AutoSize = true; this.AutoSizeMode = AutoSizeMode.GrowAndShrink; DataGridViewCheckBoxColumn checkgroup = new DataGridViewCheckBoxColumn() { Name = "Check" }; dgvgroup.Columns.Add(checkgroup); checkgroup.Width = 100; checkgroup.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; DataTable group = this.cntrl.get_groupid(patient_id); for (int j = 0; j < group.Rows.Count; j++) { dgvgroup.Rows.Add(group.Rows[j][0].ToString()); dgvgroup.Rows[j].Cells[1].Value = true; dgvgroup.Rows[j].Cells[0].Style.BackColor = Color.FromArgb(62, 165, 195); dgvgroup.Rows[j].Cells[1].Style.BackColor = Color.FromArgb(62, 165, 195); } DataTable dt9 = this.cntrl.groupname(); for (int k = 0; k < dt9.Rows.Count; k++) { string gt = this.cntrl.patient_group(patient_id, dt9.Rows[k]["name"].ToString()); if (gt == "0") { dgvgroup.Rows.Add(dt9.Rows[k]["name"].ToString()); } } DataGridViewCheckBoxColumn check = new DataGridViewCheckBoxColumn() { Name = "Check" }; grmedical.Columns.Add(check); check.Width = 100; check.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; DataTable dt8 = this.cntrl.get_medicalId(patient_id); for (int j = 0; j < dt8.Rows.Count; j++) { grmedical.Rows.Add(dt8.Rows[j][0].ToString()); grmedical.Rows[j].Cells[1].Value = true; grmedical.Rows[j].Cells[0].Style.BackColor = Color.FromArgb(62, 165, 195); grmedical.Rows[j].Cells[1].Style.BackColor = Color.FromArgb(62, 165, 195); } DataTable dt35 = this.cntrl.Get_medicalname(); for (int j = 0; j < dt35.Rows.Count; j++) { string mht = this.cntrl.patient_medical(patient_id, dt35.Rows[j][0].ToString()); if (mht == "0") { grmedical.Rows.Add(dt35.Rows[j][0].ToString()); } } /// DataTable dt7 = this.cntrl.Get_Patient_Details(patient_id); txtPatientName.Text = dt7.Rows[0]["pt_name"].ToString(); txtPatientId.Text = dt7.Rows[0]["pt_id"].ToString(); txtPatientId.BackColor = Color.White; txtAdhaarId.Text = dt7.Rows[0]["aadhar_id"].ToString(); if (dt7.Rows[0]["gender"].ToString() == "Male") { RBtnMale.Checked = true; } else { RBtnFemale.Checked = true; } string aa = dt7.Rows[0]["date_of_birth"].ToString(); if (dt7.Rows[0]["date_of_birth"].ToString() != "") { DateTimePickerDob.Show(); txtDob.Hide(); DateTimePickerDob.Value = DateTime.Parse(DateTime.Parse(dt7.Rows[0]["date_of_birth"].ToString()).ToString("yyyy-MM-dd")); } else { txtDob.Show(); DateTimePickerDob.Hide(); txtDob.Text = "click here to choose a date"; } if (dt7.Rows[0]["age"].ToString() != "0") { txtAge.Text = dt7.Rows[0]["age"].ToString(); } else { txtAge.Text = ""; } cmbBloodGroup.Text = dt7.Rows[0]["blood_group"].ToString(); txtAccompaniedBy.Text = dt7.Rows[0]["family"].ToString(); txtOccupation.Text = dt7.Rows[0]["Occupation"].ToString(); txtPrimaryMobNbr.Text = dt7.Rows[0]["primary_mobile_number"].ToString(); txtSecondaryMobNbr.Text = dt7.Rows[0]["secondary_mobile_number"].ToString(); txtLandLineNbr.Text = dt7.Rows[0]["landline_number"].ToString(); txtEmail.Text = dt7.Rows[0]["email_address"].ToString(); txtStreetAddress.Text = dt7.Rows[0]["street_address"].ToString(); txtLocality.Text = dt7.Rows[0]["locality"].ToString(); txtCity.Text = dt7.Rows[0]["city"].ToString(); txtPin.Text = dt7.Rows[0]["pincode"].ToString(); txtnationality.Text = dt7.Rows[0]["nationality"].ToString(); txtpassport.Text = dt7.Rows[0]["passport_no"].ToString(); txtReferredBy.Text = dt7.Rows[0]["refferedby"].ToString(); txtFileNo.Text = dt7.Rows[0]["Opticket"].ToString(); string bb = dt7.Rows[0]["Visited"].ToString(); if (dt7.Rows[0]["Visited"].ToString() != "") { DateTimePickerAdmitDate.Show(); txtAdmitDate.Hide(); DateTimePickerAdmitDate.Value = DateTime.Parse(DateTime.Parse(dt7.Rows[0]["Visited"].ToString()).ToString("yyyy-MM-dd")); } else { DateTimePickerAdmitDate.Hide(); txtAdmitDate.Text = "click here to choose a date"; } cmbDoctorName.Text = dt7.Rows[0]["doctorname"].ToString(); try { string curFile = this.cntrl.getserver() + "\\Pappyjoe_utilities\\patient_image\\" + patient_id; if (System.IO.File.Exists(curFile)) { pictureBox_PatientPhoto.Image = Image.FromFile(curFile); } else { pictureBox_PatientPhoto.Image = PappyjoeMVC.Properties.Resources.nophoto; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void txtDob_Click(object sender, EventArgs e) { DateTimePickerDob.Show(); txtDob.Hide(); }