// Delete Patient Profile
private void Delete_patient_button_Click(object sender, EventArgs e)
{
string message = "Are you sure you want to delete this patient?";
string caption = "Warning";
MessageBoxButtons buttons = MessageBoxButtons.YesNoCancel;
MessageBoxIcon Icon = MessageBoxIcon.Warning;
DialogResult result;
// Displays the MessageBox.
result = MessageBox.Show(message, caption, buttons, Icon);
if (result == DialogResult.Yes)
{
RetrievedContext.Database.ExecuteSqlCommand("DELETE FROM Diagnosis WHERE Patient_ID = {0}", Patient_ID);
RetrievedContext.Database.ExecuteSqlCommand("DELETE FROM Dates WHERE Patient_ID = {0}", Patient_ID);
RetrievedContext.Database.ExecuteSqlCommand("DELETE FROM [X-ray_images] WHERE Patient_ID = {0}", Patient_ID);
RetrievedContext.Database.ExecuteSqlCommand("DELETE FROM Patient_info WHERE Patient_ID = {0}", Patient_ID);
RetrievedContext.SaveChanges();
if (!RetrievedContext.Patient_info.Any(i => i.Patient_ID == Patient_ID))
{
MessageBox.Show("The patient was deleted");
ValidateData.ReorderXray_table();
ValidateData.ReorderDiagnosis_table();
ValidateData.ReorderDates_table();
}
else
{
MessageBox.Show("Failed to delete the patient");
}
this.Close();
}
}
// Delete Set of patients
private void Delete_patients_button_Click(object sender, EventArgs e)
{
String From, To;
int FromID, ToID;
From = Delete_from_textBox.Text;
To = Delete_to_textBox.Text;
if (!ValidateData.ValidateIDField(From))
{
Error.SetError(Delete_from_textBox, "sdgd");
return;
}
Error.Clear();
if (!ValidateData.ValidateIDField(To))
{
Error.SetError(Delete_to_textBox, "sdgd");
return;
}
Error.Clear();
FromID = Int32.Parse(From);
ToID = Int32.Parse(To);
//------------------------------------
string message = "Are you sure you want to delete these patients?";
string caption = "Warning";
MessageBoxButtons buttons = MessageBoxButtons.YesNoCancel;
MessageBoxIcon Icon = MessageBoxIcon.Warning;
DialogResult result;
// Displays the MessageBox.
result = MessageBox.Show(message, caption, buttons, Icon);
if (result == DialogResult.Yes)
{
Delete.Database.ExecuteSqlCommand("DELETE FROM Diagnosis WHERE Patient_ID BETWEEN {0} AND {1} ", FromID, ToID);
Delete.Database.ExecuteSqlCommand("DELETE FROM Dates WHERE Patient_ID BETWEEN {0} AND {1} ", FromID, ToID);
Delete.Database.ExecuteSqlCommand("DELETE FROM [X-ray_images] WHERE Patient_ID BETWEEN {0} AND {1} ", FromID, ToID);
int Number_of_rows_Affected = Delete.Database.ExecuteSqlCommand("DELETE FROM Patient_info WHERE Patient_ID BETWEEN {0} AND {1} ", FromID, ToID);
Delete.SaveChanges();
MessageBox.Show(Number_of_rows_Affected + " Patients was deleted.\n Please check your DB browser");
if (Number_of_rows_Affected != 0)
{
ValidateData.ReorderXray_table();
ValidateData.ReorderDiagnosis_table();
ValidateData.ReorderDates_table();
}
Delete_from_textBox.Text = "";
Delete_to_textBox.Text = "";
}
}
// Main Function
private void AddnewPatient_saveAndConfirm_button_Click(object sender, EventArgs e)
{
int ID = 0, Age;
String Name, Home_no = "", Mobile_no, Address, Cheif_comp, Medical_Alr, Comments, Sex, RelativeMarriage;
DateTime VisitDate, BirthDate;
byte[] PatientPhoto;
var newPatient = new Patient_info();
// Re-validate
if (!DataValidation())
{
return;
}
try
{
ID = Int32.Parse(Patient_ID_textBox.Text);
Age = Int32.Parse(Age_textBox.Text);
Name = Patient_name_textBox.Text;
Home_no = Homenum_textBox.Text;
Mobile_no = Mobile_textBox.Text;
Address = Address_textBox.Text;
Cheif_comp = Chief_Complaint_textBox.Text;
Medical_Alr = Medical_alert_textBox.Text;
VisitDate = Convert.ToDateTime(Visit_date_textBox.Text);
BirthDate = Convert.ToDateTime(DateOfBirth_textBox.Text);
PatientPhoto = imageToByteArray(Patient_Picture);
Comments = Comments_textbox.Text;
Sex = Sex_Combobox.Text;
RelativeMarriage = Realative_Marriage_comboBox.Text;
// Main Panel
///////////////////////////////
newPatient.Patient_ID = ID;
newPatient.Patient_name = Name;
newPatient.Visit_date = VisitDate;
newPatient.Age = Age;
newPatient.Home_number = Home_no;
newPatient.Phone_number = Mobile_no;
newPatient.Birth_date = BirthDate;
newPatient.Patient_image = PatientPhoto;
newPatient.Sex = Sex;
newPatient.Relative_marriage = RelativeMarriage;
newPatient.Address = Address;
newPatient.Cheif_complaint = Cheif_comp;
newPatient.Medical_alert = Medical_Alr;
newPatient.D_DMF = D;
newPatient.M_DMF = M;
newPatient.F_DMF = F;
newPatient.DMF = DMF;
newPatient.dd_dmf = d;
newPatient.mm_dmf = m;
newPatient.ff_dmf = f;
newPatient.C_dmf = _dmf;
newPatient.D_DEF = _D;
newPatient.E_DEF = E;
newPatient.F_DEF = _F;
newPatient.DEF = DEF;
if (Comments.Length != 0)
{
newPatient.Comments = Comments;
}
///////////////////////////////////////////
// Diagnosis and Treatment Plans panel
//////////////////////////////////////////
var Dcount = (from o in DataEntiry.Diagnoses select o).Count();
int Dtemp = Dcount + 1;
foreach (List <String> row in DiagnosisAndTPs_table)
{
var DiagnosisObject = new Diagnosis();
DiagnosisObject.Diagnose_ID = Dtemp;
DiagnosisObject.Diagnose = row[0];
DiagnosisObject.Treatment_Plan = row[1];
newPatient.Diagnoses.Add(DiagnosisObject);
Dtemp++;
}
/////////////////////////////////////////
// Patinet's X-ray images
////////////////////////////////////////
// Byte[] XrayImage;
MemoryStream ms;
int index = 0;
var Xcount = (from o in DataEntiry.X_ray_images select o).Count();
int Xtemp = Xcount + 1;
foreach (Bitmap img in Patient_Xray_images)
{
var XrayimageObject = new X_ray_images();
ms = new MemoryStream();
img.Save(ms, img.RawFormat);
XrayimageObject.Xray_image = ms.ToArray();
XrayimageObject.Image_name = XrayImagesNames[index];
XrayimageObject.Xray_images_ID = Xtemp;
newPatient.X_ray_images.Add(XrayimageObject);
index++;
Xtemp++;
}
/////////////////////////////////////////
// Dates And Procedures Panel
////////////////////////////////////////
var DAcount = (from o in DataEntiry.Dates select o).Count();
int DAtemp = DAcount + 1;
foreach (List <String> row in DatesAndProc_table)
{
var DatesObject = new Date();
DatesObject.Dates_ID = DAtemp;
DatesObject.Date1 = Convert.ToDateTime(row[0]);
DatesObject.Doctor_name = row[1];
DatesObject.Procedures = row[2];
DatesObject.Procedure_Comment = row[3];
if (row[4].Length != 0)
{
DatesObject.Medication = row[4];
}
DatesObject.Supervisor_signature = row[5];
newPatient.Dates.Add(DatesObject);
DAtemp++;
}
}
catch (Exception)
{
MessageBox.Show("Please press Check Data Button before Saving");
return;
}
DataEntiry.Patient_info.Add(newPatient);
try
{
DataEntiry.SaveChanges();
}
catch (Exception ex)
{
Exception exeption = ex;
MessageBox.Show("Something wrong with saving the changes in the DBcontext");
return;
}
// Check if exist
string SqlCommand = "SELECT * FROM Patient_info WHERE Patient_ID = " + ID.ToString() + " AND Home_number = " + Home_no.ToString() + " ";
BSS.DataSource = Con.GetData(SqlCommand);
Check = (DataTable)BSS.DataSource;
if (Check.Rows.Count != 0)
{
MessageBox.Show("The patient was added successfully");
NewPatientWasAdded = true;
Add_new_Patient Reset = new Add_new_Patient();
this.Close();
this.Dispose();
Reset.Show();
}
else
{
MessageBox.Show("Failed to add the patient file");
}
}
