private void button3_Click_1(object sender, EventArgs e)
{
listDataType = 2;
if (WritersManager.Writers.Count() != 0)
{
listBox1.DataSource = null;
listBox1.Items.Clear();
writersList.Clear();
for (int i = 0; i < WritersManager.Writers.Count(); i++)
{
writersList.Add(new Writer(WritersManager.Writers[i], WritersManager.Writers[i].FirstName, WritersManager.Writers[i].LastName));
//listBox1.Items.Add(string.Format("{0} {1}", WritersManager.Writers[i].FirstName, WritersManager.Writers[i].LastName));
}
listBox1.DataSource = writersList;
listBox1.DisplayMember = "FirstLastName";
listBox1.ValueMember = "WriterFromList";
}
else
{
if (DataBase.GetStateConnection())
{
listBox1.DataSource = null;
listBox1.Items.Clear();
writersList.Clear();
string query = "select * from Writers";
//SqlConnection connection = DataBase.GetSqlConnection();
SqlCommand command = new SqlCommand(query, DataBase.Sql);
SqlDataReader reader = command.ExecuteReader();
//WritersManager writersMng = new WritersManager();
WritersManager.LoadWriter(reader);
for (int i = 0; i < WritersManager.Writers.Count(); i++)
{
writersList.Add(new Writer(WritersManager.Writers[i], WritersManager.Writers[i].FirstName, WritersManager.Writers[i].LastName));
//listBox1.Items.Add(string.Format("{0} {1}", WritersManager.Writers[i].FirstName, WritersManager.Writers[i].LastName));
}
listBox1.DataSource = writersList;
listBox1.DisplayMember = "FirstLastName";
listBox1.ValueMember = "WriterFromList";
reader.Close();
}
}
}
private void button1_Click(object sender, EventArgs e)
{
listBox1.Items.Clear();
List <int> checkListWriters = new List <int>();
List <int> checkListpublishers = new List <int>();
switch (choice)
{
case 1:
if (BooksManager.SearchConnect())
{
((Form1)(this.Owner)).Label1.BackColor = Color.Green;
foreach (Books book in BooksManager.Books)
{
if (book.Title == textBox1.Text)
{
listBox1.Items.Add(string.Format("{0} {1} {2} {3} {4}", book.BookID.ToString(), book.Title, WritersManager.GetWriter(book.WriterID).FirstName.ToString(), WritersManager.GetWriter(book.WriterID).LastName.ToString(), PublichersManager.GetPublicher(book.PublicherID).Title.ToString()));
}
}
}
break;
case 2:
if (BooksManager.SearchConnect())
{
((Form1)(this.Owner)).Label1.BackColor = Color.Green;
foreach (Writers writer in WritersManager.Writers)
{
if (writer.FirstName == textBox2.Text || writer.LastName == textBox2.Text)
{
checkListWriters.Add(writer.WriterID);
}
}
foreach (Books book in BooksManager.Books)
{
if (checkListWriters.Contains(book.WriterID))
{
listBox1.Items.Add(string.Format("{0} {1} {2} {3} {4}", book.BookID.ToString(), book.Title, WritersManager.GetWriter(book.WriterID).FirstName.ToString(), WritersManager.GetWriter(book.WriterID).LastName.ToString(), PublichersManager.GetPublicher(book.PublicherID).Title.ToString()));
}
}
}
break;
case 3:
if (BooksManager.SearchConnect())
{
foreach (Writers writer in WritersManager.Writers)
{
if (writer.FirstName == textBox2.Text || writer.LastName == textBox2.Text)
{
checkListWriters.Add(writer.WriterID);
}
}
foreach (Books book in BooksManager.Books)
{
if (book.Title == textBox1.Text && checkListWriters.Contains(book.WriterID))
{
listBox1.Items.Add(string.Format("{0} {1} {2} {3} {4}", book.BookID.ToString(), book.Title, WritersManager.GetWriter(book.WriterID).FirstName.ToString(), WritersManager.GetWriter(book.WriterID).LastName.ToString(), PublichersManager.GetPublicher(book.PublicherID).Title.ToString()));
}
}
}
break;
case 4:
if (BooksManager.SearchConnect())
{
foreach (Publichers publicher in PublichersManager.Publichers)
{
if (publicher.Title == textBox3.Text)
{
checkListpublishers.Add(publicher.PublicherID);
}
}
foreach (Books book in BooksManager.Books)
{
if (checkListpublishers.Contains(book.PublicherID))
{
listBox1.Items.Add(string.Format("{0} {1} {2} {3} {4}", book.BookID.ToString(), book.Title, WritersManager.GetWriter(book.WriterID).FirstName.ToString(), WritersManager.GetWriter(book.WriterID).LastName.ToString(), PublichersManager.GetPublicher(book.PublicherID).Title.ToString()));
}
}
}
break;
case 5:
if (BooksManager.SearchConnect())
{
//MessageBox.Show("5");
foreach (Publichers publicher in PublichersManager.Publichers)
{
if (publicher.Title == textBox3.Text)
{
checkListpublishers.Add(publicher.PublicherID);
}
}
foreach (Books book in BooksManager.Books)
{
if (book.Title == textBox1.Text && checkListpublishers.Contains(book.PublicherID))
{
listBox1.Items.Add(string.Format("{0} {1} {2} {3} {4}", book.BookID.ToString(), book.Title, WritersManager.GetWriter(book.WriterID).FirstName.ToString(), WritersManager.GetWriter(book.WriterID).LastName.ToString(), PublichersManager.GetPublicher(book.PublicherID).Title.ToString()));
}
}
}
break;
case 6:
if (BooksManager.SearchConnect())
{
foreach (Writers writer in WritersManager.Writers)
{
if (writer.FirstName == textBox2.Text || writer.LastName == textBox2.Text)
{
checkListWriters.Add(writer.WriterID);
}
}
foreach (Publichers publicher in PublichersManager.Publichers)
{
if (publicher.Title == textBox3.Text)
{
checkListpublishers.Add(publicher.PublicherID);
}
}
foreach (Books book in BooksManager.Books)
{
if (checkListpublishers.Contains(book.PublicherID) && checkListWriters.Contains(book.WriterID))
{
listBox1.Items.Add(string.Format("{0} {1} {2} {3} {4}", book.BookID.ToString(), book.Title, WritersManager.GetWriter(book.WriterID).FirstName.ToString(), WritersManager.GetWriter(book.WriterID).LastName.ToString(), PublichersManager.GetPublicher(book.PublicherID).Title.ToString()));
}
}
}
break;
case 7:
if (BooksManager.SearchConnect())
{
foreach (Writers writer in WritersManager.Writers)
{
if (writer.FirstName == textBox2.Text || writer.LastName == textBox2.Text)
{
checkListWriters.Add(writer.WriterID);
}
}
foreach (Publichers publicher in PublichersManager.Publichers)
{
if (publicher.Title == textBox3.Text)
{
checkListpublishers.Add(publicher.PublicherID);
}
}
foreach (Books book in BooksManager.Books)
{
if (book.Title == textBox1.Text && checkListpublishers.Contains(book.PublicherID) && checkListWriters.Contains(book.WriterID))
{
listBox1.Items.Add(string.Format("{0} {1} {2} {3} {4}", book.BookID.ToString(), book.Title, WritersManager.GetWriter(book.WriterID).FirstName.ToString(), WritersManager.GetWriter(book.WriterID).LastName.ToString(), PublichersManager.GetPublicher(book.PublicherID).Title.ToString()));
}
}
}
break;
default:
break;
}
}
