/// <summary>
/// To Get Project Personnel
/// </summary>
/// <param name="projectID"></param>
/// <returns></returns>
public ProjectPersonalList GetProjectPersonnel(int projectID)
{
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_PROJECT_PERSONAL";
cmd = new OracleCommand(proc, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("PROJECTID_", projectID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
ProjectPersonalBO objPP = null;
ProjectPersonalList objPPList = new ProjectPersonalList();
while (dr.Read())
{
objPP = new ProjectPersonalBO();
objPP.UserID = dr.GetInt32(dr.GetOrdinal("USERID"));
objPP.Username = dr.GetValue(dr.GetOrdinal("USERNAME")).ToString();
objPPList.Add(objPP);
}
dr.Close();
return(objPPList);
}
/// <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>
/// To Get Users
/// </summary>
/// <returns></returns>
public ProjectPersonalList GetApproverUsers(int AssigntoId)
{
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_SHA_APPUSERS";
cmd = new OracleCommand(proc, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("ASSIGNTOID_", AssigntoId);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
ProjectPersonalBO ObjPP = null;
ProjectPersonalList ObjPPList = new ProjectPersonalList();
while (dr.Read())
{
ObjPP = new ProjectPersonalBO();
ObjPP.UserID = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("AUTHORISERID"))));
ObjPP.Username = dr.GetValue(dr.GetOrdinal("Displayname")).ToString();
ObjPPList.Add(ObjPP);
}
dr.Close();
return(ObjPPList);
}
/// <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);
}
