Example #1
0
        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");
        }
Example #2
0
        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");
        }
Example #3
0
        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");
        }