public UserEditForm(Feature feature, UserDTO userDto) { InitializeComponent(); _feature = feature; _selectedUser = userDto; InitializeControlStatus(); InitializeData(); }
public List<UserDTO> SearchUsers(SearchUserDTO dto) { UserDTO user; List<UserDTO> list=new List<UserDTO>(); try { SqlDataReader reader = ConnectionManager.GetCommand("sp0002", new Dictionary<string, SqlDbType>() { {"@username", SqlDbType.NVarChar}, {"@status", SqlDbType.Int}, {"@eMail", SqlDbType.NVarChar}, {"@idsn", SqlDbType.NVarChar} }, new List<object>() { dto.UserName, dto.Status, dto.Email, dto.Isdn }).ExecuteReader(); while (reader.Read()) { user=new UserDTO(); user.UserId = reader["UserID"].ToString(); user.Username = reader["Username"].ToString(); //user.Password = reader["Password"].ToString(); user.RoleDescription = reader["RoleDescription"].ToString(); user.Birthday = (DateTime)reader["Birthday"]; user.Address = reader["Address"].ToString(); user.Phone = reader["Phone"].ToString(); user.Email = reader["Email"].ToString(); user.IDSN = reader["IDSN"].ToString(); user.IssuedDate = (DateTime)reader["IssuedDate"]; user.ExpiredDate = (DateTime)reader["ExpiredDate"]; int statusTemp; int.TryParse(reader["Status"].ToString(), out statusTemp); user.Status = (UserStatus)Enum.Parse(typeof(UserStatus), statusTemp.ToString()); list.Add(user); } reader.Close(); } catch (Exception e) { Log.Error("Error at UserDAO - GetUserByID", e); return null; } return list; }
public static void Error(UserDTO user, object message, Exception e) { // Insert action to db here var appType = Options.IsWeb ? "WEB" : "APP"; user = user ?? (Options.User ?? ((HttpContext.Current == null ? null : HttpContext.Current.Session["USER"]) == null ? new UserDTO() { UserId = "Unknown" } : (UserDTO)HttpContext.Current.Session["USER"])); try { LogBUS bus = new LogBUS(); bus.InsertLog(user.UserId, message.ToString(), appType + "/" + "ERROR"); } catch (Exception ex) { Logger.Error("Error at Log - Error", ex); } // Write to log incase of DB fail Logger.Error(message, e); }
public UserDTO GetByUserId(string userId) { UserDTO user = null; try { SqlDataReader reader = ConnectionManager.GetCommand("SP0601ByUserID", new Dictionary<string, SqlDbType>() { {"@UserID", SqlDbType.NVarChar} }, new List<object>() { userId }).ExecuteReader(); if (reader.Read()) { user = new UserDTO(); user.UserId = reader["UserID"].ToString(); user.Username = reader["Username"].ToString(); user.Password = reader["Password"].ToString(); int roleIdTmp; int.TryParse(reader["RoleID"].ToString(), out roleIdTmp); user.RoleId = roleIdTmp; user.Birthday = (DateTime)reader["Birthday"]; user.Address = reader["Address"].ToString(); user.Phone = reader["Phone"].ToString(); user.Email = reader["Email"].ToString(); user.IDSN = reader["IDSN"].ToString(); user.IssuedDate = (DateTime)reader["IssuedDate"]; user.ExpiredDate = (DateTime)reader["ExpiredDate"]; int statusTemp; int.TryParse(reader["Status"].ToString(), out statusTemp); user.Status = (UserStatus)Enum.Parse(typeof(UserStatus), statusTemp.ToString()); user.CreatedDate = (DateTime)reader["CreatedDate"]; user.UpdatedDate = (DateTime)reader["UpdatedDate"]; } } catch (Exception e) { Log.Error("Error at UserDAO - GetByUserName", e); return null; } return user; }
public bool UpdateUser(UserDTO user) { return _userDao.Update(user); }
public bool InsertUser(UserDTO user) { return _userDao.Insert(user); }
public bool UpdateUser(UserDTO userDto) { Log.Info("Update user " + userDto.UserId + " info"); try { return userBus.UpdateUser(userDto); } catch (Exception e) { Log.Error("Error at Feature - UpdateUser", e); } return false; }
public bool ResetPassword(UserDTO userDto) { try { var pass = RandomString(8); userDto.Password = EncodePassword(pass); if (userBus.UpdateUser(userDto)) { SendSampleMail(userDto.Email, Options.MailSubject, "Mật mã của bạn đã được thiết lập lại.<br/>Mật mã mới của bạn là <b>" + pass + "</b>"); } return true; } catch (Exception e) { Log.Error("Error at Feature - ResetPassword", e); } return false; }
public List<RentalDTO> GetRentalByUserIdPaging(UserDTO user, int page, out int NoP) { var listRental = new List<RentalDTO>(); try { // get Rental info listRental = rentalBus.GetRentalByUserIdPaging(user.UserId, page, out NoP); foreach (var rentalDto in listRental) { rentalDto.Username = user.Username; // get Catalogue info string isbn = copyBus.GetCopyById(rentalDto.Barcode).ISBN; if (isbn != null) { var catalogeDto = catalogeBus.GetCatalogueById(isbn); if (catalogeDto != null) { rentalDto.BookTitle = catalogeDto.Title; rentalDto.BookPrice = catalogeDto.Price; rentalDto.ExpandLimit = catalogeDto.ExpandLimit; rentalDto.ExpandDateLimit = catalogeDto.ExpandDateLimit; } } } } catch (Exception e) { Log.Error(user, "Error at Feature - GetRentalByUserId", e); NoP = 0; } return listRental; }
public List<BookRegisterDTO> GetRegisterByUserIdPaging(UserDTO user, int page, out int noP) { Log.Info("View Register entries"); var listRegister = new List<BookRegisterDTO>(); try { listRegister = registerBus.GetBookRegisterByUserIdPaging(user.UserId, page, out noP); foreach (var registerDto in listRegister) { registerDto.Username = user.Username; registerDto.BookTitle = catalogeBus.GetCatalogueById(registerDto.ISBN).Title; } } catch (Exception e) { Log.Error(user, "Error at Feature - GetRegisterByUserId", e); noP = 0; } return listRegister; }
public bool ChangePassword(UserDTO userDto, string newPassword) { try { userDto.Password = newPassword; if (userBus.UpdateUser(userDto)) { SendSampleMail(userDto.Email, Options.MailSubject, "Mật mã của bạn đã được thiết lập lại.<br/>"); } return true; } catch (Exception e) { Log.Error("Error at Feature - ResetPassword", e); } return false; }
public bool AddUser(UserDTO userDto) { Log.Info("Add New User " + userDto.UserId); var pass = RandomString(8); userDto.Password = EncodePassword(pass); try { if (userBus.InsertUser(userDto)) { SendSampleMail(userDto.Email, Options.MailSubject, "Chào " + userDto.Username + ", <br/><br/>Tài khoản của bạn đã được tạo.<br/>Tên đăng nhập của bạn <b>" + userDto.UserId + "</b><br/>Mật mã của bạn là <b>" + pass + "</b>"); } return true; } catch (Exception e) { Log.Error("Error at Feature - AddUser", e); } return false; }
private void BtnSaveClick(object sender, EventArgs e) { string msg = ValidateData(); if (msg != null) { MessageBox.Show(this, msg, Constants.SYSTEM_INFO, MessageBoxButtons.OK, MessageBoxIcon.Information); return; } bool result = false; // update if (_selectedUser != null) { _selectedUser.Username = txtUsername.Text; _selectedUser.RoleId = (int)cboRole.SelectedValue; _selectedUser.IDSN = txtIDSN.Text; _selectedUser.Phone = txtPhone.Text; _selectedUser.Email = txtEmail.Text; _selectedUser.Address = txtAddress.Text; _selectedUser.Birthday = dteBirthday.Value; _selectedUser.ExpiredDate = dteExpireDate.Value; _selectedUser.Status = (UserStatus)EnumHelper.Parse(typeof(UserStatus), cboStatus.Text); result = _feature.UpdateUser(_selectedUser); if (result) { MessageBox.Show(this, Constants.USER_EDIT_OK, Constants.SYSTEM_INFO, MessageBoxButtons.OK, MessageBoxIcon.Information); } } // insert else { var userDto = new UserDTO(); userDto.UserId = txtUserID.Text; userDto.Username = txtUsername.Text; userDto.Password = txtUserID.Text; userDto.RoleId = (int)cboRole.SelectedValue; userDto.IDSN = txtIDSN.Text; userDto.Phone = txtPhone.Text; userDto.Email = txtEmail.Text; userDto.Address = txtAddress.Text; userDto.Birthday = dteBirthday.Value; userDto.IssuedDate = dteIssueDate.Value; userDto.ExpiredDate = dteExpireDate.Value; userDto.Status = (UserStatus)EnumHelper.Parse(typeof(UserStatus), cboStatus.Text); result = _feature.AddUser(userDto); if (result) { //_feature.SendSampleMail("*****@*****.**"); MessageBox.Show(this, Constants.USER_INSERT_OK, Constants.SYSTEM_INFO, MessageBoxButtons.OK, MessageBoxIcon.Information); } } if (!result) { MessageBox.Show(this, Constants.SYSTEM_ERROR, Constants.SYSTEM_INFO, MessageBoxButtons.OK, MessageBoxIcon.Error); } Close(); }
public bool Update(UserDTO user) { try { user.UpdatedDate = DateTime.Now; ConnectionManager.GetCommand("SP0603", new Dictionary<string, SqlDbType>() { {"@UserID", SqlDbType.NVarChar}, {"@Username", SqlDbType.NVarChar}, {"@Password", SqlDbType.NVarChar}, {"@RoleID", SqlDbType.Int}, {"@Birthday", SqlDbType.Date}, {"@Address", SqlDbType.NVarChar}, {"@Phone", SqlDbType.NVarChar}, {"@Email", SqlDbType.NVarChar}, {"@IDSN", SqlDbType.NVarChar}, {"@IssuedDate", SqlDbType.DateTime}, {"@ExpiredDate", SqlDbType.DateTime}, {"@Status", SqlDbType.Int}, {"@CreatedDate", SqlDbType.DateTime}, {"@UpdatedDate", SqlDbType.DateTime} }, new List<object>() { user.UserId, user.Username, user.Password, user.RoleId, user.Birthday, user.Address, user.Phone, user.Email, user.IDSN, user.IssuedDate, user.ExpiredDate, user.Status, user.CreatedDate, user.UpdatedDate }).ExecuteReader(); return true; } catch (Exception e) { Log.Error("Error at UserDAO - Update", e); return false; } }