/// <summary>
 /// Updates all gestures.
 /// </summary>
 /// <param name="data">The skeleton data.</param>
 public virtual void UpdateAllGestures(Skeleton data, UserInfo userInfo = null)
 {
     foreach (Gesture gesture in this.gestures)
     {
         gesture.UpdateGesture(data, userInfo);
     }
 }

        /// <summary>
        /// 添加
        /// </summary>
        /// <param name="_userinfo"></param>
        /// <returns></returns>
        public int InsertUser(UserInfo _userinfo)
        {
            string cmdText = @" insert into [loachs_users](
                                [Type],[UserName],[Name],[Password],[Email],[SiteUrl],[AvatarUrl],[Description],[displayorder],[Status],[PostCount],[CommentCount],[CreateDate])
                                values (
                                @Type,@UserName,@Name,@Password,@Email,@SiteUrl,@AvatarUrl,@Description,@Displayorder,@Status, @PostCount,@CommentCount,@CreateDate )";
            SqliteParameter[] prams = {
                                        SqliteDbHelper.MakeInParam("@Type", DbType.Int32,4, _userinfo.Type),
                                        SqliteDbHelper.MakeInParam("@UserName", DbType.String,50, _userinfo.UserName),
                                        SqliteDbHelper.MakeInParam("@Name", DbType.String,50, _userinfo.Name),
                                        SqliteDbHelper.MakeInParam("@Password", DbType.String,50, _userinfo.Password),
                                        SqliteDbHelper.MakeInParam("@Email", DbType.String,50, _userinfo.Email),
                                        SqliteDbHelper.MakeInParam("@SiteUrl", DbType.String,255, _userinfo.SiteUrl),
                                        SqliteDbHelper.MakeInParam("@AvatarUrl", DbType.String,255, _userinfo.AvatarUrl),
                                        SqliteDbHelper.MakeInParam("@Displayorder", DbType.String,255, _userinfo.Description),
                                        SqliteDbHelper.MakeInParam("@Status", DbType.Int32,4, _userinfo.Displayorder),
                                        SqliteDbHelper.MakeInParam("@Status", DbType.Int32,4, _userinfo.Status),
                                        SqliteDbHelper.MakeInParam("@PostCount", DbType.Int32,4, _userinfo.PostCount),
                                        SqliteDbHelper.MakeInParam("@CommentCount", DbType.Int32,4, _userinfo.CommentCount),
                                        SqliteDbHelper.MakeInParam("@CreateDate", DbType.Date,8, _userinfo.CreateDate),

                                    };
            int r = SqliteDbHelper.ExecuteNonQuery(CommandType.Text, cmdText, prams);
            if (r > 0)
            {
                return Convert.ToInt32(SqliteDbHelper.ExecuteScalar("select   [UserId] from [loachs_users]  order by [UserId] desc limit 1"));
            }
            return 0;
        }

        protected override void PrivateHandle(UserInfo info, List<string> args)
        {
            if (args.Count == 0)
            {
                info.AwayMessage = null;
                info.Modes.RemoveMode<ModeAway>();
                IrcDaemon.Replies.SendUnAway(info);
            }
            else
            {
                info.AwayMessage = args [0];
                info.Modes.Add (new ModeAway());
                IrcDaemon.Replies.SendNowAway(info);
            }

            foreach (var channel in info.Channels)
            {
                foreach (var user in  channel.Users)
                {
                    if (user.Capabilities.Contains("away-notify"))
                    {

                        Send (new AwayArgument (info, user, (args.Count == 0) ? null : args[0]));
                    }
                }
            }
        }

        /// <summary>
        /// 添加
        /// </summary>
        /// <param name="userinfo"></param>
        /// <returns></returns>
        public int InsertUser(UserInfo userinfo)
        {
            string cmdText =string.Format(@" insert into [{0}users](
                                [UserType],[UserName],[NickName],[Password],[Email],[SiteUrl],[AvatarUrl],[Description],[sortnum],[Status],[PostCount],[CommentCount],[CreateTime])
                                values (
                                @UserType,@UserName,@NickName,@Password,@Email,@SiteUrl,@AvatarUrl,@Description,@SortNum,@Status, @PostCount,@CommentCount,@CreateTime )",ConfigHelper.Tableprefix);
            SqliteParameter[] prams = {
                                        SqliteHelper.MakeInParam("@UserType", DbType.Int32,4, userinfo.UserType),
                                        SqliteHelper.MakeInParam("@UserName", DbType.String,50, userinfo.UserName),
                                        SqliteHelper.MakeInParam("@NickName", DbType.String,50, userinfo.NickName),
                                        SqliteHelper.MakeInParam("@Password", DbType.String,50, userinfo.Password),
                                        SqliteHelper.MakeInParam("@Email", DbType.String,50, userinfo.Email),
                                        SqliteHelper.MakeInParam("@SiteUrl", DbType.String,255, userinfo.SiteUrl),
                                        SqliteHelper.MakeInParam("@AvatarUrl", DbType.String,255, userinfo.AvatarUrl),
                                        SqliteHelper.MakeInParam("@Description", DbType.String,255, userinfo.Description),
                                        SqliteHelper.MakeInParam("@SortNum", DbType.Int32,4, userinfo.SortNum),
                                        SqliteHelper.MakeInParam("@Status", DbType.Int32,4, userinfo.Status),
                                        SqliteHelper.MakeInParam("@PostCount", DbType.Int32,4, userinfo.PostCount),
                                        SqliteHelper.MakeInParam("@CommentCount", DbType.Int32,4, userinfo.CommentCount),
                                        SqliteHelper.MakeInParam("@CreateTime", DbType.Date,8, userinfo.CreateTime),

                                    };
            int r = SqliteHelper.ExecuteNonQuery(CommandType.Text, cmdText, prams);
            if (r > 0)
            {
                return Convert.ToInt32(SqliteHelper.ExecuteScalar(string.Format("select [UserId] from [{0}users]  order by [UserId] desc limit 1",ConfigHelper.Tableprefix)));
            }
            return 0;
        }

    protected void Page_Load(object sender, EventArgs e)
    {

        
        if (!IsPostBack)
        {

            DataTable dt = OrganizationInfo.GetLogoPath(UserOrganizationId);
            if (dt != null && dt.Rows.Count > 0)
            {
                string str = ConfigurationManager.AppSettings["LogoUploadLocation"] + dt.Rows[0]["vchLogoPath"].ToString();
                if (!string.IsNullOrEmpty(dt.Rows[0]["vchLogoPath"].ToString()))
                {
                    str = str.Replace("//", "/");
                    logoimg.Src = str;
                }
            }
            UserInfo obj = UserInfo.GetCurrentUserInfo();
            UserInfo objUser = new UserInfo(obj.UserId);
            if (objUser.UserProfileImage != null)
            {
                profileimage.Src = "data:image/(gif|png|jpeg|jpg);base64," + Convert.ToBase64String(objUser.UserProfileImage);
            }
        }
        GetMenuPermission();
        GetOrganizationAndRoleName();
        //lblProduct.Text = CatName; 
    }

    protected void Page_Load(object sender, EventArgs e)
    {
        lblAvialable.Text = GetString("User_Sites.Available");

        // Get user ID
        userId = QueryHelper.GetInteger("userid", 0);
        if (userId > 0)
        {
            // Check that only global administrator can edit global administrator's accouns
            ui = UserInfoProvider.GetUserInfo(userId);
            EditedObject = ui;
            CheckUserAvaibleOnSite(ui);

            if (!CheckGlobalAdminEdit(ui))
            {
                plcTable.Visible = false;
                lblError.Text = GetString("Administration-User_List.ErrorGlobalAdmin");
                lblError.Visible = true;
            }
            else
            {
                // Get the user sites
                currentValues = GetUserSites();

                if (!RequestHelper.IsPostBack())
                {
                    usSites.Value = currentValues;
                }

                usSites.OnSelectionChanged += usSites_OnSelectionChanged;
            }
        }
    }

        public override bool HandleEvent(CommandBase command, ChannelInfo channel, UserInfo user, List<string> args)
        {
            if (onlyOnce) { return true; }
            onlyOnce = true;

            if (command is Join)
            {
                user.IrcDaemon.Commands.Send(new NoticeArgument(user, user, channel.Name, "This channel automatically translates your messages, use the LANGUAGE command to set your preferred language"));
            }
            if (!channel.Modes.HandleEvent(command, channel, user, args))
            {
                onlyOnce = false;
                return false;
            }
            if (command is PrivateMessage || command is Notice)
            {

                var translateDelegate = new GoogleTranslate.TranslateMultipleDelegate(translator.TranslateText);
                translateDelegate.BeginInvoke(args[1], channel.Users.Select(u => u.Languages.First()).Distinct(), TranslateCallBack, Tuple.Create(channel, user, command));

                onlyOnce = false;
                return false;
            }

            onlyOnce = false;
            return true;
        }

        /// <summary>
        /// Import user from CSV format.
        /// </summary>
        /// <param name="rows">
        /// Each string in the list must contain 25 CSV fields, as follows:
        ///     0 - UserName
        ///     1 - StaffType
        ///     2 - Id
        ///     3 - FamilyName
        ///     4 - GivenName
        ///     5 - MiddleName
        ///     6 - Prefix
        ///     7 - Suffix
        ///     8 - Degree
        /// </param>
        /// <param name="context"></param>
        public override void Import(List<string> rows, IUpdateContext context)
        {
            _context = context;

            List<User> importedUsers = new List<User>();

            foreach (string row in rows)
            {
                string[] fields = ParseCsv(row, _numFields);

                string userName = fields[0];

                string staffId = fields[2];
                string staffFamilyName = fields[3];
                string staffGivenName = fields[4];

                User user = GetUser(userName, importedUsers);

                if (user == null)
                {
                	UserInfo userInfo =
                		new UserInfo(userName, string.Format("{0} {1}", staffFamilyName, staffGivenName), null, null, null);
					user = User.CreateNewUser(userInfo, _settings.DefaultTemporaryPassword);
                    _context.Lock(user, DirtyState.New);

                    importedUsers.Add(user);
                }
            }
        }

    protected void Button1_Click(object sender, EventArgs e)
    {
        UserInfo obj = new UserInfo();
        DataTable dtab1 = new DataTable();
        string username = TextBox1.Text;
        string password = TextBox2.Text;
        dtab1 = obj.signin(username, password);

        if (dtab1.Rows.Count > 0)
        {

            if (TextBox1.Text == "Administrator" && TextBox2.Text=="admin")
            {
                Session["Username"] = dtab1.Rows[0][1].ToString();
                Response.Redirect("Admin/index.aspx");
            }
            else
            {
                Response.Write("Logged in successfully");
                Session["userid"] = dtab1.Rows[0][0].ToString();
                Session["Username"] = dtab1.Rows[0][1].ToString();
                Response.Redirect("bus_details.aspx");
            }

        }
        else
        {
            Label3.Visible = true;
            Label3.Text="Incorrect Username /Password";
            TextBox2.Text = "";
            TextBox1.Text = "";
        }
    }

 public void ProcessRequest(HttpContext context)
 {
     using (UserOperateClient insUserBLL = new UserOperateClient())
     {
         //context.Response.ContentType = "text/plain";
         //context.Response.Write("Hello World");
         UserInfo strUserInfo = new UserInfo();
         //strUserInfo.LoginName = context.Application.Equals("loginName").ToString();
         strUserInfo.LoginName =context.Session["loginname"].ToString();
         strUserInfo.UserName = System.Web.HttpUtility.UrlDecode(context.Request["username"]);
         strUserInfo.Birthday = Convert.ToDateTime(System.Web.HttpUtility.UrlDecode(context.Request["birthday"]));
         strUserInfo.Sexy = System.Web.HttpUtility.UrlDecode(context.Request["sex"]);
         strUserInfo.GraduteSchool = System.Web.HttpUtility.UrlDecode(context.Request["school"]);
         strUserInfo.Job = System.Web.HttpUtility.UrlDecode(context.Request["job"]);
         strUserInfo.MobilPhone = System.Web.HttpUtility.UrlDecode(context.Request["mobilphone"]);
         strUserInfo.QQ = System.Web.HttpUtility.UrlDecode(context.Request["qq"]);
         strUserInfo.Msn = System.Web.HttpUtility.UrlDecode(context.Request["msn"]);
         strUserInfo.Weibo = System.Web.HttpUtility.UrlDecode(context.Request["weibo"]);
         strUserInfo.EnglishName = System.Web.HttpUtility.UrlDecode(context.Request["englishname"]);
         try
         {
             if (insUserBLL.UpdateUserInfo(strUserInfo) == true)
             {
                 context.Response.Write("success");
             }
             else
             {
                 context.Response.Write("fail");
             }
         }
         catch (Exception ex)
         { }
     }
 }

        protected override void PrivateHandle(UserInfo info, List<string> args)
        {
            if (!IrcDaemon.Nicks.ContainsKey(args[0]))
            {
                IrcDaemon.Replies.SendNoSuchNick(info, args[0]);
                return;
            }

            var user = IrcDaemon.Nicks[args[0]];
            IrcDaemon.Replies.SendWhoIsUser(info, user);
            if (info.UserPerChannelInfos.Count > 0)
            {
                IrcDaemon.Replies.SendWhoIsChannels(info, user);
            }
            IrcDaemon.Replies.SendWhoIsServer(info, user);
            if (user.AwayMessage != null)
            {
                IrcDaemon.Replies.SendAwayMessage(info, user);
            }

            if (IrcDaemon.Options.IrcMode == IrcMode.Modern)
            {
                IrcDaemon.Replies.SendWhoIsLanguage(info, user);
            }

            if (user.Modes.Exist<ModeOperator>() || user.Modes.Exist<ModeLocalOperator>())
            {
                IrcDaemon.Replies.SendWhoIsOperator(info, user);
            }

            IrcDaemon.Replies.SendWhoIsIdle(info, user);
            IrcDaemon.Replies.SendEndOfWhoIs(info, user);
        }

        protected void Submit_Click(object sender, EventArgs e)
        {
            string strData = JsonChecked.Value;
            exception = "";
            List<UserInfo> userData = JSON.ScriptDeserialize<List<UserInfo>>(strData);
            for (int i = 0; i < userData.Count; i++)
            {
                UserInfo userinfo = new UserInfo();
                userinfo = userData.ElementAt(i);
                userinfo.UiType = userinfo.UiType.Remove(4, 1).Insert(4, "1");
                UserInfoBLL.Update(userinfo, ref exception);
            }

            if (exception == "" || exception == null)
            {
                Errors.Value = "提交成功";
                Hidden1.Value = "submit";
                ClientScript.RegisterStartupScript(this.GetType(), "", "tanchuang()", true);
                return;
            }
            else
            {
                Errors.Value = exception;
                Hidden1.Value = "submit";
                ClientScript.RegisterStartupScript(this.GetType(), "", "tanchuang()", true);
                return;
            }
        }

        public void AddUser_GetUsers()
        {
            IUsersStorageProviderV30 prov = GetProvider();

            UserInfo u1 = new UserInfo("user", "User", "[email protected]", true, DateTime.Now.AddDays(-1), prov);
            UserInfo u2 = new UserInfo("john", null, "[email protected]", false, DateTime.Now, prov);

            UserInfo u1Out = prov.AddUser(u1.Username, u1.DisplayName, "password", u1.Email, u1.Active, u1.DateTime);
            Assert.IsNotNull(u1Out, "AddUser should return something");
            AssertUserInfosAreEqual(u1, u1Out, true);

            UserInfo u2Out = prov.AddUser(u2.Username, u2.DisplayName, "password", u2.Email, u2.Active, u2.DateTime);
            Assert.IsNotNull(u2Out, "AddUser should return something");
            AssertUserInfosAreEqual(u2, u2Out, true);

            Assert.IsNull(prov.AddUser("user", null, "pwd999", "[email protected]", false, DateTime.Now), "AddUser should return false");

            UserInfo[] users = prov.GetUsers();
            Array.Sort(users, delegate(UserInfo x, UserInfo y) { return x.Username.CompareTo(y.Username); });

            Assert.AreEqual(2, users.Length, "Wrong user count");

            AssertUserInfosAreEqual(u2, users[0], true);
            AssertUserInfosAreEqual(u1, users[1], true);
        }

        protected override void PrivateHandle(UserInfo info, List<string> args)
        {
            var message = (args.Count > 1) ? args[1] : IrcDaemon.Options.StandardPartMessage;

            foreach (string channelName in GetSubArgument(args[0]))
            {
                if (IrcDaemon.Channels.ContainsKey(channelName))
                {
                    var chan = IrcDaemon.Channels[channelName];

                    if (info.Channels.Contains(chan))
                    {
                        Send(new PartArgument(info, chan, chan, message));
                        chan.RemoveUser(info);
                    }
                    else
                    {
                        IrcDaemon.Replies.SendNotOnChannel(info, channelName);
                    }
                }
                else
                {
                    IrcDaemon.Replies.SendNoSuchChannel(info, channelName);
                }
            }
        }

    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        GenralUserInfo objGenralUserInfo = new GenralUserInfo();
        UserInfo objUserInfo = new UserInfo();

        TributesPortal.Utilities.StateManager stateManager = StateManager.Instance;

        //stateManager.Add("UserId", objGenralUserInfo.RecentUsers.UserID.ToString(), StateManager.State.Session);
        objUserInfo.UserID = int.Parse(stateManager.Get("UserId", StateManager.State.Session).ToString());
        objUserInfo.UserEmail = txtEmail.Text.Trim();//int.Parse(stateManager.Get("UserId", StateManager.State.Session).ToString());
        objUserInfo.UserPassword = txtPassword.Text.Trim();
        objGenralUserInfo.RecentUsers = objUserInfo;
        _presenter.OnChangeEmailPassword(objGenralUserInfo);
        if (objGenralUserInfo.CustomError == null)
        {
            txtEmail.Text = objGenralUserInfo.RecentUsers.UserEmail;
            txtPassword.Text = objGenralUserInfo.RecentUsers.UserPassword;
            txtConformPassword.Text = objGenralUserInfo.RecentUsers.UserPassword;
            lblMessage.Text = ResourceText.GetString("msgSuccess_CEP");
        }
        else
        {
            lblMessage.Text = objGenralUserInfo.CustomError.ErrorMessage.ToString();
        }
    }

 public List<User> searchUsers(UserInfo userInfo)
 {
     // ...
     // end::UserService[]
     return new List<User>();
     // tag::UserService[]
 }

    protected void lnkbtnAddInventory_Click(object sender, EventArgs e)
    {

            UserInfo objUser = new UserInfo();
            objUser.UserId = 0;
            objUser.Login = Utils.CleanHTML(txtLogin.Text.Trim());
            objUser.Pwd = Encryption.Encrypt(txtPassword.Text.Trim());
            objUser.Email = txtEmail.Text.Trim();
            objUser.FirstName = txtFirstName.Text.Trim();
            objUser.MiddleName = txtMiddleName.Text.Trim();
            objUser.LastName = txtLastName.Text.Trim();
            objUser.DateCreated = DateTime.Now;
            objUser.CreatedByUserId = currentUserInfo.UserId;
            objUser.LanguageId = LanguageId;
            objUser.IsApproved = true;
            objUser.Number = txtPhoneNumber.Text.Trim();

            string RoleIDs = string.Empty;



            UserInfo.InsertUser(objUser, 2, "1", true);

            if (objUser.UserId > 0)
            {
                Response.Redirect("/User/ViewAdminUsers.aspx");
            }
       
       
    }

    /// <summary>
    /// 修改用户信息
    /// </summary>
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        string lb = Request.QueryString["查询类别"];
        string tj = Request.QueryString["查询条件"];
        string lr = Request.QueryString["查询内容"];
        string lr1 = Request.QueryString["查询内容1"];
        string lr2 = Request.QueryString["查询内容2"];
        string id = Request.QueryString["id"];

        UserInfo userInfo = new UserInfo();
        userInfo.UserName = username.Text;
        userInfo.UserPwd = Md5.Encrypt(userpwd.Text);
        userInfo.usersexID = Convert.ToInt16(usersex.SelectedValue);
        userInfo.userlevelID = Convert.ToInt16(userlevel.SelectedValue);
        userInfo.userinfoID = Convert.ToInt32(id);

        bool result = UserInfoDal.Update(userInfo);
        if (result)
        {
            string url;
            url = "chaxun.aspx?查询类别=" + lb
             + "&查询条件=" + tj + "&查询内容=" + lr + "&查询内容1=" + lr1 + "&查询内容2=" + lr2;
            Response.Redirect(url);
        }
        else
        {
            ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "alert('更新记录失败！！');location='javascript:history.go(-1)'", true);
        }
    }

    public string ValidateUser(string UserName, string Passsword)
    {
        string _UserType = string.Empty;
        try
        {
            GenralUserInfo objGenralUserInfo = new GenralUserInfo();
            UserInfo objUserInfo = new UserInfo();

            objUserInfo.UserName = UserName;
            objUserInfo.UserPassword = Passsword;
            objGenralUserInfo.RecentUsers = objUserInfo;
            _presenter.OnLogin(objGenralUserInfo);

            if (objGenralUserInfo.CustomError == null)
            {
                //ShowMessage(objGenralUserInfo.CustomError.ErrorMessage.ToString());
                _UserType = objGenralUserInfo.RecentUsers.UserType.ToString();
            }
            else
            {
                ShowMessage(objGenralUserInfo.CustomError.ErrorMessage.ToString());
            }

        }
        catch (Exception ex)
        {
            throw ex;
        }

        return _UserType;
    }

        private void SubmitButton_Click(object sender, RoutedEventArgs e)
        {
            if (string.IsNullOrEmpty(this.NewPasswordBox.Password)||this.NewPasswordBox.Password.Length<5)
            {
                MessageBox.Show("密码必须为5位以上");
                return;
            }

            if (this.ConfirmPasswordBox.Password!=this.NewPasswordBox.Password)
            {
                MessageBox.Show("确认密码必须与新密码一致");
                return;
            }
            UserInfo userInfo=new UserInfo()
                                  {
                                      UserName = GlobalInfo.CurrentUserName,
                                      OldPassword = this.OldPasswordBox.Password,
                                      UserPassword = this.NewPasswordBox.Password,
                                  };

            string error=null;
            if (LoginManager.Instance.ModifyPassword(userInfo, out error))
            {
                MessageBox.Show("修改密码成功");
                this.Close();
            }
            else
            {
                MessageBox.Show(error);
            }
        }