protected void btnSubmit_Click(object sender, EventArgs e) { try { objMFF = new clsMFF(); String MFF = null; // if (drpMFFcode.SelectedItem.Text == "Other") // { MFF = txtMFFCode.Text; // } // else // MFF = drpMFFcode.SelectedValue; if (objMFF.AddMFFDate(drpLoanNumber.SelectedValue, drpLoanType.SelectedValue, txtAmountToBeContracted.Text, dtFinancialClosing.Text, txtMFFApproval.Text, txtMFFAmount.Text, txtPFRApproved.Text, txtLastDatofPFR.Text, txtCompletion.Text, txtPFRApprovedCode.Text, MFF)) { lblMessage.Text = "MFF Data of selected loan has been inserted successfully "; } else { lblMessage.Text = "MFF Data not inserted"; } } catch (Exception ex) { lblMessage.Text = ex.Message; } }
void FillMFFData(string LoanNo) { string myStringFormat = "{0:0.0}"; objMFF = objMFF ?? new clsMFF(); DataSet ds = objMFF.GetMFFData(LoanNo); if (drpLoanNumber.Items.FindByValue(LoanNo) != null) { drpLoanNumber.Items.FindByValue(LoanNo).Selected = true; } if (ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; txtAmountToBeContracted.Text = String.Format(myStringFormat, dr["AmountToBeContracted"].ToDecimalOrZero()); if (dr["dtFinancialClosing"] != DBNull.Value && Convert.ToDateTime(dr["dtFinancialClosing"]) != new DateTime(1900, 1, 1)) { dtFinancialClosing.Text = Convert.ToDateTime(dr["dtFinancialClosing"].ToString()).ToString("dd MMM yyyy"); } if (dr["MFFApproval"] != DBNull.Value && Convert.ToDateTime(dr["MFFApproval"]) != new DateTime(1900, 1, 1)) { txtMFFApproval.Text = Convert.ToDateTime(dr["MFFApproval"].ToString()).ToString("dd MMM yyyy"); } txtPFRApproved.Text = String.Format(myStringFormat, dr["PFRApproved"].ToDecimalOrZero()); txtMFFAmount.Text = String.Format(myStringFormat, dr["MFFAmount"].ToDecimalOrZero()); if (dr["Completion"] != DBNull.Value && Convert.ToDateTime(dr["Completion"]) != new DateTime(1900, 1, 1)) { txtCompletion.Text = Convert.ToDateTime(dr["Completion"].ToString()).ToString("dd MMM yyyy"); } if (dr["LastDatePFR"] != DBNull.Value && Convert.ToDateTime(dr["LastDatePFR"]) != new DateTime(1900, 1, 1)) { txtLastDatofPFR.Text = Convert.ToDateTime(dr["LastDatePFR"].ToString()).ToString("dd MMM yyyy"); } if (drpLoanType.Items.FindByValue(dr["iLoanTypeId"].ToString()) != null) { drpLoanType.Items.FindByValue(dr["iLoanTypeId"].ToString()).Selected = true; } txtPFRApprovedCode.Text = dr["PFRApprovedNo"].ToString(); // drpMFFcode.SelectedItem.Text = dr["MFFCode"].ToString(); txtMFFCode.Text = dr["MFFCode"].ToString(); this.BindGrid(txtMFFCode.Text); } }