public void GetGalleries_Successful() { // Arrange MailChimpManager mc = new MailChimpManager(TestGlobal.Test_APIKey); // Act GalleryListResult result = mc.GetGalleries("test-api"); // Assert Assert.IsNotNull(result); }
public GalleryListResult Search(string keywords, int Orderby, int PageNo, int PageSize, int BlockSize) { GalleryListResult result = new GalleryListResult(); Orderby = Orderby <= 0 ? 0 : (Orderby > 2 ? 2 : Orderby); PageSize = PageSize <= 0 ? 10 : PageSize; BlockSize = BlockSize <= 0 ? 10 : BlockSize; int Start = 0; int Stop = 0; int NumberOfPages = 0; int NumberOfBlocks = 0; int BlockNo = 0; int NumberOfRecords = 0; if (string.IsNullOrEmpty(keywords)) { NumberOfRecords = datacontext.Galleries.OrderBy(o => o.GalleryId).Count(); } else { NumberOfRecords = datacontext.Galleries.Join(datacontext.States, a => a.State, b => b.StateId, (a, b) => new { Id = a.GalleryId, a.Filename, State = b.ShortName }) .Where(w => w.Filename.StartsWith(keywords) || w.State.StartsWith(keywords)).Count(); } if (NumberOfRecords == 0) { NumberOfPages = 0; NumberOfBlocks = 0; PageNo = 0; BlockNo = 0; } else { if (NumberOfRecords <= PageSize) { NumberOfPages = 1; NumberOfBlocks = 1; PageNo = 1; BlockNo = 1; } else { NumberOfPages = NumberOfRecords / PageSize; if (NumberOfRecords % PageSize > 0) { NumberOfPages++; } NumberOfBlocks = NumberOfPages / BlockSize; if (NumberOfPages % BlockSize > 0) { NumberOfBlocks++; } if (PageNo > NumberOfPages) { PageNo = NumberOfPages; } if (PageNo <= BlockSize) { BlockNo = 1; } else { BlockNo = (int)Math.Abs(Math.Floor((decimal)PageNo / (decimal)BlockSize)); if (PageNo % BlockSize > 0) { BlockNo++; } } } Start = ((BlockNo - 1) * BlockSize) + 1; Stop = BlockNo * BlockSize; if (Stop > NumberOfPages) { Stop = NumberOfPages; } for (int i = Start; i <= Stop; i++) { result.Pages.Add(i); } if (NumberOfBlocks == 1) { result.First = null; result.Prev = null; result.Next = null; result.Last = null; } else { if (BlockNo == NumberOfBlocks) { result.First = 1; result.Prev = PageNo - 1; result.Next = null; result.Last = null; } else if (BlockNo == 1) { result.First = null; result.Prev = null; result.Next = PageNo + 1; result.Last = NumberOfPages; } else { result.First = 1; result.Prev = PageNo - 1; result.Next = PageNo + 1; result.Last = NumberOfPages; } } int Skip = (Start - 1) * PageSize; int Take = (Stop - (Start - 1)) * PageSize; List <GallerySimpleItem> temps; if (string.IsNullOrEmpty(keywords)) { switch (Orderby) { case 0: /* by Id */ temps = datacontext.Galleries.OrderBy(o => o.GalleryId).Skip(Skip).Take(Take).Select(s => new GallerySimpleItem(s.GalleryId, s.Filename, s.URL, GetImageURL(s.URL, 114, 64), GetImageURL(s.URL, 570, 320))).ToList(); break; case 1: /* by Filename */ temps = datacontext.Galleries.OrderBy(o => o.Filename).Skip(Skip).Take(Take).Select(s => new GallerySimpleItem(s.GalleryId, s.Filename, s.URL, GetImageURL(s.URL, 114, 64), GetImageURL(s.URL, 570, 320))).ToList(); break; case 2: /* by Suburb */ temps = datacontext.Galleries.OrderBy(o => o.Suburb).Skip(Skip).Take(Take).Select(s => new GallerySimpleItem(s.GalleryId, s.Filename, s.URL, GetImageURL(s.URL, 114, 64), GetImageURL(s.URL, 570, 320))).ToList(); break; default: /* by State */ temps = datacontext.Galleries.Join(datacontext.States, a => a.State, b => b.StateId, (a, b) => new { Id = a.GalleryId, a.Filename, a.URL, State = b.ShortName }).OrderBy(o => o.State).Select(s => new GallerySimpleItem(s.Id, s.Filename, s.URL, GetImageURL(s.URL, 114, 64), GetImageURL(s.URL, 570, 320))).ToList(); break; } } else { switch (Orderby) { case 0: /* by Id */ temps = datacontext.Galleries.Join(datacontext.States, a => a.State, b => b.StateId, (a, b) => new { Id = a.GalleryId, a.Filename, a.URL, a.Suburb, State = b.ShortName }).Where(w => w.Filename.StartsWith(keywords) || w.Suburb.StartsWith(keywords) || w.State.StartsWith(keywords)).OrderBy(o => o.Id).Skip(Skip).Take(Take).Select(s => new GallerySimpleItem(s.Id, s.Filename, s.URL, GetImageURL(s.URL, 114, 64), GetImageURL(s.URL, 570, 320))).ToList(); break; case 1: /* by Filename */ temps = datacontext.Galleries.Join(datacontext.States, a => a.State, b => b.StateId, (a, b) => new { Id = a.GalleryId, a.Filename, a.URL, a.Suburb, State = b.ShortName }).Where(w => w.Filename.StartsWith(keywords) || w.Suburb.StartsWith(keywords) || w.State.StartsWith(keywords)).OrderBy(o => o.Filename).Skip(Skip).Take(Take).Select(s => new GallerySimpleItem(s.Id, s.Filename, s.URL, GetImageURL(s.URL, 114, 64), GetImageURL(s.URL, 570, 320))).ToList(); break; case 2: /* by Suburb */ temps = datacontext.Galleries.Join(datacontext.States, a => a.State, b => b.StateId, (a, b) => new { Id = a.GalleryId, a.Filename, a.URL, a.Suburb, State = b.ShortName }).Where(w => w.Filename.StartsWith(keywords) || w.Suburb.StartsWith(keywords) || w.State.StartsWith(keywords)).OrderBy(o => o.Suburb).Skip(Skip).Take(Take).Select(s => new GallerySimpleItem(s.Id, s.Filename, s.URL, GetImageURL(s.URL, 114, 64), GetImageURL(s.URL, 570, 320))).ToList(); break; default: /* by State */ temps = datacontext.Galleries.Join(datacontext.States, a => a.State, b => b.StateId, (a, b) => new { Id = a.GalleryId, a.Filename, a.URL, a.Suburb, State = b.ShortName }).Where(w => w.Filename.StartsWith(keywords) || w.Suburb.StartsWith(keywords) || w.State.StartsWith(keywords)).OrderBy(o => o.State).Skip(Skip).Take(Take).Select(s => new GallerySimpleItem(s.Id, s.Filename, s.URL, GetImageURL(s.URL, 114, 64), GetImageURL(s.URL, 570, 320))).ToList(); break; } } List <GallerySimpleItem> collection = new List <GallerySimpleItem>(); int count = 0; for (int i = 0; i < temps.Count(); i++) { collection.Add(temps[i]); count++; if (count >= PageSize || i == temps.Count() - 1) { result.Galleries.Add(collection); collection = new List <GallerySimpleItem>(); count = 0; } } } result.NumberOfPages = NumberOfPages; result.SelectedPageNo = PageNo; if (PageNo > result.Pages.Count) { result.SelectedIndex = (PageNo - ((BlockNo - 1) * BlockSize) - 1); } else { result.SelectedIndex = PageNo - 1; } return(result); }