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.OleDb;
using System.Data.SqlClient;

namespace v1go
{
    public partial class Login : Form
    {
        public Login()
        {
            InitializeComponent();
        }

        private void Login_Load(object sender, EventArgs e)
        {
            /* Center Form on screen */
            this.CenterToScreen();

            /* Load the user's credentials and remember state from Settings */
            txtUsername.Text = Properties.Settings.Default.username;
            txtPassword.Text = Properties.Settings.Default.password;
            chkRemember.Checked = Properties.Settings.Default.remember;
        }

        private void btnLogin_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection();
            con.ConnectionString = "server=162.253.224.12;user id=meisterc;persistsecurityinfo=True;database=meisterc_mybb598";
            con.Open();
            string userid = txtUsername.Text;
            string password = txtPassword.Text;
            SqlCommand cmd = new SqlCommand("select userid,password from login where userid='" + txtUsername.Text + "'and password='" + txtPassword.Text + "'", con);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill(dt);
            if (dt.Rows.Count > 0)
            {
                /* If chkRemember is checked, save the users's credentials, otherwise reset them to an empty string */
                if (chkRemember.Checked)
                {
                    Properties.Settings.Default.username = txtUsername.Text.Trim();
                    Properties.Settings.Default.password = txtPassword.Text;
                }
                else
                {
                    Properties.Settings.Default.username = String.Empty;
                    Properties.Settings.Default.password = String.Empty;
                }

                /* Set the remember state */
                Properties.Settings.Default.remember = chkRemember.Checked;

                /* Save the settings */
                Properties.Settings.Default.Save();

                /* Hide Login, show Loader and close Login */
                this.Hide();
                AuthLoad loader = new AuthLoad(txtUsername.Text.Trim());
                loader.ShowDialog();
                this.Close();
            }
            con.Close();
        }
        private void btnCancel_Click(object sender, EventArgs e)
        {
            /* Exit the loader */
            Application.Exit();
        }

        private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
        {

        }
    }
}