public HttpResponseMessage Search([FromUri] AspNetUserRoleSearchRequest model) { ItemsResponse <AspNetUserRole> response = new ItemsResponse <AspNetUserRole>(); response.Items = _AspNetUserRoleService.Search(model); return(Request.CreateResponse(HttpStatusCode.OK, response)); }
public List <AspNetUserRole> Search(AspNetUserRoleSearchRequest model) { List <AspNetUserRole> list = null; DataProvider.ExecuteCmd(GetConnection, "dbo.AspNetUserRoles_Search", inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@Name", model.Name); paramCollection.AddWithValue("@Role", model.Role); paramCollection.AddWithValue("@CurrentPage", model.CurrentPage); paramCollection.AddWithValue("@ItemsPerPage", model.ItemsPerPage); } , map : delegate(IDataReader reader, short set) { switch (set) { case 0: AspNetUserRole a = new AspNetUserRole(); int ord = 0; //startingOrdinal a.FirstName = reader.GetSafeString(ord++); a.LastName = reader.GetSafeString(ord++); a.Email = reader.GetSafeString(ord++); a.AspNetUserId = reader.GetSafeString(ord++); a.TotalRows = reader.GetSafeInt32(ord++); a.hasUsr = reader.GetSafeBool(ord++); a.hasMgr = reader.GetSafeBool(ord++); a.hasAdm = reader.GetSafeBool(ord++); if (list == null) { list = new List <AspNetUserRole>(); } list.Add(a); break; } } ); return(list); }