// 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 <CrudeDefaultIssueStatusRefModel> FetchWithFilter(string defaultIssueStatusRcd, string defaultIssueStatusName, System.Guid defaultUserId, System.DateTime dateTime) { var list = new List <CrudeDefaultIssueStatusRefModel>(); List <CrudeDefaultIssueStatusRefData> dataList = CrudeDefaultIssueStatusRefData.FetchWithFilter(defaultIssueStatusRcd, defaultIssueStatusName, defaultUserId, dateTime); foreach (CrudeDefaultIssueStatusRefData data in dataList) { var crudeDefaultIssueStatusRefBusinessModel = new CrudeDefaultIssueStatusRefModel(); DataToModel(data, crudeDefaultIssueStatusRefBusinessModel); list.Add(crudeDefaultIssueStatusRefBusinessModel); } 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 <CrudeDefaultIssueStatusRefContract> FetchWithFilter(string defaultIssueStatusRcd, string defaultIssueStatusName, System.Guid defaultUserId, System.DateTime dateTime) { var list = new List <CrudeDefaultIssueStatusRefContract>(); List <CrudeDefaultIssueStatusRefData> dataList = CrudeDefaultIssueStatusRefData.FetchWithFilter( defaultIssueStatusRcd: defaultIssueStatusRcd, defaultIssueStatusName: defaultIssueStatusName, defaultUserId: defaultUserId, dateTime: dateTime ); foreach (CrudeDefaultIssueStatusRefData data in dataList) { var crudeDefaultIssueStatusRefContract = new CrudeDefaultIssueStatusRefContract(); DataToContract(data, crudeDefaultIssueStatusRefContract); list.Add(crudeDefaultIssueStatusRefContract); } return(list); }