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 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);
}
}
