public clsEntDesignationDetails readerforDesignationDetails(int designationID) { clsEntDesignationDetails objEnt = new clsEntDesignationDetails(); SqlDataReader reader; try { if (objDataAccess.Connection.State == ConnectionState.Closed) { objDataAccess.Connection.Open(); } SqlParameter[] pram = new SqlParameter[] { new SqlParameter("@designationID", designationID) }; reader = objDataAccess.ExecuteReaderQuery(clsConstant.SP_SELECT_DESIGNATION_CHECK, CommandType.StoredProcedure, pram); while (reader.Read()) { objEnt.DesigntionName = reader.GetValue(0).ToString(); objEnt.AgencyId = int.Parse(reader.GetValue(1).ToString()); } return(objEnt); } catch (Exception ex) { throw ex; } }
protected void Page_Load(object sender, EventArgs e) { try { desigID = Request.QueryString["desigID"]; agencyID = Request.QueryString["agencyID"]; if (!IsPostBack) { if (Utility.CheckAccess("DesignationDetailsAddEdit") == false) { pnlInvalid.Visible = true; MainDiv.Visible = false; } if (!Convert.ToBoolean(Session[clsConstant.SESS_VIEWTYPE])) { this.MakeReadOnly(this.Controls); } if (desigID != null) { btnSubmit.Visible = false; btnReset.Visible = false; if (IsPostBack != true) { objEnt = objDesignationDetails.readerforDesignationDetails(int.Parse(desigID)); txtDesigName.Text = objEnt.DesigntionName; drpAgencyBind.DataSource = objComm.getDropDownList(clsConstant.SP_GET_AGENCY, null); drpAgencyBind.DataTextField = "DisplayFieldText"; drpAgencyBind.DataValueField = "ValueFieldText"; drpAgencyBind.DataBind(); drpAgencyBind.SelectedValue = objEnt.AgencyId.ToString(); } } else { if (IsPostBack == false) { btnUpdate.Visible = false; btnCancelUpdate.Visible = false; drpAgencyBind.DataSource = objComm.getDropDownList(clsConstant.SP_GET_AGENCY, null); drpAgencyBind.DataTextField = "DisplayFieldText"; drpAgencyBind.DataValueField = "ValueFieldText"; drpAgencyBind.DataBind(); } } } } catch (Exception ex) { logger.Error(ex); } }