public JsonResult GetSearchResults(string searchQuery)
{
SATConn context = new SATConn();
try
{
var companySearchQuery = "EXEC DBO.SearchCompany @SearchQuery = '" + searchQuery + "'";
var contactSearchQuery = "EXEC DBO.SearchContact @SearchQuery = '" + searchQuery + "'";
var companies = context.Database.SqlQuery <Company>(companySearchQuery);
var contacts = context.Database.SqlQuery <Contact>(contactSearchQuery);
var result = new
{
success = true,
companies = companies,
contacts = contacts
};
return(Json(result));
}
catch (Exception ex)
{
var result = new
{
success = false,
error = ex
};
return(Json(result));
}
}
