public ResponseModel GetTicketsOnSavedSearch(int SearchParamID) { TicketSaveSearch searchResult = null; ResponseModel objResponseModel = new ResponseModel(); int statusCode = 0; string statusMessage = ""; SearchCaller newSearchMaster = new SearchCaller(); try { string token = Convert.ToString(Request.Headers["X-Authorized-Token"]); Authenticate authenticate = new Authenticate(); var temp = SecurityService.DecryptStringAES(token); authenticate = SecurityService.GetAuthenticateDataFromTokenCache(Cache, SecurityService.DecryptStringAES(token)); searchResult = newSearchMaster.GetTicketsOnSavedSearch(new SearchService(Cache, Db), authenticate.TenantId, authenticate.UserMasterID, SearchParamID); statusCode = searchResult.ticketList.Count > 0 ? (int)EnumMaster.StatusCode.Success : (int)EnumMaster.StatusCode.RecordNotFound; statusMessage = CommonFunction.GetEnumDescription((EnumMaster.StatusCode)statusCode); objResponseModel.Status = true; objResponseModel.StatusCode = statusCode; objResponseModel.Message = statusMessage; objResponseModel.ResponseData = searchResult; } catch (Exception) { throw; } return(objResponseModel); }
/// <summary> /// Get tickets on the saved search params /// </summary> /// <param name="SearchParamID"></param> /// <returns></returns> /// public TicketSaveSearch GetTicketsOnSavedSearch(int TenantID, int UserID, int SearchParamID) { string jsonSearchParams = string.Empty; DataSet ds = new DataSet(); SearchModel searchModel = new SearchModel(); TicketSaveSearch tktSearch = new TicketSaveSearch(); List <SearchResponse> objSearchResult = new List <SearchResponse>(); try { conn.Open(); MySqlCommand cmd = new MySqlCommand("SP_GetSaveSearchByID_UTSM", conn); cmd.Connection = conn; cmd.Parameters.AddWithValue("@SearchParam_ID", SearchParamID); cmd.Parameters.AddWithValue("@searchFor", 2); cmd.CommandType = CommandType.StoredProcedure; MySqlDataAdapter da = new MySqlDataAdapter(); da.SelectCommand = cmd; da.Fill(ds); if (ds != null && ds.Tables[0] != null) { if (ds.Tables[0].Rows.Count > 0) { jsonSearchParams = ds.Tables[0].Rows[0]["SearchParameters"] == DBNull.Value ? string.Empty: Convert.ToString(ds.Tables[0].Rows[0]["SearchParameters"]); } } if (!string.IsNullOrEmpty(jsonSearchParams)) { searchModel = JsonConvert.DeserializeObject <SearchModel>(jsonSearchParams); if (searchModel != null) { searchModel.TenantID = TenantID; searchModel.AssigntoId = UserID; objSearchResult = GetTicketsOnSearch(searchModel); tktSearch.ticketList = objSearchResult; tktSearch.searchParams = jsonSearchParams; } } } catch (Exception ex) { string message = Convert.ToString(ex.InnerException); //throw ex; } finally { if (ds != null) { ds.Dispose(); } conn.Close(); } return(tktSearch); }