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