Пример #1
0
        // fetch all from table into new List of class instances, filtered by any column
        // links:
        //  docLink: http://sql2x.org/documentationLink/db27658d-4d23-46d7-9970-7bbaef8634b0
        public List <CrudeServiceRequestStatusRefModel> FetchWithFilter(string serviceRequestStatusRcd, string serviceRequestStatusName, System.Guid userId, System.DateTime dateTime, string description)
        {
            var list = new List <CrudeServiceRequestStatusRefModel>();
            List <CrudeServiceRequestStatusRefData> dataList = CrudeServiceRequestStatusRefData.FetchWithFilter(serviceRequestStatusRcd, serviceRequestStatusName, userId, dateTime, description);

            foreach (CrudeServiceRequestStatusRefData data in dataList)
            {
                var crudeServiceRequestStatusRefBusinessModel = new CrudeServiceRequestStatusRefModel();
                DataToModel(data, crudeServiceRequestStatusRefBusinessModel);
                list.Add(crudeServiceRequestStatusRefBusinessModel);
            }

            return(list);
        }
        // fetch all rows from table into new List of Contracts, filtered by any column
        // links:
        //  docLink: http://sql2x.org/documentationLink/ce01ef4a-5cd0-4e51-b211-9c0a15b791a0
        public List <CrudeServiceRequestStatusRefContract> FetchWithFilter(string serviceRequestStatusRcd, string serviceRequestStatusName, System.Guid userId, System.DateTime dateTime, string description)
        {
            var list = new List <CrudeServiceRequestStatusRefContract>();
            List <CrudeServiceRequestStatusRefData> dataList = CrudeServiceRequestStatusRefData.FetchWithFilter(
                serviceRequestStatusRcd: serviceRequestStatusRcd,
                serviceRequestStatusName: serviceRequestStatusName,
                userId: userId,
                dateTime: dateTime,
                description: description
                );

            foreach (CrudeServiceRequestStatusRefData data in dataList)
            {
                var crudeServiceRequestStatusRefContract = new CrudeServiceRequestStatusRefContract();
                DataToContract(data, crudeServiceRequestStatusRefContract);
                list.Add(crudeServiceRequestStatusRefContract);
            }

            return(list);
        }