/// <summary> /// 生成内测用户 /// </summary> public static void generateCreateTestUserSQL(UserDao userDao) { Console.WriteLine("\n"); int num = 5; IList<User> userList = new List<User>(); for (long? i = 1L; i < num + 1; ++i) { User user = new User(); user.Id = i; user.Name = getUserName(i); user.OwnApps = "2"; user.RoleId = RoleEnum.NORMAL.Value; int random = RandomUtil.random(0, 10000); string password = "******" + random.ToString(); user.Password = SignUtils.createPassword(password); // token user.Token = SignUtils.createToken(user.Name); Console.WriteLine("/* userid" + user.Id + "\t" + password + "*/"); // userDao.create(user); userList.Add(user); } printUserList(userList); }
/// <param name="userName"> </param> /// <param name="password"> </param> public static void generateCreateSpecifyUserSQL(UserDao userDao, string userName, string password, RoleEnum roleEnum, string ownAppIds) { User user = new User(); user.Name = userName; user.Password = SignUtils.createPassword(password); // token user.Token = SignUtils.createToken(userName); // set appids user.OwnApps = ownAppIds; // role user.RoleId = roleEnum.Value; Console.WriteLine("/* " + userName + "\t" + password + "*/"); // userDao.create(user); IList<User> userList = new List<User>(); userList.Add(user); printUserList(userList); }
public LogonResultForm GetUserInfo(string userid) { var mapper = Common.GetMapperFromSession(); UserDao userdao = new UserDao(mapper); var user = userdao.Query(new UserQueryForm { Name = userid }).FirstOrDefault(); if (user == null) throw new Exception("用户:" + userid + "在系统中不存在!"); if (user.Enabled == 0) throw new Exception("该用户已被禁用,请联系管理员!"); LogonResultForm result = new LogonResultForm(); UserInfoDao userInfoDao = new UserInfoDao(mapper); RoleDao roleDao = new RoleDao(mapper); LogonHistoryDao historyDao = new LogonHistoryDao(mapper); string token = Guid.NewGuid().ToString().Replace("-", ""); var userinfo = userInfoDao.Query(new UserInfoQueryForm { ID = user.ID }).FirstOrDefault(); UserEntireInfo u = new UserEntireInfo { User = user }; if (userinfo != null) u.UserInfo = userinfo; u.Role = roleDao.QueryRoleByUserID(u.User.ID); CacheItem item = new CacheItem(token, u); LogonHistory history = new LogonHistory { LogonTime = DateTime.Now, Token = token, UserID = user.ID, ActiveTime = DateTime.Now, }; historyDao.Add(history); result.token = token; result.UserInfo = userinfo; cache.AddItem(item, 30 * 60); MenuBLL menubll = new MenuBLL(); result.Menu = menubll.GetCurrentUserMenu(result.token); return result; }
protected void Button4_Click(object sender, EventArgs e) { UserDao userDao = new UserDao(); int count = userDao.DeleteAll(); Response.Write(count); }
public LogonResultForm Logon(string username, string password) { var mapper = Common.GetMapperFromSession(); UserDao userdao = new UserDao(mapper); Model.User user = userdao.Query(new UserQueryForm { Name = username, Password = password }).FirstOrDefault(); if (user == null) throw new Exception("用户名或者密码错误!"); return GetUserInfo(user.Name); }
public void TestInitialize() { Intance = new UserDao() { Name = "Test" + DateTime.Now.Ticks, Password = "******" + DateTime.Now.Ticks, Active = true }; }
public ActionResult ArticleDetail(int id) { User user = new UserDao().GetByLogin(User.Identity.Name); ViewBag.User = user.Name; Article article = new ArticleDao().GetById(id); return View(article); }
public LoginResultForm Login(string username, string password) { LoginResultForm result = new LoginResultForm(); ISqlMapper mapper = MapperHelper.GetMapper(); UserDao userdao = new UserDao(mapper); UserInfoDao userInfoDao = new UserInfoDao(mapper); RoleDao roleDao = new RoleDao(mapper); User_RoleDao urdao = new User_RoleDao(mapper); LogonHistoryDao historyDao = new LogonHistoryDao(mapper); MenuDao menudao = new MenuDao(mapper); Menu_RoleDao mrdao = new Menu_RoleDao(mapper); var user = userdao.Query(new UserQueryForm { Name = username, Password = password }).FirstOrDefault(); if (user != null) { if (user.Enabled == 0) throw new Exception("该用户已被禁用,请联系管理员!"); string token = Guid.NewGuid().ToString().Replace("-", ""); var userinfo = userInfoDao.Query(new UserInfoQueryForm { ID = user.ID }).FirstOrDefault(); var ur = urdao.Query(new User_RoleQueryForm { UserID = user.ID }); List<string> roleidlist = new List<string>(); ur.ForEach(t => { roleidlist.Add(t.RoleID); }); var roles = roleDao.Query(new RoleQueryForm { IDs = roleidlist }); var mrs = mrdao.Query(new Menu_RoleQueryForm { RoleIDs = roleidlist }); var menuids = (from mr in mrs select mr.MenuID).Distinct().ToList(); result.Menu = menudao.Query(new MenuQueryForm { IDs = menuids, Enabled = 1 }); UserEntireInfo u = new UserEntireInfo { User = user, UserInfo = userinfo, Role = roles, }; CacheItem item = new CacheItem(token, u); LogonHistory history = new LogonHistory { LogonTime = DateTime.Now, Token = token, UserID = user.ID, ActiveTime = DateTime.Now, }; historyDao.Add(history); result.User = u; result.token = token; cache.AddItem(item, 1800); //MonitorCache.GetInstance().PushMessage(new CacheMessage { Message = "login user:"******",token:" + token }, SOAFramework.Library.CacheEnum.FormMonitor); return result; } else { throw new Exception("用户名或者密码错误!请输入正确的用户名和密码!"); } }
protected void Button1_Click(object sender, EventArgs e) { User u = new User(); u.Age = 24; u.ChineseName = "苏静"; u.UserName = "******"; //u.Email = "*****@*****.**"; UserDao userDao = new UserDao(); userDao.Insert(u); }
protected void Button2_Click(object sender, EventArgs e) { User u = new User(); //u.Id = 6; u.Age = 24; u.ChineseName = "苏静sullivan"; u.UserName = "******"; u.Email = "[email protected] "; UserDao userDao = new UserDao(); userDao.Update(u); }
protected void BtnRegister_Click(object sender, EventArgs e) { if (Page.IsValid) { // TODO: Validate passed & put the register logic here UserDao dao = new UserDao(); User user = new User(); user.Username = TxbUsername.Text; user.Password = TxbPassword.Text; user.Age = Convert.ToInt32(TxbAge.Text); user.AttendanceDate = TxbAttendDate.Text; user.Email = TxbMail.Text; if (OptSexF.Checked) user.Sex = OptSexF.Text; else if (OptSexM.Checked) user.Sex = OptSexM.Text; string interest = ""; foreach (ListItem item in ChkList.Items) { if (item.Selected) interest += item.Value + ","; } user.Interest = interest; string subscribeList = ""; foreach (ListItem item in LsbSubscibe.Items) { if (item.Selected) subscribeList += item.Value + ","; } user.Subscribe = subscribeList; foreach (ListItem item in DroplistGrade.Items) { if (item.Selected) user.Grade = item.Value; } if (dao.CreateUser(user)) { RegDiv.Style.Add("display","none"); LblResult.Text = "<b>Username:</b> " + user.Username +"<br />"+ "<b>Age:</b> " + user.Age +"<br />"+ "<b>Attendance date:</b> " + user.AttendanceDate +"<br />"+ "<b>Email:</b> " + user.Email + "<br />" + "<b>sex:</b> " + user.Sex +"<br />"+ "<b>Interest:</b> " + user.Interest +"<br />"+ "<b>Subscribe:</b> " + user.Subscribe +"<br />"+ "<b>Grade:</b> " + user.Grade; } } }
protected void Button3_Click(object sender, EventArgs e) { UserDao userDao = new UserDao(); Hashtable ht = new Hashtable(); ht.Add("Id*", new List<int>(){1,2,3}); //ht.Add("%UserName%", "sullivan"); int count = userDao.Delete(ht); Response.Write(count); }
public override string[] GetRolesForUser( string username ) { UserDao userDao = new UserDao(); User user = userDao.GetByLogin(username); if (username == null) { return new string[]{}; } return new string[] {user.Role.Name}; }
protected void Button7_Click(object sender, EventArgs e) { UserDao userDao = new UserDao(); NameValueCollection name = new NameValueCollection(); name.Add("Age","ASC"); name.Add("Id", "DESC"); Hashtable ht = new Hashtable(); ht.Add("Age>",12); IList<User> list = userDao.SelectList(ht, name); Response.Write(list.Count); }
public JArray processer(string jsonStr) { String userID = null; String userPwd = null; JArray jsa = JArray.Parse(jsonStr); JObject json = JObject.Parse(jsa[0].ToString()); userID = json["userID"].ToString(); userPwd = json["userPwd"].ToString(); UserDao ud = new UserDao(); UserModel userModel = ud.login(userID, userPwd); JArray jsonArray = new JArray(); JObject jsonObject = new JObject(); if (userModel == null) { userModel = new UserModel("_", "_","_", "_", "_", "_"); jsonObject = new UserRowMapper().mappingRow(userModel); jsonObject.Add("isok", "密码错误或用户名不存在"); } else { if (new CreateTableDao().create(userID)) { jsonObject = new UserRowMapper().mappingRow(userModel); jsonObject.Add("isok", "true"); } else { userModel = new UserModel("_","_", "_", "_", "_", "_"); jsonObject = new UserRowMapper().mappingRow(userModel); jsonObject.Add("isok", "您的数据没有初始化,请首先在电脑端登陆一次.");// 没有初始化表 } } jsonArray.Add(jsonObject); return jsonArray; }
// GET: Blog public ActionResult Index(int? page) { int itemOnPage = 10; int pg = page ?? 1; int totalArticle; User user = new UserDao().GetByLogin(User.Identity.Name); ViewBag.User = user.Name; IList<Article> articles = new ArticleDao().GetArticlePage(itemOnPage, pg, out totalArticle); ViewBag.Pages = (int) Math.Ceiling((double)totalArticle/(double)itemOnPage); ViewBag.CurrentPage = pg; ViewBag.Category = new ArticleCategoryDao().GetAll(); return View(articles); }
public string Logon(string username, string password) { UserDao dao = new UserDao(); var users = dao.Query(new UserQueryForm { Name = username, Password = password }); if (users.Count > 0) { string token = Guid.NewGuid().ToString().Replace("-", ""); CacheItem item = new CacheItem(token, users[0]); cache.AddItem(item, 30 * 60); return token; } else { return null; } }
public bool ChangeSelfPassword(string oldpassword, string password) { ISqlMapper mapper = MapperHelper.GetMapper(); UserDao dao = new UserDao(mapper); var user = GetUserFormCache(); var u = dao.Query(new UserQueryForm { ID = user.User.ID, Password = oldpassword }).FirstOrDefault(); if (u == null) { throw new Exception(string.Format("旧密码错误!")); } dao.Update(new UserUpdateForm { Entity = new User { Password = password }, UserQueryForm = new UserQueryForm { ID = user.User.ID } }); return true; }
protected void BtnSigin_Click(object sender, EventArgs e) { if (Page.IsValid) { string username = InputUsername.Text; string password = InputPassword.Text; UserDao dao = new UserDao(); if (dao.login(username, password)) { LblResult.Text = "Login success!"; FormsAuthentication.RedirectFromLoginPage(username, false); } else { LblResult.Text = "Login failed!"; } } }
protected void btnLogon_Click(object sender, EventArgs e) { string userName = txtUserName.Text; string password = txtPassword.Text; if (userName == ConfigurationManager.AppSettings["ADMIN"] && password == ConfigurationManager.AppSettings["PASSWORD"]) { admin = true; } else { UserDao dao = new UserDao(); current = dao.loginUser(userName, password); } if ((current != null) || (admin == true)) { if (admin) { Response.Cookies["Username"].Value = "Admin"; Response.Cookies["Admin"].Value = "True"; } else { string name = current.getUsername(); Response.Cookies["Username"].Value = current.getUsername(); Response.Cookies["Admin"].Value = "False"; } //HttpCookie myCookies = Request.Cookies["myKeyie"]; //myCookies["Username"] = "******";// current.getUsername(); Debug.WriteLine("Logged IN Correctly!!!"); Response.Redirect("default.aspx"); } else { lblErro.Visible = true; lblErro.Text = "Password and User Name combination are not valid."; } }
/// <param name="args"> </param> public static void Main(string[] args) { ClassPathXmlApplicationContext ctx = new ClassPathXmlApplicationContext(); ctx.Environment.ActiveProfiles = "production"; ctx.ConfigLocation = "applicationContext.xml"; ctx.refresh(); userDao = (UserDao) ctx.getBean("userDaoImpl"); /// <summary> /// 生成测试用户 SQL /// </summary> UserCreateCommon.generateCreateTestUserSQL(userDao); /// <summary> /// 生成指定用户 SQL /// </summary> UserCreateCommon.generateCreateSpecifyUserSQL(userDao, "msoa", "msoaSH", RoleEnum.ADMIN, ""); Environment.Exit(1); }
public string Add(User user, UserInfo ui, List<Role> roles) { ISqlMapper mapper = MapperHelper.GetMapper(); UserDao dao = new UserDao(mapper); UserInfoDao uidao = new UserInfoDao(mapper); User_RoleDao urdao = new User_RoleDao(mapper); string id = dao.Add(user); if (ui != null) { ui.ID = id; uidao.Add(ui); } if (roles != null) { foreach (var role in roles) { urdao.Add(new User_Role { UserID = id, RoleID = role.ID }); } } return id; }
public bool ChangePassword(string username, string newpassword) { ISqlMapper mapper = MapperHelper.GetMapper(); UserDao dao = new UserDao(mapper); var user = dao.Query(new UserQueryForm { Name = username }).FirstOrDefault(); if (user == null) { throw new Exception(string.Format("用户名:{0}不存在!", username)); } if (user.Enabled == 0) { throw new Exception(string.Format("用户名:{0}已被禁用!", username)); } dao.Update(new UserUpdateForm { Entity = new User { Password = newpassword }, UserQueryForm = new UserQueryForm { ID = user.ID } }); return true; }
public List<FullUser> SimpleQuery(FullUserQueryForm form) { ISqlMapper mapper = MapperHelper.GetMapper(); UserDao dao = new UserDao(mapper); return dao.QueryFullUser(form); }
public UserService() { this._Userdao = new UserDao(); base.BaseCrudDao = this._Userdao; }
public string GetMenuItems(string userId) { return(UserDao.GetMenuItems(userId)); }
public UserRoleService() { RoleDao = new RoleDao(context); UserDao = new UserDao(context); }
public string GetDryStockMenuXml(string userId) { return(UserDao.GetDryStockMenuXml(userId)); }
public IEnumerable <User> Search(User user) { return(UserDao.Search(user)); }
public void Activate(string users) { UserDao.Activate(users); }
public UserService(UserDao userDao) { dao = userDao; }
// thông tin tài khoản public ActionResult Detail(long id) { var acc = new UserDao().ViewDetail(id); return(View(acc)); }
public void Deactivate(string users) { UserDao.Deactivate(users); }
public ActionResult Edit(int id) { var user = new UserDao().ViewDetail(id); return(View(user)); }
public UserService() { this.subjectDao = new UserDao(); }
public AssignmentPage() { dao = new UserDao(); Title = "Assignment"; NavigationPage.SetHasNavigationBar(this, false); }
public bool Update(User user, UserInfo ui, List<Role> roles) { ISqlMapper mapper = MapperHelper.GetMapper(); UserDao dao = new UserDao(mapper); UserInfoDao uidao = new UserInfoDao(mapper); User_RoleDao urdao = new User_RoleDao(mapper); var updateuser = GetUserFormCache(); dao.Update(new UserUpdateForm { Entity = new User { Enabled = user.Enabled, LastUpdateTime = DateTime.Now, LastUpdator = updateuser?.User.ID, }, UserQueryForm = new UserQueryForm { ID = user.ID } }); if (ui != null) { if (uidao.Query(new UserInfoQueryForm { ID = user.ID }).FirstOrDefault() == null) { ui.ID = user.ID; uidao.Add(ui); } else { uidao.Update(new UserInfoUpdateForm { Entity = ui, UserInfoQueryForm = new UserInfoQueryForm { ID = user.ID } }); } } urdao.Delete(new User_RoleQueryForm { UserID = user.ID }); if (roles != null) { foreach (var role in roles) { urdao.Add(new User_Role { UserID = user.ID, RoleID = role.ID }); } } return true; }
public GameService() { Users = new UserDao(); GameState = GameState.Preparing; Grid = new Cell[3, 3]; }
public ActionResult Update(long id) { var user = new UserDao().ViewDetail(id); return(View(user)); }
public IEnumerable <DealerAccountInfo> GetDealerAccountInfo(string userName) { return(UserDao.GetDealerAccountInfo(userName)); }
public JsonResult ChangeStatus(long id) { var result = new UserDao().ChangeStatus(id); return(Json(new { status = result })); }
public LoginService(DBContext context) { userDao = new UserDao(context); }
public DataSet GetMenuItems(string userId, string bla) { return(UserDao.GetMenuItems(userId, bla)); }
/// <summary> /// Menu rubrika /// </summary> /// <param name="id"></param> /// <returns>clanky</returns> public ActionResult Rubrika(int? id) { User user = new UserDao().GetByLogin(User.Identity.Name); ViewBag.User = user.Name; int i = id ?? 0; if ( i == 0 ) { return RedirectToAction("Index"); } else { IList<Article> article = new ArticleDao().GetArticleInCategoryId(i); ViewBag.Categoties = new ArticleCategoryDao().GetAll(); /* * predani identifikacniho cisla htmlHelpers pro porovnani */ HtmlHelpersExtension.Id = id.ToString(); return View("Index", article); } }
public BaseController() { _userDao = new UserDao(); }
public StatisticService() { userdao = new UserDao(); }
public ActionResult Create(User user, HttpPostedFileBase postedFile) { if (((User)Session[Constants.USER_INFO]).GroupID == Constants.GROUP_ADMIM) { if (ModelState.IsValid) { if (new UserDao().CheckByUsername(user.UserName) == false) { string path; string filename = ""; string fullfilename = ""; var userinfo = (User)Session[Constants.USER_INFO]; if (postedFile == null) { fullfilename = "computer-icons-user-profile-login-my-account-icon-png-clip-art.png"; path = Path.Combine(Server.MapPath("~/Data/ImgAdmin"), fullfilename); //postedFile.SaveAs(path); } else { //Luu ten fie, luu y bo sung thu vien using System.IO; filename = Path.GetFileName(postedFile.FileName); fullfilename = filename.Split('.')[0] + "(" + DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Millisecond.ToString() + ")." + filename.Split('.')[1]; //Luu duong dan cua file path = Path.Combine(Server.MapPath("~/Data/ImgAdmin"), fullfilename); postedFile.SaveAs(path); } if (string.IsNullOrEmpty(user.Password)) { user.Password = Encryptor.MD5Hash("12345"); } else { user.Password = Encryptor.MD5Hash(user.Password); } user.ImagePath = fullfilename; user.Status = true; user.CreatedBy = userinfo.UserName; //user.CreatedBy = Session[Constants.USER_USERNAME].ToString(); long id = new UserDao().Insert(user); if (id > 0) { SetAlert("Tạo User thành công", Constants.ALERTTYPE_SUCCESS); new LogDao().SetLog("Admin_User_Create", "Tạo User thành công", ((User)Session[Constants.USER_INFO]).ID); return(RedirectToAction("Index", "User")); } else { SetAlert("Tạo User không thành công", Constants.ALERTTYPE_ERROR); new LogDao().SetLog("Admin_User_Create", "Tạo User không thành công", ((User)Session[Constants.USER_INFO]).ID); return(RedirectToAction("Index", "User")); } } else { ModelState.AddModelError("", "Username đã tồn tại"); new LogDao().SetLog("Admin_User_Create", "Username đã tồn tại", ((User)Session[Constants.USER_INFO]).ID); return(View("Create", user)); } } else { ModelState.AddModelError("", "Dữ liệu không hợp lệ"); new LogDao().SetLog("Admin_User_Create", "Dữ liệu không hợp lệ", ((User)Session[Constants.USER_INFO]).ID); return(View("Create", user)); } } SetAlert("Tài khoản của bạn không có quyền", Constants.ALERTTYPE_ERROR); new LogDao().SetLog("Admin_User_Create", "Tài khoản của bạn không có quyền", ((User)Session[Constants.USER_INFO]).ID); return(RedirectToAction("Index", "Home")); }
public override bool IsUserInRole( string username, string roleName ) { UserDao userDao= new UserDao(); User user = userDao.GetByLogin( username ); if (user == null) { return false; } return user.Role.Name == roleName; }
public ActionResult UserProfile(int id) { var data = new UserDao().GetUserProfile(id); return(View(data)); }
public override bool ValidateUser(string username, string password) { UserDao userDao = new UserDao(); User user = userDao.GetByLoginAndPasswordUser(username, password); return user != null; }
public void Delete(string users) { UserDao.Delete(users); }
public DataRow UpdatePassword(User user) { DataRow dataRow = UserDao.UpdatePassword(user); return(dataRow); }
public IHttpActionResult UpdateById(int id, UserDto userDto) { UserDao userExists = userManagement.GetById(id); if (userExists == null) { return(NotFound()); } // validation if (userDto.FirstName == null || userDto.FirstName == "" || userDto.LastName == null || userDto.LastName == "" || userDto.DateOfBirth == null || userDto.Gender == null || userDto.Gender == "" || userDto.PhoneNumber == null || userDto.PhoneNumber == "" || userDto.Address == null || userDto.Address == "" || userDto.City == null || userDto.City == "" || userDto.Country == null || userDto.Country == "") { return(BadRequest("Insufficient input")); } //Validate phone number should be greater than 0 and in the given format Regex isValidPhoneNumber = new Regex(@"\s*(?:\+?(\d{1,3}))?([-. (]*(\d{3})[-. )]*)?((\d{3})[-. ]*(\d{2,4})(?:[-.x ]*(\d+))?)\s*"); var hasMinimumDigits = new Regex(@".{10,15}"); if (!isValidPhoneNumber.IsMatch(userDto.PhoneNumber) || !hasMinimumDigits.IsMatch(userDto.PhoneNumber)) { return(BadRequest("Invalid Phone Number")); } //Validate post code it should be greater than 0 if (userDto.PostCode <= 0) { return(BadRequest("Post Code must be greater than 0")); } //Validate DateOfBirth should not be greater than today int value = DateTime.Compare(userDto.DateOfBirth, DateTime.Now); // Return statement is 0 if dates are equal, less than 0 if DateOfBirth is earlier than today and greater than 0 if DateOfBirth is later than today if (value > 0) { return(BadRequest("Date of birth should not be greater than today")); } UserDao userDao = userManagement.UpdateById(id, userDto.Email, userDto.Password, userDto.FirstName, userDto.LastName, userDto.DateOfBirth, userDto.Gender, userDto.PhoneNumber, userDto.Address, userDto.PostCode, userDto.City, userDto.Country, userDto.MembershipId, userDto.Subscription, userDto.InterestedIn, userDto.RoleName); if (userDao == null) { return(Content((HttpStatusCode)304, "Not Modified")); } UserDto user = new UserDto(userDao.Id, userDao.Email, userDao.FirstName, userDao.LastName, userDao.DateOfBirth, userDao.Gender, userDao.PhoneNumber, userDao.Address, userDao.PostCode, userDao.City, userDao.Country, userDao.MembershipId, userDao.Subscription, userDao.InterestedIn, userDao.RoleName); return(Ok(user)); }
// GET: User/User public new ActionResult Profile(int id) { var model = new UserDao().GetById(id); return(View(model)); }
public User Read(string id) { return(UserDao.Read(id)); }