public async Task <ActionResultDto> Execute(ContextDto context) { try { init(); validate(); var count = 0; var repo = new NguoiDungRepository(context); for (int i = 0; i < _listId.Count; i++) { if (_listId[i] > 0 && repo.Delete(_listId[i])) { count++; } } return(returnActionResult(HttpStatusCode.OK, count, null)); } catch (FormatException ex) { return(returnActionError(HttpStatusCode.BadRequest, ex.InnerException != null ? ex.InnerException.Message : ex.Message)); } catch (Exception ex) { return(returnActionError(HttpStatusCode.InternalServerError, ex.InnerException != null ? ex.InnerException.Message : ex.Message)); } }
public async Task <ActionResultDto> Execute(ContextDto context) { try { var nguoidung = new Entity.MSSQL_QLDN_MAIN.Entity.NguoiDung(); nguoidung.MaNguoiDung = MaNguoiDung; nguoidung.HoTen = HoTen; nguoidung.VaiTroId = Protector.Int(VaiTroId); nguoidung.NhanVienId = Protector.Int(NhanVienId); nguoidung.Email = Email; nguoidung.PasswordHash = HashHelper.getHashSha256(PasswordHash); nguoidung.DienThoai = DienThoai; nguoidung.NguoiTao = NguoiTao; nguoidung.NgayTaoDT = DateTime.Now; nguoidung.CtrVersion = 1; nguoidung.UserName = Email; NguoiDungRepository repo = new NguoiDungRepository(context); repo.Insert(nguoidung); return(returnActionResult(HttpStatusCode.OK, nguoidung, null)); } catch (FormatException ex) { return(returnActionError(HttpStatusCode.BadRequest, ex.InnerException != null ? ex.InnerException.Message : ex.Message)); } catch (Exception ex) { return(returnActionError(HttpStatusCode.InternalServerError, ex.InnerException != null ? ex.InnerException.Message : ex.Message)); } }
public ActionResult ExportExcel() { try { var webRoot = _env.WebRootPath; DataTable dt = new DataTable(); QuanLyCongVanContext db = new QuanLyCongVanContext(); var paht = System.IO.Path.Combine(webRoot, "Content/TempExcel/NguoiDung.xlsx"); Workbook wb = new Workbook(); //Cell Cells = char.Parse(new Cell["A3"].ToString()); Worksheet ws = wb.Worksheets[0]; dt.Columns.Add("Tên tài khoản"); dt.Columns.Add("Mật khẩu"); dt.Columns.Add("kích hoạt"); dt.Columns.Add("Mã nhân sự"); List <NguoiDung> listnd = new List <NguoiDung>(); listnd = db.NguoiDung.ToList(); string listnds = ""; if (listnd.Count > 0) { listnds = String.Join(",", listnd.Select(x => x.ToString()).ToArray()); } var ob = new NguoiDungRepository(); var data = ob.GetAll(); foreach (NguoiDung item in data) { dt.Rows.Add(item.TenTaiKhoan, item.MatKhau, item.KichHoat, item.MaNhanSu); } string filename = "DanhSachNguoiDung" + DateTime.Now.Day + "-" + DateTime.Now.Month + "-" + DateTime.Now.Year + ".xlsx"; string folderName = "/assets/Excel/"; var file = System.IO.Path.Combine(webRoot + folderName + filename); if (!System.IO.Directory.Exists(folderName)) { System.IO.Directory.CreateDirectory(folderName); } ws.Cells.ImportDataTable(dt, false, 2, 0); wb.Save(file); return(Json(folderName + filename)); } catch (Exception ex) { throw ex; } }
public override bool Validate() { string newNguoiDung = ControlToValidate.Text; TextBox textBox = (TextBox)ControlToValidate; textBox.Undo(); string oldNguoiDung = textBox.Text; textBox.Text = newNguoiDung; NguoiDungRepository nguoiDungRepository = new NguoiDungRepository(); NguoiDung tenTaiKhoang = nguoiDungRepository.FindByCondition(p => p.TenTaiKhoan.Equals(newNguoiDung) && !p.TenTaiKhoan.Equals(oldNguoiDung)).SingleOrDefault(); if (tenTaiKhoang != null) { return(false); } return(true); }
public async Task <dynamic> Execute(ContextDto context) { try { dynamic result = new System.Dynamic.ExpandoObject(); var repo = new NguoiDungRepository(context); if (PasswordHash != "" && PasswordHash != null) { PasswordHash = HashHelper.getHashSha256(PasswordHash); repo.UpdatePartial(this, nameof(MaNguoiDung), nameof(HoTen), nameof(VaiTroId), nameof(NhanVienId), nameof(PasswordHash), nameof(Email), nameof(DienThoai) ); } else { repo.UpdatePartial(this, nameof(MaNguoiDung), nameof(HoTen), nameof(VaiTroId), nameof(NhanVienId), nameof(Email), nameof(DienThoai) ); } result.data = this; return(returnActionResult(this, null)); } catch (FormatException ex) { return(returnActionError(HttpStatusCode.BadRequest, ex.Message)); } catch (Exception ex) { return(returnActionError(HttpStatusCode.InternalServerError, ex.Message)); } }
public CauHinhNguoiDungService(IUnitOfWork unitOfWork) : base(unitOfWork) { _nguoiDungRepository = new NguoiDungRepository(unitOfWork); }
public void SetUp() { nguoiDungRepository = new NguoiDungRepository(); }
public override Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context) { context.OwinContext.Response.Headers.Add("Access-Control-Allow-Origin", new[] { "*" }); //Dummy check here, you need to do your DB checks against memebrship system http://bit.ly/SPAAuthCode //Begin db check user string email = context.UserName; string password = context.Password; NguoiDungRepository repo = new NguoiDungRepository(_context); NguoiDung objResult = repo.GetByEmail(email); if (objResult == null) { context.SetError("invalid_grant", "Không tìm thấy Email này trong hệ thống!"); //return; return(Task.FromResult <object>(null)); } NguoiDung objNguoiDung = objResult; string passwordhash = string.IsNullOrWhiteSpace(password) ? "" : HashHelper.getHashSha256(password); //string passwordhash = HashHelper.getHashSha256(password); if (!objNguoiDung.PasswordHash.Equals(passwordhash) || passwordhash.Equals("")) { context.SetError("invalid_grant", "Mật khẩu không chính xác!"); //return; return(Task.FromResult <object>(null)); } GetListQuyenTacVuByVaiTroIdDac getListVaiTroDal = new GetListQuyenTacVuByVaiTroIdDac(_context); getListVaiTroDal.VAITROID = objNguoiDung.VaiTroId; IEnumerable <QuyenTacVuDto> listVaiTro = getListVaiTroDal.Execute(); listVaiTro = listVaiTro.Where(dieukien => (dieukien.DSQuyenTacVu != null && dieukien.DSQuyenTacVu.Contains("V"))); if (listVaiTro.Count() == 0) { context.SetError("invalid_grant", "Người dùng không có quyền truy cập hệ thống!"); //return; return(Task.FromResult <object>(null)); } //End db check user var identity = new ClaimsIdentity("JWT"); identity.AddClaim(new Claim(ClaimTypes.NameIdentifier, objNguoiDung.NguoiDungId.ToString())); identity.AddClaim(new Claim(ClaimTypes.Name, objNguoiDung.HoTen)); identity.AddClaim(new Claim(ClaimTypes.Email, objNguoiDung.Email)); identity.AddClaim(new Claim(ClaimTypes.Role, listVaiTro.FirstOrDefault().MaVaiTro)); var nhanvienid = objNguoiDung.NhanVienId != null?objNguoiDung.NhanVienId.Value.ToString() : ""; identity.AddClaim(new Claim("NhanVienId", nhanvienid)); foreach (string chucnang in listVaiTro.Select(cot => cot.MaChucNang)) { identity.AddClaim(new Claim("FunctionCode", chucnang)); } identity.AddClaim(new Claim("jti", Guid.NewGuid().ToString())); var props = new AuthenticationProperties(new Dictionary <string, string> { { "audience", (context.ClientId == null) ? string.Empty : context.ClientId } }); var ticket = new AuthenticationTicket(identity, props); context.Validated(ticket); return(Task.FromResult <object>(null)); }