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);
}
}
