/// <summary> /// Get all itens filtering direct in DB. Up: More optimized because filters DB. Down: less flexible, don't support dynamic filters. /// </summary> /// <param name="generalBodyGet"></param> /// <param name="error"></param> /// <returns></returns> public List <GetTerritoriesView> GetAllWithDBFilter(GeneralBodyGet generalBodyGet, out RestExceptionError error) { try { if ((generalBodyGet == null) || (generalBodyGet.Filters == null) || (generalBodyGet.Filters.Count == 0)) { error = new RestExceptionError(); error.ExceptionMessage = ""; error.InternalMessage = "Url does not contains filter section"; } error = null; TerritoriesBsn bsn = new TerritoriesBsn(restConfig); List <DataFilterExpressionDB> dbFilter = HelperRESTFilterToDB.FilterRestFilterToDBExpression(generalBodyGet.Filters); List <TerritoriesInfo> dbItems = bsn.GetAll(dbFilter); List <GetTerritoriesView> result = new List <GetTerritoriesView>(); foreach (TerritoriesInfo item in dbItems) { GetTerritoriesView view = new GetTerritoriesView(); Cloner.CopyAllTo(typeof(TerritoriesInfo), item, typeof(GetTerritoriesView), view); result.Add(view); } return(result); } catch (Exception ex) { error = new RestExceptionError(); error.ExceptionMessage = ex.Message; } return(null); }
public ModelNotifiedForTerritories GetTerritoriesByID(string TerritoryID, out string error) { error = null; TerritoriesGenericREST TerritoriesGenericREST = new TerritoriesGenericREST(wpfConfig); GetTerritoriesView getTerritoriesView = TerritoriesGenericREST.GetByPK <GetTerritoriesView>(TerritoryID, out error)[0]; ModelNotifiedForTerritories modelNotifiedForTerritories = new ModelNotifiedForTerritories(); Cloner.CopyAllTo(typeof(GetTerritoriesView), getTerritoriesView, typeof(ModelNotifiedForTerritories), modelNotifiedForTerritories); return(modelNotifiedForTerritories); }
public List <GetTerritoriesView> GetAll(out RestExceptionError error) { try { error = null; TerritoriesBsn bsn = new TerritoriesBsn(restConfig); List <TerritoriesInfo> dbItems = bsn.GetAll(); List <GetTerritoriesView> result = new List <GetTerritoriesView>(); foreach (TerritoriesInfo item in dbItems) { GetTerritoriesView view = new GetTerritoriesView(); Cloner.CopyAllTo(typeof(TerritoriesInfo), item, typeof(GetTerritoriesView), view); result.Add(view); } return(result); } catch (Exception ex) { error = new RestExceptionError(); error.ExceptionMessage = ex.Message; } return(null); }