private void Form_PublisherRetrieve_Load(object sender, EventArgs e)
{
countryList = db_country.SearchAllCountries(Conn.Connection);
foreach (Country c in countryList)
{
if (c.ShowCountry.Equals("Yes"))
{
box_country.Items.Add(c.CountryName);
}
}
box_country.Items.Add("Show All");
int count = db_publusher.Count(Conn.Connection);
if (count > 1)
{
label_publishersCount.Text = "There are " + count + " publishers registered.";
}
else if (count == 1)
{
label_publishersCount.Text = "There is " + count + " publisher registered.";
}
else
{
label_publishersCount.Text = "There are no registered publisher.";
}
}
public void UpdateCountryBox()
{
CountryList.Clear();
CountryList = DB_Country.SearchAllCountries(Conn.Connection);
Box_Country.DataSource = CountryList;
Box_Country.ValueMember = "Country_Id";
Box_Country.DisplayMember = "CountryName";
}
private void Form_PublisherInsert_Load(object sender, EventArgs e)
{
countryList = db_country.SearchAllCountries(conn.Connection);
foreach (Country c in countryList)
{
if (c.ShowCountry.Equals("Yes"))
{
box_country.Items.Add(c.CountryName);
}
}
box_country.Items.Add("Show All");
}
private void button_retrieveAll_Click(object sender, EventArgs e)
{
table_countries.Rows.Clear();
countryList.Clear();
countryList = db_country.SearchAllCountries(conn.Connection);
foreach (Country c in countryList)
{
table_countries.Rows.Add(c.Country_Id, c.CountryName, c.ShowCountry);
}
if (countryList.Count != 0)
{
button_edit.Enabled = true;
button_delete.Enabled = true;
}
}
private void Form_AuthorRetrieve_Load(object sender, EventArgs e)
{
countryList = db_country.SearchAllCountries(Conn.Connection);
foreach (Country c in countryList)
{
if (c.ShowCountry.Equals("Yes"))
{
box_country.Items.Add(c.CountryName);
}
}
box_country.Items.Add("Show All");
languageList = db_language.SearchAllLanguages(Conn.Connection);
foreach (Language l in languageList)
{
if (l.ShowLanguage.Equals("Yes"))
{
box_language.Items.Add(l.LanguageName);
}
}
box_language.Items.Add("Show All");
int count = db_author.Count(Conn.Connection);
if (count > 1)
{
label_authorCount.Text = "There are " + count + " authors registered.";
}
else if (count == 1)
{
label_authorCount.Text = "There is " + count + " author registered.";
}
else
{
label_authorCount.Text = "There are no registered authors.";
}
}
