using System;
using System.Web;
using M3Workflow.Data;
using M3Workflow.Data.Base;
using System.Data.SqlClient;
using System.Configuration;
using System.Web.SessionState;

namespace M3Workflow.Web
{
    public partial class Login : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {            
            this.labelErrorMessage.Visible = false;
            if (Request.QueryString["errorMessage"] != null)
            {
                this.labelErrorMessage.Visible = true;
                this.labelErrorMessage.Text = Request.QueryString["errorMessage"].ToString();
            }
        }


        private void CreateListTables(string cabinetName)
        {
            /* UNCOMMENT
            SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["IntelligentIndexingWorkflow"].ConnectionString);
            cn.Open();
            SqlCommand cmd = new SqlCommand("[dbo].[usp_CreateSelectListTables]", cn);
            cmd.CommandType = System.Data.CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@CabinetName", cabinetName);
            cmd.ExecuteNonQuery();
            cn.Close();
            cn.Dispose();
            */
        }

        protected void buttonLogin_ServerClick(object sender, EventArgs e)
        {
            UserDataObject userDataObject = null;


            /* Uncomment this for testing 
            try
            {
                if (!Session.IsNewSession)
                {
                    Session.Clear();
                    SessionIDManager manager = new SessionIDManager();
                    string newID = manager.CreateSessionID(Context);
                    bool redirected = false;
                    bool isAdded = false;
                    manager.SaveSessionID(Context, newID, out redirected, out isAdded);
                    Session["SessionId"] = Session.SessionID;
                }
                userDataObject = M3DataProvider.Authenticate(inputUserName.Value, inputPassword.Value);
            }
            catch
            {
                Response.Redirect(
                    String.Format(
                        "Login.aspx?errorMessage={0}",
                        new object[]
                        {
                             HttpUtility.UrlEncode("Unable to autheticate.")
                        }
                    )
                );
            }
            */

            userDataObject = M3DataProvider.Authenticate(inputUserName.Value, inputPassword.Value);

            if (userDataObject != null && userDataObject.Token != null)
            {
                userDataObject.SetCredentials(
                    new AuthDataObject(inputUserName.Value, inputPassword.Value)
                );
                Session.Add("UserDataObject", userDataObject);
                Session["SessionId"] = Session.SessionID;
                foreach (UserCustomerObject customer in userDataObject.Customers)
                {
                    CreateListTables(customer.Cabinet);
                }
                Response.Redirect("Default.aspx");
            }
            else
            {
                Response.Redirect(
                    String.Format(
                        "Login.aspx?errorMessage={0}",
                        new object[]
                        {
                             HttpUtility.UrlEncode("Unable to connect to the authentication server with the supplied credentials.")
                        }
                    )
                );
            }
        }
    }
}