private void button1_Click(object sender, EventArgs e) { App_Data.PisDataSetTableAdapters.PatientsTableAdapter myPatAd = new App_Data.PisDataSetTableAdapters.PatientsTableAdapter(); App_Data.PisDataSet.PatientsDataTable myPatTable = new App_Data.PisDataSet.PatientsDataTable(); App_Data.PisDataSetTableAdapters.ImagesTableAdapter myImgAd = new App_Data.PisDataSetTableAdapters.ImagesTableAdapter(); App_Data.PisDataSet.ImagesDataTable myImgtbl = new App_Data.PisDataSet.ImagesDataTable(); if (publicClass.IsModification) { try { if (txtImageLocation.Text != "" && cmbImageIndex.SelectedIndex != -1) { myImgAd.UpdateImageLocationQuery(txtImageLocation.Text, Convert.ToInt32(cmbImageID.Items[cmbImageIndex.SelectedIndex])); } myPatAd.UpdatePatientQuery(txtpatientName.Text, txtAge.Text, Convert.ToDateTime(Convert.ToDateTime(txtDate.Text).ToShortDateString()), txtMobileNo.Text, txtLandLine.Text, txtDoctorName.Text, txtAddress.Text, txtComplaint.Text, txtFindings.Text, publicClass.PatientID); MessageBox.Show("Updated Successfully"); } catch (Exception exc) { MessageBox.Show("Update Error! " + exc.Message); } } else { try { txtImageLocation.Width = 193; myImgAd.InsertImageQuery(txtImageLocation.Text, publicClass.PatientID); myPatAd.InsertQuery(txtpatientName.Text, Convert.ToInt32(txtAge.Text).ToString(), Convert.ToDateTime(Convert.ToDateTime(txtDate.Text).ToShortDateString()), txtMobileNo.Text, txtLandLine.Text, txtDoctorName.Text, txtAddress.Text, txtComplaint.Text, txtFindings.Text); MessageBox.Show("Record Added!"); } catch (Exception exc) { MessageBox.Show("Add Error!! " + exc.Message); } } }
private void btnDelete_Click(object sender, EventArgs e) { if (listView1.SelectedItems.Count!=1) { MessageBox.Show("Select a record to delete."); } else if (MessageBox.Show("Really delete?", "Confirm delete", MessageBoxButtons.YesNo) == DialogResult.Yes) { setPatientID(); PatientInformationSystem.App_Data.PisDataSetTableAdapters.PatientsTableAdapter patientsDA = new App_Data.PisDataSetTableAdapters.PatientsTableAdapter(); PatientInformationSystem.App_Data.PisDataSetTableAdapters.HistoryTableAdapter HsitoryDA = new App_Data.PisDataSetTableAdapters.HistoryTableAdapter(); App_Data.PisDataSetTableAdapters.ImagesTableAdapter ImagesDa = new App_Data.PisDataSetTableAdapters.ImagesTableAdapter(); patientsDA.DeletePatientQuery(publicClass.PatientID); ImagesDa.DeleteImagesQuery(publicClass.PatientID); HsitoryDA.DeleteHistoryQuery(publicClass.PatientID); MessageBox.Show("Record Deleted Successfully!"); listView1.Items.Clear(); } }
private void DetailsForm_Load(object sender, EventArgs e) { App_Data.PisDataSetTableAdapters.PatientsTableAdapter myPatientDa = new App_Data.PisDataSetTableAdapters.PatientsTableAdapter(); App_Data.PisDataSet.PatientsDataTable myTbl = new App_Data.PisDataSet.PatientsDataTable(); try { myPatientDa.FillPatientByIDBy(myTbl, Classes.publicClass.PatientID); lblNname.Text = myTbl.Rows[0]["PatientName"].ToString(); lblAge.Text = myTbl.Rows[0]["PatientAge"].ToString(); lblLandLineNo.Text = myTbl.Rows[0]["PatientLandLineNo"].ToString(); lblMobileNo.Text = myTbl.Rows[0]["PatientMobileNo"].ToString(); lblPatientAddress.Text = myTbl.Rows[0]["PatientAddress"].ToString(); lblDoctorName.Text = myTbl.Rows[0]["PatientDoctor"].ToString(); lblDov.Text = Text = Convert.ToDateTime(myTbl.Rows[0]["PatientDOA"].ToString()).ToShortDateString(); txtClinicFindings.Text = myTbl.Rows[0]["PatientClinicalFindings"].ToString(); txtComplaint.Text = myTbl.Rows[0]["PatientComplaint"].ToString(); } catch(Exception exc) { MessageBox.Show("Error!! " + exc.Message ); } }
private void btnSearch_Click(object sender, EventArgs e) { listView1.Items.Clear(); App_Data.PisDataSetTableAdapters.PatientsTableAdapter myAd = new App_Data.PisDataSetTableAdapters.PatientsTableAdapter(); App_Data.PisDataSet.PatientsDataTable myTbl = new App_Data.PisDataSet.PatientsDataTable(); if (radioByName.Checked) { myAd.FillSearchPatientNameBy(myTbl, txtSearch.Text.Trim()); } else if (radioDoctor.Checked) { myAd.FillSearchByDoctorBy(myTbl, txtSearch.Text); } else if (radioMobile.Checked) { myAd.FillSearchMobileNoBy(myTbl, txtSearch.Text); } else if (radioLand.Checked) { myAd.FillSearchLandLineNoBy(myTbl, txtSearch.Text); } else if (radioAge.Checked) { myAd.FillSearchPatientsAgeBy(myTbl, txtSearch.Text); } else if(radioDate.Checked) { try { myAd.FillDateBy(myTbl, Convert.ToDateTime(Convert.ToDateTime(txtSearch.Text).ToShortDateString())); } catch { MessageBox.Show("Please input valid Date of MM/DD/YYYY Format"); } } Classes.ListViewClass.WriteListView(myTbl, listView1, comboIDs); listView1.Visible = true; }