public JsonResult GetClientMember()
        {
            if (CheckIsLogin())
            {
                var svMember = new B2B.Common.MemberService();
                var data     = svMember.SelectData <view_Member>(" * ", " IsDelete = 0 AND MemberID = " + LogonMemberID).First();
                var member   = new B2B.Common.MemberModel();

                #region Set Data
                member.MemberID    = data.MemberID;
                member.Username    = data.UserName;
                member.Password    = data.Password;
                member.Displayname = data.DisplayName;
                member.Email       = data.Email;
                member.Mobile      = data.Mobile;
                member.Phone       = data.Phone;
                member.RowFlag     = data.RowFlag;
                member.RowVersion  = data.RowVersion;
                member.ProvinceID  = data.ProvinceID;
                member.DistrictID  = data.DistrictID;
                #endregion

                var encrypt = new EncryptManager();
                member.SecretID = svMember.GetSecretID(data.UserName, encrypt.DecryptData(data.Password), GetAppSetting("WebID"));
                return(Json(member));
            }
            else
            {
                return(Json(null));
            }
        }
        public JsonResult ClientMemberSync(FormCollection form)
        {
            var svMember = new B2B.Common.MemberService();
            int ID       = int.Parse(form["MemberID"].Trim());

            var model     = svMember.GetEmMember(form["SecretID"]);
            var sqlUpdate = string.Empty;
            var sqlWhere  = " MemberID = " + model.MemberID;

            if (model != null)
            {
                #region Set Model
                sqlUpdate  = " UserName = '******' ";
                sqlUpdate += ", Password = '******' ";
                sqlUpdate += ", DisplayName = '" + form["DisplayName"] + "' ";
                sqlUpdate += ", Email = '" + form["Email"] + "' ";
                sqlUpdate += ", Phone = '" + form["Phone"] + "' ";
                sqlUpdate += ", Mobile = '" + form["Mobile"] + "' ";

                if (!string.IsNullOrEmpty(form["FirstName"]))
                {
                    sqlUpdate += ", FirstName = '" + form["FirstName"] + "' ";
                }

                if (!string.IsNullOrEmpty(form["LastName"]))
                {
                    sqlUpdate += ", LastName = '" + form["LastName"] + "' ";
                }

                if (!string.IsNullOrEmpty(form["AddrLine1"]))
                {
                    sqlUpdate += ", AddrLine1 = '" + form["AddrLine1"] + "' ";
                }

                if (!string.IsNullOrEmpty(form["DistrictID"]))
                {
                    sqlUpdate += ", DistrictID =  " + form["DistrictID"].Trim() + " ";
                }

                if (!string.IsNullOrEmpty(form["ProvinceID"]))
                {
                    sqlUpdate += ", ProvinceID =  " + form["ProvinceID"].Trim() + " ";
                }

                if (!string.IsNullOrEmpty(form["RowVersion"]))
                {
                    var rowversion = int.Parse(form["RowVersion"]);
                    sqlUpdate += ", RowVersion =  " + rowversion + " ";
                }


                svMember.UpdateByCondition <emMember>(sqlUpdate, sqlWhere);
                #endregion
            }


            return(Json(svMember.IsResult));
        }