using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using MySql.Data.MySqlClient;


namespace FileUpload
{
    public partial class add_user : System.Web.UI.Page
    {
        MySqlConnection myConnection;
        MySqlCommand cmd;

        String strSQL = null;

        
        string username = null;
        string userpass = null;
        string usermail = null;
        Int32 rolaId;

        protected void Page_Load(object sender, EventArgs e)
        {
            connectToMySql();
        }

        void connectToMySql()
        {
            username = (Request.QueryString["username"]);
            userpass = (Request.QueryString["userpass"]);
            usermail = (Request.QueryString["usermail"]);
            rolaId = Convert.ToInt32(Request.QueryString["rolaid"]);

            //username = "Sanja";
            //userpass = "1234sanja";
            //usermail = "sanja@multi-design.biz";
            //rolaId = 1;

            
           // username = (Request.Form["username"]);
           // userpass = (Request.Form["userpass"]);
           // usermail = (Request.Form["usermail"]);
           // rolaId = Convert.ToInt32(Request.Form["rolaid"]);

            userpass = encodeMd5(userpass);
            

            //Response.Write("username= " + username + "<br>");
            //Response.Write("userpass= " + userpass + "<br>");
            //Response.Write("usermail= " + usermail + "<br>");
            //Response.Write("rolaId= " + rolaId.ToString() + "<br>");

            myConnection = new MySqlConnection("server=orf-mysql1.brinkster.com; user id=tstefan; password=multi1234; database=tstefan; pooling=false;");
            strSQL = "INSERT INTO usu_users (UserName, UserPass, UserMail, RoleID) ";
            strSQL += "VALUES ('" + username + "', '" + userpass + "', '" + usermail + "', " + rolaId + ") ";

            cmd = new MySqlCommand();

            
            myConnection.Open();

            cmd.Connection = myConnection;
            cmd.CommandText = strSQL;
            cmd.ExecuteNonQuery();

            myConnection.Close();
        }


        public static string encodeMd5(string sPassword)
        {
            System.Security.Cryptography.MD5CryptoServiceProvider x = new System.Security.Cryptography.MD5CryptoServiceProvider();
            byte[] bs = System.Text.Encoding.UTF8.GetBytes(sPassword);
            bs = x.ComputeHash(bs);
            System.Text.StringBuilder s = new System.Text.StringBuilder();
            foreach (byte b in bs)
            {
                s.Append(b.ToString("x2").ToLower());
            }
            return s.ToString();
        }
    }
}