using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using KnihovnaData;

namespace Knihovna
{

    public partial class knihy : Form
    {
        KnihovnaData.KnihovnaDataDbmlDataContext DB = new KnihovnaData.KnihovnaDataDbmlDataContext();

        public knihy()
        {
            InitializeComponent();
        }

        private void knihyDataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        
        }

        private void knihy_Load(object sender, EventArgs e)
        {

            this.knihyBindingSource.DataSource = DB.knihies;

        }

        private void searchButton_Click(object sender, EventArgs e)
        {
            List<KnihovnaData.knihy> result = (from c in DB.knihies where c.nazev == searchBox.Text select c).ToList();
            //this.vytiskyBindingSource.DataSource = result;
            this.knihyBindingSource.DataSource = result;
        }

        private void loadView(object sender, EventArgs e)
        {
            Console.WriteLine("neco napis");
            try 
            { 
                int i;
                i = knihyDataGridView.SelectedCells[1].RowIndex;
                isbnBox.Text = knihyDataGridView.Rows[i].Cells[0].Value.ToString();
                nameBox.Text = knihyDataGridView.Rows[i].Cells[1].Value.ToString();
                firstNameBox.Text = knihyDataGridView.Rows[i].Cells[2].Value.ToString();
                lastNameBox.Text = knihyDataGridView.Rows[i].Cells[3].Value.ToString();

            }
            catch (Exception ex) 
            {
                Console.WriteLine(ex);
            }
        }

        private void loadView(object sender, DataGridViewCellEventArgs e)
        {

        }

        private void buttonEdit_Click(object sender, EventArgs e)
        {
            string isbn = isbnBox.Text;
            var update = (from c in DB.GetTable<KnihovnaData.knihy>() where c.isbn == isbn select c).SingleOrDefault();
            try 
            {
                update.isbn = isbnBox.Text;
                update.nazev = nameBox.Text;
                update.autor_jmeno = firstNameBox.Text;
                update.autor_prijmeni = lastNameBox.Text;
                DB.SubmitChanges();
                MessageBox.Show("Zaznam byl upraven.");
            }
            catch (Exception)
            {
                MessageBox.Show("Zadejte platný formát!"); 
            }
            this.knihyBindingSource.DataSource = DB.knihies;
        }

        private void addButton_Click(object sender, EventArgs e)
        {
            KnihovnaData.ctenari read = new KnihovnaData.ctenari();
            try 
            {
                if (isbnBox.Text == string.Empty)
                {
                } 
                else
                { 
                    read.cislo_prukazky = int.Parse(textBox1.Text);
                } 
                if (textBox2.Text == string.Empty) 
                {
                }
                else 
                { 
                    read.rc = int.Parse(textBox2.Text);
                }
                if (textBox3.Text == string.Empty)
                {
                }
                else
                {
                    read.jmeno = textBox3.Text;
                }
                if (textBox4.Text == string.Empty)
                {
                }
                else 
                { 
                    read.prijmeni = textBox4.Text;
                } 
                db.ctenaris.InsertOnSubmit(read);
                db.SubmitChanges();
                MessageBox.Show("Ctenár byl pridán");
                load_data();
            }
            catch (FormatException) 
            { 
                MessageBox.Show("Zadejte platný formát"); 
            }
        }


    }
}