public SPRes GetSystemParameters(SearchFiltersReq req)
{
var data = new SPRes();
data = _sPCommand.GetSystemParameters(req);
return(data);
}
public SPRes GetSystemParameters()
{
logger.Info(Environment.NewLine + DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss") + Environment.NewLine);
logger.Info(string.Format("{0}.{1} - START", this.GetType().Name, MethodBase.GetCurrentMethod().Name));
var requestHeader = Request;
var headers = requestHeader.Headers;
if (headers.Contains("esFilters"))
{
searchFilters = headers.GetValues("esFilters").First();
}
SearchFiltersReq req = Newtonsoft.Json.JsonConvert.DeserializeObject <SearchFiltersReq>(searchFilters);
SPRes objRes = _spService.GetSystemParameters(req);
logger.Info(string.Format("{0}.{1} - END", this.GetType().Name, MethodBase.GetCurrentMethod().Name));
return(objRes);
}
public SPRes GetSystemParameters(SearchFiltersReq req)
{
var length = req.Filters.Count;
var dynamicWhereCondition = string.Empty;
for (var i = 0; i < length; i++)
{
var filterName = req.Filters[i].FilterName;
var filterValue = req.Filters[i].FilterValue;
var filterValueMatch = req.Filters[i].FilterValueMatch;
if (string.IsNullOrEmpty(filterName))
{
continue;
}
dynamicWhereCondition = dynamicWhereCondition + " AND " + "[" + filterName + "]";
if (filterValueMatch == "Exact")
{
dynamicWhereCondition = dynamicWhereCondition + " = '" + filterValue + "'";
}
else if (filterValueMatch == "LikeBefore")
{
dynamicWhereCondition = dynamicWhereCondition + " LIKE '%" + filterValue + "'";
}
else if (filterValueMatch == "LikeAfter")
{
dynamicWhereCondition = dynamicWhereCondition + " LIKE '" + filterValue + "%'";
}
else if (filterValueMatch == "LikeBoth")
{
dynamicWhereCondition = dynamicWhereCondition + " LIKE '%" + filterValue + "%'";
}
}
var queryParameters = new DynamicParameters();
queryParameters.Add("@WhereConditions", dynamicWhereCondition);
var reader = SqlMapper.QueryMultiple(con, "dbo.sp_SystemParametersSelect", queryParameters, commandType: StoredProcedure);
var SystemParametersTableList = reader.Read <SystemParametersTable>().ToList();
var aMCount = SystemParametersTableList.Count;
SPRes SPResponse = new SPRes()
{
Response = new Response()
{
EsSystemParameters = new EsSystemParametersRes()
{
SystemParameters = new List <SystemParametersRes>(aMCount)
}
}
};
foreach (var item in SystemParametersTableList)
{
SPResponse.Response.EsSystemParameters.SystemParameters.Add(
new SystemParametersRes
{
SystemParamId = item.SystemParamId,
Code = item.Code,
Name = item.Name,
Description = item.Description,
Active = item.Active
});
}
var data = SPResponse;
return(data);
}
