Exemplo n.º 1
0
    public static DateRange getLastDates(string type, string fromdate, string todate)
    {
        DateTime date1 = new DateTime(), date2 = new DateTime();

        var       today        = Convert.ToDateTime(GeneralMethod.getdatetime());
        DayOfWeek weekStart    = DayOfWeek.Monday; // or Sunday, or whenever
        DateTime  startingDate = today;
        var       month        = new DateTime(today.Year, today.Month, 1);
        string    str          = "";

        switch (type)
        {
        case "Custom":
            date1 = Convert.ToDateTime(fromdate);
            date2 = Convert.ToDateTime(todate);
            str   = "Report From " + date1.ToString("MM/dd/yyyy") + " To " + date2.ToString("MM/dd/yyyy");
            break;

        case "Quarterly":
            int quarterNumber = (today.Month - 1) / 3 + 1;
            date1 = new DateTime(today.Year, (quarterNumber - 1) * 3 + 1, 1);
            date2 = date1.AddMonths(3).AddDays(-1);
            str   = "Quarterly Report (From " + date1.ToString("MM/dd/yyyy") + " To " + date2.ToString("MM/dd/yyyy") + ")";
            break;

        case "Monthly":

            date1 = month.AddMonths(-1);
            date2 = month.AddDays(-1);
            str   = "Monthly Report (From " + date1.ToString("MM/dd/yyyy") + " To " + date2.ToString("MM/dd/yyyy") + ")";
            break;

        case "Weekly":
            while (startingDate.DayOfWeek != weekStart)
            {
                startingDate = startingDate.AddDays(-1);
            }

            date1 = startingDate.AddDays(-7);
            date2 = startingDate.AddDays(-1);
            str   = "Weekly Report (From " + date1.ToString("MM/dd/yyyy") + " To " + date2.ToString("MM/dd/yyyy") + ")";
            break;

        case "Biweekly":

            while (startingDate.DayOfWeek != weekStart)
            {
                startingDate = startingDate.AddDays(-1);
            }

            date1 = startingDate.AddDays(-14);
            date2 = startingDate.AddDays(-1);
            str   = "Biweekly Report (From " + date1.ToString("MM/dd/yyyy") + " To " + date2.ToString("MM/dd/yyyy") + ")";
            break;

        case "Current Month":
            date1 = new DateTime(today.Year, today.Month, 1);
            date2 = date1.AddMonths(1).AddDays(-1);
            str   = "Current Month Report (From " + date1.ToString("MM/dd/yyyy") + " To " + date2.ToString("MM/dd/yyyy") + ")";
            break;

        case "Next Month":
            date1 = new DateTime(today.AddMonths(1).Year, today.AddMonths(1).Month, 1);
            date2 = date1.AddMonths(1).AddDays(-1);
            str   = "Next Month Report (From " + date1.ToString("MM/dd/yyyy") + " To " + date2.ToString("MM/dd/yyyy") + ")";
            break;

        case "Current Week":

            date1 = today.AddDays(-(int)today.DayOfWeek);
            date2 = date1.AddDays(7).AddSeconds(-1);
            str   = "Current Week Report (From " + date1.ToString("MM/dd/yyyy") + " To " + date2.ToString("MM/dd/yyyy") + ")";
            break;

        case "Next Week":

            date1 = today.AddDays(7);
            date1 = date1.AddDays(-(int)date1.DayOfWeek);
            date2 = date1.AddDays(7).AddSeconds(-1);
            str   = "Next Week Report (From " + date1.ToString("MM/dd/yyyy") + " To " + date2.ToString("MM/dd/yyyy") + ")";
            break;

        case "Today":


            date1 = today;
            date2 = today;
            str   = "Report From " + date1.ToString("MM/dd/yyyy") + " To " + date2.ToString("MM/dd/yyyy") + "";
            break;

        case "All":
            date1 = Convert.ToDateTime("01/01/1970");
            //date2 = today.AddYears(2);
            date2 = today;
            str   = "Report Date: All";
            break;

        case "AsOf":
            date1 = Convert.ToDateTime("01/01/1970");
            date2 = Convert.ToDateTime(todate);
            str   = "Report As of " + date2.ToString("MM/dd/yyyy");
            break;

        case "AsOfLastMonth":
            date1 = Convert.ToDateTime("01/01/1970");
            date2 = month.AddDays(-1);
            str   = "Report As of  Last Month (" + date2.ToString("MM/dd/yyyy") + ")";
            break;

        case "AsOfLastYear":
            date1 = Convert.ToDateTime("01/01/1970");
            date2 = Convert.ToDateTime("12/31/" + (today.Year - 1).ToString() + "");
            str   = "Report As of  Last Year (" + date2.ToString("MM/dd/yyyy") + ")";
            break;

        case "ThisWeektoDate":
            date1 = today.AddDays(-(int)today.DayOfWeek);
            date2 = today;
            str   = "This Week to Date Report (From " + date1.ToString("MM/dd/yyyy") + " To " + date2.ToString("MM/dd/yyyy") + ")";
            break;

        case "ThisMonthtoDate":
            date1 = new DateTime(today.Year, today.Month, 1);
            date2 = today;
            str   = "This Month to Date Report (From " + date1.ToString("MM/dd/yyyy") + " To " + date2.ToString("MM/dd/yyyy") + ")";
            break;

        case "ThisYeartoDate":
            date1 = Convert.ToDateTime("01/01/" + (today.Year).ToString() + "");
            date2 = today;
            str   = "This Year to Date Report (From " + date1.ToString("MM/dd/yyyy") + " To " + date2.ToString("MM/dd/yyyy") + ")";
            break;

        case "LastYeartoDate":
            date1 = Convert.ToDateTime("01/01/" + (today.Year - 1).ToString() + "");
            date2 = today;
            str   = "This Year to Date Report (From " + date1.ToString("MM/dd/yyyy") + " To " + date2.ToString("MM/dd/yyyy") + ")";
            break;

        case "This Calendar Year":
            date1 = Convert.ToDateTime("01/01/" + (today.Year).ToString() + "");
            date2 = Convert.ToDateTime("12/31/" + (today.Year).ToString() + "");;
            str   = "This Year Report (From " + date1.ToString("MM/dd/yyyy") + " To " + date2.ToString("MM/dd/yyyy") + ")";
            break;

        case "Last Calendar Year":
            date1 = Convert.ToDateTime("01/01/" + (today.Year - 1).ToString() + "");
            date2 = Convert.ToDateTime("12/31/" + (today.Year - 1).ToString() + "");;
            str   = "Last Year Report (From " + date1.ToString("MM/dd/yyyy") + " To " + date2.ToString("MM/dd/yyyy") + ")";
            break;
        }

        var result = new DateRange
        {
            fromdate = date1.ToString("MM/dd/yyyy"),
            todate   = date2.ToString("MM/dd/yyyy"),
            datetext = str
        };

        return(result);
    }
Exemplo n.º 2
0
    public static DateRange getLastDates(string type)
    {
        DateTime date1 = new DateTime(), date2 = new DateTime();

        var       today        = Convert.ToDateTime(GeneralMethod.getdatetime());
        DayOfWeek weekStart    = DayOfWeek.Monday; // or Sunday, or whenever
        DateTime  startingDate = today;


        switch (type)
        {
        case "Quarterly":
            int quarterNumber = (today.Month - 1) / 3 + 1;
            date1 = new DateTime(today.Year, (quarterNumber - 1) * 3 + 1, 1);
            date2 = date1.AddMonths(3).AddDays(-1);
            break;

        case "Monthly":
            var month = new DateTime(today.Year, today.Month, 1);
            date1 = month.AddMonths(-1);
            date2 = month.AddDays(-1);
            break;

        case "Weekly":

            while (startingDate.DayOfWeek != weekStart)
            {
                startingDate = startingDate.AddDays(-1);
            }

            date1 = startingDate.AddDays(-7);
            date2 = startingDate.AddDays(-1);
            break;

        case "Biweekly":

            while (startingDate.DayOfWeek != weekStart)
            {
                startingDate = startingDate.AddDays(-1);
            }

            date1 = startingDate.AddDays(-14);
            date2 = startingDate.AddDays(-1);
            break;

        case "Current Month":

            date1 = new DateTime(today.Year, today.Month, 1);
            date2 = date1.AddMonths(1).AddDays(-1);
            break;

        case "Next Month":
            date1 = new DateTime(today.AddMonths(1).Year, today.AddMonths(1).Month, 1);
            date2 = date1.AddMonths(1).AddDays(-1);
            break;

        case "Current Week":

            date1 = today.AddDays(-(int)today.DayOfWeek);
            date2 = date1.AddDays(7).AddSeconds(-1);
            break;

        case "Next Week":

            date1 = today.AddDays(7);
            date1 = date1.AddDays(-(int)date1.DayOfWeek);
            date2 = date1.AddDays(7).AddSeconds(-1);
            break;
        }

        var result = new DateRange
        {
            fromdate = date1.ToString("MM/dd/yyyy"),
            todate   = date2.ToString("MM/dd/yyyy")
        };

        return(result);
    }