public void Should_fail_with_descriptive_message_when_asserting_datetime_is_on_or_before_earlier_datetime()
{
DateTimeOffsetAssertions assertions = Today.Should();
assertions.Invoking(x => x.BeOnOrBefore(Yesterday, "because we want to test the failure {0}", "message"))
.ShouldThrow <AssertFailedException>()
.WithMessage(string.Format(
"Expected a date and time on or before <{0}> because we want to test the failure message, but found <{1}>.",
Yesterday.ToString("yyyy-MM-dd"), Today.ToString("yyyy-MM-dd")));
}
public override int GetHashCode()
{
var hashCode = 480274905;
hashCode = hashCode * -1521134295 + TodayInt.GetHashCode();
hashCode = hashCode * -1521134295 + Yesterday.GetHashCode();
hashCode = hashCode * -1521134295 + TwoDaysAgo.GetHashCode();
hashCode = hashCode * -1521134295 + ThreeDaysAgo.GetHashCode();
return(hashCode);
}
private static void Assign(DateTime[] dates, Dictionary <string, List <Activity> > output)
{
ActivitiesDict = output;
Pages[0] = new DailyPage();
Pages[1] = new WeeklyPage();
Pages[2] = new MonthlyPage();
Pages[3] = new TotalPage();
Pages[4] = dates == null ? new SettingsPage() : new SettingsPage(dates[0], dates[1]);
Pages[5] = new Yesterday();
Pages[6] = dates == null ? new CustomPage() : new CustomPage(dates[0], dates[1]);
}
public static void Load(bool isConvertingTime = false)
{
if (isConvertingTime && savedDates != null)
{
Pages[0] = new DailyPage();
Pages[1] = new WeeklyPage();
Pages[2] = new MonthlyPage();
Pages[3] = new TotalPage();
Pages[5] = new Yesterday();
Pages[6] = savedDates == null ? new CustomPage() : new CustomPage(savedDates[0], savedDates[1]);
return;
}
var output = ReadJson();
DateTime[] dates = GetSavedDates();
savedDates = dates;
// Checking if json could be read
if (output is int)
{
if (output == 0)
{
// ShowPopUp("Json could not be found.\nTry Starting the ActivityLogger first.\nTip: Keep in mind the Program" +
// "\nwill only show programs\n" +
// "with more than 5 min of use.", GetDirectory() + @"\TMRosemite\ActivityLogger");
Assign(dates, new Dictionary <string, List <Activity> >());
return;
}
if (output == 1)
{
ShowPopUp("The Json seems to be corrupted.\nYou can Remove the current Json the Solve this issue", GetDirectory() + @"\TMRosemite\ActivityLogger");
return;
}
}
if (output.Count == 0)
{
ShowPopUp("no logs found.\n\nTip: Keep in mind the Program\nwill only show programs\n" +
"with more than 5 min of use.");
return;
}
Assign(dates, output);
}
private static void YesterdayPropertyChangedCallback(DependencyObject d, DependencyPropertyChangedEventArgs e)
{
WeatherItemView weatherItemView = d as WeatherItemView;
Yesterday Yesterday = e.NewValue as Yesterday;
if (Yesterday == null)
{
return;
}
weatherItemView.txtBlkDate.Text = Yesterday.ymd;
weatherItemView.txtBlkweek.Text = Yesterday.week;
weatherItemView.LabRiChu.Content = Yesterday.sunrise;
weatherItemView.LabRiLuo.Content = Yesterday.sunset;
weatherItemView.txtBlkWeatherType.Text = Yesterday.type;
weatherItemView.labZuiGao.Content = Yesterday.high;
weatherItemView.labZuiDi.Content = Yesterday.low;
weatherItemView.LabFengXiang.Content = Yesterday.fx;
weatherItemView.LabFengLi.Content = Yesterday.fl;
ChangeImage(weatherItemView, Yesterday.type);
}
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);
}
}
public void Yesterday_Time_can_be_specified_with_At()
{
Assert.That(Yesterday.At(14), Is.EqualTo(7.May(2011).At(14)));
Assert.That(Yesterday.At(14, 30), Is.EqualTo(7.May(2011).At(14, 30)));
Assert.That(Yesterday.At(14, 30, 26), Is.EqualTo(7.May(2011).At(14, 30, 26)));
}
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);
}
