private void Book_add_Click(object sender, EventArgs e) { if (code.Text.Split(';').Count() == Convert.ToInt32(num.Text)) { string Surname_author = "Surname"; if (author.Text.Split(' ').Count() > 1) { Surname_author = author.Text.Split(' ')[1]; } Form1 main = this.Owner as Form1; Book b = new Book(new List <Person>(), Convert.ToInt32(year.Text), nameb.Text, name_iz.Text, place_pub.Text, code.Text); b.Authors_book.Add(new Person(author.Text.Split(' ')[0], "author", Surname_author)); List <string> buff = new List <string>(); buff.AddRange(code.Text.Split(';')); b.Libray_code = buff[0]; main.L.Codes.AddRange(buff); if (main.L.In_catalog(nameb.Text) && main.L.Search_book_by_name(nameb.Text).BookL[0].Authors_book[0].Surname == Surname_author) { BookInLibrary lib = main.L.Search_book_by_name(nameb.Text); //lib.BookL.Add(lib.); int i = lib.Total_number_copies; int index = i; lib.Total_number_copies += Convert.ToInt32(num.Text); lib.Number_of_available_copies += Convert.ToInt32(num.Text); lib.Add_Books(i); while (i < lib.Total_number_copies) { lib.BookL[i].Libray_code = buff[i - index]; i++; } } else { main.L.Catalog.Add(new BookInLibrary(Convert.ToInt32(num.Text))); main.L.Catalog[main.L.Catalog.Count - 1].BookL.Add(b); main.L.Catalog[main.L.Catalog.Count - 1].Add_Books(1); int i = 1; while (i < Convert.ToInt32(num.Text)) { main.L.Catalog[main.L.Catalog.Count - 1].BookL[i].Libray_code = buff[i]; i++; } } num.Clear(); nameb.Clear(); author.Clear(); name_iz.Clear(); place_pub.Clear(); code.Clear(); year.Clear(); pictureBox1.Visible = true; } else { MessageBox.Show("Количество библиотечных шифров не совпадает с количеством книг!"); } }
public void RemoveBook(object sender, EventArgs e) { Form1 main = this.Owner as Form1; Book b = main.L.Search_book_by_code(textBox1.Text); BookInLibrary bl = main.L.Search_book_by_name(b.Name_book); b.tr = TakesorReturns.Taken; bl.Number_of_available_copies--; bl.Total_number_copies--; main.L.Codes.Remove(b.Libray_code); b.Libray_code = "00"; form.Close(); Close(); }
public void Read_from_exel(Microsoft.Office.Interop.Excel.Worksheet workshhet) { int n, j; int i = 2; List <string> buff_authors = new List <string>(); BookInLibrary b; while (workshhet.Cells[i, 1].Value != null) { if (In_catalog(Convert.ToString(workshhet.Cells[i, 1].Value))) { b = Search_book_by_name(workshhet.Cells[i, 1].Value); b.BookL.Add(new Book()); j = b.BookL.Count - 1; if (workshhet.Cells[i, 7].Text != "Нет") { b.Number_of_available_copies++; b.BookL[j].tr = TakesorReturns.Returned; } else { b.BookL[j].tr = TakesorReturns.Taken; } b.Total_number_copies++; } else { b = new BookInLibrary(); j = 0; b.BookL.Add(new Book()); if (workshhet.Cells[i, 7].Value != "Нет") { b.Number_of_available_copies = 1; b.BookL[j].tr = TakesorReturns.Returned; } else { b.Number_of_available_copies = 0; b.BookL[j].tr = TakesorReturns.Taken; } b.Total_number_copies = 1; catalog.Add(b); } b.BookL[j].Name_book = workshhet.Cells[i, 1].Value; buff_authors.AddRange(workshhet.Cells[i, 2].Value.Split(',')); foreach (string s in buff_authors) { if (s.Split(' ').Count() == 1) { b.BookL[j].Authors_book.Add(new Person(s, "", "Surname")); } else { b.BookL[j].Authors_book.Add(new Person(s.Split(' ')[0], "", s.Split(' ')[1])); } } if (Int32.TryParse(Convert.ToString(workshhet.Cells[i, 3].Value), out n)) { b.BookL[j].Date_publishing = n; } else { b.BookL[j].Date_publishing = 2014; } b.BookL[j].Place_of_publishing = workshhet.Cells[i, 4].Value; b.BookL[j].Name_publisher = workshhet.Cells[i, 5].Value; b.BookL[j].Libray_code = workshhet.Cells[i, 6].Value; codes.Add(b.BookL[j].Libray_code); i++; buff_authors.Clear(); } }
private void button1_Click(object sender, EventArgs e) { button1.Text = "Готово"; search_table.Visible = true; textBox1.Visible = false; textBox2.Visible = false; label1.Visible = false; label2.Visible = false; pictureBox1.Visible = false; Form1 main = this.Owner as Form1; if (flag == Search.book_by_name) { search_table.Rows.Clear(); search_table.Columns.Clear(); search_table.Visible = true; search_table.Columns.Add("book", "Название книги"); search_table.Columns.Add("Authors", "Авторы"); search_table.Columns.Add("pub", "Издательство"); search_table.Columns.Add("year", "Год издания"); search_table.Columns.Add("place", "Место издания"); search_table.Columns.Add("total_num", "В наличии"); search_table.Columns.Add("aviable_num", "Библиотечный шифр"); BookInLibrary buff = main.L.Search_book_by_name(textBox1.Text); int i = 0; foreach (var b in buff.BookL) { if (b.Libray_code != "00") { search_table.Rows.Add(); search_table.Rows[i].Cells[0].Value = b.Name_book; search_table.Rows[i].Cells[1].Value = b.Authors_to_string(); search_table.Rows[i].Cells[2].Value = b.Name_publisher; search_table.Rows[i].Cells[3].Value = b.Date_publishing; search_table.Rows[i].Cells[4].Value = b.Place_of_publishing; if (b.tr == TakesorReturns.Returned) { search_table.Rows[i].Cells[5].Value = "Да"; } else { search_table.Rows[i].Cells[5].Value = "Нет"; } search_table.Rows[i].Cells[6].Value = b.Libray_code; i++; } } } if (flag == Search.book_by_code) { search_table.Rows.Clear(); search_table.Columns.Clear(); search_table.Visible = true; search_table.Columns.Add("book", "Название книги"); search_table.Columns.Add("Authors", "Авторы"); search_table.Columns.Add("pub", "Издательство"); search_table.Columns.Add("year", "Год издания"); search_table.Columns.Add("place", "Место издания"); search_table.Columns.Add("total_num", "В наличии"); search_table.Columns.Add("aviable_num", "Библиотечный шифр"); Book buff = main.L.Search_book_by_code(textBox1.Text); if (buff.Authors_book.Count != 0 && buff.Libray_code != "00") { search_table.Rows.Add(); search_table.Rows[0].Cells[0].Value = buff.Name_book; search_table.Rows[0].Cells[1].Value = buff.Authors_to_string(); search_table.Rows[0].Cells[2].Value = buff.Name_publisher; search_table.Rows[0].Cells[3].Value = buff.Date_publishing; search_table.Rows[0].Cells[4].Value = buff.Place_of_publishing; if (buff.tr == TakesorReturns.Returned) { search_table.Rows[0].Cells[5].Value = "Да"; } else { search_table.Rows[0].Cells[5].Value = "Нет"; } search_table.Rows[0].Cells[6].Value = buff.Libray_code; } } if (flag == Search.reader_by_name) { search_table.Rows.Clear(); search_table.Columns.Clear(); search_table.Visible = true; search_table.Columns.Add("book", "Имя "); search_table.Columns.Add("Authors", "Отчество"); search_table.Columns.Add("Authors", "Фамилия"); search_table.Columns.Add("pub", "Дата полученя чит.билета"); search_table.Columns.Add("year", "Номер чит.билета"); int i = 0; foreach (var r in main.L.Current_info_of_reader(textBox1.Text, textBox2.Text)) { search_table.Rows.Add(); search_table.Rows[i].Cells[0].Value = r.Name_Person; search_table.Rows[i].Cells[1].Value = r.Patronymic_Name; search_table.Rows[i].Cells[2].Value = r.Surname; search_table.Rows[i].Cells[3].Value = r.Date_get; search_table.Rows[i].Cells[4].Value = r.Number_readticket; i++; } } if (flag == Search.reader_by_ticket) { search_table.Rows.Clear(); search_table.Columns.Clear(); search_table.Visible = true; search_table.Columns.Add("book", "Имя "); search_table.Columns.Add("Authors", "Отчество"); search_table.Columns.Add("Authors", "Фамилия"); search_table.Columns.Add("pub", "Дата полученя чит.билета"); search_table.Columns.Add("year", "Номер чит.билета"); try { Reader r = main.L.Search_reader(Convert.ToInt32(textBox1.Text)); search_table.Rows.Add(); int i = 0; search_table.Rows[i].Cells[0].Value = r.Name_Person; search_table.Rows[i].Cells[1].Value = r.Patronymic_Name; search_table.Rows[i].Cells[2].Value = r.Surname; search_table.Rows[i].Cells[3].Value = r.Date_get; search_table.Rows[i].Cells[4].Value = r.Number_readticket; } catch (Exception) { } } button1.Click += Button1_Click; }