private void SetCalendarForPrevFiscalYear() { pbCalendar.MinDate = CCFBGlobal.PreviousFiscalStartDate(); pbCalendar.MaxDate = CCFBGlobal.PreviousFiscalEndDate(); pbCalendar.ActiveMonth.Month = CCFBGlobal.PreviousFiscalStartDate().Month; pbCalendar.ActiveMonth.Year = CCFBGlobal.PreviousFiscalEndDate().Year; }
private void setDateRange(dtRangeType rangeType) { dtpFirst.Enabled = false; dtpLast.Enabled = false; switch (rangeType) { case dtRangeType.CurFiscal: dtpFirst.Value = CCFBGlobal.CurrentFiscalStartDate(); dtpLast.Value = DateTime.Today; break; case dtRangeType.CurCal: dtpFirst.Value = Convert.ToDateTime("01/01/" + DateTime.Now.Year.ToString()); dtpLast.Value = DateTime.Today; break; case dtRangeType.PrevFiscal: dtpFirst.Value = CCFBGlobal.PreviousFiscalStartDate(); dtpLast.Value = CCFBGlobal.PreviousFiscalEndDate(); break; case dtRangeType.PrevCal: dtpFirst.Value = Convert.ToDateTime("01/01/" + DateTime.Now.AddYears(-1).Year.ToString()); dtpLast.Value = Convert.ToDateTime("12/31/" + DateTime.Now.AddYears(-1).Year.ToString()); break; default: dtpFirst.Enabled = true; dtpLast.Enabled = true; break; } }
private void getVoucherLogForPeriod() { string newWhereClause = ""; switch (cboVHistoryPeriod.SelectedIndex) { case 0: //Current Month int month = DateTime.Now.Month; DateTime from = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); DateTime to = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month)); newWhereClause = " AND TrxDate Between '" + from.ToString() + "' AND '" + to.ToString() + "'"; break; case 1: //Last 90 Days newWhereClause = " And TrxDate Between '" + new DateTime( DateTime.Today.Year, DateTime.Today.Month, DateTime.Today.Day).AddDays(-90).ToString() + "' And '" + DateTime.Today.ToString() + "'"; break; case 2: //Current Calendar Year newWhereClause = " And TrxDate Between '" + new DateTime(DateTime.Today.Year, 1, 1).ToString() + "' And '" + new DateTime(DateTime.Today.Year, 12, 31).ToString() + "'"; break; case 3: //Current Fiscal Year newWhereClause = " And TrxDate Between '" + CCFBGlobal.CurrentFiscalStartDate().ToString() + "' And '" + CCFBGlobal.CurrentFiscalEndDate().ToString() + "'"; break; case 4: //Previous Calendar Year newWhereClause = " And TrxDate Between '" + new DateTime(DateTime.Today.Year - 1, 1, 1).ToString() + "' ANd '" + new DateTime(DateTime.Today.Year - 1, 12, 31).ToString() + "'"; break; case 5: //Previous Fiscal Year newWhereClause = " And TrxDate Between '" + CCFBGlobal.PreviousFiscalStartDate().ToString() + "' And '" + CCFBGlobal.PreviousFiscalEndDate().ToString() + "'"; break; default: //ALL newWhereClause = ""; break; } loadVoucherLog(newWhereClause); }