public async Task <IActionResult> GetCategories() { var response = new ListModelResponse <CategoryModel>() as IListModelResponse <CategoryModel>; var query = await _categoryService.GetCategoriesAsync(); if (query == null || !query.Any()) { _logger.Warning(MessageTemplate, ProtocolName(), RequestMethod(), TraceIdentifierName(), LoggingEvents.LIST_ITEMS_NOTFOUND, "LIST_ITEMS_NOTFOUND", RequestPath()); response.HasError = true; response.ErrorMessage = "LIST_ITEMS_NOTFOUND"; response.ErrorCode = LoggingEvents.LIST_ITEMS_NOTFOUND; return(response.ToHttpResponse()); } var result = query.Select(x => new CategoryModel() { Id = x.Id, Name = x.Name }); response.Model = result; response.Message = string.Format("Total of records: {0}", response.Model.Count()); _logger.Information(MessageTemplate, ProtocolName(), RequestMethod(), TraceIdentifierName(), LoggingEvents.LIST_ITEMS, "LIST_ITEMS", RequestPath()); return(response.ToHttpResponse()); }
public async Task <IActionResult> GetBooks(int?pageSize = 25, int?pageNumber = 1, string name = null) { var response = new ListModelResponse <BookListModel>() as IListModelResponse <BookListModel>; try { response.PageSize = (int)pageSize; response.PageNumber = (int)pageNumber; var query = await _bookService.GetBooksAsync(response.PageSize, response.PageNumber, name); if (!query.Any()) { _logger.Warning(MessageTemplate, ProtocolName(), RequestMethod(), TraceIdentifierName(), LoggingEvents.LIST_ITEMS_NOTFOUND, "LIST_ITEMS_NOTFOUND", RequestPath()); response.HasError = true; response.ErrorMessage = "LIST_ITEMS_NOTFOUND"; response.ErrorCode = LoggingEvents.LIST_ITEMS_NOTFOUND; return(response.ToHttpResponse()); } var result = query.Select(x => new BookListModel() { Isbn = x.Isbn, Publisher = x.Publisher, Stock = x.Stock, Language = x.Language, AuthorModel = new AuthorModel() { Id = _authorService.GetAuthorByIdAsync(x.AuthorId).Result.Id, FirstName = _authorService.GetAuthorByIdAsync(x.AuthorId).Result.FirstName, LastName = _authorService.GetAuthorByIdAsync(x.AuthorId).Result.LastName }, CategoryModel = new CategoryModel() { Id = _categoryService.GetCategoryByIdAsync(x.CategoryId).Result.Id, Name = _categoryService.GetCategoryByIdAsync(x.CategoryId).Result.Name, }, Name = x.Name, Published = x.Published, CreatedDate = x.CreatedDate, Id = x.Id, Description = x.Description, Hardcover = x.Hardcover, ProductDimensions = x.ProductDimensions }).ToList(); response.Model = result; response.Message = string.Format("Total of records: {0}", response.Model.Count()); } catch (Exception ex) { response.HasError = true; response.ErrorMessage = ex.Message; } _logger.Information(MessageTemplate, ProtocolName(), RequestMethod(), TraceIdentifierName(), LoggingEvents.LIST_ITEMS, "LIST_ITEMS", RequestPath(), RequestPathString()); return(response.ToHttpResponse()); }
public IActionResult GetCuisinesV2(ResourceParameter parameters) { var response = new ListModelResponse <MainMenuDto>() as IListModelResponse <MainMenuDto>; //throw new InvalidOperationException("This is an unhandled exception"); //throw new ECafeException("error occured"); if (!_propertyMappingService.ValidMappingExistsFor <MainMenuDto, MainMenu>(parameters.OrderBy)) { logger.LogError($"Invalid mapping requested in {this.GetType().Name} Method Name"); return(response.ToErrorResponse("Invalid mapping requested", HttpStatusCode.BadRequest)); } if (!typeHelperService.TypeHasProperties <MainMenuDto>(parameters.Fields)) { return(response.ToErrorResponse("Invalid properties name requested", HttpStatusCode.BadRequest)); } var results = _mainMenuGetService.GetAll(parameters); //***Create pagination header var paginationMetadata = ResourceUri <MainMenu> .CreatePaginationHeader(parameters, results, urlHelper, "GetCuisines"); Response.Headers.Add("X-Pagination", Newtonsoft.Json.JsonConvert.SerializeObject(paginationMetadata)); //***Mapping Entity to Dto var medicineTypes = AutoMapper.Mapper.Map <IEnumerable <MainMenuDto> >(results); response.ShapeModel = medicineTypes.ShapeData(parameters.Fields); response.Model = new List <MainMenuDto>(); response.Message = $"Total of records: {response.ShapeModel.Count()}"; response.PageSize = parameters.PageSize; response.PageNumber = parameters.PageNumber; return(response.ToHttpResponse()); }
public async Task <IActionResult> GetRegistrations([FromQuery] int eventId) { var response = new ListModelResponse <EventRegistration>() as IListModelResponse <EventRegistration>; try { if (eventId < 1) { throw new Exception("Athlete Id is null"); } response.Model = await Task.Run(() => { IEnumerable <EventRegistration> regs = _context.GetAll(eventId); if (regs == null) { throw new Exception("No registrations"); } return(regs); }); } catch (Exception ex) { response.DidError = true; response.ErrorMessage = ex.Message; } return(response.ToHttpResponse()); }
public async Task <IActionResult> GetTestStepsAsync(int projectId, int scenarioId, int subscenarioId) { var response = new ListModelResponse <TestStepViewModel>(); try { // response.PageSize = (Int32)pageSize; // response.PageNumber = (Int32)pageNumber; // var subscenariosDataModel = await _subscenarioRepository // .GetSubScenarios(projectId, scenarioId); var teststepsDataModel = await _teststepRepository .GetTestStepsAsync(projectId, scenarioId, subscenarioId); response.Model = teststepsDataModel.Select(item => item.ToViewModel()); response.Message = String.Format("Total of records: {0}", response.Model.Count()); } catch (Exception ex) { response.DidError = true; response.ErrorMessage = ex.Message; } return(response.ToHttpResponse()); }
public IActionResult GetAll(int?pageSize = 10, int?pageNumber = 1, string q = null) { var response = new ListModelResponse <UserGridResource> { PageNumber = (int)pageNumber, PageSize = (int)pageSize }; var query = _userRepository.Query().Where(x => x.IsActive) .Include(x => x.UserRoles).ThenInclude(ur => ur.Role) .Skip((response.PageNumber - 1) * response.PageSize) .Take(response.PageSize).ToList(); if (!string.IsNullOrEmpty(q) && query.Any()) { q = q.ToLower(); query = query.Where(x => x.FullName.ToLower().Contains(q.ToLower()) || x.Email.ToLower().Contains(q.ToLower()) || x.Phone.ToLower().Contains(q.ToLower())).ToList(); } try { response.Model = _mapper.Map <IEnumerable <User>, IEnumerable <UserGridResource> >(query); response.Message = string.Format("Total of records: {0}", response.Model.Count()); } catch (Exception ex) { response.DidError = true; response.ErrorMessage = ex.Message; } return(response.ToHttpResponse()); }
public async Task <IHttpActionResult> GetAssigned(int id = 0, int page = 0, String namefilter = "", String serverNamefilter = "", String versionFilter = "", String sqlversions = "") { InstanceRepository repository = new InstanceRepository(new MsSqlMonitorEntities()); IListModelResponse <InstanceViewModel> response = new ListModelResponse <InstanceViewModel>(); try { PaginatedInstances data = await repository.GetAssignedInstancesAsync(id, page, namefilter, serverNamefilter, versionFilter, sqlversions); response.Model = data.List.Select(i => i.ToViewModel()); response.PagesCount = data.PageCount; response.PageNumber = data.Page; response.PageSize = data.PageSize; response.Versions = data.Versions; } catch (Exception e) { response.DidError = true; response.ErrorMessage = e.Message; } return(response.ToHttpResponse(Request)); }
public async Task <IActionResult> GetUsersAsync() { var response = new ListModelResponse <UserViewModel>(); try { // response.PageSize = (Int32)pageSize; // response.PageNumber = (Int32)pageNumber; var usersDataModel = await _userRepository .GetUsers(); response.Model = usersDataModel.Select(item => item.ToViewModel()); response.Message = String.Format("Total of records: {0}", response.Model.Count()); } catch (Exception ex) { response.DidError = true; response.ErrorMessage = ex.Message; } return(response.ToHttpResponse()); }
public IActionResult Get() { int pageNumber = 1; int pageSize = 10; var response = new ListModelResponse <UserType>() as IListModelResponse <UserType>; try { if (ModelState.IsValid) { var data = _userType.GetAllUserTypes(); int skip = (pageNumber - 1) * pageSize; int totalRecordCount = data.Count(); int pageCount = totalRecordCount > 0 ? (int)Math.Ceiling(totalRecordCount / (double)pageSize) : 0; response.StatusCode = (int)HttpStatusCode.OK; response.Count = data.Count(); response.Success = "Y"; response.PageNumber = pageNumber; response.PageSize = pageSize; response.Data = data.ToList(); } } catch (Exception ex) { response.StatusCode = (int)HttpStatusCode.InternalServerError; response.Message = ex.Message; response.Count = 0; response.Success = "N"; } return(response.ToHttpResponse()); }
public async Task <IActionResult> GetEventByRoute([FromQuery] int routeId) { var response = new ListModelResponse <Event>() as IListModelResponse <Event>; try { if (routeId < 1) { throw new Exception("User Id is null"); } response.Model = await Task.Run(() => { IEnumerable <Event> evnt = _context.GetEventByRoute(routeId); if (evnt == null) { throw new Exception("Event does not Exist"); } return(evnt); }); } catch (Exception ex) { response.DidError = true; response.ErrorMessage = ex.Message; } return(response.ToHttpResponse()); }
public IActionResult DeleteUser(int id, int userId) { var response = new ListModelResponse <UserListVM>() as IListModelResponse <UserListVM>; try { var data = _userService.GetUserById(id); if (data == null) { response.StatusCode = (int)HttpStatusCode.InternalServerError; response.Message = "Something went wrong when deleting data."; response.Success = "N"; } else { data.nactive = 0; _userService.Update(data); _userService.Commit(); response.Message = "Data successfully deleted."; response.StatusCode = (int)HttpStatusCode.OK; response.Success = "Y"; response.Data = _userService.GetAllUserLists(); } } catch (Exception ex) { response.StatusCode = (int)HttpStatusCode.InternalServerError; response.Message = ex.Message; response.Success = "N"; } return(response.ToHttpResponse()); }
public IActionResult GetAll(int?pageSize, int?pageNumber, string q = null) { var response = new ListModelResponse <CategoryBooking> { PageSize = (int)pageSize, PageNumber = (int)pageNumber }; var query = _cateBookingRepository.Query().Skip((response.PageNumber - 1) * response.PageSize) .Take(response.PageSize).ToList(); if (!string.IsNullOrEmpty(q) && query.Any()) { q = q.ToLower(); query = query.Where(x => x.BookingName.ToLower().Contains(q.ToLower())).ToList(); } try { response.Model = _mapper.Map(query, response.Model); response.Message = string.Format("Total of records: {0}", response.Model.Count()); } catch (Exception ex) { response.DidError = true; response.ErrorMessage = ex.Message; _logger.LogError(ex.InnerException.ToString()); } return(response.ToHttpResponse()); }
public async Task <IActionResult> GetClubMembers([FromQuery] int clubId) { var response = new ListModelResponse <ClubMember>() as IListModelResponse <ClubMember>; try { if (clubId < 1) { throw new Exception("Club Id is null"); } response.Model = await Task.Run(() => { IEnumerable <ClubMember> member = _context.GetMembers(clubId); if (member == null) { throw new Exception("Club Member does not Exist"); } return(member); }); } catch (Exception ex) { response.DidError = true; response.ErrorMessage = ex.Message; } return(response.ToHttpResponse()); }
public async Task <IActionResult> GetUserClubs([FromQuery] string userId) { var response = new ListModelResponse <Club>() as IListModelResponse <Club>; try { if (userId == null) { throw new Exception("User Id is null"); } response.Model = await Task.Run(() => { IEnumerable <Club> clubs = _context.GetUserClubs(userId); if (clubs == null) { throw new System.ArgumentNullException("Clubs do not does not Exist"); } return(clubs); }); } catch (Exception ex) { response.DidError = true; response.ErrorMessage = ex.Message; } return(response.ToHttpResponse()); }
public async Task <IActionResult> GetPackResultsAsync(int packId, int projectId, DateTime fromDate, DateTime toDate) { var response = new ListModelResponse <PackResultViewModel>(); List <PackResultViewModel> viewModel = new List <PackResultViewModel>(); try { var packResultsDataModel = await _packResultRepository.GetPackResults(packId, projectId, fromDate, toDate); List <String> tstGroupIds = packResultsDataModel.Select(x => x.TestGroupId).ToList(); var lstPieChartData = await _packResultRepository.GetPieChartDetails(packId.ToString(), tstGroupIds); foreach (var pckresults in packResultsDataModel) { var pieChartData = lstPieChartData.FirstOrDefault(x => x.TestGroupId == pckresults.TestGroupId); viewModel.Add(pckresults.ToViewModel(pieChartData)); } response.Model = viewModel; //.Select(item => item.ToViewModel()) //.ToListAsync(); response.Message = String.Format("Total of records: {0}", response.Model.Count()); } catch (Exception ex) { response.DidError = true; response.ErrorMessage = ex.Message; } return(response.ToHttpResponse()); }
public async Task <IActionResult> GetProducts(int?pageSize = 10, int?pageNumber = 1, string name = null) { var response = new ListModelResponse <ProductViewModel>() as IListModelResponse <ProductViewModel>; try { response.PageSize = (int)pageSize; response.PageNumber = (int)pageNumber; response.Model = await Task.Run(() => { var data = ProductRepository .GetProducts(response.PageSize, response.PageNumber, name).ToList(); return(ProductRepository .GetProducts(response.PageSize, response.PageNumber, name) .Select(item => item.ToViewModel()) .ToList()); }); response.Message = string.Format("Total of records: {0}", response.Model.Count()); } catch (Exception ex) { response.DidError = true; response.ErrorMessage = ex.Message; } return(response.ToHttpResponse()); }
public async Task <IActionResult> GetUserRoutes([FromQuery] string userId) { var response = new ListModelResponse <Route>() as IListModelResponse <Route>; try { if (userId == null) { throw new Exception("User Id is null"); } response.Model = await Task.Run(() => { IEnumerable <Route> routes = _context.GetUserRoutes(userId); if (routes == null) { throw new Exception("There are no routes"); } return(routes); }); } catch (Exception ex) { response.DidError = true; response.ErrorMessage = ex.Message; } return(response.ToHttpResponse()); }
public IActionResult GetAll(int page, string keyword, int pageSize = 3) { var model = _productCategoryService.GetAll(keyword); int totalRow = model.Count(); var query = model.OrderBy(x => x.ID).Skip(page * pageSize).Take(pageSize); var responseData = Mapper.Map <IEnumerable <ProductCategoryViewModel> >(query); var response = new ListModelResponse <ProductCategoryViewModel>() as IListModelResponse <ProductCategoryViewModel>; try { response.TotalRows = totalRow; //rows per page response.PageSize = query.Count(); response.PageNumber = page; response.TotalPages = (int)Math.Ceiling((double)totalRow / pageSize); response.Model = responseData; response.Message = String.Format("Total of records: {0}", response.Model.Count()); } catch (Exception ex) { response.DidError = true; response.ErrorMessage = ex.Message; } return(response.ToHttpResponse()); }
public async Task <IActionResult> GetPurchaseOrderStatusesAsync(Int32?pageSize = 10, Int32?pageNumber = 1, String name = null) { var response = new ListModelResponse <PurchaseOrderStatusViewModel>() as IListModelResponse <PurchaseOrderStatusViewModel>; try { response.PageSize = (Int32)pageSize; response.PageNumber = (Int32)pageNumber; response.Model = await Task.Run(() => { return(_RESTfulAPI_Repository .GetPurchaseOrderStatuses(response.PageSize, response.PageNumber, name) .Select(item => item.ToViewModel()) .ToList()); }); response.Info = String.Format("Total of records: {0}", response.Model.Count()); } catch (Exception ex) { response.DidError = true; response.ErrorMessage = ex.Message; } return(response.ToHttpResponse()); }
public async Task <IActionResult> GetClubEvents([FromQuery] int clubId) { var response = new ListModelResponse <Event>() as IListModelResponse <Event>; try { if (clubId <= 0) { throw new Exception("Club Id is null"); } response.Model = await Task.Run(() => { IEnumerable <Event> evnts = _context.GetClubEvents(clubId);; if (evnts == null) { throw new Exception("No Events"); } return(evnts); }); } catch (Exception ex) { response.DidError = true; response.ErrorMessage = ex.Message; } return(response.ToHttpResponse()); }
public IActionResult GetAll(int?pageSize, int?pageNumber, string q = null) { var response = new ListModelResponse <AreaResource> { PageSize = (int)pageSize, PageNumber = (int)pageNumber }; var query = _areaRepository.Query().Include(x => x.Functions) .Skip((response.PageNumber - 1) * response.PageSize) .Take(response.PageSize).ToList(); if (!string.IsNullOrEmpty(q) && query.Any()) { q = q.ToLower(); query = query.Where(x => x.AreaName.ToLower().Contains(q.ToLower()) || x.CodeArea.ToLower().Contains(q.ToLower())).ToList(); } try { response.Model = _mapper.Map(query, response.Model); response.Message = string.Format("Total of records: {0}", response.Model.Count()); } catch (Exception ex) { response.DidError = true; response.ErrorMessage = ex.Message; } return(response.ToHttpResponse()); }
public async Task <IActionResult> GetAthleteEventRuns([FromQuery] int athleteId) { var response = new ListModelResponse <Run>() as IListModelResponse <Run>; try { if (athleteId < 1) { throw new Exception("Athlete Id is missing"); } response.Model = await Task.Run(() => { IEnumerable <Run> run = _context.GetAthleteEventRuns(athleteId); if (run == null) { throw new Exception("Run does not exist"); } return(run); }); } catch (Exception ex) { response.DidError = true; response.ErrorMessage = ex.Message; } return(response.ToHttpResponse()); }
public async Task <IActionResult> GetMenuDetailBySubMenu(int id) { var response = new ListModelResponse <MenuDetailDto>() as IListModelResponse <MenuDetailDto>; response.Model = await _menuDetailService.GetMenuDetailByAsync(id);; response.Message = $"{ApiMessages.TotalRecords} {response.Model.Count()}"; return(response.ToHttpResponse()); }
public async Task <IActionResult> GetLogs(int?pageSize = 10, int?pageNumber = 1, string name = null) { var response = new ListModelResponse <LogListModel>() as IListModelResponse <LogListModel>; try { response.PageSize = (int)pageSize; response.PageNumber = (int)pageNumber; var query = await _loggingService.GetLogsAsync(response.PageSize, response.PageNumber, name); var result = query.Select(x => new LogListModel() { Id = x.Id, MessageTemplate = x.MessageTemplate, TimeStamp = x.TimeStamp, Message = x.Message, Exception = x.Exception, Level = x.Level, LogEvent = x.LogEvent, Properties = x.Properties, }).ToList(); response.Model = result; response.Message = string.Format("Total of records: {0}", response.Model.Count()); if (!response.Model.Any()) { _logger.Warning(MessageTemplate, ProtocolName(), RequestMethod(), TraceIdentifierName(), LoggingEvents.LIST_ITEMS_NOTFOUND, "LIST_ITEMS_NOTFOUND", RequestPath()); response.HasError = true; response.ErrorMessage = "LIST_ITEMS_NOTFOUND"; response.ErrorCode = LoggingEvents.LIST_ITEMS_NOTFOUND; return(response.ToHttpResponse()); } } catch (Exception ex) { _logger.Warning(MessageTemplate, ProtocolName(), RequestMethod(), TraceIdentifierName(), LoggingEvents.METHOD_ERROR, "METHOD_ERROR", RequestPath()); response.HasError = true; response.ErrorMessage = ex.Message; } return(response.ToHttpResponse()); }
public async Task <IActionResult> SearchAllMenus(string searchText) { var response = new ListModelResponse <MenuDetailDto>() as IListModelResponse <MenuDetailDto>; var entity = await _menuDetailService.SearchByMenuName(searchText); response.Model = entity; response.Message = $"{ApiMessages.TotalRecords} {response.Model.Count()}"; return(response.ToHttpResponse()); }
public async Task <IActionResult> GetAllSubMenuWithCount() { var response = new ListModelResponse <SubMenuResultSet>() as IListModelResponse <SubMenuResultSet>; var entity = await _menuService.GetSubMenuWithSubMenuDetailCount(); response.Model = entity; response.Message = $"{ApiMessages.TotalRecords} {response.Model.Count()}"; return(response.ToHttpResponse()); }
public async Task <IActionResult> GetMenus(Int32?pageSize = 100, Int32?pageNumber = 1, String name = null) { var response = new ListModelResponse <MenuDto>() as IListModelResponse <MenuDto>;; response.PageSize = (Int32)pageSize; response.PageNumber = (Int32)pageNumber; response.Model = await _menuService.GetMenuAsync(response.PageSize, response.PageNumber, name); response.Message = $"Total of records: {response.Model.Count()}"; return(response.ToHttpResponse()); }
public async Task <IActionResult> GetOrderDetails(Int32?pageSize = 10, Int32?pageNumber = 1, String name = null) { var response = new ListModelResponse <OrderDto>() as IListModelResponse <OrderDto>; response.PageSize = (Int32)pageSize; response.PageNumber = (Int32)pageNumber; response.Model = await _orderService.GetOrderAsync(response.PageSize, response.PageNumber, name); response.Message = $"{ApiMessages.TotalRecords} {response.Model.Count()}"; return(response.ToHttpResponse()); }
public async Task <IActionResult> GetMenuDetails(Int32?pageSize = 100, Int32?pageNumber = 1, String name = null) { // throw new InvalidOperationException("This is an unhandled exception"); var response = new ListModelResponse <MenuDetailDto>() as IListModelResponse <MenuDetailDto>; response.PageSize = (Int32)pageSize; response.PageNumber = (Int32)pageNumber; response.Model = await _menuDetailService.GetMenuDetailAsync(response.PageSize, response.PageNumber, name); response.Message = $"{ApiMessages.TotalRecords} {response.Model.Count()}"; return(response.ToHttpResponse()); }
public async Task <IActionResult> GetBooksByAuthorId(int authorId) { var response = new ListModelResponse <Book>() as IListModelResponse <Book>; var result = await _bookService.GetBooksByAuthorIdAsync(authorId); if (result == null || !result.Any()) { _logger.Warning(MessageTemplate, ProtocolName(), RequestMethod(), TraceIdentifierName(), LoggingEvents.LIST_ITEMS_NOTFOUND, "LIST_ITEMS_NOTFOUND", RequestPath()); response.HasError = true; response.ErrorMessage = "LIST_ITEMS_NOTFOUND"; response.ErrorCode = LoggingEvents.LIST_ITEMS_NOTFOUND; return(response.ToHttpResponse()); } response.Model = result; response.Message = string.Format("Total of records: {0}", response.Model.Count()); _logger.Information(MessageTemplate, ProtocolName(), RequestMethod(), TraceIdentifierName(), LoggingEvents.LIST_ITEMS, "LIST_ITEMS", RequestPath()); return(response.ToHttpResponse()); }