API tools faq
paste
Advertisement
Guest User

c

a guest
Nov 27th, 2014
178
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.60 KB | None | 0 0
raw download clone embed print report
  1. [TestMethod, TestCategory("Stored procedures - widgets"), Description("Unit test for widget #53 and Current Data, sumOTBDefinitiveAndTenative : true")]
  2. public void GivenOTBOccupancyProgressionBarByChannelCategories_WhenStoredProcedureInvokedForCurrent_ThenReturnedDataProperlyCalculated()
  3. {
  4. //TY
  5. var testedDate1 = Today;
  6. var testedDate2 = Today.AddDays(1);
  7. var testedDate3 = Today.AddDays(2);
  8.  
  9. //LY
  10. var lastYearTestedDate1 = testedDate1.LastYear();
  11. var lastYearTestedDate2 = testedDate2.LastYear();
  12. var lastYearTestedDate3 = testedDate3.LastYear();
  13.  
  14. var snapshotDate = Today.LastYear();
  15.  
  16. //Given
  17. //TY
  18. ModifyChannelSegmentElementFor(testedDate1, _channelSegmentUnassignedID, u => u.Add(i => i.OTBDef_RmNts, 5).Add(i => i.OTBTen_RmNts, 5));
  19. ModifyChannelSegmentElementFor(testedDate1, _channelSegment1FromCC1ID, u => u.Add(i => i.OTBDef_RmNts, 10).Add(i => i.OTBTen_RmNts, 10));
  20. ModifyChannelSegmentElementFor(testedDate1, _channelSegment2FromCC2ID, u => u.Add(i => i.OTBDef_RmNts, 7).Add(i => i.OTBTen_RmNts, 3));
  21. ModifyChannelSegmentElementFor(testedDate1, _channelSegment3FromCC2ID, u => u.Add(i => i.OTBDef_RmNts, 12).Add(i => i.OTBTen_RmNts, 8));
  22. ModifyChannelSegmentElementFor(testedDate1, _channelSegment4FromCCUnassignedID, u => u.Add(i => i.OTBDef_RmNts, 3).Add(i => i.OTBTen_RmNts, 7));
  23.  
  24. ModifyChannelSegmentElementFor(testedDate2, _channelSegmentUnassignedID, u => u.Add(i => i.OTBDef_RmNts, 6).Add(i => i.OTBTen_RmNts, 5));
  25. ModifyChannelSegmentElementFor(testedDate2, _channelSegment1FromCC1ID, u => u.Add(i => i.OTBDef_RmNts, 11).Add(i => i.OTBTen_RmNts, 4));
  26. ModifyChannelSegmentElementFor(testedDate2, _channelSegment2FromCC2ID, u => u.Add(i => i.OTBDef_RmNts, 8).Add(i => i.OTBTen_RmNts, 3));
  27. ModifyChannelSegmentElementFor(testedDate2, _channelSegment3FromCC2ID, u => u.Add(i => i.OTBDef_RmNts, 13).Add(i => i.OTBTen_RmNts, 7));
  28. ModifyChannelSegmentElementFor(testedDate2, _channelSegment4FromCCUnassignedID, u => u.Add(i => i.OTBDef_RmNts, 4).Add(i => i.OTBTen_RmNts, 6));
  29.  
  30. ModifyChannelSegmentElementFor(testedDate3, _channelSegmentUnassignedID, u => u.Add(i => i.OTBDef_RmNts, 4).Add(i => i.OTBTen_RmNts, 7));
  31. ModifyChannelSegmentElementFor(testedDate3, _channelSegment1FromCC1ID, u => u.Add(i => i.OTBDef_RmNts, 7).Add(i => i.OTBTen_RmNts, 6));
  32. ModifyChannelSegmentElementFor(testedDate3, _channelSegment2FromCC2ID, u => u.Add(i => i.OTBDef_RmNts, 12).Add(i => i.OTBTen_RmNts, 3));
  33. ModifyChannelSegmentElementFor(testedDate3, _channelSegment3FromCC2ID, u => u.Add(i => i.OTBDef_RmNts, 10).Add(i => i.OTBTen_RmNts, 4));
  34. ModifyChannelSegmentElementFor(testedDate3, _channelSegment4FromCCUnassignedID, u => u.Add(i => i.OTBDef_RmNts, 2).Add(i => i.OTBTen_RmNts, 3));
  35.  
  36. //LY Actual
  37. ModifyChannelSegmentElementFor(lastYearTestedDate1, _channelSegmentUnassignedID, u => u.Add(i => i.OTBDef_RmNts, 11).Add(i => i.OTBTen_RmNts, 5));
  38. ModifyChannelSegmentElementFor(lastYearTestedDate1, _channelSegment1FromCC1ID, u => u.Add(i => i.OTBDef_RmNts, 17).Add(i => i.OTBTen_RmNts, 5));
  39. ModifyChannelSegmentElementFor(lastYearTestedDate1, _channelSegment2FromCC2ID, u => u.Add(i => i.OTBDef_RmNts, 14).Add(i => i.OTBTen_RmNts, 3));
  40. ModifyChannelSegmentElementFor(lastYearTestedDate1, _channelSegment3FromCC2ID, u => u.Add(i => i.OTBDef_RmNts, 20).Add(i => i.OTBTen_RmNts, 3));
  41. ModifyChannelSegmentElementFor(lastYearTestedDate1, _channelSegment4FromCCUnassignedID, u => u.Add(i => i.OTBDef_RmNts, 11).Add(i => i.OTBTen_RmNts, 7));
  42.  
  43. ModifyChannelSegmentElementFor(lastYearTestedDate2, _channelSegmentUnassignedID, u => u.Add(i => i.OTBDef_RmNts, 14).Add(i => i.OTBTen_RmNts, 5));
  44. ModifyChannelSegmentElementFor(lastYearTestedDate2, _channelSegment1FromCC1ID, u => u.Add(i => i.OTBDef_RmNts, 18).Add(i => i.OTBTen_RmNts, 7));
  45. ModifyChannelSegmentElementFor(lastYearTestedDate2, _channelSegment2FromCC2ID, u => u.Add(i => i.OTBDef_RmNts, 15).Add(i => i.OTBTen_RmNts, 4));
  46. ModifyChannelSegmentElementFor(lastYearTestedDate2, _channelSegment3FromCC2ID, u => u.Add(i => i.OTBDef_RmNts, 20).Add(i => i.OTBTen_RmNts, 3));
  47. ModifyChannelSegmentElementFor(lastYearTestedDate2, _channelSegment4FromCCUnassignedID, u => u.Add(i => i.OTBDef_RmNts, 12).Add(i => i.OTBTen_RmNts, 2));
  48.  
  49. ModifyChannelSegmentElementFor(lastYearTestedDate3, _channelSegmentUnassignedID, u => u.Add(i => i.OTBDef_RmNts, 11).Add(i => i.OTBTen_RmNts, 1));
  50. ModifyChannelSegmentElementFor(lastYearTestedDate3, _channelSegment1FromCC1ID, u => u.Add(i => i.OTBDef_RmNts, 15).Add(i => i.OTBTen_RmNts, 5));
  51. ModifyChannelSegmentElementFor(lastYearTestedDate3, _channelSegment2FromCC2ID, u => u.Add(i => i.OTBDef_RmNts, 20).Add(i => i.OTBTen_RmNts, 9));
  52. ModifyChannelSegmentElementFor(lastYearTestedDate3, _channelSegment3FromCC2ID, u => u.Add(i => i.OTBDef_RmNts, 23).Add(i => i.OTBTen_RmNts, 2));
  53. ModifyChannelSegmentElementFor(lastYearTestedDate3, _channelSegment4FromCCUnassignedID, u => u.Add(i => i.OTBDef_RmNts, 10).Add(i => i.OTBTen_RmNts, 4));
  54.  
  55. var snapshotID = TakeSnapshot(snapshotDate);
  56.  
  57. //LY Final
  58. ModifyChannelSegmentElementFor(lastYearTestedDate1, _channelSegmentUnassignedID, u => u.Add(i => i.OTBDef_RmNts, 15).Add(i => i.OTBTen_RmNts, 5));
  59. ModifyChannelSegmentElementFor(lastYearTestedDate1, _channelSegment1FromCC1ID, u => u.Add(i => i.OTBDef_RmNts, 20).Add(i => i.OTBTen_RmNts, 5));
  60. ModifyChannelSegmentElementFor(lastYearTestedDate1, _channelSegment2FromCC2ID, u => u.Add(i => i.OTBDef_RmNts, 17).Add(i => i.OTBTen_RmNts, 3));
  61. ModifyChannelSegmentElementFor(lastYearTestedDate1, _channelSegment3FromCC2ID, u => u.Add(i => i.OTBDef_RmNts, 22).Add(i => i.OTBTen_RmNts, 3));
  62. ModifyChannelSegmentElementFor(lastYearTestedDate1, _channelSegment4FromCCUnassignedID, u => u.Add(i => i.OTBDef_RmNts, 13).Add(i => i.OTBTen_RmNts, 7));
  63.  
  64. ModifyChannelSegmentElementFor(lastYearTestedDate2, _channelSegmentUnassignedID, u => u.Add(i => i.OTBDef_RmNts, 16).Add(i => i.OTBTen_RmNts, 5));
  65. ModifyChannelSegmentElementFor(lastYearTestedDate2, _channelSegment1FromCC1ID, u => u.Add(i => i.OTBDef_RmNts, 21).Add(i => i.OTBTen_RmNts, 7));
  66. ModifyChannelSegmentElementFor(lastYearTestedDate2, _channelSegment2FromCC2ID, u => u.Add(i => i.OTBDef_RmNts, 18).Add(i => i.OTBTen_RmNts, 4));
  67. ModifyChannelSegmentElementFor(lastYearTestedDate2, _channelSegment3FromCC2ID, u => u.Add(i => i.OTBDef_RmNts, 23).Add(i => i.OTBTen_RmNts, 3));
  68. ModifyChannelSegmentElementFor(lastYearTestedDate2, _channelSegment4FromCCUnassignedID, u => u.Add(i => i.OTBDef_RmNts, 14).Add(i => i.OTBTen_RmNts, 2));
  69.  
  70. ModifyChannelSegmentElementFor(lastYearTestedDate3, _channelSegmentUnassignedID, u => u.Add(i => i.OTBDef_RmNts, 14).Add(i => i.OTBTen_RmNts, 1));
  71. ModifyChannelSegmentElementFor(lastYearTestedDate3, _channelSegment1FromCC1ID, u => u.Add(i => i.OTBDef_RmNts, 17).Add(i => i.OTBTen_RmNts, 5));
  72. ModifyChannelSegmentElementFor(lastYearTestedDate3, _channelSegment2FromCC2ID, u => u.Add(i => i.OTBDef_RmNts, 22).Add(i => i.OTBTen_RmNts, 9));
  73. ModifyChannelSegmentElementFor(lastYearTestedDate3, _channelSegment3FromCC2ID, u => u.Add(i => i.OTBDef_RmNts, 20).Add(i => i.OTBTen_RmNts, 2));
  74. ModifyChannelSegmentElementFor(lastYearTestedDate3, _channelSegment4FromCCUnassignedID, u => u.Add(i => i.OTBDef_RmNts, 12).Add(i => i.OTBTen_RmNts, 4));
  75.  
  76.  
  77. var expectedData =
  78. new[]
  79. {
  80. OTBOccupancyByChannelCategoryElement.Create(testedDate1, _channelCategoryUnassignedID, StringUnassigned, 0.2M, 0.4M),
  81. OTBOccupancyByChannelCategoryElement.Create(testedDate1, _channelCategory1ID, _channelCategory1Name, 0.2M, 0.25M),
  82. OTBOccupancyByChannelCategoryElement.Create(testedDate1, _channelCategory2ID, _channelCategory2Name, 0.3M, 0.45M),
  83.  
  84. OTBOccupancyByChannelCategoryElement.Create(testedDate2, _channelCategoryUnassignedID, StringUnassigned, 0.21M, 0.37M),
  85. OTBOccupancyByChannelCategoryElement.Create(testedDate2, _channelCategory1ID, _channelCategory1Name, 0.15M, 0.28M),
  86. OTBOccupancyByChannelCategoryElement.Create(testedDate2, _channelCategory2ID, _channelCategory2Name, 0.31M, 0.48M),
  87.  
  88. OTBOccupancyByChannelCategoryElement.Create(testedDate3, _channelCategoryUnassignedID, StringUnassigned, 0.16M, 0.31M),
  89. OTBOccupancyByChannelCategoryElement.Create(testedDate3, _channelCategory1ID, _channelCategory1Name, 0.13M, 0.22M),
  90. OTBOccupancyByChannelCategoryElement.Create(testedDate3, _channelCategory2ID, _channelCategory2Name, 0.29M, 0.53M),
  91. };
  92.  
  93. // When - invoke procedure
  94. var actualData = InvokeProcedure<OTBOccupancyByChannelCategoryElement>(
  95. uow => uow.GetOTBOccupancyProgressionBarByChannelCategoriesReportData,
  96. snapshotID: snapshotID,
  97. sumOTBDefinitiveAndTenative: true,
  98. startDate: testedDate1,
  99. endDate: testedDate3);
  100.  
  101. // Then - compare expected with actual
  102. actualData.Should().Have.SameValuesAs(expectedData);
  103. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!