private void fillData(EntLoanMaster objEnt)
{
try
{
if (objEnt.LoanNumber != null)
{
btnUpdate.Visible = true;
btnSubmit.Visible = false;
lblLoanNo.Text = objEnt.LoanID.ToString();
txtAmount.Text = Math.Round(Convert.ToDecimal(objEnt.Amount), 2).ToString();
txtAppDate.Text = objEnt.ApprovalDate;
txtClosingDate.Text = objEnt.ClosingDate;
txtLoanName.Text = objEnt.LoanName;
txtLoanNumber.Text = objEnt.LoanNumber;
ddlProjectDetail.SelectedValue = objEnt.ProjectID.ToString();
ddlGroup.SelectedValue = objEnt.GroupID.ToString();
ddlDocCat.SelectedValue = objEnt.DocCatID.ToString();
txtStartDate.Text = objEnt.StartDate;
txtEndDate.Text = objEnt.EndDate;
ddlAgency.SelectedValue = objEnt.AgencyID.ToString();
ddlTAno.SelectedValue = objEnt.TAID.ToString();
txtEffectivenessDate.Text = objEnt.EffectivenessDate;
txtSigningDate.Text = objEnt.SigningDate;
txtRevisedClosingDate.Text = objEnt.RevisedClosingDate;
txtContractAwardDate.Text = objEnt.ContractAwardDate;
txtPMU.Text = objEnt.EstPMU;
if (txtPMU.Text != txtAppDate.Text)
{
txtPMU.Text = "No";
chkPmu.Checked = false;
}
else
{
txtPMU.Text = "Yes";
chkPmu.Checked = true;
}
txtGracePeriod.Text = objEnt.GracePeriod;
txtOrgAmount.Text = Math.Round(Convert.ToDecimal(objEnt.OrgAmount), 2).ToString() == "0.00" ? string.Empty : Math.Round(Convert.ToDecimal(objEnt.OrgAmount), 2).ToString();
txtCancelAmount.Text = Math.Round(Convert.ToDecimal(objEnt.CancelAmount), 2).ToString() == "0.00" ? string.Empty : Math.Round(Convert.ToDecimal(objEnt.CancelAmount), 2).ToString();
txtCommtChrg.Text = Math.Round(Convert.ToDecimal(objEnt.CommCharge), 2).ToString() == "0.00" ? string.Empty : Math.Round(Convert.ToDecimal(objEnt.CommCharge), 2).ToString();
txtTotalPrjCost.Text = Math.Round(Convert.ToDecimal(objEnt.TprojectCost), 2).ToString() == "0.00" ? string.Empty : Math.Round(Convert.ToDecimal(objEnt.TprojectCost), 2).ToString();
//modified change
txtContDisTrg.Text = Math.Round(Convert.ToDecimal(objEnt.ConDisTrg), 2).ToString() == "0.00" ? string.Empty : Math.Round(Convert.ToDecimal(objEnt.ConDisTrg), 2).ToString();
txtSecondRevisedClosingDate.Text = objEnt.SecondRevClosingDate;
}
else
{
btnUpdate.Visible = false;
btnSubmit.Visible = true;
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
sLoanid = Request.QueryString["loanid"];
if (Utility.CheckAccess("LoanMasterAddEdit") == false)
{
UrlParameterPasser urlWrapper = new UrlParameterPasser();
urlWrapper["pageaccesserr"] = "1";
urlWrapper.Url = "../DocumentLogSystem/DashBoard.aspx";
urlWrapper.PassParameters();
}
if (!Convert.ToBoolean(Session[clsConstant.SESS_VIEWTYPE]))
{
this.MakeReadOnly(this.Controls);
}
else
{
ddlProjectBind();
fillDocCat();
fillAgency();
btnSubmit.Visible = true;
btnUpdate.Visible = false;
checkForPMU();
fillTA();
if (sLoanid != "")
{
chkLoanClosed.Visible = true;
}
else
{
chkLoanClosed.Visible = false;
}
}
}
if (sLoanid != null)
{
if (!IsPostBack)
{
objLoan = new clsLoanDetails();
EntLoanMaster objEnt = objLoan.setEntity(int.Parse(sLoanid));
fillData(objEnt);
}
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void txtLoanNumber_TextChanged(object sender, EventArgs e)
{
try
{
objLoan = new clsLoanDetails();
EntLoanMaster objEnt = objLoan.setEntity(0, txtLoanNumber.Text);
fillData(objEnt);
}
catch (Exception ex)
{
logger.Error(ex);
}
}
public EntLoanMaster setEntity(int loanid = 0, string loanNumber = "")
{
EntLoanMaster entLoan = new EntLoanMaster();
SqlDataReader reader;
if (objDataAccess.Connection.State == ConnectionState.Closed)
{
objDataAccess.Connection.Open();
}
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@loanId", loanid), new SqlParameter("@loanNumber", loanNumber) };
reader = objDataAccess.ExecuteReaderQuery(clsConstant.SP_SELECT_LOAN_CHECK_DEMO, CommandType.StoredProcedure, param);
if (reader.Read())
{
entLoan.LoanID = reader.GetInt32(0);
entLoan.LoanNumber = reader.GetString(1);
entLoan.LoanName = reader.GetString(2);
//entLoan.ProjectID = reader.GetInt32(3);
if (!reader.IsDBNull(3))
{
entLoan.ProjectID = reader.GetInt32(3);
}
string sDateTest = reader.GetValue(4).ToString();
if (sDateTest != null)
{
if (sDateTest == "")
{
entLoan.ApprovalDate = "";
}
else
{
entLoan.ApprovalDate = Convert.ToDateTime(sDateTest).ToString(clsConstant.DATE_FORMAT);
}
}
sDateTest = reader.GetValue(5).ToString();
if (sDateTest != null)
{
if (sDateTest == "")
{
entLoan.ClosingDate = "";
}
else
{
entLoan.ClosingDate = Convert.ToDateTime(sDateTest).ToString(clsConstant.DATE_FORMAT);
}
}
entLoan.Amount = reader.GetValue(6).ToString();
sDateTest = reader.GetValue(7).ToString();
if (sDateTest != null && sDateTest != "")
{
if (sDateTest == "")
{
entLoan.StartDate = "";
}
else
{
entLoan.StartDate = Convert.ToDateTime(sDateTest).ToString(clsConstant.DATE_FORMAT);
}
}
sDateTest = reader.GetValue(8).ToString();
if (sDateTest != null)
{
if (sDateTest == "")
{
entLoan.EndDate = "";
}
else
{
entLoan.EndDate = Convert.ToDateTime(sDateTest).ToString(clsConstant.DATE_FORMAT);
}
}
entLoan.DocCatID = reader.GetInt32(9);
entLoan.GroupID = reader.GetInt32(10);
entLoan.AgencyID = reader.GetInt32(11);
sDateTest = reader.GetValue(12).ToString();
if (sDateTest != null)
{
if (sDateTest == "")
{
entLoan.EffectivenessDate = "";
}
else
{
entLoan.EffectivenessDate = Convert.ToDateTime(sDateTest).ToString(clsConstant.DATE_FORMAT);
}
}
sDateTest = reader.GetValue(13).ToString();
if (sDateTest != null)
{
if (sDateTest == "")
{
entLoan.SigningDate = "";
}
else
{
entLoan.SigningDate = Convert.ToDateTime(sDateTest).ToString(clsConstant.DATE_FORMAT);
}
}
sDateTest = reader.GetValue(14).ToString();
if (sDateTest != null)
{
if (sDateTest == "")
{
entLoan.RevisedClosingDate = "";
}
else
{
entLoan.RevisedClosingDate = Convert.ToDateTime(sDateTest).ToString(clsConstant.DATE_FORMAT);
}
}
sDateTest = reader.GetValue(15).ToString();
if (sDateTest != null)
{
if (sDateTest == "")
{
entLoan.ContractAwardDate = "";
}
else
{
entLoan.ContractAwardDate = Convert.ToDateTime(sDateTest).ToString(clsConstant.DATE_FORMAT);
}
}
sDateTest = reader.GetValue(16).ToString();
if (sDateTest != null)
{
if (sDateTest == "")
{
entLoan.EstPMU = "";
}
else
{
entLoan.EstPMU = Convert.ToDateTime(sDateTest).ToString(clsConstant.DATE_FORMAT);
}
}
entLoan.GracePeriod = reader.GetValue(17).ToString();
//Added for PBS
entLoan.OrgAmount = reader.GetValue(18).ToString();
entLoan.CancelAmount = reader.GetValue(19).ToString();
entLoan.TprojectCost = reader.GetValue(20).ToString();
sDateTest = reader.GetValue(21).ToString();
if (sDateTest != null)
{
if (sDateTest == "")
{
entLoan.SecondRevClosingDate = "";
}
else
{
entLoan.SecondRevClosingDate = Convert.ToDateTime(sDateTest).ToString(clsConstant.DATE_FORMAT);
}
}
entLoan.CommCharge = reader.GetValue(22).ToString();
entLoan.ConDisTrg = reader.GetValue(23).ToString();//modified change
/****Add by nitin 19 oct 2013**/
if (!reader.IsDBNull(24))
{
entLoan.TAID = reader.GetInt32(24);
}
}
return(entLoan);
}
