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 NHibernate;
using NHibernate.Cfg;
using NewTest.Classes;

namespace NewTest
{
    public partial class MainForm : Form
    {
        private ISessionFactory factory = null;

        public MainForm()
        {
            InitializeComponent();

            log4net.Config.XmlConfigurator.Configure();
            Configuration configuration = new Configuration();
            configuration.Configure();
            configuration.AddAssembly(System.Reflection.Assembly.GetExecutingAssembly());
            factory = configuration.BuildSessionFactory();
        }

        private IList<User> getUsers()
        {
            IList<User> resultSet = null;

            using (ISession session = factory.OpenSession())
            {
                ICriteria criteria = session.CreateCriteria<User>();
                resultSet = criteria.List<User>();
                session.Flush();
                session.Close();
            }

            return resultSet;
        }

        private void updateList()
        {
            lbUsers.Items.Clear();
            IList<User> users = getUsers();
            foreach (User usr in users)
            {
                lbUsers.Items.Add(usr);
            }
        }

        private void MainForm_Load(object sender, EventArgs e)
        {
            updateList();
        }

        private void btnAdd_Click(object sender, EventArgs e)
        {
            User user = new User();

            user.FirstName = tbFirstName.Text;
            user.LastName = tbLastName.Text;
            user.Email = tbEmail.Text;
            user.Password = tbPassword.Text;

            using (ISession session = factory.OpenSession())
            {
                session.Save(user);
                session.Flush();
                session.Close();
            }

            tbFirstName.Text = "";
            tbLastName.Text = "";
            tbEmail.Text = "";
            tbPassword.Text = "";

            updateList();
        }

        private void btnUpdate_Click(object sender, EventArgs e)
        {
            User user = (User)lbUsers.SelectedItem;

            user.FirstName = tbFirstName.Text;
            user.LastName = tbLastName.Text;
            user.Email = tbEmail.Text;
            user.Password = tbPassword.Text;

            using (ISession session = factory.OpenSession())
            {
                session.Update(user);
                session.Flush();
                session.Close();
            }

            tbFirstName.Text = "";
            tbLastName.Text = "";
            tbEmail.Text = "";
            tbPassword.Text = "";

            updateList();
        }

        private void lbUsers_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (lbUsers.SelectedItem != null)
            {
                User user = (User)lbUsers.SelectedItem;

                tbFirstName.Text = user.FirstName;
                tbLastName.Text = user.LastName;
                tbEmail.Text = user.Email;
                tbPassword.Text = user.Password;
            }
        }

        private void btnDelete_Click(object sender, EventArgs e)
        {
            if (lbUsers.SelectedItem != null)
            {
                using (ISession session = factory.OpenSession())
                {
                    session.Delete(lbUsers.SelectedItem);
                    session.Flush();
                    session.Close();
                }

                tbFirstName.Text = "";
                tbLastName.Text = "";
                tbEmail.Text = "";
                tbPassword.Text = "";

                updateList();
            }
        }
    }
}