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