예제 #1
0
        public DataSet GetMCRequestFillData(string MCID)
        {
            DataSet ds = new DataSet();
            clsMCWB mc = new clsMCWB();

            ds = mc.GetMCRequestFillData(MCID);
            return(ds);
        }
예제 #2
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");
        }
예제 #3
0
        public void BindMCMEmberGrid()
        {
            clsMCWB       MCObj = new clsMCWB();
            StringBuilder sb    = new StringBuilder();
            DataSet       ds    = MCObj.LoadMCGrid(Convert.ToInt32(hdnedMCID.Value));

            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                sb.AppendLine("<tr>");
                sb.AppendLine("<td style='width:350px;'>" + ds.Tables[0].Rows[i][1].ToString() + " " + ds.Tables[0].Rows[i][2].ToString() + "</td>");
                sb.AppendLine("<td style='width:452px;'>" + ds.Tables[0].Rows[i][3].ToString() + "</td></tr>");
            }
            PDFMemName.InnerHtml = sb.ToString();
        }
예제 #4
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");
        }
예제 #5
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");
        }