using System;
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 _Default : System.Web.UI.Page 
{
    SqlConnection con;
    SqlCommand com;
    SqlDataReader dr;
    string user_id="", user_type="";
    protected void Page_Load(object sender, EventArgs e)
    {
        con = new SqlConnection(ConfigurationManager.ConnectionStrings["regis_dbConnectionString"].ConnectionString);

    }


    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 btn_login_Click(object sender, EventArgs e)
    {
        string ery_pass = base64Encode(txt_box_pass.Text);
        //Label2.Text = base64Decode(Label1.Text);




        string str = "select * from log_master where log_id='"+txt_box_logid.Text+"' and password='"+ery_pass+"'";
        string sesssion_check="false";
        //string str = "select * from log_master where log_id='" + txt_box_logid.Text + "' and password='" + txt_box_pass.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;
            }
            sesssion_check="true";
            Session["out"]=sesssion_check;
        }
        else 
        {
            Label1.Text = "Enter Valid Id/Password!";
        }
        com.Dispose();
        con.Close();
        if (user_type == "admin")
        {
          Response.Redirect("admin_choice_form.aspx");
        }
        else if (user_type == "user")
        {
            
            Response.Redirect("user_choice_form.aspx");
        }
        else if(user_type == "Dean")
        {
            Response.Redirect("admin_form.aspx");
        }
        else if (user_type == "Account")
        {

            Response.Redirect("admin_form.aspx");
        }
        else if(user_type == "Registrar")
        {
            Response.Redirect("admin_form.aspx");
        }
        else if (user_type == "Academic cell")
        {
          Response.Redirect("admin_form.aspx");
        }
       
    }
   
   
   
   
}