protected void Page_Load(object sender, EventArgs e) { string Month = DateTime.Now.AddMonths(-1).ToString("MM"); string Year = DateTime.Now.ToString("yyyy"); string currentMonth = Year + "-" + Month; string Month_word = DateTime.Now.AddMonths(-1).ToString("MMMM"); string date = DateTime.Now.StartOfWeek(DayOfWeek.Monday).ToString("yyyy-MM-dd h:mm tt"); string dateEnd = DateTime.Now.EndOfWeek(DayOfWeek.Monday).ToString("yyyy-MM-dd h:mm tt"); BugClass bc = new BugClass(); DataTable reportw = bc.countReportedWeekly(); DataTable reportm = bc.countReportedMonthly(); DataTable resolvew = bc.countResolvedWeekly(); DataTable resolvem = bc.countResolvedMonthly(); DataTable commentw = bc.countComments(); MySqlCommand reporter = bc.mostBugsReported(); MySqlCommand dev = bc.mostBugsFixed(); NumOfBugsReportedWeekly.Text = "Number of bugs reported last week: " + reportw.Rows.Count.ToString() + " [" + date + " TO " + dateEnd + "]"; NumOfBugsReportedMonthly.Text = "Number of bugs reported in " + Month_word + ": " + reportm.Rows.Count.ToString(); NumOfBugsFixedWeekly.Text = "Number of bugs fixed last week: " + resolvew.Rows.Count.ToString() + " [" + date + " TO " + dateEnd + "]";; NumOfBugsFixedMonthly.Text = "Number of bugs fixed in " + Month_word + ": " + resolvem.Rows.Count.ToString(); NumOfComments.Text = "Number of Comments last week: " + commentw.Rows.Count.ToString() + " [" + date + " TO " + dateEnd + "]"; BestReporter.Text = "Best performing Reporter in " + Month_word + ": " + reporter.ExecuteScalar().ToString(); BestDeveloper.Text = "Best performing Developer in " + Month_word + ": " + dev.ExecuteScalar().ToString(); }