public entRights GetRightsDetails(int iMappingID) { entRights objEnt = new entRights(); SqlDataReader reader; if (objDataAccess.Connection.State == ConnectionState.Closed) { objDataAccess.Connection.Open(); } SqlParameter[] param = new SqlParameter[] { new SqlParameter("@mappingID", iMappingID) }; reader = objDataAccess.ExecuteReaderQuery(clsConstant.SP_GET_RIGHTS, CommandType.StoredProcedure, param); if (reader.Read()) { objEnt.RoleID = reader.GetInt32(0); objEnt.UserID = reader.GetInt32(1); objEnt.UserName = reader.GetValue(2).ToString(); } return(objEnt); }
/// <summary> /// Modified By: Rabindra Kumar Das /// Dated: 28th May 2012 /// </summary> /// <param name="iMappingID"></param> private void fillDetails(int iMappingID) { lstSelectedUser.Items.Clear(); RightDetails objRight = new RightDetails(); entRights objEnt = objRight.GetRightsDetails(iMappingID); ddlRole.SelectedValue = objEnt.RoleID.ToString(); lstSelectedUser.Items.Add(new ListItem(objEnt.UserName, objEnt.UserID.ToString())); //lstSelectedUser.Enabled = false; lstUser.Visible = true; //lstUser.SelectedValue = objEnt.UserName; //btnSubmit.Text = "Update"; btnUpdate.Visible = true; btnSubmit.Visible = false; btnSingleForward0.Visible = false; btnSingleBackward0.Visible = false; btnMulitpleForward0.Visible = false; btnMultipleBackward0.Visible = false; lstSelectedUser.SelectedIndex = 0; }