示例#1
0
    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;
        }
    }
示例#2
0
        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;
                }
            }
        }