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);
}
