protected void DisplayTaskByDate(DateTime start, DateTime end) { TasksBLL tasks = new TasksBLL(); //TimeKeeper.TasksDataTable task = tasks.GetTasksByUserIDByDateRange((int)Session["userID"], start, end); TasksDataSource.SelectParameters.Clear(); TasksDataSource.SelectMethod = "GetTasksByUserIDByDateRange"; TasksDataSource.SelectParameters.Add(new Parameter("userID", TypeCode.String, Session["userID"].ToString())); TasksDataSource.SelectParameters.Add(new Parameter("start", TypeCode.DateTime, start.ToString())); TasksDataSource.SelectParameters.Add(new Parameter("end", TypeCode.DateTime, end.ToString())); decimal TotalTime = tasks.TotalTimeByUserIDByDateRange((int)Session["userID"], start, end); //TasksGridView.DataBind(); if (start == end) { StatsLabel.Text = "You worked " + TotalTime + " hrs on " + start.ToShortDateString(); } else { StatsLabel.Text = "You worked " + TotalTime + " hrs between " + start.ToShortDateString() + " and " + end.ToShortDateString(); } //ViewHelper("PickDay"); }
protected void DisplayTaskByDate(DateTime start, DateTime end) { Decimal TotalTime = 0; if (DirectReportsDropDown.SelectedValue == "AllUsers") { int userID = (int)Session["userID"]; UsersBLL users = new UsersBLL(); TimeKeeper.UsersDataTable usersDT = users.GetUsersByDirectReportsOf(userID); TasksBLL tasks = new TasksBLL(); TimeKeeper.TasksDataTable directReportTasks = tasks.GetTasksByUserIDByDateRange(0, start, end); foreach (DataRow user in usersDT.Rows) { int directReportUserID = Convert.ToInt32(user["userID"]); TimeKeeper.TasksDataTable task = tasks.GetTasksByUserIDByDateRange(directReportUserID, start, end); directReportTasks.Merge(task); TotalTime += tasks.TotalTimeByUserIDByDateRange(directReportUserID, start, end); } ByUserGridView.DataSource = directReportTasks; ByUserGridView.DataBind(); Output.Text = "Your employees have worked "; } else { TasksBLL tasks = new TasksBLL(); TimeKeeper.TasksDataTable directReportTasks = tasks.GetTasksByUserIDByDateRange(Convert.ToInt32(DirectReportsDropDown.SelectedValue), start, end); TotalTime = tasks.TotalTimeByUserIDByDateRange(Convert.ToInt32(DirectReportsDropDown.SelectedValue), start, end); ByUserGridView.DataSource = directReportTasks; ByUserGridView.DataBind(); Output.Text = "The employee has worked "; } if (start == end) { Output.Text += TotalTime + " hrs on " + start.ToShortDateString(); } else { Output.Text += TotalTime + " hrs between " + start.ToShortDateString() + " and " + end.ToShortDateString(); } }
protected void AllTasksLB_Click(object sender, EventArgs e) { int userID = (int)Session["userID"]; TasksBLL tasks = new TasksBLL(); TimeKeeper.TasksDataTable task = tasks.GetTasksByUserID(userID); decimal TotalTime = tasks.TotalTimeByUserIDByDateRange(userID, DateTime.Today.AddDays(-1000), DateTime.Today); ByUserGridView.DataSource = task; ByUserGridView.DataBind(); Output.Text = "You have worked " + TotalTime + " hrs since using TimeKeeper."; MainMultiView.ActiveViewIndex = 0; }
protected void DisplayTaskByDate(DateTime start, DateTime end) { TasksBLL tasks = new TasksBLL(); TimeKeeper.TasksDataTable task = tasks.GetTasksByUserIDByDateRange((int)Session["userID"], start, end); decimal TotalTime = tasks.TotalTimeByUserIDByDateRange((int)Session["userID"], start, end); ByUserGridView.DataSource = task; ByUserGridView.DataBind(); if (start == end) Output.Text = "You worked " + TotalTime + " hrs on " + start.ToShortDateString(); else Output.Text = "You worked " + TotalTime + " hrs between " + start.ToShortDateString() + " and " + end.ToShortDateString(); MainMultiView.ActiveViewIndex = 0; }
protected void AllTasksLB_Click(object sender, EventArgs e) { Decimal TotalTime = 0; int userID = (int)Session["userID"]; if (DirectReportsDropDown.SelectedValue == "AllUsers") { UsersBLL users = new UsersBLL(); TimeKeeper.UsersDataTable usersDT = users.GetUsersByDirectReportsOf(userID); TasksBLL tasks = new TasksBLL(); TimeKeeper.TasksDataTable directReportTasks = tasks.GetTasksByUserID(0); foreach (DataRow user in usersDT.Rows) { int directReportUserID = Convert.ToInt32(user["userID"]); TimeKeeper.TasksDataTable task = tasks.GetTasksByUserID(directReportUserID); directReportTasks.Merge(task); TotalTime += tasks.TotalTimeByUserIDByDateRange(directReportUserID, DateTime.Today.AddDays(-1000), DateTime.Today); } ByUserGridView.DataSource = directReportTasks; ByUserGridView.DataBind(); Output.Text = "Your employees have worked " + TotalTime + " hrs since using TimeKeeper."; } else { TasksBLL tasks = new TasksBLL(); TimeKeeper.TasksDataTable directReportTasks = tasks.GetTasksByUserID(Convert.ToInt32(DirectReportsDropDown.SelectedValue)); TotalTime = tasks.TotalTimeByUserIDByDateRange(Convert.ToInt32(DirectReportsDropDown.SelectedValue), DateTime.Today.AddDays(-1000), DateTime.Today); ByUserGridView.DataSource = directReportTasks; ByUserGridView.DataBind(); Output.Text = "The employee has worked " + TotalTime + " hrs since using TimeKeeper."; } }
protected void DisplayTaskByDate(DateTime start, DateTime end) { TasksBLL tasks = new TasksBLL(); TimeKeeper.TasksDataTable task = tasks.GetTasksByUserIDByDateRange((int)Session["userID"], start, end); decimal TotalTime = tasks.TotalTimeByUserIDByDateRange((int)Session["userID"], start, end); ByUserGridView.DataSource = task; ByUserGridView.DataBind(); if (start == end) { Output.Text = "You worked " + TotalTime + " hrs on " + start.ToShortDateString(); } else { Output.Text = "You worked " + TotalTime + " hrs between " + start.ToShortDateString() + " and " + end.ToShortDateString(); } MainMultiView.ActiveViewIndex = 0; }
protected void DisplayTaskByDate(DateTime start, DateTime end) { Decimal TotalTime = 0; if (DirectReportsDropDown.SelectedValue == "AllUsers") { int userID = (int)Session["userID"]; UsersBLL users = new UsersBLL(); TimeKeeper.UsersDataTable usersDT = users.GetUsersByDirectReportsOf(userID); TasksBLL tasks = new TasksBLL(); TimeKeeper.TasksDataTable directReportTasks = tasks.GetTasksByUserIDByDateRange(0, start, end); foreach (DataRow user in usersDT.Rows) { int directReportUserID = Convert.ToInt32(user["userID"]); TimeKeeper.TasksDataTable task = tasks.GetTasksByUserIDByDateRange(directReportUserID, start, end); directReportTasks.Merge(task); TotalTime += tasks.TotalTimeByUserIDByDateRange(directReportUserID, start, end); } ByUserGridView.DataSource = directReportTasks; ByUserGridView.DataBind(); Output.Text = "Your employees have worked "; } else { TasksBLL tasks = new TasksBLL(); TimeKeeper.TasksDataTable directReportTasks = tasks.GetTasksByUserIDByDateRange(Convert.ToInt32(DirectReportsDropDown.SelectedValue), start, end); TotalTime = tasks.TotalTimeByUserIDByDateRange(Convert.ToInt32(DirectReportsDropDown.SelectedValue), start, end); ByUserGridView.DataSource = directReportTasks; ByUserGridView.DataBind(); Output.Text = "The employee has worked "; } if (start == end) Output.Text += TotalTime + " hrs on " + start.ToShortDateString(); else Output.Text += TotalTime + " hrs between " + start.ToShortDateString() + " and " + end.ToShortDateString(); }