/// <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 ? "管理员" : "用户"; } }
//个人中心视图 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)); }
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)); } }
/// <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(); } } } }
/// <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); }
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(); }
/// <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(); } } } }
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)); } }
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()); }
/// <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); }
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); }
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); }
/// <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); }
protected override void OnNavigatedTo(NavigationEventArgs e) { if (e.Parameter is UsersInfo) { user = ((UsersInfo)e.Parameter); } }
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"); } } }
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; })); } }
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; } }
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 } }
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); }
/// <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; }
/// <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; } }