public MonthRange(Month startMonth, int startYear, Month endMonth, int endYear) { StartYear = startYear; StartMonth = (int)startMonth; EndMonth = (int)endMonth; EndYear = endYear; }
public CalendarDay(DayOfWeek dayOfWeek, int year, Month month, int dayOfMonth) { DayOfWeek = dayOfWeek; Year = year; Month = month; DayOfMonth = dayOfMonth; }
public DayOfWeekAnnualReccurance(DayOfWeek dayOfWeek, WeekOfMonth week, Month month, bool substituteWeekend = true) : base(substituteWeekend) { DayOfWeek = dayOfWeek; Week = week; Month = month; }
/// <summary> /// Returns quarter date is in based on specifed /// start of year /// </summary> /// <param name="aDate"></param> /// <param name="startOfQuarter">Start of the year</param> /// <returns></returns> public static Quarter Quarter(this System.DateTime aDate, Month startOfYear) { int offset; offset = (((int)startOfYear -1) * -1) + aDate.Month; if(offset <= 0) offset = 12 - (Math.Abs(offset)); return (Quarter)Math.Ceiling((double)((offset) / 3M)); }
public static int GetMonthlyPrintNumber(Date date, int refNumber, Date refDate, Month noPrintMonths, Dictionary<int, int> noPrintDates, Dictionary<int, int> noPrintNumbers) { int no = refNumber; Date date2 = refDate; while (date > date2) { date2 = date2.AddMonths(1); Month month = zdate.GetMonth(date2.Month); if ((noPrintMonths & month) != month && !noPrintDates.ContainsKey(date2.AbsoluteDay)) { do { no++; } while (noPrintNumbers.ContainsKey(no)); } } while (date < date2) { Month month = zdate.GetMonth(date2.Month); if ((noPrintMonths & month) != month && !noPrintDates.ContainsKey(date2.AbsoluteDay)) { do { no--; } while (noPrintNumbers.ContainsKey(no)); } date2 = date2.AddMonths(-1); } return no; }
private Rain GetRandomRain(Month month, Cloudiness cloudiness) { double fraction = random.NextDouble(); switch(month) { case Month.January: case Month.February: case Month.December: if(fraction < 0.05 && cloudiness != Cloudiness.Low) return Rain.Heavy; else if(fraction < 0.2) return Rain.Drizzle; else return Rain.None; case Month.July: case Month.August: if(fraction < 0.05 && cloudiness != Cloudiness.Low) return Rain.Thunderstorm; else if(fraction < 0.1) return Rain.Heavy; else if(fraction < 0.3) return Rain.Drizzle; else return Rain.None; default: if(fraction < 0.01 && cloudiness != Cloudiness.Low) return Rain.Thunderstorm; else if(fraction < 0.03) return Rain.Heavy; else if(fraction < 0.1) return Rain.Drizzle; else return Rain.None; } }
public void op_ToMonth_string() { var expected = new Month(2010, 11); var actual = "2010-11".ToMonth(); Assert.Equal(expected, actual); }
/// <summary> /// Creates a new LocalDate with the given year, month and day. /// </summary> /// <param name="year"></param> /// <param name="month"></param> /// <param name="day"></param> public LocalDate(int year, Month month, int day) { int monthNumber = month.Number(); if (monthNumber < 1 || monthNumber > 12) { throw new ArgumentOutOfRangeException("month", "invalid month with number " + ((int)month)); } if (day < 1) { throw new ArgumentOutOfRangeException("day", "day must be at least 1"); } int monthLength = month.Length(DateTime.IsLeapYear(year)); if (day > monthLength) { throw new ArgumentOutOfRangeException("day", month.Name() + " " + year + " has only " + monthLength + " days"); } m_year = year; m_month = month; m_day = day; }
public void GetLateness(int nEmployeeID, Month aMonth, int aYear) { this.nEmployeeID = nEmployeeID; Ultis.DatesRange(out startDate, out endDate, aMonth, aYear); GetLatenessData(); GenerateLatenessTable(); CalculateLateness(); }
public Gregorian(ITimeContext context, int year, Month month, int day, int hour = 0, int minute = 0, int second = 0, int milliseconds = 0, TimeZone timezone = null) { if (timezone == null) timezone = context.Gmt (); this.timezone = timezone; //TODO: Validate input this.time = new DateTime (year, (int)month, day, hour, minute, second, milliseconds, System.DateTimeKind.Utc).ToTime (context); }
public void CalculatePTServiceCommission(int aEmployeeID, string aBranchCode, Month aMonth, int aYear) { nEmployeeID = aEmployeeID; strBranchCode = aBranchCode; month = aMonth; year = aYear; ProcessCalculation(); }
/// <summary> /// Initializes a new instance of the <see cref="YearlyPattern"/> class. /// </summary> /// <param name="startDate">The date and time when the recurrence starts.</param> /// <param name="month">The month of the year each occurrence happens.</param> /// <param name="dayOfMonth">The day of the month each occurrence happens.</param> public YearlyPattern( DateTime startDate, Month month, int dayOfMonth) : base(startDate) { this.Month = month; this.DayOfMonth = dayOfMonth; }
public void AdvanceMonth() { this.month++; if (this.month == Month.December + 1) { this.month = Month.January; this.year++; } }
/// <summary> /// Initializes a new instance of the <see cref="T:OregonTrailDotNet.Window.MainMenu.NewGameInfo" /> class. /// </summary> public NewGameInfo() { PlayerNameIndex = 0; _playerNames = new List<string>(); _playerProfession = Entity.Person.Profession.Banker; _startingInventory = new List<SimItem>(); _startingMonies = 0; _startingMonth = Month.March; Modified = false; }
/// <summary> /// Initializes a new instance of the <see cref="TimeChangeRecurrence"/> class. /// </summary> /// <param name="dayOfTheWeekIndex">The index of the day in the month at which the time change occurs.</param> /// <param name="dayOfTheWeek">The day of the week the time change occurs.</param> /// <param name="month">The month the time change occurs.</param> public TimeChangeRecurrence( DayOfTheWeekIndex dayOfTheWeekIndex, DayOfTheWeek dayOfTheWeek, Month month) : this() { this.dayOfTheWeekIndex = dayOfTheWeekIndex; this.dayOfTheWeek = dayOfTheWeek; this.month = month; }
public static Quarter GetQuarter(Month month) { if (month <= Month.March) // 1st Quarter = January 1 to March 31 return Quarter.First; else if ((month >= Month.April) && (month <= Month.June)) // 2nd Quarter = April 1 to June 30 return Quarter.Second; else if ((month >= Month.July) && (month <= Month.September)) // 3rd Quarter = July 1 to September 30 return Quarter.Third; else // 4th Quarter = October 1 to December 31 return Quarter.Fourth; }
private Month CalculateMonth() { var month = new Month(); month.MonthIndex = internalDateStore.Month; month.Year = internalDateStore.Year; month.Days = GetDaysInMonth(); month.Name = string.Concat(GetMonthName(), " ", internalDateStore.Year.ToString()); return month; }
public static int GetNextDay(this int day, Month month, int year) { int daysInMonth = DateTime.DaysInMonth(year, (int)month); if (day == daysInMonth) { return 1; } else { return day + 1; } }
private DateTime GetFirstDayInGivenMonth(Month month) { int year = _currentDate.Year; if (_currentDate.Month < (int) month) { //this year } else { //Next year year++; } return new DateTime(year, (int) month, 1); }
public SlopeDayData(int aDay, Month aMonth, double aPercentOpen) { month = aMonth.ToString(); day = aDay; percentOpen = aPercentOpen; int temp; temp = ((int)aMonth * 100) + day; dayMonth = ""; if (temp < 1000) { dayMonth += "0"; } dayMonth += temp.ToString(); }
private void PopulatePostCountsPerMonth(PostsByYear postsByYear, Month targetMonth, Guid[] postsToExclude) { var monthlyPostCounts = from posts in _postsEntityContext.Entities where posts.YearOfPublication == postsByYear.Year group posts by posts.MonthOfPublication into stats select new {Month = (Month) stats.Key, Count = stats.Count()}; foreach(var monthlyPostCount in monthlyPostCounts ) { postsByYear.SetMonthCount(monthlyPostCount.Month,monthlyPostCount.Count); } postsByYear.IncrementPostCountForMonth(targetMonth); }
/// <summary> /// Initializes a new instance of the <see cref="ClimateData" /> class. /// Creates a new bit of climate data. /// </summary> /// <param name="month">Month this data is representative of.</param> /// <param name="averageTemp">Average set of temperatures for this month.</param> /// <param name="tempMax">Maximum temperature this month can have.</param> /// <param name="tempMin">Minimum temperature this month can have.</param> /// <param name="rainfall">Average rainfall for this month.</param> /// <param name="avgHumidity">Daily humidity for this month.</param> public ClimateData( Month month, float averageTemp, float tempMax, float tempMin, float rainfall, int avgHumidity) { Month = month; Temperature = averageTemp; TemperatureMax = tempMax; TemperatureMin = tempMin; Rainfall = rainfall; Humidity = avgHumidity; }
public void ctor_SerializationInfo_StreamingContext() { var expected = new Month(1999, 12); Month actual; using (Stream stream = new MemoryStream()) { var formatter = new BinaryFormatter(); formatter.Serialize(stream, new Month(1999, 12)); stream.Position = 0; actual = (Month)formatter.Deserialize(stream); } Assert.Equal(expected, actual); }
public void ScheduleEveryYearOn(Month month, int day, TimeSpan timeOfDay) { if (!Enum.IsDefined(typeof(Month), month)) throw new ArgumentOutOfRangeException("Invalid value for 'month'"); DateTime today = DateTime.Now; DateTime max = DateTimeHelper.GetMax(today, StartDateTime); int expectedYear = max.Year; DateTime expectedDueDate = new DateTime(expectedYear, (int)month, day).Add(timeOfDay); if (expectedDueDate < max) expectedDueDate = expectedDueDate.AddYears(1); DueDateTime = expectedDueDate; }
/// <summary> /// Parse a date and time for format-date() /// </summary> /// <param name="d"></param> /// <returns></returns> public static ExsltDateTime ParseDateTime(string d) { // First try any of the classes in ParseDate try { return ParseDate(d); } catch (FormatException) { } try { TimeTZ t = new TimeTZ(d); return t; } catch (FormatException) { } try { MonthDay t = new MonthDay(d); return t; } catch (FormatException) { } try { Month t = new Month(d); return t; } catch (FormatException) { } // Finally day -- don't catch the exception { Day t = new Day(d); return t; } }
int MonthOfYear(Month month) { switch (month) { case Month.january: return 1; case Month.february: return 2; case Month.march: return 3; case Month.april: return 4; case Month.may: return 5; case Month.june: return 6; case Month.july: return 7; case Month.august: return 8; case Month.september: return 9; case Month.october: return 10; case Month.november: return 11; case Month.december: return 12; default: return -1; } }
public YearsBuilder OnMonth(DateTime dateTime) { switch(dateTime.Month) { case 1: _month = Month.JANUARY; break; case 2: _month = Month.FEBRUARY; break; case 3: _month = Month.MARCH; break; case 4: _month = Month.APRIL; break; case 5: _month = Month.MAY; break; case 6: _month = Month.JUNE; break; case 7: _month = Month.JULY; break; case 8: _month = Month.AUGUST; break; case 9: _month = Month.SEPTEMBER; break; case 10: _month = Month.OCTOBER; break; case 11: _month = Month.NOVEMBER; break; case 12: _month = Month.DECEMBER; break; } return this; }
public async void ReadMyXML(string year) { Months = new Months(); Progress<int> progress = new Progress<int>((p) => { ProgressPercent = p; }); BasicFileDownloader bidl = new BasicFileDownloader(ToAbsoluteUri("xmlmonths.aspx?ay=" + year)); IRandomAccessStream s = await bidl.DownloadAsync(progress); XmlReaderSettings settings = new XmlReaderSettings(); settings.ConformanceLevel = ConformanceLevel.Fragment; settings.IgnoreWhitespace = true; settings.IgnoreComments = true; settings.Async = true; XmlReader reader = XmlReader.Create(s.AsStream(), settings); reader.ReadStartElement("Model"); reader.ReadStartElement("Months"); Count = 0; while (reader.IsStartElement()) { string month = reader[0]; string str = reader[1]; str = str.Replace("_s.jpg", ""); if (!String.IsNullOrEmpty(str)) { uint count = 0; if (uint.TryParse(reader[2], out count)) { Month m = new Month(month, str, count); Months.Add(m); Count += m.Count; } } await reader.ReadAsync(); } }
public AvailabilityModel() { Months = new List<Month>(); var months = new[] {"Apr", "May", "Jun", "Jul", "Aug", "Sep"}; var firstofMonth = new DateTime(DateTime.Now.Year, 4, 1); var firstSaturday = firstofMonth.AddDays(-(firstofMonth.DayOfWeek - DayOfWeek.Saturday)); var sunday = firstSaturday.AddDays(1); var sundayFirstOfMonth = false; while (sunday < new DateTime(DateTime.Now.Year, 10, 1)) { var month = MonthExists(months[firstSaturday.Month - 4]); if(month==null) { month = new Month {Name = months[firstSaturday.Month - 4]}; Months.Add(month); } if (sundayFirstOfMonth && month.Days.Count == 0) { month.Days.Add(new Day {Date = "01",Weekend = "Sun"}); sundayFirstOfMonth = false; } month.Days.Add(new Day{Date=firstSaturday.Day.ToString(CultureInfo.InvariantCulture).PadLeft(2,'0'),Weekend = "Sat"}); if (!sundayFirstOfMonth) month.Days.Add(new Day { Date = sunday.Day.ToString(CultureInfo.InvariantCulture).PadLeft(2, '0'), Weekend = "Sun"}); firstSaturday = firstSaturday.AddDays(7); sunday = firstSaturday.AddDays(1); if (sunday.Day == 1) sundayFirstOfMonth = true; } }
/// <summary> /// Renders the <see cref="Month"/> <paramref name="value"/>. /// </summary> /// <param name="value"></param> /// <returns></returns> public static string RenderParameterValue(this Month value) => Enum.GetValues(typeof(Month)).OfType <Month>().Contains(value) ? $"{value}" : throw new InvalidOperationException($"'{typeof(Month).FullName}' value '{value}' is unsupported.");
public static IRule Day(this Month month, int day) { return(new DayInMonthRule(day, month)); }
public void FromDateTime_MonthTypeParameter_EqualsExpected(DateTime dateTime, Month expectedMonth) { var month = TimePeriodFactory.FromDateTime <Month>(dateTime); Assert.AreEqual(expectedMonth, month); }
public IDictionary <DayType, ICollection <DatesRange> > GetRanges(Month month) { var groups = month.Days.Where(d => d.Number > 0).OrderBy(d => d.Number).GroupBy(d => d.Type).ToDictionary(d => d.Key, d => d.Select(g => g.Number).ToList()); var result = new Dictionary <DayType, ICollection <DatesRange> >(); foreach (var group in groups) { var dayType = group.Key; if (!result.ContainsKey(dayType)) { result.Add(dayType, new List <DatesRange>()); } var groupDays = group.Value; var ranges = new List <List <int> >(); var currentRange = new List <int>(); ranges.Add(currentRange); void createNewCurrentRange() { currentRange = new List <int>(); ranges.Add(currentRange); } for (var i = 0; i < groupDays.Count(); i++) { var day = groupDays[i]; var nextDayIndex = i + 1; if (i > 0) { var previousDay = groupDays[i - 1]; if (day - previousDay > 1) { createNewCurrentRange(); } } if (nextDayIndex >= groupDays.Count()) { currentRange.Add(day); //createNewCurrentRange(); continue; } var nextDay = groupDays[nextDayIndex]; if (nextDay - day == 1) { currentRange.AddRange(new[] { day, nextDay }); i++; } else { currentRange.Add(day); createNewCurrentRange(); } } foreach (var range in ranges) { if (!range.Any()) { continue; } var minDateNumber = range.Min(); var maxDateNumber = range.Max(); var minDate = new DateTime(month.Year, month.Number, minDateNumber); var maxDate = new DateTime(month.Year, month.Number, maxDateNumber); var datesRange = new DatesRange(minDate, maxDate); result[dayType].Add(datesRange); } } return(result); }
public override bool isBusinessDay(Date date) { DayOfWeek w = date.DayOfWeek; int d = date.Day, dd = date.DayOfYear; Month m = (Month)date.Month; int y = date.Year; if (isWeekend(w) // New Year's Day || (d == 1 && m == Month.January) // 23 nisan / National Holiday || (d == 23 && m == Month.April) // 19 may/ National Holiday || (d == 19 && m == Month.May) // 15 july / National Holiday (since 2017) || (d == 15 && m == Month.July && y >= 2017) // 30 aug/ National Holiday || (d == 30 && m == Month.August) // 29 ekim National Holiday || (d == 29 && m == Month.October)) { return(false); } // Local Holidays if (y == 2004) { // Kurban if ((m == Month.February && d <= 4) // Ramadan || (m == Month.November && d >= 14 && d <= 16)) { return(false); } } else if (y == 2005) { // Kurban if ((m == Month.January && d >= 19 && d <= 21) // Ramadan || (m == Month.November && d >= 2 && d <= 5)) { return(false); } } else if (y == 2006) { // Kurban if ((m == Month.January && d >= 10 && d <= 13) // Ramadan || (m == Month.October && d >= 23 && d <= 25) // Kurban || (m == Month.December && d == 31)) { return(false); } } else if (y == 2007) { // Kurban if ((m == Month.January && d <= 3) // Ramadan || (m == Month.October && d >= 12 && d <= 14) // Kurban || (m == Month.December && d >= 20 && d <= 23)) { return(false); } } else if (y == 2008) { // Ramadan if ((m == Month.September && d == 30) || (m == Month.October && d <= 2) // Kurban || (m == Month.December && d >= 8 && d <= 11)) { return(false); } } else if (y == 2009) { // Ramadan if ((m == Month.September && d >= 20 && d <= 22) // Kurban || (m == Month.November && d >= 27 && d <= 30)) { return(false); } } else if (y == 2010) { // Ramadan if ((m == Month.September && d >= 9 && d <= 11) // Kurban || (m == Month.November && d >= 16 && d <= 19)) { return(false); } } else if (y == 2011) { // not clear from borsainstanbul.com if ((m == Month.October && d == 1) || (m == Month.November && d >= 9 && d <= 13)) { return(false); } } else if (y == 2012) { // Ramadan if ((m == Month.August && d >= 18 && d <= 21) // Kurban || (m == Month.October && d >= 24 && d <= 28)) { return(false); } } else if (y == 2013) { // Ramadan if ((m == Month.August && d >= 7 && d <= 10) // Kurban || (m == Month.October && d >= 14 && d <= 18) // additional holiday for Republic Day || (m == Month.October && d == 28)) { return(false); } } else if (y == 2014) { // Ramadan if ((m == Month.July && d >= 27 && d <= 30) // Kurban || (m == Month.October && d >= 4 && d <= 7) // additional holiday for Republic Day || (m == Month.October && d == 29)) { return(false); } } return(true); }
public void YearIsCorrect([Frozen] int expected, Month sut) { Assert.Equal <int>(expected, sut.Year); }
/// <summary> /// ToString() /// </summary> public override string ToString() { return(Invariant($"{Year}/{Month.ToString("00", CultureInfo.InvariantCulture)}/{Day.ToString("00", CultureInfo.InvariantCulture)}")); }
public Double this[Month month] { get { return(this.productionRateForcast[month - Month.January]); } set { this.productionRateForcast[month - Month.January] = value; } }
/// <summary>Gets the next IMM date. /// </summary> /// <param name="date">The basis for the IMM date calculation.</param> /// <param name="month">The month of the IMM date in its <see cref="IMM.Month"/> representation.</param> /// <param name="yearOffset">The number of years to add to <paramref name="date"/> to take into account for IMM date calculation.</param> /// <returns>The next IMM date in month <paramref name="month"/> with respect to <paramref name="date"/> + <paramref name="yearOffset"/>.</returns> public static DateTime Next(DateTime date, Month month, int yearOffset) { return(GetNextDate(new DateTime(date.Year + yearOffset, (int)month, 1))); }
/// <summary>Creates a new <see cref="ITimeframeDescription"/> object, where the start date of the period is a IMM date.</summary> /// <param name="month">The month of the period start date in its <see cref="IMM.Month"/> representation.</param> /// <param name="periodStartYearOffset">The number of years to add to the reference date in <c>GetStartAndEndDate(.)</c> to take into account for the calculation of the specific IMM date.</param> /// <param name="tenor">The tenor that represents the time span.</param> /// <param name="startDateAdjustment">A business day convention used to compute the start date of the period, i.e. the IMM date.</param> /// <param name="endDateAdjustment">A business day convention used to compute the end date of the period.</param> /// <returns>The specified <see cref="ITimeframeDescription"/> object.</returns> public static ITimeframeDescription Create(Month month, int periodStartYearOffset, TenorTimeSpan tenor, IBusinessDayConvention startDateAdjustment, IBusinessDayConvention endDateAdjustment) { return(new SpecificPeriod(month, periodStartYearOffset, tenor, startDateAdjustment, endDateAdjustment)); }
internal MonthRenderer(Month input) : base(input) { }
public DayInMonthRule(int dayInMonth, Month month) { DayInMonth = dayInMonth; Month = month; }
public static DateTime FirstDay(this Month month, int year) => new DateTime(year, (int)month, 1);
public List <Payment> GetPaymentsOfSelectedMonthByCustomerId(Customer customer, Month month) { return(customer.Payments.Where(x => x.MonthId == month).ToList()); }
public BuiltInFunctions() { // Text Functions["len"] = new Len(); Functions["lower"] = new Lower(); Functions["upper"] = new Upper(); Functions["left"] = new Left(); Functions["right"] = new Right(); Functions["mid"] = new Mid(); Functions["replace"] = new Replace(); Functions["rept"] = new Rept(); Functions["substitute"] = new Substitute(); Functions["concatenate"] = new Concatenate(); Functions["concat"] = new Concat(); Functions["textjoin"] = new Textjoin(); Functions["char"] = new CharFunction(); Functions["exact"] = new Exact(); Functions["find"] = new Find(); Functions["fixed"] = new Fixed(); Functions["proper"] = new Proper(); Functions["search"] = new Search(); Functions["text"] = new Text.Text(); Functions["t"] = new T(); Functions["hyperlink"] = new Hyperlink(); Functions["value"] = new Value(CultureInfo.CurrentCulture); Functions["trim"] = new Trim(); Functions["clean"] = new Clean(); Functions["unicode"] = new Unicode(); Functions["unichar"] = new Unichar(); Functions["numbervalue"] = new NumberValue(); // Numbers Functions["int"] = new CInt(); // Math Functions["abs"] = new Abs(); Functions["asin"] = new Asin(); Functions["asinh"] = new Asinh(); Functions["acot"] = new Acot(); Functions["acoth"] = new Acoth(); Functions["cos"] = new Cos(); Functions["cot"] = new Cot(); Functions["coth"] = new Coth(); Functions["cosh"] = new Cosh(); Functions["csc"] = new Csc(); Functions["csch"] = new Csch(); Functions["power"] = new Power(); Functions["gcd"] = new Gcd(); Functions["lcm"] = new Lcm(); Functions["sec"] = new Sec(); Functions["sech"] = new SecH(); Functions["sign"] = new Sign(); Functions["sqrt"] = new Sqrt(); Functions["sqrtpi"] = new SqrtPi(); Functions["pi"] = new Pi(); Functions["product"] = new Product(); Functions["ceiling"] = new Ceiling(); Functions["ceiling.precise"] = new CeilingPrecise(); Functions["ceiling.math"] = new CeilingMath(); Functions["iso.ceiling"] = new IsoCeiling(); Functions["combin"] = new Combin(); Functions["combina"] = new Combina(); Functions["count"] = new Count(); Functions["counta"] = new CountA(); Functions["countblank"] = new CountBlank(); Functions["countif"] = new CountIf(); Functions["countifs"] = new CountIfs(); Functions["fact"] = new Fact(); Functions["factdouble"] = new FactDouble(); Functions["floor"] = new Floor(); Functions["floor.precise"] = new FloorPrecise(); Functions["floor.math"] = new FloorMath(); Functions["radians"] = new Radians(); Functions["roman"] = new Roman(); Functions["sin"] = new Sin(); Functions["sinh"] = new Sinh(); Functions["sum"] = new Sum(); Functions["sumif"] = new SumIf(); Functions["sumifs"] = new SumIfs(); Functions["sumproduct"] = new SumProduct(); Functions["sumsq"] = new Sumsq(); Functions["sumxmy2"] = new Sumxmy2(); Functions["sumx2my2"] = new SumX2mY2(); Functions["sumx2py2"] = new SumX2pY2(); Functions["seriessum"] = new Seriessum(); Functions["stdev"] = new Stdev(); Functions["stdevp"] = new StdevP(); Functions["stdev.s"] = new StdevDotS(); Functions["stdev.p"] = new StdevDotP(); Functions["subtotal"] = new Subtotal(); Functions["exp"] = new Exp(); Functions["log"] = new Log(); Functions["log10"] = new Log10(); Functions["ln"] = new Ln(); Functions["max"] = new Max(); Functions["maxa"] = new Maxa(); Functions["median"] = new Median(); Functions["min"] = new Min(); Functions["mina"] = new Mina(); Functions["mod"] = new Mod(); Functions["mode"] = new Mode(); Functions["mode.sngl"] = new ModeSngl(); Functions["mround"] = new Mround(); Functions["average"] = new Average(); Functions["averagea"] = new AverageA(); Functions["averageif"] = new AverageIf(); Functions["averageifs"] = new AverageIfs(); Functions["round"] = new Round(); Functions["rounddown"] = new Rounddown(); Functions["roundup"] = new Roundup(); Functions["rand"] = new Rand(); Functions["randbetween"] = new RandBetween(); Functions["rank"] = new Rank(); Functions["rank.eq"] = new RankEq(); Functions["rank.avg"] = new RankAvg(); Functions["percentile"] = new Percentile(); Functions["percentile.inc"] = new PercentileInc(); Functions["percentrank"] = new Percentrank(); Functions["percentrank.inc"] = new PercentrankInc(); Functions["quotient"] = new Quotient(); Functions["trunc"] = new Trunc(); Functions["tan"] = new Tan(); Functions["tanh"] = new Tanh(); Functions["atan"] = new Atan(); Functions["atan2"] = new Atan2(); Functions["atanh"] = new Atanh(); Functions["acos"] = new Acos(); Functions["acosh"] = new Acosh(); Functions["var"] = new Var(); Functions["var.s"] = new VarDotS(); Functions["varp"] = new VarP(); Functions["var.p"] = new VarDotP(); Functions["large"] = new Large(); Functions["small"] = new Small(); Functions["degrees"] = new Degrees(); Functions["odd"] = new Odd(); Functions["even"] = new Even(); // Information Functions["isblank"] = new IsBlank(); Functions["isnumber"] = new IsNumber(); Functions["istext"] = new IsText(); Functions["isnontext"] = new IsNonText(); Functions["iserror"] = new IsError(); Functions["iserr"] = new IsErr(); Functions["error.type"] = new ErrorType(); Functions["iseven"] = new IsEven(); Functions["isodd"] = new IsOdd(); Functions["islogical"] = new IsLogical(); Functions["isna"] = new IsNa(); Functions["na"] = new Na(); Functions["n"] = new N(); Functions["type"] = new TypeFunction(); // Logical Functions["if"] = new If(); Functions["ifs"] = new Ifs(); Functions["maxifs"] = new MaxIfs(); Functions["minifs"] = new MinIfs(); Functions["iferror"] = new IfError(); Functions["ifna"] = new IfNa(); Functions["not"] = new Not(); Functions["and"] = new And(); Functions["or"] = new Or(); Functions["true"] = new True(); Functions["false"] = new False(); Functions["switch"] = new Switch(); // Reference and lookup Functions["address"] = new Address(); Functions["hlookup"] = new HLookup(); Functions["vlookup"] = new VLookup(); Functions["lookup"] = new Lookup(); Functions["match"] = new Match(); Functions["row"] = new Row(); Functions["rows"] = new Rows(); Functions["column"] = new Column(); Functions["columns"] = new Columns(); Functions["choose"] = new Choose(); Functions["index"] = new RefAndLookup.Index(); Functions["indirect"] = new Indirect(); Functions["offset"] = new Offset(); // Date Functions["date"] = new Date(); Functions["today"] = new Today(); Functions["now"] = new Now(); Functions["day"] = new Day(); Functions["month"] = new Month(); Functions["year"] = new Year(); Functions["time"] = new Time(); Functions["hour"] = new Hour(); Functions["minute"] = new Minute(); Functions["second"] = new Second(); Functions["weeknum"] = new Weeknum(); Functions["weekday"] = new Weekday(); Functions["days"] = new Days(); Functions["days360"] = new Days360(); Functions["yearfrac"] = new Yearfrac(); Functions["edate"] = new Edate(); Functions["eomonth"] = new Eomonth(); Functions["isoweeknum"] = new IsoWeekNum(); Functions["workday"] = new Workday(); Functions["workday.intl"] = new WorkdayIntl(); Functions["networkdays"] = new Networkdays(); Functions["networkdays.intl"] = new NetworkdaysIntl(); Functions["datevalue"] = new DateValue(); Functions["timevalue"] = new TimeValue(); // Database Functions["dget"] = new Dget(); Functions["dcount"] = new Dcount(); Functions["dcounta"] = new DcountA(); Functions["dmax"] = new Dmax(); Functions["dmin"] = new Dmin(); Functions["dsum"] = new Dsum(); Functions["daverage"] = new Daverage(); Functions["dvar"] = new Dvar(); Functions["dvarp"] = new Dvarp(); //Finance Functions["cumipmt"] = new Cumipmt(); Functions["cumprinc"] = new Cumprinc(); Functions["ddb"] = new Ddb(); Functions["effect"] = new Effect(); Functions["fvschedule"] = new FvSchedule(); Functions["pduration"] = new Pduration(); Functions["rri"] = new Rri(); Functions["pmt"] = new Pmt(); Functions["ppmt"] = new Ppmt(); Functions["ipmt"] = new Ipmt(); Functions["ispmt"] = new IsPmt(); Functions["pv"] = new Pv(); Functions["fv"] = new Fv(); Functions["npv"] = new Npv(); Functions["rate"] = new Rate(); Functions["nper"] = new Nper(); Functions["nominal"] = new Nominal(); Functions["irr"] = new Irr(); Functions["mirr"] = new Mirr(); Functions["xirr"] = new Xirr(); Functions["sln"] = new Sln(); Functions["syd"] = new Syd(); Functions["xnpv"] = new Xnpv(); Functions["coupdays"] = new Coupdays(); Functions["coupdaysnc"] = new Coupdaysnc(); Functions["coupdaybs"] = new Coupdaybs(); Functions["coupnum"] = new Coupnum(); Functions["coupncd"] = new Coupncd(); Functions["couppcd"] = new Couppcd(); Functions["price"] = new Price(); Functions["yield"] = new Yield(); Functions["duration"] = new Duration(); Functions["disc"] = new Disc(); //Engineering Functions["bitand"] = new BitAnd(); Functions["bitor"] = new BitOr(); Functions["bitxor"] = new BitXor(); Functions["bitlshift"] = new BitLshift(); Functions["bitrshift"] = new BitRshift(); Functions["convert"] = new ConvertFunction(); Functions["bin2dec"] = new Bin2Dec(); Functions["bin2hex"] = new Bin2Hex(); Functions["bin2oct"] = new Bin2Oct(); Functions["dec2bin"] = new Dec2Bin(); Functions["dec2hex"] = new Dec2Hex(); Functions["dec2oct"] = new Dec2Oct(); Functions["hex2bin"] = new Hex2Bin(); Functions["hex2dec"] = new Hex2Dec(); Functions["hex2oct"] = new Hex2Oct(); Functions["oct2bin"] = new Oct2Bin(); Functions["oct2dec"] = new Oct2Dec(); Functions["oct2hex"] = new Oct2Hex(); Functions["delta"] = new Delta(); Functions["erf"] = new Erf(); Functions["erf.precise"] = new ErfPrecise(); Functions["erfc"] = new Erfc(); Functions["erfc.precise"] = new ErfcPrecise(); Functions["besseli"] = new BesselI(); Functions["besselj"] = new BesselJ(); Functions["besselk"] = new BesselK(); Functions["bessely"] = new BesselY(); }
partial void OnMonthChanging(Month value);
public ValidThru(Month month, short year) { Month = month; Year = year; }
public void MonthIsCorrect([Frozen] int expected, Month sut) { Assert.Equal <int>(expected, sut.MonthNumber); }
public static void RemoveEvent(this Month month, ICalendarViewEvent calendarViewEvent) { var eventDate = calendarViewEvent.StartDateTime.Date; month.Days.FirstOrDefault(day => day.DateTime.Date.Equals(eventDate))?.RemoveEvent(calendarViewEvent); }
public override bool isBusinessDay(Date date) { DayOfWeek w = date.DayOfWeek; int d = date.Day; Month m = (Month)date.Month; int y = date.Year; if (isWeekend(w) // New Year's Day || ((d == 1 || (d == 3 && w == DayOfWeek.Monday)) && m == Month.January) // Chakri Memorial Day || ((d == 6 || ((d == 7 || d == 8) && w == DayOfWeek.Monday)) && m == Month.April) // Songkran Festival || ((d == 13 || d == 14 || d == 15) && m == Month.April) // Songkran Festival obersvence (usually not more then 1 holiday will be replaced) || (d == 16 && (w == DayOfWeek.Monday || w == DayOfWeek.Tuesday) && m == Month.April) // Labor Day || ((d == 1 || ((d == 2 || d == 3) && w == DayOfWeek.Monday)) && m == Month.May) // H.M. the King's Birthday || ((d == 28 || ((d == 29 || d == 30) && w == DayOfWeek.Monday)) && m == Month.July && y >= 2017) // H.M. the Queen's Birthday || ((d == 12 || ((d == 13 || d == 14) && w == DayOfWeek.Monday)) && m == Month.August) // H.M. King Bhumibol Adulyadej Memorial Day || ((d == 3 || ((d == 14 || d == 15) && w == DayOfWeek.Monday)) && m == Month.October && y >= 2017) // H.M. King Bhumibol Adulyadej's Birthday || ((d == 5 || ((d == 6 || d == 7) && w == DayOfWeek.Monday)) && m == Month.December) // Constitution Day || ((d == 10 || ((d == 11 || d == 12) && w == DayOfWeek.Monday)) && m == Month.December) // New Year’s Eve || (d == 31 && m == Month.December) // New Year’s Eve Observence || ((d == 1 || d == 2) && w == DayOfWeek.Monday && m == Month.January) ) { return(false); } if ((y == 2000) && ((d == 21 && m == Month.February) || // Makha Bucha Day (Substitution Day) (d == 5 && m == Month.May) || // Coronation Day (d == 17 && m == Month.May) || // Wisakha Bucha Day (d == 17 && m == Month.July) || // Buddhist Lent Day (d == 23 && m == Month.October) // Chulalongkorn Day )) { return(false); } if ((y == 2001) && ((d == 8 && m == Month.February) || // Makha Bucha Day (d == 7 && m == Month.May) || // Wisakha Bucha Day (d == 8 && m == Month.May) || // Coronation Day (Substitution Day) (d == 6 && m == Month.July) || // Buddhist Lent Day (d == 23 && m == Month.October) // Chulalongkorn Day )) { return(false); } // 2002, 2003 and 2004 are missing if ((y == 2005) && ((d == 23 && m == Month.February) || // Makha Bucha Day (d == 5 && m == Month.May) || // Coronation Day (d == 23 && m == Month.May) || // Wisakha Bucha Day (Substitution Day for Sunday 22 May) (d == 1 && m == Month.July) || // Mid Year Closing Day (d == 22 && m == Month.July) || // Buddhist Lent Day (d == 24 && m == Month.October) // Chulalongkorn Day (Substitution Day for Sunday 23 October) )) { return(false); } if ((y == 2006) && ((d == 13 && m == Month.February) || // Makha Bucha Day (d == 19 && m == Month.April) || // Special Holiday (d == 5 && m == Month.May) || // Coronation Day (d == 12 && m == Month.May) || // Wisakha Bucha Day (d == 12 && m == Month.June) // Special Holidays (Due to the auspicious occasion of the // celebration of 60th Anniversary of His Majesty's Accession // to the throne. For Bangkok, Samut Prakan, Nonthaburi, // Pathumthani and Nakhon Pathom province) || (d == 13 && m == Month.June) || // Special Holidays (as above) (d == 11 && m == Month.July) || // Buddhist Lent Day (d == 23 && m == Month.October) // Chulalongkorn Day )) { return(false); } if ((y == 2007) && ((d == 5 && m == Month.March) || // Makha Bucha Day (Substitution Day for Saturday 3 March) (d == 7 && m == Month.May) || // Coronation Day (Substitution Day for Saturday 5 May) (d == 31 && m == Month.May) || // Wisakha Bucha Day (d == 30 && m == Month.July) || // Asarnha Bucha Day (Substitution Day for Sunday 29 July) (d == 23 && m == Month.October) || // Chulalongkorn Day (d == 24 && m == Month.December) // Special Holiday )) { return(false); } if ((y == 2008) && ((d == 21 && m == Month.February) || // Makha Bucha Day (d == 5 && m == Month.May) || // Coronation Day (d == 19 && m == Month.May) || // Wisakha Bucha Day (d == 1 && m == Month.July) || // Mid Year Closing Day (d == 17 && m == Month.July) || // Asarnha Bucha Day (d == 23 && m == Month.October) // Chulalongkorn Day )) { return(false); } if ((y == 2009) && ((d == 2 && m == Month.January) || // Special Holiday (d == 9 && m == Month.February) || // Makha Bucha Day (d == 5 && m == Month.May) || // Coronation Day (d == 8 && m == Month.May) || // Wisakha Bucha Day (d == 1 && m == Month.July) || // Mid Year Closing Day (d == 6 && m == Month.July) || // Special Holiday (d == 7 && m == Month.July) || // Asarnha Bucha Day (d == 23 && m == Month.October) // Chulalongkorn Day )) { return(false); } if ((y == 2010) && ((d == 1 && m == Month.March) || // Substitution for Makha Bucha Day(Sunday 28 February) (d == 5 && m == Month.May) || // Coronation Day (d == 20 && m == Month.May) || // Special Holiday (d == 21 && m == Month.May) || // Special Holiday (d == 28 && m == Month.May) || // Wisakha Bucha Day (d == 1 && m == Month.July) || // Mid Year Closing Day (d == 26 && m == Month.July) || // Asarnha Bucha Day (d == 13 && m == Month.August) || // Special Holiday (d == 25 && m == Month.October) // Substitution for Chulalongkorn Day(Saturday 23 October) )) { return(false); } if ((y == 2011) && ((d == 18 && m == Month.February) || // Makha Bucha Day (d == 5 && m == Month.May) || // Coronation Day (d == 16 && m == Month.May) || // Special Holiday (d == 17 && m == Month.May) || // Wisakha Bucha Day (d == 1 && m == Month.July) || // Mid Year Closing Day (d == 15 && m == Month.July) || // Asarnha Bucha Day (d == 24 && m == Month.October) // Substitution for Chulalongkorn Day(Sunday 23 October) )) { return(false); } if ((y == 2012) && ((d == 3 && m == Month.January) || // Special Holiday (d == 7 && m == Month.March) || // Makha Bucha Day 2/ (d == 9 && m == Month.April) || // Special Holiday (d == 7 && m == Month.May) || // Substitution for Coronation Day(Saturday 5 May) (d == 4 && m == Month.June) || // Wisakha Bucha Day (d == 2 && m == Month.August) || // Asarnha Bucha Day (d == 23 && m == Month.October) // Chulalongkorn Day )) { return(false); } if ((y == 2013) && ((d == 25 && m == Month.February) || // Makha Bucha Day (d == 6 && m == Month.May) || // Substitution for Coronation Day(Sunday 5 May) (d == 24 && m == Month.May) || // Wisakha Bucha Day (d == 1 && m == Month.July) || // Mid Year Closing Day (d == 22 && m == Month.July) || // Asarnha Bucha Day 2/ (d == 23 && m == Month.October) || // Chulalongkorn Day (d == 30 && m == Month.December) // Special Holiday )) { return(false); } if ((y == 2014) && ((d == 14 && m == Month.February) || // Makha Bucha Day (d == 5 && m == Month.May) || // Coronation Day (d == 13 && m == Month.May) || // Wisakha Bucha Day (d == 1 && m == Month.July) || // Mid Year Closing Day (d == 11 && m == Month.July) || // Asarnha Bucha Day 1/ (d == 11 && m == Month.August) || // Special Holiday (d == 23 && m == Month.October) // Chulalongkorn Day )) { return(false); } if ((y == 2015) && ((d == 2 && m == Month.January) || // Special Holiday (d == 4 && m == Month.March) || // Makha Bucha Day (d == 4 && m == Month.May) || // Special Holiday (d == 5 && m == Month.May) || // Coronation Day (d == 1 && m == Month.June) || // Wisakha Bucha Day (d == 1 && m == Month.July) || // Mid Year Closing Day (d == 30 && m == Month.July) || // Asarnha Bucha Day 1/ (d == 23 && m == Month.October) // Chulalongkorn Day )) { return(false); } if ((y == 2016) && ((d == 22 && m == Month.February) || // Makha Bucha Day (d == 5 && m == Month.May) || // Coronation Day (d == 6 && m == Month.May) || // Special Holiday (d == 20 && m == Month.May) || // Wisakha Bucha Day (d == 1 && m == Month.July) || // Mid Year Closing Day (d == 18 && m == Month.July) || // Special Holiday (d == 19 && m == Month.July) || // Asarnha Bucha Day 1/ (d == 24 && m == Month.October) // Substitution for Chulalongkorn Day (Sunday 23rd October) )) { return(false); } // 2017 is missing if ((y == 2018) && ((d == 1 && m == Month.March) || // Makha Bucha Day (d == 29 && m == Month.May) || // Wisakha Bucha Day (d == 27 && m == Month.July) || // Asarnha Bucha Day1 (d == 23 && m == Month.October) // Chulalongkorn Day )) { return(false); } return(true); }
public static void SelectDay(this Month month, Day selectedDay) { UnSelectCurrentDay(month); SelectNewDay(selectedDay, month); }
/// <summary> /// Metoda, která vyhledá záznamy podle zadaných parametrů, buď podle jedno nebo až tří /// </summary> /// <param name="category">Kategorie výdajů</param> /// <param name="balance">Typ zůstatku bankovní účet nebo hotovost</param> /// <param name="month">Měsíc kdy byla transakce uskutečněna</param> public void FindFinanceRecords(TypeRecord type, Category category, TypeBalance balance, Month month) { admin.FindRecords(type, category, balance, month); ViewGraphicFinance(3, true, false); }
public static Instant NextValid( this Instant instant, Month month = Month.Every, Week week = Week.Every, Day day = Day.Every, WeekDay weekDay = WeekDay.Every, Hour hour = Hour.Zeroth, Minute minute = Minute.Zeroth, Second second = Second.Zeroth, [CanBeNull] CalendarSystem calendarSystem = null, [CanBeNull] DateTimeZone timeZone = null) { // Never case, if any are set to never, we'll never get a valid date. if ((month == Month.Never) || (week == Week.Never) || (day == Day.Never) || (weekDay == WeekDay.Never) || (hour == Hour.Never) || (minute == Minute.Never) || (second == Second.Never)) { return(Instant.MaxValue); } if (calendarSystem == null) { calendarSystem = CalendarSystem.Iso; } if (timeZone == null) { timeZone = DateTimeZone.Utc; } Debug.Assert(calendarSystem != null); Debug.Assert(timeZone != null); // Move to next second. instant = instant.CeilingSecond(); // Every second case. if ((month == Month.Every) && (day == Day.Every) && (weekDay == WeekDay.Every) && (hour == Hour.Every) && (minute == Minute.Every) && (second == Second.Every) && (week == Week.Every)) { return(instant); } // Get days and months. int[] days = Days(day).OrderBy(dy => dy).ToArray(); int[] months = month.Months().ToArray(); // Remove months where the first day isn't in the month. int firstDay = days.First(); if (firstDay > 28) { // 2000 is a leap year, so February has 29 days. months = months.Where(mn => calendarSystem.GetDaysInMonth(2000, mn) >= firstDay).ToArray(); if (months.Length < 1) { return(Instant.MaxValue); } } // Get zoned date time. ZonedDateTime zdt = new ZonedDateTime(instant, timeZone, calendarSystem); int y = zdt.Year; int m = zdt.Month; int d = zdt.Day; int h = zdt.Hour; int n = zdt.Minute; int s = zdt.Second; int[] weeks = week.Weeks().ToArray(); IsoDayOfWeek[] weekDays = weekDay.WeekDays().ToArray(); int[] hours = hour.Hours().OrderBy(i => i).ToArray(); int[] minutes = minute.Minutes().OrderBy(i => i).ToArray(); int[] seconds = second.Seconds().ToArray(); do { foreach (int currentMonth in months) { if (currentMonth < m) { continue; } if (currentMonth > m) { d = 1; h = n = s = 0; } m = currentMonth; foreach (int currentDay in days) { if (currentDay < d) { continue; } if (currentDay > d) { h = n = s = 0; } d = currentDay; // Check day is valid for this month. if (d > calendarSystem.GetDaysInMonth(y, m)) { break; } // We have a potential day, check week and week day zdt = timeZone.AtLeniently(new LocalDateTime(y, m, d, h, n, s, calendarSystem)); if ((week != Week.Every) && (!weeks.Contains(zdt.WeekOfWeekYear))) { continue; } if ((weekDay != WeekDay.Every) && (!weekDays.Contains(zdt.IsoDayOfWeek))) { continue; } // We have a date match, check time. foreach (int currentHour in hours) { if (currentHour < h) { continue; } if (currentHour > h) { n = s = 0; } h = currentHour; foreach (int currentMinute in minutes) { if (currentMinute < n) { continue; } if (currentMinute > n) { s = 0; } n = currentMinute; foreach (int currentSecond in seconds) { if (currentSecond < s) { continue; } return (timeZone.AtLeniently( new LocalDateTime(y, m, d, h, n, currentSecond, calendarSystem)).ToInstant()); } n = s = 0; } h = n = s = 0; } d = 1; } d = 1; h = n = s = 0; } y++; // Don't bother checking max year. if (y >= calendarSystem.MaxYear) { return(Instant.MaxValue); } // Start next year m = d = 1; h = n = s = 0; } while (true); }
public static Day GetSelectedDay(this Month month) { return(month.Days.FirstOrDefault(day => day.IsSelected)); }
/// <summary> /// Spočítá veškeré parametry pro vyhodnocení statistiky za měsíc či rok - denní útrata, měsíční výdaje - příjmy apod /// </summary> /// <param name="month">Měsíc ve kterém se spočítá statistika</param> /// <param name="yearString">Rok ve kterém se spočítá statistika</param> /// <param name="type">0 - Výpočet pro měsíc ** 1 - Výpočet pro rok</param> public void CalculateStatisticParametres(int month, string yearString, byte type) { int.TryParse(yearString, out int year); // Získám měsíc ve výčtovém typu Month monthType = Month.Other; if (month >= 0 && month <= 12) { monthType = (Month)month; } // Kolekce, která obsahuje první a konečný den zkoumaných týdnů List <DateTime> weeks = Week.GetWeek(month + 1, year); List <double> result = new List <double>(); // Data pro měsíc nebo pro rok if (monthType != Month.Other && type == 0) { result = admin.CalculateStatisticParametres(monthType, year, type); } else if (type == 1) { result = admin.CalculateStatisticParametres(Month.Other, year, type); } // Vzdálenosti záznamů od sebe int headHeight = 35; // Výška jednoho řádků int heightChange = 22; // Pomocná proměnná, která obsahuje pozici pro vykreslení nového objektu int sumHeight = 0; // Výška předělů ve vykreslení - tmavě zelené bloky int splitHeight = 0; // Pomocné incrementy int n = 0; int monthInc = 0; int inc = 0; canvas.Children.Clear(); string[] names = new string[] { "Příjmy", "Výdaje", "Bilance", "Den", "Týden", "Týden", "Týden", "Týden", "Týden", "Týden", "Leden", "Únor", "Březen", "Duben", "Květen", "Červen", "Červenec", "Srpen", "Září", "Říjen", "Listopad", "Prosinec" }; // Pro každou získanou honotu ze správce se vykreslí řádek - modrý a bílý obdelník + název a suma for (int i = 0; i < result.Count; i++) { sumHeight = i * headHeight; if (i > 4) { if (type == 0) { heightChange = 50; sumHeight = 5 * 35 + ((i - 5) * 55); } else if (type == 1) { heightChange = 22; sumHeight = i * 35; } } if (type == 1 && i == 5) { monthInc += 5; } // Získání grafických objektů pro vykreslení na plátno - generuje je statická třída GRAPHIC (Rectangle left, Rectangle right, TextBlock name, TextBlock price) = Graphic.BlueWhitePanel(names[i + monthInc], result[i].ToString(), new int[] { 200, 100 }, new int[] { heightChange, 22 }, new int[] { 3, 3 }); // Přiřezení objektů na plátno canvas.Children.Add(left); canvas.Children.Add(right); canvas.Children.Add(name); canvas.Children.Add(price); // Vykreslení tmavě zeleného předělů v definovaných místech plátna if (i == 0 || i == 3 || i == 5) { string[] splitNames = new string[] { "Základní informace", "Průměrné výdaje", "Týdení výdaje", "Měsíční výdaje" }; (Rectangle split_rectangle, TextBlock split_text) = Graphic.SplitPanel(30, 425, 3, new SolidColorBrush(Color.FromArgb(255, 20, 82, 87)), splitNames[n]); n++; // Pro vykreslení ROKU - přeskočí název Týdenní výdaje a použije Měsíční výdaje if (type == 1 && n == 2) { n++; } canvas.Children.Add(split_rectangle); canvas.Children.Add(split_text); // Tmavě zelený obdelník, který odděluje bloky Canvas.SetLeft(split_rectangle, 5); Canvas.SetTop(split_rectangle, 8 + sumHeight + splitHeight); // Popis předělovacího bloku - NADPIS SEKCE Canvas.SetLeft(split_text, 150); Canvas.SetTop(split_text, 10 + sumHeight + splitHeight); splitHeight += 35; } // Podmínka pro vykreslení datumů pro týdny if (type == 0 && i > 4) { TextBlock weekDate = new TextBlock { FontSize = 15, FontWeight = FontWeights.Bold, Foreground = Brushes.Black, Text = "- " + weeks[inc].ToShortDateString() + " - " + weeks[inc + 1].ToShortDateString() }; canvas.Children.Add(weekDate); Canvas.SetLeft(weekDate, 20); Canvas.SetTop(weekDate, 35 + sumHeight + splitHeight); if (inc < result.Count - 1) { inc += 2; } } // Obdelnik pod typem zůstatku -- Světle modrá Canvas.SetLeft(left, 10); Canvas.SetTop(left, 10 + sumHeight + splitHeight); // Obdelnik pod hodnotou zůstatku -- bílý Canvas.SetLeft(right, 230); Canvas.SetTop(right, 10 + sumHeight + splitHeight); // Typ zůstatku Bankovní účet nebo Hotovost Canvas.SetLeft(name, 15); Canvas.SetTop(name, 10 + sumHeight + splitHeight); // Hodnota zůstatku v dané platformě Canvas.SetLeft(price, 290); Canvas.SetTop(price, 10 + sumHeight + splitHeight); } }
/// <summary> /// Determines whether the specified month has value. /// </summary> /// <param name="month">The month.</param> /// <returns>True if has a value, false in otherwise</returns> public static bool HasValue(this Month month) { return(month != Month.NotSet); }
//http://www.smart.net/~mmontes/ushols.html#ALG internal static DateTime NthDayOfTheMonth(Week week, DayOfWeek weekDay, int year, Month month) { // 7*Q - 6 + (N - DoW(Year,Month,1))%7 int x; switch (week) { case Week.Last: //NL = ND - (DoW(Year,Month,ND) - N)%7 int nd = DateTime.DaysInMonth(year, (int)month); int dow = (int)DayOfWeek(new DateTime(year, (int)month, nd)); int wd = (int)weekDay; int dowwd = dow - wd; int mod = dowwd % 7; if (dowwd < 0) { mod = 7 + dowwd; } x = (nd) - (mod); break; default: int q = (int)week + 1; //x = 7 * (int)week - 6 + (weekDay - DayOfWeek(new DateTime(year, (int)month, 1))); x = (7 * q - 6) + (weekDay - DayOfWeek(new DateTime(year, (int)month, 1))); break; } if (x > DateTime.DaysInMonth(year, (int)month)) { throw new ArgumentOutOfRangeException(string.Format("There is no {0} {1} in {2}.", week, weekDay, month)); } return(new DateTime(year, (int)month, x)); }
public void op_ToMonth_DirectoryInfo() { using (var temp = new TempDirectory()) { var file = temp.Info.ToDirectory("1969-03", true); var expected = new Month(1969, MonthOfYear.March); var actual = file.ToMonth(); Assert.Equal(expected, actual); } }
public BuiltInFunctions() { // Text Functions["len"] = new Len(); Functions["lower"] = new Lower(); Functions["upper"] = new Upper(); Functions["left"] = new Left(); Functions["right"] = new Right(); Functions["mid"] = new Mid(); Functions["replace"] = new Replace(); Functions["rept"] = new Rept(); Functions["substitute"] = new Substitute(); Functions["concatenate"] = new Concatenate(); Functions["concat"] = new Concat(); Functions["char"] = new CharFunction(); Functions["exact"] = new Exact(); Functions["find"] = new Find(); Functions["fixed"] = new Fixed(); Functions["proper"] = new Proper(); Functions["search"] = new Search(); Functions["text"] = new Text.Text(); Functions["t"] = new T(); Functions["hyperlink"] = new Hyperlink(); Functions["value"] = new Value(); Functions["trim"] = new Trim(); Functions["clean"] = new Clean(); Functions["unicode"] = new Unicode(); Functions["unichar"] = new Unichar(); Functions["numbervalue"] = new NumberValue(); // Numbers Functions["int"] = new CInt(); // Math Functions["abs"] = new Abs(); Functions["asin"] = new Asin(); Functions["asinh"] = new Asinh(); Functions["cos"] = new Cos(); Functions["cosh"] = new Cosh(); Functions["power"] = new Power(); Functions["sign"] = new Sign(); Functions["sqrt"] = new Sqrt(); Functions["sqrtpi"] = new SqrtPi(); Functions["pi"] = new Pi(); Functions["product"] = new Product(); Functions["ceiling"] = new Ceiling(); Functions["count"] = new Count(); Functions["counta"] = new CountA(); Functions["countblank"] = new CountBlank(); Functions["countif"] = new CountIf(); Functions["countifs"] = new CountIfs(); Functions["fact"] = new Fact(); Functions["floor"] = new Floor(); Functions["sin"] = new Sin(); Functions["sinh"] = new Sinh(); Functions["sum"] = new Sum(); Functions["sumif"] = new SumIf(); Functions["sumifs"] = new SumIfs(); Functions["sumproduct"] = new SumProduct(); Functions["sumsq"] = new Sumsq(); Functions["stdev"] = new Stdev(); Functions["stdevp"] = new StdevP(); Functions["stdev.s"] = new Stdev(); Functions["stdev.p"] = new StdevP(); Functions["subtotal"] = new Subtotal(); Functions["exp"] = new Exp(); Functions["log"] = new Log(); Functions["log10"] = new Log10(); Functions["ln"] = new Ln(); Functions["max"] = new Max(); Functions["maxa"] = new Maxa(); Functions["median"] = new Median(); Functions["min"] = new Min(); Functions["mina"] = new Mina(); Functions["mod"] = new Mod(); Functions["average"] = new Average(); Functions["averagea"] = new AverageA(); Functions["averageif"] = new AverageIf(); Functions["averageifs"] = new AverageIfs(); Functions["round"] = new Round(); Functions["rounddown"] = new Rounddown(); Functions["roundup"] = new Roundup(); Functions["rand"] = new Rand(); Functions["randbetween"] = new RandBetween(); Functions["rank"] = new Rank(); Functions["rank.eq"] = new Rank(); Functions["rank.avg"] = new Rank(true); Functions["quotient"] = new Quotient(); Functions["trunc"] = new Trunc(); Functions["tan"] = new Tan(); Functions["tanh"] = new Tanh(); Functions["atan"] = new Atan(); Functions["atan2"] = new Atan2(); Functions["atanh"] = new Atanh(); Functions["acos"] = new Acos(); Functions["acosh"] = new Acosh(); Functions["var"] = new Var(); Functions["varp"] = new VarP(); Functions["large"] = new Large(); Functions["small"] = new Small(); Functions["degrees"] = new Degrees(); Functions["odd"] = new Odd(); Functions["even"] = new Even(); // Information Functions["isblank"] = new IsBlank(); Functions["isnumber"] = new IsNumber(); Functions["istext"] = new IsText(); Functions["isnontext"] = new IsNonText(); Functions["iserror"] = new IsError(); Functions["iserr"] = new IsErr(); Functions["error.type"] = new ErrorType(); Functions["iseven"] = new IsEven(); Functions["isodd"] = new IsOdd(); Functions["islogical"] = new IsLogical(); Functions["isna"] = new IsNa(); Functions["na"] = new Na(); Functions["n"] = new N(); Functions["type"] = new TypeFunction(); // Logical Functions["if"] = new If(); Functions["ifs"] = new Ifs(); Functions["iferror"] = new IfError(); Functions["ifna"] = new IfNa(); Functions["not"] = new Not(); Functions["and"] = new And(); Functions["or"] = new Or(); Functions["true"] = new True(); Functions["false"] = new False(); Functions["switch"] = new Switch(); // Reference and lookup Functions["address"] = new Address(); Functions["hlookup"] = new HLookup(); Functions["vlookup"] = new VLookup(); Functions["lookup"] = new Lookup(); Functions["match"] = new Match(); Functions["row"] = new Row(); Functions["rows"] = new Rows(); Functions["column"] = new Column(); Functions["columns"] = new Columns(); Functions["choose"] = new Choose(); Functions["index"] = new RefAndLookup.Index(); Functions["indirect"] = new Indirect(); Functions["offset"] = new Offset(); // Date Functions["date"] = new Date(); Functions["today"] = new Today(); Functions["now"] = new Now(); Functions["day"] = new Day(); Functions["month"] = new Month(); Functions["year"] = new Year(); Functions["time"] = new Time(); Functions["hour"] = new Hour(); Functions["minute"] = new Minute(); Functions["second"] = new Second(); Functions["weeknum"] = new Weeknum(); Functions["weekday"] = new Weekday(); Functions["days"] = new Days(); Functions["days360"] = new Days360(); Functions["yearfrac"] = new Yearfrac(); Functions["edate"] = new Edate(); Functions["eomonth"] = new Eomonth(); Functions["isoweeknum"] = new IsoWeekNum(); Functions["workday"] = new Workday(); Functions["workday.intl"] = new WorkdayIntl(); Functions["networkdays"] = new Networkdays(); Functions["networkdays.intl"] = new NetworkdaysIntl(); Functions["datevalue"] = new DateValue(); Functions["timevalue"] = new TimeValue(); // Database Functions["dget"] = new Dget(); Functions["dcount"] = new Dcount(); Functions["dcounta"] = new DcountA(); Functions["dmax"] = new Dmax(); Functions["dmin"] = new Dmin(); Functions["dsum"] = new Dsum(); Functions["daverage"] = new Daverage(); Functions["dvar"] = new Dvar(); Functions["dvarp"] = new Dvarp(); //Finance Functions["pmt"] = new Pmt(); }
public override bool isBusinessDay(Date date) { DayOfWeek w = date.DayOfWeek; int d = date.Day, dd = date.DayOfYear; Month m = (Month)date.Month; int y = date.Year; int em = easterMonday(y); if (isWeekend(w) // Republic Day || (d == 26 && m == Month.January) // Good Friday || (dd == em - 3) // Ambedkar Jayanti || (d == 14 && m == Month.April) // Independence Day || (d == 15 && m == Month.August) // Gandhi Jayanti || (d == 2 && m == Month.October) // Christmas || (d == 25 && m == Month.December) ) { return(false); } if (y == 2005) { // Moharram, Holi, Maharashtra Day, and Ramzan Id fall // on Saturday or Sunday in 2005 if (// Bakri Id (d == 21 && m == Month.January) // Ganesh Chaturthi || (d == 7 && m == Month.September) // Dasara || (d == 12 && m == Month.October) // Laxmi Puja || (d == 1 && m == Month.November) // Bhaubeej || (d == 3 && m == Month.November) // Guru Nanak Jayanti || (d == 15 && m == Month.November) ) { return(false); } } if (y == 2006) { if (// Bakri Id (d == 11 && m == Month.January) // Moharram || (d == 9 && m == Month.February) // Holi || (d == 15 && m == Month.March) // Ram Navami || (d == 6 && m == Month.April) // Mahavir Jayanti || (d == 11 && m == Month.April) // Maharashtra Day || (d == 1 && m == Month.May) // Bhaubeej || (d == 24 && m == Month.October) // Ramzan Id || (d == 25 && m == Month.October) ) { return(false); } } if (y == 2007) { if (// Bakri Id (d == 1 && m == Month.January) // Moharram || (d == 30 && m == Month.January) // Mahashivratri || (d == 16 && m == Month.February) // Ram Navami || (d == 27 && m == Month.March) // Maharashtra Day || (d == 1 && m == Month.May) // Buddha Pournima || (d == 2 && m == Month.May) // Laxmi Puja || (d == 9 && m == Month.November) // Bakri Id (again) || (d == 21 && m == Month.December) ) { return(false); } } if (y == 2008) { if (// Mahashivratri (d == 6 && m == Month.March) // Id-E-Milad || (d == 20 && m == Month.March) // Mahavir Jayanti || (d == 18 && m == Month.April) // Maharashtra Day || (d == 1 && m == Month.May) // Buddha Pournima || (d == 19 && m == Month.May) // Ganesh Chaturthi || (d == 3 && m == Month.September) // Ramzan Id || (d == 2 && m == Month.October) // Dasara || (d == 9 && m == Month.October) // Laxmi Puja || (d == 28 && m == Month.October) // Bhau bhij || (d == 30 && m == Month.October) // Gurunanak Jayanti || (d == 13 && m == Month.November) // Bakri Id || (d == 9 && m == Month.December) ) { return(false); } } if (y == 2009) { if (// Moharram (d == 8 && m == Month.January) // Mahashivratri || (d == 23 && m == Month.February) // Id-E-Milad || (d == 10 && m == Month.March) // Holi || (d == 11 && m == Month.March) // Ram Navmi || (d == 3 && m == Month.April) // Mahavir Jayanti || (d == 7 && m == Month.April) // Maharashtra Day || (d == 1 && m == Month.May) // Ramzan Id || (d == 21 && m == Month.September) // Dasara || (d == 28 && m == Month.September) // Bhau Bhij || (d == 19 && m == Month.October) // Gurunanak Jayanti || (d == 2 && m == Month.November) // Moharram (again) || (d == 28 && m == Month.December) ) { return(false); } } if (y == 2010) { if (// New Year's Day (d == 1 && m == Month.January) // Mahashivratri || (d == 12 && m == Month.February) // Holi || (d == 1 && m == Month.March) // Ram Navmi || (d == 24 && m == Month.March) // Ramzan Id || (d == 10 && m == Month.September) // Laxmi Puja || (d == 5 && m == Month.November) // Bakri Id || (d == 17 && m == Month.November) // Moharram || (d == 17 && m == Month.December) ) { return(false); } } return(true); }
public static DateTime LastDay(this Month month, int year) => month.FirstDay(year).MonthLastDay();