using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Collections;
namespace BookManagementSystem
{
    public partial class frmBookView : Form
    {
        private string BookOfClass,bno,bname,CountOfBookNow;
        private DataSet thisDataSet;
        private DataTable thisTable;
        private string[] sdata = new string[7];
        private int RowCount;
        private ArrayList pBigClassOfBook;
        public frmBookView(string BookOfClass, ArrayList pBigClassOfBook)
        {
            InitializeComponent();
            this.BookOfClass = BookOfClass;
            this.pBigClassOfBook = pBigClassOfBook;
            GetUpToData();
            Dispaly();
        }
        private void frmBookView_Load(object sender, EventArgs e)
        {
            pictureBox.SizeMode = PictureBoxSizeMode.StretchImage;
            foreach (string sdata in pBigClassOfBook)
            {
                cmboxBigClassOfBook.Items.Add(sdata);
            }

        }
        private void GetUpToData()
        {
            this.thisDataSet = Program.DataOperator.GetAllBookData();
            this.thisTable = this.thisDataSet.Tables["Book"];
            this.Text = BookOfClass;
            DataColumn[] keys = new DataColumn[1];
            keys[0] = thisTable.Columns["書籍編號"];
            this.thisTable.PrimaryKey = keys;
        }
        private void AddRow(int i)
        {
            sdata[0] = thisTable.Rows[i]["書籍編號"].ToString();
            sdata[1] = thisTable.Rows[i]["書名"].ToString();
            sdata[2] = thisTable.Rows[i]["作者"].ToString();
            sdata[3] = thisTable.Rows[i]["出版社"].ToString(); ;
            sdata[4] = thisTable.Rows[i]["現有數量"].ToString();
            sdata[5] = thisTable.Rows[i]["小類"].ToString();
            sdata[6] = thisTable.Rows[i]["大類"].ToString();
            dataGridView.Rows.Add(sdata);
        }
        private void Dispaly()
        {
            RowCount = this.thisTable.Rows.Count;
            dataGridView.Rows.Clear();
            for (int i = 0; i < RowCount; i++)
            {
                if (BookOfClass != "所有書籍")
                    if (!BookOfClass.Contains(thisTable.Rows[i]["大類"].ToString())
                        && !thisTable.Rows[i]["大類"].ToString().Contains(BookOfClass))
                        continue;
                AddRow(i);
            }

        }
        private void SerchBtn_Click(object sender, EventArgs e)
        {
            RowCount = this.thisTable.Rows.Count;
            dataGridView.Rows.Clear();
            for (int i = 0; i < RowCount; i++)
                if (txtBoxNo.Text.Equals("") || thisTable.Rows[i]["書籍編號"].ToString().Contains(txtBoxNo.Text))
                    if (txtBoxName.Text.Equals("") || thisTable.Rows[i]["書名"].ToString().Contains(txtBoxName.Text))
                        if (txtBoxAuthor.Text.Equals("") || thisTable.Rows[i]["作者"].ToString().Contains(txtBoxAuthor.Text))
                            if (txtBoxpublishing_company.Text.Equals("") || thisTable.Rows[i]["出版社"].ToString().Contains(txtBoxpublishing_company.Text))
                                if (cmboxSmallClassOfBook.Text.Equals("") || thisTable.Rows[i]["小類"].ToString().Contains(cmboxSmallClassOfBook.Text))
                                    if (cmboxBigClassOfBook.Text.Equals("") || thisTable.Rows[i]["大類"].ToString().Contains(cmboxBigClassOfBook.Text))
                                        AddRow(i);
        }

        private void dataGridView_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            if (e.RowIndex < 0)
                return;
            try
            {
                txtBoxNo.Text=bno = dataGridView.Rows[e.RowIndex].Cells[0].Value.ToString();
                txtBoxName.Text=bname = dataGridView.Rows[e.RowIndex].Cells[1].Value.ToString();
                txtBoxAuthor.Text = dataGridView.Rows[e.RowIndex].Cells[2].Value.ToString();
                txtBoxpublishing_company.Text = dataGridView.Rows[e.RowIndex].Cells[3].Value.ToString();
                cmboxBigClassOfBook.Text = dataGridView.Rows[e.RowIndex].Cells[6].Value.ToString();
                cmboxSmallClassOfBook.Text = dataGridView.Rows[e.RowIndex].Cells[5].Value.ToString();
                CountOfBookNow = dataGridView.Rows[e.RowIndex].Cells[4].Value.ToString();
                //pictureBox.Image = null;
                pictureBox.Image = Program.DataOperator.GetBookImageFromBookNo(bno);
                //MessageBox.Show(CountOfBookNow);
                // MessageBox.Show(no);
                DataRow findRow = thisTable.Rows.Find(bno);
                if (findRow != null)
                    synopsis.Text = findRow["內容簡介"].ToString();
            }
            catch (Exception ex) { }
        }

        private void RefreshBtn_Click(object sender, EventArgs e)
        {
            GetUpToData();
            Dispaly();

        }

        private void cmboxBigClassOfBook_SelectedIndexChanged(object sender, EventArgs e)
        {
            ArrayList SmallClassOfBook = Program.DataOperator.GetSmallClassOfBook(cmboxBigClassOfBook.Text);
            cmboxSmallClassOfBook.Items.Clear();
                foreach (string sdata in SmallClassOfBook)
                    cmboxSmallClassOfBook.Items.Add(sdata);
            
        }



        private void borrowBtn_Click(object sender, EventArgs e)
        {
            
            new frmIssueBook(bno, bname, CountOfBookNow,synopsis.Text).Show();
        }

        private void Clear_Click(object sender, EventArgs e)
        {
            txtBoxNo.Text = txtBoxName.Text = txtBoxAuthor.Text = txtBoxpublishing_company.Text = cmboxBigClassOfBook.Text = cmboxSmallClassOfBook.Text = "";
        }
    }
}