public List <BindSearchGrid> GetSearchResult() { List <BindSearchGrid> objgriddata = new List <BindSearchGrid>(); try { var ticketdata = (from ticket in _auditToolContext.TicketsViaSSIS join hrdata in _auditToolContext.HROCRoster on ticket.CloseUserId.Substring(0, 7) equals hrdata.Employee34IdLowerCase join Category in _auditToolContext.Category on hrdata.JobCdDescHomeCurr equals Category.CatgDescription select new { ticket.TicketCode, hrdata.JobCdDescHomeCurr, ticket.Category, ticket.SubCategory, ticket.CloseUserId, hrdata.EmployeeFullName, ticket.ClosedDateTime, ticket.Topic } ).ToList(); foreach (var t in ticketdata) { BindSearchGrid tempItem = new BindSearchGrid { TicketNumber = t.TicketCode, ServiceGroup = t.JobCdDescHomeCurr, Category = t.Category, Subcategory = t.SubCategory, UserThreeFourID = t.CloseUserId, AssignedTo = t.EmployeeFullName, ClosedDateTime = t.ClosedDateTime, Topic = t.Topic }; objgriddata.Add(tempItem); } } catch (Exception ex) { _log.WriteErrorLog(new LogItem { ErrorType = "Error", ErrorSource = "SearchController_GetSearchResult", ErrorDiscription = ex.InnerException != null ? ex.InnerException.ToString() : ex.Message }); } return(objgriddata); }
public IActionResult Index(BindSearchGrid objBindSearchGrid) { try { if (isAuditor) { return(RedirectToAction("Details", objBindSearchGrid)); } } catch (Exception ex) { _log.WriteErrorLog(new LogItem { ErrorType = "Error", ErrorSource = "SearchController_Index", ErrorDiscription = ex.InnerException != null ? ex.InnerException.ToString() : ex.Message }); } return(RedirectToAction("Index", "Home")); }
public IActionResult Details(BindSearchGrid objBindSearchGrid) { if (isAuditor) { try { var draw = HttpContext.Request.Form["draw"].FirstOrDefault(); // Skip number of Rows count var start = Request.Form["start"].FirstOrDefault(); // Paging Length 10,20 var length = Request.Form["length"].FirstOrDefault(); //Paging Size (10, 20, 50,100) int pageSize = length != null?Convert.ToInt32(length) : 0; int skip = start != null?Convert.ToInt32(start) : 0; int recordsTotal = 0; var customerData = GetSearchResult(); //total number of rows counts recordsTotal = customerData.Count; //Paging var jsonData = customerData.Skip(skip).Take(pageSize).ToList(); //Returning Json Data return(Json(new { draw, recordsFiltered = recordsTotal, recordsTotal, data = jsonData })); } catch (Exception ex) { _log.WriteErrorLog(new LogItem { ErrorType = "Error", ErrorSource = "SearchController_GetSearchDetails", ErrorDiscription = ex.InnerException != null ? ex.InnerException.ToString() : ex.Message }); } } return(RedirectToAction("Index", "Home")); }
public IActionResult Details() { BindSearchGrid objBindSearchGrid = new BindSearchGrid(); return(View("Details", objBindSearchGrid)); }