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.OleDb;
 
namespace MathsNumeracy
{
    public partial class LogIn : Form
    {
        private string sConnection;
        private OleDbConnection dbConn;
        private OleDbCommand dbCmd;
        private Learner1 aLearner;
        private Teacher1 aTeacher;
        private OleDbDataReader dbReader;
        private string sql;
 
 
        public LogIn()
        {
            InitializeComponent();
        }
 
        private void btnPrevious_Click(object sender, EventArgs e)
        {
            Form1 start = new Form1();
            this.Hide();
            start.ShowDialog();
        }
 
        private void btnLogIn_Click(object sender, EventArgs e)
        {
            try
            {
                sConnection = "Provider = Microsoft.Jet.OLEDB.4.0;" +
                                    "DataSource = MathsNumeracy.mdb";
                dbConn = new OleDbConnection(sConnection);
                dbConn.Open();
 
                if (cmbStatus.Text.ToString() == "Teacher")
                {
                    sql = "Select LogID, Password From TeacherLog;";
                    dbCmd = new OleDbCommand();
                    dbCmd.CommandText = sql;
                    dbCmd.Connection = dbConn;
 
                    dbReader = dbCmd.ExecuteReader();
 
                    while (dbReader.Read())
                    {
                        aTeacher = new Teacher1(dbReader["LogID"].ToString(),dbReader["Name"].ToString(),dbReader["Surname"].ToString(), dbReader["Password"].ToString(), dbReader["Class"].ToString());
                        if ((dbReader["LogID"].ToString() == txtLogID.Text) && (dbReader["Password"].ToString() == txtPassword.Text))
                        {
                            TeacherAdmin tAdmin = new TeacherAdmin();
                            this.Hide();
                            tAdmin.ShowDialog();
                            this.Show();
                        }
 
                    }
 
 
                }
                else
                    if (cmbStatus.Text.ToString() == "Learner")
                    {
                        sql = "Select * From LearnerLog;";
                        dbCmd = new OleDbCommand();
                        dbCmd.CommandText = sql;
                        dbCmd.Connection = dbConn;
 
                        dbReader = dbCmd.ExecuteReader();
 
                        while (dbReader.Read())
                        {
                            aLearner = new Learner1(dbReader["LogID"].ToString(), dbReader["Name"].ToString(), dbReader["Surname"].ToString(), dbReader["Password"].ToString(), dbReader["Class"].ToString());
 
                            if ((dbReader["LogID"].ToString() == txtLogID.Text) && (dbReader["Password"].ToString() == txtPassword.Text))
                            {
                                LearnerTasks lTasks = new LearnerTasks();
                                this.Hide();
                                lTasks.ShowDialog();
                                this.Show();
                            }
                        }
 
 
                    }
                dbReader.Close();
                dbConn.Close();
            }
            catch(System.Exception exc)
            {
                this.lblError.Text = exc.Message;
            }
        }
 
 
    }
}