using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class create_user : System.Web.UI.Page
{
    SqlConnection con;
    SqlCommand com;
    SqlDataReader dr;
    string user_id = "", user_type = "";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["out"].ToString() == "false")
        {
            Response.Redirect("log_out.aspx");
        }
        else if (Session["u_type"].ToString() == "admin")
        {
          con = new SqlConnection(ConfigurationManager.ConnectionStrings["regis_dbConnectionString"].ConnectionString);
     
          

        } 
        else
        {

          Response.Redirect("log_out.aspx");
        }
    }
    public static string base64Encode(string sData)
    {
        try
        {
            byte[] encData_byte = new byte[sData.Length];

            encData_byte = System.Text.Encoding.UTF8.GetBytes(sData);

            string encodedData = Convert.ToBase64String(encData_byte);

            return encodedData;

        }
        catch (Exception ex)
        {
            throw new Exception("Error in base64Encode" + ex.Message);
        }
    }

    public static string base64Decode(string sData)
    {
        try
        {

            System.Text.UTF8Encoding encoder = new System.Text.UTF8Encoding();

            System.Text.Decoder utf8Decode = encoder.GetDecoder();

            byte[] todecode_byte = Convert.FromBase64String(sData);

            int charCount = utf8Decode.GetCharCount(todecode_byte, 0, todecode_byte.Length);

            char[] decoded_char = new char[charCount];

            utf8Decode.GetChars(todecode_byte, 0, todecode_byte.Length, decoded_char, 0);

            string result = new String(decoded_char);

            return result;
        }
        catch (Exception ex)
        {
            throw new Exception("Error in base64Decode" + ex.Message);
        }

    }
    protected void create_id_Click(object sender, EventArgs e)
    {
        bool flag;
        Label1.Text = "";
        string  str = "select * from log_master where log_id='" + txt_box_user_id.Text + "'";
        con.Open();
        com = new SqlCommand(str, con);
        dr = com.ExecuteReader();
        if (dr.HasRows)
        {
            flag = true;
        }
        else
        {
            flag = false;
        }
        com.Dispose();
        con.Close();

        if (flag)
        {
            Label1.Text = "User Already Exist";
            flag = false;
        }
        else
        {

            string ery_pass = base64Encode(txt_box_password.Text);
            //Label2.Text = base64Decode(Label1.Text);




             str = "insert into log_master values('" + txt_box_user_id.Text + "','" + ery_pass + "','" + ddl_type.Text + "')";
            con.Open();
            com = new SqlCommand(str, con);
            com.ExecuteNonQuery();
            com.Dispose();
            con.Close();
            
            ddl_type.Text = "user";
            Label1.Text = "User Created";
            str = "select * from log_master where log_id='" + txt_box_user_id.Text + "'";
            con.Open();
            com = new SqlCommand(str, con);
            dr = com.ExecuteReader();
            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    user_id = dr[0].ToString();
                    user_type = dr[2].ToString();
                    Session["u_id"] = user_id;
                    //Session["u_type"] = user_type;
                }
                txt_box_user_id.Text = "";
            }
            else
            {
                Label1.Text = "Enter Valid Id!";
            }
            com.Dispose();
            con.Close();
            if (user_type == "admin")
            {
                //Response.Redirect("admin_choice_form.aspx");
            }
            else if (user_type == "user")
            {
                bool ab = false;
                bool ab1 = true;
                str = "insert into registration_master(registration_no,hostel,transport,other,scholar_yes,scholar_no,apply_registration,admin_mode_cash,admin_mode_other,dean_yes,dean_no,loan_yes,loan_no) values('" + user_id + "','" + ab + "','" + ab + "','" + ab1 + "','" + ab + "','" + ab1 + "','" + ab + "','"+ab1+"','"+ab+"','"+ab+"','"+ab1+"','"+ab+"','"+ab1+"')";
                con.Open();
                com = new SqlCommand(str, con);
                com.ExecuteNonQuery();
                com.Dispose();
                con.Close();
                string userid = user_id + "kumar";
                str = "insert into image_master(roll_number) values('" + userid + "')";
                con.Open();
                com = new SqlCommand(str, con);
                com.ExecuteNonQuery();
                com.Dispose();
                con.Close();

                string userid1 = user_id + "vats";
                str = "insert into image_master(roll_number) values('" + userid1 + "')";
                con.Open();
                com = new SqlCommand(str, con);
                com.ExecuteNonQuery();
                com.Dispose();
                con.Close();

                for (int i = 1; i <= 2; i++)
                {
                    str = "insert into contact_info(roll_number,id) values('" + user_id + "','" + i.ToString() + "')";

                    con.Open();
                    com = new SqlCommand(str, con);
                    com.ExecuteNonQuery();
                    com.Dispose();
                    con.Close();
                }


                //////for (int i = 1; i <= 12; i++)
                //////{
                //////    str = "insert into course_master(roll_number,sem) values('" + user_id + "','" + i.ToString() + "')";
                //////    con.Open();
                //////    com = new SqlCommand(str, con);
                //////    com.ExecuteNonQuery();
                //////    com.Dispose();
                //////    con.Close();
                //////}


                //////for (int i = 1; i <= 8; i++)
                //////{
                //////    str = "insert into cop_master(roll_number,sem) values('" + user_id + "','" + i.ToString() + "')";
                //////    con.Open();
                //////    com = new SqlCommand(str, con);
                //////    com.ExecuteNonQuery();
                //////    com.Dispose();
                //////    con.Close();
                //////}


               


                Response.Redirect("registration_form.aspx");
            }
        }
       
    }
    protected void cancel_Click(object sender, EventArgs e)
    {
        Response.Redirect("log_in_form.aspx");
    }
    protected void link_btn_home_Click(object sender, EventArgs e)
    {
       
            if (Session["u_type"].ToString() == "admin")
            {
                Response.Redirect("admin_choice_form.aspx");
            }
            else
            {
                string session_check = "false";
                Session["out"] = session_check;
                Response.Redirect("log_out.aspx");
            }
            //Response.Redirect("log_in_form.aspx");

    }
    protected void link_btn_logout_Click(object sender, EventArgs e)
    {

        //if (Session["u_type"].ToString() == "admin")
        //{
        //    Response.Redirect("admin_choice_form.aspx");
        //}
        //else
        string session_check = "false";
        Session["out"] = session_check;
            Response.Redirect("log_out.aspx");
        
    }
}