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