public void FillEDLoanData(string LoanVal) { clsMCWB mc = new clsMCWB(); DataSet ds = mc.getLoanTADetails(int.Parse(LoanVal), "Pipeline"); DataTable dt = ds.Tables[0]; prjno.Text = dt.Rows[0][0].ToString(); prj_name.Text = dt.Rows[0][1].ToString(); lblLoanDetail.Text = dt.Rows[0][0].ToString() + "-" + dt.Rows[0][1].ToString(); prjSize.Text = dt.Rows[0][3].ToString(); prjClosingDate.Text = string.IsNullOrEmpty(dt.Rows[0][2].ToString())?"": Convert.ToDateTime(dt.Rows[0][2].ToString()).ToString("dd MMM yyyy"); }
public void FillEDProjectData(string PrjID) { clsMCWB mc = new clsMCWB(); DataSet ds = mc.getLoanTADetails(int.Parse(PrjID), "Portfolio"); DataTable dt = ds.Tables[0]; prjno.Text = dt.Rows[0][0].ToString(); prj_name.Text = dt.Rows[0][1].ToString(); lblTaDetail.Text = dt.Rows[0][0].ToString() + "-" + dt.Rows[0][1].ToString(); prjSize.Text = dt.Rows[0][2].ToString(); DateTime dt1; DateTime.TryParse(dt.Rows[0][3].ToString(), out dt1); prjClosingDate.Text = (dt1 != Convert.ToDateTime("1/1/0001 12:00:00 AM") ? dt1.ToString("dd MMM yyyy") : "N/A"); }
public void FillEDTAData(string TAID) { clsMCWB mc = new clsMCWB(); DataSet ds = mc.getLoanTADetails(int.Parse(TAID), "AAA"); DataTable dt = ds.Tables[0]; prjno.Text = dt.Rows[0][0].ToString(); prj_name.Text = dt.Rows[0][1].ToString(); lblRetaDetail.Text = prjno.Text + "-" + prj_name.Text; decimal result; decimal.TryParse(dt.Rows[0][3].ToString(), out result); prjSize.Text = Math.Round(result, 2).ToString(); DateTime dt1; DateTime.TryParse(dt.Rows[0][2].ToString(), out dt1); prjClosingDate.Text = (dt1 != Convert.ToDateTime("1/1/0001 12:00:00 AM") ? dt1.ToString("dd MMM yyyy") : "N/A"); }