private void dothesearch() { if (txtBoxSearchAimodoti.Text != "") { AimodotisAnazitisis = null; this.aimodotesTableAdapter.Fill(ptuxiakiDatabaseDataSet1.Aimodotes); DataRow[] grammes; int count_results; int idAimodoti; bool is_int = int.TryParse(txtBoxSearchAimodoti.Text, out idAimodoti); if (is_int) { grammes = ptuxiakiDatabaseDataSet1.Tables["Aimodotes"].Select("ID = '" + txtBoxSearchAimodoti.Text + "'"); } else { txtBoxSearchAimodoti.Text = txtBoxSearchAimodoti.Text.Replace('*', '%'); grammes = ptuxiakiDatabaseDataSet1.Tables["Aimodotes"].Select("Name LIKE '" + txtBoxSearchAimodoti.Text + "' or LastName LIKE '" + txtBoxSearchAimodoti.Text + "'"); } count_results = grammes.Length; if (count_results > 1) { textboxes_enable(true); stoixeio = txtBoxSearchAimodoti.Text; FormEpilogiAimodoti_Edit AimodotiEpilogi_Show_A = new FormEpilogiAimodoti_Edit(); if (AimodotiEpilogi_Show_A.ShowDialog() == DialogResult.OK) { AimodotisAnazitisis = grammes[0]; txtBoxName.Text = AimodotisAnazitisis[0].ToString(); txtBoxLastName.Text = AimodotisAnazitisis[1].ToString(); txtBoxFatherName.Text = AimodotisAnazitisis[3].ToString(); txtBoxOmadaAimatos.Text = AimodotisAnazitisis[4].ToString(); txtBoxRhesus.Text = AimodotisAnazitisis[5].ToString(); txtBoxBirthYear.Text = AimodotisAnazitisis[6].ToString(); txtBoxJob.Text = AimodotisAnazitisis[7].ToString(); txtBoxAddress.Text = AimodotisAnazitisis[8].ToString(); txtBoxPhone1.Text = AimodotisAnazitisis[9].ToString(); txtBoxPhone2.Text = AimodotisAnazitisis[10].ToString(); } } if (count_results == 1) { textboxes_enable(true); AimodotisAnazitisis = grammes[0]; txtBoxName.Text = AimodotisAnazitisis[0].ToString(); txtBoxLastName.Text = AimodotisAnazitisis[1].ToString(); txtBoxFatherName.Text = AimodotisAnazitisis[3].ToString(); txtBoxOmadaAimatos.Text = AimodotisAnazitisis[4].ToString(); txtBoxRhesus.Text = AimodotisAnazitisis[5].ToString(); txtBoxBirthYear.Text = AimodotisAnazitisis[6].ToString(); txtBoxJob.Text = AimodotisAnazitisis[7].ToString(); txtBoxAddress.Text = AimodotisAnazitisis[8].ToString(); txtBoxPhone1.Text = AimodotisAnazitisis[9].ToString(); txtBoxPhone2.Text = AimodotisAnazitisis[10].ToString(); } if (count_results == 0) { MessageBox.Show("Δεν βρέθηκε η εγγραφή!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtBoxSearchAimodoti.Focus(); txtBoxSearchAimodoti.SelectAll(); } } }
private void SearchAimodoti() { if (TextBoxSearchAimodoti.Text != "") { AimodotisAnazitisis = null; this.aimodotesTableAdapter1.Fill(ptuxiakiDatabaseDataSet11.Aimodotes); DataRow[] grammes; int count_results = 0; int idAimodoti; bool idgiven = int.TryParse(TextBoxSearchAimodoti.Text, out idAimodoti); if (idgiven) { grammes = ptuxiakiDatabaseDataSet11.Tables["Aimodotes"].Select("ID='" + TextBoxSearchAimodoti.Text + "'"); count_results = grammes.Length; if (count_results != 0) { AimodotisAnazitisis = grammes[0]; } else { MessageBox.Show("Δεν βρέθηκε ο Αιμοδότης!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { TextBoxSearchAimodoti.Text = TextBoxSearchAimodoti.Text.Replace('*', '%'); grammes = ptuxiakiDatabaseDataSet11.Tables["Aimodotes"].Select("Name LIKE '" + TextBoxSearchAimodoti.Text + "' or LastName LIKE '" + TextBoxSearchAimodoti.Text + "'"); count_results = grammes.Length; if (count_results > 1) { stoixeio = TextBoxSearchAimodoti.Text; FormEpilogiAimodoti_Edit epilogiaimodoti = new FormEpilogiAimodoti_Edit(); epilogiaimodoti.stoixeio = stoixeio; if (epilogiaimodoti.ShowDialog() == DialogResult.OK) { AimodotisAnazitisis = epilogiaimodoti.AimodotisAnazitishs; } } if (count_results == 1) { AimodotisAnazitisis = grammes[0]; } if (count_results == 0) { MessageBox.Show("Δεν βρέθηκε ο Αιμοδότης!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } }
private void dothesearch() { if (TextBoxSearchAimodoti.Text != "") { int count_results = 0; DataRow[] grammes; this.aimodotesTableAdapter1.Fill(ptuxiakiDatabaseDataSet11.Aimodotes); int idAimodoti; bool is_int = int.TryParse(TextBoxSearchAimodoti.Text, out idAimodoti); if (is_int) { grammes = ptuxiakiDatabaseDataSet11.Tables["Aimodotes"].Select("ID = '" + TextBoxSearchAimodoti.Text + "'"); } else { TextBoxSearchAimodoti.Text = TextBoxSearchAimodoti.Text.Replace('*', '%'); grammes = ptuxiakiDatabaseDataSet11.Tables["Aimodotes"].Select("LastName LIKE '" + TextBoxSearchAimodoti.Text + "' or Name LIKE '" + TextBoxSearchAimodoti.Text + "'"); } count_results = grammes.Length; if (count_results > 1) { stoixeio = TextBoxSearchAimodoti.Text; FormEpilogiAimodoti_Edit epilogiAimodoti=new FormEpilogiAimodoti_Edit(); epilogiAimodoti.stoixeio = stoixeio; if (epilogiAimodoti.ShowDialog() == DialogResult.OK) { AimodotisAnazitisis = epilogiAimodoti.AimodotisAnazitishs; FormFindAimodotiFromMain AimodotiEpilogi_Show_A = new FormFindAimodotiFromMain(); AimodotiEpilogi_Show_A.AimodotisAnazitisis = AimodotisAnazitisis; AimodotiEpilogi_Show_A.Show(); } } if (count_results == 1) { MessageBox.Show("Ο Αιμοδότης βρέθηκε", "Found !", MessageBoxButtons.OK, MessageBoxIcon.Information); FormFindAimodotiFromMain findaimodotis = new FormFindAimodotiFromMain(); findaimodotis.AimodotisAnazitisis=grammes[0]; findaimodotis.Show(); } if (count_results == 0) { MessageBox.Show("Δεν βρέθηκε ο Αιμοδότης!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } }