// GET: User
// [CustomAuthorize(Roles = "Admin")]
public ActionResult Index(int?page, string keyword, DateTime?startDate, DateTime?endDate, int?roleId)
{
var userListVM = new UserListVM
{
StartDate = startDate,
EndDate = endDate,
Keyword = keyword,
RoleId = roleId,
PageIndex = page ?? 1,
PageSize = SettingsManager.User.PageSize,
SetPasswordIM = new SetPasswordIM()
};
int totalCount;
var users = _userServices.GetPagedElements(userListVM.PageIndex - 1, userListVM.PageSize, userListVM.Keyword,
userListVM.StartDate, userListVM.EndDate, userListVM.RoleId, out totalCount);
userListVM.TotalCount = totalCount;
// var userList = _mapper.Map<IList<User>, IList<UserVM>>(users);
userListVM.Users = new StaticPagedList <User>(users, userListVM.PageIndex, userListVM.PageSize, userListVM.TotalCount);
// ViewBag.OnePageOfUsers = usersAsIPagedList;
ViewBag.PageSizes = new SelectList(Site.PageSizes());
var roleList = _roleServices.GetAll().Where(m => m.Id != SettingsManager.Role.Founder).ToList();
var roles = new SelectList(roleList, "Id", "RoleName");
ViewBag.Roles = roles;
return(View(userListVM));
}
public ActionResult UserGrid()
{
UserListVM model = new UserListVM();
model = repository.GetUserListItems();
return(View("UsersListGrid", model));
}
//[Authorize(Roles = "Admin")]
public ActionResult Users()
{
AccountManager mgr = new AccountManager();
UserListVM model = new UserListVM();
var roles = mgr.GetAllRoles();
var users = mgr.GetAllUsers();
if (roles.Success)
{
model.Roles = roles.Payload;
}
else
{
throw new Exception("Roles loading improperly");
}
if (users.Success)
{
model.Users = users.Payload;
}
else
{
throw new Exception("Users loading improperly");
}
return(View(model));
}
public ActionResult GetUsers()
{
List <LibraryCommon.DataEntity.User> _list = _logicUser.GetUsersPassThru();
UserListVM model = new UserListVM(_list);
return(View(model));
}
public async Task <IActionResult> Index()
{
UserListVM vm = new UserListVM();
vm.Users = new List <UserListItemVM>();
// get the list of users
List <IdentityUser> users = await _userManager.Users.ToListAsync();
foreach (IdentityUser user in users)
{
// get user is of admin role
//bool isSuperAdmin = (await _userManager.GetRolesAsync(user)).Any(r => r == SecurityConstants.AdminRoleString);
// todo make identity init singleton service like email config so as to avoid raw strings usage
bool isSuperAdmin = (user.UserName == _identityInit.AdminUserName);
if (!isSuperAdmin)
{
// add user to vm only if not admin
string userRole = "";
IList <string> existingRoles = await _userManager.GetRolesAsync(user);
if (existingRoles.Count > 0)
{
userRole = existingRoles.ElementAt(0);
}
vm.Users.Add(new UserListItemVM
{
UserId = user.Id,
Username = user.UserName,
Email = user.Email,
UserRole = userRole
});
}
}
return(View(vm));
}
public ActionResult GetUsers()
{
List <User> _list = userBL.GetUsersPassThru();
UserListVM model = new UserListVM(_list);
return(View(model));
}
// GET: User
// [CustomAuthorize(Roles = "Admin")]
public IActionResult Index(int?page, string keyword, DateTime?startDate, DateTime?endDate, int?roleId)
{
var userListVM = new UserListVM
{
StartDate = startDate,
EndDate = endDate,
Keyword = keyword,
RoleId = roleId,
PageIndex = page ?? 1,
PageSize = SettingsManager.User.PageSize,
SetPasswordIM = new SetPasswordIM()
};
int totalCount;
userListVM.Users = _userServices.GetPagedElements(userListVM.PageIndex - 1, userListVM.PageSize, userListVM.Keyword,
userListVM.StartDate, userListVM.EndDate, userListVM.RoleId, out totalCount);
userListVM.TotalCount = totalCount;
if (Request.Headers["X-Requested-With"] == "XMLHttpRequest")
{
return(PartialView("_UserList", userListVM.Users.Items));
}
ViewBag.PageSizes = new SelectList(Site.PageSizes());
var roleList = _roleServices.GetAll().Where(m => m.Id != SettingsManager.Role.Founder).ToList();
var roles = new SelectList(roleList, "Id", "RoleName");
ViewBag.Roles = roles;
return(View(userListVM));
}
public async Task <IActionResult> Index()
{
UserListVM vm = new UserListVM();
vm.Users = new List <UserListItemVM>();
// get the list of users
List <Utility> users = await _userManager.Users.ToListAsync();
foreach (Utility user in users)
{
// get user is of admin role
bool isAdmin = (await _userManager.GetRolesAsync(user)).Any(r => r == SecurityConstants.AdminRoleString);
if (!isAdmin)
{
// add user to vm only if not admin
vm.Users.Add(new UserListItemVM
{
UserId = user.Id,
Username = user.UserName,
Email = user.Email
});
}
}
return(View(vm));
}
public ViewResult Index()
{
UserListVM userListVM = new UserListVM();
userListVM.userList = _context.Users.ToList();
return(View(userListVM));
}
public ActionResult Index()
{
var viewModel = new UserListVM();
viewModel.Userlist = _UserlistService.GetAll();
return(View(viewModel));
}
public ActionResult List()
{
List <User> users = usersService.GetAll();
UserListVM userListVM = new UserListVM();
userListVM.Users = users;
return(View(userListVM));
}
public UserListVM GetUserListItems()
{
using (SqlConnection conn = new SqlConnection(this.connectionString))
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "SELECT " +
" ID, "+
" UserName, "+
" WebUserFirstName, "+
" WebUserLastName, "+
" WebUserEmail, "+
" StaffID "+
"FROM dbo.WebUsers;";
try
{
DataSet set = cmd.GetDataSet();
DataTable userTable = set.Tables[0];
List <UserVM> items = new List <UserVM>();
UserListVM userList = new UserListVM();
foreach (DataRow r in userTable.Rows)
{
UserVM item = new UserVM
{
ID = r.ToIntOrNull("ID"),
UserName = r.ToStringValue("UserName"),
FirstName = r.ToStringValue("WebUserFirstName"),
LastName = r.ToStringValue("WebUserLastName"),
Email = r.ToStringValue("WebUserEmail")
};
if (r.ToIntOrNull("StaffID") != null)
{
item.StaffMember = this.GetOfficeStaffMember(r.ToInt("StaffID"));
}
items.Add(item);
}
userList.DetailList = items;
return(userList);
}
catch (Exception e)
{
Exceptions.Handle(e);
throw new DataException(e.Message, e);
}
}
}
public ActionResult Index([Bind(Include = "Page, Sort")] PageSortCriteria pageSortCriteria, [Bind(Include = "FirstName, LastName, UserName, Email")] UserSearchCriteria searchCriteria = null)
{
UserListVM vm = new UserListVM
{
Users = UOW.SkyberryUsers.GetAllPaged(pageSortCriteria, searchCriteria),
PageSortCriteria = pageSortCriteria,
SearchCriteria = searchCriteria
};
return(View(vm));
}
public IActionResult PostUserData([FromBody] User user)
{
var response = new SingleModelResponse <UserListVM>() as ISingleModelResponse <UserListVM>;
var result = new UserListVM();
string error = "N";
try
{
if (ModelState.IsValid)
{
user.signaturepath = "";
var addedUser = _userService.AddUserData(user);
if (addedUser.userid != 0)
{
result = _userService.GetUserListsById(addedUser.userid);
error = "E";
SendEmail(user.email, user.name, user);
}
else
{
result = null;
}
response.StatusCode = (int)HttpStatusCode.OK;
response.Success = "Y";
response.Message = "Save data successful.";
response.Data = result;
}
else
{
response.StatusCode = (int)HttpStatusCode.InternalServerError;
response.Success = "N";
response.Message = "Invalid entry.";
}
}
catch (Exception ex)
{
response.StatusCode = (int)HttpStatusCode.InternalServerError;
response.Success = error;
response.Message = ex.Message;
if (error == "E")
{
response.Data = result;
}
}
return(response.ToHttpResponse());
}
public IActionResult RevokePermission(int listId, string userId)
{
_groceryLists.RevokePermission(listId, userId);
var groceryList = _groceryLists.ReadGroceryList(listId);
var userList = _userManager.ReadAllAsync();
var privUsers = groceryList.AssociativeEntities.Select(u => u.PrivUserEmail).ToList();
UserListVM model = new UserListVM
{
UserList = userList.Result.AsQueryable(),//may need to select non-priv users
PriviledgedUsers = privUsers,
ListName = groceryList.GroceryListName,
ListId = listId,
OwnerId = groceryList.OwnerId
};
return View(model);
}
/// <summary>
/// Allows an Owner of a grocery list to add or revoke access to
/// registered users. If user is not the owner, they may only be able to see
/// other users who are granted access.
/// </summary>
/// <param name="listId"></param>
/// <returns></returns>
public IActionResult Permissions(int listId)
{
var groceryList = _groceryLists.ReadGroceryList(listId);
var userList = _userManager.ReadAllAsync();
var privUsers = groceryList.AssociativeEntities.Select(u => u.PrivUserEmail).ToList();
string userId = _manager.GetUserId(HttpContext.User);
UserListVM model = new UserListVM
{
UserList = userList.Result.AsQueryable(),
PriviledgedUsers = privUsers,
ListName = groceryList.GroceryListName,
ListId = listId,
OwnerId = groceryList.OwnerId ,
UserId = userId
};
return View(model);
}
public ActionResult UpdateUser(int id)
{
RoleListVM list = new RoleListVM(roleBL.GetRolesPassThru());
ViewBag.Roles = new SelectList(list.ListOfRoleModels, "RoleID", "RoleName");
List <User> _list = userBL.GetUsersPassThru();
UserListVM model = new UserListVM(_list);
UserModel updateUser = new UserModel();
foreach (var i in model.ListOfUserModels)
{
if (id == i.UserID)
{
updateUser = i;
}
}
return(View(updateUser));
}
public async Task <IActionResult> Index(string sortOrder,
string currentFilter,
string searchString,
int?page)
{
UserListVM userListVM = new UserListVM();
userListVM.currentSort = sortOrder;
userListVM.currentFilter = searchString;
userListVM.emailSortParm = String.IsNullOrEmpty(sortOrder) ? "email_desc" : "";
if (searchString != currentFilter)
{
page = 1;
}
var users = from u in _context.Users
select u;
if (!String.IsNullOrEmpty(searchString))
{
users = users.Where(s => s.Email.Contains(searchString));
}
switch (sortOrder)
{
case "email_desc":
users = users.OrderByDescending(u => u.Email);
break;
default:
users = users.OrderBy(u => u.Email);
break;
}
userListVM.userList = await PaginatedList <User> .CreateAsync(users.AsNoTracking(), page ?? 1, PageSize);
return(View(userListVM));
}
public ActionResult Index(int? page, string startDate, string expireDate, string userName, string email)
{
var userListVM = new UserListVM
{
StartDate = startDate,
ExpireDate = expireDate,
UserName = userName,
Email = email,
PageIndex = (page ?? 1) - 1,
PageSize = Site.Settings.PageSize,
SetPasswordVM = new SetPasswordVM()
};
userListVM.Users = _userService.SearchUsers(userListVM.PageIndex, userListVM.PageSize, startDate, expireDate, userName, email);
userListVM.TotalUserCount = _userService.SearchUserCount(startDate, expireDate, userName, email);
var logsAsIPagedList = new StaticPagedList<ApplicationUser>(userListVM.Users, userListVM.PageIndex + 1, userListVM.PageSize, userListVM.TotalUserCount);
ViewBag.OnePageOfLogs = logsAsIPagedList;
return View(userListVM);
}
public ActionResult HR(UserListVM vm)
{
List <UserListVM> list = _us.GetAll()
.Select(x => new UserListVM()
{
Photo = x.Photo,
FName = x.FName,
LName = x.LName,
Email = x.Email,
Phone = x.Phone,
Created = x.Created,
IsActive = x.IsActive,
UserName = x.UserName,
RoleName = _rs.GetAll()
.Where(y => y.Id == x.RoleId)
.Select(y => y.Name)
.FirstOrDefault(),
PersonnelCode = x.Id
}).ToList();
return(View(list));
}
public ActionResult PrikazUsera(UserListVM Model, int?page)
{
if (Model.ItemsPerPage == 0)
{
Model = new UserListVM();
Model.ItemsPerPage = 5;
}
Model.ItemsPerPageList = new List <SelectListItem>()
{
new SelectListItem {
Value = "5", Text = "5"
},
new SelectListItem {
Value = "7", Text = "7"
},
new SelectListItem {
Value = "10", Text = "10"
},
new SelectListItem {
Value = "15", Text = "15"
},
};
Model.allUsers = ctx.Users
.Where(x => Model.searchParam == "" || Model.searchParam == null ? true : (x.FirstName.Contains(Model.searchParam) || x.SecondName.Contains(Model.searchParam) || x.Email.Contains(Model.searchParam) || (x.FirstName + " " + x.SecondName).Contains(Model.searchParam)))
.Select(x => new UserListVM.UserInfo
{
Id = x.Id,
Name = x.FirstName + " " + x.SecondName,
Age = x.Age,
Email = x.Email,
Blogs = ctx.Blogs.Count(y => y.UserId == x.Id)
}).OrderBy(x => x.Name).ToList();
Model.allUsersPaged = new PagedList.PagedList <UserListVM.UserInfo>(Model.allUsers, page ?? 1, Model.ItemsPerPage);
return(View("PrikazUsera", Model));
}
public async Task <IActionResult> Index()
{
UserListVM vm = new UserListVM
{
Users = new List <UserListItemVM>()
};
// get the list of users
List <ApplicationUser> users = await _userManager.Users.ToListAsync();
foreach (ApplicationUser user in users)
{
// get user is of admin role
//bool isSuperAdmin = (await _userManager.GetRolesAsync(user)).Any(r => r == SecurityConstants.AdminRoleString);
bool isSuperAdmin = (user.UserName == _identityInit.AdminUserName);
if (true)
{
// add user to vm only if not admin
string userRole = "";
IList <string> existingRoles = await _userManager.GetRolesAsync(user);
if (existingRoles.Count > 0)
{
userRole = existingRoles.ElementAt(0);
}
vm.Users.Add(new UserListItemVM
{
UserId = user.Id,
Username = user.UserName,
Email = user.Email,
UserRole = userRole,
Phone = user.PhoneNumber,
TwoFactorEnabled = user.TwoFactorEnabled
});
}
}
return(View(vm));
}
// GET: Users
public ActionResult List(int?page)
{
UsersService userService = new UsersService();
UserListVM model = new UserListVM();
TryUpdateModel(model);
model.Users = userService.GetAll();
if (model.Search != null)
{
model.Users = model.Users.Where(u => u.FirstName.Contains(model.Search) || u.LastName.Contains(model.Search) || u.Username.Contains(model.Search) || u.Email.Contains(model.Search)).ToList();
}
switch (model.SortOrder)
{
case "fname_desc": model.Users = model.Users.OrderByDescending(u => u.FirstName).ToList(); break;
case "lname_asc": model.Users = model.Users.OrderBy(u => u.LastName).ToList(); break;
case "lname_desc": model.Users = model.Users.OrderByDescending(u => u.LastName).ToList(); break;
case "username_asc": model.Users = model.Users.OrderBy(u => u.Username).ToList(); break;
case "username_desc": model.Users = model.Users.OrderByDescending(u => u.Username).ToList(); break;
case "fname_asc":
default:
model.Users = model.Users.OrderBy(u => u.FirstName).ToList();
break;
}
int pageSize = 2;
int pageNumber = (page ?? 1);
model.UsersPaged = model.Users.ToPagedList(pageNumber, pageSize);
return(View(model));
}
public IActionResult Permissions(int listId)
{
var groceryList = _groceryLists.ReadGroceryList(listId);
//populate list vm
var model = new UserListVM
{
OwnerId = groceryList.OwnerId,
ListId = listId,
ListName = groceryList.GroceryListName
};
//RETRIEVAL
string userId = _manager.GetUserId(HttpContext.User);
ApplicationUser au = _userManager.ReadAll().FirstOrDefault(p => p.Id == userId);
//VALIDATION
if (userId.Equals(groceryList.OwnerId) || groceryList.PriviligedPeople.Contains(au))
{
foreach (var user in _userManager.ReadAll())
{
model.AllNames.Add(user);
}
foreach (var puser in groceryList.PriviligedPeople)
{
model.PriviledgedUsers.Add(puser);
}
return(View(model));
}
else
{
return(Content("You must be a permitted user to view this list."));
}
}
public async Task <IActionResult> Index(int productPage = 1, string searchByEmail = null)
{
var claimsIdentity = (ClaimsIdentity)User.Identity;
var claim = claimsIdentity.FindFirst(ClaimTypes.NameIdentifier);
var(users, usersCount) = await _userService.GetFiltered(claim.Value, searchByEmail, PageSize, productPage);
var userListVM = new UserListVM()
{
Users = users
};
const string Url = "/Admin/User/Index?productPage=:";
userListVM.PagingInfo = new PagingInfo
{
CurrentPage = productPage,
ItemsPerPage = PageSize,
TotalItem = usersCount,
UrlParam = Url
};
return(View(userListVM));
}
// GET: User
// [CustomAuthorize(Roles = "Admin")]
public async Task <IActionResult> Index(int?page, string sort, string keyword, DateTime?startDate, DateTime?endDate, int?roleId)
{
var vm = new UserListVM
{
StartDate = startDate,
EndDate = endDate,
Keyword = keyword,
RoleId = roleId,
PageIndex = page ?? 1,
PageSize = SettingsManager.User.PageSize,
SetPasswordIM = new SetPasswordIM()
};
var query = _context.Users.AsQueryable();
if (!string.IsNullOrEmpty(keyword))
{
query = query.Where(d => d.RealName.Contains(keyword) && d.UserName.Contains(keyword));
}
if (startDate != null)
{
query = query.Where(d => d.CreateDate >= startDate);
}
if (endDate != null)
{
query = query.Where(d => d.CreateDate <= endDate);
}
if (roleId != null)
{
query = query.Where(d => d.UserRoles.Any(c => c.RoleId == roleId));
}
ViewData["EmailSortParm"] = sort == "email" ? "email_desc" : "email";
ViewData["MobileSortParm"] = sort == "mobile" ? "mobile_desc" : "mobile";
ViewData["UsernameSortParm"] = sort == "username" ? "username_desc" : "username";
ViewData["DateSortParm"] = sort == "date" ? "date_desc" : "date";
query = sort switch
{
"email" => query.OrderBy(s => s.Email),
"email_desc" => query.OrderByDescending(s => s.Email),
"username" => query.OrderBy(s => s.UserName),
"username_desc" => query.OrderByDescending(s => s.UserName),
"date" => query.OrderBy(s => s.CreateDate),
"date_desc" => query.OrderByDescending(s => s.CreateDate),
"mobile" => query.OrderBy(s => s.Mobile),
"mobile_desc" => query.OrderByDescending(s => s.Mobile),
_ => query.OrderByDescending(s => s.CreateDate),
};
vm.TotalCount = await query.CountAsync();
var list = await query.Skip((vm.PageIndex - 1) *vm.PageSize).Take(vm.PageSize).ToListAsync();
vm.Users = new StaticPagedList <User>(list, vm.PageIndex, vm.PageSize, vm.TotalCount);
if (Request.Headers["X-Requested-With"] == "XMLHttpRequest")
{
return(PartialView("_UserList", list));
}
ViewBag.PageSizes = new SelectList(Site.PageSizes());
var roleList = _roleServices.GetAll().Where(m => m.Id != SettingsManager.Role.Founder).ToList();
var roles = new SelectList(roleList, "Id", "RoleName");
ViewBag.Roles = roles;
return(View(vm));
}
public UserListView(UserListVM vm)
{
InitializeComponent();
ViewModel = vm;
}
public IHttpActionResult LoadUserList([FromBody] UserListVM filter)
{
if (filter == null || !ModelState.IsValid)
{
return(Content(HttpStatusCode.BadRequest, "Request body not valid"));
}
ARCOeCardEntities arcodb = new eCard.ARCOeCardEntities();
int siteid = Convert.ToInt32(filter.SiteId);
//SiteLocation sitelocation = arcodb.SiteLocations.Where(s => s.ID == siteid).FirstOrDefault();
List <UserListVM> UserList = (from User in arcodb.PrenotesUsers
join sitename in arcodb.SiteLocations
on User.DefaultSite equals sitename.ID
where
(String.IsNullOrEmpty(filter.UserName) || (User.Username.Contains(filter.UserName))) &&
(filter.SiteId == 0 || User.DefaultSite == siteid) && User.Deleted == false && sitename.Status != false
// (filter.CreatedDate == null || orders.CreatedDate >= filter.CreatedDate) &&
//(filter.EndDate == null || note.CreatedDate.Date <= filter.EndDate.Value.Date)
select new UserListVM
{
UserName = User.Username,
Id = User.Id,
Email = User.Email,
SiteName = sitename.SiteLocation1,
CreatedDate = User.CreatedDate,
LastUpdatedDate = User.ModifiedDate,
})
.ToList()
//.Where(a => filter.StatusForDate == false ? (filter.StartDate == null || a.StartDate.Value.Date >= filter.StartDate.Value.Date) : filter.StartDate == null || a.LastStartDate.Value.Date >= filter.StartDate.Value.Date).DefaultIfEmpty()
//.Where(a => filter.StatusForDate == false ? (filter.LastUpdatedDate == null || a.LastUpdatedDate.Value.Date <= filter.LastUpdatedDate.Value.Date) : filter.LastUpdatedDate == null || a.LastEndUpdate.Value.Date <= filter.LastUpdatedDate.Value.Date).DefaultIfEmpty()
.ToList();
// Filter the list according to the input filter
try
{
#region Orders Sorting
if (String.IsNullOrWhiteSpace(filter.Sorting))
{
UserList = UserList.OrderByDescending(i => i.LastUpdatedDate).ToList();
}
else if (filter.Direction == "desc")
{
switch (filter.Sorting)
{
case "UserName":
UserList = UserList.OrderByDescending(i => i.UserName).ToList();
break;
case "SiteName":
UserList = UserList.OrderByDescending(i => i.SiteName).ToList();
break;
case "lastupdated":
UserList = UserList.OrderByDescending(i => i.LastUpdatedDate).ToList();
break;
default:
UserList = UserList.OrderByDescending(i => i.LastUpdatedDate).ToList();
break;
}
}
else
{
switch (filter.Sorting)
{
case "UserName":
UserList = UserList.OrderByDescending(i => i.UserName).ToList();
break;
case "SiteName":
UserList = UserList.OrderByDescending(i => i.SiteName).ToList();
break;
case "lastupdated":
UserList = UserList.OrderByDescending(i => i.LastUpdatedDate).ToList();
break;
default:
UserList = UserList.OrderByDescending(i => i.LastUpdatedDate).ToList();
break;
}
}
#endregion
int UserListCount = UserList.Count();
int pages = UserListCount / filter.PageSize + ((UserListCount % filter.PageSize > 0) ? 1 : 0);
UserListReturnVM result = new UserListReturnVM();
result.Pages = pages;
result.Users = UserList.Skip((filter.Page - 1) * filter.PageSize).Take(filter.PageSize).ToList();
return(Content(HttpStatusCode.OK, result));
}
catch (Exception ex)
{
Log.Error("There was an unexpected error while filtering a list of Orders.", ex);
return(Content(HttpStatusCode.InternalServerError, "There was an unexpected error while filtering a list of Orders."));
}
}
public IActionResult PutUserData([FromBody] User user)
{
var response = new SingleModelResponse <UserListVM>() as ISingleModelResponse <UserListVM>;
var result = new UserListVM();
try
{
if (ModelState.IsValid)
{
var details = _userService.GetUserById(user.userid);
if (details == null)
{
response.StatusCode = (int)HttpStatusCode.InternalServerError;
response.Success = "N";
response.Message = "Data does not exists.";
}
else
{
details.branchid = user.branchid;
details.name = user.name;
details.email = user.email;
details.telno = user.telno;
details.address = user.address;
details.username = user.username;
details.password = user.password;
details.lastupdateddate = user.lastupdateddate;
details.lastupdatedby = user.lastupdatedby;
details.nactive = user.nactive;
details.usertypeid = user.usertypeid;
var IsSuccess = _userService.UpdateUserData(details);
if (IsSuccess)
{
result = _userService.GetUserListsById(details.userid);
}
else
{
result = null;
}
response.StatusCode = (int)HttpStatusCode.OK;
response.Success = "Y";
response.Message = "Save data successful.";
response.Data = result;
}
}
else
{
response.StatusCode = (int)HttpStatusCode.InternalServerError;
response.Success = "N";
response.Message = "Invalid entry.";
}
}
catch (Exception ex)
{
response.StatusCode = (int)HttpStatusCode.InternalServerError;
response.Success = "N";
response.Message = ex.Message;
}
return(response.ToHttpResponse());
}
public async Task <ResultObject> GetUserList()
{
try
{
using (var sqlcon = new NpgsqlConnection("Server = localhost; Username = postgres; Password = sa; Database = elocare;"))
{
sqlcon.Open();
using (NpgsqlDataAdapter dap = new NpgsqlDataAdapter("fn_users", sqlcon))
{
DataSet dsActiveUsers = new DataSet();
dap.SelectCommand.CommandType = CommandType.StoredProcedure;
dap.SelectCommand.Parameters.Add(new NpgsqlParameter("@onlyactive", true));
dap.Fill(dsActiveUsers);
List <UserListVM> UserList = new List <UserListVM>();
if (dsActiveUsers.Tables[0].Rows.Count > 0)
{
_result[ResultKey.Success] = true;
_result[ResultKey.Message] = Message.Success;
foreach (DataRow x in dsActiveUsers.Tables[0].Rows)
{
UserListVM objCP = new UserListVM();
objCP.UserId = Convert.ToInt32(x.ItemArray[0]);
objCP.FirstName = Convert.ToString(x.ItemArray[1]);
UserList.Add(objCP);
}
_result[ResultKey.UserList] = UserList;
}
else
{
_result[ResultKey.Success] = true;
_result[ResultKey.Message] = Message.Success;
_result[ResultKey.UserList] = UserList;
}
}
sqlcon.Close();
}
//using (var sqlConnection = new SqlConnection(ConnectionString))
//{
// await sqlConnection.OpenAsync();
// using (SqlDataAdapter dap = new SqlDataAdapter("sp_GetUserList", sqlConnection))
// {
// DataSet dsUserList = new DataSet();
// dap.SelectCommand.CommandType = CommandType.StoredProcedure;
// dap.Fill(dsUserList);
// List<UserListVM> UserList = new List<UserListVM>();
// if (dsUserList.Tables[0].Rows.Count > 0)
// {
// _result[ResultKey.Success] = true;
// _result[ResultKey.Message] = Message.Success;
// foreach (DataRow x in dsUserList.Tables[0].Rows)
// {
// UserListVM objCP = new UserListVM();
// objCP.UserId = Convert.ToInt32(x["UserId"]);
// objCP.FirstName = Convert.ToString(x["FirstName"]);
// UserList.Add(objCP);
// }
// _result[ResultKey.UserList] = UserList;
// }
// else
// {
// _result[ResultKey.Success] = true;
// _result[ResultKey.Message] = Message.Success;
// _result[ResultKey.UserList] = UserList;
// }
// }
// sqlConnection.Close();
//}
return(_result);
}
catch (Exception ex)
{
_result[ResultKey.Success] = false;
_result[ResultKey.Message] = ex.Message;
throw ex;
}
}
