public EntConFirmDesgRelation readerConsultantByID(int CFDRelationID) { EntConFirmDesgRelation objEnt = new EntConFirmDesgRelation(); try { if (objConnection.Connection.State == ConnectionState.Closed) { objConnection.Connection.Open(); } SqlParameter[] param = new SqlParameter[] { new SqlParameter("@cfdID", CFDRelationID) }; SqlDataReader reader = objConnection.ExecuteReaderQuery(clsConstant.SP_SELECT_CONSULTANT_TO_FIRM_BY_ID, CommandType.StoredProcedure, param); while (reader.Read()) { objEnt.CFDRelationID = Convert.ToInt32(reader.GetValue(0)); objEnt.LoanID = Convert.ToInt32(reader.GetValue(1)); objEnt.PackageID = reader.GetInt32(2); objEnt.FirmID = Convert.ToInt32(reader.GetValue(3)); objEnt.DesignationName = reader.GetString(4); objEnt.ConsultantID = Convert.ToInt32(reader.GetValue(5)); string dtStartDate = reader.GetValue(6).ToString(); string dtEndDate = reader.GetValue(7).ToString(); if (dtStartDate == "" || dtStartDate == "01 Jan 1900") { objEnt.StartDate = ""; } else { objEnt.StartDate = dtStartDate; } if (dtEndDate == "" || dtEndDate == "01 Jan 1900") { objEnt.EndDate = ""; } else { objEnt.EndDate = dtEndDate; } } return(objEnt); } catch (Exception ex) { throw ex; } }
private void ddlChangeEvent() { objEnt = objConsultantToFirm.readerConsultantByFirmID(int.Parse(drpFirmNameFirst.SelectedValue), int.Parse(drpLoanNumber.SelectedValue), int.Parse(drpPackageName.SelectedValue), int.Parse(drpConsultant.SelectedValue)); if (objEnt.FirmID != 0) { lblCfdID.Text = objEnt.CFDRelationID.ToString(); if (objEnt.FirmID > 0) { int leadFirmname = objEnt.FirmID; drpFirmNameFirst.SelectedValue = leadFirmname.ToString(); drpFirmNameFirst.Visible = true; } else { //drpFirmNameFirst.Visible = false; } if (objEnt.DesignationName != null) { txtDesignation.Text = objEnt.DesignationName.ToString(); } else { txtDesignation.Text = ""; } drpConsultant.SelectedValue = objEnt.ConsultantID.ToString(); if (objEnt.StartDate != null) { if (objEnt.StartDate != "") { DateTime dtstartdate = DateTime.Parse(objEnt.StartDate); txtStartDate.Text = dtstartdate.ToString(clsConstant.DATE_FORMAT); } } else { txtStartDate.Text = ""; } if (objEnt.EndDate != null) { if (objEnt.EndDate != "") { DateTime dtenddate = DateTime.Parse(objEnt.EndDate); txtEndDate.Text = dtenddate.ToString(clsConstant.DATE_FORMAT); } } lblMessage.ForeColor = System.Drawing.Color.Black; lblMessage.Text = "Data Available in Database."; btnUpdate.Visible = true; btnSubmit.Visible = false; isEdit = true; } else { lblMessage.Text = ""; btnUpdate.Visible = false; btnSubmit.Visible = true; } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { if (Utility.CheckAccess("ConsultantToFirmList") == false) { //UrlParameterPasser urlWrapper = new UrlParameterPasser(); //urlWrapper["pageaccesserr"] = "1"; ////urlWrapper.Url = "../Logout.aspx"; //urlWrapper.Url = "../DocumentLogSystem/DashBoard.aspx"; //urlWrapper.PassParameters(); pnlInvalid.Visible = true; MainDiv.Visible = false; } if (!Convert.ToBoolean(Session[clsConstant.SESS_VIEWTYPE])) { this.MakeReadOnly(this.Controls); } else { loadLoan(); loadConsultant(); CFDRelationID = Request.QueryString["CFDRelationID"]; if (CFDRelationID != null) { objEnt = objConsultantToFirm.readerConsultantByID(int.Parse(CFDRelationID)); if (objEnt.LoanID != 0) { lblCfdID.Text = objEnt.CFDRelationID.ToString(); drpLoanNumber.SelectedValue = objEnt.LoanID.ToString(); loadPackage(); drpPackageName.SelectedValue = objEnt.PackageID.ToString(); getFirmByPackage(objEnt.PackageID); drpFirmNameFirst.SelectedValue = objEnt.FirmID.ToString(); txtDesignation.Text = objEnt.DesignationName.ToString(); drpConsultant.SelectedValue = objEnt.ConsultantID.ToString(); if (objEnt.StartDate != null) { if (objEnt.StartDate != "") { txtStartDate.Text = objEnt.StartDate; } } else { txtStartDate.Text = ""; } if (objEnt.EndDate != null) { if (objEnt.EndDate != "") { txtEndDate.Text = objEnt.EndDate; } } else { txtEndDate.Text = ""; } btnSubmit.Visible = false; btnUpdate.Visible = true; } else { btnSubmit.Visible = true; btnUpdate.Visible = false; } } else { txtStartDate.Text = DateTime.Now.Date.ToString(clsConstant.DATE_FORMAT); btnSubmit.Visible = true; btnUpdate.Visible = false; } } } } catch (Exception ex) { logger.Error(ex); } }