public UsersListModel SelectAllUsers() { var cs = "Server=localhost\\SQLEXPRESS;Database=LibraryDB;Trusted_Connection=True;"; using var con = new SqlConnection(cs); //Using Class SqlConnection for COnnent to database con.Open(); string sql = "SELECT UserId, Username, Name, Surname, Birthday, Email FROM UserTable"; using var cmd = new SqlCommand(sql, con); //Using Class SqlCommand for query data using SqlDataReader rdr = cmd.ExecuteReader(); UsersListModel output = new UsersListModel(); output.usersList = new List <UserModel>(); while (rdr.Read()) { output.usersList.Add( new UserModel() { userId = rdr.GetInt32(0), username = rdr.GetString(1), name = rdr.GetString(2), surname = rdr.GetString(3), birthday = rdr.GetDateTime(4), email = rdr.GetString(5), } ); } return(output); }
public async Task <JsonResult> GetUsersData(string userName, string email, string phoneNumber, string role, int page = 1) { var users = await _userManager.Users.ToListAsync(); if (!string.IsNullOrEmpty(userName)) { users.RemoveAll(u => !u.UserName.Contains(userName)); } if (!string.IsNullOrEmpty(email)) { users.RemoveAll(u => !u.Email.Contains(email)); } if (!string.IsNullOrEmpty(phoneNumber)) { users.RemoveAll(u => !u.PhoneNumber.Contains(phoneNumber)); } if (!string.IsNullOrEmpty(role)) { if (await _roleManger.RoleExistsAsync(role)) { var usersInRole = new List <UserModel>(); foreach (var user in users) { if (await _userManager.IsInRoleAsync(user, role)) { usersInRole.Add(user); } } users = usersInRole; } } int pageSize = Convert.ToInt32(_configuration["Paginations:UserListPagination"]); var outputlist = users .OrderBy(u => u.UserName) .Skip((page - 1) * pageSize) .Take(pageSize); var model = new UsersListModel(ModelState) { Users = outputlist, DefaultRoleName = GetDefaultRoleName(), FilteredMail = email, FilteredPhoneNumber = phoneNumber, FilteredUserName = userName, FilterRoles = role, Pagination = this.GetPaginationData(users.Count(), pageSize, page), }; return(Json(new Result(string.Empty, false) { JsonData = model, })); }
//View users list public List <UsersListModel> UsersList(string sUserID) { List <UsersListModel> _UsersListModel = new List <UsersListModel>(); using (SqlConnection conn = new SqlConnection(DBCon)) { using (SqlCommand cmd = new SqlCommand("GetUsers", conn))//call Stored Procedure { cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserId", sUserID); cmd.Parameters.AddWithValue("@Flag", "ADMIN"); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { UsersListModel __UsersListModel = new UsersListModel(); __UsersListModel.UserID = reader["UserID"].ToString(); __UsersListModel.Firstname = reader["Firstname"].ToString(); __UsersListModel.Middlename = reader["Middlename"].ToString(); __UsersListModel.Lastname = reader["Lastname"].ToString(); __UsersListModel.Gender = reader["Gender"].ToString(); __UsersListModel.Email = reader["Email"].ToString(); __UsersListModel.Phone = reader["Phone"].ToString(); __UsersListModel.PositionName = reader["PositionName"].ToString(); __UsersListModel.DateCreated = reader["DateCreated"].ToString(); __UsersListModel.IsActive = int.Parse(reader["IsActive"].ToString()); __UsersListModel.IsArchived = int.Parse(reader["IsActive"].ToString()); _UsersListModel.Add(__UsersListModel); } } } return(_UsersListModel); }
public ActionResult Register(UsersListModel register) { if (register.Password != register.ConfirmPassword) { @TempData["FirstName"] = register.FirstName; @TempData["LastName"] = register.LastName; @TempData["Email"] = register.Email; @TempData["PhoneNumber"] = register.PhoneNumber; @TempData["REGISTER"] = "REGISTER"; @TempData["message"] = "Passwords dont match"; return(RedirectToAction("Register")); } var mes = UsersSQL.AddUser(register); if (mes.Status == "success") { return(RedirectToAction("../Home/Index")); } else { @TempData["FirstName"] = register.FirstName; @TempData["LastName"] = register.LastName; @TempData["Email"] = register.Email; @TempData["PhoneNumber"] = register.PhoneNumber; @TempData["REGISTER"] = "REGISTER"; @TempData["message"] = "Failed! Check details and then retry"; return(RedirectToAction("Register")); } }
public ActionResult AdminList(int pageSize = 10, int pageNumber = 1) { pageSize = WorkContext.SiteConfig.pageSize; string condition = "AdminGroupID > 0"; string sort = "UserID desc"; PageModel pageModel = new PageModel(pageSize, pageNumber, Users.AdminGetUserCount(condition)); UsersListModel model = new UsersListModel() { DataList = Users.AdminGetUserList(pageModel.PageSize, pageModel.PageNumber, condition, sort), PageModel = pageModel }; UserRoleModel userRoleModel = new UserRoleModel(); userRoleModel.UserRoleList = UserRoles.GetUserRoleList(); List <UserRoleInfo> resultList = new List <UserRoleInfo>(); resultList = userRoleModel.UserRoleList.ToList(); TempData["userModelList"] = resultList; SiteUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}", Url.Action("AdminList"), pageModel.PageNumber, pageModel.PageSize)); return(View(model)); }
//View Active users list public List <UsersListModel> ActiveUsersList() { List <UsersListModel> _UsersListModel = new List <UsersListModel>(); using (SqlConnection conn = new SqlConnection(DBCon)) { using (SqlCommand cmd = new SqlCommand("GetActiveUsers", conn))//call Stored Procedure { cmd.CommandType = System.Data.CommandType.StoredProcedure; conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { UsersListModel __UsersListModel = new UsersListModel(); __UsersListModel.UserID = reader["UserID"].ToString(); __UsersListModel.Firstname = reader["Firstname"].ToString(); __UsersListModel.Middlename = reader["Middlename"].ToString(); __UsersListModel.Lastname = reader["Lastname"].ToString(); __UsersListModel.Gender = reader["Gender"].ToString(); __UsersListModel.Email = reader["Email"].ToString(); __UsersListModel.Phone = reader["Phone"].ToString(); __UsersListModel.Position = reader["Position"].ToString(); __UsersListModel.Image = (byte[])reader["Image"]; __UsersListModel.DateCreated = reader["DateCreated"].ToString(); __UsersListModel.IsActive = int.Parse(reader["IsActive"].ToString()); __UsersListModel.IsArchived = int.Parse(reader["IsActive"].ToString()); _UsersListModel.Add(__UsersListModel); } } } return(_UsersListModel); }
public ActionResult Index(PagingCommand command) { command.CustomerId = Customer.CustomerId; command.UserType = _userType; UsersListModel model = _userService.List(command); return(View(model)); }
public static MessageResult AddUser(UsersListModel user) { var mes = new MessageResult(); using (SqlConnection conn = new SqlConnection(DBConn)) { conn.Open(); SqlCommand command = conn.CreateCommand(); SqlTransaction transaction = conn.BeginTransaction("ADDUSER"); command.Connection = conn; command.Transaction = transaction; try { Byte[] Password; Byte[] Keys; Byte[] IV; AccountService.EncryptStringToBytes(user.Password.Trim(), out Password, out Keys, out IV); command.Parameters.AddWithValue("@FirstName", user.FirstName); command.Parameters.AddWithValue("@LastName", user.LastName); command.Parameters.AddWithValue("@Email", user.Email); command.Parameters.AddWithValue("@PhoneNumber", user.PhoneNumber); command.Parameters.AddWithValue("@DateAdded", DateTime.Now); command.Parameters.AddWithValue("@Position", 1); command.CommandText = $@"insert into Users(FirstName,LastName,Email,PhoneNumber,DateAdded,Position) OUTPUT Inserted.UserID values(@FirstName,@LastName,@Email,@PhoneNumber,@DateAdded,@Position)" ; int UserID = Convert.ToInt32(command.ExecuteScalar()); command.Parameters.AddWithValue("@UserID", UserID); command.Parameters.AddWithValue("@Password", Password); command.Parameters.AddWithValue("@Keys", Keys); command.Parameters.AddWithValue("@IV", IV); command.Parameters.AddWithValue("@LoginType", 1); command.Parameters.AddWithValue("@Status", 1); command.Parameters.AddWithValue("@AddedBy", Constant.GetUserID()); command.CommandText = $@"Insert into UserCredential(UserID,Password,Keys,IV,LoginType,Status,DateAdded,AddedBy) values(@UserID, @Password, @Keys, @IV, @LoginType, @Status, @DateAdded, @AddedBy)"; command.ExecuteNonQuery(); transaction.Commit(); OcelotLog.AuditLogs($"{UserID} at {DateTime.Now} added.", "UserSQL", "AddUser"); mes.Status = "success"; mes.Message = "User registered successfully"; } catch (Exception e) { transaction.Rollback(); OcelotLog.ErrorLogs(e.Message.ToString(), "UserSQL", "AddUser"); mes.Status = "warning"; mes.Message = "Failed! this normaly works"; } } return(mes); }
public ActionResult Index() { ViewBag.Title = "Home Page"; var usersViewModel = new UsersListModel { Users = GetUsers() }; return(View(usersViewModel)); }
public object GetUsersInfo([FromQuery] TokenQueryModel tokenInfo, [FromBody] UsersListModel usersList) { var result = new List <SimpleUserModel>(); foreach (var user in userRepository.Select(usersList.Users)) { result.Add(SimpleUserModel.Create(user)); } return(result); }
public ActionResult UsersList(int page = 1) { var usersList = _userRepository.GetList(page); var model = new UsersListModel { UsersList = usersList, Count = _userRepository.CountAll(), Page = page }; return(View("~/Views/User/UsersList.cshtml", model)); }
//Remove User public int RemoveUser(UsersListModel model) { using (SqlConnection conn = new SqlConnection(DBCon)) { conn.Open(); SqlCommand cmd = new SqlCommand("RemoveUser", conn);//call Stored Procedure cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserID", model.UserID); int rs = cmd.ExecuteNonQuery(); return(rs); } }
public ActionResult Index() { var userService = new AccountService(); var users = userService.GetByCondition((x) => x.Role != null && x.Role.Name != "Customer"); UsersListModel usersListModel = new UsersListModel(); usersListModel.Users = new List <UserModel>(); foreach (var user in users) { usersListModel.Users.Add(user.ToView()); } return(View(usersListModel)); }
public UsersListModel List(PagingCommand command) { var users = _userRepository.FetchPaged( q => q.Where(u => u.UserTypeString == command.UserType.ToString() && u.CustomerId == command.CustomerId).OrderBy(u => u.FirstName).ThenBy(u => u.LastName), command.PageIndex, command.PageSize ); var model = new UsersListModel { Users = Mapper.Engine.MapPaged <User, UsersListModel.UserSummary>(users) }; return(model); }
public async Task <IActionResult> UserAccounts() { var allUsers = _context.Users.ToList(); var tupleList = new List <(ApplicationUser, bool)>(); foreach (var user in allUsers) { bool isAdmin = await _userManager.IsInRoleAsync(user, "Admin"); tupleList.Add((user, isAdmin)); } UsersListModel model = new UsersListModel(); model.UserIsAdminTupleList = tupleList; return(View(model)); }
public ActionResult Index( string option ) { ViewBag.Message = "Users"; bool getFullDetails = false; if( string.IsNullOrEmpty( option ) == false ) { bool.TryParse( option, out getFullDetails ); } UsersListModel model = new UsersListModel() { WorkspaceUsers = new UsersService( Shared.API_KEY ).GetUsers( ( getFullDetails ? UsersService.AllOptionalFieldsForUsers : null ) ), ShowCompleteUserDetails = getFullDetails }; return View( model ); }
// // GET: /Admin/SendEmailToUsers/ public ActionResult Index(int?RegionId, int?CountryId, int?AgencyGroupId, int?AgencyId, string errorMsg, string successMsg) { var model = new UsersListModel(); model.SelectedRegionId = RegionId; model.SelectedCountryId = CountryId; model.SelectedAgencyGroupId = AgencyGroupId; model.SelectedAgencyId = AgencyId; if (!string.IsNullOrEmpty(errorMsg)) { ModelState.AddModelError(string.Empty, errorMsg); } if (!string.IsNullOrEmpty(successMsg)) { ModelState.AddModelError("Success", successMsg); } return(View(model)); }
public ActionResult Index(string option) { ViewBag.Message = "Users"; bool getFullDetails = false; if (string.IsNullOrEmpty(option) == false) { bool.TryParse(option, out getFullDetails); } UsersListModel model = new UsersListModel() { WorkspaceUsers = new UsersService(Shared.API_KEY).GetUsers((getFullDetails ? UsersService.AllOptionalFieldsForUsers : null)), ShowCompleteUserDetails = getFullDetails }; return(View(model)); }
public async Task <ActionResult> Index(string searchTerm, string RoleID, int?page) { int recordSize = 8; page = page ?? 1; UsersListModel model = new UsersListModel(); model.SearchTerm = searchTerm; model.RoleID = RoleID; model.Roles = RoleManager.Roles.ToList(); model.Users = await SearchUsers(searchTerm, RoleID, page.Value, recordSize); var TotalRecords = await SearchUsersCount(searchTerm, RoleID); model.Pager = new Pager(TotalRecords, page, recordSize); return(View(model)); }
public ActionResult Create(UserModel user) { if (ModelState.IsValid) { AccountService accountService = new AccountService(); accountService.Add(user.ToBLL()); } var userService = new AccountService(); var users = userService.GetByCondition((x) => x.Role != null && x.Role.Name != "Customer"); UsersListModel usersListModel = new UsersListModel(); usersListModel.Users = new List <UserModel>(); foreach (var curUser in users) { usersListModel.Users.Add(curUser.ToView()); } return(View("Index", usersListModel)); }
public ActionResult Index(UsersListModel listModel) { var keywords = ""; if (!String.IsNullOrEmpty(listModel.Keywords)) { keywords = listModel.Keywords.Trim(); } var models = db.users.Where(x => x.Username.Contains(keywords) || x.Email.Contains(keywords)).OrderBy(x => x.Username).Select(x => new UserEntryViewModel { UserId = x.UserId, Username = x.Username, Email = x.Email }); listModel.Entries = models.ToPagedList( listModel.Page > 0 ? listModel.Page : 1, listModel.PageSize > 0 ? listModel.PageSize : 10); return(View(listModel)); }
public UsersListModel Build(UserFilterModel filter, Boolean?delayed = null) { filter = filter ?? new UserFilterModel(); Data.Models.Users.UserFilterModel dataFilter = filter.ToDataOne(); var usersListResult = usersQueryExecutor.UsersListByFilter(dataFilter) as IDelayedQueryExecutionResult <IList <Data.Models.Users.UserModel> >; var result = new UsersListModel { Filter = filter }; result.Filter.DelayedQueryState = DelayedQueryStateModel.FromDelayedExecutionResult(usersListResult); if (result.Filter.DelayedQueryState.StateCode == (Int32)QueryStatesEnum.Completed && (!delayed.HasValue || delayed.Value == false)) { result.Items = BuildItems(usersListResult); } return(result); }
public async Task <ActionResult> UsersList() { System.Linq.IQueryable <IdentityUser> users = _userManager.Users; UsersListModel vm = new UsersListModel(); foreach (IdentityUser u in users) { List <SelectListItem> sl = new List <SelectListItem>(); IList <string> roles = await _userManager.GetRolesAsync(u); foreach (string r in roles) { sl.Add(new SelectListItem { Text = r }); } vm.Users.Add(new User { ID = u.Id, Name = u.UserName, Roles = sl }); } return(View(vm)); }
public ActionResult SendEmail(UsersListModel model) { if (string.IsNullOrEmpty(model.EmailTo)) { ModelState.AddModelError(string.Empty, "To is a required field"); return(RedirectToAction("Index", new { RegionId = model.SelectedRegionId, CountryId = model.SelectedCountryId, AgencyGroupId = model.SelectedAgencyGroupId, AgencyId = model.SelectedAgencyId, errorMsg = "To is a required field" })); } using (var smtpClient = new System.Net.Mail.SmtpClient()) { // smtpClient.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.Network; //smtpClient = 25; try { var msg = new System.Net.Mail.MailMessage(); smtpClient.Port = 25; msg.IsBodyHtml = true; msg.Subject = model.Subject; msg.Body = model.Body; msg.To.Add(model.EmailTo); if (!string.IsNullOrEmpty(model.EmailBcc)) { msg.Bcc.Add(model.EmailBcc); } if (!string.IsNullOrEmpty(model.EmailCc)) { msg.CC.Add(model.EmailCc); } smtpClient.Send(msg); return(RedirectToAction("Index", new { RegionId = model.SelectedRegionId, CountryId = model.SelectedCountryId, AgencyGroupId = model.SelectedAgencyGroupId, AgencyId = model.SelectedAgencyId, successMsg = "The email sent successfully" })); } catch (Exception ex) { ModelState.AddModelError(string.Empty, ex); return(RedirectToAction("Index", new { RegionId = model.SelectedRegionId, CountryId = model.SelectedCountryId, AgencyGroupId = model.SelectedAgencyGroupId, AgencyId = model.SelectedAgencyId, errorMsg = ex.Message })); } } }
public JsonResult List() { UsersListModel result = new UsersListModel(); try { result.ListItems.AddRange(_userService.GetAllShortUserInfo()); } catch (BusinessException exception) { _logger.DebugFormat("BusinessException: {0}-{1}", exception.ErrorCode, exception.Message); result.ErrorCode = exception.ErrorCode; result.ErrorDescription = CommonUtils.GetErrorMessage(exception); } catch (Exception exception) { _logger.Error(string.Format("Iternal error {0}", exception)); result.ErrorCode = ErrorCode.InternalErrorException; result.ErrorDescription = CommonUtils.GetEnumDescription(ErrorCode.InternalErrorException); } return(Json(result)); }
public ActionResult RemoveUser(UsersListModel model) { if (ModelState.IsValid) { try { _UsersManagementService.RemoveUser(model); TempData["Success"] = "Success"; return(RedirectToAction("UsersList")); } catch (Exception e) { Response.StatusCode = (int)HttpStatusCode.BadRequest; ModelState.AddModelError("", e.Message); TempData["Fail"] = "Fail"; return(View("UsersList", model)); } } else { TempData["ModelsError"] = "Error"; return(RedirectToAction("UsersList")); } }
//Remove User public int RemoveUser(UsersListModel model) { throw new NotImplementedException(); }
//Deactivate User public int DeactivateActivateUser(UsersListModel model) { throw new NotImplementedException(); }
public UsersListModel GetUsersList() { UsersListModel result = _usersService.SelectAllUsersService(); return(result); }
public UsersListModel SelectAllUsersService() { UsersListModel result = _usersRepository.SelectAllUsers(); return(result); }