#region Include Classes
using System;
using System.Text;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using MySql;
using MySql.Web;
using MySql.Data;
using MySql.Data.Common;
using MySql.Data.Entity;
using MySql.Data.Entity.Properties;
using MySql.Data.MySqlClient;
using MySql.Data.MySqlClient.Authentication;
using MySql.Data.MySqlClient.Properties;
using MySql.Data.Types;
#endregion


namespace WebApplication1
{
    public partial class Default : System.Web.UI.Page
    {
        private string tmpStr = String.Empty;

        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                Default pageHandler = sender as Default;
                tmpStr = HttpUtility.UrlDecode(pageHandler.ClientQueryString);

                if (tmpStr != String.Empty)
                {
                    if (pageHandler.Request.HttpMethod == "GET")
                    {
                        if (pageHandler.Request.Params["method"] == "checkAuth")
                        {
                            string reqLogin = pageHandler.Request.Params["username"].ToString();
                            string reqPass = pageHandler.Request.Params["password"].ToString();
                            bool reqChecked = Convert.ToBoolean(pageHandler.Request.Params["checked"].ToString());

                            MySQLGear mysqlObject = new MySQLGear();
                            MySqlConnection mysqlConn = mysqlObject.CreateConnection();
                            bool userExists = Convert.ToBoolean(mysqlObject.MakeScalar(ref mysqlConn,
                                "SELECT COUNT(*) FROM `data_user` WHERE username='" + reqLogin + "' AND password='" + reqPass + "'"));

                            if (userExists)
                            {
                                pageHandler.Response.Cookies.Add(new HttpCookie("sessionId", Guid.NewGuid().ToString()));
                                pageHandler.Response.Cookies.Add(new HttpCookie("clientIp", pageHandler.Request.UserHostAddress.ToString()));
                                pageHandler.Response.Cookies.Add(new HttpCookie("timeAuth", DateTime.Now.ToString()));

                                Response.Redirect("Cabinet.aspx");
                            }
                            else
                            {
                                Page.ClientScript.RegisterStartupScript(GetType(), "", "alert('Такого пользователя - нет в базе данных!'); RedirectUser('Default.aspx');", true);
                            }
                        }
                    }
                    else if (pageHandler.Request.HttpMethod == "POST")
                    {

                    }
                }
            }
            catch (Exception exc)
            {
                exc.ToString();
            }
        }
    }
}