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;
}
