protected void drpPackageName_SelectedIndexChanged(object sender, EventArgs e)
{
objEnt = ObjconFirmPackage.readerPackageConsultantByPackageNo(drpPackageName.SelectedValue);
bool flag = false;
if (objEnt != null)
{
bindFirstFirm();
bindSecondFirm();
FirmTypeLoad();
FirmStatusLoad();
if (objEnt.FirmID1 > 0)
{
flag = true;
isInsert = false;
int leadFirmname = objEnt.FirmID1;
drpFirmNameFirst.SelectedValue = leadFirmname.ToString();
drpFirmNameFirst.Visible = true;
}
else
{
flag = false;
isInsert = true;
drpFirmNameFirst.Visible = false;
}
if ((flag) && objEnt.FirmID2 > 0)
{
bindSecondFirm();
secondFirmLoad();
flag = true;
int leadFirmname = objEnt.FirmID2;
drpFirmNameSecond.SelectedValue = leadFirmname.ToString();
drpFirmNameSecond.Visible = true;
}
else
{
flag = false;
drpFirmNameSecond.Visible = false;
lblFirmNameSecond.Visible = false;
btnImgSecond.Visible = false;
}
if ((flag) && objEnt.FirmID3 > 0)
{
flag = true;
thirdFirmLoad();
bindThirdFirm();
int leadFirmname = objEnt.FirmID3;
drpFirmNameThird.SelectedValue = leadFirmname.ToString();
drpFirmNameThird.Visible = true;
}
else
{
flag = false;
drpFirmNameThird.Visible = false;
lblFirmNameThird.Visible = false;
btnImgThird.Visible = false;
}
if ((flag) && objEnt.FirmID4 > 0)
{
flag = true;
forthFirmLoad();
bindForthFirm();
int leadFirmname = objEnt.FirmID4;
drpFirmNameForth.SelectedValue = leadFirmname.ToString();
drpFirmNameForth.Visible = true;
}
else
{
flag = false;
drpFirmNameForth.Visible = false;
lblFirmNameForth.Visible = false;
btnImgForth.Visible = false;
}
if ((flag) && objEnt.FirmID5 > 0)
{
fifthFirmLoad();
bindFifthFirm();
int leadFirmname = objEnt.FirmID2;
drpFirmNameFivth.SelectedValue = leadFirmname.ToString();
drpFirmNameFivth.Visible = true;
}
else
{
drpFirmNameFivth.Visible = false;
lblFirmNameFivth.Visible = false;
}
string firmtype = objEnt.FirmType.ToString();
drpFirmType.Items.FindByText(firmtype).Selected = true;
string firmstatus = objEnt.FirmStatus.ToString();
drpStatus.Items.FindByText(firmstatus).Selected = true;
lblMessage.ForeColor = System.Drawing.Color.Black;
lblMessage.Text = "Data Available in Database.";
btnUpdate.Visible = !isInsert;
btnSubmit.Visible = isInsert;
}
else
{
btnUpdate.Visible = false;
btnSubmit.Visible = true;
drpFirmNameFirst.SelectedIndex = 0;
drpFirmType.SelectedIndex = 0;
drpStatus.SelectedIndex = 0;
lblFirmNameFirst.Text = "Firm Name";
drpFirmNameFirst.Visible = true;
lblFirmNameSecond.Visible = false;
drpFirmNameSecond.Visible = false;
btnImgSecond.Visible = false;
lblFirmNameThird.Visible = false;
btnImgThird.Visible = false;
drpFirmNameThird.Visible = false;
lblFirmNameForth.Visible = false;
btnImgForth.Visible = false;
drpFirmNameForth.Visible = false;
lblFirmNameFivth.Visible = false;
drpFirmNameFivth.Visible = false;
lblMessage.Text = "";
}
}
public clsEntPackageConsultant readerPackageConsultantByPackageNo(string packNo)
{
clsEntPackageConsultant objEnt = null;
try
{
if (objConnection.Connection.State == ConnectionState.Closed)
{
objConnection.Connection.Open();
}
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@packNo", packNo) };
SqlDataReader reader = objConnection.ExecuteReaderQuery(clsConstant.SP_SELECT_CONSULTANT_PACKAGE_ENT_BY_PACKNO, CommandType.StoredProcedure, param);
while (reader.Read())
{
objEnt = new clsEntPackageConsultant();
objEnt.PackageCons = Convert.ToInt32(reader.GetValue(0));
objEnt.PackageNumber = reader.GetValue(1).ToString();
objEnt.PackageID = reader.GetInt32(2);
objEnt.PackageID = Convert.ToInt32(reader.GetValue(2));
objEnt.FirmType = reader.GetValue(3).ToString();
objEnt.FirmStatus = reader.GetValue(4).ToString();
if (DBNull.Value != reader.GetValue(5))
{
objEnt.FirmID1 = Convert.ToInt32(reader.GetValue(5));
}
else
{
objEnt.FirmID1 = 0;
}
if (DBNull.Value != reader.GetValue(6))
{
objEnt.FirmID2 = Convert.ToInt32(reader.GetValue(6));
}
objEnt.PackageID = Convert.ToInt32(reader.GetValue(2));
objEnt.FirmType = reader.GetValue(3).ToString();
objEnt.FirmStatus = reader.GetValue(4).ToString();
if (DBNull.Value != reader.GetValue(5))
{
objEnt.FirmID1 = Convert.ToInt32(reader.GetValue(5));
}
else
{
objEnt.FirmID1 = 0;
}
if (DBNull.Value != reader.GetValue(6))
{
objEnt.FirmID2 = Convert.ToInt32(reader.GetValue(6));
}
else
{
objEnt.FirmID2 = 0;
}
if (DBNull.Value != reader.GetValue(7))
{
objEnt.FirmID3 = Convert.ToInt32(reader.GetValue(7));
}
else
{
objEnt.FirmID3 = 0;
}
if (DBNull.Value != reader.GetValue(8))
{
objEnt.FirmID4 = Convert.ToInt32(reader.GetValue(8));
}
else
{
objEnt.FirmID4 = 0;
}
if (DBNull.Value != reader.GetValue(9))
{
objEnt.FirmID5 = Convert.ToInt32(reader.GetValue(9));
}
else
{
objEnt.FirmID5 = 0;
}
objEnt.loanID = reader.GetValue(10).ToString();
}
return(objEnt);
}
catch (Exception ex)
{
throw ex;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if ((!IsPostBack))
{
lblFirmNameSecond.Visible = false;
lblFirmNameThird.Visible = false;
lblFirmNameForth.Visible = false;
lblFirmNameFivth.Visible = false;
drpFirmNameSecond.Visible = false;
drpFirmNameThird.Visible = false;
drpFirmNameForth.Visible = false;
drpFirmNameFivth.Visible = false;
btnImgFirst.Visible = false;
btnImgSecond.Visible = false;
btnImgThird.Visible = false;
btnImgForth.Visible = false;
packageConsID = Request.QueryString["packageConsid"];
if (packageConsID != null)
{
if (!IsPostBack)
{
objEnt = ObjconFirmPackage.readerPackageConsultant(int.Parse(packageConsID));
LoanLoad();
string loanno = objEnt.loanID.ToString();
drpLoanNumber.Items.FindByValue(loanno).Selected = true;
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@iLoanID", drpLoanNumber.SelectedValue) };
drpPackageName.DataSource = objCommon.getDropDownList(clsConstant.SP_GET_PACKAGELOAN, param);
drpPackageName.DataTextField = "DisplayFieldText";
drpPackageName.DataValueField = "ValueFieldText";
drpPackageName.DataBind();
int packageNumber = objEnt.PackageID;
drpPackageName.SelectedValue = packageNumber.ToString();
bindFirstFirm();
//Chech for enable disable.
FirmTypeLoad();
string firmtype = objEnt.FirmType.ToString();
drpFirmType.Items.FindByText(firmtype).Selected = true;
FirmStatusLoad();
string firmstatus = objEnt.FirmStatus.ToString();
drpStatus.Items.FindByText(firmstatus).Selected = true;
btnUpdate.Visible = true;
btnSubmit.Visible = false;
enableDisable();
}
}
else
{
btnUpdate.Visible = false;
if (!IsPostBack)
{
if (Utility.CheckAccess("PackageToFirmAddEdit") == 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);
}
LoanLoad();
bindFirstFirm();
FirmTypeLoad();
FirmStatusLoad();
}
}
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}