protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
UsersBLL users = new UsersBLL();
TimeKeeper.UsersDataTable user = users.GetUserByAccountName(User.Identity.Name);
TimeKeeper.UsersRow row = user[0];
AccountNameTextBox.Text = row.AccountName.ToString();
DisplayNameTextBox.Text = row.DisplayName.ToString();
EmailTextBox.Text = row.Email.ToString();
}
}
protected void ReportCalendar_DayRender(object sender, DayRenderEventArgs e)
{
TasksBLL tasks = new TasksBLL();
TimeKeeper.TasksDataTable directReportTasks = tasks.GetTasksByUserID(0);
if (DirectReportsDropDown.SelectedValue == "AllUsers")
{
int userID = (int)Session["userID"];
UsersBLL users = new UsersBLL();
TimeKeeper.UsersDataTable usersDT = users.GetUsersByDirectReportsOf(userID);
foreach (DataRow user in usersDT.Rows)
{
int directReportUserID = Convert.ToInt32(user["userID"]);
TimeKeeper.TasksDataTable task = tasks.GetTasksByUserIDByDateRange(directReportUserID, e.Day.Date, e.Day.Date);
directReportTasks.Merge(task);
}
}
else
{
directReportTasks = tasks.GetTasksByUserIDByDateRange(Convert.ToInt32(DirectReportsDropDown.SelectedValue), e.Day.Date, e.Day.Date);
}
// If the month is CurrentMonth
if (!e.Day.IsOtherMonth)
{
foreach (DataRow dr in directReportTasks)
{
if ((dr["Date"].ToString() != DBNull.Value.ToString()))
{
DateTime dtEvent = (DateTime)dr["Date"];
if (dtEvent.Equals(e.Day.Date))
{
System.Web.UI.WebControls.Image image;
image = new System.Web.UI.WebControls.Image();
image.ImageUrl = "images/green_diamond.gif";
e.Cell.Controls.Add(image);
}
}
//just want the first row...THIS IS VERY UGLY!
return;
}
}
//If the month is not CurrentMonth then hide the Dates
else
{
e.Cell.Text = "";
}
}
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)
{
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.";
}
}
public bool AddUser(string accountName, string displayName, string email, int defaultView, string role, bool active, int managerID, int sectionID)
{
//Create a new UserRow instance
TimeKeeper.UsersDataTable users = new TimeKeeper.UsersDataTable();
TimeKeeper.UsersRow user = users.NewUsersRow();
user.AccountName = accountName;
user.DisplayName = displayName;
user.Email = email;
user.DefaultView = defaultView;
user.Role = role;
user.Active = active;
user.ManagerID = managerID;
user.SectionID = sectionID;
//Add the new user
users.AddUsersRow(user);
int rowsAffected = Adaptor.Update(users);
//Return true if precisely one row was inserted, otherwise false
return rowsAffected == 1;
}
public bool AddUser(string accountName, string displayName, string email, int defaultView, string role, bool active, int managerID, int sectionID)
{
//Create a new UserRow instance
TimeKeeper.UsersDataTable users = new TimeKeeper.UsersDataTable();
TimeKeeper.UsersRow user = users.NewUsersRow();
user.AccountName = accountName;
user.DisplayName = displayName;
user.Email = email;
user.DefaultView = defaultView;
user.Role = role;
user.Active = active;
user.ManagerID = managerID;
user.SectionID = sectionID;
//Add the new user
users.AddUsersRow(user);
int rowsAffected = Adaptor.Update(users);
//Return true if precisely one row was inserted, otherwise false
return(rowsAffected == 1);
}
public bool UpdateUser(string accountName, string displayName, string email, int defaultView, string role, bool active, int managerID, int sectionID, int userID)
{
TimeKeeper.UsersDataTable users = Adaptor.GetUserByUserID(userID);
if (users.Count == 0)
{
return(false);
}
TimeKeeper.UsersRow user = users[0];
user.AccountName = accountName;
user.DisplayName = displayName;
user.Email = email;
user.DefaultView = defaultView;
user.Role = role;
user.Active = active;
user.ManagerID = managerID;
user.SectionID = sectionID;
int rowsAffected = Adaptor.Update(user);
//Return true if precisely one row was inserted, otherwise false
return(rowsAffected == 1);
}
