public EntFirmType readFirmtypeFromFirmName(int firmID) { EntFirmType objEnt = new EntFirmType(); try { if (objConnection.Connection.State == ConnectionState.Closed) { objConnection.Connection.Open(); } SqlParameter[] param = new SqlParameter[] { new SqlParameter("@firmID", firmID) }; SqlDataReader reader = objConnection.ExecuteReaderQuery(clsConstant.SP_GET_FIRMTYPE_FIRMNAME, CommandType.StoredProcedure, param); while (reader.Read()) { objEnt.FirmTypeID = reader.GetInt32(0); } reader.Close(); return(objEnt); } catch (Exception ex) { throw ex; } }
protected void drpFirmName_SelectedIndexChanged(object sender, EventArgs e) { ObjEntType = ObjfirmEval.readFirmtypeFromFirmName(int.Parse(drpFirmName.SelectedValue)); drpFirmType.SelectedValue = ObjEntType.FirmTypeID.ToString(); //drpFirmType.Enabled = false; objEnt = ObjfirmEval.readerFirmEvaluationByFirmname(drpFirmName.SelectedValue, int.Parse(drpLoan.SelectedValue), int.Parse(drpPackage.SelectedValue)); if (objEnt.FirmID != 0) { FirmTypeLoad(); string firmtype = objEnt.FirmType.ToString(); if (firmtype == "1" || firmtype == "2") { drpFirmType.Items.FindByValue(firmtype).Selected = true; } else { drpFirmType.Items.FindByText(firmtype).Selected = true; drpFirmType.Enabled = false; } RatingParameterLoad(); string evalDate = objEnt.EvalDate; if (evalDate != "") { evalDate = Convert.ToDateTime(evalDate).ToString(clsConstant.DATE_FORMAT); } if (evalDate != "") { if (evalDate.Substring(0, evalDate.Length - 5) == "01 Jan" || evalDate.Substring(0, evalDate.Length - 5) == "1 Jan") { drpDate.SelectedIndex = 0; } else { drpDate.SelectedIndex = 1; } drpYear.SelectedIndex = drpYear.Items.IndexOf(drpYear.Items.FindByText(evalDate.Substring(evalDate.Length - 4, 4))); } lblMessage.Text = "Firm Already Evaluated."; btnSubmit.Visible = false; btnUpdate.Visible = true; } else { lblMessage.Text = ""; btnSubmit.Visible = true; btnUpdate.Visible = false; if (drpFirmType.SelectedValue == "0") { drpFirmType.Enabled = true; } else { drpFirmType.Enabled = false; } } }