public ActivityViewModel(Community community, Individual individual, Quarter quarter, ActivitySelection activitySelection) { _community = community; _individual = individual; _quarter = quarter; _activitySelection = activitySelection; }
public void op_ToQuarter_string() { var expected = new Quarter(2010, QuarterOfYear.Q4); var actual = "2010 Q4".ToQuarter(); Assert.Equal(expected, actual); }
public void should_correctly_calculate_this_quarter_start() { var tense = new This(); var place = new Start(); var unit = new Quarter(_dateTime); var dt = unit.GetDateTime(tense, place); Assert.That(dt, Is.EqualTo(_thisQuarterStart)); }
public void should_correctly_calculate_prev_quarter_end() { var tense = new Prev(); var place = new End(); var unit = new Quarter(_dateTime); var dt = unit.GetDateTime(tense, place); Assert.That(dt, Is.EqualTo(_prevQuarterEnd)); }
public TransactionReportQuarter() { Quarter = new Quarter(); Balance = 0; TotalForQuarter = 0; TotalTransactions = 0; TransactionReportItems = new List<TransactionReportItem>(); }
public async Task Initialize() { _community = new Community(new MemoryStorageStrategy()) .Register<CorrespondenceModel>(); _company = await _community.AddFactAsync(new Company("improvingEnterprises")); _quarter = await _community.AddFactAsync(new Quarter(_company, new DateTime(2013, 1, 1))); _categoryGenerator = new CategoryGenerator(_community, _company, _quarter); await _categoryGenerator.GenerateAsync(); }
public QuarterRequestSheetDlg() { this.Build (); var list = new List<Quarter> (); var quarter = new Quarter ((DateTime.Today.Month + 2) / 3, DateTime.Today.Year); for(int i = 0; i < 5; i++) { list.Add (quarter); quarter = quarter.GetNext (); } comboQuarter.ItemsList = list; comboQuarter.SelectedItem = list [1]; }
// GET: Quarters/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Quarter quarter = db.Quarters.Find(id); if (quarter == null) { return(HttpNotFound()); } return(View(quarter)); }
public ReturnsData(List <ReturnData> returnsList, Quarter returnQuarter, List <Quarter> openQuarters, QuarterWindow nextWindow, DateTime currentDate) { Guard.ArgumentNotNull(() => returnsList, returnsList); ReturnsList = returnsList; ReturnQuarter = returnQuarter; OpenQuarters = openQuarters; NextWindow = nextWindow; CurrentDate = currentDate; }
public void BuilderWithData_ConstructedWithCapacityParameter_AddsPointsToBuiltSeries() { var curve = new DoubleCurve <Month> .Builder(1, month => 1.0) .WithData(Month.CreateJanuary(2019), 1.0) .WithData(Month.CreateFebruary(2019), 2.0) .WithData(Month.CreateMarch(2019), 3.0) .Build(); Assert.AreEqual(3, curve.Count); Assert.AreEqual(1.0, curve[Month.CreateJanuary(2019)]); Assert.AreEqual(2.0, curve[Month.CreateFebruary(2019)]); Assert.AreEqual(3.0, curve[Month.CreateMarch(2019)]); Assert.AreEqual(2.0, curve.Price(Quarter.CreateQuarter1(2019))); }
public async Task HandleAsync_ProvideOrganisationIdWithOutPreviousReturns_ReturnsEmptyList() { Organisation requestedOrganisation = fixture.Build <Organisation>().With(o => o.OrganisationStatus, OrganisationStatus.Complete).Create(); Organisation otherOrganisation = fixture.Build <Organisation>().With(o => o.OrganisationStatus, OrganisationStatus.Complete).Create(); Quarter q1 = new Quarter(2019, QuarterType.Q1); Quarter q2 = new Quarter(2019, QuarterType.Q2); Quarter q3 = new Quarter(2019, QuarterType.Q3); List <Return> returns = new List <Return>() { A.Fake <Return>(), A.Fake <Return>() }; Return currentReturn = A.Fake <Return>(); A.CallTo(() => currentReturn.Id).Returns(Guid.NewGuid()); A.CallTo(() => currentReturn.Quarter).Returns(q3); A.CallTo(() => currentReturn.Organisation).Returns(requestedOrganisation); A.CallTo(() => currentReturn.ReturnStatus).Returns(Domain.AatfReturn.ReturnStatus.Submitted); returns.Add(currentReturn); A.CallTo(() => returns.ElementAt(0).Id).Returns(Guid.NewGuid()); A.CallTo(() => returns.ElementAt(0).Quarter).Returns(q1); A.CallTo(() => returns.ElementAt(0).Organisation).Returns(otherOrganisation); A.CallTo(() => returns.ElementAt(0).ReturnStatus).Returns(Domain.AatfReturn.ReturnStatus.Submitted); A.CallTo(() => returns.ElementAt(1).Id).Returns(Guid.NewGuid()); A.CallTo(() => returns.ElementAt(1).Quarter).Returns(q2); A.CallTo(() => returns.ElementAt(1).Organisation).Returns(otherOrganisation); A.CallTo(() => returns.ElementAt(1).ReturnStatus).Returns(Domain.AatfReturn.ReturnStatus.Submitted); A.CallTo(() => dataAccess.GetAll <Return>()).Returns(returns); List <ReturnScheme> returnSchemes = new List <ReturnScheme>(); A.CallTo(() => dataAccess.GetAll <ReturnScheme>()).Returns(returnSchemes); GetPreviousQuarterSchemes request = new GetPreviousQuarterSchemes(requestedOrganisation.Id, currentReturn.Id); PreviousQuarterReturnResult result = await handler.HandleAsync(request); Assert.Equal(0, result.PreviousSchemes.Count); A.CallTo(() => dataAccess.GetAll <Return>()).MustHaveHappened(Repeated.Exactly.Once); A.CallTo(() => dataAccess.GetAll <ReturnScheme>()).MustHaveHappened(Repeated.Exactly.Once); }
public async void IndexGet_GivenValidViewModel_BreadcrumbShouldBeSet() { var organisationId = Guid.NewGuid(); var siteId = Guid.NewGuid(); const string orgName = "orgName"; var @return = A.Fake <ReturnData>(); var quarterData = new Quarter(2019, QuarterType.Q1); var quarterWindow = QuarterWindowTestHelper.GetDefaultQuarterWindow(); var aatfInfo = A.Fake <AatfData>(); var aatfId = Guid.NewGuid(); const string reportingQuarter = "2019 Q1 Jan - Mar"; const string reportingPeriod = "Test (WEE/QW1234RE/ATF)"; @return.Quarter = quarterData; @return.QuarterWindow = quarterWindow; const string aatfName = "Test"; aatfInfo.ApprovalNumber = "WEE/QW1234RE/ATF"; var siteAddressData = new SiteAddressData("TEST", "TEST", "TEST", "TEST", "TEST", "TEST", Guid.NewGuid(), "TEST") { Id = siteId }; var addressTonnage = new AddressTonnageSummary() { AddressData = new List <SiteAddressData>() { siteAddressData } }; A.CallTo(() => apiClient.SendAsync(A <string> ._, A <GetAatfSite> .Ignored)).Returns(addressTonnage); A.CallTo(() => cache.FetchOrganisationName(organisationId)).Returns(orgName); A.CallTo(() => apiClient.SendAsync(A <string> ._, A <GetReturn> ._)).Returns(@return); A.CallTo(() => cache.FetchAatfData(organisationId, aatfId)).Returns(aatfInfo); A.CallTo(() => aatfInfo.Name).Returns(aatfName); await controller.Index(organisationId, A.Dummy <Guid>(), aatfId, siteId); breadcrumb.ExternalActivity.Should().Be(BreadCrumbConstant.AatfReturn); breadcrumb.ExternalOrganisation.Should().Be(orgName); breadcrumb.OrganisationId.Should().Be(organisationId); Assert.Contains(reportingQuarter, breadcrumb.QuarterDisplayInfo); Assert.Contains(reportingPeriod, breadcrumb.AatfDisplayInfo); }
// GET: Quarters/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Quarter quarter = db.Quarters.Find(id); if (quarter == null) { return(HttpNotFound()); } ViewBag.SchoolYearID = new SelectList(db.SchoolYears, "ID", "Name", quarter.SchoolYearID); return(View(quarter)); }
static void Main(string[] args) { MyWallet w = new MyWallet(); Penny p = new Penny(); Quarter q = new Quarter(); w.AddMoney(p); w.AddMoney(q); Console.WriteLine("My wallet has {0} in it.", w.TotalValue); // p = w.RemoveMoney(p); // List<CirculatingMoney> moneyBag = w.GetMoney(25.25m); Console.ReadLine(); }
// Teacher and Coordinator Learning Plan public ActionResult LearningPlanAdd() { //connect to db Syllabus_ManagementEntities4 term = new Syllabus_ManagementEntities4(); //retrieve table details (firstName, lastName, etc.) Quarter q = new Quarter(); //from the table friends, select all in descending order by age var quarterList = (from u in term.Quarters select u); //converting all the retrieved data (friends) into a list object ViewData["QuarterList"] = quarterList.ToList(); return(View()); }
public HomeViewModel() { InvoiceViewModel invoiceViewModel = new InvoiceViewModel(); Invoices = invoiceViewModel.GetUnPaidInvoices(); Quarter quarter = new Quarter(); var invoicesForPeriod = Invoice.GetInvoicesForPeriod(quarter.Start, quarter.End); JobsCompleted = invoicesForPeriod.Count; MoneyMade = invoicesForPeriod.Sum(m => m.Price); IncomeTax = MoneyMade * 0.3; Vat = MoneyMade * 0.2; Quotes = Quote.GetQuoteSummaries(); ScheduledWorks = ScheduledWork.GetScheduledWorks(); }
} // ShowCompactQuarter // ---------------------------------------------------------------------- public static void ShowQuarter(Quarter quarter, string caption = "Quarter") { WriteLine("{0}: {1}", caption, quarter); WriteIndentLine("YearBaseMonth: {0}", quarter.YearBaseMonth); WriteIndentLine("StartMonth: {0}", quarter.StartMonth); WriteIndentLine("Year: {0}", quarter.Year); WriteIndentLine("YearQuarter: {0}", quarter.YearQuarter); WriteIndentLine("IsCalendarQuarter: {0}", quarter.IsCalendarQuarter); WriteIndentLine("MultipleCalendarYears: {0}", quarter.MultipleCalendarYears); WriteIndentLine("QuarterName: {0}", quarter.QuarterName); WriteIndentLine("QuarterOfYearName: {0}", quarter.QuarterOfYearName); WriteIndentLine("FirstDayStart: {0}", Format(quarter.FirstDayStart)); WriteIndentLine("LastDayStart: {0}", Format(quarter.LastDayStart)); WriteLine(); } // ShowQuarter
private static Quarter ParseQuarter( PropertyDictionary properties, PropertyDescriptionDictionary descriptions) { var fiscalYear = Convert.ToUInt16(properties.Get(PropertyNames.FiscalYear)); var fiscalQuarter = Convert.ToUInt16(properties.Get(PropertyNames.FiscalQuarter)); return(Quarter.Create( properties.Get(PropertyNames.Ticker), fiscalYear, fiscalQuarter, properties, descriptions )); }
/// <summary> /// Retrieves information about the sales quarter based on the period number and the year. /// </summary> /// <param name="period"> /// The period you wish to get quarter information for. /// </param> /// <param name="year"> /// The year you wish to get quarter information for. /// </param> /// <returns> /// Quarter /// </returns> public static Quarter GetQuarter(int period, int year) { // Make sure the period passed in is valid. ValidatePeriod(period); // Divide the period by 3, round up to the nearest whole number. var quarterNumber = (int) Math.Ceiling((decimal) period/3); // Make sure the quarter is valid. ValidateQuarter(quarterNumber); var returnValue = new Quarter { Year = year, Number = quarterNumber }; var dateRange = new DateRange(); // Return different values for the rest of the object depending on what the quarter number is. switch (returnValue.Number) { case 1: returnValue.Name = "Spring"; dateRange.StartDate = GetPeriodDateRange(1, year).StartDate; dateRange.EndDate = GetPeriodDateRange(3, year).EndDate; break; case 2: returnValue.Name = "Summer"; dateRange.StartDate = GetPeriodDateRange(4, year).StartDate; dateRange.EndDate = GetPeriodDateRange(6, year).EndDate; break; case 3: returnValue.Name = "Fall"; dateRange.StartDate = GetPeriodDateRange(7, year).StartDate; dateRange.EndDate = GetPeriodDateRange(9, year).EndDate; break; case 4: returnValue.Name = "Winter"; dateRange.StartDate = GetPeriodDateRange(10, year).StartDate; dateRange.EndDate = GetPeriodDateRange(12, year).EndDate; break; } returnValue.DateRange = dateRange; return returnValue; }
public async Task FetchResultsAsync_WithSeveralDeliveredAmounts_ReturnsSumOfAmounts() { using (Weee.Tests.Core.Model.DatabaseWrapper wrapper = new Weee.Tests.Core.Model.DatabaseWrapper()) { // Arrange Organisation organisation = Organisation.CreateSoleTrader("Test Organisation"); Scheme scheme = new Scheme(organisation); Quarter quarter = new Quarter(2099, QuarterType.Q1); DataReturn dataReturn = new DataReturn(scheme, quarter); DataReturnVersion version = new DataReturnVersion(dataReturn); WeeeDeliveredAmount amount1 = new WeeeDeliveredAmount( ObligationType.B2C, WeeeCategory.LargeHouseholdAppliances, 100, new AatfDeliveryLocation("WEE/AA1111AA/ATF", string.Empty)); version.WeeeDeliveredReturnVersion.AddWeeeDeliveredAmount(amount1); WeeeDeliveredAmount amount2 = new WeeeDeliveredAmount( ObligationType.B2C, WeeeCategory.LargeHouseholdAppliances, 200, new AatfDeliveryLocation("WEE/BB2222BB/ATF", string.Empty)); version.WeeeDeliveredReturnVersion.AddWeeeDeliveredAmount(amount2); wrapper.WeeeContext.DataReturns.Add(dataReturn); await wrapper.WeeeContext.SaveChangesAsync(); dataReturn.SetCurrentVersion(version); await wrapper.WeeeContext.SaveChangesAsync(); // Act FetchSummaryCsvDataAccess dataAccess = new FetchSummaryCsvDataAccess(wrapper.WeeeContext); List <DataReturnSummaryCsvData> results = await dataAccess.FetchResultsAsync(scheme.Id, 2099); // Assert Assert.NotNull(results); Assert.Equal(1, results.Count); DataReturnSummaryCsvData result = results[0]; Assert.NotNull(result); Assert.Equal(300, result.Category1); } }
private static void Creating() { #region creating var mar19 = new Month(2019, 3); Console.WriteLine(mar19); var aug19 = Month.CreateAugust(2019); Console.WriteLine(aug19); var qu119 = Quarter.CreateQuarter1(2019); Console.WriteLine(qu119); Day christmas2020 = Day.FromDateTime(new DateTime(2020, 12, 25)); Console.WriteLine(christmas2020); Console.WriteLine(); #endregion }
public async void GetQuarter_GivenFourthQuarter_ValidQuarterStartAndEndDatesShouldBeCalculated() { var quarter = new Quarter(2019, QuarterType.Q4); var quarterWindowTemplate = QuarterWindowTemplate(1, 1, 1, 1); A.CallTo(() => dataAccess.GetByQuarter((int)quarter.Q)).Returns(quarterWindowTemplate); var result = await quarterWindowFactory.GetAnnualQuarter(quarter); result.StartDate.Year.Should().Be(2019); result.StartDate.Month.Should().Be(10); result.StartDate.Day.Should().Be(1); result.EndDate.Year.Should().Be(2019); result.EndDate.Month.Should().Be(12); result.EndDate.Day.Should().Be(31); }
public static DateTime GetEndOfQuarter(int Year, Quarter Qtr) { if (Qtr == Quarter.First) { return(new DateTime(Year, 3, DateTime.DaysInMonth(Year, 3), 0x17, 0x3b, 0x3b, 0x3e7)); } if (Qtr == Quarter.Second) { return(new DateTime(Year, 6, DateTime.DaysInMonth(Year, 6), 0x17, 0x3b, 0x3b, 0x3e7)); } if (Qtr == Quarter.Third) { return(new DateTime(Year, 9, DateTime.DaysInMonth(Year, 9), 0x17, 0x3b, 0x3b, 0x3e7)); } return(new DateTime(Year, 12, DateTime.DaysInMonth(Year, 12), 0x17, 0x3b, 0x3b, 0x3e7)); }
public static DateTime GetStartOfQuarter(int Year, Quarter Qtr) { if (Qtr == Quarter.First) { return(new DateTime(Year, 1, 1, 0, 0, 0, 0)); } if (Qtr == Quarter.Second) { return(new DateTime(Year, 4, 1, 0, 0, 0, 0)); } if (Qtr == Quarter.Third) { return(new DateTime(Year, 7, 1, 0, 0, 0, 0)); } return(new DateTime(Year, 10, 1, 0, 0, 0, 0)); }
public ActionResult SaveValues(int formId, int year, Quarter quarter, int areaId, string data, Period period = 0) { //判断用户是否可以保存当前年份、季度的数据 var season = Core.SeasonManager.GetSeason(year, quarter); if (CurrentIdentity.Role <= UserRole.Advanced && (season == null || !season.Indate)) { throw new HttpException(401, "当前时段不能添加表单数据"); } var values = data.ToObject <List <NodeValue> >(); Core.FormManager.SaveNodeValues(values); Core.FormManager.ComputeSumValue(formId, year, quarter, values); return(JsonSuccessResult()); }
public void FiscalYearGetMonthsTest() { Quarter quarter = new Quarter(2006, YearQuarter.First, GetFiscalYearCalendar(FiscalYearAlignment.LastDay)); ITimePeriodCollection months = quarter.GetMonths(); Assert.NotNull(months); Assert.Equal(months.Count, TimeSpec.MonthsPerQuarter); Assert.Equal(months[0].Start, new DateTime(2006, 8, 27)); for (int i = 0; i < months.Count; i++) { Assert.Equal(months[i].Duration.Subtract(TimeCalendar.DefaultEndOffset).Days, (i + 1) % 3 == 0 ? TimeSpec.FiscalDaysPerLongMonth : TimeSpec.FiscalDaysPerShortMonth); } Assert.Equal(months[TimeSpec.MonthsPerQuarter - 1].End, quarter.End); } // FiscalYearGetMonthsTest
public static DateTime GetStartOfQuarter(int Year, Quarter Qtr) { if (Qtr == Quarter.First) // 1st Quarter = January 1 to March 31 { return(new DateTime(Year, 1, 1, 0, 0, 0, 0)); } if (Qtr == Quarter.Second) // 2nd Quarter = April 1 to June 30 { return(new DateTime(Year, 4, 1, 0, 0, 0, 0)); } if (Qtr == Quarter.Third) // 3rd Quarter = July 1 to September 30 { return(new DateTime(Year, 7, 1, 0, 0, 0, 0)); } return(new DateTime(Year, 10, 1, 0, 0, 0, 0)); }
public void QuarterConstructor() { //Arrange Quarter sanFran; q = new Quarter(); //Act sanFran = new Quarter(USCoinMintMark.S); //Assert //Current Year is default year Assert.AreEqual(USCoinMintMark.D, q.MintMark); Assert.AreEqual(System.DateTime.Now.Year, q.Year); Assert.AreEqual(System.DateTime.Now.Year, sanFran.Year); Assert.AreEqual(USCoinMintMark.S, sanFran.MintMark); }
protected ReturnViewModelBase(ReturnData returnData) { Guard.ArgumentNotNull(() => returnData, returnData); Guard.ArgumentNotNull(() => returnData.Quarter, returnData.Quarter); Guard.ArgumentNotNull(() => returnData.QuarterWindow, returnData.QuarterWindow); this.QuarterWindow = returnData.QuarterWindow; this.QuarterInstance = returnData.Quarter; this.year = returnData.Quarter.Year; this.CreatedBy = returnData.CreatedBy; this.CreatedDate = returnData.CreatedDate.ToString("dd/MM/yyyy HH:mm:ss"); this.SubmittedBy = string.IsNullOrWhiteSpace(returnData.SubmittedBy) ? "-" : returnData.SubmittedBy; this.SubmittedDate = returnData.SubmittedDate.HasValue ? returnData.SubmittedDate.Value.ToString("dd/MM/yyyy HH:mm:ss") : "-"; this.ReturnStatus = returnData.ReturnStatus; this.ReturnId = returnData.Id; }
private void OnQuarterClick(object sender, EventArgs e) { var button = (ButtonX)sender; if (button.Checked) { button.Checked = false; SelectedQuarter = null; } else { _quarterButtons.ForEach(b => b.Checked = false); button.Checked = true; SelectedQuarter = (Quarter)button.Tag; } QuarterSelected?.Invoke(this, EventArgs.Empty); }
/** * Sets the selected quarter to session if one not already * set. Then gets the list of valid quarters and returns * **/ private Task <List <Quarter> > SetAndGetQuartersAsync() { Utility util = new Utility(_config); //if current quarter session value is null, query current quarter and set if (_httpContextAccessor.HttpContext.Session.Get <Quarter>(_appSettings.SessionKey_SelectedQuarter) == null) { //get current quarter and set it in the session Quarter curQuarter = util.getCurrentQuarter(_context); _httpContextAccessor.HttpContext.Session.Set <Quarter>(_appSettings.SessionKey_SelectedQuarter, curQuarter); Quarter quar = _httpContextAccessor.HttpContext.Session.Get <Quarter>(_appSettings.SessionKey_SelectedQuarter); //_logger.LogDebug(quar.Id); } return(util.getQuarters(_context, 10).ToListAsync()); }
public void PushQuarter(Quarter q) { if (currentIndex >= maxSize) { for (int i = 0; i < quarters.Length - 1; i++) { quarters[i] = quarters[i + 1]; } quarters[maxSize - 1] = q; } else { quarters[currentIndex] = q; currentIndex++; } }
public ReturnToReturnViewModelMapTests() { map = new ReturnToReturnViewModelMap(new TonnageUtilities()); mapperTestId = Guid.NewGuid(); mapperTestYear = 2019; mapperTestQuarter = new Quarter(mapperTestYear, QuarterType.Q1); mapperTestQuarterWindow = new QuarterWindow(new DateTime(mapperTestYear, 4, 1), new DateTime(mapperTestYear + 1, 3, 31), QuarterType.Q1); mapperTestPeriod = "Q1 Jan - Mar"; mapperTestNonObligatedData = new List <NonObligatedData>(); mapperTestObligatedReceivedData = new List <WeeeObligatedData>(); mapperTestObligatedReusedData = new List <WeeeObligatedData>(); mapperTestObligatedSentOnData = new List <WeeeObligatedData>(); mapperTestScheme = new Scheme(Guid.NewGuid(), "Test Scheme"); mapperTestAatf = new AatfData(mapperTestId, "Test Aatf", "Aatf approval", (Int16)2019); mapperTestAatfList = new List <AatfData>(); }
public static DateTime GetEndOfQuarter(int year, Quarter qtr) { switch (qtr) { case Quarter.First: return(new DateTime(year, 3, DateTime.DaysInMonth(year, 3), 23, 59, 59, 999)); case Quarter.Second: return(new DateTime(year, 6, DateTime.DaysInMonth(year, 6), 23, 59, 59, 999)); case Quarter.Third: return(new DateTime(year, 9, DateTime.DaysInMonth(year, 9), 23, 59, 59, 999)); default: return(new DateTime(year, 12, DateTime.DaysInMonth(year, 12), 23, 59, 59, 999)); } }
public static DateTime GetStartOfQuarter(int year, Quarter qtr) { switch (qtr) { case Quarter.First: return(new DateTime(year, 1, 1, 0, 0, 0, 0)); case Quarter.Second: return(new DateTime(year, 4, 1, 0, 0, 0, 0)); case Quarter.Third: return(new DateTime(year, 7, 1, 0, 0, 0, 0)); default: return(new DateTime(year, 10, 1, 0, 0, 0, 0)); } }
public void Build_InputContractsAllEqualAndNoSeasonalAdjustments_ResultsInFlatCurve() { const double flatPrice = 84.54; var curve = new MaxSmoothnessSplineCurveBuilder <Day>() .AddContract(Month.CreateJanuary(2019), flatPrice) .AddContract(Month.CreateFebruary(2019), flatPrice) .AddContract(Month.CreateMarch(2019), flatPrice) .AddContract(Quarter.CreateQuarter2(2019), flatPrice) .AddContract(Quarter.CreateQuarter3(2019), flatPrice) .AddContract(Season.CreateWinter(2019), flatPrice) .BuildCurve(); foreach (double price in curve.Data) { Assert.AreEqual(flatPrice, price, 1E-12); } }
public static DateTime GetEndOfQuarter(int Year, Quarter Qtr) { if (Qtr == Quarter.First) // 1st Quarter = January 1 to March 31 { return(new DateTime(Year, 3, DateTime.DaysInMonth(Year, 3), 23, 59, 59)); } if (Qtr == Quarter.Second) // 2nd Quarter = April 1 to June 30 { return(new DateTime(Year, 6, DateTime.DaysInMonth(Year, 6), 23, 59, 59)); } if (Qtr == Quarter.Third) // 3rd Quarter = July 1 to September 30 { return(new DateTime(Year, 9, DateTime.DaysInMonth(Year, 9), 23, 59, 59)); } // 4th Quarter = October 1 to December 31 return(new DateTime(Year, 12, DateTime.DaysInMonth(Year, 12), 23, 59, 59)); }
public async Task FetchResultsAsync_WithQ1ReturnDataWithOutputB2CAmount_ReturnsOneResultForQ1Type2B2C() { using (Weee.Tests.Core.Model.DatabaseWrapper wrapper = new Weee.Tests.Core.Model.DatabaseWrapper()) { // Arrange Organisation organisation = Organisation.CreateSoleTrader("Test Organisation"); Scheme scheme = new Scheme(organisation); RegisteredProducer registeredProducer1 = new RegisteredProducer("WEE/AA1111AA", 2099, scheme); Quarter quarter = new Quarter(2099, QuarterType.Q1); DataReturn dataReturn = new DataReturn(scheme, quarter); DataReturnVersion version = new DataReturnVersion(dataReturn); EeeOutputAmount amount1 = new EeeOutputAmount( ObligationType.B2C, WeeeCategory.LargeHouseholdAppliances, 123.456m, registeredProducer1); version.EeeOutputReturnVersion.AddEeeOutputAmount(amount1); wrapper.WeeeContext.DataReturns.Add(dataReturn); await wrapper.WeeeContext.SaveChangesAsync(); dataReturn.SetCurrentVersion(version); await wrapper.WeeeContext.SaveChangesAsync(); // Act FetchSummaryCsvDataAccess dataAccess = new FetchSummaryCsvDataAccess(wrapper.WeeeContext); List <DataReturnSummaryCsvData> results = await dataAccess.FetchResultsAsync(scheme.Id, 2099); // Assert Assert.NotNull(results); Assert.Equal(1, results.Count); DataReturnSummaryCsvData result = results[0]; Assert.NotNull(result); Assert.Equal(1, result.Quarter); Assert.Equal(2, result.Type); Assert.Equal(null, result.Source); Assert.Equal("B2C", result.ObligationType); } }
public async void GetNextQuarterWindow_CurrentIsQ1_ReturnsQ2() { Quarter quarter = new Quarter(2019, QuarterType.Q1); QuarterWindowTemplate quarterWindowTemplate = QuarterWindowTemplate(7, 1, 0, 1); A.CallTo(() => dataAccess.GetByQuarter(((int)quarter.Q) + 1)).Returns(quarterWindowTemplate); QuarterWindow result = await quarterWindowFactory.GetNextQuarterWindow(QuarterType.Q1, 2019); result.StartDate.Year.Should().Be(2019); result.StartDate.Month.Should().Be(07); result.StartDate.Day.Should().Be(01); result.EndDate.Year.Should().Be(2020); result.EndDate.Month.Should().Be(03); result.EndDate.Day.Should().Be(16); Assert.Equal(QuarterType.Q2, result.QuarterType); }
public DataSource() { //// appData appData = new List<Quarter>(); var quarterNames = "Q1, Q2, Q3, Q4".Split(','); var salesData = new[] { 6833, 11100, 10833, 15350 }; var downloadsData = new[] { 8500, 7933, 11666, 12350 }; var expensesData = new[] { 11166, 10166, 7333, 8166 }; for (int i = 0; i < 4; i++) { Quarter tempQuarter = new Quarter(); tempQuarter.Name = quarterNames[i]; tempQuarter.Sales = salesData[i]; tempQuarter.Downloads = downloadsData[i]; tempQuarter.Expenses = expensesData[i]; appData.Add(tempQuarter); } }
public void CalendarQuarterOfYearTest() { int currentYear = ClockProxy.Clock.Now.Year; TimeCalendar timeCalendar = TimeCalendar.New( YearMonth.October ); Year calendarYear = new Year( currentYear, timeCalendar ); Assert.AreEqual( calendarYear.YearBaseMonth, YearMonth.October ); Assert.AreEqual( calendarYear.BaseYear, currentYear ); Assert.AreEqual( calendarYear.Start, new DateTime( currentYear, 10, 1 ) ); Assert.AreEqual( calendarYear.End, calendarYear.Calendar.MapEnd( calendarYear.Start.AddYears( 1 ) ) ); // Q1 Quarter q1 = new Quarter( calendarYear.BaseYear, YearQuarter.First, timeCalendar ); Assert.AreEqual( q1.YearBaseMonth, calendarYear.YearBaseMonth ); Assert.AreEqual( q1.BaseYear, calendarYear.BaseYear ); Assert.AreEqual( q1.Start, new DateTime( currentYear, 10, 1 ) ); Assert.AreEqual( q1.End, q1.Calendar.MapEnd( q1.Start.AddMonths( 3 ) ) ); // Q2 Quarter q2 = new Quarter( calendarYear.BaseYear, YearQuarter.Second, timeCalendar ); Assert.AreEqual( q2.YearBaseMonth, calendarYear.YearBaseMonth ); Assert.AreEqual( q2.BaseYear, calendarYear.BaseYear ); Assert.AreEqual( q2.Start, new DateTime( currentYear + 1, 1, 1 ) ); Assert.AreEqual( q2.End, q2.Calendar.MapEnd( q2.Start.AddMonths( 3 ) ) ); // Q3 Quarter q3 = new Quarter( calendarYear.BaseYear, YearQuarter.Third, timeCalendar ); Assert.AreEqual( q3.YearBaseMonth, calendarYear.YearBaseMonth ); Assert.AreEqual( q3.BaseYear, calendarYear.BaseYear ); Assert.AreEqual( q3.Start, new DateTime( currentYear + 1, 4, 1 ) ); Assert.AreEqual( q3.End, q3.Calendar.MapEnd( q3.Start.AddMonths( 3 ) ) ); // Q4 Quarter q4 = new Quarter( calendarYear.BaseYear, YearQuarter.Fourth, timeCalendar ); Assert.AreEqual( q4.YearBaseMonth, calendarYear.YearBaseMonth ); Assert.AreEqual( q4.BaseYear, calendarYear.BaseYear ); Assert.AreEqual( q4.Start, new DateTime( currentYear + 1, 7, 1 ) ); Assert.AreEqual( q4.End, q4.Calendar.MapEnd( q4.Start.AddMonths( 3 ) ) ); }
public void InitControls(IEnumerable<Quarter> quarters, Quarter selectedQuarter) { SelectedQuarter = selectedQuarter; Controls.Clear(); _quarterButtons.Clear(); foreach (var quarter in quarters) { var button = new ButtonX { ColorTable = eButtonColor.OrangeWithBackground, Style = eDotNetBarStyle.StyleManagerControlled, Text = quarter.ToString(), Cursor = Cursors.Hand, Tag = quarter, Checked = quarter == SelectedQuarter, Height = ButtonHeight, Width = ButtonWidth }; button.Click += OnQuarterClick; _quarterButtons.Add(button); Controls.Add(button); } ResizeButtons(); }
private void SetupPartitions() { if (s_quran_metadata == null) { LoadQuranMetadata(); } if (s_quran_metadata != null) { // setup Chapters for (int i = 0; i < s_quran_metadata.Chapters.Length; i++) { int number = s_quran_metadata.Chapters[i].Number; int verse_count = s_quran_metadata.Chapters[i].Verses; int first_verse = s_quran_metadata.Chapters[i].FirstVerse; int last_verse = first_verse + verse_count; string name = s_quran_metadata.Chapters[i].Name; string transliterated_name = s_quran_metadata.Chapters[i].TransliteratedName; string english_name = s_quran_metadata.Chapters[i].EnglishName; int revelation_order = s_quran_metadata.Chapters[i].RevelationOrder; RevelationPlace revelation_place = s_quran_metadata.Chapters[i].RevelationPlace; int bowing_count = s_quran_metadata.Chapters[i].Bowings; List<Verse> verses = new List<Verse>(); if (this.verses != null) { for (int j = first_verse; j < last_verse; j++) { int index = j - 1; if ((index >= 0) && (index < this.verses.Count)) { Verse verse = this.verses[index]; verses.Add(verse); } else { break; } } Chapter chapter = new Chapter(number, name, transliterated_name, english_name, revelation_order, revelation_place, bowing_count, verses); this.chapters.Add(chapter); } } // setup Bowings for (int i = 0; i < s_quran_metadata.Bowings.Length; i++) { int number = s_quran_metadata.Bowings[i].Number; int start_chapter = s_quran_metadata.Bowings[i].StartChapter; int start_chapter_verse = s_quran_metadata.Bowings[i].StartChapterVerse; int first_verse = 0; for (int j = 0; j < start_chapter - 1; j++) { first_verse += this.chapters[j].Verses.Count; } first_verse += start_chapter_verse; int next_bowing_first_verse = 0; if (i < s_quran_metadata.Bowings.Length - 1) { int next_bowing_start_chapter = s_quran_metadata.Bowings[i + 1].StartChapter; int next_bowing_start_chapter_verse = s_quran_metadata.Bowings[i + 1].StartChapterVerse; for (int j = 0; j < next_bowing_start_chapter - 1; j++) { next_bowing_first_verse += this.chapters[j].Verses.Count; } next_bowing_first_verse += next_bowing_start_chapter_verse; } else { next_bowing_first_verse = Verse.MAX_NUMBER + 1; } int last_verse = next_bowing_first_verse; List<Verse> verses = new List<Verse>(); for (int j = first_verse; j < last_verse; j++) { int index = j - 1; if ((index >= 0) && (index < this.verses.Count)) { Verse verse = this.verses[index]; verses.Add(verse); } else { break; } } Bowing bowing = new Bowing(number, verses); this.bowings.Add(bowing); } // setup Group for (int i = 0; i < s_quran_metadata.Groups.Length; i++) { int number = s_quran_metadata.Groups[i].Number; int start_chapter = s_quran_metadata.Groups[i].StartChapter; int start_chapter_verse = s_quran_metadata.Groups[i].StartChapterVerse; int first_verse = 0; for (int j = 0; j < start_chapter - 1; j++) { first_verse += this.chapters[j].Verses.Count; } first_verse += start_chapter_verse; int next_group_first_verse = 0; if (i < s_quran_metadata.Groups.Length - 1) { int next_group_start_chapter = s_quran_metadata.Groups[i + 1].StartChapter; int next_group_start_chapter_verse = s_quran_metadata.Groups[i + 1].StartChapterVerse; for (int j = 0; j < next_group_start_chapter - 1; j++) { next_group_first_verse += this.chapters[j].Verses.Count; } next_group_first_verse += next_group_start_chapter_verse; } else { next_group_first_verse = Verse.MAX_NUMBER + 1; } int last_verse = next_group_first_verse; List<Verse> verses = new List<Verse>(); for (int j = first_verse; j < last_verse; j++) { int index = j - 1; if ((index >= 0) && (index < this.verses.Count)) { Verse verse = this.verses[index]; verses.Add(verse); } else { break; } } Model.Group group = new Model.Group(number, verses); this.groups.Add(group); } // setup Quarters for (int i = 0; i < s_quran_metadata.Quarters.Length; i++) { int number = s_quran_metadata.Quarters[i].Number; int start_chapter = s_quran_metadata.Quarters[i].StartChapter; int start_chapter_verse = s_quran_metadata.Quarters[i].StartChapterVerse; int first_verse = 0; for (int j = 0; j < start_chapter - 1; j++) { first_verse += this.chapters[j].Verses.Count; } first_verse += start_chapter_verse; int next_group_quarter_first_verse = 0; if (i < s_quran_metadata.Quarters.Length - 1) { int next_group_quarter_start_chapter = s_quran_metadata.Quarters[i + 1].StartChapter; int next_group_quarter_start_chapter_verse = s_quran_metadata.Quarters[i + 1].StartChapterVerse; for (int j = 0; j < next_group_quarter_start_chapter - 1; j++) { next_group_quarter_first_verse += this.chapters[j].Verses.Count; } next_group_quarter_first_verse += next_group_quarter_start_chapter_verse; } else { next_group_quarter_first_verse = Verse.MAX_NUMBER + 1; } int last_verse = next_group_quarter_first_verse; List<Verse> verses = new List<Verse>(); for (int j = first_verse; j < last_verse; j++) { int index = j - 1; if ((index >= 0) && (index < this.verses.Count)) { Verse verse = this.verses[index]; verses.Add(verse); } else { break; } } Quarter group_quarter = new Quarter(number, verses); this.quarters.Add(group_quarter); } // setup Pages for (int i = 0; i < s_quran_metadata.Pages.Length; i++) { int number = s_quran_metadata.Pages[i].Number; int start_chapter = s_quran_metadata.Pages[i].StartChapter; int start_chapter_verse = s_quran_metadata.Pages[i].StartChapterVerse; int first_verse = 0; for (int j = 0; j < start_chapter - 1; j++) { first_verse += this.chapters[j].Verses.Count; } first_verse += start_chapter_verse; int next_page_first_verse = 0; if (i < s_quran_metadata.Pages.Length - 1) { int next_page_start_chapter = s_quran_metadata.Pages[i + 1].StartChapter; int next_page_start_chapter_verse = s_quran_metadata.Pages[i + 1].StartChapterVerse; for (int j = 0; j < next_page_start_chapter - 1; j++) { next_page_first_verse += this.chapters[j].Verses.Count; } next_page_first_verse += next_page_start_chapter_verse; } else { next_page_first_verse = Verse.MAX_NUMBER + 1; } int last_verse = next_page_first_verse; List<Verse> verses = new List<Verse>(); for (int j = first_verse; j < last_verse; j++) { int index = j - 1; if ((index >= 0) && (index < this.verses.Count)) { Verse verse = this.verses[index]; verses.Add(verse); } else { break; } } Page page = new Page(number, verses); this.pages.Add(page); } // setup Parts for (int i = 0; i < s_quran_metadata.Parts.Length; i++) { int number = s_quran_metadata.Parts[i].Number; int start_chapter = s_quran_metadata.Parts[i].StartChapter; int start_chapter_verse = s_quran_metadata.Parts[i].StartChapterVerse; int first_verse = 0; for (int j = 0; j < start_chapter - 1; j++) { first_verse += this.chapters[j].Verses.Count; } first_verse += start_chapter_verse; int next_part_first_verse = 0; if (i < s_quran_metadata.Parts.Length - 1) { int next_part_start_chapter = s_quran_metadata.Parts[i + 1].StartChapter; int next_part_start_chapter_verse = s_quran_metadata.Parts[i + 1].StartChapterVerse; for (int j = 0; j < next_part_start_chapter - 1; j++) { next_part_first_verse += this.chapters[j].Verses.Count; } next_part_first_verse += next_part_start_chapter_verse; } else { next_part_first_verse = Verse.MAX_NUMBER + 1; } int last_verse = next_part_first_verse; List<Verse> verses = new List<Verse>(); for (int j = first_verse; j < last_verse; j++) { int index = j - 1; if ((index >= 0) && (index < this.verses.Count)) { Verse verse = this.verses[index]; verses.Add(verse); } else { break; } } Part part = new Part(number, verses); this.parts.Add(part); } // setup Stations for (int i = 0; i < s_quran_metadata.Stations.Length; i++) { int number = s_quran_metadata.Stations[i].Number; int start_chapter = s_quran_metadata.Stations[i].StartChapter; int start_chapter_verse = s_quran_metadata.Stations[i].StartChapterVerse; int first_verse = 0; for (int j = 0; j < start_chapter - 1; j++) { first_verse += this.chapters[j].Verses.Count; } first_verse += start_chapter_verse; int next_station_first_verse = 0; if (i < s_quran_metadata.Stations.Length - 1) { int next_station_start_chapter = s_quran_metadata.Stations[i + 1].StartChapter; int next_station_start_chapter_verse = s_quran_metadata.Stations[i + 1].StartChapterVerse; for (int j = 0; j < next_station_start_chapter - 1; j++) { next_station_first_verse += this.chapters[j].Verses.Count; } next_station_first_verse += next_station_start_chapter_verse; } else { next_station_first_verse = Verse.MAX_NUMBER + 1; } int last_verse = next_station_first_verse; List<Verse> verses = new List<Verse>(); for (int j = first_verse; j < last_verse; j++) { int index = j - 1; if ((index >= 0) && (index < this.verses.Count)) { Verse verse = this.verses[index]; verses.Add(verse); } else { break; } } Station station = new Station(number, verses); this.stations.Add(station); } // setup Prostration for (int i = 0; i < s_quran_metadata.Prostrations.Length; i++) { int number = s_quran_metadata.Prostrations[i].Number; int chapter = s_quran_metadata.Prostrations[i].Chapter; int chapter_verse = s_quran_metadata.Prostrations[i].ChapterVerse; ProstrationType type = s_quran_metadata.Prostrations[i].Type; int first_verse = 0; for (int j = 0; j < chapter - 1; j++) { first_verse += this.chapters[j].Verses.Count; } first_verse += chapter_verse; if (this.verses.Count > first_verse - 1) { Verse verse = this.verses[first_verse - 1]; Prostration prostration = new Prostration(number, type, verse); this.prostrations.Add(prostration); } else { break; } } // update verse/word/letter numbers AND // update distances to previous same verse/word/letter UpdateNumbersAndDistances(SelectionScope.Book); } }
public static IEnumerable<Quarter> GetNextnCurrentQuarter(DateTime date) { var list = new List<Quarter>(); var currentQtr = GetCurrentQuarter(DateTime.Now); list.Add(currentQtr); var nextQtr = new Quarter(); if (currentQtr.QuarterId == 1) { nextQtr = Quarters.FirstOrDefault(q => q.QuarterId == 2); var qtrYr = nextQtr.QuarterDescription + " " + date.AddYears(1).Year; nextQtr.QuarterYear = qtrYr; } else { nextQtr = Quarters.FirstOrDefault(q => q.QuarterId == currentQtr.QuarterId + 1); var qtrYr = nextQtr.QuarterDescription + " " + date.Year; nextQtr.QuarterYear = qtrYr; } list.Add(nextQtr); return list; }
public MySqlFunctionManager(bool allowFuncDefChange) { this.allowFuncDefChange = allowFuncDefChange; parsingStrateg["CAST"] = FunctionParsingStrategy.Cast; parsingStrateg["POSITION"] = FunctionParsingStrategy.Position; parsingStrateg["SUBSTR"] = FunctionParsingStrategy.Substring; parsingStrateg["SUBSTRING"] = FunctionParsingStrategy.Substring; parsingStrateg["TRIM"] = FunctionParsingStrategy.Trim; parsingStrateg["AVG"] = FunctionParsingStrategy.Avg; parsingStrateg["COUNT"] = FunctionParsingStrategy.Count; parsingStrateg["GROUP_CONCAT"] = FunctionParsingStrategy.GroupConcat; parsingStrateg["MAX"] = FunctionParsingStrategy.Max; parsingStrateg["MIN"] = FunctionParsingStrategy.Min; parsingStrateg["SUM"] = FunctionParsingStrategy.Sum; parsingStrateg["ROW"] = FunctionParsingStrategy.Row; parsingStrateg["CHAR"] = FunctionParsingStrategy.Char; parsingStrateg["CONVERT"] = FunctionParsingStrategy.Convert; parsingStrateg["EXTRACT"] = FunctionParsingStrategy.Extract; parsingStrateg["TIMESTAMPADD"] = FunctionParsingStrategy.Timestampadd; parsingStrateg["TIMESTAMPDIFF"] = FunctionParsingStrategy.Timestampdiff; parsingStrateg["GET_FORMAT"] = FunctionParsingStrategy.GetFormat; functionPrototype["ABS"] = new Abs(null); functionPrototype["ACOS"] = new Acos(null); functionPrototype["ADDDATE"] = new Adddate(null); functionPrototype["ADDTIME"] = new Addtime(null); functionPrototype["AES_DECRYPT"] = new AesDecrypt(null); functionPrototype["AES_ENCRYPT"] = new AesEncrypt(null); functionPrototype["ANALYSE"] = new Analyse(null); functionPrototype["ASCII"] = new Ascii(null); functionPrototype["ASIN"] = new Asin(null); functionPrototype["ATAN2"] = new Atan2(null); functionPrototype["ATAN"] = new Atan(null); functionPrototype["BENCHMARK"] = new Benchmark(null); functionPrototype["BIN"] = new Bin(null); functionPrototype["BIT_AND"] = new BitAnd(null); functionPrototype["BIT_COUNT"] = new BitCount(null); functionPrototype["BIT_LENGTH"] = new BitLength(null); functionPrototype["BIT_OR"] = new BitOR(null); functionPrototype["BIT_XOR"] = new BitXor(null); functionPrototype["CEIL"] = new Ceiling(null); functionPrototype["CEILING"] = new Ceiling(null); functionPrototype["CHAR_LENGTH"] = new CharLength(null); functionPrototype["CHARACTER_LENGTH"] = new CharLength(null); functionPrototype["CHARSET"] = new Charset(null); functionPrototype["COALESCE"] = new Coalesce(null); functionPrototype["COERCIBILITY"] = new Coercibility(null); functionPrototype["COLLATION"] = new Collation(null); functionPrototype["COMPRESS"] = new Compress(null); functionPrototype["CONCAT_WS"] = new ConcatWs(null); functionPrototype["CONCAT"] = new Concat(null); functionPrototype["CONNECTION_ID"] = new ConnectionId(null); functionPrototype["CONV"] = new Conv(null); functionPrototype["CONVERT_TZ"] = new ConvertTz(null); functionPrototype["COS"] = new Cos(null); functionPrototype["COT"] = new Cot(null); functionPrototype["CRC32"] = new Crc32(null); functionPrototype["CURDATE"] = new Curdate(); functionPrototype["CURRENT_DATE"] = new Curdate(); functionPrototype["CURRENT_TIME"] = new Curtime(); functionPrototype["CURTIME"] = new Curtime(); functionPrototype["CURRENT_TIMESTAMP"] = new Now(); functionPrototype["CURRENT_USER"] = new CurrentUser(); functionPrototype["CURTIME"] = new Curtime(); functionPrototype["DATABASE"] = new Database(null); functionPrototype["DATE_ADD"] = new DateAdd(null); functionPrototype["DATE_FORMAT"] = new DateFormat(null); functionPrototype["DATE_SUB"] = new DateSub(null); functionPrototype["DATE"] = new Date(null); functionPrototype["DATEDIFF"] = new Datediff(null); functionPrototype["DAY"] = new Dayofmonth(null); functionPrototype["DAYOFMONTH"] = new Dayofmonth(null); functionPrototype["DAYNAME"] = new Dayname(null); functionPrototype["DAYOFWEEK"] = new Dayofweek(null); functionPrototype["DAYOFYEAR"] = new Dayofyear(null); functionPrototype["DECODE"] = new Decode(null); functionPrototype["DEFAULT"] = new Default(null); functionPrototype["DEGREES"] = new Degrees(null); functionPrototype["DES_DECRYPT"] = new DesDecrypt(null); functionPrototype["DES_ENCRYPT"] = new DesEncrypt(null); functionPrototype["ELT"] = new Elt(null); functionPrototype["ENCODE"] = new Encode(null); functionPrototype["ENCRYPT"] = new Encrypt(null); functionPrototype["EXP"] = new Exp(null); functionPrototype["EXPORT_SET"] = new ExportSet(null); // functionPrototype.put("EXTRACT", new Extract(null)); functionPrototype["EXTRACTVALUE"] = new ExtractValue(null); functionPrototype["FIELD"] = new Field(null); functionPrototype["FIND_IN_SET"] = new FindInSet(null); functionPrototype["FLOOR"] = new Floor(null); functionPrototype["FORMAT"] = new Format(null); functionPrototype["FOUND_ROWS"] = new FoundRows(null); functionPrototype["FROM_DAYS"] = new FromDays(null); functionPrototype["FROM_UNIXTIME"] = new FromUnixtime(null); // functionPrototype.put("GET_FORMAT", new GetFormat(null)); functionPrototype["GET_LOCK"] = new GetLock(null); functionPrototype["GREATEST"] = new Greatest(null); functionPrototype["HEX"] = new Hex(null); functionPrototype["HOUR"] = new Hour(null); functionPrototype["IF"] = new IF(null); functionPrototype["IFNULL"] = new IFNull(null); functionPrototype["INET_ATON"] = new InetAton(null); functionPrototype["INET_NTOA"] = new InetNtoa(null); functionPrototype["INSERT"] = new Insert(null); functionPrototype["INSTR"] = new Instr(null); functionPrototype["INTERVAL"] = new Interval(null); functionPrototype["IS_FREE_LOCK"] = new IsFreeLock(null); functionPrototype["IS_USED_LOCK"] = new IsUsedLock(null); functionPrototype["ISNULL"] = new IsNull(null); functionPrototype["LAST_DAY"] = new LastDay(null); functionPrototype["LAST_INSERT_ID"] = new LastInsertId(null); functionPrototype["LCASE"] = new Lower(null); functionPrototype["LEAST"] = new Least(null); functionPrototype["LEFT"] = new Left(null); functionPrototype["LENGTH"] = new Length(null); functionPrototype["LN"] = new Log(null); // Ln(X) equals Log(X) functionPrototype["LOAD_FILE"] = new LoadFile(null); functionPrototype["LOCALTIME"] = new Now(); functionPrototype["LOCALTIMESTAMP"] = new Now(); functionPrototype["LOCATE"] = new Locate(null); functionPrototype["LOG10"] = new Log10(null); functionPrototype["LOG2"] = new Log2(null); functionPrototype["LOG"] = new Log(null); functionPrototype["LOWER"] = new Lower(null); functionPrototype["LPAD"] = new Lpad(null); functionPrototype["LTRIM"] = new Ltrim(null); functionPrototype["MAKE_SET"] = new MakeSet(null); functionPrototype["MAKEDATE"] = new Makedate(null); functionPrototype["MAKETIME"] = new Maketime(null); functionPrototype["MASTER_POS_WAIT"] = new MasterPosWait(null); functionPrototype["MD5"] = new Md5(null); functionPrototype["MICROSECOND"] = new Microsecond(null); functionPrototype["MID"] = new Substring(null); functionPrototype["MINUTE"] = new Minute(null); functionPrototype["MONTH"] = new Month(null); functionPrototype["MONTHNAME"] = new Monthname(null); functionPrototype["NAME_CONST"] = new NameConst(null); functionPrototype["NOW"] = new Now(); functionPrototype["NULLIF"] = new NullIF(null); functionPrototype["OCT"] = new Oct(null); functionPrototype["OCTET_LENGTH"] = new Length(null); functionPrototype["OLD_PASSWORD"] = new OldPassword(null); functionPrototype["ORD"] = new Ord(null); functionPrototype["PASSWORD"] = new Password(null); functionPrototype["PERIOD_ADD"] = new PeriodAdd(null); functionPrototype["PERIOD_DIFF"] = new PeriodDiff(null); functionPrototype["PI"] = new PI(null); functionPrototype["POW"] = new Pow(null); functionPrototype["POWER"] = new Pow(null); functionPrototype["QUARTER"] = new Quarter(null); functionPrototype["QUOTE"] = new Quote(null); functionPrototype["RADIANS"] = new Radians(null); functionPrototype["RAND"] = new Rand(null); functionPrototype["RELEASE_LOCK"] = new ReleaseLock(null); functionPrototype["REPEAT"] = new Repeat(null); functionPrototype["REPLACE"] = new Replace(null); functionPrototype["REVERSE"] = new Reverse(null); functionPrototype["RIGHT"] = new Right(null); functionPrototype["ROUND"] = new Round(null); functionPrototype["ROW_COUNT"] = new RowCount(null); functionPrototype["RPAD"] = new Rpad(null); functionPrototype["RTRIM"] = new Rtrim(null); functionPrototype["SCHEMA"] = new Database(null); functionPrototype["SEC_TO_TIME"] = new SecToTime(null); functionPrototype["SECOND"] = new Second(null); functionPrototype["SESSION_USER"] = new User(null); functionPrototype["SHA1"] = new Sha1(null); functionPrototype["SHA"] = new Sha1(null); functionPrototype["SHA2"] = new Sha2(null); functionPrototype["SIGN"] = new Sign(null); functionPrototype["SIN"] = new Sin(null); functionPrototype["SLEEP"] = new Sleep(null); functionPrototype["SOUNDEX"] = new Soundex(null); functionPrototype["SPACE"] = new Space(null); functionPrototype["SQRT"] = new Sqrt(null); functionPrototype["STD"] = new Std(null); functionPrototype["STDDEV_POP"] = new StdDevPop(null); functionPrototype["STDDEV_SAMP"] = new StdDevSamp(null); functionPrototype["STDDEV"] = new StdDev(null); functionPrototype["STR_TO_DATE"] = new StrToDate(null); functionPrototype["STRCMP"] = new Strcmp(null); functionPrototype["SUBDATE"] = new Subdate(null); functionPrototype["SUBSTRING_INDEX"] = new SubstringIndex(null); functionPrototype["SUBTIME"] = new Subtime(null); functionPrototype["SYSDATE"] = new Sysdate(null); functionPrototype["SYSTEM_USER"] = new User(null); functionPrototype["TAN"] = new Tan(null); functionPrototype["TIME_FORMAT"] = new TimeFormat(null); functionPrototype["TIME_TO_SEC"] = new TimeToSec(null); functionPrototype["TIME"] = new Time(null); functionPrototype["TIMEDIFF"] = new Timediff(null); functionPrototype["TIMESTAMP"] = new Timestamp(null); // functionPrototype.put("TIMESTAMPADD", new Timestampadd(null)); // functionPrototype.put("TIMESTAMPDIFF", new Timestampdiff(null)); functionPrototype["TO_DAYS"] = new ToDays(null); functionPrototype["TO_SECONDS"] = new ToSeconds(null); functionPrototype["TRUNCATE"] = new Truncate(null); functionPrototype["UCASE"] = new Upper(null); functionPrototype["UNCOMPRESS"] = new Uncompress(null); functionPrototype["UNCOMPRESSED_LENGTH"] = new UncompressedLength(null); functionPrototype["UNHEX"] = new Unhex(null); functionPrototype["UNIX_TIMESTAMP"] = new UnixTimestamp(null); functionPrototype["UPDATEXML"] = new UpdateXml(null); functionPrototype["UPPER"] = new Upper(null); functionPrototype["USER"] = new User(null); functionPrototype["UTC_DATE"] = new UtcDate(null); functionPrototype["UTC_TIME"] = new UtcTime(null); functionPrototype["UTC_TIMESTAMP"] = new UtcTimestamp(null); functionPrototype["UUID_SHORT"] = new UuidShort(null); functionPrototype["UUID"] = new Uuid(null); functionPrototype["VALUES"] = new Values(null); functionPrototype["VAR_POP"] = new VarPop(null); functionPrototype["VAR_SAMP"] = new VarSamp(null); functionPrototype["VARIANCE"] = new Variance(null); functionPrototype["VERSION"] = new Version(null); functionPrototype["WEEK"] = new Week(null); functionPrototype["WEEKDAY"] = new Weekday(null); functionPrototype["WEEKOFYEAR"] = new Weekofyear(null); functionPrototype["YEAR"] = new Year(null); functionPrototype["YEARWEEK"] = new Yearweek(null); }
partial void InsertQuarter(Quarter instance);
partial void UpdateQuarter(Quarter instance);
// ---------------------------------------------------------------------- private void UpdateSelectedPeriodInfo() { TimeCalendar timeCalendar = TimeCalendar.New( SelectedYearBaseMonth ); switch ( SelectedPeriodMode ) { case TimePeriodMode.Year: Year year = new Year( WorkingDate, timeCalendar ); periodInfo.Clear(); periodInfo.AddItem( "Year", year ); periodInfo.AddItem( "YearBaseMonth", year.YearBaseMonth ); periodInfo.AddItem( "IsCalendarYear", year.IsCalendarYear ); periodInfo.AddItem( "StartYear", year.StartYear ); periodInfo.AddItem( "FirstDayStart", year.FirstDayStart ); periodInfo.AddItem( "LastDayStart", year.LastDayStart ); periodInfo.AddItem( "LastMonthStart", year.LastMonthStart ); periodInfo.AddItem( "YearName", year.YearName ); periodInfo.AddSection( "Previous/Next" ); periodInfo.AddItem( "Previous", year.GetPreviousYear() ); periodInfo.AddItem( "Next", year.GetNextYear() ); periodInfo.AddSubitems( "Halfyears", year.GetHalfyears() ); periodInfo.AddSubitems( "Quarters", year.GetQuarters() ); periodInfo.AddSubitems( "Months", year.GetMonths() ); SelectedPeriodInfo = periodInfo.ToString(); break; case TimePeriodMode.Halfyear: Halfyear halfyear = new Halfyear( WorkingDate, timeCalendar ); periodInfo.Clear(); periodInfo.AddItem( "Halfyear", halfyear ); periodInfo.AddItem( "YearBaseMonth", halfyear.YearBaseMonth ); periodInfo.AddItem( "StartMonth", halfyear.StartMonth ); periodInfo.AddItem( "Year", halfyear.Year ); periodInfo.AddItem( "YearHalfyear", halfyear.YearHalfyear ); periodInfo.AddItem( "IsCalendarHalfyear", halfyear.IsCalendarHalfyear ); periodInfo.AddItem( "MultipleCalendarYears", halfyear.MultipleCalendarYears ); periodInfo.AddItem( "HalfyearName", halfyear.HalfyearName ); periodInfo.AddItem( "HalfyearOfYearName", halfyear.HalfyearOfYearName ); periodInfo.AddItem( "LastDayStart", halfyear.LastDayStart ); periodInfo.AddItem( "LastMonthStart", halfyear.LastMonthStart ); periodInfo.AddSection( "Previous/Next" ); periodInfo.AddItem( "Previousr", halfyear.GetPreviousHalfyear() ); periodInfo.AddItem( "Next", halfyear.GetNextHalfyear() ); periodInfo.AddSubitems( "Quarters", halfyear.GetQuarters() ); periodInfo.AddSubitems( "Months", halfyear.GetMonths() ); SelectedPeriodInfo = periodInfo.ToString(); break; case TimePeriodMode.Quarter: Quarter quarter = new Quarter( WorkingDate, timeCalendar ); periodInfo.Clear(); periodInfo.AddItem( "Quarter", quarter ); periodInfo.AddItem( "YearBaseMonth", quarter.YearBaseMonth ); periodInfo.AddItem( "StartMonth", quarter.StartMonth ); periodInfo.AddItem( "Year", quarter.Year ); periodInfo.AddItem( "YearQuarter", quarter.YearQuarter ); periodInfo.AddItem( "IsCalendarQuarter", quarter.IsCalendarQuarter ); periodInfo.AddItem( "MultipleCalendarYears", quarter.MultipleCalendarYears ); periodInfo.AddItem( "QuarterName", quarter.QuarterName ); periodInfo.AddItem( "QuarterOfYearName", quarter.QuarterOfYearName ); periodInfo.AddItem( "LastDayStart", quarter.FirstDayStart ); periodInfo.AddItem( "LastMonthStart", quarter.LastDayStart ); periodInfo.AddSection( "Previous/Next" ); periodInfo.AddItem( "Previous", quarter.GetPreviousQuarter() ); periodInfo.AddItem( "Next", quarter.GetNextQuarter() ); periodInfo.AddSubitems( "Months", quarter.GetMonths() ); SelectedPeriodInfo = periodInfo.ToString(); break; case TimePeriodMode.Month: Month month = new Month( WorkingDate, timeCalendar ); periodInfo.Clear(); periodInfo.AddItem( "Month", month ); periodInfo.AddItem( "YearBaseMonth", month.YearMonth ); periodInfo.AddItem( "Year", month.Year ); periodInfo.AddItem( "DaysInMonth", month.DaysInMonth ); periodInfo.AddItem( "MonthName", month.MonthName ); periodInfo.AddItem( "MonthOfYearName", month.MonthOfYearName ); periodInfo.AddItem( "LastDayStart", month.FirstDayStart ); periodInfo.AddItem( "LastMonthStart", month.LastDayStart ); periodInfo.AddSection( "Previous/Next" ); periodInfo.AddItem( "Previous", month.GetPreviousMonth() ); periodInfo.AddItem( "Next", month.GetNextMonth() ); periodInfo.AddSubitems( "Days", month.GetDays() ); SelectedPeriodInfo = periodInfo.ToString(); break; case TimePeriodMode.Week: Week week = new Week( WorkingDate, timeCalendar ); periodInfo.Clear(); periodInfo.AddItem( "Week", week ); periodInfo.AddItem( "MultipleCalendarYears", week.MultipleCalendarYears ); periodInfo.AddItem( "FirstDayStart", week.FirstDayStart ); periodInfo.AddItem( "FirstDayOfWeek", week.FirstDayOfWeek ); periodInfo.AddItem( "LastDayStart", week.LastDayStart ); periodInfo.AddItem( "LastDayOfWeek", week.LastDayOfWeek ); periodInfo.AddItem( "WeekOfYear", week.WeekOfYear ); periodInfo.AddItem( "WeekOfYearName", week.WeekOfYearName ); periodInfo.AddSection( "Previous/Next" ); periodInfo.AddItem( "Previous", week.GetPreviousWeek() ); periodInfo.AddItem( "Next", week.GetNextWeek() ); periodInfo.AddSubitems( "Days", week.GetDays() ); SelectedPeriodInfo = periodInfo.ToString(); break; case TimePeriodMode.Day: Day day = new Day( WorkingDate, timeCalendar ); periodInfo.Clear(); periodInfo.AddItem( "Day", day ); periodInfo.AddItem( "Year", day.Year ); periodInfo.AddItem( "FirstDayStart", day.FirstDayStart ); periodInfo.AddItem( "Month", day.Month ); periodInfo.AddItem( "DayValue", day.DayValue ); periodInfo.AddItem( "DayOfWeek", day.DayOfWeek ); periodInfo.AddItem( "DayName", day.DayName ); periodInfo.AddItem( "FirstHourStart", day.FirstHourStart ); periodInfo.AddItem( "LastHourStart", day.LastHourStart ); periodInfo.AddSection( "Previous/Next" ); periodInfo.AddItem( "Previous", day.GetPreviousDay() ); periodInfo.AddItem( "Next", day.GetNextDay() ); periodInfo.AddSubitems( "Hours", day.GetHours() ); SelectedPeriodInfo = periodInfo.ToString(); break; case TimePeriodMode.Hour: Hour hour = new Hour( WorkingDate, timeCalendar ); periodInfo.Clear(); periodInfo.AddItem( "Hour", hour ); periodInfo.AddItem( "Year", hour.Year ); periodInfo.AddItem( "Month", hour.Month ); periodInfo.AddItem( "Day", hour.Day ); periodInfo.AddItem( "HourValue", hour.HourValue ); periodInfo.AddItem( "FirstMinuteStart", hour.FirstMinuteStart ); periodInfo.AddItem( "LastMinuteStart", hour.LastMinuteStart ); periodInfo.AddSection( "Previous/Next" ); periodInfo.AddItem( "Previous", hour.GetPreviousHour() ); periodInfo.AddItem( "Next", hour.GetNextHour() ); periodInfo.AddSubitems( "Minutes", hour.GetMinutes() ); SelectedPeriodInfo = periodInfo.ToString(); break; case TimePeriodMode.Minute: Minute minute = new Minute( WorkingDate, timeCalendar ); periodInfo.Clear(); periodInfo.AddItem( "Minute", minute ); periodInfo.AddItem( "Year", minute.Year ); periodInfo.AddItem( "Month", minute.Month ); periodInfo.AddItem( "Day", minute.Day ); periodInfo.AddItem( "Hour", minute.Hour ); periodInfo.AddItem( "MinuteValue", minute.MinuteValue ); periodInfo.AddSection( "Previous/Next" ); periodInfo.AddItem( "Previous", minute.GetPreviousMinute() ); periodInfo.AddItem( "Next", minute.GetNextMinute() ); SelectedPeriodInfo = periodInfo.ToString(); break; } }
public void InitValuesTest() { DateTime now = ClockProxy.Clock.Now; DateTime firstQuarter = new DateTime( now.Year, 1, 1 ); DateTime secondQuarter = firstQuarter.AddMonths( TimeSpec.MonthsPerQuarter ); Quarter quarter = new Quarter( now.Year, YearQuarter.First, TimeCalendar.NewEmptyOffset() ); Assert.AreEqual( quarter.Start.Year, firstQuarter.Year ); Assert.AreEqual( quarter.Start.Month, firstQuarter.Month ); Assert.AreEqual( quarter.Start.Day, firstQuarter.Day ); Assert.AreEqual( quarter.Start.Hour, 0 ); Assert.AreEqual( quarter.Start.Minute, 0 ); Assert.AreEqual( quarter.Start.Second, 0 ); Assert.AreEqual( quarter.Start.Millisecond, 0 ); Assert.AreEqual( quarter.End.Year, secondQuarter.Year ); Assert.AreEqual( quarter.End.Month, secondQuarter.Month ); Assert.AreEqual( quarter.End.Day, secondQuarter.Day ); Assert.AreEqual( quarter.End.Hour, 0 ); Assert.AreEqual( quarter.End.Minute, 0 ); Assert.AreEqual( quarter.End.Second, 0 ); Assert.AreEqual( quarter.End.Millisecond, 0 ); }
partial void DeleteQuarter(Quarter instance);
public void CurrentQuarterTest() { int currentYear = ClockProxy.Clock.Now.Year; Quarter quarter = new Quarter( currentYear, YearQuarter.First ); Assert.AreEqual( quarter.BaseYear, currentYear ); }
public void CalendarYearQuarterTest() { int currentYear = ClockProxy.Clock.Now.Year; TimeCalendar calendar = TimeCalendar.New( TimeSpan.Zero, TimeSpan.Zero ); Quarter current = new Quarter( currentYear, YearQuarter.First ); Assert.AreEqual( current.GetNextQuarter().GetNextQuarter().GetNextQuarter().GetNextQuarter().YearQuarter, current.YearQuarter ); Assert.AreEqual( current.GetPreviousQuarter().GetPreviousQuarter().GetPreviousQuarter().GetPreviousQuarter().YearQuarter, current.YearQuarter ); Quarter q1 = new Quarter( currentYear, YearQuarter.First, calendar ); Assert.IsTrue( q1.IsReadOnly ); Assert.AreEqual( q1.YearQuarter, YearQuarter.First ); Assert.AreEqual( q1.Start, new DateTime( currentYear, TimeSpec.FirstQuarterMonthIndex, 1 ) ); Assert.AreEqual( q1.End, new DateTime( currentYear, TimeSpec.SecondQuarterMonthIndex, 1 ) ); Quarter q2 = new Quarter( currentYear, YearQuarter.Second, calendar ); Assert.IsTrue( q2.IsReadOnly ); Assert.AreEqual( q2.YearQuarter, YearQuarter.Second ); Assert.AreEqual( q2.Start, new DateTime( currentYear, TimeSpec.SecondQuarterMonthIndex, 1 ) ); Assert.AreEqual( q2.End, new DateTime( currentYear, TimeSpec.ThirdQuarterMonthIndex, 1 ) ); Quarter q3 = new Quarter( currentYear, YearQuarter.Third, calendar ); Assert.IsTrue( q3.IsReadOnly ); Assert.AreEqual( q3.YearQuarter, YearQuarter.Third ); Assert.AreEqual( q3.Start, new DateTime( currentYear, TimeSpec.ThirdQuarterMonthIndex, 1 ) ); Assert.AreEqual( q3.End, new DateTime( currentYear, TimeSpec.FourthQuarterMonthIndex, 1 ) ); Quarter q4 = new Quarter( currentYear, YearQuarter.Fourth, calendar ); Assert.IsTrue( q4.IsReadOnly ); Assert.AreEqual( q4.YearQuarter, YearQuarter.Fourth ); Assert.AreEqual( q4.Start, new DateTime( currentYear, TimeSpec.FourthQuarterMonthIndex, 1 ) ); Assert.AreEqual( q4.End, new DateTime( currentYear + 1, TimeSpec.FirstQuarterMonthIndex, 1 ) ); }
public void AddQuartersTest() { int currentYear = ClockProxy.Clock.Now.Year; const YearMonth yearStartMonth = YearMonth.April; TimeCalendar calendar = TimeCalendar.New( TimeSpan.Zero, TimeSpan.Zero, yearStartMonth ); DateTime calendarStartDate = new DateTime( currentYear, 4, 1 ); Quarter calendarQuarter = new Quarter( currentYear, YearQuarter.First, calendar ); Assert.AreEqual( calendarQuarter.AddQuarters( 0 ), calendarQuarter ); Quarter prevQ1 = calendarQuarter.AddQuarters( -1 ); Assert.AreEqual( prevQ1.YearQuarter, YearQuarter.Fourth ); Assert.AreEqual( prevQ1.BaseYear, currentYear - 1 ); Assert.AreEqual( prevQ1.Start, calendarStartDate.AddMonths( -3 ) ); Assert.AreEqual( prevQ1.End, calendarStartDate ); Quarter prevQ2 = calendarQuarter.AddQuarters( -2 ); Assert.AreEqual( prevQ2.YearQuarter, YearQuarter.Third ); Assert.AreEqual( prevQ2.BaseYear, currentYear - 1 ); Assert.AreEqual( prevQ2.Start, calendarStartDate.AddMonths( -6 ) ); Assert.AreEqual( prevQ2.End, calendarStartDate.AddMonths( -3 ) ); Quarter prevQ3 = calendarQuarter.AddQuarters( -3 ); Assert.AreEqual( prevQ3.YearQuarter, YearQuarter.Second ); Assert.AreEqual( prevQ3.BaseYear, currentYear - 1 ); Assert.AreEqual( prevQ3.Start, calendarStartDate.AddMonths( -9 ) ); Assert.AreEqual( prevQ3.End, calendarStartDate.AddMonths( -6 ) ); Quarter prevQ4 = calendarQuarter.AddQuarters( -4 ); Assert.AreEqual( prevQ4.YearQuarter, YearQuarter.First ); Assert.AreEqual( prevQ4.BaseYear, currentYear - 1 ); Assert.AreEqual( prevQ4.Start, calendarStartDate.AddMonths( -12 ) ); Assert.AreEqual( prevQ4.End, calendarStartDate.AddMonths( -9 ) ); Quarter prevQ5 = calendarQuarter.AddQuarters( -5 ); Assert.AreEqual( prevQ5.YearQuarter, YearQuarter.Fourth ); Assert.AreEqual( prevQ5.BaseYear, currentYear - 2 ); Assert.AreEqual( prevQ5.Start, calendarStartDate.AddMonths( -15 ) ); Assert.AreEqual( prevQ5.End, calendarStartDate.AddMonths( -12 ) ); Quarter futureQ1 = calendarQuarter.AddQuarters( 1 ); Assert.AreEqual( futureQ1.YearQuarter, YearQuarter.Second ); Assert.AreEqual( futureQ1.BaseYear, currentYear ); Assert.AreEqual( futureQ1.Start, calendarStartDate.AddMonths( 3 ) ); Assert.AreEqual( futureQ1.End, calendarStartDate.AddMonths( 6 ) ); Quarter futureQ2 = calendarQuarter.AddQuarters( 2 ); Assert.AreEqual( futureQ2.YearQuarter, YearQuarter.Third ); Assert.AreEqual( futureQ2.BaseYear, currentYear ); Assert.AreEqual( futureQ2.Start, calendarStartDate.AddMonths( 6 ) ); Assert.AreEqual( futureQ2.End, calendarStartDate.AddMonths( 9 ) ); Quarter futureQ3 = calendarQuarter.AddQuarters( 3 ); Assert.AreEqual( futureQ3.YearQuarter, YearQuarter.Fourth ); Assert.AreEqual( futureQ3.BaseYear, currentYear ); Assert.AreEqual( futureQ3.Start, calendarStartDate.AddMonths( 9 ) ); Assert.AreEqual( futureQ3.End, calendarStartDate.AddMonths( 12 ) ); Quarter futureQ4 = calendarQuarter.AddQuarters( 4 ); Assert.AreEqual( futureQ4.YearQuarter, YearQuarter.First ); Assert.AreEqual( futureQ4.BaseYear, currentYear + 1 ); Assert.AreEqual( futureQ4.Start, calendarStartDate.AddMonths( 12 ) ); Assert.AreEqual( futureQ4.End, calendarStartDate.AddMonths( 15 ) ); Quarter futureQ5 = calendarQuarter.AddQuarters( 5 ); Assert.AreEqual( futureQ5.YearQuarter, YearQuarter.Second ); Assert.AreEqual( futureQ5.BaseYear, currentYear + 1 ); Assert.AreEqual( futureQ5.Start, calendarStartDate.AddMonths( 15 ) ); Assert.AreEqual( futureQ5.End, calendarStartDate.AddMonths( 18 ) ); }
public void QuarterMomentTest() { Quarter quarter = new Quarter( 2008, YearQuarter.First, TimeCalendar.New( TimeSpan.Zero, TimeSpan.Zero ) ); Assert.IsTrue( quarter.IsReadOnly ); Assert.AreEqual( quarter.BaseYear, 2008 ); Assert.AreEqual( quarter.YearQuarter, YearQuarter.First ); Assert.AreEqual( quarter.Start, new DateTime( 2008, TimeSpec.FirstQuarterMonthIndex, 1 ) ); Assert.AreEqual( quarter.End, new DateTime( 2008, TimeSpec.SecondQuarterMonthIndex, 1 ) ); Quarter previous = quarter.GetPreviousQuarter(); Assert.AreEqual( previous.BaseYear, 2007 ); Assert.AreEqual( previous.YearQuarter, YearQuarter.Fourth ); Assert.AreEqual( previous.Start, new DateTime( 2007, TimeSpec.FourthQuarterMonthIndex, 1 ) ); Assert.AreEqual( previous.End, new DateTime( 2008, TimeSpec.FirstQuarterMonthIndex, 1 ) ); Quarter next = quarter.GetNextQuarter(); Assert.AreEqual( next.BaseYear, 2008 ); Assert.AreEqual( next.YearQuarter, YearQuarter.Second ); Assert.AreEqual( next.Start, new DateTime( 2008, TimeSpec.SecondQuarterMonthIndex, 1 ) ); Assert.AreEqual( next.End, new DateTime( 2008, TimeSpec.ThirdQuarterMonthIndex, 1 ) ); }
public void DefaultCalendarTest() { DateTime yearStart = new DateTime( ClockProxy.Clock.Now.Year, 1, 1 ); foreach ( YearQuarter yearQuarter in Enum.GetValues( typeof( YearQuarter ) ) ) { int offset = (int)yearQuarter - 1; Quarter quarter = new Quarter( yearStart.AddMonths( TimeSpec.MonthsPerQuarter * offset ) ); Assert.AreEqual( quarter.YearBaseMonth, YearMonth.January ); Assert.AreEqual( quarter.BaseYear, yearStart.Year ); Assert.AreEqual( quarter.Start, yearStart.AddMonths( TimeSpec.MonthsPerQuarter * offset ).Add( quarter.Calendar.StartOffset ) ); Assert.AreEqual( quarter.End, yearStart.AddMonths( TimeSpec.MonthsPerQuarter * ( offset + 1 ) ).Add( quarter.Calendar.EndOffset ) ); } }
public CategoryGenerator(Community community, Company company, Quarter quarter) { _community = community; _company = company; _quarter = quarter; }
private IQueryable<Quarter> GetOrCreateQuareters() { for (int i = 0; i < 4; ++i) { if (!JournalContext.Quarters.Any(q => q.QuarterID == i)) { var stubQuarter = new Quarter {StartDate = DateTime.Now, EndDate = DateTime.Now, QuarterID = i}; JournalContext.Quarters.InsertOnSubmit(stubQuarter); } } JournalContext.SubmitChanges(); return JournalContext.Quarters; }
public void DefaultQuarterTest() { int currentYear = ClockProxy.Clock.Now.Year; const YearMonth yearStartMonth = YearMonth.April; TimeCalendar calendar = TimeCalendar.New( TimeSpan.Zero, TimeSpan.Zero, yearStartMonth ); Quarter q1 = new Quarter( currentYear, YearQuarter.First, calendar ); Assert.IsTrue( q1.IsReadOnly ); Assert.AreEqual( q1.YearBaseMonth, yearStartMonth ); Assert.AreEqual( q1.YearQuarter, YearQuarter.First ); Assert.AreEqual( q1.BaseYear, currentYear ); Assert.AreEqual( q1.Start, new DateTime( currentYear, 4, 1 ) ); Assert.AreEqual( q1.End, new DateTime( currentYear, 7, 1 ) ); Quarter q2 = new Quarter( currentYear, YearQuarter.Second, calendar ); Assert.IsTrue( q2.IsReadOnly ); Assert.AreEqual( q2.YearBaseMonth, yearStartMonth ); Assert.AreEqual( q2.YearQuarter, YearQuarter.Second ); Assert.AreEqual( q2.BaseYear, currentYear ); Assert.AreEqual( q2.Start, new DateTime( currentYear, 7, 1 ) ); Assert.AreEqual( q2.End, new DateTime( currentYear, 10, 1 ) ); Quarter q3 = new Quarter( currentYear, YearQuarter.Third, calendar ); Assert.IsTrue( q3.IsReadOnly ); Assert.AreEqual( q3.YearBaseMonth, yearStartMonth ); Assert.AreEqual( q3.YearQuarter, YearQuarter.Third ); Assert.AreEqual( q3.BaseYear, currentYear ); Assert.AreEqual( q3.Start, new DateTime( currentYear, 10, 1 ) ); Assert.AreEqual( q3.End, new DateTime( currentYear + 1, 1, 1 ) ); Quarter q4 = new Quarter( currentYear, YearQuarter.Fourth, calendar ); Assert.IsTrue( q4.IsReadOnly ); Assert.AreEqual( q4.YearBaseMonth, yearStartMonth ); Assert.AreEqual( q4.YearQuarter, YearQuarter.Fourth ); Assert.AreEqual( q4.BaseYear, currentYear ); Assert.AreEqual( q4.Start, new DateTime( currentYear + 1, 1, 1 ) ); Assert.AreEqual( q4.End, new DateTime( currentYear + 1, 4, 1 ) ); }
public void GetMonthsTest() { Quarter quarter = new Quarter( ClockProxy.Clock.Now.Year, YearQuarter.First, TimeCalendar.New( YearMonth.October ) ); ITimePeriodCollection months = quarter.GetMonths(); Assert.AreNotEqual( months, null ); int index = 0; foreach ( Month month in months ) { Assert.AreEqual( month.Start, quarter.Start.AddMonths( index ) ); Assert.AreEqual( month.End, month.Calendar.MapEnd( month.Start.AddMonths( 1 ) ) ); index++; } Assert.AreEqual( index, TimeSpec.MonthsPerQuarter ); }
// ---------------------------------------------------------------------- public void GetDaysOfPastQuarter( DateTime moment, out DateTime firstDay, out DateTime lastDay ) { TimeCalendar calendar = new TimeCalendar( new TimeCalendarConfig { YearBaseMonth = YearMonth.October } ); Quarter quarter = new Quarter( moment, calendar ); Quarter pastQuarter = quarter.GetPreviousQuarter(); firstDay = pastQuarter.FirstDayStart; lastDay = pastQuarter.LastDayStart; }