public ResponseModel GetDashBoardTicketsOnSavedSearch(int SearchParamID)
{
DashBoardSavedSearch searchResult = null;
ResponseModel objResponseModel = new ResponseModel();
int statusCode = 0;
string statusMessage = "";
DashBoardCaller dCaller = new DashBoardCaller();
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 = dCaller.GetDashBoardTicketsOnSavedSearch(new DashBoardService(Cache, Db), authenticate.TenantId, authenticate.UserMasterID, SearchParamID);
statusCode = searchResult.DashboardTicketList.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);
}
public DashBoardSavedSearch GetDashBoardTicketsOnSavedSearch(int TenantID, int UserID, int SearchParamID)
{
string jsonSearchParams = string.Empty;
DataSet ds = new DataSet();
SearchModelDashBoard searchModel = new SearchModelDashBoard();
DashBoardSavedSearch dbsavedsearch = new DashBoardSavedSearch();
List <SearchResponseDashBoard> objSearchResult = new List <SearchResponseDashBoard>();
try
{
conn = Db.Connection;
MySqlCommand cmd = new MySqlCommand("SP_GetSaveSearchByID_UTSM", conn);
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@SearchParam_ID", SearchParamID);
cmd.Parameters.AddWithValue("@searchFor", 1);
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 <SearchModelDashBoard>(jsonSearchParams);
if (searchModel != null)
{
searchModel.TenantID = TenantID;
searchModel.curentUserId = UserID;
objSearchResult = GetDashboardTicketsOnSearch(searchModel);
dbsavedsearch.dbsearchParams = jsonSearchParams;
dbsavedsearch.DashboardTicketList = objSearchResult;
}
}
}
catch (Exception ex)
{
string message = Convert.ToString(ex.InnerException);
//throw ex;
}
finally
{
if (ds != null)
{
ds.Dispose();
}
}
return(dbsavedsearch);
}
