public ActionResult Filter(InvoiceListModel postModel) { PopulateSecurityExtended(); int securityProfileId = SecurityExtended.SecurityProfileId; var permissionList = _sharedFunctions.GetSecuritySettings(securityProfileId, (int)SecurityCatEnum.RequireService, null); if (TempData["Equipment"] == null) { return(null); } InvoiceListModel invoiceListModel = new InvoiceListModel(); int locationId = SecurityExtended.LocationId.Value; string equipment = TempData["Equipment"].ToString(); string filter = postModel.TextFilter; string filterColumn = postModel.SelectedColumn; string filterExpression = ""; if (!string.IsNullOrEmpty(filter.Trim())) { filterExpression = filterColumn + " like '" + filter + "%'"; } invoiceListModel.DataTableMoveHistory = GetTankMoveHistory(locationId, equipment, filterExpression); invoiceListModel.DataTableEquipmentInfo = GetEquipmentInfo(equipment); invoiceListModel.DataTableEquipmentProduct = GetEquipmentProduct(equipment); invoiceListModel.DataTableInvoiceHistory = GetInvoiceHistory(equipment); invoiceListModel.HfShowResult = "true"; invoiceListModel.TextSearch = equipment; return(View("Index", invoiceListModel));; }
// GET: /InvoiceList/ public ActionResult Index() { PopulateSecurityExtended(); int securityProfileId = SecurityExtended.SecurityProfileId; var permissionList = _sharedFunctions.GetSecuritySettings(securityProfileId, (int)SecurityCatEnum.RequireService, null); InvoiceListModel invoiceListModel = new InvoiceListModel(); invoiceListModel.DataTableMoveHistory = new DataTable(); invoiceListModel.DataTableEquipmentInfo = new DataTable(); invoiceListModel.DataTableEquipmentProduct = new DataTable(); invoiceListModel.DataTableInvoiceHistory = new DataTable(); invoiceListModel.HfShowResult = "false"; return(View(invoiceListModel)); }
public ActionResult Search(InvoiceListModel postModel) { PopulateSecurityExtended(); if (string.IsNullOrEmpty(postModel.TextSearch)) { return(RedirectToAction("Index")); } InvoiceListModel invoiceListModel = new InvoiceListModel(); int locationId = SecurityExtended.LocationId.Value; string equipment = postModel.TextSearch; invoiceListModel.DataTableMoveHistory = GetTankMoveHistory(locationId, equipment, ""); invoiceListModel.DataTableEquipmentInfo = GetEquipmentInfo(equipment); invoiceListModel.DataTableEquipmentProduct = GetEquipmentProduct(equipment); invoiceListModel.DataTableInvoiceHistory = GetInvoiceHistory(equipment); TempData["Equipment"] = equipment; invoiceListModel.HfShowResult = "true"; return(View("Index", invoiceListModel)); }