Exemple #1
0
        /// <summary>
        /// 获取用户
        /// </summary>
        /// <param name="userInfo">用户实体</param>
        /// <param name="pageInfo">分页实体</param>
        /// <returns></returns>
        public IList <UsersInfo> GetUser(UsersInfo userInfo, PageInfo pageInfo)
        {
            using (DataContextDB DB = new DataContextDB())
            {
                IQueryable <UsersInfo> userInfos =
                    (
                        from item in DB.GetTable <UsersInfo>()
                        orderby item.ID descending
                        select item
                    );
                if (userInfo != null && userInfo.ID != 0)
                {
                    userInfos = userInfos.Where <UsersInfo>(m => m.ID == userInfo.ID);
                }
                if (userInfo != null && !string.IsNullOrEmpty(userInfo.Name))
                {
                    userInfos = userInfos.Where <UsersInfo>(m => m.Name.Contains(userInfo.Name));
                }
                if (userInfo != null && userInfo.UserGroup != 0)
                {
                    userInfos = userInfos.Where <UsersInfo>(m => m.UserGroup == userInfo.UserGroup);
                }

                if (pageInfo != null)
                {
                    pageInfo.TotalRecord = userInfos.Count();
                    return(userInfos.Skip(pageInfo.PageSize * (pageInfo.PageIndex - 1)).Take(pageInfo.PageSize).ToList <UsersInfo>());
                }
                else
                {
                    return(userInfos.ToList <UsersInfo>());
                }
            }
        }
        public ActionResult LoginTrapper(string returnUrl, LoginViewModel model)
        {
            //  var manager = new ApplicationUserManager(new UserStore<ApplicationUser>(new ApplicationDbContext()));
            //   var currUser = manager.FindById(User.Identity.GetUserId());

            ApplicationUser dtChangeApp = null;
            UsersInfo       dtChange    = null;
            //1. Get student from DB
            var stss = Session["UserFname"].ToString();

            using (var ctx = new ApplicationDbContext())
            {
                dtChangeApp = ctx.Users.Where(s => s.Email.Equals(stss)).FirstOrDefault <ApplicationUser>();
                dtChange    = ctx.DbUsersInfo.Where(s => s.UserEmail.Equals(model.Email)).FirstOrDefault <UsersInfo>();
                // dtChange = ctx.DbUsersInfo.Where(s => s.UserEmail.Equals(model.Email)).FirstOrDefault<UsersInfo>();
            }

            //2. change student name in disconnected mode (out of ctx scope)
            if (dtChangeApp != null)
            {
                dtChangeApp.LastLogin = DateTime.Now;
                dtChange.LastLogin    = DateTime.Now;
            }

            //save modified entity using new Context
            using (var dbCtx = new ApplicationDbContext())
            {
                //3. Mark entity as modified
                dbCtx.Entry(dtChangeApp).State = System.Data.Entity.EntityState.Modified;
                dbCtx.Entry(dtChange).State    = System.Data.Entity.EntityState.Modified;
                //4. call SaveChanges
                dbCtx.SaveChanges();
            }
            return(RedirectToLocal(returnUrl));
        }
 protected override void OnNavigatedTo(NavigationEventArgs e)
 {
     if (e.Parameter is UsersInfo)
     {
         user = ((UsersInfo)e.Parameter);
     }
     if (user.Role == 1)
     {
         users.Clear();
         for (int i = 0; i < ViewModel.Instance.UsersList.Count; i++)
         {
             if (ViewModel.Instance.UsersList[i].Username == user.Username)
             {
                 users.Add(ViewModel.Instance.UsersList[i]);
             }
         }
         AddPanel.Visibility        = Visibility.Collapsed;
         SearchPanel.Visibility     = Visibility.Collapsed;
         confirmButton.Content      = "修改";
         usernameTextBlock.Text     = user.Username;
         passwordTextBlock.Password = user.Password;
         emailTextBlock.Text        = user.Email;
         phoneTextBlock.Text        = user.Phone;
         roleTextBlock.Text         = temp.Role == 0 ? "管理员" : "用户";
     }
 }
Exemple #4
0
 //个人中心视图
 public ActionResult Center(int?id)
 {
     if (Request.Cookies["Login"] == null)
     {
         return(RedirectToAction("Login", "Users"));
     }
     else
     {
         HttpCookie cookie   = Request.Cookies["Login"];
         JObject    username = readtoken(cookie.Values["Token"]);
         UsersInfo  user     = uManager.GetUsersInfo((int)id);
         string     name     = user.UserName;
         var        visitor  = username["UserName"].ToString();
         if (visitor == user.UserName)
         {
             ViewBag.username = name;
             //db.PersonalSpace(name, visitor);
             return(View(user));
         }
         else
         {
             return(RedirectToAction("TouristCenter", "Tourist", new { id, name }));
         }
     }
 }
        // POST api/<controller>
        public IHttpActionResult Post([FromBody] AddUser user)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            User us = new User
            {
                login    = user.Login,
                password = user.Password
            };

            db.Users.Add(us);
            UsersInfo usf = new UsersInfo
            {
                FirstName  = user.FirstName,
                SecondName = user.SecondName,
                login      = user.Login,
                address    = user.Address,
                BornDate   = Convert.ToDateTime(user.BornDate),
                mail       = user.Mail,
                number     = user.Number,
                Patronomyc = user.Patronomyc
            };

            db.UsersInfoes.Add(usf);
            db.SaveChanges();
            return(Ok(User));
        }
Exemple #6
0
        public IActionResult Index(string pageInfo = null)
        {
            //HttpContext.Session.Clear();

            //LoginInfo.SetLoginUser(string.Empty, string.Empty);
            HttpContext.SignOutAsync(CookieAuthenticationDefaults.AuthenticationScheme);

            using (var def = new DoctorContext())
            {
                var loadUsers = (from u in def.Users
                                 where u.LeaveDate >= DateTime.Now ||
                                 u.LeaveDate.Equals(DateTime.Parse("1900-01-01"))
                                 select u).ToList();
                UsersInfo.SetUsers(loadUsers);
                var users = new LoginIndexViewModel()
                {
                    Users = (from u in UsersInfo.Users
                             select new SelectListItem()
                    {
                        Text = u.UserName,
                        Value = u.UserNo,
                        Selected = false
                    }).ToList()
                };
                if (!string.IsNullOrEmpty(pageInfo))
                {
                    ModelState.AddModelError("PageInfo", pageInfo);
                }
                return(View(users));
            }
        }
Exemple #7
0
        /// <summary>
        /// 更新数据
        /// </summary>
        /// <param name="mod">UsersInfo</param>
        /// <returns>受影响行数</returns>
        public int Update(UsersInfo mod)
        {
           using (DbConnection conn = db.CreateConnection())
			{
				conn.Open();
				using (DbTransaction tran = conn.BeginTransaction())
				{ 
					try
					{ 
						using (DbCommand cmd = db.GetStoredProcCommand("SP_Users_Update"))
						{
							db.AddInParameter(cmd, "@UserID", DbType.Int32, mod.UserID); 
							db.AddInParameter(cmd, "@UserName", DbType.String, mod.UserName); 
							db.AddInParameter(cmd, "@Password", DbType.String, mod.Password); 
							db.AddInParameter(cmd, "@State", DbType.Int32, mod.State); 
							db.AddInParameter(cmd, "@IsDeleted", DbType.Int32, mod.IsDeleted); 
							db.AddInParameter(cmd, "@Sort", DbType.Int32, mod.Sort); 
							tran.Commit();
							return db.ExecuteNonQuery(cmd);
						} 
					}
					catch (Exception e)
					{
						tran.Rollback();
						throw e;
					}
					finally
					{
						conn.Close();
					}
				}
			}
        }  
Exemple #8
0
        /// <summary>
        /// 根据分页获得数据列表
        /// </summary>
        /// <param name="TbFields">返回字段</param>
        /// <param name="strWhere">查询条件</param>
        /// <param name="OrderField">排序字段</param>
        /// <param name="PageIndex">页码</param>
        /// <param name="PageSize">页尺寸</param>
        /// <param name="TotalCount">返回总记录数</param>
        /// <returns>IList<UsersInfo></returns>
        public IList <UsersInfo> Find(string tbFields, string strWhere, string orderField, int pageIndex, int pageSize, out int totalCount)
        {
            IList <UsersInfo> list = new List <UsersInfo>();

            using (DbCommand cmd = db.GetStoredProcCommand("SP_SqlPagenation"))
            {
                db.AddInParameter(cmd, "@TbName", DbType.String, "Users");
                db.AddInParameter(cmd, "@TbFields", DbType.String, tbFields);
                db.AddInParameter(cmd, "@StrWhere", DbType.String, strWhere);
                db.AddInParameter(cmd, "@OrderField", DbType.String, orderField);
                db.AddInParameter(cmd, "@PageIndex", DbType.Int32, pageIndex);
                db.AddInParameter(cmd, "@PageSize", DbType.Int32, pageSize);
                db.AddOutParameter(cmd, "@Total", DbType.Int32, int.MaxValue);
                using (DataTable dt = db.ExecuteDataSet(cmd).Tables[0])
                {
                    if (dt.Rows.Count > 0)
                    {
                        foreach (DataRow dr in dt.Rows)
                        {
                            UsersInfo model = new UsersInfo();
                            model.LoadFromDataRow(dr);
                            list.Add(model);
                        }
                    }
                }

                totalCount = (int)db.GetParameterValue(cmd, "@Total");
                return(list);
            }
        }
        private bool PasswordChecked(UsersInfo userInfo, string oldPassword)
        {
            if (userInfo.PasswordFormat == PasswordFormatOptions.Clear)
            {
                if (!userInfo.Password.Equals(oldPassword))
                {
                    return(false);
                }
            }
            else if (userInfo.PasswordFormat == PasswordFormatOptions.Hashed)
            {
                if (!userInfo.Password.Equals(EncryptHelper.EncodePassword(oldPassword, userInfo.PasswordFormat, userInfo.PasswordSalt)))
                {
                    return(false);
                }
            }
            else if (userInfo.PasswordFormat == PasswordFormatOptions.Encrypted)
            {
                if (!userInfo.Password.Equals(EncryptHelper.UnEncodePassword(oldPassword, userInfo.PasswordFormat, userInfo.PasswordSalt)))
                {
                    return(false);
                }
            }

            return(true);
        }
Exemple #10
0
        private void AuthetnticationButton_Click(object sender, RoutedEventArgs e)
        {
            UsersInfo result = null;

            //foreach (var user in _users)
            //{
            //    if (user.Login == LoginTextBox.Text && user.Password == PasswordBox.Password)
            //    {
            //        result = new UsersInfo() {Login = LoginTextBox.Text,Password = PasswordBox.Password};
            //        break;
            //    }
            //}
            //if (result!=null)
            //{
            if (_mainWindow.CreateSmtpWindowAndConnectToServer(LoginTextBox.Text, PasswordBox.Password))
            {
                _mainWindow.Show();
                Close();
            }

            //}
            else

            {
                MessageBox.Show("Login or Password Error");
            }
            //_mainWindow.Show();
        }
Exemple #11
0
 /// <summary>
 /// 更新数据
 /// </summary>
 /// <param name="mod">UsersInfo</param>
 /// <returns>受影响行数</returns>
 public int Update(UsersInfo mod)
 {
     using (DbConnection conn = db.CreateConnection())
     {
         conn.Open();
         using (DbTransaction tran = conn.BeginTransaction())
         {
             try
             {
                 using (DbCommand cmd = db.GetStoredProcCommand("SP_Users_Update"))
                 {
                     db.AddInParameter(cmd, "@UserID", DbType.Int32, mod.UserID);
                     db.AddInParameter(cmd, "@UserName", DbType.String, mod.UserName);
                     db.AddInParameter(cmd, "@Password", DbType.String, mod.Password);
                     db.AddInParameter(cmd, "@State", DbType.Int32, mod.State);
                     db.AddInParameter(cmd, "@IsDeleted", DbType.Int32, mod.IsDeleted);
                     db.AddInParameter(cmd, "@Sort", DbType.Int32, mod.Sort);
                     tran.Commit();
                     return(db.ExecuteNonQuery(cmd));
                 }
             }
             catch (Exception e)
             {
                 tran.Rollback();
                 throw e;
             }
             finally
             {
                 conn.Close();
             }
         }
     }
 }
Exemple #12
0
        public static UsersInfo GetItemByEmail(string Email)
        {
            if (Email == null)
            {
                return(null);
            }
            if (itemCacheTimeout <= 0)
            {
                return(dal.GetItemByEmail(Email));
            }
            string key   = string.Concat("cnodejs_BLL_UsersByEmail_", Email);
            string value = RedisHelper.Get(key);

            if (!string.IsNullOrEmpty(value))
            {
                try { return(new UsersInfo(value)); } catch { }
            }
            UsersInfo item = dal.GetItemByEmail(Email);

            if (item == null)
            {
                return(null);
            }
            RedisHelper.Set(key, item.Stringify(), itemCacheTimeout);
            return(item);
        }
 public static UsersInfo ValidateUser(UsersInfo user)
 {
     using (var Context = new NPDEntities())
     {
         return(Context.UsersInfoes.FirstOrDefault(x => x.Email == user.Email && x.Password == user.Password));
     }
 }
Exemple #14
0
        public string SaveUser(UsersInfo uInfo)
        {
            if (db.User.Where(u => u.username == uInfo.userName).Count() > 0)
            {
                return("用户名已存在,保存失败");
            }
            try {
                User user = new User()
                {
                    username      = uInfo.userName,
                    real_name     = uInfo.realName,
                    email         = uInfo.email,
                    department_no = db.Department.Single(d => d.name == uInfo.depName && d.dep_type == "部门").dep_no,
                    is_forbit     = false,
                    in_date       = DateTime.Now,
                    error_times   = 0,
                    password      = SomeUtils.getMD5("000000")
                };
                db.User.InsertOnSubmit(user);
                db.SubmitChanges();
            }
            catch (Exception ex) {
                return(ex.Message);
            }

            return("");
        }
        public UsersInfo CreateUser(Guid applicationId, PasswordFormatOptions passwordFormat, string username, string password, string email, string passwordQuestion, string passwordAnswer, bool isApproved, object providerUserKey)
        {
            if (IsExistUser(applicationId, username))
            {
                return(null);
            }

            PasswordInfo passwordInfo = GetPasswordInfo(passwordFormat, password);
            DateTime     currentTime  = DateTime.Now;

            var userInfo = new UsersInfo
            {
                ApplicationId                                  = applicationId,
                Id                                             = providerUserKey == null?Guid.NewGuid() : (Guid)providerUserKey,
                                               Name            = username,
                                               Password        = passwordInfo.Password,
                                               PasswordSalt    = passwordInfo.PasswordSalt,
                                               PasswordFormat  = passwordInfo.PasswordFormat,
                                               Email           = email,
                                               CreatedDate     = currentTime,
                                               LastUpdatedDate = currentTime
            };

            _db.Users.Insert(userInfo);

            return(userInfo);
        }
        public static MainPage Login(UsersInfo usersInfo, IWebDriver driver)
        {
            LoginPage loginPage = new LoginPage(driver);

            loginPage.Login(usersInfo);
            return(loginPage.LoginBtnClick());
        }
Exemple #17
0
        /// <summary>
        /// 单条添加用户角色信息
        /// </summary>
        /// <param name="usersInfo"></param>
        /// <returns></returns>
        public int Add(UsersInfo usersInfo)
        {
            //实例化用户表
            Users users = new Users();

            users.UserName = usersInfo.UserName;
            users.Password = usersInfo.Password;
            var result = UsersDB.Insert(users);

            //如果result为true
            if (result)
            {
                SqlSugarClient sqlSugarClient = Educationcontext.GetClient();
                var            db             = sqlSugarClient.SqlQueryable <Users>("select Id from Users order by Id  ").Max(s => s.Id);
                //实例化用户角色表
                UserandRole userandRole = new UserandRole();
                userandRole.UsersId = db;
                var num = usersInfo.RoleName.Substring(0, usersInfo.RoleName.LastIndexOf(',')).Split(',');

                var usersdb = 0;
                foreach (var item in num)
                {
                    userandRole.RolesId = int.Parse(item);
                    usersdb            += sqlSugarClient.Insertable <UserandRole>(userandRole).ExecuteCommand();
                }
                if (usersdb == num.Length)
                {
                    return(1);
                }
            }
            return(0);
        }
Exemple #18
0
    public List <UsersInfo> getUsersList(string UserId)
    {
        List <UsersInfo> userData = new List <UsersInfo>();

        ConnectDB     db        = new ConnectDB();
        SqlDataSource oracleObj = db.ConnectionOracle();

        oracleObj.SelectCommand = "Select * From USERS_INFO Where USER_ID='" + UserId + "'";
        DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);

        foreach (DataRowView rowData in allData)
        {
            UsersInfo users_data = new UsersInfo();
            users_data.USERS_INFO_USER_ID         = rowData["USER_ID"].ToString();
            users_data.USERS_INFO_NATIONAL_ID     = rowData["NATIONAL_ID"].ToString();
            users_data.USERS_INFO_OFFICIAL_ID     = rowData["OFFICIAL_ID"].ToString();
            users_data.USERS_INFO_TITLE_THAINAME  = rowData["TITLE_THAINAME"].ToString();
            users_data.USERS_INFO_FIRST_THAINAME  = rowData["FIRST_THAINAME"].ToString();
            users_data.USERS_INFO_FAMILY_THAINAME = rowData["FAMILY_THAINAME"].ToString();
            users_data.USERS_INFO_TITLE_ENGNAME   = rowData["TITLE_ENGNAME"].ToString();
            users_data.USERS_INFO_FIRST_ENGNAME   = rowData["FIRST_ENGNAME"].ToString();
            users_data.USERS_INFO_FAMILY_ENGNAME  = rowData["FAMILY_ENGNAME"].ToString();
            users_data.USERS_INFO_FACULTY_ID      = rowData["FACULTY_ID"].ToString();
            users_data.USERS_INFO_DEPARTMENT_ID   = rowData["DEPARTMENT_ID"].ToString();
            users_data.USERS_INFO_INTERNAL_PHONE  = rowData["INTERNAL_PHONE"].ToString();
            users_data.USERS_INFO_EXTERNAL_PHONE  = rowData["EXTERNAL_PHONE"].ToString();
            users_data.OTHEROFFICE_CODE           = rowData["OTHEROFFICE_CODE"].ToString();
            users_data.STATUS   = rowData["STATUS"].ToString();
            users_data.PASSWORD = rowData["PASSWORD"].ToString();
            userData.Add(users_data);
        }

        return(userData);
    }
        public bool ValidateUser(Guid applicationId, PasswordFormatOptions passwordFormat, string username, string password)
        {
            if (passwordFormat == PasswordFormatOptions.Clear)
            {
                return(_db.Users.Exists(m => m.ApplicationId.Equals(applicationId) && m.Name.Equals(username, StringComparison.OrdinalIgnoreCase) && m.Password.Equals(password)));
            }
            else if (passwordFormat == PasswordFormatOptions.Hashed)
            {
                UsersInfo userInfo = _db.Users.FindOne(m => m.ApplicationId.Equals(applicationId) && m.Name.Equals(username, StringComparison.OrdinalIgnoreCase));
                if (userInfo != null)
                {
                    return(EncryptHelper.EncodePassword(password, PasswordFormatOptions.Hashed, userInfo.PasswordSalt) == userInfo.Password);
                }
            }
            else if (passwordFormat == PasswordFormatOptions.Encrypted)
            {
                UsersInfo userInfo = _db.Users.FindOne(m => m.ApplicationId.Equals(applicationId) && m.Name.Equals(username, StringComparison.OrdinalIgnoreCase));
                if (userInfo != null)
                {
                    return(EncryptHelper.UnEncodePassword(password, PasswordFormatOptions.Hashed, userInfo.PasswordSalt) == userInfo.Password);
                }
            }

            return(false);
        }
Exemple #20
0
        public void Inviteuser(string emailId, int UserId)
        {
            var  userDetails = _db.UsersInfoes.FirstOrDefault(a => a.EmailId == emailId);
            Guid uniqueId;

            uniqueId = Guid.NewGuid();
            if (userDetails == null)
            {
                var user = new UsersInfo
                {
                    EmailId     = emailId,
                    UniqueId    = uniqueId.ToString(),
                    Status_Flag = false,
                    IsActive    = false
                };
                using (_db)
                {
                    _db.UsersInfoes.Add(user);
                    _db.SaveChanges();
                }
            }

            UpdateStatus(emailId, UserId);
            //SendEmailInvite(emailId);
        }
Exemple #21
0
        /// <summary>
        /// 身份认证后存入Reids
        /// </summary>
        /// <param name="usersInfo"></param>
        /// <returns></returns>
        public async Task SaveRedisAsync <T>(T t)
        {
            try
            {
                UsersInfo usersInfo = JsonConvert.DeserializeObject <UsersInfo>(JsonConvert.SerializeObject(t));
                //构造ClaimsIdentity 对象
                var identity = new ClaimsIdentity(CookieAuthenticationDefaults.AuthenticationScheme);
                //创建 Claim 类型,传入 ClaimsIdentity 中
                identity.AddClaim(new Claim("keyhou", usersInfo.UserName));

                //创建ClaimsPrincipal对象,传入ClaimsIdentity 对象,调用HttpContext.SignInAsync完成登录
                await HttpContext.SignInAsync(CookieAuthenticationDefaults.AuthenticationScheme, new ClaimsPrincipal(identity));

                //存储redis
                RedisHelper.Set <UsersInfo>(usersInfo.UserName, usersInfo);
            }
            catch
            {
                Candidate candidate = JsonConvert.DeserializeObject <Candidate>(JsonConvert.SerializeObject(t));
                //构造ClaimsIdentity 对象
                var identity = new ClaimsIdentity(CookieAuthenticationDefaults.AuthenticationScheme);
                //创建 Claim 类型,传入 ClaimsIdentity 中
                identity.AddClaim(new Claim("key", candidate.Name));

                //创建ClaimsPrincipal对象,传入ClaimsIdentity 对象,调用HttpContext.SignInAsync完成登录
                await HttpContext.SignInAsync(CookieAuthenticationDefaults.AuthenticationScheme, new ClaimsPrincipal(identity));

                //存储redis
                RedisHelper.Set <Candidate>(candidate.Name, candidate);
            }


            //取Redis
            //var user2 = RedisHelper.Get<ApplicationUser>(lookupUser.UserName);
        }
Exemple #22
0
 protected override void OnNavigatedTo(NavigationEventArgs e)
 {
     if (e.Parameter is UsersInfo)
     {
         user = ((UsersInfo)e.Parameter);
     }
 }
Exemple #23
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["login_data"] == null)
        {
            Response.Redirect("../index.aspx");
        }
        else
        {
            //ตรวจสอบสิทธิ์
            login_data = (UserLoginData)Session["login_data"];
            if (autro_obj.CheckGroupUser(login_data, group_var.admin_university) || autro_obj.CheckGroupUser(login_data, group_var.admin_faculty))
            {
                /*=============================*/
                LoginName = Request.QueryString["UserId"];

                UsersInfo user = new UsersInfo().getUsers(LoginName);

                if (user.USERS_INFO_FACULTY_ID == "00")
                {
                    OtherOfficeData otherOffice = new OtherOffice().getOtherOffice(user.OTHEROFFICE_CODE);
                    lblStringToRemove.Text = LoginName + " สังกัด" + otherOffice.OtherOffice_ThaiName;
                }
                else
                {
                    lblStringToRemove.Text = LoginName + " สังกัด" + new Faculty().getFaculty(user.USERS_INFO_FACULTY_ID).Faculty_Thai;
                }
                /*=============================*/
            }
            else
            {
                HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
                HttpContext.Current.Response.Redirect("err_response.aspx");
            }
        }
    }
Exemple #24
0
        public APIReturn Post_insert([FromForm] string Email, [FromForm] string Github, [FromForm] string Location, [FromForm] string Password, [FromForm] uint?Point, [FromForm] string Sign, [FromForm] string Username, [FromForm] string Website, [FromForm] string Weibo, [FromForm] uint[] mn_Roles, [FromForm] ulong[] mn_Topics)
        {
            UsersInfo item = new UsersInfo();

            item.Create_time = DateTime.Now;
            item.Email       = Email;
            item.Github      = Github;
            item.Location    = Location;
            item.Password    = Password;
            item.Point       = Point;
            item.Sign        = Sign;
            item.Username    = Username;
            item.Website     = Website;
            item.Weibo       = Weibo;
            item             = Users.Insert(item);
            //关联 Roles
            foreach (uint mn_Roles_in in mn_Roles)
            {
                item.FlagRoles(mn_Roles_in);
            }
            //关联 Topics
            foreach (ulong mn_Topics_in in mn_Topics)
            {
                item.FlagTopics(mn_Topics_in);
            }
            return(new APIReturn(0, "成功", "item", item.ToBson()));
        }
        public async Task <IActionResult> Edit(int id, [Bind("Id,Name,Lastname,Tc,Email,Address,Phone1,Phone2,Phone3,Username,Packet,Accesspoint,Ftipi,Osifre,Adurum,Sabitip,Atipi,Pasaportno,Unvan,Vergino,Cinsiyet,Uyruk,Babaadi,Anaadi,Anakizliksoyadi,Dogumyeri,Dogumtarihi,Meslek,Ciltno,Kutukno,Sayfano,Kil,Kilce,Mahkoy,Ktipi,Kserino,Kverildigiyer,Kverildigitarih,Ksahibi,Til,Tilce,Tmahalle,Tcadde,Tdiskapino,Tickapino,Tpostano,Tadresno,Vergidairesi")] UsersInfo usersInfo)
        {
            if (id != usersInfo.Id)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(usersInfo);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!UsersInfoExists(usersInfo.Id))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            return(View(usersInfo));
        }
        public void Enroll(long deviceId, string userId, int finger)
        {
            var device = Devices(DeviceType.Imputed).FirstOrDefault(d => d.id == deviceId);

            if (device == null)
            {
                return;
            }
            _service = new CZKEMClass();
            Connect(device);
            _service.CancelOperation();
            _service.SSR_DelUserTmpExt(MachineNumber, userId, finger);//If the specified index of user's templates has existed ,delete it first.(SSR_DelUserTmp is also available sometimes)

            _service.OnEnrollFinger += (number, index, result, length) =>
            {
                int    flag, tmpLength;
                string tmpData;

                var enroll = _service.GetUserTmpExStr(MachineNumber, userId, finger, out flag, out tmpData,
                                                      out tmpLength)
                    ? new EnrollEventArgs(true, finger, tmpData)
                    : new EnrollEventArgs(false, -1, null);
                OnEnrollCompleted(enroll);


                if (!enroll.Result)
                {
                    return;
                }

                var userInfo = UsersInfo.FirstOrDefault(u => u.EnrollNumber == userId);
                if (userInfo == null)
                {
                    return;
                }
                var fingerPrint = userInfo.FingerPrints.FirstOrDefault(f => f.Finger == finger);
                if (fingerPrint == null)
                {
                    userInfo.FingerPrints.Add(new FingerPrint {
                        Finger = finger, Data = tmpData
                    });
                }
                else
                {
                    fingerPrint.Data = tmpData;
                }
            };


            if (_service.StartEnrollEx(userId, finger, 0))
            {
                _service.StartIdentify();//After enrolling templates,you should let the device into the 1:N verification condition
            }
            else
            {
                var idwErrorCode = 0;
                _service.GetLastError(ref idwErrorCode);
                MessageBox.Show("Operation failed,ErrorCode=" + idwErrorCode, "Error");
            }
        }
        public async Task <Result <List <UsersInfo> > > GetUsers()
        {
            using (var connection = utils.GetDbConnection())
            {
                await connection.OpenAsync();

                var sql = $"SELECT * FROM {tableName}";
                var cmd = connection.CreateCommand();
                cmd.CommandText = sql;
                return(await Result.Of(async() =>
                {
                    var reader = await cmd.ExecuteReaderAsync();
                    var str = new List <UsersInfo>();
                    while (reader.Read())
                    {
                        var res = new UsersInfo
                        {
                            PhoneNumber = (string)reader[TableFields.PhoneNumber],
                            FullName = (string)reader[TableFields.FullName],
                            AdditionalNumbers = (string)reader[TableFields.AdditionalNumbers],
                            Email = (string)reader[TableFields.Email],
                            PositionHeld = (string)reader[TableFields.PositionHeld]
                        };

                        str.Add(res);
                    }

                    return str;
                }));
            }
        }
        private UsersInfo CreateItem(SqlDataReader dr)
        {
            UsersInfo info = new UsersInfo
            {
                UserID   = Convert.ToInt32(dr["UserID"]),
                UserName = Convert.ToString(dr["UserName"]),
                Password = Convert.ToString(dr["Password"])
            };

            if (dr["LastLoginTime"] is DBNull)
            {
                info.LastLoginTime = null;
            }
            else
            {
                info.LastLoginTime = new DateTime?(Convert.ToDateTime(dr["LastLoginTime"]));
            }
            info.EmailAddress = Convert.ToString(dr["EmailAddress"]);
            if (dr["Status"] is DBNull)
            {
                info.Status = null;
            }
            else
            {
                info.Status = new int?(Convert.ToInt32(dr["Status"]));
            }
            if (dr["CreateTime"] is DBNull)
            {
                info.CreateTime = null;
                return(info);
            }
            info.CreateTime = new DateTime?(Convert.ToDateTime(dr["CreateTime"]));
            return(info);
        }
        public async Task <Result <List <UsersInfo> > > SelectUser(SelectInfo info)
        {
            using (var connection = utils.GetDbConnection())
            {
                await connection.OpenAsync();

                var sql = $"SELECT * FROM {tableName} WHERE {info.SelectConditionField} = @SelectConditionValue";
                var cmd = connection.CreateCommand();
                cmd.CommandText = sql;
                cmd.Parameters.Add("@SelectConditionValue", SqlDbType.NVarChar).Value = info.SelectConditionValue;
                return(await Result.Of(async() =>
                {
                    var reader = await cmd.ExecuteReaderAsync();
                    var str = new List <UsersInfo>();
                    while (reader.Read())
                    {
                        var res = new UsersInfo
                        {
                            PhoneNumber = (string)reader[TableFields.PhoneNumber],
                            FullName = (string)reader[TableFields.FullName],
                            AdditionalNumbers = (string)reader[TableFields.AdditionalNumbers],
                            Email = (string)reader[TableFields.Email],
                            PositionHeld = (string)reader[TableFields.PositionHeld]
                        };
                        str.Add(res);
                    }
                    return str;
                }));
            }
        }
Exemple #30
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["login_data"] == null)
        {
            Response.Redirect("../index.aspx");
        }
        else
        {
            //ตรวจสอบสิทธิ์
            login_data = (UserLoginData)Session["login_data"];
            if (autro_obj.CheckGroupUser(login_data, group_var.admin_university) || autro_obj.CheckGroupUser(login_data, group_var.admin_faculty) || autro_obj.CheckGroupUser(login_data, group_var.admin_department) || autro_obj.CheckGroupUser(login_data, group_var.admin_otherOffice))
            {
                /*=============================*/
                userId = Request.QueryString["userId"];

                UsersInfo userInfo = new UsersInfo().getUsers(userId);

                lblCurricuumName.Text = "<span class=\"txt-blue\"><h4>แก้ไขรหัสผ่านผู้ใช้งาน </h4><br>" + userInfo.USERS_INFO_FIRST_THAINAME + " " + userInfo.USERS_INFO_FAMILY_THAINAME + "</span>";

                if (!Page.IsPostBack)
                {
                }
                /*=============================*/
            }
            else
            {
                HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
                HttpContext.Current.Response.Redirect("err_response.aspx");
            }
        }
    }
        protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
        {
            var lstUser = UsersService.UsersInfo_GetByAll();
            var obj     = new UsersInfo
            {
                UserName     = txtUserName.Text,
                Password     = md5(txtPassword.Text),
                FullName     = txtFullName.Text,
                Gender       = rdGender.SelectedValue,
                Avatar       = lbImages1.Text,
                Birthday     = "",
                Email        = txtEmail.Text,
                Address      = txtAddress.Text,
                MobilePhone  = txtNumberPhone.Text,
                IdentityCard = txtIdentyCard.Text,
                LastLoggedOn = "",
                CreatedDate  = "",
                GroupID      = ddlNhomNguoiDung.SelectedValue,
                Active       = "0",
                Level        = "2",
                Ord          = "",
                Admin        = "",
            };
            int userId = UsersService.UsersInfo_Insert(obj, UserID);

            Session["UserControl"] = "~/Default2.aspx?mod=Register";
            Response.Redirect("~/ViewRegister.aspx?id=" + userId);
        }
 private void SerializeInternal(UsersInfo model, IDictionary<string, object> result)
 { 
     result.Add("userid", model.UserID);
     result.Add("username", model.UserName);
     result.Add("password", model.Password);
     result.Add("state", model.State);
     result.Add("isdeleted", model.IsDeleted);
     result.Add("sort", model.Sort);
 }
        /// <summary>
        /// Saves a record to the users table.
        /// </summary>
        public virtual void Insert(UsersInfo usersInfo)
        {
            SqlParameter[] parameters = new SqlParameter[]
            {
                new SqlParameter("@username", usersInfo.Username),
                new SqlParameter("@password", usersInfo.Password),
                new SqlParameter("@roleid", usersInfo.Roleid)
            };

            usersInfo.Userid = (int) SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "users_Insert", parameters);
        }
 /// <summary>
 /// Saves a record to the users table.
 /// </summary>
 public virtual void Insert(UsersInfo usersInfo)
 {
     try
     {
         new UsersTFM().Insert(usersInfo);
     }
     catch (Exception ex)
     {
         //Provider.Log.Error(ex, "TFM.Biz.Implements.Users - Insert" + ex.Message);
         throw;
     }
 }
Exemple #35
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                #region Êý¾Ý¿â²Ù×÷

                UsersManager Manager = new UsersManager();

                //Ìí¼Ó
                //Manager.Save(new UsersInfo()
                //{
                //    UserID = 1,
                //    UserName = "******",
                //    Password = "******",
                //    IsDeleted = 0,
                //    Sort = 1,
                //    State = 0
                //});

                //ÐÞ¸Ä
                //Manager.Update(new CustomerInfo() { UserID = 1, UserName = "******", Password = "******"});
                //ɾ³ý
                //Manager.Remove(8);
                //²éѯ
                ci = Manager.Get(1);

                int TotalCount;
                IList<UsersInfo> value = Manager.Find(out TotalCount);
                RptCustomers.DataSource = value;
                RptCustomers.DataBind();


                #endregion

                #region Json Serialization

                var expected = new UsersInfo()
                {
                    UserID = 1,
                    UserName = "******",
                    Password = "******",
                    IsDeleted = 0,
                    Sort = 1,
                    State = 0
                };

                // {"id":3,"title":"test","date":"2009-12-02T05:12:00"}
                var _serialize = JsonHelper.Register<UsersJavaScriptConverter>();
                _json = _serialize.Serialize(expected);
                json = JsonConverter.Serialize<IList<UsersInfo>>(value);
                #endregion
            }
        }
Exemple #36
0
        public void Insert(int UserKey,string Address1,string Address2,string City,string State,int? Country,string Postalcode,int? Phonecountrycode1,int? Phonetype1,string Phonenumber1,int? Phonecountrycode2,int? Phonetype2,string Phonenumber2,int? Identitynationality,string Occupation,string Passportnumber,DateTime? LastChanged,string Username,string Password,string Ssn,string ImageUrl,int? DefaultCurrency,int? Timezone,string Referral)
        {
            UsersInfo item = new UsersInfo();

            item.UserKey = UserKey;

            item.Address1 = Address1;

            item.Address2 = Address2;

            item.City = City;

            item.State = State;

            item.Country = Country;

            item.Postalcode = Postalcode;

            item.Phonecountrycode1 = Phonecountrycode1;

            item.Phonetype1 = Phonetype1;

            item.Phonenumber1 = Phonenumber1;

            item.Phonecountrycode2 = Phonecountrycode2;

            item.Phonetype2 = Phonetype2;

            item.Phonenumber2 = Phonenumber2;

            item.Identitynationality = Identitynationality;

            item.Occupation = Occupation;

            item.Passportnumber = Passportnumber;

            item.LastChanged = LastChanged;

            item.Username = Username;

            item.Password = Password;

            item.Ssn = Ssn;

            item.ImageUrl = ImageUrl;

            item.DefaultCurrency = DefaultCurrency;

            item.Timezone = Timezone;

            item.Referral = Referral;

            item.Save(UserName);
        }
 public void Insert(UsersInfo model)
 {
     if (model == null)
         throw new ArgumentNullException("usersInfo");
     usersInfoRepository.Insert(model);
 }
Exemple #38
0
        /// <summary>
        /// 根据分页获得数据列表
        /// </summary>
        /// <param name="TbFields">返回字段</param>
        /// <param name="strWhere">查询条件</param>
        /// <param name="OrderField">排序字段</param>
        /// <param name="PageIndex">页码</param>
        /// <param name="PageSize">页尺寸</param> 
        /// <param name="TotalCount">返回总记录数</param>
        /// <returns>IList<UsersInfo></returns>
        public IList<UsersInfo> Find(string tbFields, string strWhere, string orderField, int pageIndex, int pageSize, out int totalCount)
        {
			IList<UsersInfo> list = new List<UsersInfo>();
			using (DbCommand cmd = db.GetStoredProcCommand("SP_SqlPagenation"))
			{
				db.AddInParameter(cmd, "@TbName", DbType.String, "Users");
				db.AddInParameter(cmd, "@TbFields", DbType.String, tbFields);
				db.AddInParameter(cmd, "@StrWhere", DbType.String, strWhere);
				db.AddInParameter(cmd, "@OrderField", DbType.String, orderField);
				db.AddInParameter(cmd, "@PageIndex", DbType.Int32, pageIndex);
				db.AddInParameter(cmd, "@PageSize", DbType.Int32, pageSize);
				db.AddOutParameter(cmd, "@Total", DbType.Int32, int.MaxValue);
				using (DataTable dt = db.ExecuteDataSet(cmd).Tables[0])
				{
					if (dt.Rows.Count > 0)
					{
						foreach (DataRow dr in dt.Rows)
						{
							UsersInfo model = new UsersInfo();
							model.LoadFromDataRow(dr);
							list.Add(model);
						}
					}
				}

				totalCount = (int)db.GetParameterValue(cmd, "@Total");
				return list;
			}
		} 
        /// <summary>
        /// Updates a record in the users table.
        /// </summary>
        public virtual void Update(UsersInfo usersInfo)
        {
            SqlParameter[] parameters = new SqlParameter[]
            {
                new SqlParameter("@userid", usersInfo.Userid),
                new SqlParameter("@username", usersInfo.Username),
                new SqlParameter("@password", usersInfo.Password),
                new SqlParameter("@roleid", usersInfo.Roleid),
                new SqlParameter("@created_date", usersInfo.Created_date),
                new SqlParameter("@last_login", usersInfo.Last_login),
                new SqlParameter("@last_logout", usersInfo.Last_logout)
            };

            SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "users_Update", parameters);
        }
        /// <summary>
        /// Creates a new instance of the users class and populates it with data from the specified SqlDataReader.
        /// </summary>
        protected virtual UsersInfo MakeUsersInfo(SqlDataReader dataReader)
        {
            UsersInfo usersInfo = new UsersInfo();
            usersInfo.Userid = SqlClientUtility.GetInt32(dataReader,DbConstants.USERS.USERID, 0);
            usersInfo.Username = SqlClientUtility.GetString(dataReader,DbConstants.USERS.USERNAME, String.Empty);
            usersInfo.Password = SqlClientUtility.GetString(dataReader,DbConstants.USERS.PASSWORD, String.Empty);
            usersInfo.Roleid = SqlClientUtility.GetInt32(dataReader,DbConstants.USERS.ROLEID, 0);
            usersInfo.Created_date = SqlClientUtility.GetInt32(dataReader,DbConstants.USERS.CREATED_DATE, 0);
            usersInfo.Last_login = SqlClientUtility.GetInt32(dataReader,DbConstants.USERS.LAST_LOGIN, 0);
            usersInfo.Last_logout = SqlClientUtility.GetInt32(dataReader,DbConstants.USERS.LAST_LOGOUT, 0);

            return usersInfo;
        }
        /// <summary>
        /// Creates a new instance of the users class and populates it with data from the specified SqlDataReader.
        /// </summary>
        protected virtual UsersInfo MakeUsersInfo(SqlDataReader dataReader)
        {
            UsersInfo usersInfo = new UsersInfo();
            usersInfo.Userid = SqlClientUtility.GetInt32(dataReader,DbConstants.USERS.USERID, 0);
            usersInfo.Username = SqlClientUtility.GetString(dataReader,DbConstants.USERS.USERNAME, String.Empty);
            usersInfo.Password = SqlClientUtility.GetString(dataReader,DbConstants.USERS.PASSWORD, String.Empty);
            usersInfo.Roleid = SqlClientUtility.GetInt32(dataReader,DbConstants.USERS.ROLEID, 0);

            return usersInfo;
        }
Exemple #42
0
        /// <summary>
        /// 获得实体
        /// </summary>
        /// <param name="keyValue">编号</param>
        /// <returns>UsersInfo</returns>
        public UsersInfo Get(int keyValue)
        {
            UsersInfo model = null;
			using (DbCommand cmd = db.GetStoredProcCommand("SP_GetRecord"))
			{
				db.AddInParameter(cmd, "@TableName", DbType.String, "Users");
				db.AddInParameter(cmd, "@KeyName", DbType.String, "UserID");
				db.AddInParameter(cmd, "@KeyValue", DbType.Int32, keyValue);
				using (DataTable dt = db.ExecuteDataSet(cmd).Tables[0])
				{
					if (dt.Rows.Count > 0)
					{
						model = new UsersInfo();
						model.LoadFromDataRow(dt.Rows[0]);
					}
				}
				return model;
			}
        }