/// <summary>
/// Set Grid Data source
/// </summary>
/// <param name="addRow"></param>
/// <param name="deleteRow"></param>e
private void BindGrid(bool addRow, bool deleteRow)
{
ProjectPersonalBO objPP = new ProjectPersonalBO();
ProjectPersonalBLL objPPBLL = new ProjectPersonalBLL();
UserBLL objUserBLL = new UserBLL();
UserBO oBOUser = new UserBO();
oBOUser.UserName = string.Empty;
oBOUser.UserID = 0;
oBOUser.RoleID = 0;
UserList UserList = objUserBLL.GetUsers(oBOUser);
ListItem lstItem = null;
LstUsers.Items.Clear();
foreach (UserBO objUser in UserList)
{
lstItem = new ListItem();
lstItem.Value = objUser.UserID.ToString();
lstItem.Text = objUser.UserName;
LstUsers.Items.Add(lstItem);
}
}
/// <summary>
/// get results data from database by id
/// </summary>
private void Getresolby()
{
ProjectPersonalBLL objProjPersonalLogic = new ProjectPersonalBLL();
ProjectPersonalList ProjectPersonnel = objProjPersonalLogic.GetProjectPersonnel(Convert.ToInt32(Session["PROJECT_ID"]));
resolDropDownList.DataSource = ProjectPersonnel;
resolDropDownList.DataTextField = "UserName";
resolDropDownList.DataValueField = "UserID";
resolDropDownList.DataBind();
}
//private void BindRole()
//{
// objRoleBLL = new RoleBLL();
// objRoleList = objRoleBLL.GetRoles("");
// if (objRoleList.Count > 0)
// {
// ddlAssignTo.DataSource = objRoleList;
// ddlAssignTo.DataTextField = "RoleName";
// ddlAssignTo.DataValueField = "RoleID";
// ddlAssignTo.DataBind();
// }
//}
/// <summary>
/// To bind values from database to Assignto dropdownlist
/// </summary>
private void BindUser()
{
ProjectPersonalBLL objProjPersonalLogic = new ProjectPersonalBLL();
ProjectPersonalList ProjectPersonnels = objProjPersonalLogic.GetProjectPersonnel(Convert.ToInt32(Session["PROJECT_ID"]));
ddlAssignTo.DataSource = ProjectPersonnels;
ddlAssignTo.DataTextField = "UserName";
ddlAssignTo.DataValueField = "UserID";
ddlAssignTo.DataBind();
}
/// <summary>
/// calls MoveListBoxItems method
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Btn_remove_Click(object sender, EventArgs e)
{
string message = string.Empty;
if (LstProject.SelectedItem != null)
{
ProjectPersonalBLL objPPBLL = new ProjectPersonalBLL();
message = objPPBLL.CheckUser(Convert.ToInt32(LstProject.SelectedItem.Value), Convert.ToInt32(Session["PROJECT_ID"]));
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
MoveListBoxItems(LstProject, LstUsers);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
}
}
/// <summary>
/// To bind values to project listbox from database
/// </summary>
private void BindProjectUsers()
{
ProjectPersonalBLL objProjPersonalLogic = new ProjectPersonalBLL();
ProjectPersonalList ProjectPersonnels = objProjPersonalLogic.GetProjectPersonnel(Convert.ToInt32(Session["PROJECT_ID"]));
foreach (ProjectPersonalBO objProjPers in ProjectPersonnels)
{
if (LstUsers.Items.FindByValue(objProjPers.UserID.ToString()) != null)
{
LstUsers.Items.Remove(LstUsers.Items.FindByValue(objProjPers.UserID.ToString()));
}
}
LstProject.DataSource = ProjectPersonnels;
LstProject.DataTextField = "UserName";
LstProject.DataValueField = "UserID";
LstProject.DataBind();
}
private void BindPersonnel()//These are Project Users
{
ListItem firstListItem = new ListItem(ddlProjectPersonnel.Items[0].Text, ddlProjectPersonnel.Items[0].Value);
ProjectPersonalBLL objProjPersonalLogic = new ProjectPersonalBLL();
int ProjectID = Convert.ToInt32(Request.QueryString["ProjectID"]);
//Edwin: 30MAY2016 -
ProjectPersonalList ProjectPersonnels = objProjPersonalLogic.GetProjectPersonnel(ProjectID);
ddlProjectPersonnel.ClearSelection();
ddlProjectPersonnel.Items.Clear();
if (ProjectPersonnels != null)
{
ddlProjectPersonnel.DataSource = ProjectPersonnels;
ddlProjectPersonnel.DataTextField = "Username";
ddlProjectPersonnel.DataValueField = "UserID";
ddlProjectPersonnel.DataBind();
}
ddlProjectPersonnel.Items.Insert(0, firstListItem);
}
/// <summary>
/// get actionby data from database
/// </summary>
private void Getactionby()
{
//UserBLL objUserBLL = new UserBLL();
//UserList objUserList = new UserList();
//UserBO oBOUser = null;
//oBOUser = new UserBO();
//oBOUser.UserName = string.Empty;
//oBOUser.UserID = 0;
//oBOUser.RoleID = 0;
//objUserList = objUserBLL.GetUsers(oBOUser);
ProjectPersonalBLL objProjPersonalLogic = new ProjectPersonalBLL();
ProjectPersonalList ProjectPersonnel = objProjPersonalLogic.GetProjectPersonnel(Convert.ToInt32(Session["PROJECT_ID"]));
actionDropDownList.DataSource = ProjectPersonnel;
actionDropDownList.DataTextField = "UserName";
actionDropDownList.DataValueField = "UserID";
actionDropDownList.DataBind();
actionDropDownList.Items.Insert(0, new ListItem("--Select--", "0"));
actionDropDownList.SelectedIndex = 0;
}
/// <summary>
/// To save details to database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void SaveProjectPersonnel()
{
int ProjID = int.Parse(Session["PROJECT_ID"].ToString());
int userID = Convert.ToInt32(Session["USER_ID"]);
ProjectPersonalList PPList = new ProjectPersonalList();
ProjectPersonalBO objPP = null;
foreach (ListItem lstItem in LstProject.Items)
{
objPP = new ProjectPersonalBO();
objPP.UserID = Convert.ToInt32(lstItem.Value);
objPP.ProjID = ProjID;
objPP.CreatedBy = userID;
PPList.Add(objPP);
}
ProjectPersonalBLL objPPBLL = new ProjectPersonalBLL();
objPPBLL.AddPersonal(ProjID, PPList);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Data saved successfully');", true);
}
/// <summary>
/// Bind values to Drop down ddlDeliveredBy
/// </summary>
private void BindDeliveredBy()//These are Project Users
{
ListItem firstListItem = new ListItem(ddlDeliveredBy.Items[0].Text, ddlDeliveredBy.Items[0].Value);
ProjectPersonalBLL objProjPersonalLogic = new ProjectPersonalBLL();
if (Session["PROJECT_ID"] != null)
{
//Edwin: 30MAY2016 -
ProjectPersonalList ProjectPersonnels = objProjPersonalLogic.GetAllPersonnel(Convert.ToInt32(Session["PROJECT_ID"]));
ddlDeliveredBy.ClearSelection();
ddlDeliveredBy.Items.Clear();
if (ProjectPersonnels != null)
{
ddlDeliveredBy.DataSource = ProjectPersonnels;
ddlDeliveredBy.DataTextField = "Username";
ddlDeliveredBy.DataValueField = "UserID";
ddlDeliveredBy.DataBind();
}
ddlDeliveredBy.Items.Insert(0, firstListItem);
}
}
//private void BindRole()
//{
// objRoleBLL = new RoleBLL();
// objRoleList = objRoleBLL.GetRoles("");
// if (objRoleList.Count > 0)
// {
// ddlAssignTo.DataSource = objRoleList;
// ddlAssignTo.DataTextField = "RoleName";
// ddlAssignTo.DataValueField = "RoleID";
// ddlAssignTo.DataBind();
// }
//}
/// <summary>
/// To bind values from database to Assignto dropdownlist
/// </summary>
private void BindUser()
{
ProjectPersonalBLL objProjPersonalLogic = new ProjectPersonalBLL();
int UserId = 0, ProjectId = 0;
if (Session["PROJECT_ID"] != null)
{
ProjectId = Convert.ToInt32(Session["PROJECT_ID"]);
//UserId = Convert.ToInt32(Session["USER_ID"]);
}
if (Session["USER_ID"] != null)
{
//ProjectId = Convert.ToInt32(Session["PROJECT_ID"]);
UserId = Convert.ToInt32(Session["USER_ID"]);
}
ProjectPersonalList ProjectPersonnels = objProjPersonalLogic.GetProjectOtherPersonnel(ProjectId, UserId);
ddlAssignTo.DataSource = ProjectPersonnels;
ddlAssignTo.DataTextField = "UserName";
ddlAssignTo.DataValueField = "UserID";
ddlAssignTo.DataBind();
}
