/// <summary> /// Get all itens to populate NXN relation used in ComboNxNEmployeeTerritories /// </summary> public List <ModelNotifiedForEmployeeTerritories> GetAllEmployeeTerritories(int EmployeeID, out string error) { EmployeeTerritoriesGenericREST EmployeeTerritoriesGenericREST = new EmployeeTerritoriesGenericREST(wpfConfig); List <DataFilterExpressionREST> dataFilterExpressionRESTList = new List <DataFilterExpressionREST>(); DataFilterExpressionREST dataFilterExpressionREST = null; dataFilterExpressionREST = new DataFilterExpressionREST(); dataFilterExpressionREST.FieldName = "EmployeeID"; dataFilterExpressionREST.FilterType = DataFilterExpressionREST._FilterType.Equal; dataFilterExpressionREST.Filter = EmployeeID.ToString(); dataFilterExpressionRESTList.Add(dataFilterExpressionREST); List <ModelNotifiedForEmployeeTerritories> modelNotifiedForEmployeeTerritories = EmployeeTerritoriesGenericREST.GetAllX <ModelNotifiedForEmployeeTerritories>(dataFilterExpressionRESTList, out error); if (!string.IsNullOrEmpty(error)) { return(null); } //Initializing row status foreach (var item in modelNotifiedForEmployeeTerritories) { item.ItemChanged = false; } return(modelNotifiedForEmployeeTerritories); return(null); }
public List <T> GetByPK <T>(string CustomerTypeID, out string error) { List <DataFilterExpressionREST> dataFilterExpressionRESTList = new List <DataFilterExpressionREST>(); DataFilterExpressionREST dataFilterExpressionREST = null; dataFilterExpressionREST = new DataFilterExpressionREST(); dataFilterExpressionREST.FieldName = "CustomerTypeID"; dataFilterExpressionREST.FilterType = DataFilterExpressionREST._FilterType.Equal; dataFilterExpressionREST.Filter = CustomerTypeID.ToString(); dataFilterExpressionRESTList.Add(dataFilterExpressionREST); return(GetAllX <T>(dataFilterExpressionRESTList, out error)); }
public List <T> GetByPK <T>(int EmployeeID, string TerritoryID, out string error) { List <DataFilterExpressionREST> dataFilterExpressionRESTList = new List <DataFilterExpressionREST>(); DataFilterExpressionREST dataFilterExpressionREST = null; dataFilterExpressionREST = new DataFilterExpressionREST(); dataFilterExpressionREST.FieldName = "EmployeeID"; dataFilterExpressionREST.FilterType = DataFilterExpressionREST._FilterType.Equal; dataFilterExpressionREST.Filter = EmployeeID.ToString(); dataFilterExpressionRESTList.Add(dataFilterExpressionREST); dataFilterExpressionREST = new DataFilterExpressionREST(); dataFilterExpressionREST.FieldName = "TerritoryID"; dataFilterExpressionREST.FilterType = DataFilterExpressionREST._FilterType.Equal; dataFilterExpressionREST.Filter = TerritoryID.ToString(); dataFilterExpressionRESTList.Add(dataFilterExpressionREST); return(GetAllX <T>(dataFilterExpressionRESTList, out error)); }
public List <T> GetByPK <T>(int OrderID, int ProductID, out string error) { List <DataFilterExpressionREST> dataFilterExpressionRESTList = new List <DataFilterExpressionREST>(); DataFilterExpressionREST dataFilterExpressionREST = null; dataFilterExpressionREST = new DataFilterExpressionREST(); dataFilterExpressionREST.FieldName = "OrderID"; dataFilterExpressionREST.FilterType = DataFilterExpressionREST._FilterType.Equal; dataFilterExpressionREST.Filter = OrderID.ToString(); dataFilterExpressionRESTList.Add(dataFilterExpressionREST); dataFilterExpressionREST = new DataFilterExpressionREST(); dataFilterExpressionREST.FieldName = "ProductID"; dataFilterExpressionREST.FilterType = DataFilterExpressionREST._FilterType.Equal; dataFilterExpressionREST.Filter = ProductID.ToString(); dataFilterExpressionRESTList.Add(dataFilterExpressionREST); return(GetAllX <T>(dataFilterExpressionRESTList, out error)); }
/// <summary> /// Filters a raw list based on GeneralBodyGet.Filters /// </summary> public List <GetTagView> Filter(List <GetTagView> rawList, GeneralBodyGet GeneralBodyGet, out RestExceptionError error) { try { error = null; if ((GeneralBodyGet == null) || (GeneralBodyGet.Filters == null) || (GeneralBodyGet.Filters.Count == 0)) { return(rawList); } //Search request data if dynamic filtering is send. DataFilterExpressionREST linqQuery = GeneralBodyGet.Filters.Where(x => x.FilterType == DataFilterExpressionREST._FilterType.Dynamic).FirstOrDefault(); List <GetTagView> result = null; if (linqQuery != null) { result = DynamicLinqQuery(rawList, linqQuery.Filter, out error); } else { var filteredList = base.FilterRawList(rawList, GeneralBodyGet, out error); result = filteredList.Cast <GetTagView>().ToList(); } if (error != null) { return(null); } return(result); } catch (Exception ex) { error = new RestExceptionError(); error.ExceptionMessage = ex.Message; error.InternalMessage = "Error ocurred during 'Filter' "; } return(null); }