Ejemplo n.º 1
0
        /// <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);
        }
Ejemplo n.º 2
0
        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));
        }
Ejemplo n.º 3
0
        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));
        }
Ejemplo n.º 4
0
        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));
        }
Ejemplo n.º 5
0
        /// <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);
        }