protected void Page_Load(object sender, EventArgs e) { try { objConsultantDetails = new ConsultantDetails(); objEnt = new clsEntConsultantDetails(); iConsDetailsID = Request.QueryString["ConsultantID"]; if (!IsPostBack) { txtStartDate.Text = DateTime.Today.ToString(clsConstant.DATE_FORMAT); if (Utility.CheckAccess("ConsultantDetailsAddEdit") == false) { pnlInvalid.Visible = true; MainDiv.Visible = false; } if (!Convert.ToBoolean(Session[clsConstant.SESS_VIEWTYPE])) { this.MakeReadOnly(this.Controls); } // Function Binding FirmId into the DropDown Menu if (iConsDetailsID != null) { objEnt = objConsultantDetails.readerForConsultantDetails(int.Parse(iConsDetailsID)); txtFirstName.Text = objEnt.FirstName; txtLastName.Text = objEnt.LastName; txtDateOfBirth.Text = objEnt.DateOfBirth; txtStartDate.Text = objEnt.StartDate; txtEndDate.Text = objEnt.EndDate; } } if (iConsDetailsID != null) { btnSubmit.Visible = false; btnReset.Visible = true; btnUpdate.Visible = true; } else { btnSubmit.Visible = true; btnReset.Visible = true; btnUpdate.Visible = false; } } catch (Exception ex) { logger.Error(ex); } }
///<summary> /// Function for Data reader, returning Entities ///</summary> public clsEntConsultantDetails readerForConsultantDetails(int consultantID) { clsEntConsultantDetails objEnt = new clsEntConsultantDetails(); SqlDataReader reader; try { if (objConnection.Connection.State == ConnectionState.Closed) { objConnection.Connection.Open(); } SqlParameter[] pram = new SqlParameter[] { new SqlParameter("@consultantID", consultantID) }; reader = objConnection.ExecuteReaderQuery(clsConstant.SP_SELECT_CONSULTANT_MASTER_CHECK, CommandType.StoredProcedure, pram); while (reader.Read()) { if (!reader.IsDBNull(0)) { objEnt.ConsultantID = Convert.ToInt32(reader.GetValue(0)); } if (!reader.IsDBNull(1)) { objEnt.FirstName = reader.GetValue(1).ToString(); } if (!reader.IsDBNull(2)) { objEnt.LastName = reader.GetValue(2).ToString(); } if (!reader.IsDBNull(3)) { objEnt.DateOfBirth = Convert.ToDateTime(reader.GetValue(3)).ToString(clsConstant.DATE_FORMAT); } if (!reader.IsDBNull(4)) { objEnt.StartDate = Convert.ToDateTime(reader.GetValue(4)).ToString(clsConstant.DATE_FORMAT); } if (!reader.IsDBNull(5)) { objEnt.EndDate = Convert.ToDateTime(reader.GetValue(5)).ToString(clsConstant.DATE_FORMAT); } } return(objEnt); } catch (Exception ex) { throw ex; } }