public void FillEDProjectData(string PrjID)
{
clsMC mc = new clsMC();
DataSet ds = mc.getLoanTADetails(int.Parse(PrjID), "Project");
DataTable dt = ds.Tables[0];
prjno.Text = dt.Rows[0]["vsProjectNumber"].ToString();
prj_name.Text = dt.Rows[0]["vsProjectName"].ToString();
lblLoanDetail.Text = dt.Rows[0]["vsProjectNumber"].ToString() + "-" + dt.Rows[0]["vsProjectName"].ToString();
}
public void FillEDLoanData(string LoanVal)
{
clsMC mc = new clsMC();
DataSet ds = mc.getLoanTADetails(int.Parse(LoanVal), "Loan");
DataTable dt = ds.Tables[0];
prjno.Text = dt.Rows[0]["vsLoanNumber"].ToString();
prj_name.Text = dt.Rows[0]["vsLoanName"].ToString();
lblLoanDetail.Text = dt.Rows[0]["vsLoanNumber"].ToString() + "-" + dt.Rows[0]["vsLoanName"].ToString();
prjSize.Text = "USD " + dt.Rows[0]["cAmount"].ToString();
prjClosingDate.Text = Convert.ToDateTime(dt.Rows[0]["dtClosingDate"].ToString()).ToString("dd MMM yyyy");
}
public void FillEDTAData(string TAID)
{
clsMC mc = new clsMC();
DataSet ds = mc.getLoanTADetails(int.Parse(TAID), "TA");
DataTable dt = ds.Tables[0];
prjno.Text = dt.Rows[0]["iTANumber"].ToString();
prj_name.Text = dt.Rows[0]["vsTAName"].ToString();
lblTaDetail.Text = prjno.Text + "-" + prj_name.Text;
decimal result;
decimal.TryParse(dt.Rows[0]["cTAAmount"].ToString(), out result);
prjSize.Text = "USD " + Math.Round(result, 2).ToString();
DateTime dt1;
DateTime.TryParse(dt.Rows[0]["dtEndDate"].ToString(), out dt1);
prjClosingDate.Text = (dt1 != Convert.ToDateTime("1/1/0001 12:00:00 AM") ? dt1.ToString("dd MMM yyyy") : "N/A");
}