/// <summary>
/// Cache item until absolute expiration THIS YEAR / 01 / 01 @ 17h45
/// </summary>
/// <param name="month">1</param>
/// <param name="day">1</param>
/// <param name="hour">17</param>
/// <param name="minute">45</param>
/// <param name="second">0</param>
public CacheOutputUntilThisYearAttribute(int month,
int day,
int hour = 0,
int minute = 0,
int second = 0)
{
CacheTimeQuery = new ThisYear(month, day, hour, minute, second);
}
/// <summary>
/// Cache item until absolute expiration THIS YEAR / 01 / 01 @ 17h45
/// </summary>
/// <param name="month">1</param>
/// <param name="day">1</param>
/// <param name="hour">17</param>
/// <param name="minute">45</param>
/// <param name="second">0</param>
public CacheOutputUntilThisYearAttribute(int month,
int day,
int hour = 0,
int minute = 0,
int second = 0)
{
CacheTimeQuery = new ThisYear(month, day, hour, minute, second);
}
protected void PageInit()
{
//昨日
Yestoday.DataSource = Query(o => o.date.Date == DateTime.Now.AddDays(-1).Date&& o.paid == true && o.price1 >= 1, out yestodyDaySales, out yestodyTotal);
Yestoday.DataBind();
//七天前
ServerDays.DataSource = Query(o => o.date.Date >= DateTime.Now.AddDays(-7).Date&& o.paid == true && o.price1 >= 1, out serverDaySales, out serverTotal);
ServerDays.DataBind();
//上月
LastMonth.DataSource = Query(o => o.date.Year == DateTime.Now.AddMonths(-1).Year&& o.date.Month == DateTime.Now.AddMonths(-1).Month&& o.paid == true && o.price1 >= 1, out lastMonthDaySales, out lastMonthTotal);
LastMonth.DataBind();
//本月
ThisMonth.DataSource = Query(o => o.date.Year == DateTime.Now.Year && o.date.Month == DateTime.Now.Month && o.date.Day >= 1 && o.paid == true && o.price1 >= 1, out thisMonthDaySales, out thisMonthTotal);
ThisMonth.DataBind();
//今年
ThisYear.DataSource = Query(o => o.date.Year == DateTime.Now.Year && o.paid == true && o.price1 >= 1, out thisYearDaySales, out thisYearTotal);
ThisYear.DataBind();
//全部
AllGoods.DataSource = Query(o => o.paid == true && o.price1 >= 1, out allDaySales, out allTotal);
AllGoods.DataBind();
}
protected void filldatebyperiod()
{
string Today, Yesterday, ThisYear;
Today = Convert.ToString(System.DateTime.Today.ToShortDateString());
Yesterday = Convert.ToString(System.DateTime.Today.AddDays(-1).ToShortDateString());
ThisYear = Convert.ToString(System.DateTime.Today.Year.ToString());
DateTime d1, d2, d3, d4, d5, d6, d7;
DateTime weekstart, weekend;
d1 = Convert.ToDateTime(System.DateTime.Today.ToShortDateString());
d2 = Convert.ToDateTime(System.DateTime.Today.AddDays(-1).ToShortDateString());
d3 = Convert.ToDateTime(System.DateTime.Today.AddDays(-2).ToShortDateString());
d4 = Convert.ToDateTime(System.DateTime.Today.AddDays(-3).ToShortDateString());
d5 = Convert.ToDateTime(System.DateTime.Today.AddDays(-4).ToShortDateString());
d6 = Convert.ToDateTime(System.DateTime.Today.AddDays(-5).ToShortDateString());
d7 = Convert.ToDateTime(System.DateTime.Today.AddDays(-6).ToShortDateString());
string ThisWeek = (System.DateTime.Today.DayOfWeek.ToString());
if (ThisWeek.ToString() == "Monday")
{
weekstart = d1;
weekend = weekstart.Date.AddDays(+6);
}
else if (Convert.ToString(ThisWeek) == "Tuesday")
{
weekstart = d2;
weekend = weekstart.Date.AddDays(+6);
}
else if (ThisWeek.ToString() == "Wednesday")
{
weekstart = d3;
weekend = weekstart.Date.AddDays(+6);
}
else if (ThisWeek.ToString() == "Thursday")
{
weekstart = d4;
weekend = weekstart.Date.AddDays(+6);
}
else if (ThisWeek.ToString() == "Friday")
{
weekstart = d5;
weekend = weekstart.Date.AddDays(+6);
}
else if (ThisWeek.ToString() == "Saturday")
{
weekstart = d6;
weekend = weekstart.Date.AddDays(+6);
}
else
{
weekstart = d7;
weekend = weekstart.Date.AddDays(+6);
}
string thisweekstart = weekstart.ToShortDateString();
ViewState["thisweekstart"] = thisweekstart;
string thisweekend = weekend.ToShortDateString();
ViewState["thisweekend"] = thisweekend;
//.................this week .....................
DateTime d17, d8, d9, d10, d11, d12, d13;
DateTime lastweekstart, lastweekend;
d17 = Convert.ToDateTime(System.DateTime.Today.AddDays(-7).ToShortDateString());
d8 = Convert.ToDateTime(System.DateTime.Today.AddDays(-8).ToShortDateString());
d9 = Convert.ToDateTime(System.DateTime.Today.AddDays(-9).ToShortDateString());
d10 = Convert.ToDateTime(System.DateTime.Today.AddDays(-10).ToShortDateString());
d11 = Convert.ToDateTime(System.DateTime.Today.AddDays(-11).ToShortDateString());
d12 = Convert.ToDateTime(System.DateTime.Today.AddDays(-12).ToShortDateString());
d13 = Convert.ToDateTime(System.DateTime.Today.AddDays(-13).ToShortDateString());
string thisday = (System.DateTime.Today.DayOfWeek.ToString());
if (thisday.ToString() == "Monday")
{
lastweekstart = d17;
lastweekend = lastweekstart.Date.AddDays(+6);
}
else if (Convert.ToString(thisday) == "Tuesday")
{
lastweekstart = d8;
lastweekend = lastweekstart.Date.AddDays(+6);
}
else if (thisday.ToString() == "Wednesday")
{
lastweekstart = d9;
lastweekend = lastweekstart.Date.AddDays(+6);
}
else if (thisday.ToString() == "Thursday")
{
lastweekstart = d10;
lastweekend = lastweekstart.Date.AddDays(+6);
}
else if (thisday.ToString() == "Friday")
{
lastweekstart = d11;
lastweekend = lastweekstart.Date.AddDays(+6);
}
else if (thisday.ToString() == "Saturday")
{
lastweekstart = d12;
lastweekend = lastweekstart.Date.AddDays(+6);
}
else
{
lastweekstart = d13;
lastweekend = lastweekstart.Date.AddDays(+6);
}
string lastweekstartdate = lastweekstart.ToShortDateString();
ViewState["lastweekstart"] = lastweekstartdate;
string lastweekenddate = lastweekend.ToShortDateString();
ViewState["lastweekend"] = lastweekenddate;
//.................last week .....................
DateTime d14, d15, d16, d171, d18, d19, d20;
DateTime last2weekstart, last2weekend;
d14 = Convert.ToDateTime(System.DateTime.Today.AddDays(-14).ToShortDateString());
d15 = Convert.ToDateTime(System.DateTime.Today.AddDays(-15).ToShortDateString());
d16 = Convert.ToDateTime(System.DateTime.Today.AddDays(-16).ToShortDateString());
d171 = Convert.ToDateTime(System.DateTime.Today.AddDays(-17).ToShortDateString());
d18 = Convert.ToDateTime(System.DateTime.Today.AddDays(-18).ToShortDateString());
d19 = Convert.ToDateTime(System.DateTime.Today.AddDays(-19).ToShortDateString());
d20 = Convert.ToDateTime(System.DateTime.Today.AddDays(-20).ToShortDateString());
//string thisday = (System.DateTime.Today.DayOfWeek.ToString());
if (thisday.ToString() == "Monday")
{
last2weekstart = d14;
last2weekend = last2weekstart.Date.AddDays(+6);
}
else if (Convert.ToString(thisday) == "Tuesday")
{
last2weekstart = d15;
last2weekend = last2weekstart.Date.AddDays(+6);
}
else if (thisday.ToString() == "Wednesday")
{
last2weekstart = d16;
last2weekend = last2weekstart.Date.AddDays(+6);
}
else if (thisday.ToString() == "Thursday")
{
last2weekstart = d171;
last2weekend = last2weekstart.Date.AddDays(+6);
}
else if (thisday.ToString() == "Friday")
{
last2weekstart = d18;
last2weekend = last2weekstart.Date.AddDays(+6);
}
else if (thisday.ToString() == "Saturday")
{
last2weekstart = d19;
last2weekend = last2weekstart.Date.AddDays(+6);
}
else
{
last2weekstart = d20;
last2weekend = last2weekstart.Date.AddDays(+6);
}
string last2weekstartdate = last2weekstart.ToShortDateString();
ViewState["last2weekstart"] = last2weekstartdate;
//string last2weekenddate = last2weekend.ToShortDateString();
//ViewState["last2week"] = last2weekenddate;
//------------------this month period-----------------
DateTime thismonthstart = Convert.ToDateTime(System.DateTime.Now.Month.ToString() + "/1/" + System.DateTime.Now.Year.ToString());
string thismonthstartdate = thismonthstart.ToShortDateString();
ViewState["thismonthstartdate"] = thismonthstartdate;
string thismonthenddate = Today.ToString();
ViewState["thismonthenddate"] = thismonthenddate;
//------------------this month period end................
//-----------------last month period start ---------------
// int last2monthno = Convert.ToInt32(thismonthstart.Month.ToString()) - 2;
int lastmonthno = Convert.ToInt32(thismonthstart.Month.ToString()) - 1;
string lastmonthNumber = Convert.ToString(lastmonthno.ToString());
DateTime lastmonth = Convert.ToDateTime(lastmonthNumber.ToString() + "/1/" + ThisYear.ToString());
string lastmonthstart = lastmonth.ToShortDateString();
string lastmonthend = "";
if (lastmonthNumber == "1" || lastmonthNumber == "3" || lastmonthNumber == "5" || lastmonthNumber == "7" || lastmonthNumber == "8" || lastmonthNumber == "10" || lastmonthNumber == "12")
{
lastmonthend = lastmonthNumber + "/31/" + ThisYear.ToString();
}
else if (lastmonthNumber == "4" || lastmonthNumber == "6" || lastmonthNumber == "9" || lastmonthNumber == "11")
{
lastmonthend = lastmonthNumber + "/30/" + ThisYear.ToString();
}
else
{
if (System.DateTime.IsLeapYear(Convert.ToInt32(ThisYear.ToString())))
{
lastmonthend = lastmonthNumber + "/29/" + ThisYear.ToString();
}
else
{
lastmonthend = lastmonthNumber + "/28/" + ThisYear.ToString();
}
}
string lastmonthstartdate = lastmonthstart.ToString();
ViewState["lastmonthstartdate"] = lastmonthstartdate;
string lastmonthenddate = lastmonthend.ToString();
ViewState["lastmonthenddate"] = lastmonthenddate;
//-----------------last month period end -----------------------
int last2monthno = Convert.ToInt32(thismonthstart.Month.ToString()) - 2;
string last2monthNumber = Convert.ToString(last2monthno.ToString());
DateTime last2month = Convert.ToDateTime(last2monthNumber.ToString() + "/1/" + ThisYear.ToString());
string last2monthstart = last2month.ToShortDateString();
ViewState["last2monthstart"] = last2monthstart;
//-----------------last 2 month period end -----------------------
//--------------this year period start----------------------
DateTime thisyearstart = Convert.ToDateTime("1/1/" + ThisYear.ToString());
DateTime thisyearend = Convert.ToDateTime("12/31/" + ThisYear.ToString());
string thisyearstartdate = thisyearstart.ToShortDateString();
ViewState["thisyearstartdate"] = thisyearstartdate;
string thisyearenddate = thisyearend.ToShortDateString();
ViewState["thisyearenddate"] = thisyearenddate;
//---------------this year period end-------------------
//--------------last year period start----------------------
DateTime lastyearstart = Convert.ToDateTime("1/1/" + System.DateTime.Today.AddYears(-1).Year.ToString());
DateTime lastyearend = Convert.ToDateTime("12/31/" + System.DateTime.Today.AddYears(-1).Year.ToString());
string lastyearstartdate = lastyearstart.ToShortDateString();
ViewState["lastyearstartdate"] = lastyearstartdate;
string lastyearenddate = lastyearend.ToShortDateString();
ViewState["lastyearenddate"] = lastyearenddate;
//---------------last year period end-------------------
DateTime last2yearstart = Convert.ToDateTime("1/1/" + System.DateTime.Today.AddYears(-2).Year.ToString());
string last2yearstartdate = last2yearstart.ToShortDateString();
ViewState["last2yearstartdate"] = last2yearstartdate;
//---------------last 2 year period -------------------
}
protected void ddlDuration_SelectedIndexChanged(object sender, EventArgs e)
{
//date between you should use date first and earlier date lateafter
string Today, Yesterday, ThisYear;
Today = Convert.ToString(System.DateTime.Today.ToShortDateString());
Yesterday = Convert.ToString(System.DateTime.Today.AddDays(-1).ToShortDateString());
ThisYear = Convert.ToString(System.DateTime.Today.Year.ToString());
//-------------------this week start...............
DateTime d1, d2, d3, d4, d5, d6, d7;
DateTime weekstart, weekend;
d1 = Convert.ToDateTime(System.DateTime.Today.ToShortDateString());
d2 = Convert.ToDateTime(System.DateTime.Today.AddDays(-1).ToShortDateString());
d3 = Convert.ToDateTime(System.DateTime.Today.AddDays(-2).ToShortDateString());
d4 = Convert.ToDateTime(System.DateTime.Today.AddDays(-3).ToShortDateString());
d5 = Convert.ToDateTime(System.DateTime.Today.AddDays(-4).ToShortDateString());
d6 = Convert.ToDateTime(System.DateTime.Today.AddDays(-5).ToShortDateString());
d7 = Convert.ToDateTime(System.DateTime.Today.AddDays(-6).ToShortDateString());
string ThisWeek = (System.DateTime.Today.DayOfWeek.ToString());
if (ThisWeek.ToString() == "Monday")
{
weekstart = d1;
weekend = weekstart.Date.AddDays(+6);
}
else if (Convert.ToString(ThisWeek) == "Tuesday")
{
weekstart = d2;
weekend = weekstart.Date.AddDays(+6);
}
else if (ThisWeek.ToString() == "Wednesday")
{
weekstart = d3;
weekend = weekstart.Date.AddDays(+6);
}
else if (ThisWeek.ToString() == "Thursday")
{
weekstart = d4;
weekend = weekstart.Date.AddDays(+6);
}
else if (ThisWeek.ToString() == "Friday")
{
weekstart = d5;
weekend = weekstart.Date.AddDays(+6);
}
else if (ThisWeek.ToString() == "Saturday")
{
weekstart = d6;
weekend = weekstart.Date.AddDays(+6);
}
else
{
weekstart = d7;
weekend = weekstart.Date.AddDays(+6);
}
string thisweekstart = weekstart.ToShortDateString();
string thisweekend = weekend.ToShortDateString();
//.................this week duration end.....................
///--------------------last week duration ....
DateTime d17, d8, d9, d10, d11, d12, d13;
DateTime lastweekstart, lastweekend;
d17 = Convert.ToDateTime(System.DateTime.Today.AddDays(-7).ToShortDateString());
d8 = Convert.ToDateTime(System.DateTime.Today.AddDays(-8).ToShortDateString());
d9 = Convert.ToDateTime(System.DateTime.Today.AddDays(-9).ToShortDateString());
d10 = Convert.ToDateTime(System.DateTime.Today.AddDays(-10).ToShortDateString());
d11 = Convert.ToDateTime(System.DateTime.Today.AddDays(-11).ToShortDateString());
d12 = Convert.ToDateTime(System.DateTime.Today.AddDays(-12).ToShortDateString());
d13 = Convert.ToDateTime(System.DateTime.Today.AddDays(-13).ToShortDateString());
string thisday = (System.DateTime.Today.DayOfWeek.ToString());
if (thisday.ToString() == "Monday")
{
lastweekstart = d17;
lastweekend = lastweekstart.Date.AddDays(+6);
}
else if (Convert.ToString(thisday) == "Tuesday")
{
lastweekstart = d8;
lastweekend = lastweekstart.Date.AddDays(+6);
}
else if (thisday.ToString() == "Wednesday")
{
lastweekstart = d9;
lastweekend = lastweekstart.Date.AddDays(+6);
}
else if (thisday.ToString() == "Thursday")
{
lastweekstart = d10;
lastweekend = lastweekstart.Date.AddDays(+6);
}
else if (thisday.ToString() == "Friday")
{
lastweekstart = d11;
lastweekend = lastweekstart.Date.AddDays(+6);
}
else if (thisday.ToString() == "Saturday")
{
lastweekstart = d12;
lastweekend = lastweekstart.Date.AddDays(+6);
}
else
{
lastweekstart = d13;
lastweekend = lastweekstart.Date.AddDays(+6);
}
string lastweekstartdate = lastweekstart.ToShortDateString();
string lastweekenddate = lastweekend.ToString();
//---------------lastweek duration end.................
// Today
//2 Yesterday
//3 ThisWeek
//4 LastWeek
//5 ThisMonth
//6 LastMonth
//7 ThisQuarter
//8 LastQuarter
//9 ThisYear
//10Last Year
//------------------this month period-----------------
DateTime thismonthstart = Convert.ToDateTime(System.DateTime.Now.Month.ToString() + "/1/" + System.DateTime.Now.Year.ToString());
string thismonthstartdate = thismonthstart.ToShortDateString();
string thismonthenddate = Today.ToString();
//------------------this month period end................
//-----------------last month period start ---------------
int lastmonthno = Convert.ToInt32(thismonthstart.Month.ToString()) - 1;
string lastmonthNumber = Convert.ToString(lastmonthno.ToString());
DateTime lastmonth = Convert.ToDateTime(lastmonthNumber.ToString() + "/1/" + ThisYear.ToString());
string lastmonthstart = lastmonth.ToShortDateString();
string lastmonthend = "";
if (lastmonthNumber == "1" || lastmonthNumber == "3" || lastmonthNumber == "5" || lastmonthNumber == "7" || lastmonthNumber == "9" || lastmonthNumber == "11")
{
lastmonthend = lastmonthNumber + "/31/" + ThisYear.ToString();
}
else if (lastmonthNumber == "4" || lastmonthNumber == "6" || lastmonthNumber == "8" || lastmonthNumber == "10" || lastmonthNumber == "12")
{
lastmonthend = lastmonthNumber + "/30/" + ThisYear.ToString();
}
else
{
if (System.DateTime.IsLeapYear(Convert.ToInt32(ThisYear.ToString())))
{
lastmonthend = lastmonthNumber + "/29/" + ThisYear.ToString();
}
else
{
lastmonthend = lastmonthNumber + "/28/" + ThisYear.ToString();
}
}
string lastmonthstartdate = lastmonthstart.ToString();
string lastmonthenddate = lastmonthend.ToString();
//-----------------last month period end -----------------------
//--------------------this quater period start ----------------
int thisqtr = Convert.ToInt32(thismonthstart.AddMonths(-2).Month.ToString());
string thisqtrNumber = Convert.ToString(thisqtr.ToString());
DateTime thisquater = Convert.ToDateTime(thisqtrNumber.ToString() + "/1/" + ThisYear.ToString());
string thisquaterstart = thisquater.ToShortDateString();
string thisquaterend = "";
if (thisqtrNumber == "1" || thisqtrNumber == "3" || thisqtrNumber == "5" || thisqtrNumber == "7" || thisqtrNumber == "9" || thisqtrNumber == "11")
{
thisquaterend = thisqtrNumber + "/31/" + ThisYear.ToString();
}
else if (thisqtrNumber == "4" || thisqtrNumber == "6" || thisqtrNumber == "8" || thisqtrNumber == "10" || thisqtrNumber == "12")
{
thisquaterend = thisqtrNumber + "/30/" + ThisYear.ToString();
}
else
{
if (System.DateTime.IsLeapYear(Convert.ToInt32(ThisYear.ToString())))
{
thisquaterend = thisqtrNumber + "/29/" + ThisYear.ToString();
}
else
{
thisquaterend = thisqtrNumber + "/28/" + ThisYear.ToString();
}
}
string thisquaterstartdate = thisquaterstart.ToString();
string thisquaterenddate = thisquaterend.ToString();
// --------------this quater period end ------------------------
// --------------last quater period start----------------------
int lastqtr = Convert.ToInt32(thismonthstart.AddMonths(-5).Month.ToString());// -5;
string lastqtrNumber = Convert.ToString(lastqtr.ToString());
int lastqater3 = Convert.ToInt32(thismonthstart.AddMonths(-3).Month.ToString());
//DateTime lastqater3 = Convert.ToDateTime(System.DateTime.Now.AddMonths(-3).Month.ToString());
string lasterquater3 = lastqater3.ToString();
DateTime lastquater = Convert.ToDateTime(lastqtrNumber.ToString() + "/1/" + ThisYear.ToString());
string lastquaterstart = lastquater.ToShortDateString();
string lastquaterend = "";
if (lastqtrNumber == "1" || lastqtrNumber == "3" || lastqtrNumber == "5" || lastqtrNumber == "7" || lastqtrNumber == "9" || lastqtrNumber == "11")
{
lastquaterend = lasterquater3 + "/31/" + ThisYear.ToString();
}
else if (lastqtrNumber == "4" || lastqtrNumber == "6" || lastqtrNumber == "8" || lastqtrNumber == "10" || lastqtrNumber == "12")
{
lastquaterend = lasterquater3 + "/30/" + ThisYear.ToString();
}
else
{
if (System.DateTime.IsLeapYear(Convert.ToInt32(ThisYear.ToString())))
{
lastquaterend = lasterquater3 + "/29/" + ThisYear.ToString();
}
else
{
lastquaterend = lasterquater3 + "/28/" + ThisYear.ToString();
}
}
string lastquaterstartdate = lastquaterstart.ToString();
string lastquaterenddate = lastquaterend.ToString();
//--------------last quater period end-------------------------
//--------------this year period start----------------------
DateTime thisyearstart = Convert.ToDateTime("1/1/" + ThisYear.ToString());
DateTime thisyearend = Convert.ToDateTime("12/31/" + ThisYear.ToString());
string thisyearstartdate = thisyearstart.ToShortDateString();
string thisyearenddate = thisyearend.ToShortDateString();
//---------------this year period end-------------------
//--------------this year period start----------------------
DateTime lastyearstart = Convert.ToDateTime("1/1/" + System.DateTime.Today.AddYears(-1).Year.ToString());
DateTime lastyearend = Convert.ToDateTime("12/31/" + System.DateTime.Today.AddYears(-1).Year.ToString());
string lastyearstartdate = lastyearstart.ToShortDateString();
string lastyearenddate = lastyearend.ToShortDateString();
//---------------this year period end-------------------
string periodstartdate = "";
string periodenddate = "";
if (ddlDuration.SelectedItem.Text == "Today")
{
periodstartdate = Today.ToString();
periodenddate = Today.ToString();
}
else if (ddlDuration.SelectedItem.Text == "Yesterday")
{
periodstartdate = Yesterday.ToString();
periodenddate = Yesterday.ToString();
}
else if (ddlDuration.SelectedItem.Text == "This Week")
{
periodstartdate = thisweekstart.ToString();
periodenddate = thisweekend.ToString();
}
else if (ddlDuration.SelectedItem.Text == "Last Week")
{
periodstartdate = lastweekstartdate.ToString();
periodenddate = Today.ToString();
}
else if (ddlDuration.SelectedItem.Text == "This Month")
{
periodstartdate = thismonthstart.ToShortDateString();
periodenddate = Today.ToString();
}
else if (ddlDuration.SelectedItem.Text == "Last Month")
{
periodstartdate = lastmonthstartdate.ToString();
periodenddate = lastmonthenddate.ToString();
}
else if (ddlDuration.SelectedItem.Text == "This Quarter")
{
periodstartdate = thisquaterstartdate.ToString();
periodenddate = thisquaterenddate.ToString();
}
else if (ddlDuration.SelectedItem.Text == "Last Quarter")
{
periodstartdate = lastquaterstartdate.ToString();
periodenddate = lastquaterenddate.ToString();
}
else if (ddlDuration.SelectedItem.Text == "This Year")
{
periodstartdate = thisyearstartdate.ToString();
periodenddate = thisyearenddate.ToString();
}
else if (ddlDuration.SelectedItem.Text == "Last Year")
{
periodstartdate = lastyearstartdate.ToString();
periodenddate = lastyearenddate.ToString();
}
else
{
periodstartdate = "1/1/1900";
periodenddate = Today.ToString();
}
if (periodstartdate.Length > 0)
{
txtfrom.Text = periodstartdate;
txtto.Text = periodenddate; // periodstartdate;
// Session["MFDate"] = txtFromDate.Text;
// Session["MTDate"] = txtToDate.Text; // txtFromDate.Text;
// DropDownList1_SelectedIndexChanged(sender, e);
}
}
private string BetweenByPeriod()
{
//date between you should use date first and earlier date lateafter
string Today, Yesterday, ThisYear;
Today = Convert.ToString(System.DateTime.Today.ToShortDateString());
Yesterday = Convert.ToString(System.DateTime.Today.AddDays(-1).ToShortDateString());
ThisYear = Convert.ToString(System.DateTime.Today.Year.ToString());
//-------------------this week start...............
DateTime d1, d2, d3, d4, d5, d6, d7;
DateTime weekstart, weekend;
d1 = Convert.ToDateTime(System.DateTime.Today.ToShortDateString());
d2 = Convert.ToDateTime(System.DateTime.Today.AddDays(-1).ToShortDateString());
d3 = Convert.ToDateTime(System.DateTime.Today.AddDays(-2).ToShortDateString());
d4 = Convert.ToDateTime(System.DateTime.Today.AddDays(-3).ToShortDateString());
d5 = Convert.ToDateTime(System.DateTime.Today.AddDays(-4).ToShortDateString());
d6 = Convert.ToDateTime(System.DateTime.Today.AddDays(-5).ToShortDateString());
d7 = Convert.ToDateTime(System.DateTime.Today.AddDays(-6).ToShortDateString());
string ThisWeek = (System.DateTime.Today.DayOfWeek.ToString());
if (ThisWeek.ToString() == "Monday")
{
weekstart = d1;
weekend = weekstart.Date.AddDays(+6);
}
else if (Convert.ToString(ThisWeek) == "Tuesday")
{
weekstart = d2;
weekend = weekstart.Date.AddDays(+6);
}
else if (ThisWeek.ToString() == "Wednesday")
{
weekstart = d3;
weekend = weekstart.Date.AddDays(+6);
}
else if (ThisWeek.ToString() == "Thursday")
{
weekstart = d4;
weekend = weekstart.Date.AddDays(+6);
}
else if (ThisWeek.ToString() == "Friday")
{
weekstart = d5;
weekend = weekstart.Date.AddDays(+6);
}
else if (ThisWeek.ToString() == "Saturday")
{
weekstart = d6;
weekend = weekstart.Date.AddDays(+6);
}
else
{
weekstart = d7;
weekend = weekstart.Date.AddDays(+6);
}
string thisweekstart = weekstart.ToString();
string thisweekend = weekend.ToString();
//.................this week duration end.....................
///--------------------last week duration ....
DateTime d17, d8, d9, d10, d11, d12, d13;
DateTime lastweekstart, lastweekend;
d17 = Convert.ToDateTime(System.DateTime.Today.AddDays(-7).ToShortDateString());
d8 = Convert.ToDateTime(System.DateTime.Today.AddDays(-8).ToShortDateString());
d9 = Convert.ToDateTime(System.DateTime.Today.AddDays(-9).ToShortDateString());
d10 = Convert.ToDateTime(System.DateTime.Today.AddDays(-10).ToShortDateString());
d11 = Convert.ToDateTime(System.DateTime.Today.AddDays(-11).ToShortDateString());
d12 = Convert.ToDateTime(System.DateTime.Today.AddDays(-12).ToShortDateString());
d13 = Convert.ToDateTime(System.DateTime.Today.AddDays(-13).ToShortDateString());
string thisday = (System.DateTime.Today.DayOfWeek.ToString());
if (thisday.ToString() == "Monday")
{
lastweekstart = d17;
lastweekend = lastweekstart.Date.AddDays(+6);
}
else if (Convert.ToString(thisday) == "Tuesday")
{
lastweekstart = d8;
lastweekend = lastweekstart.Date.AddDays(+6);
}
else if (thisday.ToString() == "Wednesday")
{
lastweekstart = d9;
lastweekend = lastweekstart.Date.AddDays(+6);
}
else if (thisday.ToString() == "Thursday")
{
lastweekstart = d10;
lastweekend = lastweekstart.Date.AddDays(+6);
}
else if (thisday.ToString() == "Friday")
{
lastweekstart = d11;
lastweekend = lastweekstart.Date.AddDays(+6);
}
else if (thisday.ToString() == "Saturday")
{
lastweekstart = d12;
lastweekend = lastweekstart.Date.AddDays(+6);
}
else
{
lastweekstart = d13;
lastweekend = lastweekstart.Date.AddDays(+6);
}
string lastweekstartdate = lastweekstart.ToString();
string lastweekenddate = lastweekend.ToString();
//---------------lastweek duration end.................
// Today
//2 Yesterday
//3 ThisWeek
//4 LastWeek
//5 ThisMonth
//6 LastMonth
//7 ThisQuarter
//8 LastQuarter
//9 ThisYear
//10Last Year
//------------------this month period-----------------
DateTime thismonthstart = Convert.ToDateTime(System.DateTime.Now.Month.ToString() + "/1/" + System.DateTime.Now.Year.ToString());
string thismonthstartdate = thismonthstart.ToShortDateString();
string thismonthenddate = Today.ToString();
//------------------this month period end................
//-----------------last month period start ---------------
string lastmonthNumber = "12";
int yearforlastmont12 = Convert.ToInt32(ThisYear);
int lastmonthno = Convert.ToInt32(thismonthstart.Month.ToString()) - 1;
if (lastmonthno.ToString() == "0")
{
yearforlastmont12 = Convert.ToInt32(ThisYear) - 1;
}
else
{
lastmonthNumber = Convert.ToString(lastmonthno.ToString());
}
//int lastmonthno = Convert.ToInt32(thismonthstart.Month.ToString()) - 1;
//string lastmonthNumber = Convert.ToString(lastmonthno.ToString());
DateTime lastmonth = Convert.ToDateTime(lastmonthNumber.ToString() + "/1/" + yearforlastmont12.ToString());
string lastmonthstart = lastmonth.ToShortDateString();
string lastmonthend = "";
if (lastmonthNumber == "1" || lastmonthNumber == "3" || lastmonthNumber == "5" || lastmonthNumber == "7" || lastmonthNumber == "8" || lastmonthNumber == "10" || lastmonthNumber == "12")
{
lastmonthend = lastmonthNumber + "/31/" + yearforlastmont12.ToString();
}
else if (lastmonthNumber == "4" || lastmonthNumber == "6" || lastmonthNumber == "9" || lastmonthNumber == "11")
{
lastmonthend = lastmonthNumber + "/30/" + yearforlastmont12.ToString();
}
else
{
if (System.DateTime.IsLeapYear(Convert.ToInt32(ThisYear.ToString())))
{
lastmonthend = lastmonthNumber + "/29/" + yearforlastmont12.ToString();
}
else
{
lastmonthend = lastmonthNumber + "/28/" + yearforlastmont12.ToString();
}
}
string lastmonthstartdate = lastmonthstart.ToString();
string lastmonthenddate = lastmonthend.ToString();
//-----------------last month period end -----------------------
//--------------------this quater period start ----------------
int thisqtr = Convert.ToInt32(thismonthstart.AddMonths(-2).Month.ToString());
string thisqtrNumber = Convert.ToString(thisqtr.ToString());
int lstyear = Convert.ToInt32(ThisYear);
if (thisqtrNumber.ToString() == "11" || thisqtrNumber.ToString() == "12")
{
lstyear = Convert.ToInt32(ThisYear) - 1;
}
DateTime thisquater = Convert.ToDateTime(thisqtrNumber.ToString() + "/1/" + lstyear.ToString());
string thisquaterstart = thisquater.ToShortDateString();
string thisquaterend = "";
if (thisqtrNumber == "1" || thisqtrNumber == "3" || thisqtrNumber == "5" || thisqtrNumber == "7" || thisqtrNumber == "8" || thisqtrNumber == "10" || thisqtrNumber == "12")
{
thisquaterend = thisqtrNumber + "/31/" + ThisYear.ToString();
}
else if (thisqtrNumber == "4" || thisqtrNumber == "6" || thisqtrNumber == "9" || thisqtrNumber == "11")
{
thisquaterend = thisqtrNumber + "/30/" + ThisYear.ToString();
}
else
{
if (System.DateTime.IsLeapYear(Convert.ToInt32(ThisYear.ToString())))
{
thisquaterend = thisqtrNumber + "/29/" + ThisYear.ToString();
}
else
{
thisquaterend = thisqtrNumber + "/28/" + ThisYear.ToString();
}
}
string thisquaterstartdate = thisquaterstart.ToString();
string thisquaterenddate = thismonthenddate.ToString();
// --------------this quater period end ------------------------
// --------------last quater period start----------------------
int lastqtr = Convert.ToInt32(thismonthstart.AddMonths(-5).Month.ToString());// -5;
string lastqtrNumber = Convert.ToString(lastqtr.ToString());
int lastqater3 = Convert.ToInt32(thismonthstart.AddMonths(-3).Month.ToString());
//DateTime lastqater3 = Convert.ToDateTime(System.DateTime.Now.AddMonths(-3).Month.ToString());
string lasterquater3 = lastqater3.ToString();
int lstyreee = Convert.ToInt32(ThisYear);
if (lasterquater3.ToString() == "10" || lasterquater3.ToString() == "11" || lasterquater3.ToString() == "12")
{
lstyreee = Convert.ToInt32(ThisYear) - 1;
}
DateTime lastquater = Convert.ToDateTime(lastqtrNumber.ToString() + "/1/" + lstyreee.ToString());
string lastquaterstart = lastquater.ToShortDateString();
string lastquaterend = "";
if (lasterquater3 == "1" || lasterquater3 == "3" || lasterquater3 == "5" || lasterquater3 == "7" || lasterquater3 == "8" || lasterquater3 == "10" || lasterquater3 == "12")
{
lastquaterend = lasterquater3 + "/31/" + lstyreee.ToString();
}
else if (lasterquater3 == "4" || lasterquater3 == "6" || lasterquater3 == "9" || lasterquater3 == "11")
{
lastquaterend = lasterquater3 + "/30/" + lstyreee.ToString();
}
else
{
if (System.DateTime.IsLeapYear(Convert.ToInt32(lstyreee.ToString())))
{
lastquaterend = lasterquater3 + "/29/" + lstyreee.ToString();
}
else
{
lastquaterend = lasterquater3 + "/28/" + lstyreee.ToString();
}
}
string lastquaterstartdate = lastquaterstart.ToString();
string lastquaterenddate = lastquaterend.ToString();
//--------------last quater period end-------------------------
//--------------this year period start----------------------
DateTime thisyearstart = Convert.ToDateTime("1/1/" + ThisYear.ToString());
DateTime thisyearend = Convert.ToDateTime("12/31/" + ThisYear.ToString());
string thisyearstartdate = thisyearstart.ToShortDateString();
string thisyearenddate = thisyearend.ToShortDateString();
//---------------this year period end-------------------
//--------------this year period start----------------------
DateTime lastyearstart = Convert.ToDateTime("1/1/" + System.DateTime.Today.AddYears(-1).Year.ToString());
DateTime lastyearend = Convert.ToDateTime("12/31/" + System.DateTime.Today.AddYears(-1).Year.ToString());
string lastyearstartdate = lastyearstart.ToShortDateString();
string lastyearenddate = lastyearend.ToShortDateString();
//---------------this year period end-------------------
string periodstartdate = "";
string periodenddate = "";
if (ddlperiod.SelectedItem.Text == "Today")
{
periodstartdate = Today.ToString();
periodenddate = Today.ToString();
}
else if (ddlperiod.SelectedItem.Text == "Yesterday")
{
periodstartdate = Yesterday.ToString();
periodenddate = Yesterday.ToString();
// }
//}
}
else if (ddlperiod.SelectedItem.Text == "CurrentWeek")
{
periodstartdate = thisweekstart.ToString();
periodenddate = thisweekend.ToString();
// }
// }
}
else if (ddlperiod.SelectedItem.Text == "LastWeek")
{
periodstartdate = lastweekstartdate.ToString();
periodenddate = Today.ToString();
}
else if (ddlperiod.SelectedItem.Text == "CurrentMonth")
{
periodstartdate = thismonthstart.ToString();
periodenddate = Today.ToString();
// }
// }
}
else if (ddlperiod.SelectedItem.Text == "LastMonth")
{
periodstartdate = lastmonthstartdate.ToString();
periodenddate = lastmonthenddate.ToString();
// }
// }
}
else if (ddlperiod.SelectedItem.Text == "CurrentQuater")
{
periodstartdate = thisquaterstartdate.ToString();
periodenddate = thisquaterenddate.ToString();
//}
// }
}
else if (ddlperiod.SelectedItem.Text == "LastQuater")
{
periodstartdate = lastquaterstartdate.ToString();
periodenddate = lastquaterenddate.ToString();
// }
// }
}
else if (ddlperiod.SelectedItem.Text == "CurrentYear")
{
periodstartdate = thisyearstartdate.ToString();
periodenddate = thisyearenddate.ToString();
}
else if (ddlperiod.SelectedItem.Text == "LastYear")
{
periodstartdate = lastyearstartdate.ToString();
periodenddate = lastyearenddate.ToString();
}
else if (ddlperiod.SelectedItem.Text == "All")
{
periodstartdate = "1/1/1900";
periodenddate = Today.ToString();
}
DateTime sd = Convert.ToDateTime(periodstartdate.ToString());
DateTime ed = Convert.ToDateTime(periodenddate.ToString());
string str = " and dateandtime Between '" + sd.ToShortDateString() + "' AND '" + ed.ToShortDateString() + "'"; // + //2009-4-30' " +
return(str);
}
