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;
}
}
