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