protected Users ConvertToPureModel(UsersDTO dto) { var pureModel = _mapper.Map <UsersDTO, Users>(dto); pureModel.RoleNo = dto.RoleName.RoleNameToRoleNo(); return(pureModel); }
protected void Application_AuthenticateRequest() { //Check if user is logged in if (User == null) { return; } //Get username string username = Context.User.Identity.Name; //declare array of roles string[] roles = null; using (db DB = new db()) { //Populate roles UsersDTO dto = DB.Users.FirstOrDefault(x => x.UserName == username); roles = DB.UserRoles.Where(x => x.UserId == dto.Id).Select(x => x.Role.Name).ToArray(); } //Build IPrincipal object IIdentity userIdentity = new GenericIdentity(username); IPrincipal newUserObj = new GenericPrincipal(userIdentity, roles); //Update context.user Context.User = newUserObj; }
protected void Application_AuthenticateRequest() { if (User == null) { return; } string login = Context.User.Identity.Name; string[] roles = null; using (ChekitDB chekitDB = new ChekitDB()) { UsersDTO usersDTO = chekitDB.Users.FirstOrDefault(x => x.Login == login); if (usersDTO == null) { return; } roles = chekitDB.UserRoles.Where(x => x.UserId == usersDTO.UserId).Select(x => x.RoleUser.RoleName).ToArray(); } IIdentity userIdentity = new GenericIdentity(login); IPrincipal newUserObject = new GenericPrincipal(userIdentity, roles); Context.User = newUserObject; }
public async Task <UsersDTO> Autheticate(string username, string password) { var user = await _repository.GetByUserNameAsync(username); if (user != null) { // check password if (GenerateSaltedPassword(password, user.Salt).Item1.Equals(user.Password)) { UsersDTO dto = _mapper.Map <Users, UsersDTO>(user); dto.RoleNo = (ERole)user.RoleNo; dto.RoleName = dto.RoleNo.RoleNoToRoleName(); var tokenHandler = new JwtSecurityTokenHandler(); var key = Encoding.ASCII.GetBytes("adsdfhjfjhdfgkjldfgdsdflksdjglkfdjgdfiojga;sldjapdjfsdsfjfgpdgjpgre"); var tokenDescriptor = new SecurityTokenDescriptor { Subject = new ClaimsIdentity(new Claim[] { new Claim(ClaimTypes.Name, user.Id.ToString()), new Claim(ClaimTypes.Role, dto.RoleName) }), Expires = DateTime.UtcNow.AddDays(7), SigningCredentials = new SigningCredentials(new SymmetricSecurityKey(key), SecurityAlgorithms.HmacSha256Signature) }; var token = tokenHandler.CreateToken(tokenDescriptor); dto.Token = tokenHandler.WriteToken(token); return(dto); } } return(null); }
public bool XoaUsers(string Username) { UsersDTO users = new UsersDTO(); users.Username = Username; return(UsersDAO.Instance.XoaUsers(users)); }
public string RegisterUser(UsersDTO user) { using (var uow = new UnitOfWork()) { return("ss"); } }
public static UsersDTO Post(UsersDTO user) { using (SqlConnection connection = DataBase.GetConnection()) { connection.Open(); SqlCommand command = connection.CreateCommand(); command.CommandText = REQ_POST; command.Parameters.AddWithValue($@"{FIELD_FIRSTNAME}", user.FirstName); command.Parameters.AddWithValue($@"{FIELD_LASTNAME}", user.LastName); command.Parameters.AddWithValue($@"{FIELD_PSEUDO}", user.Pseudo); command.Parameters.AddWithValue($@"{FIELD_MAIL}", user.Mail); command.Parameters.AddWithValue($@"{FIELD_USERTYPE}", user.UserType); command.Parameters.AddWithValue($@"{FIELD_PASSWORD}", user.Password); try { user.IdUser = (int)command.ExecuteScalar(); } catch (Exception e) { Console.WriteLine(e); return(null); } } return(user); }
/// <summary> /// Список пользователей /// </summary> /// <param name=""></param> public IEnumerable <UsersDTO> GetUsers() { try { List <UsersDTO> Users = new List <UsersDTO>(); var UsersDAL = Data.GetUsers(); foreach (var u in UsersDAL) { UsersDTO user = new UsersDTO(); user.UserID = u.UserID; user.Login = u.Login; user.Name = u.Name; user.RegistrationDate = u.RegistrationDate; user.TypeID = u.TypeID; user.UserType = u.UserType; user.Avatar = u.Avatar; Users.Add(user); } return(Users); } catch (ArgumentException ex) { throw new ValidationException(ex.Message, ex.ParamName); } }
public static UsersDTO GetUserByPseudo(string pseudo) { UsersDTO user = new UsersDTO(); using (SqlConnection connection = DataBase.GetConnection()) { connection.Open(); SqlCommand command = connection.CreateCommand(); command.CommandText = REQ_QUERY_BY_PSEUDO; command.Parameters.AddWithValue($@"{FIELD_PSEUDO}", pseudo); Console.WriteLine(command.CommandText); try { if (connection.State == ConnectionState.Broken) { return(null); } SqlDataReader reader = command.ExecuteReader(); if (reader.Read()) { user = new UsersDTO(reader); } } catch (Exception e) { Console.WriteLine(e); } } return(user); }
public static UsersDTO GetUserByMail(string mail) { UsersDTO user = new UsersDTO(); using (SqlConnection connection = DataBase.GetConnection()) { connection.Open(); SqlCommand command = connection.CreateCommand(); command.CommandText = REQ_QUERY_BY_MAIL; command.Parameters.AddWithValue($@"{FIELD_MAIL}", mail); try { SqlDataReader reader = command.ExecuteReader(); if (reader.Read()) { user = new UsersDTO(reader); } } catch (Exception e) { Console.WriteLine(e); } } return(user); }
//TODO BK check EmailAddress public async Task <IActionResult> PutUsers(long id, UsersDTO usersDTO) { if (id != usersDTO.Id) { return(BadRequest()); } Users users = usersDTO.FromDTO(); _context.Entry(users).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!UsersExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
private void btnDangNhap_Click(object sender, EventArgs e) { try { UsersDTO User = new UsersDTO(); User.User_kyDanh = tbKyDanh.Text; User.User_matKhau = tbMatKhau.Text; QuanLyUserBUS bus = new QuanLyUserBUS(); int check = bus.FindOneUser(User); if (check == 1) { //Dang nhap thanh cong MessageBox.Show("Đăng nhập thành công", "Thông báo"); } else { //Dang nhap that bai MessageBox.Show("Ký danh hoặc mật khẩu không đúng!", "Thông báo"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public async Task <ActionResult <UsersDTO> > DeleteUser(int id) { var users = await db.Users.FindAsync(id); if (users == null) { return(new JsonResult(new { Status = "error", Message = "No user found with the id: " + id })); } users.isDelted = true; db.Users.Update(users); await db.SaveChangesAsync(); UsersDTO userDTO = new UsersDTO { Id = users.Id, username = users.username, email = users.email, first_name = users.first_name, last_name = users.last_name, contact_number = users.contact_number, created_at = users.created_at, updated_at = users.updated_at, isAdmin = users.isAdmin, isActive = users.isActive, isDeleted = users.isDelted }; return(userDTO); }
private void btnXoa_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtMaUS.Text)) { return; } if (MessageBox.Show("Bạn muốn xóa users?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { UsersDTO us = new UsersDTO(); us.MaUS = txtMaUS.Text; us.TaiKhoan = txtTaiKhoan.Text; us.MatKhau = txtMatKhau.Text; us.MaNV = cboMaNV.Text; us.MaQH = cboMaQuyenHan.Text; bool kq = usBUS.xoa(us); if (kq == false) { MessageBox.Show("Xóa thông tin users thất bại."); } else { MessageBox.Show("Xóa thông tin users thành công"); dataGridViewNguoiDung.DataSource = usBUS.loadDuLieuUsers();//load lại dữ liệu cho datagridview empty(); } KhoaButton(); } }
public ActionResult Post([FromBody] UsersDTO obj) { try { var mapp = AutoMapp <UsersDTO, Users> .Convert(obj); if (obj.Id > 0) { if (!string.IsNullOrEmpty(obj.Password)) { mapp.Password = Encrypt.GenSHA256(obj.Password); } else { mapp.Password = UsersData.GetById(obj.Id).Password; } var ListRta = this.UsersData.Update(mapp, obj.Id); } else { mapp.Password = Encrypt.GenSHA256(obj.Password); var ListRta = this.UsersData.Add(mapp); } obj.Id = mapp.Id; return(Ok(ResultData <UsersDTO> .Sucess(obj, "Usuario Guardado de manera exitosa"))); } catch (Exception ex) { return(BadRequest(ResultData <UsersDTO> .Issue(null, "Opps ha ocurrido un error", ex))); } }
/// <summary> /// Изменить данные пользователя, для администратора /// </summary> /// <param name="user"></param> public bool ChangeUserType(UsersDTO user) { try { Users userDAL = new Users(); userDAL.UserID = user.UserID; userDAL.Login = user.Login; userDAL.Password = user.Password; userDAL.Name = user.Name; userDAL.RegistrationDate = user.RegistrationDate; userDAL.TypeID = user.TypeID; userDAL.Avatar = user.Avatar; if (Data.ChangeUserType(userDAL) == true) { return(true); } else { throw new ValidationException("Ваш запрос не был обработан", ""); } } catch (ArgumentException ex) { throw new ValidationException(ex.Message, ex.ParamName); } }
public ActionResult Edit([FromBody] UsersDTO obj) { try { var mapp = AutoMapp <UsersDTO, Users> .Convert(obj); if (mapp.Id > 0) { if (!string.IsNullOrEmpty(obj.Password)) { mapp.Password = Encrypt.GenSHA256(obj.Password); } else { mapp.Password = this._ctx.Users.AsNoTracking().Where(c => c.Id == obj.Id).FirstOrDefault().Password; } var ListRta = this.UsersData.Update(mapp, obj.Id); return(Ok(ResultData <UsersDTO> .Sucess(obj, "Usuario Guardado de manera exitosa"))); } return(NotFound("No se encontraron datos con la información enviada")); } catch (Exception ex) { return(BadRequest(ResultData <UsersDTO> .Issue(null, "Opps ha ocurrido un error", ex))); } }
// PUT: api/Users/5 public IHttpActionResult PutUsers(Guid id, UsersDTO usersDTO) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != usersDTO.Id) { return(BadRequest()); } var users = DTOMapper.mapper.Map <UsersDTO, Users>(usersDTO); db.Entry(users).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!UsersExists(id)) { return(NotFound()); } else { throw; } } return(Ok(usersDTO)); }
private void fUser_Load(object sender, EventArgs e) { DataTable dt = user.showUser(); List <UsersDTO> listUser = new List <UsersDTO>(); foreach (DataRow row in dt.Rows) { UsersDTO user = new UsersDTO(); user.ID = int.Parse(row["id"].ToString()); user.UserName = row["username"].ToString(); user.Password = row["password"].ToString(); user.FullName = row["fullname"].ToString(); //Boolean genderNumber = Boolean.Parse((row["gender"].ToString())); //user.Gender = genderNumber == true ? "Nam" : "Nữ"; Console.WriteLine(row["gender"].ToString()); user.Phone = row["phone"].ToString(); user.Address = row["address"].ToString(); user.Email = row["email"].ToString(); user.Avatar = row["avatar"].ToString(); //user.Roles = int.Parse(row["roles"].ToString()) == 1 ? "Admin" : "Nhân viên"; //user.Created_at = DateTime.Parse(row["created_at"].ToString()); user.Updated_at = DateTime.Now; listUser.Add(user); } dgvUser.DataSource = listUser; commomMethodFn.changeColordgv(dgvUser); if (dgvUser.Rows.Count > 0) { btnDeleteUser.Enabled = true; btnEditUser.Enabled = true; } }
public HttpResponseMessage GetUserById(int id) { try { Users user = this._userManagement.GetUserById(id); if (user != null) { UsersDTO dto = new UsersDTO { UserId = user.UserId, AccessStatus = user.AccessStatus, Email = user.Email, FirstName = user.FirstName, LastName = user.LastName, MiddleName = user.MiddleName, StudentIdentificationNumber = user.StudentIdentificationNumber, UserName = user.UserName }; return(Request.CreateResponse <UsersDTO>(HttpStatusCode.OK, dto)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Resource Not Found")); } } catch (Exception) { // Log exception code goes here return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Error occured while executing method.")); } }
public UsersVM(UsersDTO row) { Id = row.Id; UserName = row.UserName; Email = row.Email; Password = row.Password; }
public static UsersDTO Login(string email, string password) { ConnectionDatabase.getConnection(); string query = "select * from users where email = @email and password = @password"; SqlCommand cmd = new SqlCommand(query, ConnectionDatabase.conn); cmd.Parameters.AddWithValue("@email", email); cmd.Parameters.AddWithValue("@password", password); IDataReader reader = cmd.ExecuteReader(); UsersDTO user = null; while (reader.Read()) { int userId = Convert.ToInt32(reader["id"]); string userName = reader["name"].ToString(); string userEmail = reader["email"].ToString(); string userRole = reader["role"].ToString(); user = new UsersDTO { ID = userId, Name = userName, Email = userEmail, Role = userRole }; } ConnectionDatabase.closeConnection(); return(user); }
/// <summary> /// Регистрация /// </summary> /// <param name="user"></param> public bool Registration(UsersDTO user) { try { Users UserDAL = new Users(); UserDAL.Name = user.Name; UserDAL.Login = user.Login; UserDAL.Password = user.Password; UserDAL.RegistrationDate = DateTime.Now; UserDAL.Avatar = user.Avatar; if (Data.Registration(UserDAL) == true) { return(true); } else { throw new ValidationException("Ваш запрос не был обработан", ""); } } catch (ArgumentException ex) { throw new ValidationException(ex.Message, ex.ParamName); } }
public void UserControl() { try { UsersDTO temp = new UsersDTO(); temp = userService.Search(CurrentUser.UserName); if (temp.Id != 0) { if ((temp.UserName).Equals(CurrentUser.UserName) && (temp.Password).Equals(CurrentUser.Password)) { passView.passToMainWindowFromLoginWindow(temp); } } else { Message = "Login Operation Failed"; } } catch (Exception) { Message = "Login Operation Failed"; } }
public ActionResult ChangeUserType(UsersViewModel user) { try { ModelState.Remove("ConfirmPassword"); if ((ModelState.IsValid)) { UsersDTO UserBLL = new UsersDTO(); UserBLL.Name = user.Name; UserBLL.Login = user.Login; UserBLL.Password = user.Password; UserBLL.UserID = user.UserID; UserBLL.TypeID = user.TypeID; UserBLL.Avatar = user.Avatar; UserBLL.RegistrationDate = user.RegistrationDate; Data.ChangeUserType(UserBLL); return(RedirectToAction("UsersList", "Home")); } else { return(View(user)); } } catch (ValidationException ex) { ModelState.AddModelError("DalError", ex.Message); return(View(user)); } }
public IActionResult DeleteUser([FromBody] UsersDTO request) { var response = new OperationResponse <ICollection>(); try { var result = _userService.DeleteUser(request.Tasks); if (result.Any(fn => !string.IsNullOrEmpty(fn.Message))) { response.State = ResponseState.ValidationError; response.Data = result.ToList(); return(new JsonResult(response)); } else { response.State = ResponseState.Success; } } catch (Exception exception) { response.State = ResponseState.Error; response.Messages.Add(exception.Message); //_logger.LogError(exception, "Error in Delete Bts Pack ==>" + exception.StackTrace, BtsPackId); } return(new JsonResult(response)); }
public static User ToUser(this UsersDTO input) { if (input == null) { return(null); } return(new User() { Email = input.Email, UserId = input.UserId, RankId = input.RankId, FullNameAr = input.FullNameAr, FullNameEn = input.FullNameEn, UserName = input.UserName, Password = input.Password, IsActive = input.IsActive, IsOwner = input.IsOwner, PhoneNumber = input.PhoneNumber, RoleId = input.RoleId, UserRole = input.Role.ToUserRoles(), EncPassword = input.EncPassword, Salt = input.Salt }); }
public ActionResult Registration(UsersViewModel user) { try { if ((ModelState.IsValid) && (user.Password == user.ConfirmPassword)) { UsersDTO UserBLL = new UsersDTO(); UserBLL.Name = user.Name; UserBLL.Login = user.Login; UserBLL.Password = user.Password; UserBLL.Avatar = user.Avatar; Data.Registration(UserBLL); return(RedirectToAction("Index")); } if (user.Password != user.ConfirmPassword) { ModelState.AddModelError("WrongConfirmPassword", "Пароли на совпадают."); return(View(user)); } else { return(View(user)); } } catch (ValidationException ex) { ModelState.AddModelError("DalError", ex.Message); return(View(user)); } }
public ActionResult <UsersDTO> GetAllUsers() { // this.Logger.LogInformation("Action `GetAllUsers` starting"); var users = this.Database.Users .Select(x => new { x.Id, x.FirstName, x.LastName }) .ToList(); var rv = new UsersDTO(); rv.UserList = new List <UserDTO>(); foreach (var user in users) { rv.UserList.Add( new UserDTO { Id = user.Id, FirstName = user.FirstName, LastName = user.LastName, HeightLogEntries = $"{this.Request.Scheme}:{this.Request.Host}/api/users/{user.Id}/heightlogentries", WeightLogEntries = $"{this.Request.Scheme}:{this.Request.Host}/api/users/{user.Id}/weightlogentries", FoodLogEntries = $"{this.Request.Scheme}:{this.Request.Host}/api/users/{user.Id}/foodlogentries", ExerciseLogEntries = $"{this.Request.Scheme}:{this.Request.Host}/api/users/{user.Id}/exerciselogentries" }); } // this.Logger.LogInformation("Action `GetAllUsers` ending"); return(rv); }
protected void Page_Load(object sender, EventArgs e) { if (Session["name"] == null) { Response.Redirect("/login"); } if (Session["role"] != null && !Session["role"].Equals(Role.Admin)) { Response.Redirect("/login"); } int userId = Convert.ToInt32(Request.QueryString["id"]); UsersDTO user = UsersBLL.getUserById(userId); if (user == null) { Response.Redirect("/users"); } lbEmail.Text = user.Email; lbName.Text = user.Name; lbRole.Text = user.Role; TasksBLL.expiringTask(); }
public UsersS UsersGrid() { UsersS userse = new UsersS(); string connectionString = UtilSh.strCnn; //System.Configuration.ConfigurationManager.ConnectionStrings["cnnSql2"].ToString(); using (SqlConnection connection = new SqlConnection(connectionString)) { using (SqlCommand command = new SqlCommand()) { command.Connection = connection; command.CommandText = "Exec dbo.UsersGrid"; command.CommandType = CommandType.Text; connection.Open(); using (SqlDataReader dataReader = command.ExecuteReader()) { UsersDTO user; while (dataReader.Read()) { user = new UsersDTO();//Creación de un nuevo objeto del tipo de nuestro DTO en donde cargaremos toda la información proveniente de nuestro comando de DB, discriminando cada elemento con 'request' user.ID = Convert.ToInt32(dataReader["ID"]); user.CemexID = Convert.ToString(dataReader["CemexID"]); user.NUsuario = Convert.ToString(dataReader["NUsuario"]); user.Email = Convert.ToString(dataReader["Email"]); user.Rol = Convert.ToString(dataReader["Rol"]); userse.Add(user); } } //Convert.ToInt32(paramTotalRecords.Value); } } return userse; }