// 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 <CrudeDefaultUserModel> FetchWithFilter(System.Guid defaultUserId, string defaultUserCode, string defaultUserName, string email, string password, string defaultStateRcd, System.Guid createdByDefaultUserId, System.DateTime dateTime, System.DateTime lastActivityDateTime) { var list = new List <CrudeDefaultUserModel>(); List <CrudeDefaultUserData> dataList = CrudeDefaultUserData.FetchWithFilter(defaultUserId, defaultUserCode, defaultUserName, email, password, defaultStateRcd, createdByDefaultUserId, dateTime, lastActivityDateTime); foreach (CrudeDefaultUserData data in dataList) { var crudeDefaultUserBusinessModel = new CrudeDefaultUserModel(); DataToModel(data, crudeDefaultUserBusinessModel); list.Add(crudeDefaultUserBusinessModel); } 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 <CrudeDefaultUserContract> FetchWithFilter(System.Guid defaultUserId, string defaultUserCode, string defaultUserName, string email, string password, string defaultStateRcd, System.Guid createdByDefaultUserId, System.DateTime dateTime, System.DateTime lastActivityDateTime) { var list = new List <CrudeDefaultUserContract>(); List <CrudeDefaultUserData> dataList = CrudeDefaultUserData.FetchWithFilter( defaultUserId: defaultUserId, defaultUserCode: defaultUserCode, defaultUserName: defaultUserName, email: email, password: password, defaultStateRcd: defaultStateRcd, createdByDefaultUserId: createdByDefaultUserId, dateTime: dateTime, lastActivityDateTime: lastActivityDateTime ); foreach (CrudeDefaultUserData data in dataList) { var crudeDefaultUserContract = new CrudeDefaultUserContract(); DataToContract(data, crudeDefaultUserContract); list.Add(crudeDefaultUserContract); } return(list); }