private void Images_Load(object sender, EventArgs e)
{
try
{
App_Data.PisDataSet.ImagesDataTable myTbl = new App_Data.PisDataSet.ImagesDataTable();
App_Data.PisDataSetTableAdapters.ImagesTableAdapter myAd = new App_Data.PisDataSetTableAdapters.ImagesTableAdapter();
myAd.FillImagesbyPatientBy(myTbl, Classes.publicClass.PatientID);
// MessageBox.Show(myTbl.Rows.Count.ToString());
string[] MyStrImageLocation = new string[myTbl.Rows.Count];
string[] MyStrImageID = new string[myTbl.Rows.Count];
foreach (DataRow dr in myTbl.Rows)
{
MyStrImageID[index] = dr["ImageID"].ToString();
MyStrImageLocation[index] = dr["ImageLocation"].ToString();
index++;
//MessageBox.Show(dr["ImageID"].ToString());
//MessageBox.Show(dr["ImageLocation"].ToString());
}
myStrImageID = MyStrImageID;
myStrImageLocation = MyStrImageLocation;
index = 0;
pictureBox1.ImageLocation = myStrImageLocation[index];
btnPrevious.Enabled = false;
if (myStrImageID.Length == 1)
btnNext.Enabled = false;
}
catch (Exception Exc)
{
MessageBox.Show(Exc.Message + "\nPossibly No Images to Load ADD Images Please");
this.Close();
}
}
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 button1_Click_1(object sender, EventArgs e)
{
if (cmbImageIndex.SelectedIndex != -1)
{
App_Data.PisDataSetTableAdapters.ImagesTableAdapter myAd = new App_Data.PisDataSetTableAdapters.ImagesTableAdapter();
myAd.DeleteImageByImageIDQuery(Convert.ToInt32(cmbImageID.Items[cmbImageIndex.SelectedIndex]));
App_Data.PisDataSet.ImagesDataTable myTbl = new App_Data.PisDataSet.ImagesDataTable();
myAd.FillImagesbyPatientBy(myTbl, Classes.publicClass.PatientID);
cmbImageID.Items.Clear();
cmbImageIndex.Items.Clear();
for (int index = 0; index < myTbl.Rows.Count; index++)
{
cmbImageIndex.Items.Add((index + 1).ToString());
cmbImageID.Items.Add(myTbl.Rows[index]["ImageID"].ToString());
}
txtImageLocation.Text = "";
cmbImageIndex.SelectedIndex = -1;
cmbImageIndex.Text = "";
MessageBox.Show("Image Deleted");
}
else
{
MessageBox.Show("Select An Image Index to delete it");
}
}
void FillFormData()
{
App_Data.PisDataSet.ImagesDataTable myImageTbl = new App_Data.PisDataSet.ImagesDataTable();
App_Data.PisDataSetTableAdapters.ImagesTableAdapter myAd = new App_Data.PisDataSetTableAdapters.ImagesTableAdapter();
myAd.FillImagesbyPatientBy(myImageTbl, Classes.publicClass.PatientID);
txtAge.Text = Classes.publicClass.age.ToString();
txtLandLine.Text = Classes.publicClass.LandLineNo;
txtMobileNo.Text = Classes.publicClass.MobileNo;
txtpatientName.Text = Classes.publicClass.PatientName;
txtAddress.Text = Classes.publicClass.Address;
txtDoctorName.Text = Classes.publicClass.DoctorName;
txtAge.Text = Classes.publicClass.age.ToString();
txtFindings.Text = Classes.publicClass.ClinicalFinding;
txtComplaint.Text = Classes.publicClass.Complaint;
txtDate.Text = Convert.ToDateTime(Classes.publicClass.DOV).ToShortDateString();
for (int index = 0; index < myImageTbl.Rows.Count; index++)
{
cmbImageIndex.Items.Add((index + 1).ToString());
cmbImageID.Items.Add(myImageTbl.Rows[index]["ImageID"].ToString());
}
}
private void cmbImageIndex_SelectedIndexChanged(object sender, EventArgs e)
{
//App_Data.PisDataSet.ImagesDataTable myImgTbl = new App_Data.PisDataSet.ImagesDataTable();
App_Data.PisDataSet.ImagesDataTable myImgTbl = new App_Data.PisDataSet.ImagesDataTable();
App_Data.PisDataSetTableAdapters.ImagesTableAdapter myImgAd = new App_Data.PisDataSetTableAdapters.ImagesTableAdapter();
myImgAd.FillImageByIDBy(myImgTbl, Convert.ToInt32(cmbImageID.Items[cmbImageIndex.SelectedIndex]));
//MessageBox.Show(/*myImgTbl.Rows[0]["ImageLocation"].ToString() + " " + */cmbImageID.Items[cmbImageIndex.SelectedIndex].ToString() + myImgTbl.Rows.Count.ToString());
txtImageLocation.Text = myImgTbl.Rows[0]["ImageLocation"].ToString();
}
private void button1_Click_2(object sender, EventArgs e)
{
try
{
if (txtImageLocation.Text == "")
{
MessageBox.Show("Image Location Can't Be Null");
return;
}
else if (txtImageLocation.Text != "")
{
App_Data.PisDataSetTableAdapters.ImagesTableAdapter myAd = new App_Data.PisDataSetTableAdapters.ImagesTableAdapter();
App_Data.PisDataSet.ImagesDataTable myTbl = new App_Data.PisDataSet.ImagesDataTable();
myAd.InsertImageQuery(txtImageLocation.Text, publicClass.PatientID);
myAd.FillImagesbyPatientBy(myTbl, Classes.publicClass.PatientID);
cmbImageID.Items.Clear();
cmbImageIndex.Items.Clear();
for (int index = 0; index < myTbl.Rows.Count; index++)
{
cmbImageIndex.Items.Add((index + 1).ToString());
cmbImageID.Items.Add(myTbl.Rows[index]["ImageID"].ToString());
}
txtImageLocation.Text = "";
cmbImageIndex.SelectedIndex = -1;
cmbImageIndex.Text = "";
MessageBox.Show("New Image Loaded!");
}
}
catch (Exception exc)
{
MessageBox.Show(exc.Message);
}
}
