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