using System;
using System.Collections.Generic;
using DataModule.Security;
using DataModule.SQL;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Text;
using System.Security.Cryptography;

public partial class UserProfile_Profile : System.Web.UI.Page
{
    protected string oldPassword = "";
    User cuser = DataModule.Security.User.CurentUser();
    public static string CryptWord(string aWord)
    {
        Encoding uni = Encoding.GetEncoding(1251);
        byte[] bytes = uni.GetBytes(aWord);
        MD5CryptoServiceProvider CSP = new MD5CryptoServiceProvider();
        byte[] byteHash = CSP.ComputeHash(bytes);
        return uni.GetString(byteHash);
    }

    protected void changePassBtnState(bool state)
    {
        if (state)
        {
            oldPasswordLabel.Visible = true;
            newPasswordLabel.Visible = true;
            repeatNewPasswordLabel.Visible = true;
            oldPasswordText.Visible = true;
            newPasswordText.Visible = true;
            repeatNewPasswordText.Visible = true;
            savePasswordButton.Visible = true;
            changePasswordButton.Enabled = false;
        }
        if(!state){
            oldPasswordLabel.Visible = false;
            newPasswordLabel.Visible = false;
            repeatNewPasswordLabel.Visible = false;
            oldPasswordText.Visible = false;
            newPasswordText.Visible = false;
            repeatNewPasswordText.Visible = false;
            savePasswordButton.Visible = false;
            changePasswordButton.Enabled = true;
        }

    }
    protected void Page_Load(object sender, EventArgs e)
    {
        string photoName;
        firstNameLabel.Text = cuser.FirstName.ToString();
        lastNameLabel.Text = cuser.Surname.ToString();
        middleNameLabel.Text = cuser.MiddleName.ToString();
        oldPasswordText.Password = true;

        changePassBtnState(false);


        if (cuser.isStudent == true)
        {
            studentInfoTable.Visible = true;
            teacherInfoTable.Visible = false;
            Student student = new Student(cuser.AnotherID);
            photoName = student.photoName;
            userPhoto.ImageUrl = "~/Photo/" + photoName;

            //string query = "SELECT Пароль FROM Все_Студенты WHERE Код = " + cuser.AnotherID.ToString();
            //DBTable myDbTable = new DBTable(query);
            //oldPassword = myDbTable["Пароль"].ToString();
            string query = "SELECT Пароль FROM Все_Студенты WHERE Код = " + cuser.AnotherID.ToString();
            oldPassword = SqlManager.ExecuteScalar(query).ToString();
        }
        else
        {
            teacherInfoTable.Visible = true;
            studentInfoTable.Visible = false;
            Prepod prepod = new Prepod(cuser.AnotherID);
            photoName = prepod.Photo;
            userPhoto.ImageUrl = "~/PhotoP/" + photoName;

            string query = "SELECT Пароль FROM Пользователи WHERE ID = " + cuser.ID.ToString();
            oldPassword = SqlManager.ExecuteScalar(query).ToString();
        }
        //newPasswordText.Text = oldPassword;
    }
    protected void changePasswordButton_Click(object sender, EventArgs e)
    {
        changePassBtnState(true);
    }
    protected void savePasswordButton_Click(object sender, EventArgs e)
    {
        //// Response.Write("<script>alert('Roma Vasiya')</script>");

        //if (oldPassword != CryptWord(oldPasswordText.Text))
        //{
        //    Response.Write("<script>alert('Неверный старый пароль')</script>");
        //}
        //else if (oldPassword == CryptWord(oldPasswordText.Text))
        //{

        //    if (newPasswordText.Text != repeatNewPasswordText.Text)
        //    {
        //        Response.Write("<script>alert('Пароли не совпадают')</script>");
        //    }
        //    else
        //    {
        //        updatePassword(newPasswordText.Text);
        //        changePassBtnState(false);
        //    }
        //}
        updatePassword(newPasswordText.Text);
    }

    protected void updatePassword(string newPassword)
    {
        string query = "";
        string cryptPassword;
        cryptPassword = CryptWord(newPassword);
        if (!cuser.isStudent)
        {
            query = "SELECT * FROM Пользователи WHERE ID=" + cuser.ID.ToString();
        }
        else
        {
            query = "SELECT * FROM Все_Студенты WHERE Код=" + cuser.AnotherID.ToString();
        }
        //DBTable myTable = new DBTable(query);

        SqlManager.ExecuteNonQuery("UPDATE Все_Студенты SET Пароль = '" + cryptPassword + "' WHERE Код=" + cuser.AnotherID.ToString());
        //DataRow row = null;
        //if (cuser.UID == 0)
        //    row = myTable.NewRow();
        //else
        //    row = myTable.Table.Rows[0];

        //row["Пароль"] = newPassword;

        //myTable.Update();
    }
}