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