Example #1
0
    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;
        }