protected void taskReport_OnSort(object sender, GridViewSortEventArgs e) { BCCTaskEffort effort = new BCCTaskEffort(); effort.TaskAssignedToUserName = CurrentUser; effort.TaskStatus = null; DateTime startDate = DateTime.Today.Subtract(new TimeSpan(7, 0, 0, 0)); effort.ReportStartDate = startDate; if (DateTime.TryParse(tStartDate.Text, out startDate)) { effort.ReportStartDate = startDate; } DateTime endDate = DateTime.Today; effort.ReportEndDate = endDate; if (DateTime.TryParse(tEndDate.Text, out endDate)) { effort.ReportEndDate = endDate; } DataTable dtTasks = BCCTaskEffort.ReportTaskEfforts(effort); if (dtTasks != null) { DataView dataView = new DataView(dtTasks); dataView.Sort = e.SortExpression + " " + ToggleDirection(); reportView.DataSource = dataView; reportView.DataBind(); reportView.Visible = true; } }
private void FillReport(BCCTaskEffort effort) { DataTable dtTasks = BCCTaskEffort.ReportTaskEfforts(effort); if (dtTasks != null) { reportView.DataSource = dtTasks; reportView.DataBind(); reportView.Visible = true; } }
protected void lnkViewReport_Click(object sender, EventArgs e) { BCCTaskEffort effort = new BCCTaskEffort(); effort.TaskAssignedToUserName = CurrentUser; effort.TaskStatus = null; DateTime startDate = DateTime.Today.Subtract(new TimeSpan(5, 0, 0, 0)); effort.ReportStartDate = startDate; if (DateTime.TryParse(tStartDate.Text, out startDate)) { effort.ReportStartDate = startDate; } DateTime endDate = DateTime.Today; effort.ReportEndDate = endDate; if (DateTime.TryParse(tEndDate.Text, out endDate)) { effort.ReportEndDate = endDate; } FillReport(effort); // Databind charts DataBindChart(); }
protected void taskEffortView_Sorting(object sender, GridViewSortEventArgs e) { BCCTaskEffort effort = new BCCTaskEffort(); effort.ProjectName = projectName; effort.ReportStartDate = reportStartDate; effort.ReportEndDate = reportEndDate; DataTable projectEffort = BCCTaskEffort.ReportProjectEfforts(effort); if (projectEffort != null) { DataView dataView = new DataView(projectEffort); dataView.Sort = e.SortExpression + " " + ToggleDirection(); projectEffortView.DataSource = dataView; projectEffortView.DataBind(); } }
/// <summary> /// BindProjectGrid /// </summary> /// <param name="projectName"></param> /// <param name="reportStartDate"></param> /// <param name="reportEndDate"></param> private void BindProjectGrid(string projectName, DateTime reportStartDate, DateTime reportEndDate) { BCCTaskEffort effort = new BCCTaskEffort(); effort.ProjectName = projectName; effort.ReportStartDate = reportStartDate; effort.ReportEndDate = reportEndDate; headerCaption.Text = string.Format("Project Task Report - ({0})", projectName); DataTable dtTaskEffort = BCCTaskEffort.ReportProjectEfforts(effort); if (dtTaskEffort != null) { projectEffortView.DataSource = dtTaskEffort; projectEffortView.DataBind(); projectEffortView.Visible = true; } }
private void BindTaskEffortGrid(string taskId, string taskName, string projectName) { Guid taskGuid = new Guid(taskId); BCCTaskEffort effort = new BCCTaskEffort(); effort.TaskID = taskGuid; lblTaskEffortCaption.Text = string.Format("Project: {0}, Task: {1}", projectName, taskName); // Retrieves all the effort for a specific task. DataTable dtTaskEffort = BCCTaskEffort.RetrieveAllTaskEfforts(effort); if (dtTaskEffort != null) { taskEffortView.DataSource = dtTaskEffort; taskEffortView.DataBind(); taskEffortView.Visible = true; } }
private void FillTaskEfforts(Guid taskID) { BCCTaskEffort effort = new BCCTaskEffort(); effort.TaskID = taskID; // Get me all the active tasks. DataTable dtTasks = BCCTaskEffort.RetrieveAllTaskEfforts(effort); if (dtTasks != null) { taskEffortView.DataSource = dtTasks; taskEffortView.DataBind(); taskEffortView.Visible = true; } }
protected void taskEffortView_RowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow updatableRow = taskEffortView.Rows[e.RowIndex] as GridViewRow; Guid taskGuid = new Guid(); if (updatableRow != null) { HiddenField htaskID = updatableRow.FindControl("taskID") as HiddenField; HiddenField taskRef = updatableRow.FindControl("taskRef") as HiddenField; TextBox tTaskDate = updatableRow.FindControl("tTaskDate") as TextBox; DropDownList ddlTaskStatus = updatableRow.FindControl("ddlTaskStatus") as DropDownList; TextBox tTaskRemark = updatableRow.FindControl("tTaskRemark") as TextBox; TextBox tTaskHours = updatableRow.FindControl("tTaskHours") as TextBox; if (htaskID != null) { taskGuid = new Guid(htaskID.Value); BCCTaskEffort effort = new BCCTaskEffort(); effort.TaskID = taskGuid; effort.TaskRef = taskRef.Value; effort.TaskAssignedToUserName = HttpContext.Current.User.Identity.Name; DateTime today = DateTime.Today; DateTime.TryParse(tTaskDate.Text, out today); effort.TaskEffortDate = today; effort.TaskStatus = ddlTaskStatus.SelectedValue; effort.TaskRemark = tTaskRemark.Text; double taskEffort = 0; Double.TryParse(tTaskHours.Text, out taskEffort); effort.TaskEffort = taskEffort; BCCTaskEffort.UpdateTaskEffort(effort); } } // Refresh the data taskEffortView.EditIndex = -1; FillTaskEfforts(taskGuid); }
protected void taskEffortView_Sorting(object sender, GridViewSortEventArgs e) { Guid taskGuid = new Guid(taskID); BCCTaskEffort effort = new BCCTaskEffort(); effort.TaskID = taskGuid; DataTable dtTasks = BCCTaskEffort.RetrieveAllTaskEfforts(effort); if (dtTasks != null) { DataView dataView = new DataView(dtTasks); dataView.Sort = e.SortExpression + " " + ToggleDirection(); taskEffortView.DataSource = dataView; taskEffortView.DataBind(); } }
protected void taskEffortView_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.Equals("Add")) { TextBox tNewTaskDate = taskEffortView.FooterRow.FindControl("tNewTaskDate") as TextBox; TextBox tNewTaskHours = taskEffortView.FooterRow.FindControl("tNewTaskHours") as TextBox; DropDownList ddlNewTaskStatus = taskEffortView.FooterRow.FindControl("ddlNewTaskStatus") as DropDownList; TextBox tNewTaskRemark = taskEffortView.FooterRow.FindControl("tNewTaskRemark") as TextBox; Guid taskGuid = new Guid(); if (taskID != null) { taskGuid = new Guid(taskID); } if (taskID != null && tNewTaskDate != null && ddlNewTaskStatus != null && tNewTaskHours != null && tNewTaskRemark != null) { BCCTaskEffort effort = new BCCTaskEffort(); effort.TaskID = taskGuid; effort.TaskAssignedToUserName = HttpContext.Current.User.Identity.Name; DateTime today = DateTime.UtcNow.Date; DateTime.TryParse(tNewTaskDate.Text, out today); effort.TaskEffortDate = today; effort.TaskStatus = ddlNewTaskStatus.SelectedValue; effort.TaskRemark = tNewTaskRemark.Text; double taskEffort = 0; Double.TryParse(tNewTaskHours.Text, out taskEffort); effort.TaskEffort = taskEffort; BCCTaskEffort.CreateTaskEffort(effort); } FillTaskEfforts(taskGuid); } else if (e.CommandName.Equals("AddOnEmpty")) { TextBox tDate = taskEffortView.Controls[0].Controls[0].FindControl("tDate") as TextBox; DropDownList ddlTaskStatus2 = taskEffortView.Controls[0].Controls[0].FindControl("ddlTaskStatus2") as DropDownList; TextBox tRemark = taskEffortView.Controls[0].Controls[0].FindControl("tRemark") as TextBox; TextBox tEffort = taskEffortView.Controls[0].Controls[0].FindControl("tEffort") as TextBox; Guid taskGuid = new Guid(); if (taskID != null) { taskGuid = new Guid(taskID); } if (taskID != null && tDate != null && ddlTaskStatus2 != null && tRemark != null && tEffort != null) { BCCTaskEffort effort = new BCCTaskEffort(); effort.TaskID = taskGuid; effort.TaskAssignedToUserName = HttpContext.Current.User.Identity.Name; DateTime today = DateTime.UtcNow.Date; DateTime.TryParse(tDate.Text, out today); effort.TaskEffortDate = today; effort.TaskStatus = ddlTaskStatus2.SelectedValue; effort.TaskRemark = tRemark.Text; double taskEffort = 0; Double.TryParse(tEffort.Text, out taskEffort); effort.TaskEffort = taskEffort; BCCTaskEffort.CreateTaskEffort(effort); } FillTaskEfforts(taskGuid); } }
protected void taskEffortView_RowDeleting(object sender, GridViewDeleteEventArgs e) { GridViewRow deletedRow = taskEffortView.Rows[e.RowIndex] as GridViewRow; Guid taskGuid = new Guid(); if (deletedRow != null) { HiddenField hGuid = deletedRow.FindControl("taskID") as HiddenField; HiddenField taskRef = deletedRow.FindControl("taskRef") as HiddenField; taskGuid = new Guid(hGuid.Value); BCCTaskEffort taskEffort = new BCCTaskEffort(); taskEffort.TaskID = taskGuid; taskEffort.TaskRef = taskRef.Value; // User trying to delete taskEffort.TaskAssignedToUserName = HttpContext.Current.User.Identity.Name; BCCTaskEffort.RemoveTaskEfforts(taskEffort); } // Refresh the data taskEffortView.EditIndex = -1; FillTaskEfforts(taskGuid); }
private void FindTasksAndNotifyUsers() { // Get all the users - 25 user limit. DataTable userTable = BCCTaskDataAccess.RetrieveAllUsers(ApplicationName, 0, USER_LIMIT); string mailMessage = string.Empty; string mailSubject = string.Empty; // foreach user in the user table. foreach (DataRow dr in userTable.Rows) { BCCTaskEffort effort = new BCCTaskEffort(); effort.TaskAssignedToUserName = dr["userName"] as string; effort.TaskStatus = null; // has to be null to get all the tasks. DataTable taskTable = null; try { // Get the list of tasks for each user taskTable = BCCTaskEffort.ReportTaskEfforts(effort); } catch(Exception exception) { System.Diagnostics.Debug.Write(exception.Message, "TaskNotifier"); } // Dont send emails when there are no tasks. if (taskTable != null && taskTable.Rows != null && taskTable.Rows.Count > 0) { EmailHelper helper = new EmailHelper(EmailConfigSpeedCode); helper.EmailRecipient = dr["email"] as string; WriteToEventLog("Sending email to : " + helper.EmailRecipient); // Form the email message for each task mailMessage = HtmlEmailHelper.FormHTMLContent(taskTable, effort.ReportStartDate, effort.ReportEndDate); mailSubject = "(BCC) - Task Status Report - " + DateTime.UtcNow.Date.ToString("MMM-dd-yyyy"); helper.SendMail(mailSubject, mailMessage, false); } else { System.Diagnostics.Debug.Write("No tasks found for " + effort.TaskAssignedToUserName, "TaskNotifier"); } } }
/// <summary> /// Update /// </summary> /// <param name="taskEffort"></param> public static void UpdateTaskEffort(BCCTaskEffort taskEffort) { using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["authStore"].ConnectionString)) { SqlCommand command = new SqlCommand("[dbo].[bcc_TaskEfforts_Update]", connection); command.CommandType = CommandType.StoredProcedure; SqlParameter param = new SqlParameter("@taskID", taskEffort.TaskID); command.Parameters.Add(param); param = new SqlParameter("@taskRef", taskEffort.TaskRef); command.Parameters.Add(param); param = new SqlParameter("@taskStatus", taskEffort.TaskStatus); command.Parameters.Add(param); param = new SqlParameter("@updatedbyUser", taskEffort.TaskAssignedToUserName); command.Parameters.Add(param); param = new SqlParameter("@taskDate", taskEffort.TaskEffortDate); command.Parameters.Add(param); param = new SqlParameter("@taskEffort", taskEffort.TaskEffort); command.Parameters.Add(param); param = new SqlParameter("@taskRemark", taskEffort.TaskRemark); command.Parameters.Add(param); connection.Open(); command.ExecuteNonQuery(); } }
/// <summary> /// Retrieve All Tasks whatever the case may be. /// </summary> /// <param name="task">BCC Task</param> /// <returns>DataTable</returns> public static DataTable RetrieveAllTaskEfforts(BCCTaskEffort taskEffort) { DataTable dt = null; using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["authStore"].ConnectionString)) { SqlCommand command = new SqlCommand("[dbo].[bcc_TaskEfforts_Efforts]", connection); command.CommandType = CommandType.StoredProcedure; SqlParameter param = new SqlParameter("@taskID", taskEffort.TaskID); command.Parameters.Add(param); connection.Open(); SqlDataReader reader = command.ExecuteReader(); dt = new DataTable(); dt.Load(reader); reader.Close(); } return dt; }
/// <summary> /// Task Effort Report /// </summary> /// <param name="effort"></param> public static DataTable ReportTaskEfforts(BCCTaskEffort effort) { DataTable dt = null; using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["authStore"].ConnectionString)) { SqlCommand command = new SqlCommand("[dbo].[bcc_TaskEfforts_TaskEffortReport]", connection); command.CommandType = CommandType.StoredProcedure; SqlParameter param = new SqlParameter("@assignedToUser", effort.TaskAssignedToUserName); command.Parameters.Add(param); param = new SqlParameter("@reportStartDate", effort.ReportStartDate); command.Parameters.Add(param); param = new SqlParameter("@reportEndDate", effort.ReportEndDate); command.Parameters.Add(param); if (effort.TaskStatus != null) { param = new SqlParameter("@taskStatus", effort.TaskStatus); command.Parameters.Add(param); } else { param = new SqlParameter("@taskStatus", DBNull.Value); command.Parameters.Add(param); } connection.Open(); SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection); dt = new DataTable(); dt.Load(reader); reader.Close(); } return dt; }
/// <summary> /// Task Effort Report /// </summary> /// <param name="effort"></param> public static DataTable ReportProjectEfforts(BCCTaskEffort effort) { DataTable dt = null; using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["authStore"].ConnectionString)) { SqlCommand command = new SqlCommand("[dbo].[bcc_TaskEfforts_ProjectTaskEffort]", connection); command.CommandType = CommandType.StoredProcedure; SqlParameter param = new SqlParameter("@projectName", effort.ProjectName); command.Parameters.Add(param); param = new SqlParameter("@reportStartDate", effort.ReportStartDate); command.Parameters.Add(param); param = new SqlParameter("@reportEndDate", effort.ReportEndDate); command.Parameters.Add(param); connection.Open(); SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection); dt = new DataTable(); dt.Load(reader); reader.Close(); } return dt; }