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.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Xml.Linq;
using CoreSavingLibrary.WcfNCommon;
//using adminservice;
using CoreSavingLibrary;
using CoreSavingLibrary.WcfNAdmin;
using DataLibrary;
using EncryptDecryptEngine;

namespace Saving
{
    public partial class ChangePass : PageWebSheet, WebSheet
    {
        Sdt dt = new Sdt();

        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void Button1_Click(object sender, EventArgs e)
        {

            //รหัสผ่านที่ป้อนจากหน้าจอ.
            String userID, oldPass, newPass, confirmPass, oldpass_eny;
            WebState state = new WebState(Session,Request);
            userID = state.SsUsername;
            oldPass = TextBox1.Text.Trim();
            oldpass_eny = Encryption.UserPassword(oldPass);
            newPass = TextBox2.Text.Trim();
            confirmPass = TextBox3.Text.Trim();
            string resultpass = "";

            try
            {
                string sql = @"select password from amsecusers where user_name={0} and coop_id='" + state.SsCoopId + "'";

                sql = WebUtil.SQLFormat(sql, userID);
                dt = WebUtil.QuerySdt(sql);

                if (dt.Next())
                {
                    resultpass = dt.GetString("password");
                }

                //resultpass = adminService.of_decodestring(state.SsWsPass, password);
            }
            catch (Exception ex)
            {
                LtServerMessage.Text = WebUtil.ErrorMessage(ex);
            }
            
            if (newPass == "" || confirmPass == "" || oldPass == "")
                {
                    LtServerMessage.Text = WebUtil.ErrorMessage("กรุณากรอกข้อมูลให้ครบทุกช่อง");
                }
            else if (oldpass_eny != resultpass)
                 {
                     LtServerMessage.Text = WebUtil.ErrorMessage("รหัสเก่าไม่ถูกต้อง");
                 }
            else if (newPass != confirmPass)
                 {
                     LtServerMessage.Text = WebUtil.ErrorMessage("รหัสผ่านใหม่ไม่ตรงกัน");
                 }
                 else
                 {

                     int result = 0;
                     try
                     {
                         //result = adminService.of_saveuserpassword(state.SsWsPass, user_name, new_pass);

                         string newpass_update = "";
                         newpass_update = Encryption.UserPassword(newPass);

                         String sql = @"update amsecusers set password = {0} where user_name = {1} and coop_id='" + state.SsCoopId + "'";
                         sql = WebUtil.SQLFormat(sql, newpass_update, userID);
                         Sdt dt = WebUtil.QuerySdt(sql);


                         LtServerMessage.Text = WebUtil.CompleteMessage("เปลี่ยนรหัสผ่านสำเร็จ");
                     }
                     catch (Exception ex)
                     {
                         LtServerMessage.Text = WebUtil.ErrorMessage(ex);
                         LtServerMessage.Text = WebUtil.ErrorMessage("เปลี่ยนรหัสไม่สำเร็จ");
                     }
                 }  
        }

        public void InitJsPostBack()
        {

            this.IgnoreReadable = true;
        }

        public void WebSheetLoadBegin()
        {
        }

        public void CheckJsPostBack(string eventArg)
        {
        }

        public void SaveWebSheet()
        {
        }

        public void WebSheetLoadEnd()
        {
        }
    }
}