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); } }
protected void btnSubmit_Click(object sender, EventArgs e) { string pmuDate = ""; try { if (txtPMU.Text == "Yes") { pmuDate = txtAppDate.Text; } else { pmuDate = DateTime.Now.ToString(); DateTime dtPmu = new DateTime(); dtPmu = DateTime.Parse(pmuDate); pmuDate = dtPmu.ToString("dd MMM yyyy"); } objLoan = new clsLoanDetails(); if (objLoan.AddLoanMaster(ddlProjectDetail.SelectedValue, txtLoanNumber.Text, txtLoanName.Text, double.Parse(txtAmount.Text), txtAppDate.Text, txtClosingDate.Text, txtStartDate.Text, txtEndDate.Text, int.Parse(ddlDocCat.SelectedValue), int.Parse(ddlGroup.SelectedValue), int.Parse(ddlAgency.SelectedValue), txtSigningDate.Text, txtEffectivenessDate.Text, txtContractAwardDate.Text, txtRevisedClosingDate.Text, pmuDate, txtGracePeriod.Text, double.Parse(txtOrgAmount.Text == "" ? "0" : txtOrgAmount.Text), double.Parse(txtCancelAmount.Text == "" ? "0" : txtCancelAmount.Text), double.Parse(txtTotalPrjCost.Text == "" ? "0" : txtTotalPrjCost.Text), double.Parse(txtCommtChrg.Text == "" ? "0" : txtCommtChrg.Text), double.Parse(txtContDisTrg.Text == ""?"0":txtContDisTrg.Text), txtSecondRevisedClosingDate.Text, int.Parse(ddlTAno.SelectedValue))) { lblMessage.ForeColor = System.Drawing.Color.Blue; lblMessage.Text = "Information has been saved successfully"; Utility util = new Utility(); util.ResetFormControl(pageDiv); } else { lblMessage.ForeColor = System.Drawing.Color.Red; lblMessage.Text = "Sorry Unable to Save."; } } catch (Exception ex) { logger.Error(ex); } }
protected void btnUpdate_Click(object sender, EventArgs e) { string pmuDate = ""; try { if (txtPMU.Text == "Yes") { pmuDate = txtAppDate.Text; } else { //pmuDate = null; pmuDate = DateTime.Now.ToString(); DateTime dtPmu = new DateTime(); dtPmu = DateTime.Parse(pmuDate); pmuDate = dtPmu.ToString("dd MMM yyyy"); } objLoan = new clsLoanDetails(); if (objLoan.EditLoanDetails(int.Parse(lblLoanNo.Text), ddlProjectDetail.SelectedValue, txtLoanNumber.Text, txtLoanName.Text, double.Parse(txtAmount.Text), txtAppDate.Text, txtClosingDate.Text, txtStartDate.Text, txtEndDate.Text, int.Parse(ddlDocCat.SelectedValue), int.Parse(ddlGroup.SelectedValue), int.Parse(ddlAgency.SelectedValue), txtSigningDate.Text, txtEffectivenessDate.Text, txtContractAwardDate.Text, txtRevisedClosingDate.Text, pmuDate, txtGracePeriod.Text, (txtOrgAmount.Text == ""?0.00:double.Parse(txtOrgAmount.Text)), (txtCancelAmount.Text == ""?0.00:double.Parse(txtCancelAmount.Text)), (txtTotalPrjCost.Text == ""?0.00:double.Parse(txtTotalPrjCost.Text)), (txtCommtChrg.Text == ""?0.00:double.Parse(txtCommtChrg.Text)), (txtContDisTrg.Text == ""?0.00:double.Parse(txtContDisTrg.Text)), txtSecondRevisedClosingDate.Text, int.Parse(ddlTAno.SelectedValue))) { using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = ConfigurationManager.ConnectionStrings["TA7511DBConnString"].ConnectionString; using (SqlCommand cmd = new SqlCommand()) { cmd.CommandText = "USP_UpdateLoanStatus"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@LoanId", lblLoanNo.Text); cmd.Parameters.AddWithValue("@Status", chkLoanClosed.Checked == true?1 :0); cmd.Connection = conn; conn.Open(); cmd.ExecuteNonQuery(); } } lblMessage.ForeColor = System.Drawing.Color.Blue; lblMessage.Text = "Information successfully updated"; Utility util = new Utility(); util.ResetFormControl(pageDiv); } else { lblMessage.ForeColor = System.Drawing.Color.Red; lblMessage.Text = "Sorry Unable to Save."; } } catch (Exception ex) { logger.Error(ex); } }