//[ApiExplorerSettings(IgnoreApi = true)] public UsersListResponse GetUsers(string fromDate, string toDate, string searchTerm, int userGroupId = 0, int pageSize = 25, int pageIndex = 1) { UsersListResponse retObj = new UsersListResponse(pageSize < 1 ? 1 : pageSize, pageIndex < 1 ? 1 : pageIndex); try { // set default date range DateTime fromDateTime = DateTime.Now.AddMonths(-3), toDateTime = DateTime.Now; try { toDateTime = Convert.ToDateTime(toDate); } catch { toDateTime = DateTime.Now; } try { fromDateTime = Convert.ToDateTime(fromDate); } catch { fromDateTime = DateTime.Now.AddMonths(-3); } int orderByColIndex = 5; Utility.EnumHelper.DBSortingOrder enSortingOrder = Utility.EnumHelper.DBSortingOrder.Desc; int usersCount; var userList = UserDetailsFacade.GetUsers(DateTime.Parse(fromDateTime.ToShortDateString()), DateTime.Parse(toDateTime.ToShortDateString()), searchTerm, orderByColIndex, enSortingOrder, userGroupId, ((retObj.PageIndex * retObj.PageSize) - retObj.PageSize), retObj.PageSize, out usersCount); retObj.UserList = userList; retObj.TotalRecordCount = usersCount; } catch (Exception exc) { log.Error(exc); } return(retObj); }
/// <summary> /// /// </summary> /// <param name="fromDate"></param> /// <param name="toDate"></param> /// <param name="searchTerm"></param> /// <param name="orderByColIndex"></param> /// <param name="sortingOrder"></param> /// <param name="userGroupId"></param> /// <param name="startRowIndex"></param> /// <param name="pageSize"></param> /// <param name="usersCount"></param> /// <returns></returns> public static List <ServiceEntities.ResponseEntities.UserDTO> GetUsers(DateTime fromDate, DateTime toDate, string searchTerm, int orderByColIndex, Utility.EnumHelper.DBSortingOrder sortingOrder, int userGroupId, int startRowIndex, int pageSize, out int usersCount) { List <ServiceEntities.ResponseEntities.UserDTO> retObj = new List <ServiceEntities.ResponseEntities.UserDTO>(); usersCount = 0; try { DataSet ds = new UserDB(ConfigurationHelper.GPD_Connection).GetUsers(fromDate, toDate, searchTerm, orderByColIndex, sortingOrder.ToString(), userGroupId, startRowIndex, pageSize); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { retObj.Add(new ServiceEntities.ResponseEntities.UserDTO() { UserId = int.Parse(dr["user_id"].ToString()), FirstName = dr["first_name"].ToString(), LastName = dr["last_name"].ToString(), Email = dr["email"].ToString(), FirmName = DBNull.Value.Equals(dr["firmName"]) ? "" : dr["firmName"].ToString(), IsActive = Convert.ToBoolean(dr["active"]), CreatedOn = ((DateTime)dr["CREATE_DATE"]).ToString("o"), }); } } if (ds != null && ds.Tables.Count > 1 && ds.Tables[1].Rows.Count == 1) { int.TryParse(ds.Tables[1].Rows[0][0].ToString(), out usersCount); } } catch (Exception ex) { log.Error("Unable to get users for search term: " + searchTerm, ex); } return(retObj); }