public async Task <IActionResult> Details(int id, string returnUrl = null) { ViewData["ReturnUrl"] = returnUrl; var equipment = await _context .Equipments .Include(t => t.EquipmentType) .Include(r => r.Categor) .Include(ren => ren.Rental) .AsNoTracking() .FirstOrDefaultAsync(x => x.EquipmentID == id); var model = new EquipmentListModel { Id = equipment.EquipmentID, EquipmentName = equipment.EquipmentName, EquipmentTypeID = equipment.EquipmentType.TypeID, EquipmentTypeText = equipment.EquipmentType.TypeName, CategorID = equipment.Categor.Id, CategorName = equipment.Categor.Name, RentID = equipment.Rental != null ? equipment.Rental.RentalID : default(int?), IsRented = equipment.Rental != null ? true : false }; return(View(model)); }
public EquipmentListModel GetEquipmentByPagination(EquipmentQueryModel queryModel) { StringBuilder where = new StringBuilder(); if (!string.IsNullOrEmpty(queryModel.QueryArgs)) { where.Append($" and (`EquipmentName` like '%{queryModel.QueryArgs}%'"); where.Append($" or `LastMaintenanceNames` like '%{queryModel.QueryArgs}%'"); where.Append($" or `FixedAssetId` like '%{queryModel.QueryArgs}%' ) "); } StringBuilder sqlBuilder1 = new StringBuilder(); sqlBuilder1.Append($"SELECT * FROM `ttl`.`ttl_engineering_equipment` WHERE isdelete=0 {where.ToString()} LIMIT {queryModel.StartIndex},{queryModel.PageSize}; "); StringBuilder sqlBuilder2 = new StringBuilder(); sqlBuilder2.Append($"SELECT COUNT(1) FROM `ttl`.`ttl_engineering_equipment` WHERE isdelete=0 {where.ToString()};"); EquipmentListModel resultModel = new EquipmentListModel(); using (var gridReader = _dbContext.QueryMultiple($"{sqlBuilder1.ToString()}{sqlBuilder2.ToString()}")) { resultModel.EquipmentList = gridReader.Read <EquipmentModel>().ToList(); resultModel.TotalCount = gridReader.Read <int>().Single(); } resultModel.PageIndex = queryModel.PageIndex; resultModel.PageSize = queryModel.PageSize; resultModel.QueryArgs = queryModel.QueryArgs; return(resultModel); }
public IActionResult List() { EquipmentQueryModel queryModel = new EquipmentQueryModel(); if (!string.IsNullOrEmpty(Request.Query["page"])) { queryModel.PageIndex = Convert.ToInt32(Request.Query["page"]); } if (!string.IsNullOrEmpty(Request.Query["args"])) { queryModel.QueryArgs = Request.Query["args"]; } EquipmentListModel equipmentResult = _equipmentService.GetEquipmentByPagination(queryModel); equipmentResult.MatchQueryArgs(); ViewBag.Equipment = equipmentResult; return(View()); }
public IActionResult Index(DataSourceRequest command) { if (!(bool)SharedData.isEquipmentMenuAccessible) { return(AccessDeniedView()); } ViewBag.FormName = "Equipment"; var model = new EquipmentListModel(); ViewBag.PageSizeDropdown = SelectListHelper.GetPageSizeDropdown(command.PageSize.ToString()); var PagedList = _reportService.GetAllEquipments( keywords: "", page_num: command.Page, page_size: command.PageSize, GetAll: command.PageSize == 0 ? true : false ); model.List = PagedList.List.GetPaged(command.Page, command.PageSize, PagedList.TotalRecords); return(View(model)); }
public IActionResult reciveAddEquipment(EquipmentListModel value) { //add model to db. return(Json(value)); }
public EquipmentListViewModel(Character character, IReadOnlyList <ItemDefinition> itemDefinitions) { Character = character; _equipment = new EquipmentListModel(character, itemDefinitions); }
public IActionResult RunList([FromBody] EquipmentQueryModel queryMode) { EquipmentListModel equipmentResult = _equipmentService.GetEquipmentByPagination(queryMode); return(new JsonResult(equipmentResult)); }