private void dothesearch()
{
if (txtBoxSearchSyllogo.Text != "")
{
SullogosAnazitisis = null;
this.syllogoiTableAdapter.Fill(ptuxiakiDatabaseDataSet1.Syllogoi);
DataRow[] grammes;
int count_results;
int idSullogou;
bool is_int = int.TryParse(txtBoxSearchSyllogo.Text, out idSullogou);
if (is_int)
{
grammes = ptuxiakiDatabaseDataSet1.Tables["Syllogoi"].Select("ID_Syllogou ='" + txtBoxSearchSyllogo.Text + "'");
}
else
{
txtBoxSearchSyllogo.Text = txtBoxSearchSyllogo.Text.Replace('*', '%');
grammes = ptuxiakiDatabaseDataSet1.Tables["Syllogoi"].Select("Onoma_Syllogou LIKE '" + txtBoxSearchSyllogo.Text + "' or Eponumo_Proedrou LIKE '" + txtBoxSearchSyllogo.Text + "'");
}
count_results = grammes.Length;
if (count_results > 1)
{
stoixeio = txtBoxSearchSyllogo.Text;
FormEpilogiSyllogou SyllogosEpilogi_Show_A = new FormEpilogiSyllogou();
SyllogosEpilogi_Show_A.stoixeio = stoixeio;
if (SyllogosEpilogi_Show_A.ShowDialog() == DialogResult.OK)
{
SullogosAnazitisis = SyllogosEpilogi_Show_A.SullogosAnazitisis;
iD_SyllogouLabel1.Text = SullogosAnazitisis[0].ToString();
onoma_SyllogouLabel1.Text = SullogosAnazitisis[1].ToString();
onoma_ProedrouLabel1.Text = SullogosAnazitisis[2].ToString();
eponumo_ProedrouLabel1.Text = SullogosAnazitisis[3].ToString();
num_FialesLabel1.Text = SullogosAnazitisis[4].ToString();
date_IdrisisLabel1.Text = SullogosAnazitisis[5].ToString();
}
}
if (count_results == 1)
{
SullogosAnazitisis = grammes[0];
iD_SyllogouLabel1.Text = SullogosAnazitisis[0].ToString();
onoma_SyllogouLabel1.Text = SullogosAnazitisis[1].ToString();
onoma_ProedrouLabel1.Text = SullogosAnazitisis[2].ToString();
eponumo_ProedrouLabel1.Text = SullogosAnazitisis[3].ToString();
num_FialesLabel1.Text = SullogosAnazitisis[4].ToString();
date_IdrisisLabel1.Text = SullogosAnazitisis[5].ToString();
}
if (count_results == 0)
{
MessageBox.Show("Δεν βρέθηκε η εγγραφή!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtBoxSearchSyllogo.Focus();
txtBoxSearchSyllogo.SelectAll();
}
}
}
private void SearchSyllogo()
{
if (textBoxSearchSyllogo.Text != "")
{
SyllogosAnazitisis = null;
this.syllogoiTableAdapter1.Fill(ptuxiakiDatabaseDataSet11.Syllogoi);
DataRow[] grammes;
int count_results = 0;
int idSyllogou;
bool idgiven = int.TryParse(textBoxSearchSyllogo.Text, out idSyllogou);
if (idgiven)
{
grammes = ptuxiakiDatabaseDataSet11.Tables["Syllogoi"].Select("ID_Syllogou='" + textBoxSearchSyllogo.Text + "'");
count_results = grammes.Length;
if (count_results != 0)
{
SyllogosAnazitisis = grammes[0];
}
else
{
MessageBox.Show("Δεν βρέθηκε ο Σύλλογος!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
textBoxSearchSyllogo.Text = textBoxSearchSyllogo.Text.Replace('*', '%');
grammes = ptuxiakiDatabaseDataSet11.Tables["Syllogoi"].Select("Onoma_Syllogou LIKE '" + textBoxSearchSyllogo.Text + "' or Eponumo_Proedrou LIKE '" + textBoxSearchSyllogo.Text + "'");
count_results = grammes.Length;
if (count_results > 1)
{
stoixeio = textBoxSearchSyllogo.Text;
FormEpilogiSyllogou epilogisyllogou = new FormEpilogiSyllogou();
epilogisyllogou.stoixeio = stoixeio;
if (epilogisyllogou.ShowDialog() == DialogResult.OK)
{
SyllogosAnazitisis = epilogisyllogou.SullogosAnazitisis;
}
}
if (count_results == 1)
{
SyllogosAnazitisis = grammes[0];
}
if (count_results == 0)
{
MessageBox.Show("Δεν βρέθηκε ο Συλλόγος!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
}
private void dothesearchSyllogou()
{
if (textBoxSearchSyllogo.Text != "")
{
int results = 0;
DataRow[] grammesSyllogou;
this.syllogoiTableAdapter1.Fill(ptuxiakiDatabaseDataSet11.Syllogoi);
int idSyllogou;
bool is_int = int.TryParse(textBoxSearchSyllogo.Text, out idSyllogou);
if (is_int)
{
grammesSyllogou = ptuxiakiDatabaseDataSet11.Tables["Syllogoi"].Select("ID_Syllogou= '" + textBoxSearchSyllogo.Text + "'");
}
else
{
textBoxSearchSyllogo.Text = textBoxSearchSyllogo.Text.Replace('*', '%');
grammesSyllogou = ptuxiakiDatabaseDataSet11.Tables["Syllogoi"].Select("Onoma_Syllogou LIKE '" + textBoxSearchSyllogo.Text + "'or Eponumo_Proedrou LIKE '" + textBoxSearchSyllogo.Text + "'");
}
results = grammesSyllogou.Length;
if (results > 1)
{
stoixeioSyllogou = textBoxSearchSyllogo.Text;
FormEpilogiSyllogou SyllogosEpilogi = new FormEpilogiSyllogou();
SyllogosEpilogi.stoixeio = stoixeioSyllogou;
if (SyllogosEpilogi.ShowDialog() == DialogResult.OK)
{
SullogosAnazitisis = SyllogosEpilogi.SullogosAnazitisis;
FormFindSyllogoFromMain SullogosEpilogi_Show_A = new FormFindSyllogoFromMain();
SullogosEpilogi_Show_A.SullogosAnazitisis = SullogosAnazitisis;
SullogosEpilogi_Show_A.Show();
}
}
if (results == 1)
{
MessageBox.Show("Ο Σύλλογος βρέθηκε", "Found !", MessageBoxButtons.OK, MessageBoxIcon.Information);
FormFindSyllogoFromMain findSullogos = new FormFindSyllogoFromMain();
findSullogos.SullogosAnazitisis = grammesSyllogou[0];
findSullogos.Show();
}
if (results == 0)
{
MessageBox.Show("Δεν βρέθηκε ο Σύλλογος!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}