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