private void BindGrid() { objfun.FillGridView(GridView1, "select empName+' '+lastName as Name,empCode,empType,dob from Employee_Master"); DropDownCheckBoxes ddlName = (DropDownCheckBoxes)GridView1.HeaderRow.FindControl("ddlname"); objfun.FillDropdownCheckboxIndex(ddlName, "Name", "empId", "select empName as Name,empId from Employee_Master ", "empName"); }
protected void gvOpportunityAdmin_OnRowDataBound(object sender, GridViewRowEventArgs e) { CourseSection cs = new CourseSection(); if (e.Row.RowType == DataControlRowType.DataRow) { Label lblStatus = ((Label)e.Row.FindControl("lblStatus")); Label lblOppId = ((Label)e.Row.FindControl("lblOppId")); string status = lblStatus.Text.Trim(); if (status == "Pending") { lblStatus.ForeColor = System.Drawing.Color.Red; } DropDownCheckBoxes ddckAddCourseSections = ((DropDownCheckBoxes)e.Row.FindControl("ddckAddCourseSections")); ddckAddCourseSections.DataSource = cs.GetUnAssignedCourseSection(Convert.ToInt32(lblOppId.Text)); ddckAddCourseSections.DataTextField = "CourseSectionDisplayName"; ddckAddCourseSections.DataValueField = "SectionID"; ddckAddCourseSections.DataBind(); DropDownCheckBoxes ddckRemoveCourseSections = ((DropDownCheckBoxes)e.Row.FindControl("ddckRemoveCourseSections")); ddckRemoveCourseSections.DataSource = cs.GetAssignedCourseSection(Convert.ToInt32(lblOppId.Text)); ddckRemoveCourseSections.DataTextField = "CourseSectionDisplayName"; ddckRemoveCourseSections.DataValueField = "SectionID"; ddckRemoveCourseSections.DataBind(); } }
private void SetTaskAssignedUsers(String strAssignedUser, DropDownCheckBoxes taskUsers) { String firstAssignedUser = String.Empty; String[] users = strAssignedUser.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); foreach (string user in users) { ListItem item = taskUsers.Items.FindByText(user); if (item != null) { item.Selected = true; if (string.IsNullOrEmpty(firstAssignedUser)) { firstAssignedUser = item.Text; } } } if (!String.IsNullOrEmpty(firstAssignedUser)) { taskUsers.Texts.SelectBoxCaption = firstAssignedUser; } }
public void LoadDropDownCheckBoxes(DropDownCheckBoxes ddl, DataTable dt, string valueField, string textField, string blankField) { try { if (dt != null && dt.Rows.Count > 0) { ddl.DataTextField = textField; ddl.DataValueField = valueField; ddl.DataSource = dt; ddl.DataBind(); //ddl.Items.Insert(0, new ListItem("--" + blankField + "--", "")); } else { ddl.Items.Clear(); //ddl.Items.Insert(0, new ListItem("...No Data Found...", "")); } } catch (Exception ex) { ddl.Items.Clear(); //ddl.Items.Add(new ListItem("--" + blankField + "--", "0")); //ddlProduct.Enabled = false; } }
protected void searchbox_TextChanged(object sender, System.EventArgs e) { TextBox searchbox = (TextBox)GridView1.HeaderRow.FindControl("searchbox"); string searchtext = searchbox.Text; string sql = "select empName+' '+lastName as Name,empCode,empType,dob from Employee_Master where empName like '" + searchtext + "%' or empName like '%" + searchtext + "%' or empName like '%" + searchtext + "' order by empName"; objfun.FillGridView(GridView1, sql); DropDownCheckBoxes ddlName1 = (DropDownCheckBoxes)GridView1.HeaderRow.FindControl("ddlname"); objfun.FillDropdownCheckboxIndex(ddlName1, "Name", "Name", sql, "empName"); }
/// <summary> /// Save user's to whom task is assigned. /// </summary> private void SaveAssignedTaskUsers(DropDownCheckBoxes ddcbAssigned, JGConstant.TaskStatus objTaskStatus) { //if task id is available to save its note and attachement. if (hdnTaskId.Value != "0") { string strUsersIds = string.Empty; foreach (ListItem item in ddcbAssigned.Items) { if (item.Selected) { strUsersIds = strUsersIds + (item.Value + ","); } } // removes any extra comma "," from the end of the string. strUsersIds = strUsersIds.TrimEnd(','); // save (insert / delete) assigned users. bool isSuccessful = TaskGeneratorBLL.Instance.SaveTaskAssignedUsers(Convert.ToUInt64(hdnTaskId.Value), strUsersIds); // send email to selected users. if (strUsersIds.Length > 0) { if (isSuccessful) { // Change task status to assigned = 3. if (objTaskStatus == JGConstant.TaskStatus.Open || objTaskStatus == JGConstant.TaskStatus.Requested || objTaskStatus == JGConstant.TaskStatus.SpecsInProgress) { UpdateTaskStatus(Convert.ToInt32(hdnTaskId.Value), Convert.ToUInt16(JGConstant.TaskStatus.Assigned)); } SendEmailToAssignedUsers(Convert.ToInt32(hdnTaskId.Value), strUsersIds); } } // send email to all users of the department as task is assigned to designation, but not to any specific user. else { string strUserIDs = ""; foreach (ListItem item in ddcbAssigned.Items) { strUserIDs += string.Concat(item.Value, ","); } SendEmailToAssignedUsers(Convert.ToInt32(hdnTaskId.Value), strUserIDs.TrimEnd(',')); } } }
protected void gvTasks_ddlStatus_SelectedIndexChanged(object sender, EventArgs e) { DropDownList ddlStatus = sender as DropDownList; GridViewRow objGridViewRow = (GridViewRow)ddlStatus.NamingContainer; HiddenField hdnTaskId = (HiddenField)objGridViewRow.FindControl("hdnTaskId"); DropDownCheckBoxes ddcbAssigned = objGridViewRow.FindControl("ddcbAssignedUser") as DropDownCheckBoxes; if (ValidateTaskStatus(ddlTaskStatus, ddcbAssigned, Convert.ToInt32(hdnTaskId.Value))) { Task objTask = new Task(); objTask.TaskId = Convert.ToInt32(hdnTaskId.Value.ToString()); objTask.Status = Convert.ToByte(ddlStatus.SelectedItem.Value); TaskGeneratorBLL.Instance.UpdateTaskStatus(objTask); } SearchTasks(); }
private bool ValidateTaskStatus(DropDownList ddlTaskStatus, DropDownCheckBoxes ddlAssignedUser, Int32 intTaskId) { bool blResult = true; string strStatus = string.Empty; string strMessage = string.Empty; if (this.IsAdminMode) { strStatus = ddlTaskStatus.SelectedValue; //if ( // strStatus != Convert.ToByte(JGConstant.TaskStatus.SpecsInProgress).ToString() && // !TaskGeneratorBLL.Instance.IsTaskWorkSpecificationApproved(intTaskId) // ) //{ // blResult = false; // strMessage = "Task work specifications must be approved, to change status from Specs In Progress."; //} //else // if task is in assigned status. it should have assigned user selected there in dropdown. if (strStatus == Convert.ToByte(JGConstant.TaskStatus.Assigned).ToString()) { blResult = false; strMessage = "Task must be assigned to one or more users, to change status to assigned."; foreach (ListItem objItem in ddlAssignedUser.Items) { if (objItem.Selected) { blResult = true; break; } } } if (!blResult) { CommonFunction.ShowAlertFromUpdatePanel(this.Page, strMessage); } } return(blResult); }
protected void gvTasks_ddcbAssignedUser_SelectedIndexChanged(object sender, EventArgs e) { DropDownCheckBoxes ddcbAssigned = sender as DropDownCheckBoxes; GridViewRow objGridViewRow = (GridViewRow)ddcbAssigned.NamingContainer; hdnTaskId.Value = ((HiddenField)objGridViewRow.FindControl("hdnTaskId")).Value; DropDownList ddlTaskStatus = objGridViewRow.FindControl("ddlStatus") as DropDownList; if (!string.IsNullOrEmpty(hdnTaskId.Value)) { if (ValidateTaskStatus(ddlTaskStatus, ddcbAssigned, Convert.ToInt32(hdnTaskId.Value))) { SaveAssignedTaskUsers(ddcbAssigned, (JGConstant.TaskStatus)Convert.ToByte(ddlTaskStatus.SelectedValue)); } } hdnTaskId.Value = "0"; SearchTasks(); }
//protected void OnPaging(object sender, GridViewPageEventArgs e) //{ // GridView1.PageIndex = e.NewPageIndex; // this.BindGrid(); //} protected void ddlname_SelectedIndexChanged(object sender, System.EventArgs e) { DropDownCheckBoxes ddlName = (DropDownCheckBoxes)GridView1.HeaderRow.FindControl("ddlname"); string x = ddlName.SelectedValue; for (int i = 2; i < ddlName.Items.Count; i++) { if (ddlName.Items[i].Selected == true) { if (selectedname == "") { selectedname = ddlName.Items[i].Value; } else { selectedname = selectedname + ',' + ddlName.Items[i].Value; } } } if (ddlName.SelectedIndex == 0 && selectedname == "") { objfun.FillGridView(GridView1, "select empName+' '+lastName as Name,empCode,empType,dob from Employee_Master order by empName"); } if (ddlName.SelectedIndex == 1 && selectedname == "") { objfun.FillGridView(GridView1, "select empName+' '+lastName as Name,empCode,empType,dob from Employee_Master order by empName desc"); } if ((ddlName.SelectedIndex != 0 && ddlName.SelectedIndex != 1) && selectedname != "") { objfun.FillGridView(GridView1, "select empName+' '+lastName as Name,empCode,empType,dob from Employee_Master where empid in (" + selectedname + ")"); } if (ddlName.SelectedIndex == 1 && selectedname != "") { objfun.FillGridView(GridView1, "select empName+' '+lastName as Name,empCode,empType,dob from Employee_Master where empid in (" + selectedname + ") order by empName desc"); } if (ddlName.SelectedIndex == 0 && selectedname != "") { objfun.FillGridView(GridView1, "select empName+' '+lastName as Name,empCode,empType,dob from Employee_Master where empid in (" + selectedname + ") order by empName"); } DropDownCheckBoxes ddlName1 = (DropDownCheckBoxes)GridView1.HeaderRow.FindControl("ddlname"); objfun.FillDropdownCheckboxIndex(ddlName1, "Name", "empId", "select empName as Name,empId from Employee_Master ", "empName"); for (int i = 0; i < ddlName1.Items.Count; i++) { if (ddlName1.Items[i].Text == x) { ddlName1.Items[i].Selected = true; } string[] split = selectedname.Split(','); for (int j = 0; j < split.Length; j++) { if (ddlName1.Items[i].Value == split[j].ToString()) { ddlName1.Items[i].Selected = true; } } } //protected void ddlname_SelectedIndexChanged1(object sender, System.EventArgs e) //{ // string selectedname = ""; // for (int i = 0; i < ddlname.Items.Count; i++) // { // if (ddlname.Items[i].Selected == true) // { // if (selectedname == "") // { // selectedname = ddlname.Items[i].Value; // } // else // { // selectedname = selectedname + ',' + ddlname.Items[i].Value; // } // } // } //} }
protected void gvTasks_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { DataRowView drTask = e.Row.DataItem as DataRowView; HyperLink hypTask = e.Row.FindControl("hypTask") as HyperLink; Label lblDesignation = e.Row.FindControl("lblDesignation") as Label; Label lblAssignedUser = e.Row.FindControl("lblAssignedUser") as Label; DropDownCheckBoxes ddcbAssignedUser = e.Row.FindControl("ddcbAssignedUser") as DropDownCheckBoxes; LinkButton lbtnRequestStatus = e.Row.FindControl("lbtnRequestStatus") as LinkButton; Literal ltrlStatus = e.Row.FindControl("ltrlStatus") as Literal; Literal ltrlPriority = e.Row.FindControl("ltrlPriority") as Literal; DropDownList ddlStatus = e.Row.FindControl("ddlStatus") as DropDownList; DropDownList ddlPriority = e.Row.FindControl("ddlPriority") as DropDownList; Literal ltrlDueDate = e.Row.FindControl("ltrlDueDate") as Literal; hypTask.Text = drTask["Title"].ToString(); if (hypTask.Text.Length > 55) { hypTask.ToolTip = hypTask.Text; hypTask.Text = hypTask.Text.Substring(0, 55) + ".."; } hypTask.NavigateUrl = "~/sr_app/TaskGenerator.aspx?TaskId=" + drTask["TaskId"].ToString(); lblDesignation.Text = drTask["TaskDesignations"].ToString(); if (lblDesignation.Text.Length > 30) { lblDesignation.ToolTip = lblDesignation.Text; lblDesignation.Text = lblDesignation.Text.Substring(0, 30) + ".."; } lblAssignedUser.Text = drTask["TaskAssignedUsers"].ToString(); if (lblAssignedUser.Text.Length > 30) { lblAssignedUser.ToolTip = lblAssignedUser.Text; lblAssignedUser.Text = lblAssignedUser.Text.Substring(0, 30) + ".."; } ltrlStatus.Text = ((JGConstant.TaskStatus)Convert.ToInt32(drTask["Status"])).ToString(); ddlStatus.DataSource = CommonFunction.GetTaskStatusList(); ddlStatus.DataTextField = "Text"; ddlStatus.DataValueField = "Value"; ddlStatus.DataBind(); //ddlStatus.Items.FindByValue(Convert.ToByte(JGConstant.TaskStatus.SpecsInProgress).ToString()).Enabled = false; SetStatusSelectedValue(ddlStatus, drTask["Status"].ToString()); ddlPriority.DataSource = CommonFunction.GetTaskPriorityList(); ddlPriority.DataTextField = "Text"; ddlPriority.DataValueField = "Value"; ddlPriority.DataBind(); if (!string.IsNullOrEmpty(drTask["TaskPriority"].ToString())) { ddlPriority.SelectedValue = drTask["TaskPriority"].ToString(); ltrlPriority.Text = ((JGConstant.TaskPriority)Convert.ToInt32(drTask["TaskPriority"])).ToString(); } if (!string.IsNullOrEmpty(Convert.ToString(drTask["DueDate"]))) { ltrlDueDate.Text = Convert.ToDateTime(drTask["DueDate"]).ToString("MM-dd-yyyy"); } if (this.IsAdminMode) { #region Admin User if ( ddlStatus.SelectedValue != Convert.ToByte(JGConstant.TaskStatus.Requested).ToString() && ddlStatus.SelectedValue != Convert.ToByte(JGConstant.TaskStatus.InProgress).ToString() && ddlStatus.SelectedValue != Convert.ToByte(JGConstant.TaskStatus.SpecsInProgress).ToString() && ddlStatus.SelectedValue != Convert.ToByte(JGConstant.TaskStatus.Closed).ToString() //&& //string.IsNullOrEmpty(Convert.ToString(drTask["TaskAssignedUsers"])) ) { ddcbAssignedUser.Visible = true; lbtnRequestStatus.Visible = lblAssignedUser.Visible = false; ddcbAssignedUser.Items.Clear(); ddcbAssignedUser.DataSource = TaskGeneratorBLL.Instance.GetInstallUsers(2, Convert.ToString(drTask["TaskDesignations"]).Trim()); ddcbAssignedUser.DataTextField = "FristName"; ddcbAssignedUser.DataValueField = "Id"; ddcbAssignedUser.DataBind(); } else if (ddlStatus.SelectedValue == Convert.ToByte(JGConstant.TaskStatus.Requested).ToString()) { lbtnRequestStatus.Visible = true; ddcbAssignedUser.Visible = lblAssignedUser.Visible = false; string[] arrTaskAssignmentRequest = Convert.ToString(drTask["TaskAssignmentRequestUsers"]).Split(':'); if (arrTaskAssignmentRequest.Length > 1) { lbtnRequestStatus.Text = arrTaskAssignmentRequest[1]; } lbtnRequestStatus.ForeColor = System.Drawing.Color.Red; lbtnRequestStatus.CommandName = "approve-request"; lbtnRequestStatus.CommandArgument = string.Format( "{0}:{1}", drTask["TaskId"].ToString(), arrTaskAssignmentRequest[0] ); } else { ddcbAssignedUser.Visible = true; lblAssignedUser.Visible = lbtnRequestStatus.Visible = false; DataSet dsUsers = TaskGeneratorBLL.Instance.GetInstallUsers(2, Convert.ToString(DataBinder.Eval(e.Row.DataItem, "TaskDesignations")).Trim()); ddcbAssignedUser.Items.Clear(); ddcbAssignedUser.DataSource = dsUsers; ddcbAssignedUser.DataTextField = "FristName"; ddcbAssignedUser.DataValueField = "Id"; ddcbAssignedUser.DataBind(); } ltrlPriority.Visible = false; ddlPriority.Visible = true; ddlPriority.Attributes.Add("TaskId", drTask["TaskId"].ToString()); SetTaskAssignedUsers(Convert.ToString(drTask["TaskAssignedUsers"]), ddcbAssignedUser); // set assigned user selection in dropdown. if (!string.IsNullOrEmpty(drTask["TaskAssignedUserIds"].ToString()) && ddcbAssignedUser.Items.Count > 0) { string[] arrUserIds = drTask["TaskAssignedUserIds"].ToString().Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); foreach (string strId in arrUserIds) { ListItem objListItem = ddcbAssignedUser.Items.FindByValue(strId.Trim()); if (objListItem != null) { objListItem.Selected = true; ddcbAssignedUser.Texts.SelectBoxCaption = objListItem.Text; } } } ddcbAssignedUser.Attributes.Add("TaskId", drTask["TaskId"].ToString()); ddcbAssignedUser.Attributes.Add("TaskStatus", ddlStatus.SelectedValue); #endregion } else { #region Install User string strMyDesignation = Convert.ToString(Session["DesigNew"]).Trim().ToLower(); // show request link when, // task status is open // task assigned to my designation if (ddlStatus.SelectedValue == Convert.ToByte(JGConstant.TaskStatus.Open).ToString() && strMyDesignation == Convert.ToString(drTask["TaskDesignations"]).Trim().ToLower()) { lbtnRequestStatus.Visible = true; ddcbAssignedUser.Visible = lblAssignedUser.Visible = false; lbtnRequestStatus.ForeColor = System.Drawing.Color.Green; lbtnRequestStatus.CommandName = "request"; lbtnRequestStatus.CommandArgument = string.Format( "{0}:{1}", drTask["TaskId"].ToString(), drTask["CreatedBy"].ToString() ); } else { ddcbAssignedUser.Visible = lbtnRequestStatus.Visible = false; lblAssignedUser.Visible = true; } ltrlPriority.Visible = true; ddlPriority.Visible = false; #endregion } string strRowCssClass = string.Empty; if (e.Row.RowState == DataControlRowState.Alternate) { strRowCssClass = "AlternateRow"; } else { strRowCssClass = "FirstRow"; } JGConstant.TaskStatus objTaskStatus = (JGConstant.TaskStatus)Convert.ToByte(drTask["Status"]); JGConstant.TaskPriority?objTaskPriority = null; if ( !string.IsNullOrEmpty(drTask["TaskPriority"].ToString()) && drTask["TaskPriority"].ToString() != "0" ) { objTaskPriority = (JGConstant.TaskPriority)Convert.ToByte(drTask["TaskPriority"]); } strRowCssClass += " " + CommonFunction.GetTaskRowCssClass(objTaskStatus, objTaskPriority); switch (objTaskStatus) { case JGConstant.TaskStatus.Closed: ddcbAssignedUser.Visible = false; ddlStatus.Enabled = false; ddlPriority.Enabled = false; break; case JGConstant.TaskStatus.Deleted: ddcbAssignedUser.Visible = false; ddlStatus.Enabled = false; ddlPriority.Enabled = false; break; } e.Row.CssClass = strRowCssClass; } }